This schema contains comprehensive on-chain datasets for tracking Sui fundamental data across multiple metrics categories, including network activity, fees, staking, transfers, stablecoins, and developer metrics.

​
Available Tables

Sui data is available in several tables:
  • ez_metrics: Main aggregated metrics for the Sui network
  • ez_metrics_by_category_v2: Basic metrics (DAU, gas fees, transactions) broken down by transaction category
  • ez_metrics_by_application_v2: Basic metrics (DAU, gas fees, transactions) broken down by application
  • ez_metrics_by_subcategory: Basic metrics (DAU, gas fees, transactions) broken down by subcategory
  • ez_metrics_by_contract_v2: Basic metrics (DAU, gas fees, transactions) broken down by contract
  • ez_stablecoin_metrics_by_address_with_labels: Stablecoin metrics by address with labels
Note: The by_category, by_application, by_subcategory, and by_contract tables contain the same basic metrics (daily active users, gas fees, transaction counts) but broken down by different groupings based on transaction data.

​
Table Schema

​
Network and Usage Metrics

Table NameColumn NameDescription
ez_metricschain_txnsDaily transactions on the Sui network
ez_metricschain_dauDaily unique users on Sui
ez_metricschain_wauWeekly unique users on Sui
ez_metricschain_mauMonthly unique users on Sui
ez_metricschain_avg_txn_feeThe average transaction fee on Sui
ez_metricsreturning_usersThe number of returning users on Sui
ez_metricsnew_usersThe number of new users on Sui
ez_metricstxnsLegacy naming for chain_txns
ez_metricsdauLegacy naming for chain_dau
ez_metricswauLegacy naming for chain_wau
ez_metricsmauLegacy naming for chain_mau
ez_metricsavg_txn_feeLegacy naming for chain_avg_txn_fee

​
Fee and Revenue Metrics

Table NameColumn NameDescription
ez_metricschain_feesThe total transaction fees paid on the Sui network
ez_metricsfeesThe total USD value generated from all user-paid fees
ez_metricsfees_nativeThe total native SUI value from all user-paid fees
ez_metricsfeesLegacy naming for chain_fees
ez_metricsfees_nativeTransaction fees in native SUI (legacy naming)

​
Cash Flow Distribution Metrics

Table NameColumn NameDescription
ez_metricsburned_fee_allocationUSD value of SUI burned through transaction fees
ez_metricsburned_fee_allocation_nativeAmount of native SUI burned through transaction fees
ez_metricsrevenueLegacy naming for burned_fee_allocation
ez_metricsrevenue_nativeLegacy naming for burned_fee_allocation_native

​
Transfer and Volume Metrics

Table NameColumn NameDescription
ez_metricschain_spot_volumeTotal spot DEX volume on Sui
ez_metricsdex_volumesLegacy naming for chain_spot_volume

​
Market and Supply Metrics

Table NameColumn NameDescription
ez_metricspriceThe price of SUI in USD
ez_metricsmarket_capThe market cap of SUI in USD
ez_metricsfdmcThe fully diluted market cap of SUI in USD
ez_metricstvlThe total value locked in Sui protocols
ez_metricsgross_emissions_nativeThe amount of block rewards in native SUI
ez_metricsmints_nativeLegacy naming for gross_emissions_native
ez_metricscirculating_supply_nativeThe circulating supply of SUI in native tokens
ez_metricsnet_supply_change_nativeThe net change in the circulating supply of SUI
ez_metricspremine_unlocks_nativeThe amount of native tokens unlocked from premine

​
Stablecoin Metrics

Table NameColumn NameDescription
ez_metricsstablecoin_total_supplyThe total supply of stablecoins on Sui
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_metricsp2p_stablecoin_tokenholder_countThe number of unique P2P stablecoin tokenholders (wallet-to-wallet)
ez_metricsp2p_stablecoin_txnsThe number of P2P stablecoin transactions (wallet-to-wallet)
ez_metricsp2p_stablecoin_dauDaily active users of P2P stablecoin transfers (wallet-to-wallet)
ez_metricsp2p_stablecoin_mauMonthly active users of P2P stablecoin transfers (wallet-to-wallet)
ez_metricsp2p_stablecoin_transfer_volumeThe total volume of P2P stablecoin transfers (wallet-to-wallet)
ez_metricsartemis_stablecoin_txnsNumber of stablecoin transactions excluding MEV and intra-CEX transfers
ez_metricsartemis_stablecoin_dauDaily active stablecoin users excluding MEV and intra-CEX transfers
ez_metricsartemis_stablecoin_mauMonthly active stablecoin users excluding MEV and intra-CEX transfers
ez_metricsartemis_stablecoin_transfer_volumeVolume of stablecoin transfers excluding MEV and intra-CEX transfers
Note: “artemisstablecoin**” metrics filter out MEV and intra-exchange transfers to provide a cleaner view of organic stablecoin activity. “p2pstablecoin**” metrics focus specifically on wallet-to-wallet stablecoin transfers, excluding wallet-to-contract interactions.

​
Developer Metrics

Table NameColumn NameDescription
ez_metricsweekly_commits_core_ecosystemThe number of commits to the Sui core ecosystem
ez_metricsweekly_commits_sub_ecosystemThe number of commits to the Sui sub-ecosystem
ez_metricsweekly_developers_core_ecosystemThe number of developers who have made commits to the Sui core ecosystem
ez_metricsweekly_developers_sub_ecosystemThe number of developers who have made commits to the Sui sub-ecosystem

​
Sample Queries

​
Basic Network Activity Query

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

​
Fee and Revenue Analysis

-- Analyze Sui fee and revenue metrics
SELECT
    date,
    chain_fees,
    fees,
    fees_native,
    burned_fee_allocation,
    burned_fee_allocation_native
FROM
    art_share.sui.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Supply Analysis

-- Track Sui supply changes
SELECT
    date,
    circulating_supply_native,
    gross_emissions_native,
    premine_unlocks_native,
    net_supply_change_native,
    price
FROM
    art_share.sui.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

​
Stablecoin Activity

-- Track stablecoin usage on Sui
SELECT
    date,
    stablecoin_total_supply,
    stablecoin_transfer_volume,
    stablecoin_dau,
    stablecoin_txns,
    p2p_stablecoin_transfer_volume,
    artemis_stablecoin_transfer_volume
FROM
    art_share.sui.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

​
User Segmentation Analysis

-- Analyze different user types on Sui
SELECT
    date,
    chain_dau,
    returning_users,
    new_users
FROM
    art_share.sui.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

​
Application-specific Analysis

-- Analyze metrics for specific applications on Sui
SELECT
    date,
    app,
    friendly_name,
    category,
    txns,
    dau,
    returning_users,
    new_users
FROM
    art_share.sui.ez_metrics_by_application_v2
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND app IN ('cetus', 'turbos', 'suiswap')
ORDER BY
    app, date ASC

​
Developer Activity

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

​
TVL and Market Metrics Analysis

-- Analyze Sui TVL and market metrics
SELECT
    date,
    tvl,
    price,
    market_cap,
    fdmc,
    chain_spot_volume
FROM
    art_share.sui.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC