TOTAL_PETRA_ADDRESSES | ACTIVE_ADDRESSES | |
|---|---|---|
1 | 84497 | 44491 |
datavortexcreated and active wallets
Updated 2025-03-09
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 total_addresses AS (
SELECT
DISTINCT owner_address
FROM
aptos.core.dim_aptos_names
WHERE
domain ILIKE 'petra'
)
SELECT
COUNT(DISTINCT fa.owner_address) AS total_petra_addresses,
COUNT(DISTINCT t.account_address) AS active_addresses
FROM
total_addresses fa
LEFT JOIN
aptos.core.fact_transfers t
ON
fa.owner_address = t.account_address;
/*
WITH total_addresses AS (
SELECT
DISTINCT owner_address
FROM
aptos.core.dim_aptos_names
WHERE
domain ILIKE 'petra'
)
SELECT
COUNT(DISTINCT fa.owner_address) AS total_petra_addresses,
COUNT(DISTINCT CASE WHEN t.amount > 0 THEN t.account_address END) AS active_addresses
FROM
total_addresses fa
LEFT JOIN
aptos.core.fact_transfers t
ON
Last run: about 2 months agoAuto-refreshes every 12 hours
1
15B
27s