Query editor
1SELECT 2 date_trunc('day', coined_at) AS block_date3 , COUNT(*) AS coins_created4 , COUNT(DISTINCT creator_address) AS unique_creators5FROM dune.zorateam.result_zora_20_created_coins6GROUP BY 17ORDER BY 1 DESC8
SELECT
date_trunc('day', coined_at) AS block_date
, COUNT(*) AS coins_created
, COUNT(DISTINCT creator_address) AS unique_creators
FROM dune.zorateam.result_zora_20_created_coins
GROUP BY 1
ORDER BY 1 DESC