KaskoazulFailed from addresses
Updated 2022-03-20
999
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 FAIL1 as (
select tx_from as tx_from_1,
--tx_id,
count(distinct tx_id) as failed_1
from terra.transactions
where block_timestamp::date = '2021-11-24'
and tx_status = 'FAILED'
group by 1
order by 2 desc
LIMIT 10
),
FAIL2 as (
select tx_from as tx_from_2,
--tx_id,
count(distinct tx_id) as failed_2
from terra.transactions
where block_timestamp::date = '2021-12-03'
and tx_status = 'FAILED'
group by 1
order by 2 desc
LIMIT 10
),
FAIL3 as (
select tx_from as tx_from_3,
--tx_id,
count(distinct tx_id) as failed_3
from terra.transactions
where block_timestamp::date = '2021-12-08'
and tx_status = 'FAILED'
group by 1
order by 2 desc
LIMIT 10
),
Run a query to Download Data