PREVIEW / futures_1hour / 2015-11-01
file: by_date/futures_1hour/2015/2015-11-01.parquet size: 14 KB rows: 287
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-01 18:00:00 | ES | Futures | 2218.75 | 2219.82 | 2210.99 | 2213.93 | 12341.0 |
| 2015-11-01 19:00:00 | ES | Futures | 2213.93 | 2214.73 | 2212.59 | 2212.86 | 7083.0 |
| 2015-11-01 20:00:00 | ES | Futures | 2212.86 | 2215.0 | 2210.72 | 2212.06 | 13329.0 |
| 2015-11-01 21:00:00 | ES | Futures | 2212.06 | 2212.86 | 2210.99 | 2212.06 | 4772.0 |
| 2015-11-01 22:00:00 | ES | Futures | 2212.06 | 2213.13 | 2210.72 | 2210.72 | 5531.0 |
| 2015-11-01 23:00:00 | ES | Futures | 2210.99 | 2211.25 | 2209.38 | 2210.45 | 4139.0 |
| 2015-11-01 18:00:00 | NQ | Futures | 5508.21 | 5508.21 | 5492.79 | 5495.76 | 2869.0 |
| 2015-11-01 19:00:00 | NQ | Futures | 5495.76 | 5499.02 | 5493.39 | 5493.39 | 1321.0 |
| 2015-11-01 20:00:00 | NQ | Futures | 5493.39 | 5498.43 | 5487.16 | 5489.83 | 1903.0 |
| 2015-11-01 21:00:00 | NQ | Futures | 5490.12 | 5491.61 | 5487.75 | 5490.12 | 976.0 |
| 2015-11-01 22:00:00 | NQ | Futures | 5490.12 | 5492.5 | 5487.75 | 5488.64 | 991.0 |
| 2015-11-01 23:00:00 | NQ | Futures | 5488.35 | 5489.53 | 5485.68 | 5487.75 | 607.0 |
| 2015-11-01 18:00:00 | YM | Futures | 18640.7 | 18640.7 | 18579.3 | 18594.1 | 1913.0 |
| 2015-11-01 19:00:00 | YM | Futures | 18593.1 | 18601.5 | 18587.8 | 18588.8 | 599.0 |
| 2015-11-01 20:00:00 | YM | Futures | 18586.7 | 18604.7 | 18572.9 | 18581.4 | 1527.0 |
| 2015-11-01 21:00:00 | YM | Futures | 18582.5 | 18588.8 | 18576.1 | 18584.6 | 536.0 |
| 2015-11-01 22:00:00 | YM | Futures | 18582.5 | 18593.1 | 18572.9 | 18575.1 | 1028.0 |
| 2015-11-01 23:00:00 | YM | Futures | 18576.1 | 18579.3 | 18566.6 | 18570.8 | 535.0 |
| 2015-11-01 18:00:00 | CL | Futures | 65.71 | 65.71 | 65.39 | 65.44 | 1161.0 |
| 2015-11-01 19:00:00 | CL | Futures | 65.44 | 65.51 | 65.32 | 65.47 | 1009.0 |
| 2015-11-01 20:00:00 | CL | Futures | 65.48 | 65.68 | 65.32 | 65.62 | 1494.0 |
| 2015-11-01 21:00:00 | CL | Futures | 65.61 | 65.73 | 65.49 | 65.68 | 1172.0 |
| 2015-11-01 22:00:00 | CL | Futures | 65.68 | 65.71 | 65.58 | 65.69 | 641.0 |
| 2015-11-01 23:00:00 | CL | Futures | 65.71 | 65.71 | 65.56 | 65.59 | 456.0 |
| 2015-11-01 18:00:00 | GC | Futures | 1558.2 | 1558.9 | 1548.0 | 1556.9 | 5424.0 |
| 2015-11-01 19:00:00 | GC | Futures | 1557.0 | 1557.4 | 1555.4 | 1556.3 | 2144.0 |
| 2015-11-01 20:00:00 | GC | Futures | 1556.3 | 1556.6 | 1551.7 | 1554.3 | 4777.0 |
| 2015-11-01 21:00:00 | GC | Futures | 1554.3 | 1558.1 | 1554.3 | 1557.0 | 2177.0 |
| 2015-11-01 22:00:00 | GC | Futures | 1556.9 | 1558.5 | 1555.9 | 1556.3 | 1606.0 |
| 2015-11-01 23:00:00 | GC | Futures | 1556.3 | 1558.0 | 1556.2 | 1557.2 | 830.0 |
| 2015-11-01 18:00:00 | ZN | Futures | 123.370309 | 123.415571 | 123.340134 | 123.400484 | 8211.0 |
| 2015-11-01 19:00:00 | ZN | Futures | 123.400484 | 123.415571 | 123.370309 | 123.400484 | 4368.0 |
| 2015-11-01 20:00:00 | ZN | Futures | 123.400484 | 123.430658 | 123.325046 | 123.385396 | 11776.0 |
| 2015-11-01 21:00:00 | ZN | Futures | 123.385396 | 123.415571 | 123.370309 | 123.415571 | 4603.0 |
| 2015-11-01 22:00:00 | ZN | Futures | 123.415571 | 123.415571 | 123.370309 | 123.385396 | 3983.0 |
| 2015-11-01 23:00:00 | ZN | Futures | 123.370309 | 123.400484 | 123.370309 | 123.400484 | 2162.0 |
> showing 36 of 287 rows — these rows as CSV