freemartianDaily Average ETH
    Updated 2022-06-22


    select
    sum(amount_usd)/count(distinct tx_hash) as Average,
    date_trunc('Day', block_timestamp) as TIME,
    case
    when origin_to_address = '0xa0c68c638235ee32657e8f720a23cec1bfc77c77' then 'Polygon'
    when origin_to_address = '0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031ef' then 'Arbitrum'
    when origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1' then 'Optimism'
    when origin_to_address = lower('0xb8901acB165ed027E32754E0FFe830802919727f') then 'Hop'
    end as Native_Bridge
    from ethereum.core.ez_eth_transfers
    where origin_to_address in (
    '0xa0c68c638235ee32657e8f720a23cec1bfc77c77',
    '0x72ce9c846789fdb6fc1f34ac4ad25dd9ef7031ef',
    '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1',
    lower('0xb8901acB165ed027E32754E0FFe830802919727f'))
    and block_timestamp > CURRENT_DATE - 60
    and block_timestamp > '2022-01-01'
    group by TIME, Native_Bridge

    Run a query to Download Data