Skip to main content
1 tables in this category.

​
Tables

View NameDatabaseSourceORDER BY
agent.bridge_volume_dailyagentbridges.bridge_volume_dailyblock_date, project, version, source_chain
  • agent.ethereum_chain_daily
  • agent.ethereum_prices_day

​
Sample Queries

​
1. Bridge volume by protocol this week

SELECT bridge_name, count() AS transfers,
       sum(deposit_amount_raw) AS total_raw
FROM bridges_ethereum.deposits
WHERE block_date >= today() - 7
GROUP BY bridge_name
ORDER BY transfers DESC

​
Table Schemas

​
agent.bridge_volume_daily

Daily cross-chain bridge volume in USD with directional flow tracking. One row per (block_date, project, version, source_chain, destination_chain). Each row is a directional flow: deposits contribute (ethereum, X) rows, withdrawals contribute (X, ethereum) rows. Covers Across, Polygon, USDT0, Lighter, Mayan, and other bridges with USD pricing from hourly prices. Engine: MergeTree | Partition: toYYYYMM(block_date) | ORDER BY: block_date, project, version, source_chain
ColumnTypeDescription
block_dateDateUTC block date
blockchainStringBlockchain network name
projectStringBridge protocol name (lowercase): across, polygon, arbitrum, usdt0, lighter, mayan.
versionStringBridge protocol version.
source_chainStringOrigin chain of the bridged funds.
destination_chainStringTarget chain of the bridged funds.
volume_usdFloat64Total USD value bridged. Priced at hourly rate (toStartOfHour).
tx_countUInt64Number of bridge transactions in this direction on this day.
  • Each row is directional — (Ethereum, Arbitrum) is a separate row from (Arbitrum, Ethereum)
  • For total bridge volume regardless of direction: sum both directions
  • Filter source_chain or destination_chain for chain-specific inflow/outflow analysis
  • volume_usd uses hourly price at bridge time — more precise than daily price
  • Ethereum-centric — only covers bridges with Ethereum as one endpoint
  • Not all bridge protocols are indexed — newer or smaller bridges may be missing
  • USD pricing from hourly CoinGecko — same limitations as DEX prices
  • Mayan bridge uses a separate volume model with different source methodology