flipside

    Avalanche transactions per minute over time
    articoloquintoAvalanche transactions per minute over time
    Updated 2022-07-16
    select count(*)/1440 as "transactions per minute", date_trunc('day', BLOCK_TIMESTAMP) as "date"
    from avalanche.core.fact_transactions
    where BLOCK_TIMESTAMP between '2022-06-14' and '2022-07-14'
    group by 2
    order by 2 asc
    Run a query to Download Data