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