Updated 2025-03-27
    SELECT COUNT(distinct tokenid) AS total_sales,
    COUNT(distinct buyer_address) as buyers,
    COUNT(distinct seller_address) as sellers,
    SUM(total_price_usd) as volume_usd,
    min(total_price_usd) as floor_price_usd,
    avg(total_price_usd) as avg_price_usd
    FROM aptos.nft.ez_nft_sales
    WHERE PROJECT_NAME = 'Amnis Draconian' AND BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)


    Last run: 18 days ago
    TOTAL_SALES
    BUYERS
    SELLERS
    VOLUME_USD
    FLOOR_PRICE_USD
    AVG_PRICE_USD
    1
    39114931723509.03029211411.9245.560136225
    1
    50B
    2s