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