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

# Across

> Across Schema Description and Methodology

This schema contains comprehensive datasets for tracking Across Protocol fundamental data across multiple metrics categories, including cross-chain bridge activity, volume flows, user engagement, and market data for the optimistic bridge protocol.

## Available Tables

Across data is available in two main tables:

* **ez\_metrics**: Main aggregated metrics for the Across Protocol across all supported 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 Across |
| ez\_metrics | bridge\_volume | The total volume bridged through Across        |
| ez\_metrics | app            | Always 'across' for consistency                |
| ez\_metrics | category       | Always 'Bridge' for consistency                |

### 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 'across' for consistency                     |
| ez\_metrics\_by\_chain | category    | Always 'Bridge' for consistency                     |

### Market and Token Metrics

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

## Sample Queries

### Basic Bridge Activity Query

```sql theme={null}
-- Pull fundamental bridge activity data for Across
SELECT
    date,
    bridge_dau,
    bridge_volume,
    price,
    market_cap,
    bridge_volume / NULLIF(bridge_dau, 0) as avg_volume_per_user
FROM
    art_share.across.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,
    CASE
        WHEN inflow > outflow THEN 'Net Inflow'
        WHEN outflow > inflow THEN 'Net Outflow'
        ELSE 'Balanced'
    END as flow_direction
FROM
    art_share.across.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    chain, date ASC
```

### Chain Volume Comparison

```sql theme={null}
-- Compare bridge volumes 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,
    AVG(inflow + outflow) as avg_daily_volume
FROM
    art_share.across.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 user behavior
SELECT
    date,
    bridge_volume,
    bridge_dau,
    bridge_volume / NULLIF(bridge_dau, 0) as avg_volume_per_user,
    LAG(bridge_dau, 7) OVER (ORDER BY date) as dau_7d_ago,
    LAG(bridge_volume, 7) OVER (ORDER BY date) as 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.across.ez_metrics
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    date ASC
```

### Market Performance Analysis

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

### Top Chain Activity

```sql theme={null}
-- Identify most active chains by volume and flow patterns
SELECT
    date,
    chain,
    inflow + outflow as total_volume,
    inflow,
    outflow,
    ABS(inflow - outflow) as flow_imbalance,
    ABS(inflow - outflow) / NULLIF(inflow + outflow, 0) * 100 as imbalance_percentage
FROM
    art_share.across.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_volume,
    price,
    -- 7-day moving averages
    AVG(bridge_dau) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as avg_dau_7d,
    AVG(bridge_volume) OVER (ORDER BY date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as avg_volume_7d,
    -- 30-day moving averages
    AVG(bridge_dau) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) as avg_dau_30d,
    AVG(bridge_volume) OVER (ORDER BY date ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) as avg_volume_30d
FROM
    art_share.across.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC
```

### Chain Flow Balance Analysis

```sql theme={null}
-- Analyze flow balance and concentration across chains
WITH daily_chain_metrics AS (
    SELECT
        date,
        chain,
        inflow + outflow as total_volume,
        inflow - outflow as net_flow
    FROM
        art_share.across.ez_metrics_by_chain
    WHERE
        date >= DATEADD(month, -1, CURRENT_DATE())
),
chain_rankings AS (
    SELECT
        date,
        chain,
        total_volume,
        net_flow,
        ROW_NUMBER() OVER (PARTITION BY date ORDER BY total_volume DESC) as volume_rank
    FROM
        daily_chain_metrics
)
SELECT
    date,
    chain,
    total_volume,
    net_flow,
    volume_rank,
    CASE
        WHEN volume_rank <= 3 THEN 'Top 3'
        WHEN volume_rank <= 5 THEN 'Top 5'
        ELSE 'Others'
    END as chain_tier
FROM
    chain_rankings
ORDER BY
    date DESC, volume_rank ASC
```

### Weekly Performance Summary

```sql theme={null}
-- Weekly aggregated performance summary
SELECT
    DATE_TRUNC('week', date) as week,
    AVG(bridge_dau) as avg_daily_users,
    SUM(bridge_volume) as total_weekly_volume,
    AVG(bridge_volume) as avg_daily_volume,
    MAX(bridge_volume) as peak_daily_volume,
    AVG(price) as avg_token_price,
    SUM(token_volume) as total_token_volume
FROM
    art_share.across.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
GROUP BY
    DATE_TRUNC('week', date)
ORDER BY
    week DESC
```

### Cross-Chain Dominance Analysis

```sql theme={null}
-- Analyze which chains dominate Across volume
WITH chain_totals AS (
    SELECT
        chain,
        SUM(inflow + outflow) as total_volume,
        AVG(inflow + outflow) as avg_daily_volume,
        COUNT(*) as active_days
    FROM
        art_share.across.ez_metrics_by_chain
    WHERE
        date >= DATEADD(month, -1, CURRENT_DATE())
        AND (inflow > 0 OR outflow > 0)
    GROUP BY
        chain
),
total_volume AS (
    SELECT SUM(total_volume) as grand_total
    FROM chain_totals
)
SELECT
    ct.chain,
    ct.total_volume,
    ct.avg_daily_volume,
    ct.active_days,
    ct.total_volume / tv.grand_total * 100 as volume_share_percentage,
    SUM(ct.total_volume / tv.grand_total * 100) OVER (ORDER BY ct.total_volume DESC) as cumulative_share
FROM
    chain_totals ct
CROSS JOIN
    total_volume tv
ORDER BY
    ct.total_volume DESC
```