(

select

LIQUIDITY_PROVIDER_ADDRESS,

min(block_timestamp) as join_date,

case when join_date >= '2022-09-26' then 'after cosmoverse'

else 'before cosmoverse'

end as event

from osmosis.core.fact_liquidity_provider_actions

group by LIQUIDITY_PROVIDER_ADDRESS

)

select

join_date::date as "date",

event,

count(LIQUIDITY_PROVIDER_ADDRESS) as number_of_new_users

from join_date

where join_date >= '2022-09-12'

group by "date", event