PREVIEW / futures_1hour / 2017-07-23
file: by_date/futures_1hour/2017/2017-07-23.parquet size: 15 KB rows: 291
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-07-23 18:00:00 | ES | Futures | 2700.32 | 2701.14 | 2699.22 | 2700.04 | 2943.0 |
| 2017-07-23 19:00:00 | ES | Futures | 2700.32 | 2700.59 | 2698.68 | 2698.95 | 2574.0 |
| 2017-07-23 20:00:00 | ES | Futures | 2698.95 | 2699.22 | 2695.67 | 2696.76 | 7682.0 |
| 2017-07-23 21:00:00 | ES | Futures | 2696.76 | 2697.04 | 2693.76 | 2695.94 | 8922.0 |
| 2017-07-23 22:00:00 | ES | Futures | 2695.94 | 2696.49 | 2695.12 | 2696.22 | 2429.0 |
| 2017-07-23 23:00:00 | ES | Futures | 2696.49 | 2696.76 | 2695.12 | 2695.94 | 2146.0 |
| 2017-07-23 18:00:00 | NQ | Futures | 7049.86 | 7053.13 | 7048.96 | 7050.15 | 897.0 |
| 2017-07-23 19:00:00 | NQ | Futures | 7050.15 | 7052.24 | 7046.58 | 7046.58 | 630.0 |
| 2017-07-23 20:00:00 | NQ | Futures | 7047.18 | 7047.47 | 7039.43 | 7044.5 | 1497.0 |
| 2017-07-23 21:00:00 | NQ | Futures | 7044.5 | 7045.69 | 7034.08 | 7034.97 | 2909.0 |
| 2017-07-23 22:00:00 | NQ | Futures | 7035.27 | 7038.24 | 7032.88 | 7037.05 | 1268.0 |
| 2017-07-23 23:00:00 | NQ | Futures | 7037.35 | 7038.54 | 7032.88 | 7036.16 | 1513.0 |
| 2017-07-23 18:00:00 | YM | Futures | 23418.7 | 23432.8 | 23418.7 | 23423.0 | 404.0 |
| 2017-07-23 19:00:00 | YM | Futures | 23424.1 | 23427.4 | 23415.4 | 23418.7 | 298.0 |
| 2017-07-23 20:00:00 | YM | Futures | 23418.7 | 23418.7 | 23394.7 | 23406.7 | 1178.0 |
| 2017-07-23 21:00:00 | YM | Futures | 23406.7 | 23407.8 | 23386.0 | 23403.4 | 1182.0 |
| 2017-07-23 22:00:00 | YM | Futures | 23402.4 | 23408.9 | 23398.0 | 23408.9 | 414.0 |
| 2017-07-23 23:00:00 | YM | Futures | 23408.9 | 23411.1 | 23399.1 | 23406.7 | 480.0 |
| 2017-07-23 18:00:00 | CL | Futures | 41.37 | 41.51 | 41.34 | 41.48 | 2872.0 |
| 2017-07-23 19:00:00 | CL | Futures | 41.49 | 41.5 | 41.43 | 41.47 | 1293.0 |
| 2017-07-23 20:00:00 | CL | Futures | 41.47 | 41.48 | 41.37 | 41.46 | 2675.0 |
| 2017-07-23 21:00:00 | CL | Futures | 41.46 | 41.48 | 41.4 | 41.47 | 2685.0 |
| 2017-07-23 22:00:00 | CL | Futures | 41.47 | 41.61 | 41.43 | 41.6 | 7801.0 |
| 2017-07-23 23:00:00 | CL | Futures | 41.59 | 41.68 | 41.55 | 41.56 | 9565.0 |
| 2017-07-23 18:00:00 | GC | Futures | 1680.8 | 1681.2 | 1678.1 | 1678.6 | 2063.0 |
| 2017-07-23 19:00:00 | GC | Futures | 1678.7 | 1682.0 | 1678.6 | 1682.0 | 3690.0 |
| 2017-07-23 20:00:00 | GC | Futures | 1682.0 | 1683.6 | 1681.0 | 1681.5 | 4965.0 |
| 2017-07-23 21:00:00 | GC | Futures | 1681.4 | 1681.5 | 1679.0 | 1679.2 | 6091.0 |
| 2017-07-23 22:00:00 | GC | Futures | 1679.2 | 1680.0 | 1678.7 | 1679.0 | 3653.0 |
| 2017-07-23 23:00:00 | GC | Futures | 1679.0 | 1680.2 | 1678.7 | 1679.6 | 3273.0 |
| 2017-07-23 18:00:00 | ZN | Futures | 125.515375 | 125.546436 | 125.499845 | 125.546436 | 2840.0 |
| 2017-07-23 19:00:00 | ZN | Futures | 125.530905 | 125.593026 | 125.530905 | 125.577496 | 4167.0 |
| 2017-07-23 20:00:00 | ZN | Futures | 125.561966 | 125.608557 | 125.546436 | 125.561966 | 9603.0 |
| 2017-07-23 21:00:00 | ZN | Futures | 125.577496 | 125.593026 | 125.546436 | 125.561966 | 4137.0 |
| 2017-07-23 22:00:00 | ZN | Futures | 125.561966 | 125.561966 | 125.530905 | 125.546436 | 5446.0 |
| 2017-07-23 23:00:00 | ZN | Futures | 125.530905 | 125.561966 | 125.530905 | 125.530905 | 4889.0 |
> showing 36 of 291 rows — these rows as CSV