select f.value as id, min(block_timestamp::date) as TIME

from osmosis.core.fact_swaps, table(flatten(osmosis.core.fact_swaps.pool_ids)) f

group by 1

select count(id) as new_contracts, date_trunc('week', TIME) as DATE

from contracts

where TIME >= '2022-05-01'

group by DATE