count(distinct LIQUIDITY_POOL_ID) as "Unique LPs"

from stellar.defi.fact_liquidity_pools

WHERE BLOCK_TIMESTAMP >= DATEADD(YEAR, -1, CURRENT_DATE)