PREVIEW / futures_1hour / 2017-09-24
file: by_date/futures_1hour/2017/2017-09-24.parquet size: 15 KB rows: 294
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 |
|---|---|---|---|---|---|---|---|
| 2017-09-24 18:00:00 | ES | Futures | 2734.49 | 2737.5 | 2732.85 | 2736.68 | 7615.0 |
| 2017-09-24 19:00:00 | ES | Futures | 2736.68 | 2740.51 | 2735.86 | 2739.14 | 8457.0 |
| 2017-09-24 20:00:00 | ES | Futures | 2739.14 | 2739.96 | 2737.77 | 2738.32 | 9731.0 |
| 2017-09-24 21:00:00 | ES | Futures | 2738.6 | 2738.87 | 2735.59 | 2736.41 | 8887.0 |
| 2017-09-24 22:00:00 | ES | Futures | 2736.41 | 2736.41 | 2735.04 | 2735.59 | 5589.0 |
| 2017-09-24 23:00:00 | ES | Futures | 2735.86 | 2735.86 | 2732.03 | 2733.12 | 8471.0 |
| 2017-09-24 18:00:00 | NQ | Futures | 7055.61 | 7068.99 | 7054.12 | 7066.61 | 1899.0 |
| 2017-09-24 19:00:00 | NQ | Futures | 7066.61 | 7081.78 | 7063.64 | 7079.11 | 2249.0 |
| 2017-09-24 20:00:00 | NQ | Futures | 7078.81 | 7083.57 | 7074.05 | 7076.13 | 2895.0 |
| 2017-09-24 21:00:00 | NQ | Futures | 7075.83 | 7077.32 | 7064.83 | 7066.91 | 2371.0 |
| 2017-09-24 22:00:00 | NQ | Futures | 7067.21 | 7067.51 | 7061.86 | 7064.53 | 1237.0 |
| 2017-09-24 23:00:00 | NQ | Futures | 7063.94 | 7063.94 | 7054.72 | 7059.48 | 2576.0 |
| 2017-09-24 18:00:00 | YM | Futures | 24255.4 | 24274.9 | 24241.2 | 24269.5 | 1113.0 |
| 2017-09-24 19:00:00 | YM | Futures | 24268.4 | 24302.1 | 24263.0 | 24291.3 | 1421.0 |
| 2017-09-24 20:00:00 | YM | Futures | 24291.3 | 24298.9 | 24285.8 | 24292.3 | 1716.0 |
| 2017-09-24 21:00:00 | YM | Futures | 24291.3 | 24293.4 | 24267.3 | 24270.6 | 1686.0 |
| 2017-09-24 22:00:00 | YM | Futures | 24271.7 | 24273.9 | 24263.0 | 24267.3 | 1332.0 |
| 2017-09-24 23:00:00 | YM | Futures | 24267.3 | 24267.3 | 24239.0 | 24247.7 | 1832.0 |
| 2017-09-24 18:00:00 | CL | Futures | 45.37 | 45.41 | 45.29 | 45.33 | 1731.0 |
| 2017-09-24 19:00:00 | CL | Futures | 45.34 | 45.34 | 45.32 | 45.32 | 426.0 |
| 2017-09-24 20:00:00 | CL | Futures | 45.32 | 45.33 | 45.28 | 45.3 | 1977.0 |
| 2017-09-24 21:00:00 | CL | Futures | 45.3 | 45.31 | 45.26 | 45.26 | 2066.0 |
| 2017-09-24 22:00:00 | CL | Futures | 45.26 | 45.29 | 45.25 | 45.29 | 1557.0 |
| 2017-09-24 23:00:00 | CL | Futures | 45.29 | 45.29 | 45.22 | 45.23 | 3708.0 |
| 2017-09-24 18:00:00 | GC | Futures | 1733.8 | 1733.8 | 1725.8 | 1727.1 | 4819.0 |
| 2017-09-24 19:00:00 | GC | Futures | 1727.0 | 1727.8 | 1720.7 | 1725.3 | 7499.0 |
| 2017-09-24 20:00:00 | GC | Futures | 1725.1 | 1726.3 | 1724.3 | 1725.4 | 5226.0 |
| 2017-09-24 21:00:00 | GC | Futures | 1725.3 | 1728.1 | 1725.1 | 1725.9 | 8571.0 |
| 2017-09-24 22:00:00 | GC | Futures | 1726.1 | 1726.3 | 1724.6 | 1724.6 | 5247.0 |
| 2017-09-24 23:00:00 | GC | Futures | 1724.6 | 1727.7 | 1724.6 | 1727.3 | 6547.0 |
| 2017-09-24 18:00:00 | ZN | Futures | 125.232126 | 125.263247 | 125.201004 | 125.201004 | 10538.0 |
| 2017-09-24 19:00:00 | ZN | Futures | 125.216565 | 125.263247 | 125.201004 | 125.216565 | 11954.0 |
| 2017-09-24 20:00:00 | ZN | Futures | 125.216565 | 125.263247 | 125.201004 | 125.247686 | 14682.0 |
| 2017-09-24 21:00:00 | ZN | Futures | 125.232126 | 125.294368 | 125.232126 | 125.294368 | 10131.0 |
| 2017-09-24 22:00:00 | ZN | Futures | 125.278808 | 125.294368 | 125.278808 | 125.278808 | 1029.0 |
| 2017-09-24 23:00:00 | ZN | Futures | 125.278808 | 125.309929 | 125.278808 | 125.294368 | 2889.0 |
> showing 36 of 294 rows — these rows as CSV