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'

),

period_stats AS (

SELECT

CASE

WHEN block_timestamp < '2025-02-06 11:59:00' THEN 'Before Launch'

WHEN block_timestamp >= '2025-02-06 11:59:00' THEN 'After Launch'

END as period,

COUNT(DISTINCT tx_hash) as tx_count,

ROUND(SUM(usd_amount_received), 0) as volume_usd,