Max2022Solana speed
Updated 2022-06-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH succeed_SOLANA AS (select date_trunc('minute', block_timestamp) AS time,count(tx_id) AS transactions,'TRUE' AS succeeded_type
From flipside_prod_db.solana.fact_transactions
Where date_trunc('day', block_timestamp)>='2022-04-09'
AND succeeded='TRUE'
Group by time
ORDER BY time
--LIMIT 10
),
unsucceed_SOLANA AS (select date_trunc('minute', block_timestamp) AS time,count(tx_id) AS transactions,'FALSE' AS succeeded_type
From flipside_prod_db.solana.fact_transactions
Where date_trunc('day', block_timestamp)>='2022-04-09'
AND succeeded='FALSE'
Group by time
ORDER BY time
--LIMIT 10
)
SELECT * FROM succeed_SOLANA
UNION
SELECT * FROM unsucceed_SOLANA
ORDER BY time
--LIMIT 10
Run a query to Download Data