ramishoowUntitled Query
Updated 2023-01-10
9
1
2
3
4
›
⌄
with ramishoow as ( select date_trunc('day', block_timestamp) as date_day, date_trunc('min', block_timestamp), count(*) as count1 from ethereum.core.fact_transactions
group by 1,2 ) select date_day as date1, avg(count1/60) as Avg, max(count1/60) as Max, min(count1/60) as Min from ramishoow where date1 > current_date - 60
--group by 1,2 ) select date_day as date1, avg(count1/60) as Avg, max(count1/60) as Max, min(count1/60) as Min from ramishoow where date1 > current_date - 60
group by 1 order by 1