SELECT BLOCK_TIMESTAMP::DATE AS full_date, EXTRACT(MONTH FROM BLOCK_TIMESTAMP) AS month, EXTRACT(DAY FROM BLOCK_TIMESTAMP) AS day, count(DISTINCT SIGNER_ID) AS devs
FROM near.social.fact_widget_deployments
GROUP BY full_date, month, day
ORDER BY full_date DESC, month DESC, day DESC;