mehdimarjanFlow NFT Volume in Last 7 days
    Updated 2022-06-11
    SELECT
    split_part(NFT_COLLECTION, '.', 3) AS NFT_COLLECTION,
    split_part(CURRENCY, '.', 3) AS CURRENCY,
    SUM(PRICE) AS volume, COUNT(*) AS Number
    FROM flow.core.fact_nft_sales
    WHERE BLOCK_TIMESTAMP::date >= CURRENT_DATE - 7
    GROUP BY 1,2
    ORDER BY 3 DESC
    Run a query to Download Data