ErsvanDetails top collection per day
    Updated 2022-06-12
    WITH
    topNFT (Collection) as (
    SELECT
    PROJECT_NAME AS Collection
    FROM
    flipside_prod_db.ethereum_core.ez_nft_sales
    WHERE
    PLATFORM_NAME = 'nftx'
    AND COLLECTION IS NOT NULL
    AND BLOCK_TIMESTAMP BETWEEN '2022-04-10' AND '2022-06-10'
    GROUP BY Collection
    ORDER BY SUM(PRICE) DESC
    LIMIT 3
    )

    SELECT
    DATE_TRUNC('day', block_timestamp) AS DAY,
    COLLECTION,
    SUM(PRICE) AS VOLUME,
    COUNT(COLLECTION) AS TRANSACTIONS
    FROM
    topNFT
    JOIN ethereum_core.ez_nft_sales ON PROJECT_NAME = COLLECTION
    WHERE
    BLOCK_TIMESTAMP BETWEEN '2022-04-10' AND '2022-06-10'
    GROUP BY DAY,COLLECTION
    ORDER BY DAY ASC, VOLUME DESC
    Run a query to Download Data