PREVIEW / futures_1hour / 2017-09-10
file: by_date/futures_1hour/2017/2017-09-10.parquet size: 14 KB rows: 273
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-10 18:00:00 | ES | Futures | 2698.4 | 2703.87 | 2698.4 | 2701.69 | 9287.0 |
| 2017-09-10 19:00:00 | ES | Futures | 2701.96 | 2702.51 | 2700.04 | 2700.59 | 3873.0 |
| 2017-09-10 20:00:00 | ES | Futures | 2700.59 | 2702.51 | 2700.32 | 2702.23 | 3058.0 |
| 2017-09-10 21:00:00 | ES | Futures | 2701.96 | 2705.79 | 2701.96 | 2704.69 | 6857.0 |
| 2017-09-10 22:00:00 | ES | Futures | 2704.69 | 2705.79 | 2704.42 | 2705.51 | 1800.0 |
| 2017-09-10 23:00:00 | ES | Futures | 2705.51 | 2706.06 | 2705.24 | 2706.06 | 1876.0 |
| 2017-09-10 18:00:00 | NQ | Futures | 7061.17 | 7082.61 | 7061.17 | 7075.76 | 2130.0 |
| 2017-09-10 19:00:00 | NQ | Futures | 7076.06 | 7079.04 | 7073.38 | 7075.17 | 689.0 |
| 2017-09-10 20:00:00 | NQ | Futures | 7075.17 | 7081.42 | 7074.57 | 7079.93 | 752.0 |
| 2017-09-10 21:00:00 | NQ | Futures | 7079.93 | 7089.16 | 7079.33 | 7085.88 | 1430.0 |
| 2017-09-10 22:00:00 | NQ | Futures | 7085.88 | 7090.05 | 7085.59 | 7089.16 | 600.0 |
| 2017-09-10 23:00:00 | NQ | Futures | 7089.16 | 7091.24 | 7088.56 | 7090.65 | 317.0 |
| 2017-09-10 18:00:00 | YM | Futures | 23749.6 | 23783.3 | 23730.0 | 23769.2 | 1913.0 |
| 2017-09-10 19:00:00 | YM | Futures | 23770.3 | 23775.7 | 23761.6 | 23765.9 | 638.0 |
| 2017-09-10 20:00:00 | YM | Futures | 23765.9 | 23790.9 | 23765.9 | 23790.9 | 1324.0 |
| 2017-09-10 21:00:00 | YM | Futures | 23789.8 | 23817.0 | 23786.6 | 23808.3 | 1875.0 |
| 2017-09-10 22:00:00 | YM | Futures | 23809.4 | 23815.9 | 23808.3 | 23813.8 | 709.0 |
| 2017-09-10 23:00:00 | YM | Futures | 23813.8 | 23815.9 | 23810.5 | 23815.9 | 496.0 |
| 2017-09-10 18:00:00 | CL | Futures | 43.03 | 43.16 | 43.02 | 43.11 | 3280.0 |
| 2017-09-10 19:00:00 | CL | Futures | 43.12 | 43.16 | 43.09 | 43.12 | 1311.0 |
| 2017-09-10 20:00:00 | CL | Futures | 43.12 | 43.21 | 43.11 | 43.19 | 4341.0 |
| 2017-09-10 21:00:00 | CL | Futures | 43.2 | 43.29 | 43.2 | 43.26 | 6010.0 |
| 2017-09-10 22:00:00 | CL | Futures | 43.26 | 43.31 | 43.2 | 43.27 | 4738.0 |
| 2017-09-10 23:00:00 | CL | Futures | 43.26 | 43.27 | 43.25 | 43.27 | 1973.0 |
| 2017-09-10 18:00:00 | GC | Futures | 1787.1 | 1791.2 | 1781.5 | 1784.3 | 11341.0 |
| 2017-09-10 19:00:00 | GC | Futures | 1784.4 | 1789.3 | 1782.8 | 1788.0 | 5781.0 |
| 2017-09-10 20:00:00 | GC | Futures | 1787.9 | 1788.3 | 1785.5 | 1787.1 | 7031.0 |
| 2017-09-10 21:00:00 | GC | Futures | 1786.9 | 1789.2 | 1784.8 | 1786.1 | 13787.0 |
| 2017-09-10 22:00:00 | GC | Futures | 1786.3 | 1787.6 | 1786.1 | 1787.5 | 4690.0 |
| 2017-09-10 23:00:00 | GC | Futures | 1787.5 | 1788.1 | 1786.9 | 1787.5 | 2749.0 |
| 2017-09-10 18:00:00 | ZN | Futures | 126.75707 | 126.77263 | 126.648145 | 126.694827 | 21264.0 |
| 2017-09-10 19:00:00 | ZN | Futures | 126.710388 | 126.75707 | 126.694827 | 126.725948 | 11391.0 |
| 2017-09-10 20:00:00 | ZN | Futures | 126.741509 | 126.741509 | 126.679266 | 126.679266 | 11457.0 |
| 2017-09-10 21:00:00 | ZN | Futures | 126.694827 | 126.725948 | 126.679266 | 126.725948 | 13623.0 |
| 2017-09-10 22:00:00 | ZN | Futures | 126.725948 | 126.725948 | 126.694827 | 126.725948 | 6170.0 |
| 2017-09-10 23:00:00 | ZN | Futures | 126.725948 | 126.725948 | 126.710388 | 126.725948 | 3921.0 |
> showing 36 of 273 rows — these rows as CSV