PS0G1Distribution of bridges volume by price range
    Updated 2022-11-10
    --credit alik110
    with ETHTable as (
    select tx_hash,
    origin_from_address,
    amount_usd
    from ethereum.core.ez_eth_transfers
    where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
    and block_timestamp >= '2022-04-01'),
    TokenTable as (
    select tx_hash,
    origin_from_address,
    amount_usd
    from ethereum.core.ez_token_transfers
    where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
    and block_timestamp >= '2022-04-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'
    and block_timestamp >= '2022-04-01'),
    TokenTable1 as (
    select tx_hash,
    origin_from_address,
    amount_usd
    from ethereum.core.ez_token_transfers
    where to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
    and block_timestamp >= '2022-07-01'),

    Run a query to Download Data