DiamondDaily Moment Tiers And Sales (Draft)
    Updated 2023-11-04
    -- forked from Daily Moment Tiers And Sales copy @ https://flipsidecrypto.xyz/edit/queries/54dddfc1-90a9-4ff9-99ab-4e1498c49391

    select
    date_trunc('day', block_timestamp) as date,
    moment_tier,
    sum(price) as volume,
    count(*) as sales
    from
    flow.nft.ez_nft_sales sales
    left join flow.nft.dim_allday_metadata meta on meta.nft_id = sales.nft_id
    where
    sales.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
    and meta.nft_id = sales.nft_id
    and block_timestamp between '2023-04-24' and '2023-05-02'
    GROUP BY
    moment_tier,
    date
    ORDER BY
    date DESC


    Run a query to Download Data