BLOCK_TIMESTAMP::date AS "date",

SUM (gas_used/1e12) AS Tgas_used,

SUM (Tgas_used) over (ORDER BY "date" ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS acm_Tgas_used,

SUM (TRANSACTION_FEE/1e24) AS transaction_fees,

SUM (transaction_fees) over (ORDER BY "date" ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS acm_transaction_fees,

AVG (gas_used/1e12) AS avg_Tgas_used,

AVG (TRANSACTION_FEE/1e24) AS avg_transaction_fees,

COUNT (TXN_HASH) AS transactions,

SUM (transactions) over (ORDER BY "date" ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS acm_transactions

FROM flipside_prod_db.mdao_near.transactions

WHERE "date" BETWEEN '2022-01-01' AND '2022-07-24'

GROUP BY "date"

ORDER BY "date"