date_trunc('day', block_timestamp) AS Date,

COUNT(DISTINCT tx_hash) AS Number_of_transation,

COUNT(DISTINCT from_address) AS Current_Users,

SUM(value) AS ETH_Trading_Volume

FROM blast.core.fact_transactions

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

AND value IS NOT NULL

GROUP BY 1

ORDER BY 1 DESC