DATE_TRUNC('day', block_timestamp) AS Date,

COUNT(DISTINCT from_address) AS Users,

COUNT(DISTINCT tx_hash) AS Transactions

FROM

kaia.core.fact_transactions

WHERE

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

GROUP BY 1