PREVIEW / futures_1hour / 2016-01-10
file: by_date/futures_1hour/2016/2016-01-10.parquet size: 15 KB rows: 289
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-10 18:00:00 | ES | Futures | 2052.13 | 2055.36 | 2035.2 | 2038.96 | 55198.0 |
| 2016-01-10 19:00:00 | ES | Futures | 2039.23 | 2045.14 | 2036.01 | 2041.38 | 27474.0 |
| 2016-01-10 20:00:00 | ES | Futures | 2041.38 | 2051.06 | 2038.16 | 2044.61 | 42719.0 |
| 2016-01-10 21:00:00 | ES | Futures | 2044.34 | 2050.52 | 2043.26 | 2049.44 | 18847.0 |
| 2016-01-10 22:00:00 | ES | Futures | 2049.44 | 2055.89 | 2044.61 | 2053.74 | 16104.0 |
| 2016-01-10 23:00:00 | ES | Futures | 2054.01 | 2056.97 | 2052.94 | 2055.36 | 8326.0 |
| 2016-01-10 18:00:00 | NQ | Futures | 5064.76 | 5064.76 | 5021.41 | 5027.05 | 9418.0 |
| 2016-01-10 19:00:00 | NQ | Futures | 5026.45 | 5044.27 | 5019.62 | 5034.47 | 4529.0 |
| 2016-01-10 20:00:00 | NQ | Futures | 5034.77 | 5051.1 | 5020.81 | 5037.44 | 10060.0 |
| 2016-01-10 21:00:00 | NQ | Futures | 5037.14 | 5048.43 | 5034.47 | 5045.16 | 5509.0 |
| 2016-01-10 22:00:00 | NQ | Futures | 5045.46 | 5062.98 | 5032.69 | 5059.12 | 3111.0 |
| 2016-01-10 23:00:00 | NQ | Futures | 5059.12 | 5069.21 | 5057.93 | 5065.05 | 1918.0 |
| 2016-01-10 18:00:00 | YM | Futures | 17308.4 | 17328.6 | 17124.3 | 17144.5 | 7314.0 |
| 2016-01-10 19:00:00 | YM | Futures | 17144.5 | 17197.7 | 17122.1 | 17164.7 | 4946.0 |
| 2016-01-10 20:00:00 | YM | Futures | 17164.7 | 17243.5 | 17144.5 | 17195.6 | 7316.0 |
| 2016-01-10 21:00:00 | YM | Futures | 17194.5 | 17236.0 | 17184.9 | 17229.6 | 4389.0 |
| 2016-01-10 22:00:00 | YM | Futures | 17230.7 | 17279.7 | 17189.2 | 17262.6 | 3696.0 |
| 2016-01-10 23:00:00 | YM | Futures | 17265.8 | 17289.3 | 17256.3 | 17278.6 | 2042.0 |
| 2016-01-10 18:00:00 | CL | Futures | 43.2 | 43.2 | 42.55 | 42.68 | 4494.0 |
| 2016-01-10 19:00:00 | CL | Futures | 42.68 | 42.79 | 42.53 | 42.74 | 2776.0 |
| 2016-01-10 20:00:00 | CL | Futures | 42.74 | 42.88 | 42.44 | 42.61 | 4204.0 |
| 2016-01-10 21:00:00 | CL | Futures | 42.62 | 42.78 | 42.53 | 42.68 | 3008.0 |
| 2016-01-10 22:00:00 | CL | Futures | 42.67 | 42.7 | 42.4 | 42.61 | 3612.0 |
| 2016-01-10 23:00:00 | CL | Futures | 42.61 | 42.7 | 42.55 | 42.61 | 1361.0 |
| 2016-01-10 18:00:00 | GC | Futures | 1507.2 | 1513.2 | 1506.9 | 1511.0 | 3363.0 |
| 2016-01-10 19:00:00 | GC | Futures | 1511.2 | 1513.6 | 1510.3 | 1510.9 | 2376.0 |
| 2016-01-10 20:00:00 | GC | Futures | 1510.9 | 1513.2 | 1508.4 | 1509.5 | 6110.0 |
| 2016-01-10 21:00:00 | GC | Futures | 1509.4 | 1509.7 | 1506.5 | 1508.3 | 3284.0 |
| 2016-01-10 22:00:00 | GC | Futures | 1508.3 | 1509.4 | 1506.7 | 1507.3 | 1619.0 |
| 2016-01-10 23:00:00 | GC | Futures | 1507.3 | 1507.9 | 1505.3 | 1507.2 | 1448.0 |
| 2016-01-10 18:00:00 | ZN | Futures | 123.737429 | 123.919351 | 123.707108 | 123.889031 | 20727.0 |
| 2016-01-10 19:00:00 | ZN | Futures | 123.889031 | 123.904191 | 123.85871 | 123.889031 | 5777.0 |
| 2016-01-10 20:00:00 | ZN | Futures | 123.87387 | 123.87387 | 123.737429 | 123.782909 | 16612.0 |
| 2016-01-10 21:00:00 | ZN | Futures | 123.782909 | 123.798069 | 123.737429 | 123.737429 | 5719.0 |
| 2016-01-10 22:00:00 | ZN | Futures | 123.737429 | 123.798069 | 123.631307 | 123.646468 | 10655.0 |
| 2016-01-10 23:00:00 | ZN | Futures | 123.646468 | 123.676788 | 123.646468 | 123.661628 | 5851.0 |
> showing 36 of 289 rows — these rows as CSV