Updated 2022-07-20
    with tb1 as (select
    date_trunc('day', minute) as day,
    max (count_txn) as TPM_near
    from (
    select
    date_trunc('minute', block_timestamp) as minute,
    count(TXN_HASH) as count_txn
    from flipside_prod_db.mdao_near.transactions
    WHERE block_timestamp >= CURRENT_DATE - 60
    and TXN_HASH is not null
    group by 1
    )
    where day > current_date - 60
    group by 1),

    tb2 as (select
    date_trunc('day', minute) as day,
    max (count_txn) as TPM_flow
    from (
    select
    date_trunc('minute', block_timestamp) as minute,
    count(tx_id) as count_txn
    from flow.core.fact_transactions
    WHERE block_timestamp >= CURRENT_DATE - 60
    and tx_id is not null
    group by 1
    )
    where day > current_date - 60
    group by 1),

    tb3 as (select
    date_trunc('day', minute) as day,
    max (count_txn) as TPM_Ethereum
    from (
    select
    date_trunc('minute', block_timestamp) as minute,
    Run a query to Download Data