block_timestamp :: date AS date,

count(DISTINCT delegator) AS new_delegators

FROM optimism.core.fact_delegations

WHERE block_timestamp :: date >= CURRENT_DATE - {{days}}

GROUP BY block_timestamp :: date