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

# Base

> Base Schema Description and Methodology

This schema contains comprehensive datasets for tracking Base fundamental data across multiple metrics categories, including network activity, fees, revenue distribution, stablecoin usage, bridge activity, developer engagement, and market data.

## Available Tables

Base data is available in several tables:

* **ez\_metrics**: Main aggregated metrics for the Base network
* **ez\_metrics\_by\_category\_v2**: Metrics broken down by transaction category
* **ez\_metrics\_by\_application\_v2**: Metrics broken down by application
* **ez\_metrics\_by\_subcategory**: Metrics broken down by subcategory
* **ez\_metrics\_by\_contract\_v2**: Metrics broken down by contract
* **ez\_metrics\_by\_chain**: Cross-chain flow metrics with inflow and outflow data

## Table Schema

### Network and Usage Metrics

| Table Name  | Column Name             | Description                                    |
| ----------- | ----------------------- | ---------------------------------------------- |
| ez\_metrics | chain\_txns             | Daily transactions on the Base network         |
| ez\_metrics | chain\_dau              | Daily unique users on Base                     |
| ez\_metrics | chain\_avg\_txn\_fee    | The average transaction fee on Base            |
| ez\_metrics | chain\_median\_txn\_fee | The median transaction fee on Base             |
| ez\_metrics | returning\_users        | The number of returning users on Base          |
| ez\_metrics | new\_users              | The number of new users on Base                |
| ez\_metrics | dau                     | Legacy naming for chain\_dau                   |
| ez\_metrics | txns                    | Legacy naming for chain\_txns                  |
| ez\_metrics | wau                     | Weekly active users on Base                    |
| ez\_metrics | mau                     | Monthly active users on Base                   |
| ez\_metrics | dau\_over\_100          | Users with balances over \$100 (legacy naming) |

### User Classification Metrics

| Table Name  | Column Name        | Description                                         |
| ----------- | ------------------ | --------------------------------------------------- |
| ez\_metrics | sybil\_users       | The number of sybil users (suspected bots) on Base  |
| ez\_metrics | non\_sybil\_users  | The number of non-sybil users on Base               |
| ez\_metrics | low\_sleep\_users  | Users with continuous activity (possible bots)      |
| ez\_metrics | high\_sleep\_users | Users with normal activity patterns (likely humans) |

### Fee and Revenue Metrics

| Table Name  | Column Name                 | Description                                          |
| ----------- | --------------------------- | ---------------------------------------------------- |
| ez\_metrics | fees                        | Total revenue generated from transaction fees (USD)  |
| ez\_metrics | fees\_native                | Total revenue from transaction fees in ETH           |
| ez\_metrics | l1\_fee\_allocation         | Fees paid to Ethereum L1 for data posting (USD)      |
| ez\_metrics | l1\_fee\_allocation\_native | Fees paid to Ethereum L1 in ETH                      |
| ez\_metrics | treasury\_fee\_allocation   | Revenue allocated to Base treasury (fees - L1 costs) |
| ez\_metrics | fees                        | Legacy naming for fees                               |
| ez\_metrics | fees\_native                | Legacy naming for fees\_native                       |
| ez\_metrics | avg\_txn\_fee               | Legacy naming for chain\_avg\_txn\_fee               |
| ez\_metrics | median\_txn\_fee            | Legacy naming for chain\_median\_txn\_fee            |
| ez\_metrics | l1\_data\_cost              | Legacy naming for l1\_fee\_allocation                |
| ez\_metrics | l1\_data\_cost\_native      | Legacy naming for l1\_fee\_allocation\_native        |
| ez\_metrics | revenue                     | Legacy naming for treasury\_fee\_allocation          |
| ez\_metrics | revenue\_native             | Legacy naming for treasury\_fee\_allocation in ETH   |

### Volume and Trading Metrics

| Table Name  | Column Name                 | Description                                   |
| ----------- | --------------------------- | --------------------------------------------- |
| ez\_metrics | chain\_spot\_volume         | Total spot DEX volume on Base                 |
| ez\_metrics | chain\_nft\_trading\_volume | The total volume of NFT trading on Base       |
| ez\_metrics | settlement\_volume          | Total volume of DEX + NFT + P2P transfers     |
| ez\_metrics | dex\_volumes                | Legacy naming for chain\_spot\_volume         |
| ez\_metrics | nft\_trading\_volume        | Legacy naming for chain\_nft\_trading\_volume |

### P2P Transfer Metrics

