sinahosseinzadehUntitled Query
    Updated 2022-08-06
    select 'L1 to L2' as type,
    t1.block_timestamp::date as date,
    count (distinct t1.tx_hash) as TX_Count,
    count (distinct t1.origin_from_address) as Bridgers,
    sum (amount) as Volume,
    sum (volume) over (order by date) as Cumulative_Volume
    From ethereum.core.ez_eth_transfers t1
    where (t1.ORIGIN_TO_ADDRESS = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' or t1.ORIGIN_TO_ADDRESS = '0x52ec2f3d7c5977a8e558c8d9c6000b615098e8fc')
    and t1.block_timestamp >= '2022-07-01' and t1.block_timestamp < '2022-08-01'
    group by 1,2

    UNION

    select 'L2 to L1' as type,
    t1.block_timestamp::date as date,
    count (distinct t1.tx_hash) as TX_Count,
    count (distinct t1.origin_from_address) as Bridgers,
    sum (amount) as Volume,
    sum (volume) over (order by date) as Cumulative_Volume
    From ethereum.core.ez_token_transfers t1
    where t1.ORIGIN_TO_ADDRESS = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
    and t1.block_timestamp >= '2022-07-01' and t1.block_timestamp < '2022-08-01'
    group by 1,2

    order by 2
    Run a query to Download Data