mo1152023-12-10 01:49 AM copy
Updated 2023-12-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH NAMES AS (
SELECT TX_HASH ,
DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DATE,
EVENT_DATA:"domain_name" AS domain_name,
EVENT_DATA:"registration_fee_octas"/1E8 AS amount ,
DATEADD(s, EVENT_DATA:"expiration_time_secs", '1970-01-01 00:00:00.000') as expiration_Date
FROM aptos.core.fact_events
WHERE PAYLOAD_FUNCTION = '0x867ed1f6bf916171b1de3ee92849b8978b7d1b9e0a8cc982a3d19d535dfd9c0c::router::register_domain'
AND EVENT_RESOURCE = 'RegisterNameEvent'
),
ADDRESSES AS (
SELECT ACCOUNT_ADDRESS as address,
TX_HASH
FROM aptos.core.fact_events
WHERE PAYLOAD_FUNCTION = '0x867ed1f6bf916171b1de3ee92849b8978b7d1b9e0a8cc982a3d19d535dfd9c0c::router::register_domain'
AND EVENT_RESOURCE = 'WithdrawEvent'
)
select b.address, b.TX_HASH ,DATE,domain_name,amount ,expiration_Date
from names a left join ADDRESSES b on a.TX_HASH=b.TX_HASH
Run a query to Download Data