| Table Name  | Column Name                   | Description                                      |
| ----------- | ----------------------------- | ------------------------------------------------ |
| ez\_metrics | p2p\_native\_transfer\_volume | Volume of ETH transfers directly between wallets |
| ez\_metrics | p2p\_token\_transfer\_volume  | Volume of ERC-20 token transfers between wallets |
| ez\_metrics | p2p\_transfer\_volume         | Total volume of all P2P transfers                |

### Stablecoin Metrics

| Table Name  | Column Name                            | Description                                    |
| ----------- | -------------------------------------- | ---------------------------------------------- |
| ez\_metrics | stablecoin\_total\_supply              | The total supply of stablecoins on Base        |
| ez\_metrics | stablecoin\_txns                       | The number of stablecoin transactions          |
| ez\_metrics | stablecoin\_dau                        | Daily active users of stablecoins              |
| ez\_metrics | stablecoin\_mau                        | Monthly active users of stablecoins            |
| ez\_metrics | stablecoin\_transfer\_volume           | The total volume of stablecoin transfers       |
| ez\_metrics | stablecoin\_tokenholder\_count         | The number of unique stablecoin tokenholders   |
| ez\_metrics | artemis\_stablecoin\_txns              | Stablecoin txns excluding MEV transactions     |
| ez\_metrics | artemis\_stablecoin\_dau               | Daily users excluding MEV addresses            |
| ez\_metrics | artemis\_stablecoin\_mau               | Monthly users excluding MEV addresses          |
| ez\_metrics | artemis\_stablecoin\_transfer\_volume  | Stablecoin volume excluding MEV transactions   |
| ez\_metrics | p2p\_stablecoin\_txns                  | P2P stablecoin transactions (wallet-to-wallet) |
| ez\_metrics | p2p\_stablecoin\_dau                   | Daily users of P2P stablecoin transfers        |
| ez\_metrics | p2p\_stablecoin\_mau                   | Monthly users of P2P stablecoin transfers      |
| ez\_metrics | p2p\_stablecoin\_transfer\_volume      | Volume of P2P stablecoin transfers             |
| ez\_metrics | p2p\_stablecoin\_tokenholder\_count    | Unique holders conducting P2P transfers        |
| ez\_metrics | non\_p2p\_stablecoin\_transfer\_volume | Volume of non-P2P stablecoin transfers         |

### Bridge Metrics

| Table Name  | Column Name    | Description                           |
| ----------- | -------------- | ------------------------------------- |
| ez\_metrics | bridge\_volume | The total volume bridged to/from Base |
| ez\_metrics | bridge\_daa    | Daily active users of Base bridges    |

### Developer Activity Metrics

| Table Name  | Column Name                 | Description                                  |
| ----------- | --------------------------- | -------------------------------------------- |
| ez\_metrics | weekly\_contracts\_deployed | The number of new contracts deployed on Base |
| ez\_metrics | weekly\_contract\_deployers | The number of addresses deploying contracts  |

### Market Metrics

| Table Name  | Column Name | Description                              |
| ----------- | ----------- | ---------------------------------------- |
| ez\_metrics | tvl         | The total value locked in Base protocols |

## Sample Queries

### Basic Network Activity Query

```sql theme={null}
-- Pull fundamental network activity data for Base
SELECT
    date,
    chain_txns,
    chain_dau,
    fees,
    chain_avg_txn_fee,
    chain_median_txn_fee,
    tvl
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### Fee Distribution Analysis

```sql theme={null}
-- Analyze Base fee distribution between L1 and Base
SELECT
    date,
    fees,
    l1_fee_allocation,
    treasury_fee_allocation,
    l1_fee_allocation / NULLIF(fees, 0) * 100 as l1_fee_percentage,
    treasury_fee_allocation / NULLIF(fees, 0) * 100 as base_revenue_percentage,
    fees / chain_txns as avg_fee_per_txn,
    l1_fee_allocation / chain_txns as avg_l1_cost_per_txn
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
    AND fees > 0
ORDER BY
    date ASC
```

### User Growth Analysis

```sql theme={null}
-- Analyze user growth and retention on Base
SELECT
    date,
    chain_dau,
    new_users,
    returning_users,
    new_users / NULLIF(chain_dau, 0) * 100 as new_user_percentage,
    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.base.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### User Classification Analysis

```sql theme={null}
-- Analyze different user types on Base
SELECT
    date,
    chain_dau,
    sybil_users,
    non_sybil_users,
    low_sleep_users,
    high_sleep_users,
    non_sybil_users / NULLIF(chain_dau, 0) * 100 as non_sybil_percentage,
    high_sleep_users / NULLIF(chain_dau, 0) * 100 as high_sleep_percentage
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC
```

