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 | fees | Total revenue generated (compute_fees + gas_fees) |
Revenue Distribution Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | service_fee_allocation | Revenue accrued to compute providers (compute_fees minus treasury portion) |
| ez_metrics | validator_fee_allocation | Revenue allocated to validators (gas_fees) |
| ez_metrics | treasury_fee_allocation | Revenue allocated to Akash treasury |
| ez_metrics | revenue | Legacy naming for treasury_fee_allocation |
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,
fees,
compute_fees / fees * 100 as compute_fees_percentage,
gas_fees / fees * 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,
fees,
service_fee_allocation,
validator_fee_allocation,
treasury_fee_allocation,
service_fee_allocation / fees * 100 as providers_percentage,
validator_fee_allocation / fees * 100 as validators_percentage,
treasury_fee_allocation / fees * 100 as treasury_percentage
FROM
art_share.akash.ez_metrics
WHERE
date >= DATEADD(month, -3, CURRENT_DATE())
AND fees > 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,
fees,
price,
market_cap,
market_cap / NULLIF(fees, 0) as price_to_revenue_ratio,
token_volume / NULLIF(fees, 0) as volume_to_revenue_ratio
FROM
art_share.akash.ez_metrics
WHERE
date >= DATEADD(month, -6, CURRENT_DATE())
AND fees > 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(fees) 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_fee_allocation,
compute_fees / NULLIF(active_leases, 0) as avg_fee_per_lease,
service_fee_allocation / 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