Arkanstatistic 1
Updated 2023-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH
table1 as ( -- success near
SELECT
block_timestamp,
tx_hash,
tx_status,
substr(split(tx:"actions"[0], ':')[0], 3, len(split(tx:"actions"[0], ':')[0])-3) as action
FROM
near.core.fact_transactions
WHERE block_timestamp::date >= '2022-12-1'
),
s_ as ( -- success
SELECT
date_trunc('day', block_timestamp) as date,
action,
count(*) as tx_count
FROM
table1
WHERE tx_status = 'Success'
GROUP BY date, action
),
f_ as ( -- fail
SELECT
date_trunc('day', block_timestamp) as date,
action,
count(*) as tx_count
FROM
table1
WHERE tx_status = 'Fail'
GROUP BY date, action
)
SELECT
s_.date,
CASE WHEN s_.action = 'eateAccoun' THEN 'CreateAccount' ELSE s_.action END action,
s_.tx_count as success_count,
f_.tx_count as fail_count,
Run a query to Download Data