Abbas_ra21 transactions per minute
    Updated 2022-07-20
    select
    'NEAR' AS chain,
    date_trunc('day', BLOCK_TIMESTAMP) as day,
    sum(TX_COUNT)/1440 AS TPM
    from flipside_prod_db.mdao_near.blocks where day >= '2022-06-15'
    group by 2
    UNION
    select
    'BNB CHAIN' AS chain,
    DATE_TRUNC ('day' ,BLOCK_TIMESTAMP) AS Day,
    sum(TX_COUNT)/1440 AS TPM
    from bsc.core.fact_blocks where day >= '2022-06-15'
    GROUP BY 2
    UNION
    select
    'FLOW' AS chain,
    DATE_TRUNC ('day' ,BLOCK_TIMESTAMP) AS Day,
    sum(TX_COUNT)/1440 AS TPM
    from flow.core.fact_blocks where day >= '2022-06-15'
    GROUP BY 2
    UNION
    select
    'Ethereum' AS chain,
    DATE_TRUNC ('day' ,BLOCK_TIMESTAMP) AS Day,
    sum(TX_COUNT)/1440 AS TPM
    from ethereum.core.fact_blocks where day >= '2022-06-15'
    GROUP BY 2
    Run a query to Download Data