SocioAnalyticatotal txns
Updated 2024-10-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 all_txns as (
SELECT
block_timestamp,
tx_id
FROM cosmos.core.fact_msg_attributes
WHERE msg_type = 'message'
AND ATTRIBUTE_KEY = 'action'
AND
ATTRIBUTE_VALUE = '/cosmos.bank.v1beta1.MsgSend'
AND TX_SUCCEEDED
AND block_timestamp :: date >= '2024-01-17'
)
,
fee_payer as (
SELECT
count(DISTINCT ATTRIBUTE_VALUE) as n_unique_wallet
from cosmos.core.fact_msg_attributes a
JOIN all_txns b ON a.tx_id = b.tx_id
WHERE msg_type = 'tx' and ATTRIBUTE_KEY = 'fee_payer'
AND a.block_timestamp :: date >= '2024-01-17'
)
,
total_txns as (
SELECT
count(DISTINCT tx_id) as mint
FROM all_txns
)
SELECT
mint,
n_unique_wallet
FROM total_txns a
JOIN fee_payer b ON TRUE
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived