date_trunc('day', block_timestamp) AS Date,

COUNT(DISTINCT tx_hash) AS Number_of_transation,

COUNT(DISTINCT origin_from_address) AS Active_Users,

TO_VARCHAR(ROUND(SUM(amount_usd)), '999,999,999,999,999') AS Trading_Volume

FROM blast.core.ez_token_transfers

WHERE block_timestamp >= '2024-01-01 09:00:00.000'

AND AMOUNT_USD IS NOT NULL

GROUP BY 1

ORDER BY 1 DESC