cheeyoung-kekUntitled Query
    Updated 2022-09-08
    with near as(
    SELECT
    block_timestamp::date as date,
    substr(tx[0]:"outcome":"status",3,7) as status,
    COUNT(TX_HASH)/1440 AS near_tmp
    FROM flipside_prod_db.mdao_near.transactions
    WHERE block_timestamp::date > '2022-01-01'
    GROUP BY date, status

    ),
    sol as(
    SELECT
    block_timestamp::date as date,
    succeeded as status,
    COUNT(tx_id)/1440 AS sol_tmp
    FROM solana.core.fact_transactions
    WHERE (block_timestamp::date > '2022-01-01')
    GROUP BY date,status
    ),
    eth as(
    SELECT
    block_timestamp::date as date,
    status,
    COUNT(tx_hash)/1440 AS Eth_tmp
    FROM ethereum.core.fact_transactions
    WHERE (block_timestamp::date > '2022-01-01')
    GROUP BY date,status
    )




    Run a query to Download Data