SELECT

destination_chain as chain,

size_bucket || 'n' as size_bucket,

-tx_count as tx_count,

-total_volume/1e6 as total_volume,

avg_tx_size as avg_tx_size,

pct_of_chain_txs,

pct_of_chain_volume

FROM $query('d59da65a-193e-4c10-92c5-cb35f176cbf6')

),

incoming_histograms AS (

SELECT

source_chain as chain,

size_bucket,

tx_count,

total_volume/1e6,

avg_tx_size,

pct_of_chain_txs,

pct_of_chain_volume

FROM $query('fb2e85ce-a3b6-4662-aad2-a50626d1baaf')

SELECT *

FROM (

SELECT * FROM outgoing_histograms

UNION

SELECT * FROM incoming_histograms

WHERE chain NOT IN ('Blast', 'Gnosis')

ORDER BY

chain,

CASE

WHEN size_bucket = '10K+' OR size_bucket = '10K+n' THEN 1

WHEN size_bucket = '5K-10K' OR size_bucket = '5K-10Kn' THEN 2

WHEN size_bucket = '1K-5K' OR size_bucket = '1K-5Kn' THEN 3

WHEN size_bucket = '500-1K' OR size_bucket = '500-1Kn' THEN 4