SUBDOMAIN | SYMBOL | ACCOUNT_ADDRESS | TOTAL_INFLOW_AMOUNT | TOTAL_OUTFLOW_AMOUNT | TOTAL_NETFLOW_AMOUNT | TOKEN_ADDRESS | DECIMALS | AVG_PRICE_USD | CURRENT_PRICE | PRICE_CHANGE_24HR_PERCENTAGE | PRICE_CHANGE_7D_PERCENTAGE | PRICE_CHANGE_24HR_ | PRICE_CHANGE_7D_ | INFLOW_AMOUNT_USD | OUTFLOW_AMOUNT_USD | NETFLOW_AMOUNT_USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | datavortex | APT | 0xb1a61deb6a03a96c46d4af80d6d7dd9eac4c4c766144440b10df81d9674097f2 | 27.49873795 | -27.49870195 | 0.000036 | 0x1::aptos_coin::AptosCoin | 8 | 9.063027861 | 6.05 | 1.851851852 | -2.576489533 | 🟢1.85% | 🔴-2.58% | 249.221828183 | -249.221501914 | 0.000326269003 |
datavortexCheck How Your Petra Wallet Is Doing
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 petra_wallets AS (
SELECT
DISTINCT owner_address,
domain,
subdomain
FROM
aptos.core.dim_aptos_names
WHERE
domain ILIKE 'petra'
),
token_price_and_decimal AS (
SELECT
token_address,
symbol,
decimals,
avg_price_usd,
current_price,
price_change_24hr_percentage,
price_change_7d_percentage
FROM
$query('429f43dd-57d4-4933-b2f5-f9f681235506')
),
UserTransfers AS (
SELECT
ft.account_address,
CASE
WHEN ft.transfer_event = 'DepositEvent' THEN ft.amount
ELSE 0
END AS inflow_amount,
CASE
WHEN ft.transfer_event = 'WithdrawEvent' THEN - ft.amount
ELSE 0
END AS outflow_amount,
(
CASE
WHEN ft.transfer_event = 'DepositEvent' THEN ft.amount
Last run: 2 months agoAuto-refreshes every 12 hours
1
267B
4s