Updated 2025-01-15
    SELECT
    count(*) as Total_sales,
    SUM(TOTAL_PRICE) AS sales_volume,
    AVG(TOTAL_PRICE) AS average_sale_price,
    SUM(TOTAL_PRICE_USD) AS sales_volume_usd,
    AVG(TOTAL_PRICE_USD) AS average_sale_price_usd,
    count(distinct buyer_address) as buyers,
    count(distinct seller_address) as sellers,
    FROM aptos.nft.ez_nft_sales
    where project_name= 'Pixel Pirates'




    Last run: 3 months ago
    TOTAL_SALES
    SALES_VOLUME
    AVERAGE_SALE_PRICE
    SALES_VOLUME_USD
    AVERAGE_SALE_PRICE_USD
    BUYERS
    SELLERS
    1
    760917.027294911.2066148628275.34730506310.888614875196219
    1
    68B
    3s