SELECT
DATE_TRUNC('day',block_timestamp) as Transaction_date,
SUM(tx_fee) AS Daily_Gas_used,
SUM(Daily_Gas_used) over (order by DATE_TRUNC('day',block_timestamp)) as TotalGas_Used
FROM
berachain.testnet.fact_transactions
WHERE
block_timestamp > CAST('2024-06-10' AS TIMESTAMP)
GROUP
BY
1
ORDER
BY
1
DESC