date_trunc('day', block_timestamp) as "Timestamp",

case when block_timestamp::date between '2023-02-10' and '2023-02-20' then 'Education Phase'

when block_timestamp::date between '2023-02-21' and '2023-02-28' then 'Build & Submit Phase'

when block_timestamp::date between '2023-03-01' and '2023-04-01' then 'Launchpad Phase'

else 'Other days'

end as status,

count(event_contract) as "new contract",

sum( "new contract") over (order BY "Timestamp") as "cumulative new contracts"

from (select event_contract, min(block_timestamp) as block_timestamp from flow.core.fact_events where tx_succeeded=1 group by 1)

where block_timestamp::date<current_date and block_timestamp::date>='2023-01-01'

group by 1,2

order by 1 desc