select median(x.created_contracts) median_hackathon_created_contracts from(

select date_trunc('day', block_timestamp) day,

count(tx_id) created_contracts

from flow.core.fact_events

where event_type = 'AccountContractAdded'

group by day

order by day) x

where x.day between '2023-02-21' and '2023-02-28'