mlhtop shot use count
    Updated 2022-06-06
    SELECT
    trunc(block_timestamp,'day') as date,
    count(distinct tx_id) as sales
    FROM flow.core.fact_events
    WHERE block_timestamp >= '2022-05-09'
    and event_contract='A.0b2a3299cc857e29.TopShot'
    and tx_succeeded='true'
    group by 1
    order by 1 asc
    Run a query to Download Data