pouya_22NEAR Performance - Compare Near with Ethereum
    Updated 2022-07-21
    with near as (select
    block_timestamp::date as date,
    count(distinct txn_hash) / (24 * 60) as tx_per_min
    from flipside_prod_db.mdao_near.transactions
    group by 1),

    eth as (select
    block_timestamp::date as date,
    count(distinct tx_hash) / (24 * 60) as tx_per_min
    from ethereum.core.fact_transactions
    where date > (select min(date) from near)
    group by 1)

    select 'Near' as blockchain, * from near
    union
    select 'Ethereum' as blockchain, * from eth
    Run a query to Download Data