PREVIEW / futures_1hour / 2017-02-05
file: by_date/futures_1hour/2017/2017-02-05.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-02-05 18:00:00 | ES | Futures | 2501.84 | 2502.11 | 2498.02 | 2498.29 | 7301.0 |
| 2017-02-05 19:00:00 | ES | Futures | 2498.29 | 2498.56 | 2496.38 | 2496.38 | 5004.0 |
| 2017-02-05 20:00:00 | ES | Futures | 2496.65 | 2497.47 | 2495.84 | 2497.47 | 4976.0 |
| 2017-02-05 21:00:00 | ES | Futures | 2497.2 | 2499.93 | 2496.93 | 2499.38 | 5663.0 |
| 2017-02-05 22:00:00 | ES | Futures | 2499.65 | 2499.65 | 2498.56 | 2498.84 | 1795.0 |
| 2017-02-05 23:00:00 | ES | Futures | 2499.11 | 2499.65 | 2498.56 | 2499.65 | 3163.0 |
| 2017-02-05 18:00:00 | NQ | Futures | 6154.04 | 6157.32 | 6144.2 | 6145.39 | 1655.0 |
| 2017-02-05 19:00:00 | NQ | Futures | 6145.09 | 6145.39 | 6140.91 | 6141.21 | 1052.0 |
| 2017-02-05 20:00:00 | NQ | Futures | 6141.51 | 6144.2 | 6140.32 | 6142.7 | 810.0 |
| 2017-02-05 21:00:00 | NQ | Futures | 6143.0 | 6150.16 | 6142.41 | 6148.67 | 1173.0 |
| 2017-02-05 22:00:00 | NQ | Futures | 6148.37 | 6149.27 | 6145.39 | 6148.97 | 566.0 |
| 2017-02-05 23:00:00 | NQ | Futures | 6148.67 | 6149.56 | 6146.28 | 6148.67 | 515.0 |
| 2017-02-05 18:00:00 | YM | Futures | 21686.6 | 21706.2 | 21670.4 | 21675.8 | 2104.0 |
| 2017-02-05 19:00:00 | YM | Futures | 21675.8 | 21675.8 | 21657.4 | 21659.5 | 1339.0 |
| 2017-02-05 20:00:00 | YM | Futures | 21660.6 | 21670.4 | 21655.2 | 21668.2 | 1229.0 |
| 2017-02-05 21:00:00 | YM | Futures | 21668.2 | 21688.8 | 21667.1 | 21685.6 | 1245.0 |
| 2017-02-05 22:00:00 | YM | Futures | 21686.6 | 21686.6 | 21676.9 | 21682.3 | 456.0 |
| 2017-02-05 23:00:00 | YM | Futures | 21681.2 | 21686.6 | 21676.9 | 21685.6 | 715.0 |
| 2017-02-05 18:00:00 | CL | Futures | 51.0 | 51.11 | 50.98 | 51.11 | 2168.0 |
| 2017-02-05 19:00:00 | CL | Futures | 51.1 | 51.13 | 51.06 | 51.09 | 1646.0 |
| 2017-02-05 20:00:00 | CL | Futures | 51.09 | 51.13 | 51.08 | 51.1 | 1267.0 |
| 2017-02-05 21:00:00 | CL | Futures | 51.1 | 51.11 | 51.07 | 51.11 | 855.0 |
| 2017-02-05 22:00:00 | CL | Futures | 51.11 | 51.23 | 51.09 | 51.21 | 2404.0 |
| 2017-02-05 23:00:00 | CL | Futures | 51.2 | 51.21 | 51.16 | 51.19 | 1277.0 |
| 2017-02-05 18:00:00 | GC | Futures | 1645.5 | 1651.9 | 1644.1 | 1646.5 | 5344.0 |
| 2017-02-05 19:00:00 | GC | Futures | 1646.5 | 1650.5 | 1645.3 | 1650.4 | 4681.0 |
| 2017-02-05 20:00:00 | GC | Futures | 1650.4 | 1652.4 | 1650.0 | 1650.8 | 8304.0 |
| 2017-02-05 21:00:00 | GC | Futures | 1650.9 | 1651.5 | 1649.2 | 1649.7 | 4165.0 |
| 2017-02-05 22:00:00 | GC | Futures | 1649.7 | 1651.1 | 1649.6 | 1650.1 | 2648.0 |
| 2017-02-05 23:00:00 | GC | Futures | 1650.1 | 1650.5 | 1648.9 | 1649.7 | 2147.0 |
| 2017-02-05 18:00:00 | ZN | Futures | 122.80166 | 122.894189 | 122.786238 | 122.817081 | 12758.0 |
| 2017-02-05 19:00:00 | ZN | Futures | 122.817081 | 122.971297 | 122.80166 | 122.955875 | 18332.0 |
| 2017-02-05 20:00:00 | ZN | Futures | 122.940454 | 122.955875 | 122.894189 | 122.894189 | 13077.0 |
| 2017-02-05 21:00:00 | ZN | Futures | 122.894189 | 122.955875 | 122.878767 | 122.955875 | 9309.0 |
| 2017-02-05 22:00:00 | ZN | Futures | 122.940454 | 122.971297 | 122.925032 | 122.940454 | 7587.0 |
| 2017-02-05 23:00:00 | ZN | Futures | 122.940454 | 122.940454 | 122.863346 | 122.863346 | 7644.0 |
> showing 36 of 298 rows — these rows as CSV