Great kata! Thanks :)

looks to be clear to me now

I've changed the example in the descriptions, so the output now matches the input (there was just some other random numbers in the output), and added some explanation what the balance is.
Could you take a look is this any better? Any suggestions how could it be described in English if it is not clear enough?

not bad at all, but difficult is 5 )

There is an implicit assumption that the input data will always be 1-minute interval data starting at 00:00 of some day and ends in 01:40, which then have to be processed into 5-minutes intervals.

This information completely affects how the kata should be approached, so either it should be mentioned or the generated data should be made more generic.

This is still an issue. What does open and close even mean?

The description needs some rework:

You need to write a sql query that will return the daily balance history from monetary operations tables for all the time.

You should at least explain what a daily balance history is.

6 months later, and I finally solved this kata. I was confused by the description. The balance should be a rolling amount over each day, this wasn't clear to me.

I keep getting the discrepancy in the BigDecimal, eventhough both actual and expected are 0.8518265213. And I get this error with each of your sql kata's. Are you expecting a different numerical type than specified in the columns?

expected: <BigDecimal:55b532a00770,'0.8518265213 3517E1',27(27)>
  actual: <BigDecimal:55b532c62748,'0.8518265213 3517E1',27(27)>

I don't know what you changed, but without changing my code I now get this:

Test Failed
expected: 289
got: 145

I suddenly no longer return all the records.

updated, try again pls

this keeps happening, I'm not doing any fiddling with the 'price', they look the same in the error message, and yet it keeps giving this error.

try again pls

A link is not an explanation.