nickpayiatis_Untitled Query
    Updated 2022-01-25
    with successful_tx as(
    select date_trunc('minute',block_timestamp) as blockconfirm,count(tx_id) as successfultxs from solana.transactions where blockconfirm > '2022-01-19 00:00:00.000' and TRANSFER_TX_FLAG = 'true' group by blockconfirm),
    failed_tx as(
    select date_trunc('minute',block_timestamp) as blockconfirm,count(tx_id) as failedtxs from solana.transactions where blockconfirm > '2022-01-19 00:00:00.000' and TRANSFER_TX_FLAG = 'false' group by blockconfirm)

    select sx.blockconfirm as date_minute, sx.successfultxs as successful_tx, ft.failedtxs as failed_tx from successful_tx sx left join failed_tx ft on sx.blockconfirm = ft.blockconfirm

    Run a query to Download Data