'AVALANCHE' as chain

,case

when AMOUNT>0 and AMOUNT<10 then 'Below 10 $'

when AMOUNT>=10 and AMOUNT<100 then '10~100 $'

when AMOUNT>=100 and AMOUNT<1000 then '100~1K $'

when AMOUNT>=1000 and AMOUNT<10000 then '1K~10K $'

when AMOUNT>=10000 then 'Up To 10K $' end as dis_volume

,count(distinct TX_HASH) as transfers

from avalanche.core.ez_token_transfers

where CONTRACT_ADDRESS in ( lower('0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E'))

and dis_volume is not null

group by 1,2

union all

select --date_trunc('month',BLOCK_TIMESTAMP) as month

'ARBITRUM' as chain

,case

when AMOUNT>0 and AMOUNT<10 then 'Below 10 $'

when AMOUNT>=10 and AMOUNT<100 then '10~100 $'

when AMOUNT>=100 and AMOUNT<1000 then '100~1K $'

when AMOUNT>=1000 and AMOUNT<10000 then '1K~10K $'

when AMOUNT>=10000 then 'Up To 10K $' end as dis_volume

,count(distinct TX_HASH) as transfers

from arbitrum.core.ez_token_transfers

where CONTRACT_ADDRESS in (lower('0xaf88d065e77c8cC2239327C5EDb3A432268e5831'),lower('0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8'))

and dis_volume is not null

group by 1,2

union all

select --date_trunc('month',BLOCK_TIMESTAMP) as month

'OPTIMISM' as chain

,case

when AMOUNT>0 and AMOUNT<10 then 'Below 10 $'

when AMOUNT>=10 and AMOUNT<100 then '10~100 $'

when AMOUNT>=100 and AMOUNT<1000 then '100~1K $'

when AMOUNT>=1000 and AMOUNT<10000 then '1K~10K $'

when AMOUNT>=10000 then 'Up To 10K $' end as dis_volume