0xaimanMinimum Transaction in a Block
    Updated 2022-06-27
    /*select n_txn::string as number of txn, count(block_number) as n_block
    from (*/
    select min(n_txn) as min_txn, block_number, block_timestamp
    from (select block_number,block_timestamp, count(tx_hash) as n_txn from avalanche.core.fact_transactions

    group by 1,2 order by 3 asc )

    group by 1
    /*)

    where n_txn=1

    group by 1

    limit 10000
    */
    Run a query to Download Data