The Tiesemantic-plum
Updated 2024-11-27
999
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 /*-------------------------------------------
1) Filtered fact_changes (once)
---------------------------------------------*/
changes AS (
SELECT ft.*
FROM aptos.core.fact_changes ft
WHERE ft.block_timestamp BETWEEN '1741996800' AND '1742009487'
),
/*-----------------------------------------------
2) Filtered fact_events (once)
-----------------------------------------------*/
events AS (
SELECT fe.*
FROM aptos.core.fact_events fe
WHERE fe.block_timestamp BETWEEN '1741996800' AND '1742009487'
),
/*-----------------------------------------------
3) object_transfers_v2 (same logic,
but referencing the filtered CTEs)
-----------------------------------------------*/
object_transfers_v2 AS (
SELECT
ft.tx_hash,
ft.address AS object_addr,
fe.event_data:from AS from_address,
fe.event_data:to AS to_address,
ft.change_data:transfer_events:guid:id:addr AS token_id,
ft.change_data:transfer_events:counter AS counter,
1 AS value,
ft.change_data
FROM changes ft
JOIN events fe
ON fe.event_data:object = ft.address
AND ft.inner_change_type = '0x1::object::ObjectCore'
QueryRunArchived: QueryRun has been archived