select

date_trunc('day', block_timestamp) as date,

'Ethereum' as chain,

count(distinct tx_hash) as count,

count(distinct from_address) as senders,

count(distinct to_address) as receivers,

sum(amount) as volume,

avg(amount) as average_size,

sum(count) over (order by date) as cum_count,

sum(volume) over (order by date) as cum_volume

from ethereum.core.ez_token_transfers

where

date >= '{{start_date}}' and date <= '{{end_date}}' and

contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'

group by 1, 2

union all

select

date_trunc('day', block_timestamp) as date,

'Optimism' as chain,

count(distinct tx_hash) as count,