PREVIEW / futures_1hour / 2017-03-26
file: by_date/futures_1hour/2017/2017-03-26.parquet size: 15 KB rows: 292
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2017-03-26 18:00:00 | ES | Futures | 2553.34 | 2553.89 | 2542.96 | 2545.69 | 34469.0 |
| 2017-03-26 19:00:00 | ES | Futures | 2545.69 | 2547.6 | 2544.6 | 2547.06 | 12326.0 |
| 2017-03-26 20:00:00 | ES | Futures | 2546.79 | 2547.33 | 2541.6 | 2542.41 | 15388.0 |
| 2017-03-26 21:00:00 | ES | Futures | 2542.41 | 2544.87 | 2540.78 | 2543.51 | 16081.0 |
| 2017-03-26 22:00:00 | ES | Futures | 2543.51 | 2544.6 | 2542.14 | 2542.14 | 5215.0 |
| 2017-03-26 23:00:00 | ES | Futures | 2542.14 | 2543.51 | 2541.6 | 2542.96 | 5450.0 |
| 2017-03-26 18:00:00 | NQ | Futures | 6392.13 | 6392.42 | 6368.87 | 6373.94 | 5495.0 |
| 2017-03-26 19:00:00 | NQ | Futures | 6373.94 | 6378.41 | 6370.06 | 6377.82 | 2645.0 |
| 2017-03-26 20:00:00 | NQ | Futures | 6377.82 | 6377.82 | 6362.61 | 6363.8 | 2856.0 |
| 2017-03-26 21:00:00 | NQ | Futures | 6363.8 | 6371.55 | 6359.33 | 6368.57 | 3107.0 |
| 2017-03-26 22:00:00 | NQ | Futures | 6368.27 | 6370.96 | 6363.5 | 6363.5 | 921.0 |
| 2017-03-26 23:00:00 | NQ | Futures | 6363.5 | 6367.38 | 6362.31 | 6366.49 | 770.0 |
| 2017-03-26 18:00:00 | YM | Futures | 22308.6 | 22309.6 | 22232.5 | 22251.0 | 5615.0 |
| 2017-03-26 19:00:00 | YM | Futures | 22252.0 | 22265.1 | 22242.3 | 22260.7 | 2605.0 |
| 2017-03-26 20:00:00 | YM | Futures | 22260.7 | 22261.8 | 22219.4 | 22222.7 | 2921.0 |
| 2017-03-26 21:00:00 | YM | Futures | 22222.7 | 22248.8 | 22211.8 | 22237.9 | 2921.0 |
| 2017-03-26 22:00:00 | YM | Futures | 22237.9 | 22246.6 | 22227.1 | 22229.2 | 830.0 |
| 2017-03-26 23:00:00 | YM | Futures | 22227.1 | 22240.1 | 22223.8 | 22239.0 | 884.0 |
| 2017-03-26 18:00:00 | CL | Futures | 44.7 | 44.85 | 44.56 | 44.73 | 5046.0 |
| 2017-03-26 19:00:00 | CL | Futures | 44.73 | 44.77 | 44.71 | 44.77 | 2275.0 |
| 2017-03-26 20:00:00 | CL | Futures | 44.77 | 44.77 | 44.46 | 44.48 | 4838.0 |
| 2017-03-26 21:00:00 | CL | Futures | 44.48 | 44.56 | 44.35 | 44.44 | 4773.0 |
| 2017-03-26 22:00:00 | CL | Futures | 44.44 | 44.49 | 44.42 | 44.42 | 2474.0 |
| 2017-03-26 23:00:00 | CL | Futures | 44.42 | 44.46 | 44.4 | 44.45 | 1375.0 |
| 2017-03-26 18:00:00 | GC | Futures | 1674.4 | 1688.5 | 1674.4 | 1685.5 | 929.0 |
| 2017-03-26 19:00:00 | GC | Futures | 1685.8 | 1687.4 | 1684.3 | 1686.0 | 388.0 |
| 2017-03-26 20:00:00 | GC | Futures | 1686.0 | 1689.4 | 1685.5 | 1688.7 | 653.0 |
| 2017-03-26 21:00:00 | GC | Futures | 1688.7 | 1693.0 | 1688.6 | 1691.0 | 932.0 |
| 2017-03-26 22:00:00 | GC | Futures | 1691.0 | 1691.5 | 1690.6 | 1691.1 | 291.0 |
| 2017-03-26 23:00:00 | GC | Futures | 1691.1 | 1691.5 | 1690.7 | 1690.9 | 365.0 |
| 2017-03-26 18:00:00 | ZN | Futures | 123.423356 | 123.717848 | 123.423356 | 123.702348 | 31046.0 |
| 2017-03-26 19:00:00 | ZN | Futures | 123.702348 | 123.717848 | 123.64035 | 123.671349 | 21006.0 |
| 2017-03-26 20:00:00 | ZN | Futures | 123.65585 | 123.779846 | 123.65585 | 123.764347 | 28521.0 |
| 2017-03-26 21:00:00 | ZN | Futures | 123.764347 | 123.810846 | 123.748847 | 123.795346 | 18473.0 |
| 2017-03-26 22:00:00 | ZN | Futures | 123.795346 | 123.810846 | 123.764347 | 123.779846 | 8141.0 |
| 2017-03-26 23:00:00 | ZN | Futures | 123.779846 | 123.795346 | 123.779846 | 123.779846 | 3548.0 |
> showing 36 of 292 rows — these rows as CSV