ad_fanFlowverse Transactions
    Updated 2024-04-16
    SELECT
    BLOCK_TIMESTAMP,
    BLOCK_HEIGHT,
    TX_ID,
    EVENT_TYPE,
    EVENT_CONTRACT,
    event_data:listingResourceID,
    event_data:storefrontAddress AS "Listing User",
    event_data:purchased,
    event_data:nftType,
    event_data:nftUUID,
    event_data:nftID,
    event_data:salePrice AS "Sale Price",
    event_data:buyer,
    event_data:expiry,
    event_data:customID,
    event_data:salePaymentVaultType,
    FROM
    FLOW.CORE.FACT_EVENTS
    WHERE
    (
    EVENT_CONTRACT IN ('A.4eb8a10cb9f87357.NFTStorefrontV2')
    AND event_data:customID = 'flowverse-nft-marketplace' -- AND (event_data:nftType like '%TopShot.NFT%' OR event_data:nftType like '%AllDay.NFT%')
    AND event_data:nftType like '%AllDay.NFT%'
    )
    ORDER BY
    BLOCK_TIMESTAMP
    QueryRunArchived: QueryRun has been archived