PREVIEW / futures_1hour / 2016-09-18
file: by_date/futures_1hour/2016/2016-09-18.parquet size: 15 KB rows: 294
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-09-18 18:00:00 | ES | Futures | 2320.56 | 2322.47 | 2319.75 | 2320.29 | 5016.0 |
| 2016-09-18 19:00:00 | ES | Futures | 2320.29 | 2330.08 | 2320.02 | 2326.82 | 9840.0 |
| 2016-09-18 20:00:00 | ES | Futures | 2327.09 | 2327.91 | 2326.28 | 2326.55 | 3894.0 |
| 2016-09-18 21:00:00 | ES | Futures | 2326.82 | 2328.18 | 2326.28 | 2327.09 | 4939.0 |
| 2016-09-18 22:00:00 | ES | Futures | 2327.09 | 2328.45 | 2326.82 | 2327.91 | 2690.0 |
| 2016-09-18 23:00:00 | ES | Futures | 2327.91 | 2328.72 | 2327.64 | 2328.18 | 2369.0 |
| 2016-09-18 18:00:00 | NQ | Futures | 5745.63 | 5748.02 | 5742.05 | 5742.05 | 1172.0 |
| 2016-09-18 19:00:00 | NQ | Futures | 5742.65 | 5766.22 | 5740.86 | 5758.76 | 2737.0 |
| 2016-09-18 20:00:00 | NQ | Futures | 5758.76 | 5762.04 | 5756.97 | 5758.46 | 1038.0 |
| 2016-09-18 21:00:00 | NQ | Futures | 5758.46 | 5762.34 | 5757.27 | 5759.95 | 898.0 |
| 2016-09-18 22:00:00 | NQ | Futures | 5759.95 | 5763.83 | 5759.36 | 5761.74 | 668.0 |
| 2016-09-18 23:00:00 | NQ | Futures | 5761.74 | 5763.83 | 5760.55 | 5762.34 | 376.0 |
| 2016-09-18 18:00:00 | YM | Futures | 19516.4 | 19522.9 | 19492.6 | 19503.4 | 658.0 |
| 2016-09-18 19:00:00 | YM | Futures | 19504.5 | 19585.6 | 19499.1 | 19561.8 | 2027.0 |
| 2016-09-18 20:00:00 | YM | Futures | 19560.7 | 19571.5 | 19555.3 | 19559.6 | 879.0 |
| 2016-09-18 21:00:00 | YM | Futures | 19559.6 | 19572.6 | 19558.6 | 19564.0 | 676.0 |
| 2016-09-18 22:00:00 | YM | Futures | 19564.0 | 19575.9 | 19561.8 | 19572.6 | 618.0 |
| 2016-09-18 23:00:00 | YM | Futures | 19572.6 | 19578.0 | 19569.4 | 19576.9 | 554.0 |
| 2016-09-18 18:00:00 | CL | Futures | 43.86 | 44.29 | 43.82 | 44.22 | 4492.0 |
| 2016-09-18 19:00:00 | CL | Futures | 44.21 | 44.44 | 44.18 | 44.41 | 4773.0 |
| 2016-09-18 20:00:00 | CL | Futures | 44.41 | 44.47 | 44.35 | 44.38 | 2777.0 |
| 2016-09-18 21:00:00 | CL | Futures | 44.38 | 44.52 | 44.37 | 44.5 | 3639.0 |
| 2016-09-18 22:00:00 | CL | Futures | 44.5 | 44.67 | 44.48 | 44.66 | 4130.0 |
| 2016-09-18 23:00:00 | CL | Futures | 44.65 | 44.67 | 44.53 | 44.59 | 2830.0 |
| 2016-09-18 18:00:00 | GC | Futures | 1776.7 | 1779.8 | 1776.0 | 1779.8 | 1600.0 |
| 2016-09-18 19:00:00 | GC | Futures | 1779.7 | 1780.2 | 1778.1 | 1778.1 | 1199.0 |
| 2016-09-18 20:00:00 | GC | Futures | 1778.1 | 1778.2 | 1775.9 | 1777.2 | 3787.0 |
| 2016-09-18 21:00:00 | GC | Futures | 1777.1 | 1783.7 | 1776.7 | 1782.5 | 8283.0 |
| 2016-09-18 22:00:00 | GC | Futures | 1782.7 | 1786.2 | 1782.0 | 1785.0 | 5800.0 |
| 2016-09-18 23:00:00 | GC | Futures | 1785.0 | 1785.4 | 1782.1 | 1783.1 | 2832.0 |
| 2016-09-18 18:00:00 | ZN | Futures | 128.029992 | 128.045318 | 127.984016 | 128.029992 | 3917.0 |
| 2016-09-18 19:00:00 | ZN | Futures | 128.014667 | 128.014667 | 127.907388 | 127.953364 | 7821.0 |
| 2016-09-18 20:00:00 | ZN | Futures | 127.938039 | 127.96869 | 127.922713 | 127.953364 | 3959.0 |
| 2016-09-18 21:00:00 | ZN | Futures | 127.953364 | 128.014667 | 127.953364 | 127.984016 | 2023.0 |
| 2016-09-18 22:00:00 | ZN | Futures | 127.999341 | 128.029992 | 127.984016 | 128.014667 | 1842.0 |
| 2016-09-18 23:00:00 | ZN | Futures | 128.014667 | 128.045318 | 127.984016 | 127.984016 | 2266.0 |
> showing 36 of 294 rows — these rows as CSV