This schema contains comprehensive on-chain datasets for tracking Aptos fundamental data across multiple metrics categories, including network activity, fees, trading volumes, developer activity, and market data.

​
Available Tables

Aptos data is available in one main table:
  • ez_metrics: Main aggregated metrics for the Aptos blockchain

​
Table Schema

​
Network and Usage Metrics

Table NameColumn NameDescription
ez_metricschain_txnsDaily transactions on the Aptos blockchain
ez_metricschain_dauDaily unique users on Aptos
ez_metricschain_wauWeekly unique users on Aptos
ez_metricschain_mauMonthly unique users on Aptos
ez_metricstxnsLegacy naming for chain_txns
ez_metricsdauLegacy naming for chain_dau
ez_metricswauLegacy naming for chain_wau
ez_metricsmauLegacy naming for chain_mau

​
Fee and Revenue Metrics

Table NameColumn NameDescription
ez_metricschain_feesThe total transaction fees paid on Aptos in USD
ez_metricschain_avg_txn_feeThe average transaction fee on Aptos in USD
ez_metricsfeesThe total USD value generated from all user-paid fees on Aptos
ez_metricsfees_nativeThe total native APT value from all user-paid fees
ez_metricsfeesLegacy naming for chain_fees
ez_metricsfees_nativeTransaction fees in native APT tokens
ez_metricsavg_txn_feeLegacy naming for chain_avg_txn_fee

​
Cash Flow Distribution Metrics

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

​
Volume and DeFi Metrics

Table NameColumn NameDescription
ez_metricschain_spot_volumeTotal spot DEX volume on Aptos
ez_metricstvlThe total value locked in Aptos DeFi protocols
ez_metricsdex_volumesLegacy naming for chain_spot_volume

​
Market and Token Metrics

Table NameColumn NameDescription
ez_metricspriceThe price of APT token in USD
ez_metricsmarket_capThe market cap of APT token in USD
ez_metricsfdmcThe fully diluted market cap of APT token in USD
ez_metricstoken_volumeThe trading volume of APT token in USD
ez_metricstoken_turnover_circulatingThe turnover of APT based on circulating supply
ez_metricstoken_turnover_fdvThe turnover of APT based on fully diluted valuation

​
Developer Activity Metrics

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

​
Sample Queries

​
Basic Network Activity Query

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

​
User Growth Analysis

-- Analyze user growth and retention on Aptos
SELECT
    date,
    chain_dau,
    chain_wau,
    chain_mau,
    chain_dau / NULLIF(chain_wau, 0) * 100 as daily_to_weekly_ratio,
    chain_wau / NULLIF(chain_mau, 0) * 100 as weekly_to_monthly_ratio,
    LAG(chain_dau, 7) OVER (ORDER BY date) as dau_week_ago,
    chain_dau / NULLIF(dau_week_ago, 0) - 1 as weekly_dau_growth
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Fee and Revenue Analysis

-- Analyze Aptos fees and revenue
SELECT
    date,
    chain_fees,
    chain_avg_txn_fee,
    fees,
    burned_fee_allocation,
    chain_txns,
    chain_dau,
    chain_fees / chain_txns as avg_fee_per_txn,
    chain_fees / chain_dau as avg_fee_per_user
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
DeFi Activity Analysis

-- Track DeFi activity on Aptos
SELECT
    date,
    chain_spot_volume,
    tvl,
    chain_spot_volume / NULLIF(tvl, 0) as dex_volume_to_tvl_ratio,
    LAG(chain_spot_volume, 7) OVER (ORDER BY date) as volume_week_ago,
    chain_spot_volume / NULLIF(volume_week_ago, 0) - 1 as weekly_volume_growth
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

​
Token Performance Analysis

-- Analyze APT token metrics
SELECT
    date,
    price,
    market_cap,
    fdmc,
    token_volume,
    token_turnover_circulating,
    token_volume / NULLIF(chain_fees, 0) as token_volume_to_fees_ratio
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Developer Activity Monitoring

-- Track developer activity on Aptos
SELECT
    date,
    weekly_developers_core_ecosystem,
    weekly_developers_sub_ecosystem,
    weekly_commits_core_ecosystem,
    weekly_commits_sub_ecosystem,
    weekly_commits_core_ecosystem / NULLIF(weekly_developers_core_ecosystem, 0) as commits_per_core_dev,
    weekly_commits_sub_ecosystem / NULLIF(weekly_developers_sub_ecosystem, 0) as commits_per_sub_dev
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

​
Network Economics Analysis

-- Analyze Aptos network economics
SELECT
    date,
    chain_txns,
    chain_fees,
    burned_fee_allocation,
    price,
    market_cap,
    market_cap / NULLIF(chain_fees * 365, 0) as price_to_annual_fees_ratio,
    chain_fees / chain_txns as revenue_per_transaction
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Monthly Performance Dashboard

-- Create a monthly performance dashboard for Aptos
SELECT
    DATE_TRUNC('month', date) as month,
    AVG(chain_dau) as avg_daily_users,
    SUM(chain_txns) as total_transactions,
    SUM(chain_fees) as total_fees,
    AVG(chain_avg_txn_fee) as avg_transaction_fee,
    SUM(chain_spot_volume) as total_dex_volume,
    AVG(tvl) as avg_tvl,
    AVG(price) as avg_token_price,
    LAST_VALUE(market_cap) OVER (PARTITION BY DATE_TRUNC('month', date) ORDER BY date) as end_of_month_market_cap,
    LAST_VALUE(weekly_developers_core_ecosystem + weekly_developers_sub_ecosystem) OVER (PARTITION BY DATE_TRUNC('month', date) ORDER BY date) as active_developers
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(year, -1, CURRENT_DATE())
GROUP BY
    DATE_TRUNC('month', date)
ORDER BY
    month ASC