shreexMints VS Sales 2
    Updated 2022-10-24
    (select
    date_trunc('day',block_timestamp) as date,
    'Mint Sales' as event,
    count(distinct tx_id) as sales
    from flow.core.fact_events
    where event_contract = 'A.329feb3ab062d289.RaceDay_NFT' and event_type = 'Minted'
    GROUP BY date
    ORDER BY date )
    UNION
    (select
    date_trunc('day',block_timestamp) as date,
    'Secondary Sales' as event,
    count(distinct tx_id) as sales
    from flow.core.ez_nft_sales where nft_collection = 'A.329feb3ab062d289.RaceDay_NFT' and tx_succeeded='TRUE'
    GROUP BY date
    ORDER BY date)
    Run a query to Download Data