with ETHEREUM_TO_OPTIMISM as (select symbol, count (DISTINCT origin_from_address) as number_of_users,
count (distinct tx_hash) as number_of_transactions, ifnull((sum(amount_usd)),0) as volume, 'Ethereum_to_Optimism' as type_of_bridge
from ethereum.core.ez_token_transfers
where symbol in ('USDC', 'USDT', 'LUSD') and block_timestamp >= '2022-01-01' and block_timestamp <= CURRENT_DATE - 1 and
to_address ilike '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
group by 1)
select * from ETHEREUM_TO_OPTIMISM