date_trunc('day', block_timestamp) as date,

24 * 60 * 60 AS seconds_per_day,

count(DISTINCT tx_hash) / seconds_per_day as TPS

from

boba.core.fact_transactions

group by

date

order by

date asc

select

date_trunc('month', date) as month,

avg(tps)

from daily

group by 1