with Ethereum as (select

'Ethereum' as chain,

count(distinct tx_hash) as no_transfers,

count(distinct FROM_ADDRESS) as no_senders,

count(distinct TO_ADDRESS) as no_receivers,

sum(AMOUNT) as volume_usd,

avg(AMOUNT) as avg_volume,

median(AMOUNT) as median_volume,

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

volume_usd/count(distinct date_trunc(day, block_timestamp)) as average_volume_day,

volume_usd/count(distinct BLOCK_NUMBER) as average_volume_block

from ethereum.core.ez_token_transfers

where SYMBOL='USDC'

and contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'

and from_address != '0x0000000000000000000000000000000000000000'

and to_address != '0x0000000000000000000000000000000000000000'

and BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period}}

),

Optimism as (select

'Optimism' as chain,

count(distinct tx_hash) as no_transfers,

count(distinct FROM_ADDRESS) as no_senders,

count(distinct TO_ADDRESS) as no_receivers,

sum(RAW_AMOUNT/1e6) as volume_usd,

avg(RAW_AMOUNT/1e6) as avg_volume,

median(RAW_AMOUNT/1e6) as median_volume,

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

volume_usd/count(distinct date_trunc(day, block_timestamp)) as average_volume_day,

volume_usd/count(distinct BLOCK_NUMBER) as average_volume_block

from optimism.core.fact_token_transfers

where CONTRACT_ADDRESS=lower('0x7F5c764cBc14f9669B88837ca1490cCa17c31607')

and from_address != '0x0000000000000000000000000000000000000000'

and to_address != '0x0000000000000000000000000000000000000000'