op_eth_dep as (

select

block_timestamp,

tx_hash,

eth_from_address,

eth_to_address,

case when eth_to_address='0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' then 'main bridge' else 'warp bridge' end as bridge,

'ETH' as symbol,

amount,

amount_usd

from ethereum.core.ez_eth_transfers

where eth_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- main bridge

or eth_to_address = '0x52ec2f3d7c5977a8e558c8d9c6000b615098e8fc' -- warp bridge

),

op_erc_dep as (

select

block_timestamp,

tx_hash,

origin_from_address,

to_address,

case when to_address='0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' then 'main bridge' else 'warp bridge' end as bridge,

symbol,

amount,

amount_usd

from ethereum.core.ez_token_transfers

where to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' -- main bridge

select

symbol,

count(distinct origin_from_address) as users,

count(distinct tx_hash) as bridges,

sum(amount) as aseet_vol,

sum(amount_usd) as usd_vol

from (