Sui

Sui Schema Description and Methodology

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 Name	Column Name	Description
ez_metrics	chain_txns	Daily transactions on the Sui network
ez_metrics	chain_dau	Daily unique users on Sui
ez_metrics	chain_wau	Weekly unique users on Sui
ez_metrics	chain_mau	Monthly unique users on Sui
ez_metrics	chain_avg_txn_fee	The average transaction fee on Sui
ez_metrics	returning_users	The number of returning users on Sui
ez_metrics	new_users	The number of new users on Sui
ez_metrics	txns	Legacy naming for chain_txns
ez_metrics	dau	Legacy naming for chain_dau
ez_metrics	wau	Legacy naming for chain_wau
ez_metrics	mau	Legacy naming for chain_mau
ez_metrics	avg_txn_fee	Legacy naming for chain_avg_txn_fee

Fee and Revenue Metrics

Table Name	Column Name	Description
ez_metrics	chain_fees	The total transaction fees paid on the Sui network
ez_metrics	ecosystem_revenue	The total USD value generated from all user-paid fees
ez_metrics	ecosystem_revenue_native	The total native SUI value from all user-paid fees
ez_metrics	fees	Legacy naming for chain_fees
ez_metrics	fees_native	Transaction fees in native SUI (legacy naming)

Cash Flow Distribution Metrics

Table Name	Column Name	Description
ez_metrics	burned_cash_flow	USD value of SUI burned through transaction fees
ez_metrics	burned_cash_flow_native	Amount of native SUI burned through transaction fees
ez_metrics	revenue	Legacy naming for burned_cash_flow
ez_metrics	revenue_native	Legacy naming for burned_cash_flow_native

Transfer and Volume Metrics

Table Name	Column Name	Description
ez_metrics	chain_spot_volume	Total spot DEX volume on Sui
ez_metrics	dex_volumes	Legacy naming for chain_spot_volume

Market and Supply Metrics

Table Name	Column Name	Description
ez_metrics	price	The price of SUI in USD
ez_metrics	market_cap	The market cap of SUI in USD
ez_metrics	fdmc	The fully diluted market cap of SUI in USD
ez_metrics	tvl	The total value locked in Sui protocols
ez_metrics	gross_emissions_native	The amount of block rewards in native SUI
ez_metrics	mints_native	Legacy naming for gross_emissions_native
ez_metrics	circulating_supply_native	The circulating supply of SUI in native tokens
ez_metrics	net_supply_change_native	The net change in the circulating supply of SUI
ez_metrics	premine_unlocks_native	The amount of native tokens unlocked from premine

Stablecoin Metrics

Table Name	Column Name	Description
ez_metrics	stablecoin_total_supply	The total supply of stablecoins on Sui
ez_metrics	stablecoin_txns	The number of stablecoin transactions
ez_metrics	stablecoin_dau	Daily active users of stablecoins
ez_metrics	stablecoin_mau	Monthly active users of stablecoins
ez_metrics	stablecoin_transfer_volume	The total volume of stablecoin transfers
ez_metrics	stablecoin_tokenholder_count	The number of unique stablecoin tokenholders
ez_metrics	p2p_stablecoin_tokenholder_count	The number of unique P2P stablecoin tokenholders (wallet-to-wallet)
ez_metrics	p2p_stablecoin_txns	The number of P2P stablecoin transactions (wallet-to-wallet)
ez_metrics	p2p_stablecoin_dau	Daily active users of P2P stablecoin transfers (wallet-to-wallet)
ez_metrics	p2p_stablecoin_mau	Monthly active users of P2P stablecoin transfers (wallet-to-wallet)
ez_metrics	p2p_stablecoin_transfer_volume	The total volume of P2P stablecoin transfers (wallet-to-wallet)
ez_metrics	artemis_stablecoin_txns	Number of stablecoin transactions excluding MEV and intra-CEX transfers
ez_metrics	artemis_stablecoin_dau	Daily active stablecoin users excluding MEV and intra-CEX transfers
ez_metrics	artemis_stablecoin_mau	Monthly active stablecoin users excluding MEV and intra-CEX transfers
ez_metrics	artemis_stablecoin_transfer_volume	Volume 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 Name	Column Name	Description
ez_metrics	weekly_commits_core_ecosystem	The number of commits to the Sui core ecosystem
ez_metrics	weekly_commits_sub_ecosystem	The number of commits to the Sui sub-ecosystem
ez_metrics	weekly_developers_core_ecosystem	The number of developers who have made commits to the Sui core ecosystem
ez_metrics	weekly_developers_sub_ecosystem	The 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,
    ecosystem_revenue,
    ecosystem_revenue_native,
    burned_cash_flow,
    burned_cash_flow_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