OPTIMISM_TO_ETHEREUM as (select date_trunc('week',block_timestamp) as week, 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, 'Optimism_to_Ethereum' as tyoe_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

origin_to_address ilike '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1' group by 1,2)

select * from OPTIMISM_TO_ETHEREUM