Akash

Akash Schema Description and Methodology

This schema contains comprehensive datasets for tracking Akash fundamental data across multiple metrics categories, including network activity, compute services, revenue streams, token economics, and market data.

Available Tables

Akash data is available in two main tables:

• ez_metrics: Main aggregated metrics for the entire Akash protocol
• ez_metrics_by_chain: Metrics specific to the Akash chain (mostly a duplicate of ez_metrics)

Table Schema

Network Activity Metrics

Table Name	Column Name	Description
ez_metrics	active_leases	The number of active compute leases on Akash Network
ez_metrics	active_providers	The number of active compute providers on the network
ez_metrics	new_leases	The number of new compute leases created

Revenue and Fee Metrics

Table Name	Column Name	Description
ez_metrics	compute_fees	Fees paid for compute resources in USD
ez_metrics	compute_fees_native	Fees paid for compute resources in AKT tokens
ez_metrics	compute_fees_usdc	Fees paid for compute resources in USDC
ez_metrics	compute_fees_total_usd	Total compute fees across all currencies in USD
ez_metrics	gas_fees	Transaction fees paid to validators in USD
ez_metrics	validator_fees	Same as gas_fees (legacy naming)
ez_metrics	validator_fees_native	Transaction fees paid to validators in AKT tokens
ez_metrics	total_fees	Sum of all fees on the network
ez_metrics	ecosystem_revenue	Total revenue generated (compute_fees + gas_fees)

Revenue Distribution Metrics

Table Name	Column Name	Description
ez_metrics	service_cash_flow	Revenue accrued to compute providers (compute_fees minus treasury portion)
ez_metrics	validator_cash_flow	Revenue allocated to validators (gas_fees)
ez_metrics	treasury_cash_flow	Revenue allocated to Akash treasury
ez_metrics	revenue	Legacy naming for treasury_cash_flow

Token Supply Metrics

Table Name	Column Name	Description
ez_metrics	gross_emissions_native	The amount of new AKT tokens emitted
ez_metrics	premine_unlocks_native	The amount of AKT tokens unlocked from premine
ez_metrics	burns_native	The amount of AKT tokens burned
ez_metrics	total_burned_native	Legacy naming for burns_native
ez_metrics	net_supply_change_native	Net change in circulating supply (emissions + unlocks - burns)
ez_metrics	circulating_supply_native	The circulating supply of AKT in native tokens

Market and Token Metrics

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

Sample Queries

Basic Network Activity Query

-- Pull fundamental network activity data for Akash
SELECT
    date,
    active_providers,
    active_leases,
    new_leases,
    price
FROM
    art_share.akash.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

Revenue Analysis

-- Analyze Akash revenue streams
SELECT
    date,
    compute_fees,
    gas_fees,
    ecosystem_revenue,
    compute_fees / ecosystem_revenue * 100 as compute_fees_percentage,
    gas_fees / ecosystem_revenue * 100 as gas_fees_percentage
FROM
    art_share.akash.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

Revenue Distribution Analysis

-- Analyze how Akash revenue is distributed
SELECT
    date,
    ecosystem_revenue,
    service_cash_flow,
    validator_cash_flow,
    treasury_cash_flow,
    service_cash_flow / ecosystem_revenue * 100 as providers_percentage,
    validator_cash_flow / ecosystem_revenue * 100 as validators_percentage,
    treasury_cash_flow / ecosystem_revenue * 100 as treasury_percentage
FROM
    art_share.akash.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
    AND ecosystem_revenue > 0
ORDER BY
    date ASC

Token Supply Analysis

-- Track AKT token supply changes
SELECT
    date,
    gross_emissions_native,
    premine_unlocks_native,
    burns_native,
    net_supply_change_native,
    circulating_supply_native,
    price,
    circulating_supply_native * price as market_cap_calc
FROM
    art_share.akash.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

Provider and Lease Growth Metrics

-- Analyze growth of the Akash compute marketplace
SELECT
    date,
    active_providers,
    active_leases,
    new_leases,
    active_leases / NULLIF(active_providers, 0) as leases_per_provider,
    LAG(active_providers, 30) OVER (ORDER BY date) as providers_30d_ago,
    LAG(active_leases, 30) OVER (ORDER BY date) as leases_30d_ago,
    active_providers / NULLIF(providers_30d_ago, 0) - 1 as provider_monthly_growth,
    active_leases / NULLIF(leases_30d_ago, 0) - 1 as lease_monthly_growth
FROM
    art_share.akash.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

Revenue vs. Market Metrics

-- Analyze relationship between revenue and market metrics
SELECT
    date,
    compute_fees,
    ecosystem_revenue,
    price,
    market_cap,
    market_cap / NULLIF(ecosystem_revenue, 0) as price_to_revenue_ratio,
    token_volume / NULLIF(ecosystem_revenue, 0) as volume_to_revenue_ratio
FROM
    art_share.akash.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
    AND ecosystem_revenue > 0
ORDER BY
    date ASC

Monthly Compute Marketplace Statistics

-- Calculate monthly compute marketplace statistics
SELECT
    DATE_TRUNC('month', date) as month,
    AVG(active_providers) as avg_providers,
    AVG(active_leases) as avg_leases,
    SUM(new_leases) as total_new_leases,
    SUM(compute_fees) as total_compute_fees,
    SUM(ecosystem_revenue) as total_revenue,
    AVG(price) as avg_token_price
FROM
    art_share.akash.ez_metrics
WHERE
    date >= DATEADD(year, -1, CURRENT_DATE())
GROUP BY
    DATE_TRUNC('month', date)
ORDER BY
    month ASC

Ecosystem Economics Analysis

-- Analyze Akash ecosystem economics
SELECT
    date,
    active_providers,
    active_leases,
    compute_fees,
    service_cash_flow,
    compute_fees / NULLIF(active_leases, 0) as avg_fee_per_lease,
    service_cash_flow / NULLIF(active_providers, 0) as avg_revenue_per_provider,
    gross_emissions_native - burns_native as net_inflation,
    net_inflation / NULLIF(circulating_supply_native, 0) * 100 as inflation_rate
FROM
    art_share.akash.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC