keshanUntitled Query
Updated 2022-07-23
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
/* 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