PREVIEW / futures_1hour / 2017-01-29
file: by_date/futures_1hour/2017/2017-01-29.parquet size: 15 KB rows: 298
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-01-29 18:00:00 | ES | Futures | 2489.83 | 2492.56 | 2489.29 | 2490.38 | 17855.0 |
| 2017-01-29 19:00:00 | ES | Futures | 2490.38 | 2491.47 | 2489.02 | 2489.29 | 6325.0 |
| 2017-01-29 20:00:00 | ES | Futures | 2489.56 | 2489.83 | 2488.74 | 2489.02 | 5899.0 |
| 2017-01-29 21:00:00 | ES | Futures | 2489.29 | 2489.56 | 2488.74 | 2489.56 | 1203.0 |
| 2017-01-29 22:00:00 | ES | Futures | 2489.56 | 2490.65 | 2489.29 | 2490.65 | 2260.0 |
| 2017-01-29 23:00:00 | ES | Futures | 2490.65 | 2490.93 | 2490.38 | 2490.93 | 1174.0 |
| 2017-01-29 18:00:00 | NQ | Futures | 6140.91 | 6148.67 | 6138.23 | 6141.21 | 2947.0 |
| 2017-01-29 19:00:00 | NQ | Futures | 6141.21 | 6145.39 | 6139.42 | 6139.42 | 1405.0 |
| 2017-01-29 20:00:00 | NQ | Futures | 6139.42 | 6140.62 | 6136.74 | 6139.72 | 1221.0 |
| 2017-01-29 21:00:00 | NQ | Futures | 6139.72 | 6142.11 | 6138.53 | 6141.81 | 494.0 |
| 2017-01-29 22:00:00 | NQ | Futures | 6142.11 | 6143.9 | 6141.51 | 6143.6 | 606.0 |
| 2017-01-29 23:00:00 | NQ | Futures | 6143.3 | 6143.9 | 6141.81 | 6142.41 | 530.0 |
| 2017-01-29 18:00:00 | YM | Futures | 21661.7 | 21673.6 | 21625.9 | 21658.4 | 3183.0 |
| 2017-01-29 19:00:00 | YM | Futures | 21656.3 | 21664.9 | 21647.6 | 21649.8 | 1219.0 |
| 2017-01-29 20:00:00 | YM | Futures | 21650.8 | 21650.8 | 21640.0 | 21643.2 | 1129.0 |
| 2017-01-29 21:00:00 | YM | Futures | 21643.2 | 21648.7 | 21642.2 | 21647.6 | 379.0 |
| 2017-01-29 22:00:00 | YM | Futures | 21647.6 | 21658.4 | 21647.6 | 21658.4 | 779.0 |
| 2017-01-29 23:00:00 | YM | Futures | 21657.4 | 21660.6 | 21657.4 | 21660.6 | 214.0 |
| 2017-01-29 18:00:00 | CL | Futures | 50.38 | 50.39 | 50.15 | 50.21 | 3033.0 |
| 2017-01-29 19:00:00 | CL | Futures | 50.21 | 50.29 | 50.18 | 50.21 | 1978.0 |
| 2017-01-29 20:00:00 | CL | Futures | 50.21 | 50.26 | 50.19 | 50.23 | 1123.0 |
| 2017-01-29 21:00:00 | CL | Futures | 50.24 | 50.27 | 50.23 | 50.23 | 944.0 |
| 2017-01-29 22:00:00 | CL | Futures | 50.23 | 50.24 | 50.08 | 50.13 | 2576.0 |
| 2017-01-29 23:00:00 | CL | Futures | 50.13 | 50.2 | 50.12 | 50.18 | 2663.0 |
| 2017-01-29 18:00:00 | GC | Futures | 1608.8 | 1611.7 | 1606.8 | 1611.1 | 5256.0 |
| 2017-01-29 19:00:00 | GC | Futures | 1611.1 | 1611.7 | 1609.3 | 1610.1 | 3493.0 |
| 2017-01-29 20:00:00 | GC | Futures | 1610.3 | 1613.2 | 1610.1 | 1612.6 | 3915.0 |
| 2017-01-29 21:00:00 | GC | Futures | 1612.4 | 1612.7 | 1611.1 | 1611.2 | 1868.0 |
| 2017-01-29 22:00:00 | GC | Futures | 1611.3 | 1612.0 | 1610.5 | 1610.9 | 2535.0 |
| 2017-01-29 23:00:00 | GC | Futures | 1610.9 | 1611.3 | 1610.3 | 1610.5 | 1772.0 |
| 2017-01-29 18:00:00 | ZN | Futures | 122.585758 | 122.632023 | 122.554915 | 122.585758 | 28059.0 |
| 2017-01-29 19:00:00 | ZN | Futures | 122.585758 | 122.632023 | 122.570337 | 122.632023 | 8343.0 |
| 2017-01-29 20:00:00 | ZN | Futures | 122.647444 | 122.724552 | 122.647444 | 122.724552 | 17032.0 |
| 2017-01-29 21:00:00 | ZN | Futures | 122.724552 | 122.724552 | 122.693709 | 122.693709 | 5662.0 |
| 2017-01-29 22:00:00 | ZN | Futures | 122.693709 | 122.709131 | 122.616601 | 122.616601 | 7655.0 |
| 2017-01-29 23:00:00 | ZN | Futures | 122.616601 | 122.647444 | 122.616601 | 122.647444 | 3489.0 |
> showing 36 of 298 rows — these rows as CSV