PREVIEW / futures_1hour / 2015-01-25
file: by_date/futures_1hour/2015/2015-01-25.parquet size: 14 KB rows: 277
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-01-25 18:00:00 | ES | Futures | 2142.06 | 2143.11 | 2132.06 | 2133.37 | 28664.0 |
| 2015-01-25 19:00:00 | ES | Futures | 2133.11 | 2141.27 | 2132.85 | 2139.42 | 13852.0 |
| 2015-01-25 20:00:00 | ES | Futures | 2139.42 | 2140.74 | 2136.27 | 2139.95 | 6135.0 |
| 2015-01-25 21:00:00 | ES | Futures | 2139.95 | 2141.0 | 2138.11 | 2138.11 | 3555.0 |
| 2015-01-25 22:00:00 | ES | Futures | 2138.11 | 2139.69 | 2137.32 | 2137.85 | 2351.0 |
| 2015-01-25 23:00:00 | ES | Futures | 2137.85 | 2140.21 | 2137.32 | 2139.95 | 2455.0 |
| 2015-01-25 18:00:00 | NQ | Futures | 4992.12 | 4992.7 | 4970.97 | 4973.91 | 4292.0 |
| 2015-01-25 19:00:00 | NQ | Futures | 4973.32 | 4992.41 | 4973.03 | 4988.0 | 2020.0 |
| 2015-01-25 20:00:00 | NQ | Futures | 4988.0 | 4993.0 | 4981.25 | 4991.23 | 1218.0 |
| 2015-01-25 21:00:00 | NQ | Futures | 4991.23 | 4993.58 | 4985.95 | 4985.95 | 513.0 |
| 2015-01-25 22:00:00 | NQ | Futures | 4986.24 | 4989.77 | 4983.89 | 4984.48 | 412.0 |
| 2015-01-25 23:00:00 | NQ | Futures | 4984.77 | 4990.06 | 4983.89 | 4990.06 | 383.0 |
| 2015-01-25 18:00:00 | YM | Futures | 18286.6 | 18286.6 | 18196.9 | 18207.3 | 3138.0 |
| 2015-01-25 19:00:00 | YM | Futures | 18207.3 | 18266.8 | 18204.2 | 18250.1 | 1998.0 |
| 2015-01-25 20:00:00 | YM | Futures | 18250.1 | 18253.2 | 18223.0 | 18245.9 | 2388.0 |
| 2015-01-25 21:00:00 | YM | Futures | 18247.0 | 18255.3 | 18229.2 | 18230.3 | 741.0 |
| 2015-01-25 22:00:00 | YM | Futures | 18230.3 | 18242.8 | 18221.9 | 18226.1 | 602.0 |
| 2015-01-25 23:00:00 | YM | Futures | 18227.1 | 18244.9 | 18223.0 | 18243.8 | 622.0 |
| 2015-01-25 18:00:00 | CL | Futures | 75.89 | 76.14 | 74.46 | 74.63 | 8115.0 |
| 2015-01-25 19:00:00 | CL | Futures | 74.63 | 75.82 | 74.6 | 75.61 | 5549.0 |
| 2015-01-25 20:00:00 | CL | Futures | 75.61 | 75.93 | 75.42 | 75.82 | 3575.0 |
| 2015-01-25 21:00:00 | CL | Futures | 75.82 | 75.89 | 75.34 | 75.46 | 2084.0 |
| 2015-01-25 22:00:00 | CL | Futures | 75.47 | 75.71 | 75.42 | 75.61 | 1657.0 |
| 2015-01-25 23:00:00 | CL | Futures | 75.62 | 75.67 | 75.49 | 75.64 | 772.0 |
| 2015-01-25 18:00:00 | GC | Futures | 1768.6 | 1775.7 | 1764.4 | 1774.3 | 4641.0 |
| 2015-01-25 19:00:00 | GC | Futures | 1774.3 | 1777.3 | 1771.7 | 1774.1 | 2457.0 |
| 2015-01-25 20:00:00 | GC | Futures | 1774.2 | 1777.2 | 1772.0 | 1773.2 | 3590.0 |
| 2015-01-25 21:00:00 | GC | Futures | 1773.2 | 1773.7 | 1771.6 | 1772.7 | 2303.0 |
| 2015-01-25 22:00:00 | GC | Futures | 1773.0 | 1773.5 | 1768.9 | 1770.9 | 2054.0 |
| 2015-01-25 23:00:00 | GC | Futures | 1771.2 | 1771.6 | 1768.7 | 1770.4 | 1365.0 |
| 2015-01-25 18:00:00 | ZN | Futures | 123.618325 | 123.737189 | 123.573751 | 123.707473 | 18826.0 |
| 2015-01-25 19:00:00 | ZN | Futures | 123.692615 | 123.722331 | 123.633183 | 123.677757 | 9918.0 |
| 2015-01-25 20:00:00 | ZN | Futures | 123.662899 | 123.722331 | 123.662899 | 123.662899 | 3986.0 |
| 2015-01-25 21:00:00 | ZN | Futures | 123.677757 | 123.781763 | 123.662899 | 123.781763 | 5978.0 |
| 2015-01-25 22:00:00 | ZN | Futures | 123.766905 | 123.796621 | 123.722331 | 123.781763 | 4318.0 |
| 2015-01-25 23:00:00 | ZN | Futures | 123.766905 | 123.781763 | 123.707473 | 123.722331 | 2287.0 |
> showing 36 of 277 rows — these rows as CSV