'Ethereum' as chain,

WHEN RAW_AMOUNT/1e6 < 5 then 'a. Below 5'

WHEN RAW_AMOUNT/1e6 < 100 then 'b. 5 - 100'

WHEN RAW_AMOUNT/1e6 < 500 then 'c. 100 - 500'

WHEN RAW_AMOUNT/1e6 < 2000 then 'd. 500 - 2,000'

WHEN RAW_AMOUNT/1e6 < 10000 then 'e. 2,000 - 10,000'

WHEN RAW_AMOUNT/1e6 >= 10000 then 'f. Over 10,000'

end as gp,

count(distinct tx_hash) as no_transfers,

count(distinct FROM_ADDRESS) as no_senders,

count(distinct TO_ADDRESS) as no_receivers,

no_senders/count(distinct date_trunc(day, block_timestamp)) as average_sender_day

from ethereum.core.ez_token_transfers

where SYMBOL='USDC'

and contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'

and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}}

and RAW_AMOUNT>0

group by 1,2

union all

'Optimism' as chain,

WHEN RAW_AMOUNT/1e6 < 5 then 'a. Below 5'

WHEN RAW_AMOUNT/1e6 < 100 then 'b. 5 - 100'

WHEN RAW_AMOUNT/1e6 < 500 then 'c. 100 - 500'

WHEN RAW_AMOUNT/1e6 < 2000 then 'd. 500 - 2,000'

WHEN RAW_AMOUNT/1e6 < 10000 then 'e. 2,000 - 10,000'

WHEN RAW_AMOUNT/1e6 >= 10000 then 'f. Over 10,000'

end as gp,

count(distinct tx_hash) as no_transfers,

count(distinct FROM_ADDRESS) as no_senders,