day,

count(DISTINCT LIQUIDITY_PROVIDER_ADDRESS)

FROM (

SELECT

date_trunc('day', day) as day,

LIQUIDITY_PROVIDER_ADDRESS,

count(*) as actvie_days

FROM (

SELECT

date_trunc('day', block_timestamp) as day,

LIQUIDITY_PROVIDER_ADDRESS

FROM osmosis.core.fact_liquidity_provider_actions

GROUP BY 1,2

)

GROUP BY 1,2

GROUP BY 1