ramishoowUntitled Query
    Updated 2023-01-10
    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