-- Combine all relevant data sources for bridging activities

SELECT *, TOTAL_VOLUME AS volume_adj, transaction_date AS trans_date

FROM $query('681e5f03-81f2-4610-b46a-d9bb07a57d8c') -- eth to ronin native

UNION ALL

SELECT *, TOTAL_VOLUME * -1 AS volume_adj, transaction_date AS trans_date

FROM $query('5fed494d-91be-4e73-84b4-3321e38a0b99') -- ronin to eth native

UNION ALL

SELECT *, TOTAL_VOLUME AS volume_adj, transaction_date AS trans_date

FROM $query('e640caf5-ec09-4512-9d13-e9ad0b6e8e03') -- eth to ronin ccip

UNION ALL

SELECT *, TOTAL_VOLUME AS volume_adj, transaction_date AS trans_date

FROM $query('a6bd881e-a6a5-4c4d-85da-78ca173c67e4') -- base to ronin ccip

UNION ALL

SELECT *, TOTAL_VOLUME * -1 AS volume_adj, transaction_date AS trans_date

FROM $query('a89d784f-8965-4adf-8204-93c086c029ac') -- ronin to base and eth ccip

SELECT

token_symbol,

SUM(COALESCE(ABS(volume_adj), 0))::FLOAT AS volume_out_daily, -- Total volume out bridged tokens (convert negative to positive for chart)

SUM(SUM(COALESCE(ABS(volume_adj), 0))) OVER (PARTITION BY token_symbol ORDER BY MIN(trans_date) ASC) ::FLOAT AS total_volume_out -- Cumulative volume out

FROM combined

WHERE volume_adj < 0 -- Focus on outbound bridged tokens (negative volume_adj)

AND trans_date >= '2025-01-01' -- Start of Q1

AND trans_date <= '2025-03-31' -- End of Q1

GROUP BY token_symbol

ORDER BY volume_out_daily DESC

LIMIT 10; -- Top 10 tokens by volume bridged out