with ethop as (select tx_hash, origin_from_address, amount_usd as volume from ethereum.core.ez_eth_transfers where origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'), bridge as (select tx_hash, origin_from_address, amount_usd as volume from ethereum.core.ez_token_transfers where origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'), ethtoop as (select * from ethop union select * from bridge), ethop2 as (select tx_hash, origin_from_address, amount_usd as volume from ethereum.core.ez_eth_transfers where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'), bridge2 as (select tx_hash, origin_from_address, amount_usd as volume from ethereum.core.ez_token_transfers where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'), optoeth as (select * from ethop2 union select * from bridge2) select 'Bridge from Optimism to Ethereum' as netwrok, case when volume <= 50 then 'Less than or Equal to $50' when volume > 50 and volume <=100 then '$50 - $100' when volume > 100 and volume <=1000 then '$100 - $1k' when volume > 1000 and volume <=10000 then '$1k - $10k' when volume > 10000 and volume <=100000 then '$10k - $100k' when volume > 100000 and volume <=1000000 then '$100k - $1M' when volume > 1000000 and volume <=10000000 then '$1M - $10M' when volume > 10000000 and volume <=100000000 then '$10M - $100M' else 'More than $100 million' end as distribution, count (distinct tx_hash) as Number_of_transaction from optoeth group by 1, 2 union select 'Bridge from Ethereum to Optimism' as netwrok, case when volume <= 50 then 'Less than or Equal to $50' when volume > 50 and volume <=100 then '$50 - $100' when volume > 100 and volume <=1000 then '$100 - $1k' when volume > 1000 and volume <=10000 then '$1k - $10k' when volume > 10000 and volume <=100000 then '$10k - $100k' when volume > 100000 and volume <=1000000 then '$100k - $1M' when volume > 1000000 and volume <=10000000 then '$1M - $10M' when volume > 10000000 and volume <=100000000 then '$10M - $100M' else 'More than $100 million' end as distribution, count (distinct tx_hash) as Number_of_transaction from ethtoop group by 1, 2

Optimism Inflow & Outflow