PREVIEW / futures_1hour / 2016-07-03
file: by_date/futures_1hour/2016/2016-07-03.parquet size: 14 KB rows: 249
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-07-03 18:00:00 | ES | Futures | 2277.69 | 2277.69 | 2273.9 | 2274.98 | 4155.0 |
| 2016-07-03 19:00:00 | ES | Futures | 2274.98 | 2275.25 | 2271.46 | 2271.46 | 2351.0 |
| 2016-07-03 20:00:00 | ES | Futures | 2271.73 | 2275.8 | 2271.46 | 2273.63 | 4038.0 |
| 2016-07-03 21:00:00 | ES | Futures | 2273.9 | 2278.78 | 2273.63 | 2277.97 | 7227.0 |
| 2016-07-03 22:00:00 | ES | Futures | 2277.97 | 2278.78 | 2276.61 | 2277.15 | 4095.0 |
| 2016-07-03 23:00:00 | ES | Futures | 2277.15 | 2277.97 | 2275.8 | 2276.61 | 3037.0 |
| 2016-07-03 18:00:00 | NQ | Futures | 5291.91 | 5298.16 | 5286.54 | 5288.63 | 439.0 |
| 2016-07-03 19:00:00 | NQ | Futures | 5287.73 | 5288.63 | 5277.0 | 5277.6 | 397.0 |
| 2016-07-03 20:00:00 | NQ | Futures | 5277.9 | 5287.43 | 5277.0 | 5282.96 | 486.0 |
| 2016-07-03 21:00:00 | NQ | Futures | 5282.96 | 5295.78 | 5280.58 | 5294.29 | 813.0 |
| 2016-07-03 22:00:00 | NQ | Futures | 5294.59 | 5295.48 | 5290.42 | 5292.8 | 374.0 |
| 2016-07-03 23:00:00 | NQ | Futures | 5292.8 | 5295.18 | 5289.52 | 5291.01 | 355.0 |
| 2016-07-03 18:00:00 | YM | Futures | 19242.5 | 19261.9 | 19217.8 | 19226.4 | 545.0 |
| 2016-07-03 19:00:00 | YM | Futures | 19224.2 | 19228.6 | 19200.6 | 19200.6 | 392.0 |
| 2016-07-03 20:00:00 | YM | Futures | 19202.7 | 19233.9 | 19200.6 | 19216.7 | 892.0 |
| 2016-07-03 21:00:00 | YM | Futures | 19217.8 | 19257.6 | 19213.5 | 19250.1 | 1287.0 |
| 2016-07-03 22:00:00 | YM | Futures | 19251.2 | 19258.7 | 19243.6 | 19251.2 | 787.0 |
| 2016-07-03 23:00:00 | YM | Futures | 19251.2 | 19255.5 | 19238.2 | 19240.4 | 559.0 |
| 2016-07-03 18:00:00 | CL | Futures | 51.41 | 51.54 | 51.23 | 51.39 | 3276.0 |
| 2016-07-03 19:00:00 | CL | Futures | 51.39 | 51.39 | 51.29 | 51.3 | 1033.0 |
| 2016-07-03 20:00:00 | CL | Futures | 51.3 | 51.37 | 51.22 | 51.24 | 2196.0 |
| 2016-07-03 21:00:00 | CL | Futures | 51.24 | 51.39 | 51.14 | 51.35 | 4639.0 |
| 2016-07-03 22:00:00 | CL | Futures | 51.35 | 51.36 | 51.19 | 51.25 | 2439.0 |
| 2016-07-03 23:00:00 | CL | Futures | 51.24 | 51.34 | 51.23 | 51.26 | 1456.0 |
| 2016-07-03 18:00:00 | GC | Futures | 1830.4 | 1830.6 | 1821.5 | 1829.7 | 2230.0 |
| 2016-07-03 19:00:00 | GC | Futures | 1829.6 | 1833.9 | 1828.9 | 1830.9 | 2545.0 |
| 2016-07-03 20:00:00 | GC | Futures | 1831.2 | 1832.3 | 1827.8 | 1828.7 | 4970.0 |
| 2016-07-03 21:00:00 | GC | Futures | 1828.7 | 1841.9 | 1827.8 | 1839.1 | 20299.0 |
| 2016-07-03 22:00:00 | GC | Futures | 1839.1 | 1851.2 | 1832.4 | 1834.5 | 26952.0 |
| 2016-07-03 23:00:00 | GC | Futures | 1834.5 | 1838.1 | 1831.1 | 1835.4 | 9897.0 |
| 2016-07-03 18:00:00 | ZN | Futures | 129.801145 | 129.81636 | 129.709853 | 129.709853 | 2460.0 |
| 2016-07-03 19:00:00 | ZN | Futures | 129.709853 | 129.785929 | 129.648992 | 129.755499 | 3342.0 |
| 2016-07-03 20:00:00 | ZN | Futures | 129.770714 | 129.785929 | 129.694638 | 129.755499 | 5732.0 |
| 2016-07-03 21:00:00 | ZN | Futures | 129.755499 | 129.755499 | 129.679423 | 129.694638 | 3318.0 |
| 2016-07-03 22:00:00 | ZN | Futures | 129.694638 | 129.755499 | 129.679423 | 129.755499 | 1711.0 |
| 2016-07-03 23:00:00 | ZN | Futures | 129.755499 | 129.755499 | 129.709853 | 129.725068 | 3150.0 |
> showing 36 of 249 rows — these rows as CSV