PREVIEW / futures_1hour / 2014-05-11
file: by_date/futures_1hour/2014/2014-05-11.parquet size: 14 KB rows: 266
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-11 18:00:00 | ES | Futures | 1946.5 | 1950.39 | 1946.5 | 1949.87 | 7679.0 |
| 2014-05-11 19:00:00 | ES | Futures | 1949.61 | 1949.87 | 1948.83 | 1949.09 | 1614.0 |
| 2014-05-11 20:00:00 | ES | Futures | 1948.83 | 1950.39 | 1948.57 | 1950.39 | 3715.0 |
| 2014-05-11 21:00:00 | ES | Futures | 1950.39 | 1950.65 | 1948.57 | 1948.57 | 3758.0 |
| 2014-05-11 22:00:00 | ES | Futures | 1948.57 | 1949.87 | 1948.31 | 1949.09 | 4417.0 |
| 2014-05-11 23:00:00 | ES | Futures | 1949.09 | 1949.61 | 1948.57 | 1949.09 | 1540.0 |
| 2014-05-11 18:00:00 | NQ | Futures | 4134.48 | 4142.64 | 4133.32 | 4140.31 | 1160.0 |
| 2014-05-11 19:00:00 | NQ | Futures | 4140.31 | 4141.18 | 4139.43 | 4139.72 | 345.0 |
| 2014-05-11 20:00:00 | NQ | Futures | 4139.72 | 4145.26 | 4137.98 | 4144.09 | 988.0 |
| 2014-05-11 21:00:00 | NQ | Futures | 4144.38 | 4144.97 | 4138.27 | 4138.85 | 696.0 |
| 2014-05-11 22:00:00 | NQ | Futures | 4139.14 | 4142.93 | 4138.27 | 4141.47 | 830.0 |
| 2014-05-11 23:00:00 | NQ | Futures | 4140.89 | 4142.64 | 4140.89 | 4141.76 | 303.0 |
| 2014-05-11 18:00:00 | YM | Futures | 17024.6 | 17051.4 | 17023.6 | 17046.2 | 879.0 |
| 2014-05-11 19:00:00 | YM | Futures | 17046.2 | 17049.3 | 17040.1 | 17041.1 | 279.0 |
| 2014-05-11 20:00:00 | YM | Futures | 17040.1 | 17054.5 | 17035.9 | 17053.4 | 1009.0 |
| 2014-05-11 21:00:00 | YM | Futures | 17053.4 | 17056.5 | 17046.2 | 17047.3 | 1660.0 |
| 2014-05-11 22:00:00 | YM | Futures | 17047.3 | 17052.4 | 17044.2 | 17049.3 | 871.0 |
| 2014-05-11 23:00:00 | YM | Futures | 17048.3 | 17052.4 | 17046.2 | 17047.3 | 431.0 |
| 2014-05-11 18:00:00 | CL | Futures | 160.59 | 160.62 | 160.28 | 160.41 | 661.0 |
| 2014-05-11 19:00:00 | CL | Futures | 160.41 | 160.52 | 160.39 | 160.47 | 196.0 |
| 2014-05-11 20:00:00 | CL | Futures | 160.47 | 160.7 | 160.47 | 160.57 | 616.0 |
| 2014-05-11 21:00:00 | CL | Futures | 160.59 | 160.78 | 160.51 | 160.54 | 934.0 |
| 2014-05-11 22:00:00 | CL | Futures | 160.54 | 160.68 | 160.47 | 160.52 | 502.0 |
| 2014-05-11 23:00:00 | CL | Futures | 160.52 | 160.62 | 160.43 | 160.57 | 501.0 |
| 2014-05-11 18:00:00 | GC | Futures | 1766.9 | 1767.2 | 1750.3 | 1755.5 | 3458.0 |
| 2014-05-11 19:00:00 | GC | Futures | 1755.2 | 1759.6 | 1755.2 | 1758.3 | 1043.0 |
| 2014-05-11 20:00:00 | GC | Futures | 1758.1 | 1760.4 | 1756.5 | 1760.3 | 2040.0 |
| 2014-05-11 21:00:00 | GC | Futures | 1760.2 | 1765.4 | 1760.0 | 1764.1 | 4628.0 |
| 2014-05-11 22:00:00 | GC | Futures | 1764.3 | 1764.4 | 1762.1 | 1762.1 | 1013.0 |
| 2014-05-11 23:00:00 | GC | Futures | 1762.2 | 1771.3 | 1762.2 | 1768.9 | 3050.0 |
| 2014-05-11 18:00:00 | ZN | Futures | 116.996569 | 117.011198 | 116.938056 | 116.952685 | 3506.0 |
| 2014-05-11 19:00:00 | ZN | Futures | 116.967313 | 116.981941 | 116.938056 | 116.967313 | 4545.0 |
| 2014-05-11 20:00:00 | ZN | Futures | 116.967313 | 116.967313 | 116.850287 | 116.864915 | 18150.0 |
| 2014-05-11 21:00:00 | ZN | Futures | 116.864915 | 116.894172 | 116.850287 | 116.879543 | 6843.0 |
| 2014-05-11 22:00:00 | ZN | Futures | 116.879543 | 116.9088 | 116.864915 | 116.894172 | 3413.0 |
| 2014-05-11 23:00:00 | ZN | Futures | 116.894172 | 116.923428 | 116.879543 | 116.9088 | 965.0 |
> showing 36 of 266 rows — these rows as CSV