legionUntitled Query
Updated 2022-12-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
Select date_trunc('minute', block_timestamp) as date,
count(DISTINCT tx_id) as trx_count,
'Total' as type
From flow.core.fact_transactions
Where date(block_timestamp) >='2022-01-01'
and date < CURRENT_DATE - 1
Group by date
UNION
Select date_trunc('minute', block_timestamp) as date,
count(DISTINCT tx_id) as trx_count,
'Successful' as type
From flow.core.fact_transactions
Where date(block_timestamp) >='2022-01-01'
and TX_SUCCEEDED = 'TRUE'
and date < CURRENT_DATE - 1
Group by date
Run a query to Download Data