PREVIEW / futures_1hour / 2018-08-05
file: by_date/futures_1hour/2018/2018-08-05.parquet size: 14 KB rows: 293
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-05 18:00:00 | ES | Futures | 3096.85 | 3098.49 | 3095.49 | 3096.31 | 4486.0 |
| 2018-08-05 19:00:00 | ES | Futures | 3096.31 | 3097.12 | 3094.94 | 3095.22 | 2409.0 |
| 2018-08-05 20:00:00 | ES | Futures | 3095.22 | 3097.67 | 3094.94 | 3096.31 | 3983.0 |
| 2018-08-05 21:00:00 | ES | Futures | 3096.31 | 3099.58 | 3095.76 | 3099.58 | 7958.0 |
| 2018-08-05 22:00:00 | ES | Futures | 3099.58 | 3100.67 | 3099.03 | 3099.3 | 5252.0 |
| 2018-08-05 23:00:00 | ES | Futures | 3099.3 | 3099.85 | 3097.94 | 3098.76 | 3526.0 |
| 2018-08-05 18:00:00 | NQ | Futures | 8719.78 | 8733.33 | 8718.02 | 8720.08 | 1879.0 |
| 2018-08-05 19:00:00 | NQ | Futures | 8720.37 | 8726.55 | 8718.9 | 8720.08 | 678.0 |
| 2018-08-05 20:00:00 | NQ | Futures | 8720.08 | 8730.09 | 8719.49 | 8723.9 | 1315.0 |
| 2018-08-05 21:00:00 | NQ | Futures | 8723.61 | 8742.45 | 8722.43 | 8738.04 | 2717.0 |
| 2018-08-05 22:00:00 | NQ | Futures | 8738.33 | 8743.34 | 8734.8 | 8736.86 | 1935.0 |
| 2018-08-05 23:00:00 | NQ | Futures | 8736.56 | 8738.33 | 8730.09 | 8732.44 | 1016.0 |
| 2018-08-05 18:00:00 | YM | Futures | 27639.4 | 27665.5 | 27631.8 | 27640.5 | 827.0 |
| 2018-08-05 19:00:00 | YM | Futures | 27640.5 | 27651.4 | 27635.1 | 27638.3 | 570.0 |
| 2018-08-05 20:00:00 | YM | Futures | 27636.2 | 27661.2 | 27635.1 | 27649.2 | 842.0 |
| 2018-08-05 21:00:00 | YM | Futures | 27648.1 | 27688.4 | 27644.9 | 27686.2 | 1380.0 |
| 2018-08-05 22:00:00 | YM | Futures | 27687.3 | 27703.6 | 27684.0 | 27692.7 | 1327.0 |
| 2018-08-05 23:00:00 | YM | Futures | 27691.6 | 27698.1 | 27673.1 | 27681.8 | 857.0 |
| 2018-08-05 18:00:00 | CL | Futures | 62.4 | 62.41 | 62.26 | 62.31 | 2074.0 |
| 2018-08-05 19:00:00 | CL | Futures | 62.31 | 62.39 | 62.31 | 62.31 | 1150.0 |
| 2018-08-05 20:00:00 | CL | Futures | 62.32 | 62.39 | 62.29 | 62.36 | 2802.0 |
| 2018-08-05 21:00:00 | CL | Futures | 62.36 | 62.62 | 62.34 | 62.58 | 6386.0 |
| 2018-08-05 22:00:00 | CL | Futures | 62.58 | 62.61 | 62.49 | 62.51 | 4035.0 |
| 2018-08-05 23:00:00 | CL | Futures | 62.51 | 62.55 | 62.47 | 62.5 | 1743.0 |
| 2018-08-05 18:00:00 | GC | Futures | 1592.1 | 1592.9 | 1591.6 | 1592.1 | 1513.0 |
| 2018-08-05 19:00:00 | GC | Futures | 1592.1 | 1594.0 | 1592.0 | 1593.5 | 1907.0 |
| 2018-08-05 20:00:00 | GC | Futures | 1593.5 | 1594.2 | 1592.1 | 1594.0 | 3188.0 |
| 2018-08-05 21:00:00 | GC | Futures | 1593.9 | 1597.3 | 1592.9 | 1596.4 | 9775.0 |
| 2018-08-05 22:00:00 | GC | Futures | 1596.5 | 1597.2 | 1595.0 | 1595.1 | 5772.0 |
| 2018-08-05 23:00:00 | GC | Futures | 1595.1 | 1595.6 | 1594.4 | 1595.1 | 3108.0 |
| 2018-08-05 18:00:00 | ZN | Futures | 120.306608 | 120.306608 | 120.243744 | 120.25946 | 5492.0 |
| 2018-08-05 19:00:00 | ZN | Futures | 120.25946 | 120.275176 | 120.243744 | 120.25946 | 4658.0 |
| 2018-08-05 20:00:00 | ZN | Futures | 120.25946 | 120.275176 | 120.243744 | 120.25946 | 7269.0 |
| 2018-08-05 21:00:00 | ZN | Futures | 120.275176 | 120.275176 | 120.228028 | 120.228028 | 9100.0 |
| 2018-08-05 22:00:00 | ZN | Futures | 120.228028 | 120.243744 | 120.228028 | 120.243744 | 6878.0 |
| 2018-08-05 23:00:00 | ZN | Futures | 120.228028 | 120.25946 | 120.228028 | 120.243744 | 4084.0 |
> showing 36 of 293 rows — these rows as CSV