select
avg("Average TX fee") AS "Average TX fee",
avg(TPS) AS TPS from (
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
group by 1)