PREVIEW / futures_1hour / 2016-06-26
file: by_date/futures_1hour/2016/2016-06-26.parquet size: 16 KB rows: 304
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-06-26 18:00:00 | ES | Futures | 2184.41 | 2185.76 | 2173.83 | 2180.07 | 54227.0 |
| 2016-06-26 19:00:00 | ES | Futures | 2180.07 | 2181.42 | 2171.12 | 2177.36 | 30791.0 |
| 2016-06-26 20:00:00 | ES | Futures | 2177.36 | 2180.88 | 2173.83 | 2175.19 | 29907.0 |
| 2016-06-26 21:00:00 | ES | Futures | 2175.46 | 2179.53 | 2172.47 | 2178.71 | 25142.0 |
| 2016-06-26 22:00:00 | ES | Futures | 2178.98 | 2179.8 | 2175.46 | 2179.53 | 14102.0 |
| 2016-06-26 23:00:00 | ES | Futures | 2179.8 | 2183.32 | 2179.8 | 2181.69 | 13413.0 |
| 2016-06-26 18:00:00 | NQ | Futures | 5066.88 | 5070.45 | 5037.37 | 5051.97 | 4026.0 |
| 2016-06-26 19:00:00 | NQ | Futures | 5051.97 | 5057.64 | 5025.15 | 5047.21 | 2000.0 |
| 2016-06-26 20:00:00 | NQ | Futures | 5047.8 | 5056.15 | 5039.16 | 5041.54 | 2068.0 |
| 2016-06-26 21:00:00 | NQ | Futures | 5043.03 | 5051.97 | 5036.18 | 5051.68 | 1634.0 |
| 2016-06-26 22:00:00 | NQ | Futures | 5051.08 | 5054.95 | 5044.82 | 5054.66 | 1072.0 |
| 2016-06-26 23:00:00 | NQ | Futures | 5054.66 | 5065.68 | 5054.66 | 5063.0 | 1487.0 |
| 2016-06-26 18:00:00 | YM | Futures | 18494.6 | 18544.1 | 18426.8 | 18475.2 | 4453.0 |
| 2016-06-26 19:00:00 | YM | Futures | 18475.2 | 18489.2 | 18408.5 | 18454.8 | 3348.0 |
| 2016-06-26 20:00:00 | YM | Futures | 18454.8 | 18478.4 | 18431.1 | 18440.8 | 6261.0 |
| 2016-06-26 21:00:00 | YM | Futures | 18444.0 | 18469.8 | 18424.6 | 18464.4 | 5310.0 |
| 2016-06-26 22:00:00 | YM | Futures | 18466.6 | 18476.3 | 18440.8 | 18476.3 | 2407.0 |
| 2016-06-26 23:00:00 | YM | Futures | 18477.4 | 18508.6 | 18477.4 | 18497.8 | 2602.0 |
| 2016-06-26 18:00:00 | CL | Futures | 50.05 | 50.06 | 49.5 | 49.55 | 4828.0 |
| 2016-06-26 19:00:00 | CL | Futures | 49.55 | 49.57 | 49.12 | 49.26 | 4423.0 |
| 2016-06-26 20:00:00 | CL | Futures | 49.27 | 49.5 | 49.18 | 49.34 | 4774.0 |
| 2016-06-26 21:00:00 | CL | Futures | 49.34 | 49.64 | 49.26 | 49.53 | 7070.0 |
| 2016-06-26 22:00:00 | CL | Futures | 49.55 | 49.65 | 49.5 | 49.6 | 3322.0 |
| 2016-06-26 23:00:00 | CL | Futures | 49.6 | 49.71 | 49.56 | 49.62 | 2119.0 |
| 2016-06-26 18:00:00 | GC | Futures | 1799.5 | 1815.4 | 1799.3 | 1814.7 | 10974.0 |
| 2016-06-26 19:00:00 | GC | Futures | 1814.6 | 1823.6 | 1814.6 | 1818.9 | 9792.0 |
| 2016-06-26 20:00:00 | GC | Futures | 1818.9 | 1820.3 | 1814.7 | 1818.0 | 7161.0 |
| 2016-06-26 21:00:00 | GC | Futures | 1817.9 | 1817.9 | 1807.4 | 1813.2 | 15892.0 |
| 2016-06-26 22:00:00 | GC | Futures | 1813.1 | 1813.9 | 1809.4 | 1811.2 | 7267.0 |
| 2016-06-26 23:00:00 | GC | Futures | 1811.1 | 1811.2 | 1806.0 | 1807.5 | 4196.0 |
| 2016-06-26 18:00:00 | ZN | Futures | 129.268611 | 129.481625 | 129.222966 | 129.481625 | 30302.0 |
| 2016-06-26 19:00:00 | ZN | Futures | 129.466409 | 129.694638 | 129.451194 | 129.618562 | 25839.0 |
| 2016-06-26 20:00:00 | ZN | Futures | 129.603347 | 129.633777 | 129.542486 | 129.633777 | 20625.0 |
| 2016-06-26 21:00:00 | ZN | Futures | 129.633777 | 129.770714 | 129.572916 | 129.725068 | 22448.0 |
| 2016-06-26 22:00:00 | ZN | Futures | 129.709853 | 129.785929 | 129.679423 | 129.725068 | 11897.0 |
| 2016-06-26 23:00:00 | ZN | Futures | 129.709853 | 129.740284 | 129.572916 | 129.588131 | 18074.0 |
> showing 36 of 304 rows — these rows as CSV