'AVALANCHE' as chain

,sum(AMOUNT) as volume

,avg(AMOUNT) as avg_volume

,count(distinct FROM_ADDRESS) as senders

,count(distinct TO_ADDRESS) as receivers

,count(distinct TX_HASH) as transfers

,senders+receivers as transmitters

from avalanche.core.ez_token_transfers

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

group by 1

union all

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

'ARBITRUM' as chain

,sum(AMOUNT) as volume

,avg(AMOUNT) as avg_volume

,count(distinct FROM_ADDRESS) as senders

,count(distinct TO_ADDRESS) as receivers

,count(distinct TX_HASH) as transfers

,senders+receivers as transmitters

from arbitrum.core.ez_token_transfers

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

group by 1

union all

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

'OPTIMISM' as chain

,sum(AMOUNT) as volume

,avg(AMOUNT) as avg_volume

,count(distinct FROM_ADDRESS) as senders

,count(distinct TO_ADDRESS) as receivers

,count(distinct TX_HASH) as transfers

,senders+receivers as transmitters

from optimism.core.ez_token_transfers

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

group by 1

union all