Acala

Acala Schema Description and Methodology

This schema contains comprehensive datasets for tracking Acala fundamental data across multiple metrics categories, including network activity, fees, token burning mechanics, and market data for the DeFi hub built on Polkadot.

Available Tables

Acala data is available in the main metrics table:

• ez_metrics: Aggregated metrics for the Acala network including DeFi activity and token economics

Table Schema

Network and Usage Metrics

Table Name	Column Name	Description
ez_metrics	chain_dau	Daily unique users on Acala
ez_metrics	chain_wau	Weekly unique users on Acala
ez_metrics	chain_mau	Monthly unique users on Acala
ez_metrics	chain_txns	Daily transactions on Acala
ez_metrics	chain_avg_txn_fee	The average transaction fee on Acala
ez_metrics	dau	Same as chain_dau (legacy naming)
ez_metrics	wau	Same as chain_wau (legacy naming)
ez_metrics	mau	Same as chain_mau (legacy naming)
ez_metrics	txns	Same as chain_txns (legacy naming)
ez_metrics	avg_txn_fee	Same as chain_avg_txn_fee (legacy naming)

Fee and Revenue Metrics

Table Name	Column Name	Description
ez_metrics	chain_fees	The total transaction fees paid on Acala
ez_metrics	ecosystem_revenue	The total USD value generated by Acala from all user-paid fees
ez_metrics	ecosystem_revenue_native	The total native ACA value generated by Acala from all user-paid fees
ez_metrics	fees	Same as chain_fees (legacy naming)
ez_metrics	fees_native	Transaction fees collected in native ACA tokens
ez_metrics	revenue	Net revenue after fee distribution (legacy naming)

Token Burning Mechanics

Table Name	Column Name	Description
ez_metrics	burned_cash_flow	The USD value of ACA tokens burned (20% of transaction fees)
ez_metrics	burned_cash_flow_native	The amount of native ACA tokens burned (20% of transaction fees)

Market and Token Metrics

Table Name	Column Name	Description
ez_metrics	price	The price of ACA token in USD
ez_metrics	market_cap	The market cap of ACA token in USD
ez_metrics	fdmc	The fully diluted market cap of ACA token in USD

Sample Queries

Basic Network Activity Query

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

Token Burning Analysis

-- Analyze Acala's token burning mechanism
SELECT
    date,
    ecosystem_revenue,
    burned_cash_flow,
    burned_cash_flow_native,
    chain_txns,
    burned_cash_flow / NULLIF(ecosystem_revenue, 0) * 100 as burn_percentage,
    burned_cash_flow / NULLIF(chain_txns, 0) as burned_per_txn,
    burned_cash_flow_native / NULLIF(chain_txns, 0) as burned_aca_per_txn
FROM
    art_share.acala.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
    AND ecosystem_revenue > 0
ORDER BY
    date ASC

User Growth and Engagement

-- Track Acala user growth and engagement patterns
SELECT
    date,
    chain_dau,
    chain_wau,
    chain_mau,
    chain_txns,
    chain_txns / NULLIF(chain_dau, 0) as txns_per_user,
    chain_dau / NULLIF(chain_wau, 0) * 100 as daily_weekly_ratio,
    chain_wau / NULLIF(chain_mau, 0) * 100 as weekly_monthly_ratio,
    LAG(chain_dau, 7) OVER (ORDER BY date) as dau_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
FROM
    art_share.acala.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

Fee Structure and Economics

-- Analyze Acala's fee structure and economic model
SELECT
    date,
    ecosystem_revenue,
    burned_cash_flow,
    ecosystem_revenue - burned_cash_flow as retained_revenue,
    chain_avg_txn_fee,
    chain_txns,
    price,
    burned_cash_flow / NULLIF(ecosystem_revenue, 0) * 100 as burn_rate,
    (ecosystem_revenue - burned_cash_flow) / NULLIF(ecosystem_revenue, 0) * 100 as retention_rate,
    ecosystem_revenue / NULLIF(chain_dau, 0) as revenue_per_user
FROM
    art_share.acala.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND ecosystem_revenue > 0
ORDER BY
    date ASC

Market Performance Analysis

-- Analyze ACA token market performance vs network activity
SELECT
    date,
    price,
    market_cap,
    fdmc,
    chain_dau,
    chain_txns,
    ecosystem_revenue,
    burned_cash_flow_native,
    market_cap / NULLIF(ecosystem_revenue, 0) as mcap_to_revenue_ratio,
    burned_cash_flow_native * price as burned_usd_value,
    ecosystem_revenue / NULLIF(chain_dau, 0) as revenue_per_user
