SPORTPASShomely-tomato
Updated 2024-09-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH RevealedGBs AS (
SELECT DISTINCT
EVENT_DATA:"id" AS id,
EVENT_DATA:"to" AS to_address,
BLOCK_TIMESTAMP AS reveal_timestamp,
TX_ID AS reveal_tx_id
FROM flow.core.fact_events
WHERE
EVENT_CONTRACT LIKE '%AFLNFT%'
AND EVENT_TYPE = 'Deposit'
AND TX_SUCCEEDED = 'TRUE'
AND EVENT_DATA:"from" = '0x8f9231920da9af6d'
AND EVENT_DATA:"to" :: STRING = '0x64222cd5d597d23b'
)
SELECT
id,
to_address,
reveal_timestamp,
reveal_tx_id
FROM RevealedGBs
ORDER BY reveal_timestamp;
QueryRunArchived: QueryRun has been archived