@noizygamer I did not, looked into it, and wow. The SQL code for this dataset runs fine on R through an ODBC link to the DB. However, if I run it directly in sql server management studio, it fails with this error

@noizygamer Which means that back in november, the total trade value for a particular group in a particular index exceeded the sql money type, and ODBC simply didn't return rows after that particular error. I fixed this by casting the variable to numeric, now we get full history :)

@noizygamer What a remarkable bug... thanks for reporting it! :)

@noizygamer the culprit

@noizygamer It's a Chained Laspeyres price index, more details here eveonline.com/article/eve-ec… near the bottom of it.

@noizygamer spoke with @CCPRecurve about it and he argued for keeping them in as they’re consumables. They are the reason for the inflation we’ve seen in the past few months

@noizygamer @CCPRecurve No, the argument from @CCPRecurve is that PLEX is more like a currency rather than a commodity. Skill trading was introduced in February 2016, after which injectors and extractors became a part of the indices. I.e. PLEX and skill trading items are not treated equally as RMT prods