Sui

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	fees	The total USD value generated from all user-paid fees
ez_metrics	fees_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_fee_allocation	USD value of SUI burned through transaction fees
ez_metrics	burned_fee_allocation_native	Amount of native SUI burned through transaction fees
ez_metrics	revenue	Legacy naming for burned_fee_allocation
ez_metrics	revenue_native	Legacy naming for burned_fee_allocation_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

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

👋 Welcome

📜 Data Reference

🌎 Prediction Markets

🔢 Artemis Sheets

🖥️ API

❄️ Snowflake Share

🖼️ Artemis Terminal

🔍 Research

📞 Contact Us

Available Tables

Table Schema

Network and Usage Metrics

Fee and Revenue Metrics

Cash Flow Distribution Metrics

Transfer and Volume Metrics

Market and Supply Metrics

Stablecoin Metrics

Developer Metrics

Sample Queries

Basic Network Activity Query

Fee and Revenue Analysis

Supply Analysis

Stablecoin Activity

User Segmentation Analysis

Application-specific Analysis

Developer Activity

TVL and Market Metrics Analysis

​Available Tables

​Table Schema

​Network and Usage Metrics

​Fee and Revenue Metrics

​Cash Flow Distribution Metrics

​Transfer and Volume Metrics

​Market and Supply Metrics

​Stablecoin Metrics

​Developer Metrics

​Sample Queries

​Basic Network Activity Query

​Fee and Revenue Analysis

​Supply Analysis

​Stablecoin Activity

​User Segmentation Analysis

​Application-specific Analysis

​Developer Activity

​TVL and Market Metrics Analysis

Available Tables

Table Schema

Network and Usage Metrics

Fee and Revenue Metrics

Cash Flow Distribution Metrics

Transfer and Volume Metrics

Market and Supply Metrics

Stablecoin Metrics

Developer Metrics

Sample Queries

Basic Network Activity Query

Fee and Revenue Analysis

Supply Analysis

Stablecoin Activity

User Segmentation Analysis

Application-specific Analysis

Developer Activity

TVL and Market Metrics Analysis