PREVIEW / futures_1hour / 2016-05-29
file: by_date/futures_1hour/2016/2016-05-29.parquet size: 13 KB rows: 245
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-29 18:00:00 | ES | Futures | 2267.83 | 2269.45 | 2266.48 | 2268.37 | 4988.0 |
| 2016-05-29 19:00:00 | ES | Futures | 2268.64 | 2271.34 | 2268.1 | 2269.18 | 8251.0 |
| 2016-05-29 20:00:00 | ES | Futures | 2269.18 | 2270.26 | 2268.64 | 2268.91 | 4150.0 |
| 2016-05-29 21:00:00 | ES | Futures | 2268.91 | 2270.53 | 2267.56 | 2268.91 | 5664.0 |
| 2016-05-29 22:00:00 | ES | Futures | 2269.18 | 2271.88 | 2268.91 | 2271.34 | 3867.0 |
| 2016-05-29 23:00:00 | ES | Futures | 2271.34 | 2271.88 | 2270.53 | 2271.07 | 2762.0 |
| 2016-05-29 18:00:00 | NQ | Futures | 5377.25 | 5377.85 | 5373.39 | 5376.96 | 563.0 |
| 2016-05-29 19:00:00 | NQ | Futures | 5376.06 | 5382.31 | 5374.87 | 5379.04 | 776.0 |
| 2016-05-29 20:00:00 | NQ | Futures | 5378.44 | 5379.63 | 5374.87 | 5375.77 | 366.0 |
| 2016-05-29 21:00:00 | NQ | Futures | 5375.17 | 5381.42 | 5372.2 | 5376.36 | 1093.0 |
| 2016-05-29 22:00:00 | NQ | Futures | 5377.25 | 5383.2 | 5376.36 | 5382.01 | 368.0 |
| 2016-05-29 23:00:00 | NQ | Futures | 5382.61 | 5384.99 | 5382.01 | 5383.8 | 448.0 |
| 2016-05-29 18:00:00 | YM | Futures | 19131.1 | 19145.0 | 19122.5 | 19135.4 | 869.0 |
| 2016-05-29 19:00:00 | YM | Futures | 19136.4 | 19155.7 | 19133.2 | 19145.0 | 1585.0 |
| 2016-05-29 20:00:00 | YM | Futures | 19143.9 | 19149.3 | 19140.7 | 19143.9 | 709.0 |
| 2016-05-29 21:00:00 | YM | Futures | 19142.9 | 19154.6 | 19133.2 | 19143.9 | 1285.0 |
| 2016-05-29 22:00:00 | YM | Futures | 19142.9 | 19166.4 | 19142.9 | 19166.4 | 963.0 |
| 2016-05-29 23:00:00 | YM | Futures | 19166.4 | 19169.6 | 19162.1 | 19164.3 | 745.0 |
| 2016-05-29 18:00:00 | CL | Futures | 52.56 | 52.75 | 52.54 | 52.72 | 1552.0 |
| 2016-05-29 19:00:00 | CL | Futures | 52.72 | 52.72 | 52.55 | 52.59 | 1989.0 |
| 2016-05-29 20:00:00 | CL | Futures | 52.6 | 52.62 | 52.43 | 52.45 | 2308.0 |
| 2016-05-29 21:00:00 | CL | Futures | 52.44 | 52.53 | 52.35 | 52.35 | 3819.0 |
| 2016-05-29 22:00:00 | CL | Futures | 52.36 | 52.39 | 52.32 | 52.37 | 1872.0 |
| 2016-05-29 23:00:00 | CL | Futures | 52.38 | 52.39 | 52.26 | 52.28 | 1426.0 |
| 2016-05-29 18:00:00 | GC | Futures | 1653.6 | 1654.7 | 1647.1 | 1648.4 | 2046.0 |
| 2016-05-29 19:00:00 | GC | Futures | 1648.7 | 1649.0 | 1644.1 | 1646.7 | 3135.0 |
| 2016-05-29 20:00:00 | GC | Futures | 1646.5 | 1646.5 | 1643.1 | 1644.6 | 3927.0 |
| 2016-05-29 21:00:00 | GC | Futures | 1644.3 | 1644.5 | 1636.0 | 1639.7 | 12835.0 |
| 2016-05-29 22:00:00 | GC | Futures | 1639.7 | 1641.2 | 1637.1 | 1640.9 | 4660.0 |
| 2016-05-29 23:00:00 | GC | Futures | 1641.1 | 1642.6 | 1638.8 | 1639.7 | 4037.0 |
| 2016-05-29 18:00:00 | ZN | Futures | 126.103843 | 126.134274 | 126.042982 | 126.058197 | 1840.0 |
| 2016-05-29 19:00:00 | ZN | Futures | 126.058197 | 126.103843 | 126.058197 | 126.103843 | 883.0 |
| 2016-05-29 20:00:00 | ZN | Futures | 126.103843 | 126.119058 | 126.027767 | 126.058197 | 3096.0 |
| 2016-05-29 21:00:00 | ZN | Futures | 126.058197 | 126.073413 | 126.027767 | 126.073413 | 2027.0 |
| 2016-05-29 22:00:00 | ZN | Futures | 126.058197 | 126.073413 | 126.058197 | 126.058197 | 1461.0 |
| 2016-05-29 23:00:00 | ZN | Futures | 126.073413 | 126.088628 | 126.073413 | 126.088628 | 298.0 |
> showing 36 of 245 rows — these rows as CSV