PREVIEW / futures_1hour / 2016-05-01
file: by_date/futures_1hour/2016/2016-05-01.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-05-01 18:00:00 | ES | Futures | 2225.45 | 2225.98 | 2223.02 | 2223.83 | 7962.0 |
| 2016-05-01 19:00:00 | ES | Futures | 2224.1 | 2224.64 | 2220.05 | 2221.67 | 8125.0 |
| 2016-05-01 20:00:00 | ES | Futures | 2221.94 | 2223.83 | 2219.78 | 2222.75 | 15706.0 |
| 2016-05-01 21:00:00 | ES | Futures | 2222.75 | 2223.56 | 2221.94 | 2222.75 | 5244.0 |
| 2016-05-01 22:00:00 | ES | Futures | 2222.48 | 2223.02 | 2221.67 | 2222.48 | 3865.0 |
| 2016-05-01 23:00:00 | ES | Futures | 2222.48 | 2223.56 | 2221.94 | 2222.21 | 3343.0 |
| 2016-05-01 18:00:00 | NQ | Futures | 5161.55 | 5163.63 | 5151.13 | 5152.32 | 1879.0 |
| 2016-05-01 19:00:00 | NQ | Futures | 5152.92 | 5153.81 | 5141.02 | 5143.99 | 2183.0 |
| 2016-05-01 20:00:00 | NQ | Futures | 5144.59 | 5149.94 | 5138.93 | 5146.67 | 1903.0 |
| 2016-05-01 21:00:00 | NQ | Futures | 5147.26 | 5148.75 | 5143.69 | 5145.78 | 522.0 |
| 2016-05-01 22:00:00 | NQ | Futures | 5145.48 | 5146.97 | 5143.69 | 5146.97 | 543.0 |
| 2016-05-01 23:00:00 | NQ | Futures | 5146.37 | 5150.54 | 5146.07 | 5146.97 | 622.0 |
| 2016-05-01 18:00:00 | YM | Futures | 18985.5 | 18993.0 | 18941.6 | 18949.1 | 1083.0 |
| 2016-05-01 19:00:00 | YM | Futures | 18950.2 | 18954.5 | 18921.3 | 18930.9 | 1190.0 |
| 2016-05-01 20:00:00 | YM | Futures | 18930.9 | 18948.0 | 18910.6 | 18934.1 | 2500.0 |
| 2016-05-01 21:00:00 | YM | Futures | 18936.3 | 18942.7 | 18927.7 | 18935.2 | 852.0 |
| 2016-05-01 22:00:00 | YM | Futures | 18934.1 | 18937.3 | 18926.6 | 18929.8 | 503.0 |
| 2016-05-01 23:00:00 | YM | Futures | 18929.8 | 18939.5 | 18927.7 | 18928.8 | 587.0 |
| 2016-05-01 18:00:00 | CL | Futures | 49.32 | 49.38 | 48.94 | 48.96 | 4146.0 |
| 2016-05-01 19:00:00 | CL | Futures | 48.99 | 49.08 | 48.95 | 49.06 | 1639.0 |
| 2016-05-01 20:00:00 | CL | Futures | 49.06 | 49.08 | 48.97 | 49.04 | 1862.0 |
| 2016-05-01 21:00:00 | CL | Futures | 49.04 | 49.08 | 48.99 | 49.01 | 1311.0 |
| 2016-05-01 22:00:00 | CL | Futures | 49.02 | 49.05 | 48.94 | 48.97 | 1355.0 |
| 2016-05-01 23:00:00 | CL | Futures | 48.97 | 49.01 | 48.86 | 48.86 | 1314.0 |
| 2016-05-01 18:00:00 | GC | Futures | 1763.7 | 1768.4 | 1762.8 | 1765.2 | 2156.0 |
| 2016-05-01 19:00:00 | GC | Futures | 1765.1 | 1771.0 | 1764.7 | 1768.9 | 2940.0 |
| 2016-05-01 20:00:00 | GC | Futures | 1769.1 | 1770.6 | 1765.7 | 1768.0 | 4600.0 |
| 2016-05-01 21:00:00 | GC | Futures | 1768.0 | 1768.7 | 1765.4 | 1767.7 | 2993.0 |
| 2016-05-01 22:00:00 | GC | Futures | 1767.7 | 1769.6 | 1766.7 | 1766.9 | 2619.0 |
| 2016-05-01 23:00:00 | GC | Futures | 1766.9 | 1767.2 | 1764.3 | 1764.6 | 2268.0 |
| 2016-05-01 18:00:00 | ZN | Futures | 126.514654 | 126.545085 | 126.484224 | 126.52987 | 5277.0 |
| 2016-05-01 19:00:00 | ZN | Futures | 126.545085 | 126.621161 | 126.52987 | 126.605946 | 6193.0 |
| 2016-05-01 20:00:00 | ZN | Futures | 126.605946 | 126.621161 | 126.5603 | 126.575515 | 7223.0 |
| 2016-05-01 21:00:00 | ZN | Futures | 126.575515 | 126.621161 | 126.5603 | 126.605946 | 5386.0 |
| 2016-05-01 22:00:00 | ZN | Futures | 126.605946 | 126.651591 | 126.605946 | 126.621161 | 4882.0 |
| 2016-05-01 23:00:00 | ZN | Futures | 126.636376 | 126.651591 | 126.605946 | 126.636376 | 2576.0 |
> showing 36 of 289 rows — these rows as CSV