Afonso_DiazBy Marketplace
    Updated 2024-10-29
    SELECT
    platform_name as marketplace,
    COUNT(tx_hash) AS total_sales,
    SUM(total_price) AS total_volume_apt,
    COUNT(DISTINCT buyer_address) AS unique_buyers,
    AVG(total_price) AS average_price_apt
    FROM
    aptos.nft.ez_nft_sales
    WHERE
    project_name ILIKE '%Aptomingos%'
    GROUP BY
    marketplace
    ORDER BY
    total_sales DESC;

    QueryRunArchived: QueryRun has been archived