count(distinct tx_id) as TX_Count,

sum (TX_Count) over (order by date) as Cum_TX_Count,

count (distinct event_data:seller) as Sellers_Count,

sum (Sellers_Count) over (order by date) as Cum_Sellers_Count,

sum (event_data:price) as Volume,

sum (Volume) over (order by date) as Cum_Volume

from flow.core.fact_events t1

join flow.core.dim_contract_labels t2 on t1.event_contract = t2.event_contract

where block_timestamp >= '2022-05-10' and block_timestamp <= '2022-06-05'

and contract_name like '%TopShotMarket%'

group by 1

order by 1