Specterduration active addeess
Updated 2024-11-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- Active Addresses (Last 24 hours, Last 30 days, Total)
SELECT
COUNT(DISTINCT CASE
WHEN block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '24 hours' THEN sender
END) AS active_addresses_24h,
COUNT(DISTINCT CASE
WHEN block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 days' THEN sender
END) AS active_addresses_30d,
COUNT(DISTINCT sender) AS total_active_addresses
FROM
aptos.core.fact_transactions
WHERE
tx_type = 'user_transaction'
AND success = TRUE
AND block_timestamp >= '2024-01-01';
QueryRunArchived: QueryRun has been archived