This schema contains comprehensive datasets for tracking Astar fundamental data across multiple metrics categories, including network activity, fees, user engagement, and market data for the multi-chain smart contract platform within the Polkadot ecosystem.

​
Available Tables

Astar data is available in two main tables:
  • ez_metrics: Main aggregated metrics for the Astar Network
  • ez_metrics_by_chain: Chain-specific metrics (currently focused on Astar network)

​
Table Schema

​
Network and Usage Metrics

Table NameColumn NameDescription
ez_metricschain_dauDaily unique users on Astar
ez_metricschain_txnsDaily transactions on Astar
ez_metricsdauSame as chain_dau (legacy naming)
ez_metricstxnsSame as chain_txns (legacy naming)

​
Fee and Revenue Metrics

Table NameColumn NameDescription
ez_metricsfeesThe total USD value generated by Astar from all user-paid fees
ez_metricsfees_nativeThe total native ASTR value generated by Astar from all user-paid fees
ez_metricsfeesSame as fees (legacy naming)
ez_metricsfees_nativeSame as fees_native (legacy naming)

​
Market and Token Metrics

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

​
Chain-Specific Metrics

Table NameColumn NameDescription
ez_metrics_by_chainchainThe blockchain identifier (currently ‘astar’)
ez_metrics_by_chainchain_dauDaily unique users on the specific chain
ez_metrics_by_chainchain_txnsDaily transactions on the specific chain
ez_metrics_by_chainfeesRevenue generated on the specific chain
ez_metrics_by_chainfees_nativeRevenue in native tokens on the specific chain
ez_metrics_by_chainpriceToken price for the specific chain
ez_metrics_by_chainmarket_capMarket cap for the specific chain
ez_metrics_by_chainfdmcFDMC for the specific chain
ez_metrics_by_chaintoken_volumeToken trading volume for the specific chain

​
Sample Queries

​
Basic Network Activity Query

-- Pull fundamental network activity data for Astar
SELECT
    date,
    chain_txns,
    chain_dau,
    fees,
    fees_native,
    price,
    market_cap
FROM
    art_share.astar.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Network Growth and User Engagement

-- Track Astar network growth and user adoption trends
SELECT
    date,
    chain_dau,
    chain_txns,
    fees,
    chain_txns / NULLIF(chain_dau, 0) as txns_per_user,
    fees / NULLIF(chain_dau, 0) as revenue_per_user,
    fees / NULLIF(chain_txns, 0) as avg_fee_per_txn,
    LAG(chain_dau, 7) OVER (ORDER BY date) as dau_7d_ago,
    LAG(chain_txns, 7) OVER (ORDER BY date) as txns_7d_ago,
    (chain_dau - LAG(chain_dau, 7) OVER (ORDER BY date)) / NULLIF(LAG(chain_dau, 7) OVER (ORDER BY date), 0) * 100 as dau_growth_7d,
    (chain_txns - LAG(chain_txns, 7) OVER (ORDER BY date)) / NULLIF(LAG(chain_txns, 7) OVER (ORDER BY date), 0) * 100 as txns_growth_7d
FROM
    art_share.astar.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

​
Fee Structure and Economics

-- Analyze Astar's fee structure and economic model
SELECT
    date,
    fees,
    fees_native,
    chain_txns,
    chain_dau,
    price,
    fees / NULLIF(chain_txns, 0) as avg_fee_per_txn_usd,
    fees_native / NULLIF(chain_txns, 0) as avg_fee_per_txn_astr,
    fees / NULLIF(chain_dau, 0) as revenue_per_user,
    fees_native * price as calculated_revenue_usd
FROM
    art_share.astar.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND fees > 0
ORDER BY
    date ASC

​
Market Performance vs Network Activity

-- Analyze ASTR token market performance vs network metrics
SELECT
    date,
    price,
    market_cap,
    fdmc,
    token_volume,
    chain_dau,
    chain_txns,
    fees,
    token_turnover_circulating,
    market_cap / NULLIF(fees, 0) as mcap_to_revenue_ratio,
    token_volume / NULLIF(market_cap, 0) * 100 as daily_volume_to_mcap_ratio,
    token_turnover_circulating * 100 as daily_token_turnover_percentage,
    fees / NULLIF(chain_dau, 0) as revenue_per_user
FROM
    art_share.astar.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

