keshanUntitled Query
    Updated 2022-07-23
    /* select count(*) from (select time, ifnull(f.address_name, ETH_FROM_ADDRESS) as eth_from_address, ifnull(t.address_name, eth_to_address) as ETH_TO_ADDRESS, amount from
    (
    select min(date_trunc(hour, block_timestamp)) as time, eth_from_address, ETH_TO_ADDRESS,
    sum(AMOUNT) as amount
    from optimism.core.ez_eth_transfers
    group by ETH_FROM_ADDRESS, ETH_TO_ADDRESS
    having count(*) > 2
    order by time)
    left join optimism.core.dim_labels f on f.address=eth_from_address
    left join optimism.core.dim_labels t on t.address=eth_to_address) */

    select min(block_timestamp) from optimism.core.ez_eth_transfers
    Run a query to Download Data