date_trunc('seconds', block_timestamp) as seconds,

count(distinct tx_id) as transaction_count

from osmosis.core.fact_transactions

where block_timestamp >= CURRENT_DATE - 1

group by seconds