PREVIEW / futures_1hour / 2018-08-26
file: by_date/futures_1hour/2018/2018-08-26.parquet size: 14 KB rows: 286
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 |
|---|---|---|---|---|---|---|---|
| 2018-08-26 18:00:00 | ES | Futures | 3136.36 | 3139.9 | 3135.27 | 3139.36 | 7182.0 |
| 2018-08-26 19:00:00 | ES | Futures | 3139.36 | 3141.54 | 3138.81 | 3140.99 | 4161.0 |
| 2018-08-26 20:00:00 | ES | Futures | 3140.99 | 3143.72 | 3140.72 | 3141.81 | 7827.0 |
| 2018-08-26 21:00:00 | ES | Futures | 3141.54 | 3142.63 | 3140.72 | 3141.54 | 7142.0 |
| 2018-08-26 22:00:00 | ES | Futures | 3141.54 | 3142.63 | 3140.72 | 3142.35 | 4762.0 |
| 2018-08-26 23:00:00 | ES | Futures | 3142.35 | 3143.44 | 3142.35 | 3143.17 | 4210.0 |
| 2018-08-26 18:00:00 | NQ | Futures | 8831.37 | 8853.15 | 8831.07 | 8849.62 | 3489.0 |
| 2018-08-26 19:00:00 | NQ | Futures | 8849.92 | 8861.69 | 8847.56 | 8861.4 | 2560.0 |
| 2018-08-26 20:00:00 | NQ | Futures | 8861.1 | 8865.22 | 8853.15 | 8857.28 | 2800.0 |
| 2018-08-26 21:00:00 | NQ | Futures | 8857.28 | 8861.1 | 8852.27 | 8855.8 | 2706.0 |
| 2018-08-26 22:00:00 | NQ | Futures | 8856.1 | 8859.93 | 8851.98 | 8858.75 | 2503.0 |
| 2018-08-26 23:00:00 | NQ | Futures | 8859.04 | 8866.11 | 8857.28 | 8863.75 | 2094.0 |
| 2018-08-26 18:00:00 | YM | Futures | 28058.0 | 28105.8 | 28053.6 | 28098.2 | 1450.0 |
| 2018-08-26 19:00:00 | YM | Futures | 28097.1 | 28123.2 | 28094.9 | 28119.9 | 919.0 |
| 2018-08-26 20:00:00 | YM | Futures | 28117.8 | 28133.0 | 28116.7 | 28125.4 | 1327.0 |
| 2018-08-26 21:00:00 | YM | Futures | 28125.4 | 28134.1 | 28113.4 | 28121.0 | 1072.0 |
| 2018-08-26 22:00:00 | YM | Futures | 28122.1 | 28136.3 | 28116.7 | 28135.2 | 653.0 |
| 2018-08-26 23:00:00 | YM | Futures | 28135.2 | 28149.3 | 28133.0 | 28142.8 | 1252.0 |
| 2018-08-26 18:00:00 | CL | Futures | 62.96 | 63.03 | 62.92 | 63.0 | 1848.0 |
| 2018-08-26 19:00:00 | CL | Futures | 63.0 | 63.06 | 63.0 | 63.04 | 1241.0 |
| 2018-08-26 20:00:00 | CL | Futures | 63.04 | 63.06 | 62.89 | 62.97 | 3318.0 |
| 2018-08-26 21:00:00 | CL | Futures | 62.98 | 63.07 | 62.97 | 63.02 | 3411.0 |
| 2018-08-26 22:00:00 | CL | Futures | 63.02 | 63.06 | 62.95 | 62.99 | 2467.0 |
| 2018-08-26 23:00:00 | CL | Futures | 62.98 | 63.1 | 62.97 | 63.07 | 3023.0 |
| 2018-08-26 18:00:00 | GC | Futures | 1582.3 | 1582.6 | 1579.8 | 1580.4 | 2243.0 |
| 2018-08-26 19:00:00 | GC | Futures | 1580.4 | 1582.2 | 1579.7 | 1582.1 | 4583.0 |
| 2018-08-26 20:00:00 | GC | Futures | 1581.9 | 1582.1 | 1579.6 | 1580.9 | 5498.0 |
| 2018-08-26 21:00:00 | GC | Futures | 1580.8 | 1581.0 | 1576.1 | 1577.1 | 11440.0 |
| 2018-08-26 22:00:00 | GC | Futures | 1577.0 | 1579.6 | 1576.8 | 1579.2 | 6096.0 |
| 2018-08-26 23:00:00 | GC | Futures | 1579.3 | 1581.8 | 1578.8 | 1581.0 | 6461.0 |
| 2018-08-26 18:00:00 | ZN | Futures | 121.312437 | 121.312437 | 121.233857 | 121.233857 | 11642.0 |
| 2018-08-26 19:00:00 | ZN | Futures | 121.233857 | 121.281005 | 121.233857 | 121.265289 | 8326.0 |
| 2018-08-26 20:00:00 | ZN | Futures | 121.265289 | 121.265289 | 121.249573 | 121.249573 | 3610.0 |
| 2018-08-26 21:00:00 | ZN | Futures | 121.249573 | 121.281005 | 121.249573 | 121.265289 | 6414.0 |
| 2018-08-26 22:00:00 | ZN | Futures | 121.281005 | 121.312437 | 121.265289 | 121.296721 | 7882.0 |
| 2018-08-26 23:00:00 | ZN | Futures | 121.312437 | 121.312437 | 121.281005 | 121.296721 | 5970.0 |
> showing 36 of 286 rows — these rows as CSV