,sum(TX_COUNT) AS "Tx_Count"

,sum(sum(TX_COUNT)) OVER (

ORDER BY date_trunc('day', BLOCK_TIMESTAMP)

) AS "Total_Tx"

FROM lava.core.fact_blocks

WHERE 1 = 1

AND "Date" >= '2024-07-01'

GROUP BY 1

ORDER BY 1 DESC;