with table2 as (with table1 as (with tab1 as (select origin_from_address as bridger, sum(AMOUNT_USD) bridged_volume, count(distinct tx_hash) as bridge_count from ethereum.core.ez_token_transfers where (to_address='0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- Optimism: Gateway or to_address='0x3666f603cc164936c1b87e207f36beba4ac5f18a' -- HOP: USDC or to_address='0xb98454270065a31d71bf635f6f7ee6a518dfb849' --HOP: WBTC or to_address='0xb8901acb165ed027e32754e0ffe830802919727f' --HOP: ETH or to_address='0x3d4cc8a61c7528fd86c55cfe061a78dcba48edd1' --HOP: DAI or to_address='0x3e4a3a4796d16c0cd582c382691998f7c06420b6' --HOP: USDT or to_address='0x22b1cbb8d98a01a3b71d034bb899775a76eb1cc2') --HOP: MATIC and block_timestamp::date>=current_date-180 and block_timestamp::date<>current_date and amount_usd is not null and symbol is not null group by 1 order by 1), tab2 as (select origin_from_address as bridger, sum(AMOUNT_USD) bridged_volume, count(distinct tx_hash) as bridge_count from ethereum.core.ez_eth_transfers where (eth_to_address='0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- Optimism: Gateway or eth_to_address='0xb8901acb165ed027e32754e0ffe830802919727f') --HOP: ETH and block_timestamp::date>=current_date-180 and block_timestamp::date<>current_date and amount_usd is not null group by 1 order by 1) select * from tab1 union ALL select * from tab2) select bridger, BRIDGED_VOLUME, case when BRIDGED_VOLUME<=1 then 'V<=1' when BRIDGED_VOLUME>1 and BRIDGED_VOLUME<=10 then '110 and BRIDGED_VOLUME<=100 then '10100 and BRIDGED_VOLUME<=1000 then '1001000 and BRIDGED_VOLUME<=10000 then '1k10000 and BRIDGED_VOLUME<=100000 then '10k100000 and BRIDGED_VOLUME<=1000000 then '100k1000000 then 'V>1M' end as group_ from table1) select group_, count(distinct bridger) as bridger_count from table2 group by 1 order by 2

Bridger Destinations (redux)