PREVIEW / futures_1hour / 2017-10-22
file: by_date/futures_1hour/2017/2017-10-22.parquet size: 15 KB rows: 291
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-10-22 18:00:00 | ES | Futures | 2815.19 | 2819.29 | 2814.92 | 2817.93 | 9019.0 |
| 2017-10-22 19:00:00 | ES | Futures | 2817.93 | 2820.12 | 2817.65 | 2818.75 | 5878.0 |
| 2017-10-22 20:00:00 | ES | Futures | 2818.75 | 2819.29 | 2817.38 | 2818.47 | 9763.0 |
| 2017-10-22 21:00:00 | ES | Futures | 2818.47 | 2819.02 | 2817.11 | 2817.11 | 8591.0 |
| 2017-10-22 22:00:00 | ES | Futures | 2817.38 | 2818.2 | 2816.01 | 2816.83 | 6252.0 |
| 2017-10-22 23:00:00 | ES | Futures | 2816.83 | 2817.38 | 2816.83 | 2817.11 | 2165.0 |
| 2017-10-22 18:00:00 | NQ | Futures | 7268.26 | 7280.16 | 7267.97 | 7277.19 | 1654.0 |
| 2017-10-22 19:00:00 | NQ | Futures | 7277.19 | 7290.27 | 7276.0 | 7281.65 | 2225.0 |
| 2017-10-22 20:00:00 | NQ | Futures | 7281.05 | 7281.35 | 7273.02 | 7276.0 | 2242.0 |
| 2017-10-22 21:00:00 | NQ | Futures | 7276.29 | 7277.48 | 7269.75 | 7270.05 | 2015.0 |
| 2017-10-22 22:00:00 | NQ | Futures | 7270.34 | 7274.21 | 7265.59 | 7270.05 | 1710.0 |
| 2017-10-22 23:00:00 | NQ | Futures | 7270.34 | 7272.43 | 7270.05 | 7271.24 | 739.0 |
| 2017-10-22 18:00:00 | YM | Futures | 25312.6 | 25346.3 | 25305.0 | 25332.2 | 2167.0 |
| 2017-10-22 19:00:00 | YM | Futures | 25332.2 | 25355.0 | 25328.9 | 25346.3 | 1654.0 |
| 2017-10-22 20:00:00 | YM | Futures | 25345.2 | 25350.7 | 25327.8 | 25340.9 | 2485.0 |
| 2017-10-22 21:00:00 | YM | Futures | 25340.9 | 25350.7 | 25332.2 | 25333.3 | 1867.0 |
| 2017-10-22 22:00:00 | YM | Futures | 25334.3 | 25340.9 | 25321.3 | 25328.9 | 1287.0 |
| 2017-10-22 23:00:00 | YM | Futures | 25328.9 | 25334.3 | 25327.8 | 25331.1 | 509.0 |
| 2017-10-22 18:00:00 | CL | Futures | 46.36 | 46.52 | 46.35 | 46.42 | 4105.0 |
| 2017-10-22 19:00:00 | CL | Futures | 46.42 | 46.45 | 46.39 | 46.39 | 1191.0 |
| 2017-10-22 20:00:00 | CL | Futures | 46.39 | 46.43 | 46.31 | 46.33 | 3349.0 |
| 2017-10-22 21:00:00 | CL | Futures | 46.33 | 46.44 | 46.28 | 46.35 | 4749.0 |
| 2017-10-22 22:00:00 | CL | Futures | 46.35 | 46.38 | 46.32 | 46.35 | 2194.0 |
| 2017-10-22 23:00:00 | CL | Futures | 46.34 | 46.39 | 46.32 | 46.39 | 1539.0 |
| 2017-10-22 18:00:00 | GC | Futures | 1707.1 | 1707.1 | 1702.9 | 1703.9 | 3142.0 |
| 2017-10-22 19:00:00 | GC | Futures | 1703.9 | 1704.5 | 1699.0 | 1700.4 | 6903.0 |
| 2017-10-22 20:00:00 | GC | Futures | 1700.2 | 1701.7 | 1699.2 | 1701.6 | 8205.0 |
| 2017-10-22 21:00:00 | GC | Futures | 1701.6 | 1701.9 | 1699.3 | 1701.4 | 7950.0 |
| 2017-10-22 22:00:00 | GC | Futures | 1701.4 | 1703.8 | 1701.3 | 1701.7 | 8776.0 |
| 2017-10-22 23:00:00 | GC | Futures | 1701.6 | 1702.7 | 1700.9 | 1702.2 | 4373.0 |
| 2017-10-22 18:00:00 | ZN | Futures | 124.267365 | 124.282926 | 124.251805 | 124.251805 | 14803.0 |
| 2017-10-22 19:00:00 | ZN | Futures | 124.267365 | 124.267365 | 124.205123 | 124.236244 | 20378.0 |
| 2017-10-22 20:00:00 | ZN | Futures | 124.236244 | 124.267365 | 124.220683 | 124.251805 | 15542.0 |
| 2017-10-22 21:00:00 | ZN | Futures | 124.251805 | 124.267365 | 124.236244 | 124.267365 | 10529.0 |
| 2017-10-22 22:00:00 | ZN | Futures | 124.282926 | 124.314047 | 124.267365 | 124.298487 | 10274.0 |
| 2017-10-22 23:00:00 | ZN | Futures | 124.298487 | 124.314047 | 124.298487 | 124.298487 | 1035.0 |
> showing 36 of 291 rows — these rows as CSV