with all_chain as (

select

from_address as sender,

'Ethereum' as chain,

sum(amount) as volume

from ethereum.core.ez_token_transfers

where

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

contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' and

amount > 0 and

from_address != '0x0000000000000000000000000000000000000000' and

to_address != '0x0000000000000000000000000000000000000000'

group by 1, 2

union all

select

from_address as sender,

'Optimism' as chain,

sum(raw_amount/1e6) as volume

from optimism.core.fact_token_transfers

where

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

contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607' and