SPORTPASShomely-tomato
    Updated 2024-09-23
    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