Pmisha-bmlMdxcomparison
    Updated 2022-06-06
    with t1 as (SELECT
    date_trunc('day',BLOCK_TIMESTAMP) as dt1,
    TX_SUCCEEDED,
    count(TX_ID)/1440 as tpm_flow
    from flow.core.fact_transactions
    where BLOCK_TIMESTAMP>='2022-05-09'
    group by 1,2),

    t2 as (SELECT
    date_trunc('day',BLOCK_TIMESTAMP) as dt2,
    SUCCEEDED,
    count(TX_ID)/1440 as tpm_solana
    from flipside_prod_db.solana.fact_transactions
    where BLOCK_TIMESTAMP>='2022-05-09'
    group by 1,2),

    t3 as (SELECT
    date_trunc('day',BLOCK_TIMESTAMP) as dt3,
    STATUS,
    count(TX_HASH)/1440 as tpm_ETH
    from flipside_prod_db.ethereum_core.fact_transactions
    where BLOCK_TIMESTAMP>='2022-05-09'
    group by 1,2)



    select t1.dt1 as dt,
    tpm_flow,
    tpm_solana,
    tpm_ETH
    from t1 join t2 on t1.dt1=t2.dt2
    join t3 on t1.dt1=t3.dt3
    Run a query to Download Data