Updated 5 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: 5 days ago
    PLATFORM_NAME
    UNIQUE_BUYERS
    UNIQUE_SELLERS
    1
    Wapal305432
    2
    Mercato89118
    3
    BlueMove2123
    4
    Topaz86
    4
    71B
    8s