flipside

    2.block num per minute
    ZSaed2.block num per minute
    Updated 2023-02-01
    select
    date_trunc('day',BLOCK_TIMESTAMP) as day,
    count(DISTINCT TX_HASH) as TX_HASH,
    count(DISTINCT TX_HASH)/1440 as TX_STATUSnum
    FROM near.core.fact_transactions
    where BLOCK_TIMESTAMP::date< '2023-02-01'
    GROUP by day
    Run a query to Download Data