> ## Documentation Index
> Fetch the complete documentation index at: https://artemis.ai/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# 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 | 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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

```sql theme={null}
-- 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
```