PREVIEW / futures_1hour / 2016-12-26
file: by_date/futures_1hour/2016/2016-12-26.parquet size: 14 KB rows: 279
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 |
|---|---|---|---|---|---|---|---|
| 2016-12-26 18:00:00 | ES | Futures | 2464.47 | 2465.83 | 2463.65 | 2464.74 | 2536.0 |
| 2016-12-26 19:00:00 | ES | Futures | 2465.01 | 2465.01 | 2463.38 | 2464.47 | 1559.0 |
| 2016-12-26 20:00:00 | ES | Futures | 2464.19 | 2464.74 | 2463.92 | 2464.74 | 1014.0 |
| 2016-12-26 21:00:00 | ES | Futures | 2464.47 | 2465.01 | 2464.47 | 2464.74 | 403.0 |
| 2016-12-26 22:00:00 | ES | Futures | 2464.74 | 2465.56 | 2463.92 | 2464.19 | 1272.0 |
| 2016-12-26 23:00:00 | ES | Futures | 2464.19 | 2464.74 | 2463.92 | 2464.19 | 628.0 |
| 2016-12-26 18:00:00 | NQ | Futures | 5897.19 | 5900.47 | 5894.8 | 5898.08 | 513.0 |
| 2016-12-26 19:00:00 | NQ | Futures | 5898.38 | 5898.98 | 5895.69 | 5897.78 | 344.0 |
| 2016-12-26 20:00:00 | NQ | Futures | 5897.78 | 5898.98 | 5896.29 | 5898.38 | 334.0 |
| 2016-12-26 21:00:00 | NQ | Futures | 5898.08 | 5898.98 | 5897.48 | 5897.78 | 144.0 |
| 2016-12-26 22:00:00 | NQ | Futures | 5898.08 | 5898.98 | 5896.89 | 5897.48 | 295.0 |
| 2016-12-26 23:00:00 | NQ | Futures | 5897.19 | 5899.57 | 5897.19 | 5898.08 | 351.0 |
| 2016-12-26 18:00:00 | YM | Futures | 21546.7 | 21557.6 | 21543.5 | 21553.2 | 752.0 |
| 2016-12-26 19:00:00 | YM | Futures | 21555.4 | 21555.4 | 21544.5 | 21550.0 | 432.0 |
| 2016-12-26 20:00:00 | YM | Futures | 21548.9 | 21553.2 | 21547.8 | 21553.2 | 271.0 |
| 2016-12-26 21:00:00 | YM | Futures | 21553.2 | 21557.6 | 21552.1 | 21555.4 | 262.0 |
| 2016-12-26 22:00:00 | YM | Futures | 21556.5 | 21560.8 | 21550.0 | 21552.1 | 464.0 |
| 2016-12-26 23:00:00 | YM | Futures | 21552.1 | 21554.3 | 21548.9 | 21551.0 | 190.0 |
| 2016-12-26 18:00:00 | CL | Futures | 51.27 | 51.32 | 51.11 | 51.16 | 2055.0 |
| 2016-12-26 19:00:00 | CL | Futures | 51.16 | 51.21 | 51.12 | 51.12 | 1367.0 |
| 2016-12-26 20:00:00 | CL | Futures | 51.13 | 51.16 | 51.02 | 51.12 | 3560.0 |
| 2016-12-26 21:00:00 | CL | Futures | 51.12 | 51.18 | 51.06 | 51.1 | 2810.0 |
| 2016-12-26 22:00:00 | CL | Futures | 51.09 | 51.13 | 51.09 | 51.09 | 851.0 |
| 2016-12-26 23:00:00 | CL | Futures | 51.09 | 51.13 | 51.09 | 51.13 | 784.0 |
| 2016-12-26 18:00:00 | GC | Futures | 1532.4 | 1533.6 | 1531.0 | 1531.3 | 2410.0 |
| 2016-12-26 19:00:00 | GC | Futures | 1531.4 | 1531.6 | 1529.0 | 1529.3 | 1724.0 |
| 2016-12-26 20:00:00 | GC | Futures | 1529.3 | 1533.3 | 1529.0 | 1532.5 | 4909.0 |
| 2016-12-26 21:00:00 | GC | Futures | 1532.5 | 1537.4 | 1532.5 | 1536.8 | 6477.0 |
| 2016-12-26 22:00:00 | GC | Futures | 1536.8 | 1537.6 | 1535.2 | 1535.3 | 2325.0 |
| 2016-12-26 23:00:00 | GC | Futures | 1535.3 | 1537.1 | 1535.2 | 1536.1 | 1589.0 |
| 2016-12-26 18:00:00 | ZN | Futures | 121.737574 | 121.737574 | 121.660466 | 121.691309 | 3556.0 |
| 2016-12-26 19:00:00 | ZN | Futures | 121.691309 | 121.691309 | 121.629623 | 121.645045 | 3137.0 |
| 2016-12-26 20:00:00 | ZN | Futures | 121.645045 | 121.645045 | 121.552516 | 121.59878 | 6443.0 |
| 2016-12-26 21:00:00 | ZN | Futures | 121.59878 | 121.59878 | 121.567937 | 121.567937 | 3926.0 |
| 2016-12-26 22:00:00 | ZN | Futures | 121.583359 | 121.583359 | 121.537094 | 121.583359 | 5673.0 |
| 2016-12-26 23:00:00 | ZN | Futures | 121.583359 | 121.59878 | 121.567937 | 121.583359 | 2696.0 |
> showing 36 of 279 rows — these rows as CSV