KARTODTransactions
    Updated 2022-06-03
    WITH sol as(
    SELECT
    date_trunc('minute',block_timestamp) as dt,
    count (distinct TX_ID) as tx_solana
    from flipside_prod_db.solana.fact_transactions
    where tx_id is not NULL
    and block_timestamp >= '2022-05-09'
    group by 1
    ),

    eth as (
    SELECT
    date_trunc('minute',block_timestamp) as dt,
    count (distinct TX_ID) as tx_eth
    from ethereum.transactions
    where tx_id is not NULL
    and block_timestamp >= '2022-05-09'
    group by 1
    ),
    faild_tx AS (
    SELECT
    DATE_TRUNC('minute', BLOCK_TIMESTAMP) AS "Minute",
    COUNT(TX_ID) AS filed_txs
    FROM flow.core.fact_transactions
    WHERE BLOCK_TIMESTAMP > '2022-05-09'
    AND TX_SUCCEEDED = 0
    GROUP BY 1
    ),

    succ_tx AS (
    SELECT
    DATE_TRUNC('minute', BLOCK_TIMESTAMP) AS "Minute",
    COUNT(TX_ID) AS succ_txs
    FROM flow.core.fact_transactions
    WHERE BLOCK_TIMESTAMP > '2022-05-09'
    Run a query to Download Data