PREVIEW / futures_1hour / 2017-12-10
file: by_date/futures_1hour/2017/2017-12-10.parquet size: 14 KB rows: 274
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-12-10 18:00:00 | ES | Futures | 2901.91 | 2904.92 | 2901.09 | 2903.28 | 5471.0 |
| 2017-12-10 19:00:00 | ES | Futures | 2903.28 | 2903.55 | 2901.36 | 2902.46 | 2716.0 |
| 2017-12-10 20:00:00 | ES | Futures | 2902.46 | 2903.28 | 2901.64 | 2902.73 | 2762.0 |
| 2017-12-10 21:00:00 | ES | Futures | 2903.0 | 2903.28 | 2901.64 | 2902.73 | 1195.0 |
| 2017-12-10 22:00:00 | ES | Futures | 2902.73 | 2904.37 | 2902.46 | 2903.82 | 1148.0 |
| 2017-12-10 23:00:00 | ES | Futures | 2903.82 | 2905.19 | 2903.82 | 2904.65 | 1570.0 |
| 2017-12-10 18:00:00 | NQ | Futures | 7546.05 | 7556.76 | 7546.05 | 7552.89 | 1062.0 |
| 2017-12-10 19:00:00 | NQ | Futures | 7553.49 | 7554.08 | 7549.02 | 7552.0 | 493.0 |
| 2017-12-10 20:00:00 | NQ | Futures | 7552.0 | 7555.27 | 7549.92 | 7554.97 | 612.0 |
| 2017-12-10 21:00:00 | NQ | Futures | 7555.27 | 7557.65 | 7551.7 | 7557.65 | 445.0 |
| 2017-12-10 22:00:00 | NQ | Futures | 7557.65 | 7563.89 | 7557.65 | 7562.41 | 530.0 |
| 2017-12-10 23:00:00 | NQ | Futures | 7562.71 | 7564.49 | 7559.73 | 7562.11 | 295.0 |
| 2017-12-10 18:00:00 | YM | Futures | 26465.5 | 26492.7 | 26455.8 | 26477.5 | 1464.0 |
| 2017-12-10 19:00:00 | YM | Futures | 26477.5 | 26478.6 | 26460.1 | 26468.8 | 803.0 |
| 2017-12-10 20:00:00 | YM | Futures | 26467.7 | 26480.7 | 26463.4 | 26471.0 | 786.0 |
| 2017-12-10 21:00:00 | YM | Futures | 26471.0 | 26474.2 | 26454.7 | 26467.7 | 752.0 |
| 2017-12-10 22:00:00 | YM | Futures | 26467.7 | 26486.2 | 26467.7 | 26481.8 | 842.0 |
| 2017-12-10 23:00:00 | YM | Futures | 26481.8 | 26496.0 | 26480.7 | 26488.4 | 609.0 |
| 2017-12-10 18:00:00 | CL | Futures | 50.77 | 50.79 | 50.67 | 50.72 | 2553.0 |
| 2017-12-10 19:00:00 | CL | Futures | 50.71 | 50.71 | 50.57 | 50.65 | 4271.0 |
| 2017-12-10 20:00:00 | CL | Futures | 50.65 | 50.72 | 50.64 | 50.66 | 2960.0 |
| 2017-12-10 21:00:00 | CL | Futures | 50.66 | 50.67 | 50.58 | 50.61 | 3459.0 |
| 2017-12-10 22:00:00 | CL | Futures | 50.61 | 50.66 | 50.59 | 50.66 | 1684.0 |
| 2017-12-10 23:00:00 | CL | Futures | 50.65 | 50.72 | 50.63 | 50.68 | 2828.0 |
| 2017-12-10 18:00:00 | GC | Futures | 1659.0 | 1661.6 | 1659.0 | 1660.8 | 2914.0 |
| 2017-12-10 19:00:00 | GC | Futures | 1660.7 | 1661.5 | 1659.1 | 1659.2 | 3696.0 |
| 2017-12-10 20:00:00 | GC | Futures | 1659.2 | 1660.6 | 1658.7 | 1660.3 | 4526.0 |
| 2017-12-10 21:00:00 | GC | Futures | 1660.3 | 1660.8 | 1659.5 | 1660.4 | 3792.0 |
| 2017-12-10 22:00:00 | GC | Futures | 1660.3 | 1661.4 | 1660.2 | 1660.7 | 2443.0 |
| 2017-12-10 23:00:00 | GC | Futures | 1660.6 | 1661.0 | 1660.0 | 1660.7 | 1412.0 |
| 2017-12-10 18:00:00 | ZN | Futures | 124.002712 | 124.033896 | 123.987121 | 124.018304 | 7480.0 |
| 2017-12-10 19:00:00 | ZN | Futures | 124.002712 | 124.033896 | 124.002712 | 124.002712 | 6214.0 |
| 2017-12-10 20:00:00 | ZN | Futures | 124.018304 | 124.033896 | 124.002712 | 124.002712 | 5155.0 |
| 2017-12-10 21:00:00 | ZN | Futures | 124.018304 | 124.049488 | 124.002712 | 124.033896 | 7156.0 |
| 2017-12-10 22:00:00 | ZN | Futures | 124.033896 | 124.06508 | 124.033896 | 124.033896 | 6006.0 |
| 2017-12-10 23:00:00 | ZN | Futures | 124.049488 | 124.06508 | 124.018304 | 124.033896 | 3016.0 |
> showing 36 of 274 rows — these rows as CSV