datavortexextra-azure
Updated 2025-01-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH labeled_addresses AS (
SELECT DISTINCT owner_address
FROM aptos.core.dim_aptos_names
WHERE domain ILIKE 'petra'
)
SELECT
COUNT(DISTINCT ft.tx_hash) AS total_withdraw_transactions
FROM
aptos.core.fact_transfers ft
JOIN
labeled_addresses la
ON
ft.account_address = la.owner_address
WHERE
ft.transfer_event = 'WithdrawEvent';
QueryRunArchived: QueryRun has been archived