DATE | ACTIVE_ADDRESSES | TOTAL_TRANSACTIONS | SUCCESSFUL_TRANSACTIONS | FAILED_TRANSACTIONS | FEES | FEE_DENOM | |
---|---|---|---|---|---|---|---|
1 | 2024-01-23 00:00:00.000 | 40850 | 365445 | 364093 | 1352 | 1001908732 | uatom |
2 | 2024-01-22 00:00:00.000 | 33252 | 329497 | 328132 | 1365 | 730499067 | uatom |
3 | 2024-01-21 00:00:00.000 | 38987 | 419566 | 418099 | 1467 | 806684111 | uatom |
4 | 2024-01-20 00:00:00.000 | 36278 | 335667 | 334004 | 1663 | 816574432 | uatom |
5 | 2024-01-19 00:00:00.000 | 40048 | 976163 | 972830 | 3333 | 1148809790 | uatom |
6 | 2024-01-18 00:00:00.000 | 43502 | 1000657 | 998013 | 2644 | 1415083917 | uatom |
7 | 2024-01-17 00:00:00.000 | 48512 | 1133734 | 1131750 | 1984 | 2110913562 | uatom |
8 | 2024-01-16 00:00:00.000 | 39445 | 109093 | 107687 | 1406 | 638671506 | uatom |
9 | 2024-01-15 00:00:00.000 | 48727 | 120093 | 117315 | 2778 | 693216764 | uatom |
10 | 2024-01-14 00:00:00.000 | 38890 | 109270 | 107504 | 1766 | 651674695 | uatom |
11 | 2024-01-13 00:00:00.000 | 33012 | 89973 | 88374 | 1599 | 574599816 | uatom |
12 | 2024-01-12 00:00:00.000 | 33447 | 89417 | 87482 | 1935 | 561308604 | uatom |
13 | 2024-01-11 00:00:00.000 | 43403 | 110519 | 108408 | 2111 | 703259921 | uatom |
14 | 2024-01-10 00:00:00.000 | 48605 | 119597 | 113647 | 5950 | 646236265 | uatom |
15 | 2024-01-09 00:00:00.000 | 51484 | 134130 | 116413 | 17717 | 739652833 | uatom |
16 | 2024-01-08 00:00:00.000 | 34695 | 102755 | 100177 | 2578 | 754313811 | uatom |
17 | 2024-01-07 00:00:00.000 | 34115 | 100467 | 98320 | 2147 | 716477265 | uatom |
18 | 2024-01-06 00:00:00.000 | 35294 | 108165 | 102067 | 6098 | 728025012 | uatom |
19 | 2024-01-05 00:00:00.000 | 40330 | 109055 | 107081 | 1974 | 820009741 | uatom |
20 | 2024-01-04 00:00:00.000 | 46127 | 128138 | 125015 | 3123 | 910485454 | uatom |
messaricomos-activity
Updated 2024-01-23
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 base as (
SELECT
date(block_timestamp) as date,
fee,
fee_denom,
tx_from,
tx_succeeded
from
cosmos.core.fact_transactions
),
fees as (
select
date,
sum(fee) as fees,
'uatom' as fee_denom
from
base
where
fee_denom = 'uatom'
group by
1
),
activity as (
select
date,
count(distinct tx_from) as active_addresses,
count(*) as total_transactions,
sum(
case
tx_succeeded
when true then 1
else 0
end
) as successful_transactions,
sum(
case
Last run: about 1 year ago
...
1202
73KB
42s