Updated 7 days ago
    SELECT
    PLATFORM_NAME,
    COUNT(DISTINCT BUYER_ADDRESS) AS unique_buyers,
    COUNT(DISTINCT SELLER_ADDRESS) AS unique_sellers
    FROM
    aptos.nft.ez_nft_sales
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
    GROUP BY
    PLATFORM_NAME
    ORDER BY
    unique_buyers DESC
    Last run: 7 days ago
    PLATFORM_NAME
    UNIQUE_BUYERS
    UNIQUE_SELLERS
    1
    Wapal269297
    2
    Mercato135170
    3
    BlueMove1920
    4
    Topaz1614
    5
    Souffl312
    5
    90B
    2s