KaskoazulSent-to addresses vs failures
Updated 2022-03-21
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 SUCCESS as (
select block_timestamp::date as fecha,
tx_status,
count(distinct tx_id) as successful_txs
from terra.transactions
where fecha >= '2021-11-01'--(fecha = '2021-11-24' or fecha = '2021-12-03' or fecha = '2021-12-08')
and tx_status = 'SUCCEEDED'
group by 1,2
),
FAIL as (
select block_timestamp::date as fecha,
count(distinct tx_id) as failed_txs
from terra.transactions
where fecha >= '2021-11-01'--(fecha = '2021-11-24' or fecha = '2021-12-03' or fecha = '2021-12-08')
and tx_status = 'FAILED'
group by 1
),
SUCCESS_TOP as (
select block_timestamp::date as fecha,
tx_status,
count(distinct tx_id) as successful_txs
from terra.transactions
where fecha >= '2021-11-01'--(fecha = '2021-11-24' or fecha = '2021-12-03' or fecha = '2021-12-08')
and tx_status = 'SUCCEEDED'
and tx_to[0] = 'terra17e6u8gq0m0tq8gcvdul2nqqxl2gwcpwp77leu5'
group by 1,2
),
FAIL_TOP as (
select block_timestamp::date as fecha,
count(distinct tx_id) as failed_txs
from terra.transactions
Run a query to Download Data