flipside

    BNB Chain Feb Blocks*
    mo115BNB Chain Feb Blocks*
    Updated 2024-03-08
    -- forked from Litoshi / BNB Chain Feb Blocks @ https://flipsidecrypto.xyz/Litoshi/q/IZqIXAdcToRJ/bnb-chain-feb-blocks

    SELECT

    count(distinct block_number) as Total_Blocks,
    (Total_Blocks/(count (distinct date_trunc('day',block_timestamp)))) as avg_Daily_Blocks

    from bsc.core.fact_transactions
    where block_timestamp::date between '2024-02-01' and '2024-02-29'


    QueryRunArchived: QueryRun has been archived