Google Charts + AWS


Check out what we're doing with Amazon Web Services and Google Charts.

We've set up a live schema (continue reading) and the charts will follow shortly.


CFTC Historical COT Schema


The legendary Commitments of Traders reports archive has been loaded in to our AWS RDB schema.

CFTC__FUTURES_OPTIONS table contains 132,720 reports spanning 1995 to 2016.


Silver Report Query


Accessing CFTC silver data with SQL SELECT  : 726 Analytics


One commodity that stands out in terms of the data is silver. Grouping the reports by the year of the REPORT_DATE and averaging the OPEN_INTEREST for each year's reports is instructive.

Conclusion: Open interest is on a multi-year sustained climb.