-- Track Astar network activity trends with moving averages
SELECT
    date,
    chain_dau,
    chain_txns,
    fees,
    -- 7-day moving averages
    AVG(chain_dau) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as avg_dau_7d,
    AVG(chain_txns) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as avg_txns_7d,
    AVG(fees) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as avg_revenue_7d,
    -- 30-day moving averages
    AVG(chain_dau) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) as avg_dau_30d,
    AVG(chain_txns) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) as avg_txns_30d,
    AVG(fees) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) as avg_revenue_30d
FROM
    art_share.astar.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Token Market Analysis

-- Analyze ASTR token market metrics and trading patterns
SELECT
    date,
    price,
    market_cap,
    fdmc,
    token_volume,
    token_turnover_circulating,
    token_turnover_fdv,
    fees,
    -- Token valuation metrics
    market_cap / NULLIF(fdmc, 0) * 100 as circulating_percentage,
    token_volume / NULLIF(market_cap, 0) * 100 as volume_to_mcap_ratio,
    -- Network correlation
    market_cap / NULLIF(fees, 0) as mcap_per_dollar_revenue,
    token_volume / NULLIF(fees, 0) as token_volume_to_revenue_ratio
FROM
    art_share.astar.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND price > 0
ORDER BY
    date ASC

​
Chain-Specific Performance

-- Analyze performance by chain (currently Astar-focused)
SELECT
    date,
    chain,
    chain_dau,
    chain_txns,
    fees,
    fees_native,
    price,
    market_cap,
    chain_txns / NULLIF(chain_dau, 0) as txns_per_user,
    fees / NULLIF(chain_txns, 0) as avg_fee_per_txn
FROM
    art_share.astar.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date DESC, fees DESC

​
Network Efficiency Analysis

-- Analyze Astar network efficiency and utilization
SELECT
    date,
    chain_txns,
    chain_dau,
    fees,
    fees_native,
    price,
    -- Efficiency metrics
    chain_txns / NULLIF(chain_dau, 0) as avg_txns_per_user,
    fees / NULLIF(chain_txns, 0) as revenue_per_txn,
    fees_native / NULLIF(chain_txns, 0) as native_fee_per_txn,
    -- Network utilization trends
    LAG(chain_txns / NULLIF(chain_dau, 0), 7) OVER (ORDER BY date) as txns_per_user_7d_ago,
    (chain_txns / NULLIF(chain_dau, 0)) - LAG(chain_txns / NULLIF(chain_dau, 0), 7) OVER (ORDER BY date) as txns_per_user_change_7d
FROM
    art_share.astar.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND chain_dau > 0
ORDER BY
    date ASC

​
Weekly Performance Summary

-- Weekly aggregated performance summary for Astar
SELECT
    DATE_TRUNC('week', date) as week,
    AVG(chain_dau) as avg_daily_users,
    SUM(chain_txns) as total_weekly_txns,
    SUM(fees) as total_weekly_revenue,
    SUM(fees_native) as total_weekly_revenue_native,
    AVG(price) as avg_token_price,
    SUM(token_volume) as total_token_volume,
    AVG(market_cap) as avg_market_cap,
    SUM(chain_txns) / NULLIF(AVG(chain_dau), 0) as avg_txns_per_user_per_day
FROM
    art_share.astar.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
GROUP BY
    DATE_TRUNC('week', date)
ORDER BY
    week DESC

​
Polkadot Ecosystem Analysis

-- Analyze Astar's performance within the Polkadot ecosystem context
SELECT
    date,
    chain_dau,
    chain_txns,
    fees,
    price,
    market_cap,
    token_volume,
    -- Growth metrics
    (chain_dau - LAG(chain_dau, 30) OVER (ORDER BY date)) / NULLIF(LAG(chain_dau, 30) OVER (ORDER BY date), 0) * 100 as dau_growth_30d,
    (fees - LAG(fees, 30) OVER (ORDER BY date)) / NULLIF(LAG(fees, 30) OVER (ORDER BY date), 0) * 100 as revenue_growth_30d,
    -- Network health indicators
    fees / NULLIF(chain_dau, 0) as revenue_per_user,
    chain_txns / NULLIF(chain_dau, 0) as network_activity_ratio,
    token_volume / NULLIF(market_cap, 0) * 100 as token_liquidity_ratio
FROM
    art_share.astar.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC