Popex404Total Metrics Users & Last Month/Day
Updated 2023-02-19Copy Reference Fork
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
›
⌄
SELECT
'Total' as "Type",
count (distinct tx_from) as "Total Users",
count (*) as "Successful Transactions",
min (block_timestamp) as "Min Date"
FROM cosmos.core.fact_transactions
where tx_succeeded = true
Group by 1
Union ALL
SELECT
'Last Month' as "Type",
count (distinct tx_from) as "Total Users",
count (*) as "Successful Transactions",
min (block_timestamp) as "Min Date"
FROM cosmos.core.fact_transactions
where tx_succeeded = true
and block_timestamp >= CURRENT_DATE - 31
Group by 1
Union ALL
SELECT
'Last 24 Hours' as "Type",
count (distinct tx_from) as "Total Users",
count (*) as "Successful Transactions",
min (block_timestamp) as "Min Date"
FROM cosmos.core.fact_transactions
where tx_succeeded = true
and block_timestamp >= CURRENT_DATE - 1
Group by 1
Run a query to Download Data