ethereum_bridge_txs AS (SELECT * FROM $query('378caf92-42fd-4fa9-aa11-19f2d6d731c8')),

arbitrum_bridge_txs AS (SELECT * FROM $query('7aa67484-f639-4a58-9e35-18460971423e')),

avalanche_bridge_txs AS (SELECT * FROM $query('4424046c-1851-448a-9cd5-739828b10826')),

base_bridge_txs AS (SELECT * FROM $query('47d7e8cc-173e-417b-8816-7443365b0352')),

optimism_bridge_txs AS (SELECT * FROM $query('8e829a16-a353-4508-bdda-ac3184295d1d')),

polygon_bridge_txs AS (SELECT * FROM $query('2a4afae7-5a43-48e9-a073-0443eaedc240')),

all_bridge_txs AS (

SELECT * FROM (

SELECT * FROM ethereum_bridge_txs

UNION ALL

SELECT * FROM arbitrum_bridge_txs

UNION ALL

SELECT * FROM avalanche_bridge_txs

UNION ALL

SELECT * FROM base_bridge_txs

UNION ALL

SELECT * FROM optimism_bridge_txs

UNION ALL

SELECT * FROM polygon_bridge_txs

)

WHERE

token_symbol is not NULL

AND usd_amount_received is not NULL

AND block_timestamp > '2025-02-03'

),

hourly_bridging as (

SELECT

date_trunc('h', block_timestamp) as hour,

chain,

token_symbol,

count(DISTINCT tx_hash) as tx_count,

sum(usd_amount_received) as volume_usd,

count(DISTINCT sender) as unique_users