date_trunc('day',block_timestamp) as day,

count(DISTINCt tx_id)/86400 as tps,

count(DISTINCt tx_id) as transactions

from sei.core.fact_transactions

GROUP by 1