superflysmall-orange
    Updated 2024-12-26
    SELECT
    SUM(price) AS total_sales_volume,
    COUNT(*) AS total_transactions,
    COUNT(DISTINCT buyer) AS unique_buyers,
    COUNT(DISTINCT nft_id) AS unique_nfts_traded
    FROM
    flow.nft.ez_nft_sales
    WHERE
    nft_collection = 'A.edf9df96c92f4595.Pinnacle'
    AND price > 0
    AND DATE(block_timestamp) BETWEEN '{{start_date}}' AND '{{end_date}}'

    QueryRunArchived: QueryRun has been archived