DATE_TRUNC('day', creation_time) AS creation_date,

COUNT (*) AS total_created

ethereum.defi.dim_dex_liquidity_pools

creation_date >= '2025-02-01'

GROUP BY

1

ORDER BY

1 ASC;