date_trunc (day, block_timestamp) as date,

count (DISTINCT tx_hash) as "Total Transaction",

sum ("Total Transaction") over (order by date) as "Cumulative tx count",

sum (TX_FEE_PRECISE) as "Total fee (BERA)",

sum ("Total fee (BERA)") over (order by date) as "Cumulative fee (BERA)"

from berachain.testnet.fact_transactions

GROUP by 1