DATE(BLOCK_TIMESTAMP) as date,

count(TX_ID) as daily_tx_count,

SUM(count(TX_ID)) over (

ORDER BY

DATE(BLOCK_TIMESTAMP)

) as total_tx_count

FROM

osmosis.core.fact_transactions

group BY

DATE(BLOCK_TIMESTAMP);