PREVIEW / futures_1hour / 2016-01-17
file: by_date/futures_1hour/2016/2016-01-17.parquet size: 14 KB rows: 261
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 |
|---|---|---|---|---|---|---|---|
| 2016-01-17 18:00:00 | ES | Futures | 2009.67 | 2013.17 | 1998.93 | 2009.14 | 31257.0 |
| 2016-01-17 19:00:00 | ES | Futures | 2008.87 | 2012.09 | 2005.11 | 2010.21 | 18504.0 |
| 2016-01-17 20:00:00 | ES | Futures | 2010.21 | 2019.62 | 2008.6 | 2018.27 | 27046.0 |
| 2016-01-17 21:00:00 | ES | Futures | 2018.27 | 2019.35 | 2011.02 | 2017.2 | 11657.0 |
| 2016-01-17 22:00:00 | ES | Futures | 2017.2 | 2022.57 | 2015.59 | 2020.42 | 10473.0 |
| 2016-01-17 23:00:00 | ES | Futures | 2020.69 | 2022.57 | 2018.27 | 2019.08 | 6223.0 |
| 2016-01-17 18:00:00 | NQ | Futures | 4901.45 | 4915.1 | 4878.58 | 4905.6 | 3198.0 |
| 2016-01-17 19:00:00 | NQ | Futures | 4904.41 | 4911.84 | 4892.24 | 4908.57 | 4343.0 |
| 2016-01-17 20:00:00 | NQ | Futures | 4908.87 | 4934.11 | 4902.93 | 4930.54 | 5157.0 |
| 2016-01-17 21:00:00 | NQ | Futures | 4930.54 | 4934.11 | 4912.14 | 4928.47 | 2290.0 |
| 2016-01-17 22:00:00 | NQ | Futures | 4928.47 | 4942.42 | 4923.12 | 4936.48 | 2028.0 |
| 2016-01-17 23:00:00 | NQ | Futures | 4937.08 | 4942.13 | 4930.25 | 4931.73 | 1426.0 |
| 2016-01-17 18:00:00 | YM | Futures | 16898.6 | 16934.8 | 16812.4 | 16898.6 | 6081.0 |
| 2016-01-17 19:00:00 | YM | Futures | 16898.6 | 16928.4 | 16874.1 | 16915.6 | 6074.0 |
| 2016-01-17 20:00:00 | YM | Futures | 16915.6 | 16993.3 | 16902.9 | 16985.9 | 6825.0 |
| 2016-01-17 21:00:00 | YM | Futures | 16981.6 | 16990.1 | 16922.0 | 16969.9 | 2421.0 |
| 2016-01-17 22:00:00 | YM | Futures | 16973.1 | 17017.8 | 16953.9 | 16996.5 | 1758.0 |
| 2016-01-17 23:00:00 | YM | Futures | 16998.7 | 17014.6 | 16980.6 | 16984.8 | 1063.0 |
| 2016-01-17 18:00:00 | CL | Futures | 38.43 | 38.47 | 37.39 | 37.88 | 10170.0 |
| 2016-01-17 19:00:00 | CL | Futures | 37.9 | 38.05 | 37.87 | 38.0 | 2909.0 |
| 2016-01-17 20:00:00 | CL | Futures | 38.01 | 38.58 | 38.0 | 38.42 | 5096.0 |
| 2016-01-17 21:00:00 | CL | Futures | 38.41 | 38.57 | 38.16 | 38.52 | 3869.0 |
| 2016-01-17 22:00:00 | CL | Futures | 38.52 | 38.65 | 38.41 | 38.48 | 1698.0 |
| 2016-01-17 23:00:00 | CL | Futures | 38.48 | 38.56 | 38.25 | 38.28 | 2218.0 |
| 2016-01-17 18:00:00 | GC | Futures | 1487.7 | 1489.7 | 1487.3 | 1488.9 | 1231.0 |
| 2016-01-17 19:00:00 | GC | Futures | 1488.9 | 1490.3 | 1488.5 | 1489.6 | 930.0 |
| 2016-01-17 20:00:00 | GC | Futures | 1489.6 | 1492.7 | 1489.3 | 1490.1 | 3678.0 |
| 2016-01-17 21:00:00 | GC | Futures | 1490.1 | 1492.2 | 1489.3 | 1492.0 | 1320.0 |
| 2016-01-17 22:00:00 | GC | Futures | 1492.2 | 1493.1 | 1490.8 | 1490.8 | 1194.0 |
| 2016-01-17 23:00:00 | GC | Futures | 1490.8 | 1491.8 | 1490.4 | 1491.8 | 632.0 |
| 2016-01-17 18:00:00 | ZN | Futures | 124.67736 | 124.768321 | 124.64704 | 124.6622 | 7836.0 |
| 2016-01-17 19:00:00 | ZN | Futures | 124.67736 | 124.753161 | 124.6622 | 124.69252 | 7372.0 |
| 2016-01-17 20:00:00 | ZN | Futures | 124.707681 | 124.707681 | 124.510598 | 124.556079 | 12776.0 |
| 2016-01-17 21:00:00 | ZN | Futures | 124.556079 | 124.586399 | 124.525758 | 124.525758 | 5267.0 |
| 2016-01-17 22:00:00 | ZN | Futures | 124.525758 | 124.571239 | 124.495438 | 124.510598 | 4805.0 |
| 2016-01-17 23:00:00 | ZN | Futures | 124.510598 | 124.540919 | 124.495438 | 124.525758 | 3044.0 |
> showing 36 of 261 rows — these rows as CSV