CarlOwOsGoblers: mints
    Updated 2022-11-30
    WITH mints AS (
    SELECT
    block_timestamp::DATE AS date,
    COUNT(*) AS mint_count
    FROM
    ethereum.core.ez_nft_mints
    WHERE
    nft_address ilike '0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769'
    GROUP BY
    1
    )
    SELECT
    *,
    SUM(mint_count) OVER (ORDER BY date) AS cumulative_mints,
    CASE
    WHEN date <= '2022-11-07' THEN 'Before Market Downturn'
    ELSE 'Market Downturn'
    END AS label
    FROM
    mints

    Run a query to Download Data