PREVIEW / futures_1hour / 2015-11-08
file: by_date/futures_1hour/2015/2015-11-08.parquet size: 15 KB rows: 284
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-08 18:00:00 | ES | Futures | 2239.08 | 2241.22 | 2237.74 | 2239.88 | 14524.0 |
| 2015-11-08 19:00:00 | ES | Futures | 2240.15 | 2240.95 | 2239.35 | 2239.62 | 3870.0 |
| 2015-11-08 20:00:00 | ES | Futures | 2239.62 | 2244.43 | 2239.35 | 2243.63 | 6780.0 |
| 2015-11-08 21:00:00 | ES | Futures | 2243.63 | 2245.24 | 2242.29 | 2243.9 | 4954.0 |
| 2015-11-08 22:00:00 | ES | Futures | 2243.9 | 2244.17 | 2241.76 | 2243.09 | 3519.0 |
| 2015-11-08 23:00:00 | ES | Futures | 2243.36 | 2244.17 | 2242.02 | 2242.56 | 2892.0 |
| 2015-11-08 18:00:00 | NQ | Futures | 5575.51 | 5577.0 | 5569.58 | 5576.4 | 1288.0 |
| 2015-11-08 19:00:00 | NQ | Futures | 5576.4 | 5577.0 | 5573.44 | 5574.33 | 1260.0 |
| 2015-11-08 20:00:00 | NQ | Futures | 5574.33 | 5586.48 | 5574.03 | 5583.22 | 1730.0 |
| 2015-11-08 21:00:00 | NQ | Futures | 5583.52 | 5589.15 | 5581.44 | 5587.08 | 1837.0 |
| 2015-11-08 22:00:00 | NQ | Futures | 5587.08 | 5589.15 | 5584.11 | 5587.67 | 1067.0 |
| 2015-11-08 23:00:00 | NQ | Futures | 5587.97 | 5588.56 | 5584.41 | 5585.59 | 850.0 |
| 2015-11-08 18:00:00 | YM | Futures | 18882.3 | 18900.3 | 18879.1 | 18891.8 | 1027.0 |
| 2015-11-08 19:00:00 | YM | Futures | 18893.9 | 18899.2 | 18886.5 | 18889.7 | 700.0 |
| 2015-11-08 20:00:00 | YM | Futures | 18889.7 | 18927.8 | 18887.5 | 18918.3 | 1368.0 |
| 2015-11-08 21:00:00 | YM | Futures | 18918.3 | 18929.9 | 18910.9 | 18919.3 | 1026.0 |
| 2015-11-08 22:00:00 | YM | Futures | 18918.3 | 18922.5 | 18906.6 | 18915.1 | 585.0 |
| 2015-11-08 23:00:00 | YM | Futures | 18915.1 | 18919.3 | 18908.7 | 18915.1 | 483.0 |
| 2015-11-08 18:00:00 | CL | Futures | 63.0 | 63.07 | 62.03 | 62.76 | 1781.0 |
| 2015-11-08 19:00:00 | CL | Futures | 62.72 | 62.93 | 62.68 | 62.92 | 943.0 |
| 2015-11-08 20:00:00 | CL | Futures | 62.93 | 63.19 | 62.79 | 63.03 | 4406.0 |
| 2015-11-08 21:00:00 | CL | Futures | 63.03 | 63.3 | 63.02 | 63.2 | 2312.0 |
| 2015-11-08 22:00:00 | CL | Futures | 63.22 | 63.26 | 63.17 | 63.22 | 484.0 |
| 2015-11-08 23:00:00 | CL | Futures | 63.2 | 63.24 | 63.16 | 63.22 | 372.0 |
| 2015-11-08 18:00:00 | GC | Futures | 1487.0 | 1489.3 | 1485.9 | 1487.1 | 2366.0 |
| 2015-11-08 19:00:00 | GC | Futures | 1487.1 | 1490.3 | 1485.9 | 1488.5 | 3376.0 |
| 2015-11-08 20:00:00 | GC | Futures | 1488.5 | 1491.2 | 1487.0 | 1490.9 | 4135.0 |
| 2015-11-08 21:00:00 | GC | Futures | 1490.8 | 1492.3 | 1490.8 | 1491.8 | 3451.0 |
| 2015-11-08 22:00:00 | GC | Futures | 1491.8 | 1492.3 | 1490.5 | 1492.2 | 2627.0 |
| 2015-11-08 23:00:00 | GC | Futures | 1492.0 | 1492.2 | 1490.7 | 1491.3 | 1302.0 |
| 2015-11-08 18:00:00 | ZN | Futures | 121.786123 | 121.801211 | 121.725773 | 121.755948 | 6612.0 |
| 2015-11-08 19:00:00 | ZN | Futures | 121.755948 | 121.771036 | 121.650336 | 121.650336 | 17533.0 |
| 2015-11-08 20:00:00 | ZN | Futures | 121.665424 | 121.680511 | 121.574899 | 121.605074 | 12933.0 |
| 2015-11-08 21:00:00 | ZN | Futures | 121.589986 | 121.620161 | 121.589986 | 121.620161 | 7301.0 |
| 2015-11-08 22:00:00 | ZN | Futures | 121.605074 | 121.635249 | 121.589986 | 121.620161 | 2931.0 |
| 2015-11-08 23:00:00 | ZN | Futures | 121.635249 | 121.650336 | 121.589986 | 121.605074 | 5843.0 |
> showing 36 of 284 rows — these rows as CSV