date_trunc('day',block_timestamp) as "Day",

sum(1) as "Count",

sum("Count") over(order by "Day") as "Cumulative Sum"

from

osmosis.core.fact_transactions

where

"Day">= '2022-02-01'

and TX_STATUS='FAILED'

group by

"Day"

order by

"Day"