Aptos

Aptos Schema Description and Methodology

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 Name	Column Name	Description
ez_metrics	chain_txns	Daily transactions on the Aptos blockchain
ez_metrics	chain_dau	Daily unique users on Aptos
ez_metrics	chain_wau	Weekly unique users on Aptos
ez_metrics	chain_mau	Monthly unique users on Aptos
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

Fee and Revenue Metrics

Table Name	Column Name	Description
ez_metrics	chain_fees	The total transaction fees paid on Aptos in USD
ez_metrics	chain_avg_txn_fee	The average transaction fee on Aptos in USD
ez_metrics	ecosystem_revenue	The total USD value generated from all user-paid fees on Aptos
ez_metrics	ecosystem_revenue_native	The total native APT value from all user-paid fees
ez_metrics	fees	Legacy naming for chain_fees
ez_metrics	fees_native	Transaction fees in native APT tokens
ez_metrics	avg_txn_fee	Legacy naming for chain_avg_txn_fee

Cash Flow Distribution Metrics

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

Volume and DeFi Metrics

Table Name	Column Name	Description
ez_metrics	chain_spot_volume	Total spot DEX volume on Aptos
ez_metrics	tvl	The total value locked in Aptos DeFi protocols
ez_metrics	dex_volumes	Legacy naming for chain_spot_volume

Market and Token Metrics

Table Name	Column Name	Description
ez_metrics	price	The price of APT token in USD
ez_metrics	market_cap	The market cap of APT token in USD
ez_metrics	fdmc	The fully diluted market cap of APT token in USD
ez_metrics	token_volume	The trading volume of APT token in USD
ez_metrics	token_turnover_circulating	The turnover of APT based on circulating supply
ez_metrics	token_turnover_fdv	The turnover of APT based on fully diluted valuation

Developer Activity Metrics

Table Name	Column Name	Description
ez_metrics	weekly_commits_core_ecosystem	The number of commits to the Aptos core ecosystem
ez_metrics	weekly_commits_sub_ecosystem	The number of commits to the Aptos sub-ecosystem
ez_metrics	weekly_developers_core_ecosystem	The number of developers who have made commits to the Aptos core ecosystem
ez_metrics	weekly_developers_sub_ecosystem	The 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,
    ecosystem_revenue,
    burned_cash_flow,
    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_cash_flow,
    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