Updated 2022-10-23
    with tab1 as
    (
    SELECT block_timestamp::date as daily , count( DISTINCT tx_id) as mint
    from flow.core.fact_events
    where event_contract ilike '%raceday%'
    and EVENT_TYPE = 'Minted'
    GROUP by 1
    )
    , tab2 as (
    SELECT block_timestamp::date as daily, COUNT(DISTINCT tx_id) as sale
    from flow.core.ez_nft_sales
    where NFT_COLLECTION ilike '%raceday%'
    and TX_SUCCEEDED ilike '%TRUE%'
    GROUP by 1
    )
    SELECT A.daily , sale , mint
    from tab1 A
    join tab2 B on A.daily = B.daily

    Run a query to Download Data