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

# Aptos

> Aptos Schema Description and Methodology

This schema contains comprehensive on-chain datasets for tracking Aptos fundamental data across multiple metrics categories, including network activity, fees, trading volumes, developer activity, and market data.

## Available Tables

Aptos data is available in one main table:

* **ez\_metrics**: Main aggregated metrics for the Aptos blockchain

## Table Schema

### Network and Usage Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | chain\_txns | Daily transactions on the Aptos blockchain |
| ez\_metrics | chain\_dau | Daily unique users on Aptos |
| ez\_metrics | chain\_wau | Weekly unique users on Aptos |
| ez\_metrics | chain\_mau | Monthly unique users on Aptos |
| ez\_metrics | txns | Legacy naming for chain\_txns |
| ez\_metrics | dau | Legacy naming for chain\_dau |
| ez\_metrics | wau | Legacy naming for chain\_wau |
| ez\_metrics | mau | Legacy naming for chain\_mau |

### Fee and Revenue Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | chain\_fees | The total transaction fees paid on Aptos in USD |
| ez\_metrics | chain\_avg\_txn\_fee | The average transaction fee on Aptos in USD |
| ez\_metrics | fees | The total USD value generated from all user-paid fees on Aptos |
| ez\_metrics | fees\_native | The total native APT value from all user-paid fees |
| ez\_metrics | fees | Legacy naming for chain\_fees |
| ez\_metrics | fees\_native | Transaction fees in native APT tokens |
| ez\_metrics | avg\_txn\_fee | Legacy naming for chain\_avg\_txn\_fee |

### Cash Flow Distribution Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | burned\_fee\_allocation | USD value of APT burned through transaction fees |
| ez\_metrics | burned\_fee\_allocation\_native | Amount of native APT burned through transaction fees |
| ez\_metrics | revenue | Legacy naming for burned\_fee\_allocation |
| ez\_metrics | revenue\_native | Legacy naming for burned\_fee\_allocation\_native |

### Volume and DeFi Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | chain\_spot\_volume | Total spot DEX volume on Aptos |
| ez\_metrics | tvl | The total value locked in Aptos DeFi protocols |
| ez\_metrics | dex\_volumes | Legacy naming for chain\_spot\_volume |

### Market and Token Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | price | The price of APT token in USD |
| ez\_metrics | market\_cap | The market cap of APT token in USD |
| ez\_metrics | fdmc | The fully diluted market cap of APT token in USD |
| ez\_metrics | token\_volume | The trading volume of APT token in USD |
| ez\_metrics | token\_turnover\_circulating | The turnover of APT based on circulating supply |
| ez\_metrics | token\_turnover\_fdv | The turnover of APT based on fully diluted valuation |

### Developer Activity Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | weekly\_commits\_core\_ecosystem | The number of commits to the Aptos core ecosystem |
| ez\_metrics | weekly\_commits\_sub\_ecosystem | The number of commits to the Aptos sub-ecosystem |
| ez\_metrics | weekly\_developers\_core\_ecosystem | The number of developers who have made commits to the Aptos core ecosystem |
| ez\_metrics | weekly\_developers\_sub\_ecosystem | The number of developers who have made commits to the Aptos sub-ecosystem |

## Sample Queries

### Basic Network Activity Query

```sql theme={null}
-- Pull fundamental network activity data for Aptos
SELECT
    date,
    chain_txns,
    chain_dau,
    chain_fees,
    chain_avg_txn_fee,
    price
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### User Growth Analysis

```sql theme={null}
-- Analyze user growth and retention on Aptos
SELECT
    date,
    chain_dau,
    chain_wau,
    chain_mau,
    chain_dau / NULLIF(chain_wau, 0) * 100 as daily_to_weekly_ratio,
    chain_wau / NULLIF(chain_mau, 0) * 100 as weekly_to_monthly_ratio,
    LAG(chain_dau, 7) OVER (ORDER BY date) as dau_week_ago,
    chain_dau / NULLIF(dau_week_ago, 0) - 1 as weekly_dau_growth
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### Fee and Revenue Analysis

```sql theme={null}
-- Analyze Aptos fees and revenue
SELECT
    date,
    chain_fees,
    chain_avg_txn_fee,
    fees,
    burned_fee_allocation,
    chain_txns,
    chain_dau,
    chain_fees / chain_txns as avg_fee_per_txn,
    chain_fees / chain_dau as avg_fee_per_user
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### DeFi Activity Analysis

```sql theme={null}
-- Track DeFi activity on Aptos
SELECT
    date,
    chain_spot_volume,
    tvl,
    chain_spot_volume / NULLIF(tvl, 0) as dex_volume_to_tvl_ratio,
    LAG(chain_spot_volume, 7) OVER (ORDER BY date) as volume_week_ago,
    chain_spot_volume / NULLIF(volume_week_ago, 0) - 1 as weekly_volume_growth
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC
```

### Token Performance Analysis

```sql theme={null}
-- Analyze APT token metrics
SELECT
    date,
    price,
    market_cap,
    fdmc,
    token_volume,
    token_turnover_circulating,
    token_volume / NULLIF(chain_fees, 0) as token_volume_to_fees_ratio
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### Developer Activity Monitoring

```sql theme={null}
-- Track developer activity on Aptos
SELECT
    date,
    weekly_developers_core_ecosystem,
    weekly_developers_sub_ecosystem,
    weekly_commits_core_ecosystem,
    weekly_commits_sub_ecosystem,
    weekly_commits_core_ecosystem / NULLIF(weekly_developers_core_ecosystem, 0) as commits_per_core_dev,
    weekly_commits_sub_ecosystem / NULLIF(weekly_developers_sub_ecosystem, 0) as commits_per_sub_dev
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC
```

### Network Economics Analysis

```sql theme={null}
-- Analyze Aptos network economics
SELECT
    date,
    chain_txns,
    chain_fees,
    burned_fee_allocation,
    price,
    market_cap,
    market_cap / NULLIF(chain_fees * 365, 0) as price_to_annual_fees_ratio,
    chain_fees / chain_txns as revenue_per_transaction
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### Monthly Performance Dashboard

```sql theme={null}
-- Create a monthly performance dashboard for Aptos
SELECT
    DATE_TRUNC('month', date) as month,
    AVG(chain_dau) as avg_daily_users,
    SUM(chain_txns) as total_transactions,
    SUM(chain_fees) as total_fees,
    AVG(chain_avg_txn_fee) as avg_transaction_fee,
    SUM(chain_spot_volume) as total_dex_volume,
    AVG(tvl) as avg_tvl,
    AVG(price) as avg_token_price,
    LAST_VALUE(market_cap) OVER (PARTITION BY DATE_TRUNC('month', date) ORDER BY date) as end_of_month_market_cap,
    LAST_VALUE(weekly_developers_core_ecosystem + weekly_developers_sub_ecosystem) OVER (PARTITION BY DATE_TRUNC('month', date) ORDER BY date) as active_developers
FROM
    art_share.aptos.ez_metrics
WHERE
    date >= DATEADD(year, -1, CURRENT_DATE())
GROUP BY
    DATE_TRUNC('month', date)
ORDER BY
    month ASC
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.