flipside

    number of topshot transactions and the others
    ramshini-rezanumber of topshot transactions and the others
    Updated 2022-06-28
    SELECT BLOCK_TIMESTAMP::date as date, case when lower(EVENT_CONTRACT) like '%topshot%' THEN 'topshots' else 'otherwise' end as event,
    count(DISTINCT tx_id) as freq from flow.core.fact_events
    where date >= CURRENT_DATE-90
    GROUP by 1,2
    Run a query to Download Data