### Volume Analysis

```sql theme={null}
-- Analyze different volume sources on Base
SELECT
    date,
    settlement_volume,
    chain_spot_volume,
    chain_nft_trading_volume,
    p2p_transfer_volume,
    p2p_native_transfer_volume,
    p2p_token_transfer_volume,
    stablecoin_transfer_volume,
    chain_spot_volume / NULLIF(settlement_volume, 0) * 100 as dex_percentage,
    chain_nft_trading_volume / NULLIF(settlement_volume, 0) * 100 as nft_percentage,
    p2p_transfer_volume / NULLIF(settlement_volume, 0) * 100 as p2p_percentage
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC
```

### Stablecoin Analysis

```sql theme={null}
-- Track stablecoin usage on Base
SELECT
    date,
    stablecoin_total_supply,
    stablecoin_dau,
    artemis_stablecoin_dau,
    p2p_stablecoin_dau,
    stablecoin_transfer_volume,
    p2p_stablecoin_transfer_volume,
    non_p2p_stablecoin_transfer_volume,
    p2p_stablecoin_transfer_volume / NULLIF(stablecoin_transfer_volume, 0) * 100 as p2p_percentage,
    stablecoin_transfer_volume / NULLIF(chain_spot_volume, 0) * 100 as stablecoin_to_dex_ratio
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC
```

### Bridge Activity Analysis

```sql theme={null}
-- Track bridge activity on Base
SELECT
    date,
    bridge_volume,
    bridge_daa as bridge_dau,
    bridge_volume / NULLIF(bridge_daa, 0) as avg_bridge_volume_per_user,
    chain_dau,
    bridge_daa / NULLIF(chain_dau, 0) * 100 as bridging_user_percentage,
    LAG(bridge_volume, 7) OVER (ORDER BY date) as bridge_volume_week_ago,
    bridge_volume / NULLIF(bridge_volume_week_ago, 0) - 1 as weekly_bridge_growth
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### Developer Activity Monitoring

```sql theme={null}
-- Track developer activity on Base
SELECT
    date,
    weekly_contracts_deployed,
    weekly_contract_deployers,
    weekly_contracts_deployed / NULLIF(weekly_contract_deployers, 0) as avg_contracts_per_deployer,
    LAG(weekly_contracts_deployed, 4) OVER (ORDER BY date) as contracts_month_ago,
    weekly_contracts_deployed / NULLIF(contracts_month_ago, 0) - 1 as monthly_contract_growth
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC
```

### Layer 2 Economics Analysis

```sql theme={null}
-- Analyze Base's economics as a Layer 2 solution
SELECT
    date,
    chain_txns,
    fees,
    l1_fee_allocation,
    treasury_fee_allocation,
    chain_avg_txn_fee,
    l1_fee_allocation / NULLIF(chain_txns, 0) as l1_cost_per_transaction,
    treasury_fee_allocation / NULLIF(chain_txns, 0) as profit_per_transaction,
    treasury_fee_allocation / NULLIF(l1_fee_allocation, 0) as profit_to_cost_ratio
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### Application-specific Analysis

```sql theme={null}
-- Analyze metrics for specific applications on Base
SELECT
    date,
    app,
    friendly_name,
    category,
    txns,
    dau,
    returning_users,
    new_users
FROM
    art_share.base.ez_metrics_by_application_v2
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND app IN ('aerodrome', 'baseswap', 'uniswap-v3')
ORDER BY
    app, date ASC
```

### Cross-chain Flow Analysis

```sql theme={null}
-- Analyze cross-chain flows to and from Base
SELECT
    date,
    inflow,
    outflow,
    inflow - outflow as net_flow,
    SUM(inflow - outflow) OVER (ORDER BY date) as cumulative_net_flow
FROM
    art_share.base.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### TVL and Usage Correlation

```sql theme={null}
-- Analyze relationship between TVL and usage metrics on Base
SELECT
    date,
    tvl,
    chain_dau,
    chain_txns,
    chain_spot_volume,
    stablecoin_total_supply,
    tvl / NULLIF(chain_dau, 0) as tvl_per_user,
    chain_spot_volume / NULLIF(tvl, 0) as dex_volume_to_tvl_ratio,
    stablecoin_total_supply / NULLIF(tvl, 0) * 100 as stablecoin_percentage_of_tvl
FROM
    art_share.base.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```