flipside

    Wallets that have opened a Pack
    SPORTPASSWallets that have opened a Pack
    Updated 2024-05-21

    -- SELECT DISTINCT event_data:receiptAddress as walletAddress -- DISTINCT WALLET_ADDRESS
    select *
    FROM flow.core.fact_events
    WHERE EVENT_CONTRACT = 'A.8f9231920da9af6d.AFLPack'
    -- AND EVENT_TYPE = 'PackOpened'

    QueryRunArchived: QueryRun has been archived