PREVIEW / futures_1hour / 2017-08-13
file: by_date/futures_1hour/2017/2017-08-13.parquet size: 14 KB rows: 281
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-08-13 18:00:00 | ES | Futures | 2669.43 | 2673.53 | 2669.43 | 2672.98 | 8880.0 |
| 2017-08-13 19:00:00 | ES | Futures | 2672.71 | 2675.72 | 2672.71 | 2675.17 | 6929.0 |
| 2017-08-13 20:00:00 | ES | Futures | 2675.17 | 2678.18 | 2674.9 | 2677.63 | 14964.0 |
| 2017-08-13 21:00:00 | ES | Futures | 2677.9 | 2678.45 | 2675.72 | 2676.26 | 8570.0 |
| 2017-08-13 22:00:00 | ES | Futures | 2676.54 | 2677.08 | 2675.72 | 2677.08 | 3691.0 |
| 2017-08-13 23:00:00 | ES | Futures | 2677.36 | 2678.45 | 2677.08 | 2677.63 | 3136.0 |
| 2017-08-13 18:00:00 | NQ | Futures | 6952.19 | 6973.93 | 6952.19 | 6967.08 | 2684.0 |
| 2017-08-13 19:00:00 | NQ | Futures | 6967.08 | 6981.97 | 6967.08 | 6981.67 | 2625.0 |
| 2017-08-13 20:00:00 | NQ | Futures | 6981.67 | 7000.73 | 6981.08 | 6991.2 | 4855.0 |
| 2017-08-13 21:00:00 | NQ | Futures | 6991.2 | 6995.67 | 6983.16 | 6987.03 | 2105.0 |
| 2017-08-13 22:00:00 | NQ | Futures | 6986.14 | 6988.22 | 6983.46 | 6987.03 | 814.0 |
| 2017-08-13 23:00:00 | NQ | Futures | 6987.33 | 6992.69 | 6985.84 | 6991.2 | 938.0 |
| 2017-08-13 18:00:00 | YM | Futures | 23784.4 | 23817.1 | 23784.4 | 23808.4 | 1029.0 |
| 2017-08-13 19:00:00 | YM | Futures | 23808.4 | 23835.6 | 23808.4 | 23834.5 | 1228.0 |
| 2017-08-13 20:00:00 | YM | Futures | 23835.6 | 23860.6 | 23832.3 | 23858.4 | 2232.0 |
| 2017-08-13 21:00:00 | YM | Futures | 23859.5 | 23865.0 | 23846.5 | 23853.0 | 1448.0 |
| 2017-08-13 22:00:00 | YM | Futures | 23851.9 | 23857.3 | 23847.5 | 23855.2 | 559.0 |
| 2017-08-13 23:00:00 | YM | Futures | 23855.2 | 23861.7 | 23855.2 | 23858.4 | 425.0 |
| 2017-08-13 18:00:00 | CL | Futures | 44.25 | 44.27 | 44.2 | 44.25 | 1507.0 |
| 2017-08-13 19:00:00 | CL | Futures | 44.26 | 44.32 | 44.24 | 44.3 | 1557.0 |
| 2017-08-13 20:00:00 | CL | Futures | 44.3 | 44.33 | 44.27 | 44.32 | 1645.0 |
| 2017-08-13 21:00:00 | CL | Futures | 44.32 | 44.35 | 44.21 | 44.25 | 4539.0 |
| 2017-08-13 22:00:00 | CL | Futures | 44.24 | 44.27 | 44.18 | 44.22 | 2927.0 |
| 2017-08-13 23:00:00 | CL | Futures | 44.21 | 44.3 | 44.21 | 44.3 | 2425.0 |
| 2017-08-13 18:00:00 | GC | Futures | 1727.0 | 1727.0 | 1723.4 | 1724.3 | 2848.0 |
| 2017-08-13 19:00:00 | GC | Futures | 1724.3 | 1725.4 | 1723.3 | 1724.5 | 4209.0 |
| 2017-08-13 20:00:00 | GC | Futures | 1724.3 | 1725.0 | 1721.5 | 1721.8 | 6533.0 |
| 2017-08-13 21:00:00 | GC | Futures | 1721.8 | 1723.1 | 1719.8 | 1722.9 | 9848.0 |
| 2017-08-13 22:00:00 | GC | Futures | 1722.9 | 1723.4 | 1722.3 | 1723.1 | 3055.0 |
| 2017-08-13 23:00:00 | GC | Futures | 1723.1 | 1725.5 | 1723.0 | 1723.5 | 7375.0 |
| 2017-08-13 18:00:00 | ZN | Futures | 125.981282 | 126.027873 | 125.934692 | 125.965752 | 5356.0 |
| 2017-08-13 19:00:00 | ZN | Futures | 125.950222 | 125.981282 | 125.934692 | 125.934692 | 6369.0 |
| 2017-08-13 20:00:00 | ZN | Futures | 125.950222 | 125.965752 | 125.888101 | 125.903631 | 15455.0 |
| 2017-08-13 21:00:00 | ZN | Futures | 125.888101 | 125.919161 | 125.872571 | 125.903631 | 13454.0 |
| 2017-08-13 22:00:00 | ZN | Futures | 125.903631 | 125.919161 | 125.888101 | 125.919161 | 5091.0 |
| 2017-08-13 23:00:00 | ZN | Futures | 125.919161 | 125.919161 | 125.888101 | 125.903631 | 3024.0 |
> showing 36 of 281 rows — these rows as CSV