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

# Wormhole

> Wormhole Schema Description and Methodology

This schema contains comprehensive datasets for tracking Wormhole fundamental data across multiple metrics categories, including cross-chain bridge activity, fees, token supply mechanics, and market data for the multichain bridge protocol.

## Available Tables

Wormhole data is available in two main tables:

* **ez\_metrics**: Main aggregated metrics for the Wormhole protocol across all chains
* **ez\_metrics\_by\_chain**: Cross-chain flow metrics showing inflow and outflow data broken down by individual blockchain

## Table Schema

### Bridge Activity Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | bridge\_dau | The number of daily active addresses on Wormhole |
| ez\_metrics | bridge\_txns | The number of transactions on the Wormhole bridge |
| ez\_metrics | bridge\_volume | The total volume bridged through Wormhole |
| ez\_metrics | bridge\_fees | The total fees collected by the Wormhole bridge |

### Revenue Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | fees | The total USD value generated by Wormhole from all user-paid fees |
| ez\_metrics | fees | Total fees collected by the protocol (same as bridge\_fees) |

### Cross-Chain Flow Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics\_by\_chain | inflow | The amount (in USD) flowing into a specific chain |
| ez\_metrics\_by\_chain | outflow | The amount (in USD) flowing out of a specific chain |
| ez\_metrics\_by\_chain | chain | The blockchain identifier |
| ez\_metrics\_by\_chain | app | Always 'wormhole' for consistency |
| ez\_metrics\_by\_chain | category | Always 'Bridge' for consistency |

### Token Supply Metrics

| Table Name | Column Name | Description |
| - | - | - |
| ez\_metrics | circulating\_supply\_native | The circulating supply of W tokens in native units |
| ez\_metrics | net\_supply\_change\_native | The net change in the circulating supply of W tokens |
| ez\_metrics | premine\_unlocks\_native | The amount of native W tokens unlocked from premine allocations |

### Market and Token Metrics

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

## Sample Queries

### Basic Bridge Activity Query

```sql theme={null}
-- Pull fundamental bridge activity data for Wormhole
SELECT
    date,
    bridge_txns,
    bridge_dau,
    bridge_volume,
    bridge_fees,
    fees,
    price
FROM
    art_share.wormhole.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### Cross-Chain Flow Analysis

```sql theme={null}
-- Analyze cross-chain flows by individual blockchain
SELECT
    date,
    chain,
    inflow,
    outflow,
    (inflow - outflow) as net_flow,
    inflow + outflow as total_volume
FROM
    art_share.wormhole.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    chain, date ASC
```

### Chain Flow Comparison

```sql theme={null}
-- Compare net flows across different chains
SELECT
    chain,
    SUM(inflow) as total_inflow,
    SUM(outflow) as total_outflow,
    SUM(inflow - outflow) as net_flow,
    SUM(inflow + outflow) as total_volume
FROM
    art_share.wormhole.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
GROUP BY
    chain
ORDER BY
    total_volume DESC
```

### Bridge Usage Efficiency

```sql theme={null}
-- Analyze bridge usage efficiency and fee structure
SELECT
    date,
    bridge_volume,
    bridge_fees,
    bridge_txns,
    bridge_dau,
    bridge_fees / NULLIF(bridge_volume, 0) * 100 as fee_percentage,
    bridge_volume / NULLIF(bridge_txns, 0) as avg_volume_per_txn,
    bridge_volume / NULLIF(bridge_dau, 0) as avg_volume_per_user
FROM
    art_share.wormhole.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
    AND bridge_volume > 0
ORDER BY
    date ASC
```

### Token Supply Analysis

```sql theme={null}
-- Track Wormhole token supply changes and unlocks
SELECT
    date,
    circulating_supply_native,
    net_supply_change_native,
    premine_unlocks_native,
    price,
    market_cap,
    fdmc
FROM
    art_share.wormhole.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC
```

### Market Performance Analysis

```sql theme={null}
-- Analyze Wormhole token market performance
SELECT
    date,
    price,
    market_cap,
    fdmc,
    token_volume,
    token_turnover_circulating,
    token_turnover_fdv,
    bridge_volume,
    token_volume / NULLIF(bridge_volume, 0) * 100 as token_vs_bridge_volume_ratio
FROM
    art_share.wormhole.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### Daily Bridge Metrics Summary

```sql theme={null}
-- Comprehensive daily bridge performance summary
SELECT
    date,
    bridge_dau,
    bridge_txns,
    bridge_volume,
    bridge_fees,
    fees,
    bridge_txns / NULLIF(bridge_dau, 0) as txns_per_user,
    bridge_fees / NULLIF(bridge_txns, 0) as avg_fee_per_txn
FROM
    art_share.wormhole.ez_metrics
WHERE
    date >= DATEADD(week, -4, CURRENT_DATE())
ORDER BY
    date DESC
```

### Top Chain Activity

```sql theme={null}
-- Identify most active chains by volume over time
SELECT
    date,
    chain,
    inflow + outflow as total_volume,
    inflow,
    outflow,
    CASE
        WHEN inflow > outflow THEN 'Net Inflow'
        WHEN outflow > inflow THEN 'Net Outflow'
        ELSE 'Balanced'
    END as flow_direction
FROM
    art_share.wormhole.ez_metrics_by_chain
WHERE
    date >= DATEADD(week, -2, CURRENT_DATE())
ORDER BY
    date DESC, total_volume DESC
```

### Bridge Adoption Trends

```sql theme={null}
-- Track bridge adoption and growth trends
SELECT
    date,
    bridge_dau,
    bridge_txns,
    bridge_volume,
    LAG(bridge_dau, 7) OVER (ORDER BY date) as bridge_dau_7d_ago,
    LAG(bridge_volume, 7) OVER (ORDER BY date) as bridge_volume_7d_ago,
    (bridge_dau - LAG(bridge_dau, 7) OVER (ORDER BY date)) / NULLIF(LAG(bridge_dau, 7) OVER (ORDER BY date), 0) * 100 as dau_growth_7d,
    (bridge_volume - LAG(bridge_volume, 7) OVER (ORDER BY date)) / NULLIF(LAG(bridge_volume, 7) OVER (ORDER BY date), 0) * 100 as volume_growth_7d
FROM
    art_share.wormhole.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC
```

### Chain Concentration Analysis

```sql theme={null}
-- Analyze volume concentration across different chains
WITH chain_totals AS (
    SELECT
        chain,
        SUM(inflow + outflow) as total_volume
    FROM
        art_share.wormhole.ez_metrics_by_chain
    WHERE
        date >= DATEADD(month, -1, CURRENT_DATE())
    GROUP BY
        chain
),
total_volume AS (
    SELECT SUM(total_volume) as grand_total
    FROM chain_totals
)
SELECT
    ct.chain,
    ct.total_volume,
    ct.total_volume / tv.grand_total * 100 as volume_percentage,
    SUM(ct.total_volume / tv.grand_total * 100) OVER (ORDER BY ct.total_volume DESC) as cumulative_percentage
FROM
    chain_totals ct
CROSS JOIN
    total_volume tv
ORDER BY
    ct.total_volume DESC
```


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