mz0111inflow outflow 6
    Updated 2023-01-13
    select
    date_trunc(day,BLOCK_TIMESTAMP) as date ,
    case when ORIGIN_TO_ADDRESS ='0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' then 'Ethereum to Optimistm'
    when ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1' then 'Optimism to Ethereum'
    end as bridge_type ,
    count (DISTINCT tx_hash) num_bridges_ ,
    count (DISTINCT ETH_FROM_ADDRESS ) num_wallets_,
    sum (amount ) volume ,
    sum (AMOUNT_USD) volume_usd ,
    sum (volume) over (partition by bridge_type order by date ) cum_volume ,
    sum (volume_usd) over (partition by bridge_type order by date ) cum_volume_usd
    from ethereum.core.ez_eth_transfers
    WHERE DATE >= CURRENT_DATE - 30
    group by 1,2
    having bridge_type is not NULL
    Run a query to Download Data