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 NameColumn NameDescription
ez_metricsactive_leasesThe number of active compute leases on Akash Network
ez_metricsactive_providersThe number of active compute providers on the network
ez_metricsnew_leasesThe number of new compute leases created

​
Revenue and Fee Metrics

Table NameColumn NameDescription
ez_metricscompute_feesFees paid for compute resources in USD
ez_metricscompute_fees_nativeFees paid for compute resources in AKT tokens
ez_metricscompute_fees_usdcFees paid for compute resources in USDC
ez_metricscompute_fees_total_usdTotal compute fees across all currencies in USD
ez_metricsgas_feesTransaction fees paid to validators in USD
ez_metricsvalidator_feesSame as gas_fees (legacy naming)
ez_metricsvalidator_fees_nativeTransaction fees paid to validators in AKT tokens
ez_metricstotal_feesSum of all fees on the network
ez_metricsfeesTotal revenue generated (compute_fees + gas_fees)

​
Revenue Distribution Metrics

Table NameColumn NameDescription
ez_metricsservice_fee_allocationRevenue accrued to compute providers (compute_fees minus treasury portion)
ez_metricsvalidator_fee_allocationRevenue allocated to validators (gas_fees)
ez_metricstreasury_fee_allocationRevenue allocated to Akash treasury
ez_metricsrevenueLegacy naming for treasury_fee_allocation

​
Token Supply Metrics

Table NameColumn NameDescription
ez_metricsgross_emissions_nativeThe amount of new AKT tokens emitted
ez_metricspremine_unlocks_nativeThe amount of AKT tokens unlocked from premine
ez_metricsburns_nativeThe amount of AKT tokens burned
ez_metricstotal_burned_nativeLegacy naming for burns_native
ez_metricsnet_supply_change_nativeNet change in circulating supply (emissions + unlocks - burns)
ez_metricscirculating_supply_nativeThe circulating supply of AKT in native tokens

​
Market and Token Metrics

Table NameColumn NameDescription
ez_metricspriceThe price of AKT token in USD
ez_metricsmarket_capThe market cap of AKT token in USD
ez_metricsfdmcThe fully diluted market cap of AKT token in USD
ez_metricstoken_volumeThe trading volume of AKT token in USD
ez_metricstoken_turnover_circulatingThe turnover of AKT based on circulating supply
ez_metricstoken_turnover_fdvThe 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