date, count(DISTINCT LIQUIDITY_PROVIDER_ADDRESS)

as total_liquidity, sum(total_liquidity) over

(order by date asc) as Cumulative_liquidity

FROM

( SELECT date_trunc('Day', date) as date,

LIQUIDITY_PROVIDER_ADDRESS

FROM (SELECT

date_trunc('day', block_timestamp) as date,

LIQUIDITY_PROVIDER_ADDRESS

FROM osmosis.core.fact_liquidity_provider_actions

GROUP BY date,LIQUIDITY_PROVIDER_ADDRESS ) GROUP BY date,LIQUIDITY_PROVIDER_ADDRESS)

WHERE date >= CURRENT_DATE - 90

GROUP BY date