mariyaTotal Bridges ( from Ethreum to Optimism )
    Updated 2022-09-12
    with ETHTable as (
    select block_timestamp::date as date,
    tx_hash,
    origin_from_address,
    amount_usd
    from ethereum.core.ez_eth_transfers
    where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
    and block_timestamp >= '2022-01-01'),
    TokenTable as (
    select block_timestamp::date as date,
    tx_hash,
    origin_from_address,
    amount_usd
    from ethereum.core.ez_token_transfers
    where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
    and block_timestamp >= '2022-01-01'),

    L2toL1 as (
    select * from ethtable union all select * from tokentable),

    ETHTable1 as (
    select tx_hash,
    eth_from_address as origin_from_address,
    amount_usd
    from ethereum.core.ez_eth_transfers
    where eth_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'),
    TokenTable1 as (
    select tx_hash,
    origin_from_address,
    amount_usd
    from ethereum.core.ez_token_transfers
    where to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'),

    L1toL2 as (
    Run a query to Download Data