date_trunc('day', block_timestamp) as day,

count(DISTINCT TX_FROM)

FROM osmosis.core.fact_transactions

WHERE block_timestamp > '2023-01-01'

GROUP BY 1