victor-sanzcapdetPixel Pirates Sales Across Different Marketplaces
    Updated 2025-01-28
    SELECT
    PLATFORM_NAME,
    COUNT(TX_HASH) AS TOTAL_SALES,
    SUM(TOTAL_PRICE_USD) AS TOTAL_SALES_VOLUME
    FROM
    aptos.nft.ez_nft_sales
    WHERE
    PROJECT_NAME = 'Pixel Pirates'
    AND BLOCK_TIMESTAMP >= DATEADD({{Period}}, -1, CURRENT_DATE)
    GROUP BY
    PLATFORM_NAME
    ORDER BY
    TOTAL_SALES_VOLUME DESC;

    Last run: 3 months ago
    PLATFORM_NAME
    TOTAL_SALES
    TOTAL_SALES_VOLUME
    1
    Wapal680.8548574
    1
    24B
    2s