PREVIEW / futures_1hour / 2015-10-11
file: by_date/futures_1hour/2015/2015-10-11.parquet size: 14 KB rows: 265
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-11 18:00:00 | ES | Futures | 2146.23 | 2146.5 | 2142.75 | 2143.82 | 3824.0 |
| 2015-10-11 19:00:00 | ES | Futures | 2143.82 | 2145.43 | 2143.02 | 2143.29 | 2550.0 |
| 2015-10-11 20:00:00 | ES | Futures | 2143.29 | 2145.16 | 2142.49 | 2144.09 | 3259.0 |
| 2015-10-11 21:00:00 | ES | Futures | 2143.82 | 2145.96 | 2142.75 | 2145.7 | 4825.0 |
| 2015-10-11 22:00:00 | ES | Futures | 2145.96 | 2147.57 | 2145.16 | 2145.96 | 4387.0 |
| 2015-10-11 23:00:00 | ES | Futures | 2145.96 | 2147.03 | 2144.89 | 2145.16 | 2053.0 |
| 2015-10-11 18:00:00 | NQ | Futures | 5164.87 | 5164.87 | 5155.68 | 5158.05 | 811.0 |
| 2015-10-11 19:00:00 | NQ | Futures | 5158.05 | 5162.5 | 5155.98 | 5158.65 | 560.0 |
| 2015-10-11 20:00:00 | NQ | Futures | 5158.05 | 5159.83 | 5154.5 | 5156.57 | 499.0 |
| 2015-10-11 21:00:00 | NQ | Futures | 5157.16 | 5164.58 | 5154.79 | 5164.58 | 727.0 |
| 2015-10-11 22:00:00 | NQ | Futures | 5164.87 | 5169.02 | 5163.09 | 5165.47 | 812.0 |
| 2015-10-11 23:00:00 | NQ | Futures | 5166.65 | 5168.43 | 5162.8 | 5164.28 | 462.0 |
| 2015-10-11 18:00:00 | YM | Futures | 17977.6 | 17981.9 | 17950.1 | 17959.6 | 634.0 |
| 2015-10-11 19:00:00 | YM | Futures | 17960.7 | 17970.2 | 17952.2 | 17954.3 | 451.0 |
| 2015-10-11 20:00:00 | YM | Futures | 17954.3 | 17968.1 | 17946.9 | 17956.5 | 419.0 |
| 2015-10-11 21:00:00 | YM | Futures | 17958.6 | 17981.9 | 17953.3 | 17980.8 | 655.0 |
| 2015-10-11 22:00:00 | YM | Futures | 17981.9 | 17993.5 | 17976.6 | 17982.9 | 722.0 |
| 2015-10-11 23:00:00 | YM | Futures | 17984.0 | 17989.3 | 17974.5 | 17977.6 | 302.0 |
| 2015-10-11 18:00:00 | CL | Futures | 70.83 | 71.37 | 70.77 | 71.27 | 1392.0 |
| 2015-10-11 19:00:00 | CL | Futures | 71.27 | 71.42 | 71.26 | 71.33 | 457.0 |
| 2015-10-11 20:00:00 | CL | Futures | 71.32 | 71.34 | 71.17 | 71.24 | 756.0 |
| 2015-10-11 21:00:00 | CL | Futures | 71.26 | 71.32 | 71.16 | 71.29 | 1418.0 |
| 2015-10-11 22:00:00 | CL | Futures | 71.29 | 71.56 | 71.26 | 71.46 | 1482.0 |
| 2015-10-11 23:00:00 | CL | Futures | 71.46 | 71.67 | 71.46 | 71.6 | 1152.0 |
| 2015-10-11 18:00:00 | GC | Futures | 1577.0 | 1579.0 | 1576.3 | 1577.0 | 753.0 |
| 2015-10-11 19:00:00 | GC | Futures | 1576.8 | 1578.0 | 1576.7 | 1577.4 | 338.0 |
| 2015-10-11 20:00:00 | GC | Futures | 1577.2 | 1579.3 | 1576.0 | 1577.5 | 1278.0 |
| 2015-10-11 21:00:00 | GC | Futures | 1577.5 | 1580.9 | 1577.2 | 1580.2 | 1869.0 |
| 2015-10-11 22:00:00 | GC | Futures | 1580.1 | 1581.9 | 1579.7 | 1580.6 | 1593.0 |
| 2015-10-11 23:00:00 | GC | Futures | 1580.6 | 1581.6 | 1579.5 | 1579.5 | 871.0 |
| 2015-10-11 18:00:00 | ZN | Futures | 124.13977 | 124.13977 | 124.07942 | 124.094508 | 1135.0 |
| 2015-10-11 19:00:00 | ZN | Futures | 124.094508 | 124.109595 | 124.034158 | 124.094508 | 1969.0 |
| 2015-10-11 20:00:00 | ZN | Futures | 124.094508 | 124.13977 | 124.094508 | 124.124682 | 1316.0 |
| 2015-10-11 21:00:00 | ZN | Futures | 124.124682 | 124.13977 | 124.109595 | 124.13977 | 1837.0 |
| 2015-10-11 22:00:00 | ZN | Futures | 124.124682 | 124.124682 | 124.094508 | 124.109595 | 1368.0 |
| 2015-10-11 23:00:00 | ZN | Futures | 124.109595 | 124.124682 | 124.094508 | 124.109595 | 292.0 |
> showing 36 of 265 rows — these rows as CSV