date_trunc('day', block_timestamp) date,

COUNT(DISTINCT tx_id) AS no_of_transaction

FROM flow.core.ez_token_transfers

WHERE block_timestamp::date >= '2024-01-01'

AND amount IS NOT NULL

GROUP BY 1

ORDER BY 1 DESC

LIMIT 1000