-- Chong Sun wrote this for ingestion. Please DM before modifying
select date_trunc('day',block_timestamp) as "date", count(distinct tx_hash) as "tx_count"
from kaia.core.fact_transactions
where block_timestamp::date>='2023-01-01'
group by 1
order by 1