snowmanUntitled Query
Updated 2022-07-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH a AS (select date_trunc('second', block_timestamp) AS seconds,count(tx_id) AS transactions,'Successful' AS status
From solana.core.fact_transactions
Where date_trunc('day', block_timestamp)>='2022-07-01'
AND date_trunc('day', block_timestamp)<'2022-07-02'
AND succeeded='TRUE'
Group by seconds
ORDER BY seconds
LIMIT 500
),
b AS (select date_trunc('second', block_timestamp) AS seconds,count(tx_id) AS transactions,'Fail' AS status
From solana.core.fact_transactions
Where date_trunc('day', block_timestamp)>='2022-07-01'
AND date_trunc('day', block_timestamp)<'2022-07-02'
AND succeeded='FALSE'
Group by seconds
ORDER BY seconds
LIMIT 250
)
SELECT * FROM a
UNION
SELECT * FROM b
ORDER BY seconds
Run a query to Download Data