Date_trunc('day', block_timestamp) Date,

Count(DISTINCT tx_id) Txns,

--abs(Txns/Date) as TPS

FROM sei.core.fact_transactions

WHERE block_timestamp :: date > current_date - 30

GROUP by 1