PREVIEW / futures_1hour / 2015-08-23
file: by_date/futures_1hour/2015/2015-08-23.parquet size: 16 KB rows: 298
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-08-23 18:00:00 | ES | Futures | 2092.18 | 2092.45 | 2077.27 | 2085.52 | 59135.0 |
| 2015-08-23 19:00:00 | ES | Futures | 2085.52 | 2088.98 | 2077.27 | 2085.79 | 33433.0 |
| 2015-08-23 20:00:00 | ES | Futures | 2086.06 | 2090.05 | 2084.19 | 2087.12 | 19921.0 |
| 2015-08-23 21:00:00 | ES | Futures | 2087.12 | 2089.78 | 2077.27 | 2081.8 | 29073.0 |
| 2015-08-23 22:00:00 | ES | Futures | 2081.8 | 2082.59 | 2048.25 | 2057.83 | 98299.0 |
| 2015-08-23 23:00:00 | ES | Futures | 2058.1 | 2058.63 | 2035.2 | 2041.59 | 98964.0 |
| 2015-08-23 18:00:00 | NQ | Futures | 4950.04 | 4950.04 | 4911.29 | 4930.51 | 7137.0 |
| 2015-08-23 19:00:00 | NQ | Futures | 4931.11 | 4937.32 | 4911.29 | 4928.15 | 3017.0 |
| 2015-08-23 20:00:00 | NQ | Futures | 4928.74 | 4940.87 | 4924.3 | 4931.4 | 1965.0 |
| 2015-08-23 21:00:00 | NQ | Futures | 4931.4 | 4939.39 | 4904.19 | 4918.09 | 3603.0 |
| 2015-08-23 22:00:00 | NQ | Futures | 4917.5 | 4918.09 | 4826.1 | 4840.59 | 19433.0 |
| 2015-08-23 23:00:00 | NQ | Futures | 4841.19 | 4841.48 | 4758.07 | 4763.1 | 16823.0 |
| 2015-08-23 18:00:00 | YM | Futures | 17282.0 | 17289.4 | 17175.6 | 17220.9 | 5225.0 |
| 2015-08-23 19:00:00 | YM | Futures | 17218.8 | 17244.1 | 17154.5 | 17226.2 | 3742.0 |
| 2015-08-23 20:00:00 | YM | Futures | 17227.2 | 17255.7 | 17214.6 | 17227.2 | 2658.0 |
| 2015-08-23 21:00:00 | YM | Futures | 17229.3 | 17252.5 | 17149.3 | 17188.3 | 4099.0 |
| 2015-08-23 22:00:00 | YM | Futures | 17185.1 | 17192.5 | 16920.7 | 16990.2 | 15810.0 |
| 2015-08-23 23:00:00 | YM | Futures | 16989.2 | 16997.6 | 16810.1 | 16856.4 | 13658.0 |
| 2015-08-23 18:00:00 | CL | Futures | 58.35 | 58.59 | 58.15 | 58.38 | 2202.0 |
| 2015-08-23 19:00:00 | CL | Futures | 58.38 | 58.41 | 57.83 | 58.0 | 1960.0 |
| 2015-08-23 20:00:00 | CL | Futures | 57.99 | 58.13 | 57.49 | 57.64 | 2835.0 |
| 2015-08-23 21:00:00 | CL | Futures | 57.65 | 57.73 | 57.19 | 57.42 | 4457.0 |
| 2015-08-23 22:00:00 | CL | Futures | 57.42 | 57.55 | 57.02 | 57.06 | 4695.0 |
| 2015-08-23 23:00:00 | CL | Futures | 57.06 | 57.23 | 56.47 | 57.15 | 7078.0 |
| 2015-08-23 18:00:00 | GC | Futures | 1584.1 | 1590.6 | 1584.1 | 1587.7 | 4504.0 |
| 2015-08-23 19:00:00 | GC | Futures | 1587.7 | 1587.7 | 1583.8 | 1587.2 | 1999.0 |
| 2015-08-23 20:00:00 | GC | Futures | 1587.2 | 1587.3 | 1581.5 | 1583.6 | 3247.0 |
| 2015-08-23 21:00:00 | GC | Futures | 1583.4 | 1589.4 | 1577.6 | 1583.2 | 11925.0 |
| 2015-08-23 22:00:00 | GC | Futures | 1583.1 | 1588.8 | 1582.6 | 1587.6 | 5733.0 |
| 2015-08-23 23:00:00 | GC | Futures | 1587.6 | 1587.9 | 1577.1 | 1582.1 | 6804.0 |
| 2015-08-23 18:00:00 | ZN | Futures | 123.941294 | 124.001416 | 123.896202 | 123.971355 | 14352.0 |
| 2015-08-23 19:00:00 | ZN | Futures | 123.986385 | 124.076568 | 123.911233 | 123.971355 | 17604.0 |
| 2015-08-23 20:00:00 | ZN | Futures | 123.956324 | 123.986385 | 123.881172 | 123.941294 | 10546.0 |
| 2015-08-23 21:00:00 | ZN | Futures | 123.941294 | 124.076568 | 123.911233 | 124.076568 | 25649.0 |
| 2015-08-23 22:00:00 | ZN | Futures | 124.076568 | 124.332086 | 124.061537 | 124.286995 | 57884.0 |
| 2015-08-23 23:00:00 | ZN | Futures | 124.286995 | 124.392208 | 124.13669 | 124.181781 | 43032.0 |
> showing 36 of 298 rows — these rows as CSV