date_trunc('day',block_timestamp) as date,

count(tx_id)

from solana.core.fact_transactions

group by date order by date desc