PREVIEW / futures_1hour / 2018-01-28
file: by_date/futures_1hour/2018/2018-01-28.parquet size: 15 KB rows: 313
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 |
|---|---|---|---|---|---|---|---|
| 2018-01-28 18:00:00 | ES | Futures | 3142.45 | 3145.73 | 3141.63 | 3145.19 | 14375.0 |
| 2018-01-28 19:00:00 | ES | Futures | 3145.46 | 3146.83 | 3144.09 | 3146.28 | 10307.0 |
| 2018-01-28 20:00:00 | ES | Futures | 3146.01 | 3147.1 | 3145.73 | 3146.55 | 6683.0 |
| 2018-01-28 21:00:00 | ES | Futures | 3146.28 | 3146.55 | 3145.19 | 3145.46 | 4751.0 |
| 2018-01-28 22:00:00 | ES | Futures | 3145.46 | 3145.46 | 3140.27 | 3141.63 | 10920.0 |
| 2018-01-28 23:00:00 | ES | Futures | 3141.91 | 3143.27 | 3141.36 | 3142.18 | 3590.0 |
| 2018-01-28 18:00:00 | NQ | Futures | 8340.23 | 8356.25 | 8340.23 | 8353.58 | 4531.0 |
| 2018-01-28 19:00:00 | NQ | Futures | 8353.58 | 8360.4 | 8351.8 | 8358.32 | 2389.0 |
| 2018-01-28 20:00:00 | NQ | Futures | 8358.03 | 8360.7 | 8350.31 | 8355.06 | 2869.0 |
| 2018-01-28 21:00:00 | NQ | Futures | 8355.06 | 8356.25 | 8352.09 | 8352.98 | 1007.0 |
| 2018-01-28 22:00:00 | NQ | Futures | 8353.28 | 8353.28 | 8334.6 | 8337.86 | 3237.0 |
| 2018-01-28 23:00:00 | NQ | Futures | 8337.86 | 8342.9 | 8337.86 | 8340.82 | 1125.0 |
| 2018-01-28 18:00:00 | YM | Futures | 28893.6 | 28973.0 | 28890.4 | 28967.5 | 5273.0 |
| 2018-01-28 19:00:00 | YM | Futures | 28967.5 | 29000.1 | 28964.3 | 28987.1 | 2616.0 |
| 2018-01-28 20:00:00 | YM | Futures | 28986.0 | 29002.3 | 28986.0 | 28994.7 | 1994.0 |
| 2018-01-28 21:00:00 | YM | Futures | 28993.6 | 28995.8 | 28976.2 | 28978.4 | 1177.0 |
| 2018-01-28 22:00:00 | YM | Futures | 28978.4 | 28981.7 | 28926.2 | 28934.9 | 3066.0 |
| 2018-01-28 23:00:00 | YM | Futures | 28936.0 | 28955.6 | 28936.0 | 28948.0 | 1254.0 |
| 2018-01-28 18:00:00 | CL | Futures | 58.77 | 58.85 | 58.7 | 58.85 | 3847.0 |
| 2018-01-28 19:00:00 | CL | Futures | 58.85 | 59.02 | 58.77 | 58.92 | 6876.0 |
| 2018-01-28 20:00:00 | CL | Futures | 58.91 | 59.0 | 58.87 | 58.93 | 7874.0 |
| 2018-01-28 21:00:00 | CL | Futures | 58.93 | 58.96 | 58.86 | 58.92 | 5119.0 |
| 2018-01-28 22:00:00 | CL | Futures | 58.91 | 58.96 | 58.89 | 58.95 | 4078.0 |
| 2018-01-28 23:00:00 | CL | Futures | 58.95 | 58.98 | 58.93 | 58.94 | 2183.0 |
| 2018-01-28 18:00:00 | GC | Futures | 1791.4 | 1793.2 | 1790.2 | 1793.0 | 2153.0 |
| 2018-01-28 19:00:00 | GC | Futures | 1793.1 | 1794.8 | 1791.6 | 1792.6 | 2590.0 |
| 2018-01-28 20:00:00 | GC | Futures | 1792.7 | 1793.6 | 1788.2 | 1789.7 | 6278.0 |
| 2018-01-28 21:00:00 | GC | Futures | 1789.5 | 1789.7 | 1786.5 | 1788.9 | 4563.0 |
| 2018-01-28 22:00:00 | GC | Futures | 1788.7 | 1790.7 | 1788.5 | 1789.9 | 2859.0 |
| 2018-01-28 23:00:00 | GC | Futures | 1789.9 | 1790.2 | 1788.7 | 1789.0 | 1694.0 |
| 2018-01-28 18:00:00 | ZN | Futures | 121.788657 | 121.835433 | 121.773065 | 121.835433 | 11330.0 |
| 2018-01-28 19:00:00 | ZN | Futures | 121.851025 | 121.866616 | 121.788657 | 121.788657 | 17198.0 |
| 2018-01-28 20:00:00 | ZN | Futures | 121.788657 | 121.788657 | 121.585962 | 121.648329 | 82835.0 |
| 2018-01-28 21:00:00 | ZN | Futures | 121.648329 | 121.663921 | 121.617145 | 121.632737 | 19304.0 |
| 2018-01-28 22:00:00 | ZN | Futures | 121.648329 | 121.695105 | 121.617145 | 121.679513 | 18648.0 |
| 2018-01-28 23:00:00 | ZN | Futures | 121.679513 | 121.695105 | 121.663921 | 121.695105 | 6549.0 |
> showing 36 of 313 rows — these rows as CSV