Tron

-- Pull fundamental network activity data for Tron
SELECT
    date,
    chain_txns,
    chain_dau,
    chain_fees,
    chain_avg_txn_fee,
    chain_median_txn_fee,
    price
FROM
    art_share.tron.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Analyze Tron fee structure and revenue
SELECT
    date,
    fees,
    fees_native,
    burned_fee_allocation,
    burned_fee_allocation_native,
    chain_avg_txn_fee,
    chain_txns
FROM
    art_share.tron.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Analyze different user types on Tron
SELECT
    date,
    chain_dau,
    new_users,
    returning_users,
    sybil_users,
    non_sybil_users,
    low_sleep_users,
    high_sleep_users,
    dau_over_100_balance,
    non_sybil_users / NULLIF(chain_dau, 0) * 100 as non_sybil_percentage
FROM
    art_share.tron.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

-- Analyze different volume sources on Tron
SELECT
    date,
    settlement_volume,
    chain_spot_volume,
    stablecoin_transfer_volume,
    chain_spot_volume / NULLIF(settlement_volume, 0) * 100 as dex_percentage
FROM
    art_share.tron.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC

-- Track stablecoin usage on Tron
SELECT
    date,
    stablecoin_total_supply,
    stablecoin_dau,
    stablecoin_transfer_volume
FROM
    art_share.tron.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

-- Track developer activity on Tron
SELECT
    date,
    weekly_commits_core_ecosystem,
    weekly_commits_sub_ecosystem,
    weekly_developers_core_ecosystem,
    weekly_developers_sub_ecosystem
FROM
    art_share.tron.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

-- Track Tron market and ecosystem metrics
SELECT
    date,
    price,
    market_cap,
    fdmc,
    tvl,
    chain_spot_volume,
    stablecoin_total_supply,
    fees
FROM
    art_share.tron.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Analyze metrics for specific applications on Tron
SELECT
    date,
    app,
    friendly_name,
    category,
    txns,
    dau,
    returning_users,
    new_users
FROM
    art_share.tron.ez_metrics_by_application_v2
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND app IN ('justswap', 'sunswap', 'tronscan')  -- Example popular Tron dApps
ORDER BY
    app, date ASC