datavortexpetra active wallets (deposits)
Updated 2025-02-06
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 petra_wallets AS (
SELECT DISTINCT owner_address
FROM aptos.core.dim_aptos_names
WHERE domain ILIKE 'petra'
)
SELECT
ft.account_address,
SUM(ft.amount) AS total_amount,
ft.token_address
FROM
aptos.core.fact_transfers ft
JOIN
petra_wallets pw
ON
ft.account_address = pw.owner_address
WHERE
ft.transfer_event = 'DepositEvent'
GROUP BY
ft.account_address, ft.token_address;
/*
WITH petra_wallets AS (
SELECT DISTINCT owner_address
FROM aptos.core.dim_aptos_names
WHERE domain ILIKE 'petra'
),
token_prices AS (
SELECT
token_address,
symbol,
decimals,
AVG(price) AS avg_price_usd
FROM
aptos.price.ez_prices_hourly
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived