dammyzuks2023-10-25 07:24 PM copy
    -- forked from 2023-10-25 07:24 PM @ https://flipsidecrypto.xyz/edit/queries/2a97eaae-af58-42c3-9749-ee6824a5780e
    SELECT
    DATE_TRUNC('month', block_timestamp) AS _date,
    AMOUNT,
    MINT_TOKEN_SYMBOL,
    SUM(MINT_PRICE_USD) AS MINT PRICE USD SUM(NFT_COUNT) AS Total Nft
    FROM
    ethereum.nft.ez_nft_mints
    WHERE
    block_timestamp :: DATE BETWEEN '2022-04-01'
    AND '2022-08-30'
    AND platform_name = 'opensea'
    and MINT_TOKEN_SYMBOL = 'ENS'
    GROUP BY
    1;
    Run a query to Download Data