with avaxr as ( select to_address, sum (amount) as Received_Volume from avalanche.core.ez_token_transfers where contract_address in ('0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664') group by 1), avaxs as ( select from_address, sum (amount) as sent_volume from avalanche.core.ez_token_transfers where contract_address in ('0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e','0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664') group by 1), arbr as ( select to_address, sum (amount) as Received_Volume from arbitrum.core.ez_token_transfers where contract_address in ('0xaf88d065e77c8cc2239327c5edb3a432268e5831','0xff970a61a04b1ca14834a43f5de4533ebddb5cc8') group by 1), arbs as ( select from_address, sum (amount) as sent_volume from arbitrum.core.ez_token_transfers where contract_address in ('0xaf88d065e77c8cc2239327c5edb3a432268e5831','0xff970a61a04b1ca14834a43f5de4533ebddb5cc8') group by 1), polyr as ( select to_address, sum (amount) as Received_Volume from polygon.core.ez_token_transfers where contract_address ilike '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' group by 1), polys as ( select from_address, sum (amount) as sent_volume from polygon.core.ez_token_transfers where contract_address ilike '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' group by 1), optr as ( select to_address, sum (amount) as Received_Volume from optimism.core.ez_token_transfers where contract_address ilike '0x7f5c764cbc14f9669b88837ca1490cca17c31607' group by 1), opts as ( select from_address, sum (amount) as sent_volume from optimism.core.ez_token_transfers where contract_address ilike '0x7f5c764cbc14f9669b88837ca1490cca17c31607' group by 1), avaxmain as ( select from_address as Holder, sum (received_volume - sent_volume) as Balance from avaxr t1 full outer join avaxs t2 on t1.to_address = t2.from_address group by 1 having balance > 0 and holder != '0x0000000000000000000000000000000000000000'), arbmain as ( select from_address as Holder, sum (received_volume - sent_volume) as Balance from arbr t1 full outer join arbs t2 on t1.to_address = t2.from_address group by 1 having balance > 0 and holder != '0x0000000000000000000000000000000000000000'), polymain as ( select from_address as Holder, sum (received_volume - sent_volume) as Balance from polyr t1 full outer join polys t2 on t1.to_address = t2.from_address group by 1 having balance > 0 and holder != '0x0000000000000000000000000000000000000000'), optmain as ( select from_address as Holder, sum (received_volume - sent_volume) as Balance from optr t1 full outer join opts t2 on t1.to_address = t2.from_address group by 1 having balance > 0 and holder != '0x0000000000000000000000000000000000000000') select 'Avalanche' as chain, case when balance < 10 then 'Less Than 10 $USDC' when balance >= 10 and balance < 100 then '10 - 100 $USDC' when balance >= 100 and balance < 1000 then '100 - 1,000 $USDC' when balance >= 1000 and balance < 10000 then '1,000 - 10,000 $USDC' else 'More Than 10,000 $USDC' end as type, count (distinct holder) as Holders_Count from avaxmain group by 1,2 union all select 'Arbitrum' as chain, case when balance < 10 then 'Less Than 10 $USDC' when balance >= 10 and balance < 100 then '10 - 100 $USDC' when balance >= 100 and balance < 1000 then '100 - 1,000 $USDC' when balance >= 1000 and balance < 10000 then '1,000 - 10,000 $USDC' else 'More Than 10,000 $USDC' end as type, count (distinct holder) as Holders_Count from arbmain group by 1,2 union all select 'Polygon' as chain, case when balance < 10 then 'Less Than 10 $USDC' when balance >= 10 and balance < 100 then '10 - 100 $USDC' when balance >= 100 and balance < 1000 then '100 - 1,000 $USDC' when balance >= 1000 and balance < 10000 then '1,000 - 10,000 $USDC' else 'More Than 10,000 $USDC' end as type, count (distinct holder) as Holders_Count from polymain group by 1,2 union all select 'Optimism' as chain, case when balance < 10 then 'Less Than 10 $USDC' when balance >= 10 and balance < 100 then '10 - 100 $USDC' when balance >= 100 and balance < 1000 then '100 - 1,000 $USDC' when balance >= 1000 and balance < 10000 then '1,000 - 10,000 $USDC' else 'More Than 10,000 $USDC' end as type, count (distinct holder) as Holders_Count from optmain group by 1,2

USDC on AVAX vs L2s