WITH raw_data AS
(SELECT *
FROM terra.core.fact_lp_actions
WHERE block_timestamp::date >= CURRENT_DATE() -INTERVAL '30 days'
AND currency = 'uluna')
SELECT DATE_TRUNC('day', block_timestamp) AS "Days",
COUNT(DISTINCT LIQUIDITY_PROVIDER_ADDRESS) AS "Liquidity Providers Count"
FROM raw_data
WHERE action = 'provide_liquidity'
GROUP BY "Days"