nickpayiatis_Untitled Query
Updated 2022-01-25
9
1
2
3
4
5
6
7
›
⌄
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