SELECT date_trunc('day', block_timestamp) as date,
count(tx_hash) as transactions,
count(tx_hash)/86400 as tps,
FROM base.core.fact_transactions
WHERE block_timestamp::date >= '2024-01-01'
AND block_timestamp::date < current_date
GROUP BY 1
ORDER BY 1