date_trunc('day', block_timestamp) AS Date,

COUNT(DISTINCT TX_FROM) AS Active_Users

FROM solana.core.fact_transfers

WHERE amount IS NOT NULL

GROUP BY 1

ORDER BY 1 DESC

LIMIT 1000