rezaramshiniNEAR Performance - 3
    Updated 2022-07-17
    SELECT count(DISTINCT TXN_HASH)/count(DISTINCT date_trunc('minute', BLOCK_TIMESTAMP)) as tx_per_minute_near, 'near' as chain
    from flipside_prod_db.mdao_near.transactions
    where BLOCK_TIMESTAMP::date >= '2022-04-01'
    -------------------------------------------------------------------------------
    UNION
    SELECT count(DISTINCT TX_HASH)/count(DISTINCT date_trunc('minute', BLOCK_TIMESTAMP)) as tx_per_minute_ETH, 'ETH' as chain
    from ethereum.core.fact_transactions
    where BLOCK_TIMESTAMP::date >= '2022-04-01'
    ------------------------------------------------------------------------------------
    UNION
    SELECT count(DISTINCT TX_ID)/count(DISTINCT date_trunc('minute', BLOCK_TIMESTAMP)) as tx_per_minute_flow, 'flow' as chain
    from flow.core.fact_transactions
    where BLOCK_TIMESTAMP::date >= '2022-04-01'
    Run a query to Download Data