FROM
    art_share.acala.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

Network Growth Trends

-- Track Acala network growth and adoption trends
SELECT
    date,
    chain_dau,
    chain_txns,
    ecosystem_revenue,
    burned_cash_flow,
    -- 7-day growth rates
    LAG(chain_dau, 7) OVER (ORDER BY date) as dau_7d_ago,
    LAG(chain_txns, 7) OVER (ORDER BY date) as txns_7d_ago,
    LAG(ecosystem_revenue, 7) OVER (ORDER BY date) as revenue_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,
    (ecosystem_revenue - LAG(ecosystem_revenue, 7) OVER (ORDER BY date)) / NULLIF(LAG(ecosystem_revenue, 7) OVER (ORDER BY date), 0) * 100 as revenue_growth_7d
FROM
    art_share.acala.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC

Burn Impact Analysis

-- Analyze the impact of token burning on supply and market
SELECT
    date,
    burned_cash_flow_native,
    burned_cash_flow,
    price,
    market_cap,
    chain_txns,
    -- Cumulative burns
    SUM(burned_cash_flow_native) OVER (ORDER BY date) as cumulative_burned_aca,
    SUM(burned_cash_flow) OVER (ORDER BY date) as cumulative_burned_usd,
    -- Moving averages
    AVG(burned_cash_flow_native) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as avg_daily_burn_7d,
    AVG(burned_cash_flow) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) as avg_daily_burn_30d
FROM
    art_share.acala.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

Daily Performance Summary

-- Comprehensive daily performance summary for Acala
SELECT
    date,
    chain_dau,
    chain_txns,
    ecosystem_revenue,
    burned_cash_flow,
    chain_avg_txn_fee,
    price,
    market_cap,
    -- Efficiency metrics
    chain_txns / NULLIF(chain_dau, 0) as txns_per_user,
    ecosystem_revenue / NULLIF(chain_txns, 0) as revenue_per_txn,
    burned_cash_flow / NULLIF(ecosystem_revenue, 0) * 100 as burn_percentage,
    ecosystem_revenue / NULLIF(chain_dau, 0) as revenue_per_user
FROM
    art_share.acala.ez_metrics
WHERE
    date >= DATEADD(week, -4, CURRENT_DATE())
ORDER BY
    date DESC

Fee Distribution Analysis

-- Analyze how fees are distributed between burning and retention
SELECT
    date,
    ecosystem_revenue,
    burned_cash_flow,
    ecosystem_revenue - burned_cash_flow as retained_fees,
    chain_txns,
    burned_cash_flow / NULLIF(ecosystem_revenue, 0) * 100 as burn_rate,
    (ecosystem_revenue - burned_cash_flow) / NULLIF(ecosystem_revenue, 0) * 100 as retention_rate,
    burned_cash_flow / NULLIF(chain_txns, 0) as burn_per_txn,
    (ecosystem_revenue - burned_cash_flow) / NULLIF(chain_txns, 0) as retained_per_txn
FROM
    art_share.acala.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
    AND ecosystem_revenue > 0
ORDER BY
    date DESC

Monthly Aggregated Metrics

-- Monthly summary of Acala network performance
WITH monthly_summary AS (
    SELECT
        DATE_TRUNC('month', date) as month,
        AVG(chain_dau) as avg_dau,
        SUM(chain_txns) as total_txns,
        SUM(ecosystem_revenue) as total_revenue,
        SUM(burned_cash_flow) as total_burned,
        SUM(burned_cash_flow_native) as total_burned_aca,
        AVG(price) as avg_price,
        AVG(market_cap) as avg_market_cap
    FROM
        art_share.acala.ez_metrics
    WHERE
        date >= DATEADD(month, -6, CURRENT_DATE())
    GROUP BY
        DATE_TRUNC('month', date)
)
SELECT
    month,
    avg_dau,
    total_txns,
    total_revenue,
    total_burned,
    total_burned_aca,
    avg_price,
    avg_market_cap,
    total_burned / NULLIF(total_revenue, 0) * 100 as monthly_burn_rate,
    total_revenue / NULLIF(total_txns, 0) as avg_revenue_per_txn,
    total_txns / NULLIF(avg_dau, 0) as avg_txns_per_user_per_day
FROM
    monthly_summary
ORDER BY
    month DESC