yasmin Breakdown by TOKEN_ID
    Updated 2024-09-11
    SELECT
    SUBSTRING(TOKENID, CHARINDEX('#', TOKENID) + 1) AS TOKEN_ID,
    SUM(TOTAL_PRICE) AS VOLUME_apt,
    COUNT(DISTINCT tx_hash) AS TX,
    COUNT(DISTINCT Seller_address) AS Sellers,
    COUNT(DISTINCT buyer_address) AS Buyers
    FROM aptos.nft.ez_nft_sales
    WHERE project_name IN ('{{project_name}}')
    AND block_timestamp::date >= '{{Start_Date}}'
    AND block_timestamp::date <= '{{End_Date}}'
    AND project_name IS NOT NULL
    AND EVENT_TYPE = 'sale'
    AND TOKEN_ID IS NOT NULL
    GROUP BY 1
    ORDER BY VOLUME_apt DESC;
    QueryRunArchived: QueryRun has been archived