select

Date_trunc('Day',BLOCK_TIMESTAMP)::DATE AS DAY,

count(*)/86400 AS TPS,

count(*)/1440 AS TPM,

avg(TX_Fee) AS "Average TX fee"

from berachain.testnet.fact_transactions where TX_SUCCEEDED=TRUE

group by 1