This schema contains comprehensive on-chain datasets for tracking Tron fundamental data across multiple metrics categories, including network activity, fees, stablecoin usage, developer engagement, and market data.

​
Available Tables

Tron data is available in several tables:
  • ez_metrics: Main aggregated metrics for the Tron network
  • ez_metrics_by_category_v2: Metrics broken down by transaction category
  • ez_metrics_by_application_v2: Metrics broken down by application
  • ez_metrics_by_subcategory: Metrics broken down by subcategory
  • ez_metrics_by_contract_v2: Metrics broken down by contract

​
Table Schema

​
Network and Usage Metrics

Table NameColumn NameDescription
ez_metricschain_txnsDaily transactions on the Tron network
ez_metricschain_dauDaily unique users on Tron
ez_metricschain_wauWeekly unique users on Tron
ez_metricschain_mauMonthly unique users on Tron
ez_metricschain_avg_txn_feeThe average transaction fee on Tron
ez_metricschain_median_txn_feeThe median transaction fee on Tron
ez_metricsreturning_usersThe number of returning users on Tron
ez_metricsnew_usersThe number of new users on Tron
ez_metricsdau_over_100_balanceThe number of users with balances over $100

​
User Classification Metrics

Table NameColumn NameDescription
ez_metricssybil_usersThe number of sybil users (suspected bots) on Tron
ez_metricsnon_sybil_usersThe number of non-sybil users on Tron
ez_metricslow_sleep_usersUsers with continuous activity (possible bots)
ez_metricshigh_sleep_usersUsers with normal activity patterns (likely humans)

​
Fee and Revenue Metrics

Table NameColumn NameDescription
ez_metricschain_feesThe total transaction fees paid on Tron (in USD)
ez_metricsfeesTotal revenue generated from all user-paid fees
ez_metricsfees_nativeThe total native TRX value from all user-paid fees
ez_metricsburned_fee_allocationThe USD value of tokens burned (equivalent to fees)
ez_metricsburned_fee_allocation_nativeThe amount of native tokens burned (equivalent to fees)
ez_metricsfeesSame as chain_fees (legacy naming)
ez_metricsfees_nativeTransaction fees in native TRX tokens
ez_metricsavg_txn_feeSame as chain_avg_txn_fee (legacy naming)
ez_metricsmedian_txn_feeSame as chain_median_txn_fee (legacy naming)
ez_metricsrevenueSame as fees (legacy naming)
ez_metricsrevenue_nativeSame as fees_native (legacy naming)

​
Volume and Trading Metrics

Table NameColumn NameDescription
ez_metricschain_spot_volumeTotal spot DEX volume on Tron
ez_metricssettlement_volumeTotal volume of DEX + P2P transfers
ez_metricsdex_volumesSame as chain_spot_volume (legacy naming)

​
P2P Transfer Metrics

Table NameColumn NameDescription
ez_metricsp2p_native_transfer_volumeVolume of TRX transfers directly between wallets
ez_metricsp2p_token_transfer_volumeVolume of TRC-20 token transfers between wallets
ez_metricsp2p_transfer_volumeTotal volume of all P2P transfers

​
Stablecoin Metrics

Table NameColumn NameDescription
ez_metricsstablecoin_total_supplyThe total supply of stablecoins on Tron
ez_metricsstablecoin_txnsThe number of stablecoin transactions
ez_metricsstablecoin_dauDaily active users of stablecoins
ez_metricsstablecoin_mauMonthly active users of stablecoins
ez_metricsstablecoin_transfer_volumeThe total volume of stablecoin transfers
ez_metricsstablecoin_tokenholder_countThe number of unique stablecoin tokenholders
ez_metricsartemis_stablecoin_txnsStablecoin transactions excluding MEV transactions
ez_metricsartemis_stablecoin_dauDaily users excluding MEV addresses
ez_metricsartemis_stablecoin_mauMonthly users excluding MEV addresses
ez_metricsartemis_stablecoin_transfer_volumeStablecoin volume excluding MEV transactions
ez_metricsp2p_stablecoin_txnsP2P stablecoin transactions (wallet-to-wallet)
ez_metricsp2p_stablecoin_dauDaily users of P2P stablecoin transfers
ez_metricsp2p_stablecoin_mauMonthly users of P2P stablecoin transfers
ez_metricsp2p_stablecoin_transfer_volumeVolume of P2P stablecoin transfers
ez_metricsp2p_stablecoin_tokenholder_countUnique holders conducting P2P transfers
ez_metricsnon_p2p_stablecoin_transfer_volumeVolume of non-P2P stablecoin transfers (contract interactions)

​
Developer Activity Metrics

Table NameColumn NameDescription
ez_metricsweekly_commits_core_ecosystemCommits to the Tron core ecosystem repositories
ez_metricsweekly_commits_sub_ecosystemCommits to Tron sub-ecosystem repositories
ez_metricsweekly_developers_core_ecosystemDevelopers contributing to core repositories
ez_metricsweekly_developers_sub_ecosystemDevelopers contributing to sub-ecosystem repositories

​
Market and Token Metrics

Table NameColumn NameDescription
ez_metricspriceThe price of TRX token in USD
ez_metricsmarket_capThe market cap of TRX token in USD
ez_metricsfdmcThe fully diluted market cap of TRX token in USD
ez_metricstvlThe total value locked in Tron protocols

​
Sample Queries

​
Basic Network Activity Query

-- 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

​
Fee and Revenue Analysis

-- 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

​
User Analysis

-- 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

​
Volume Analysis

-- Analyze different volume sources on Tron
SELECT
    date,
    settlement_volume,
    chain_spot_volume,
    p2p_transfer_volume,
    p2p_native_transfer_volume,
    p2p_token_transfer_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

​
Stablecoin Analysis

-- Track stablecoin usage on Tron
SELECT
    date,
    stablecoin_total_supply,
    stablecoin_dau,
    artemis_stablecoin_dau,
    p2p_stablecoin_dau,
    stablecoin_transfer_volume,
    p2p_stablecoin_transfer_volume,
    non_p2p_stablecoin_transfer_volume,
    p2p_stablecoin_transfer_volume / NULLIF(stablecoin_transfer_volume, 0) * 100 as p2p_percentage
FROM
    art_share.tron.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

​
Developer Activity Monitoring

-- 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

​
Market Metrics Analysis

-- 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

​
Application-specific Analysis

-- 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

​
P2P Transfer Analysis

-- Analyze peer-to-peer transfer activity on Tron
SELECT
    date,
    p2p_transfer_volume,
    p2p_native_transfer_volume,
    p2p_token_transfer_volume,
    p2p_stablecoin_transfer_volume,
    p2p_stablecoin_dau,
    p2p_stablecoin_txns,
    p2p_stablecoin_transfer_volume / NULLIF(p2p_transfer_volume, 0) * 100 as stablecoin_p2p_percentage
FROM
    art_share.tron.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC