PREVIEW / futures_1hour / 2016-09-04
file: by_date/futures_1hour/2016/2016-09-04.parquet size: 13 KB rows: 242
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 |
|---|---|---|---|---|---|---|---|
| 2016-09-04 18:00:00 | ES | Futures | 2363.93 | 2366.64 | 2362.85 | 2365.29 | 4306.0 |
| 2016-09-04 19:00:00 | ES | Futures | 2365.02 | 2366.1 | 2364.75 | 2365.56 | 1499.0 |
| 2016-09-04 20:00:00 | ES | Futures | 2365.56 | 2366.1 | 2365.02 | 2365.83 | 3614.0 |
| 2016-09-04 21:00:00 | ES | Futures | 2365.83 | 2366.1 | 2365.02 | 2365.83 | 2895.0 |
| 2016-09-04 22:00:00 | ES | Futures | 2365.56 | 2366.64 | 2365.29 | 2365.29 | 3306.0 |
| 2016-09-04 23:00:00 | ES | Futures | 2365.29 | 2366.1 | 2365.02 | 2366.1 | 1853.0 |
| 2016-09-04 18:00:00 | NQ | Futures | 5724.08 | 5726.46 | 5718.72 | 5723.19 | 815.0 |
| 2016-09-04 19:00:00 | NQ | Futures | 5722.89 | 5724.97 | 5721.99 | 5723.78 | 292.0 |
| 2016-09-04 20:00:00 | NQ | Futures | 5723.78 | 5726.17 | 5722.89 | 5724.68 | 364.0 |
| 2016-09-04 21:00:00 | NQ | Futures | 5724.97 | 5727.95 | 5724.08 | 5724.97 | 540.0 |
| 2016-09-04 22:00:00 | NQ | Futures | 5725.27 | 5727.06 | 5722.89 | 5723.19 | 438.0 |
| 2016-09-04 23:00:00 | NQ | Futures | 5723.19 | 5726.17 | 5723.19 | 5725.57 | 253.0 |
| 2016-09-04 18:00:00 | YM | Futures | 19898.0 | 19933.5 | 19890.4 | 19913.0 | 1474.0 |
| 2016-09-04 19:00:00 | YM | Futures | 19914.1 | 19916.2 | 19909.8 | 19914.1 | 254.0 |
| 2016-09-04 20:00:00 | YM | Futures | 19914.1 | 19918.4 | 19909.8 | 19915.2 | 399.0 |
| 2016-09-04 21:00:00 | YM | Futures | 19916.2 | 19923.8 | 19913.0 | 19918.4 | 501.0 |
| 2016-09-04 22:00:00 | YM | Futures | 19918.4 | 19928.1 | 19917.3 | 19917.3 | 540.0 |
| 2016-09-04 23:00:00 | YM | Futures | 19916.2 | 19919.5 | 19913.0 | 19919.5 | 165.0 |
| 2016-09-04 18:00:00 | CL | Futures | 44.85 | 45.08 | 44.76 | 44.92 | 1863.0 |
| 2016-09-04 19:00:00 | CL | Futures | 44.91 | 44.94 | 44.8 | 44.8 | 971.0 |
| 2016-09-04 20:00:00 | CL | Futures | 44.81 | 44.89 | 44.77 | 44.89 | 1556.0 |
| 2016-09-04 21:00:00 | CL | Futures | 44.89 | 44.89 | 44.78 | 44.81 | 1531.0 |
| 2016-09-04 22:00:00 | CL | Futures | 44.81 | 44.82 | 44.77 | 44.8 | 1035.0 |
| 2016-09-04 23:00:00 | CL | Futures | 44.8 | 44.82 | 44.77 | 44.78 | 1023.0 |
| 2016-09-04 18:00:00 | GC | Futures | 1796.9 | 1797.8 | 1796.5 | 1796.6 | 779.0 |
| 2016-09-04 19:00:00 | GC | Futures | 1796.7 | 1797.0 | 1794.2 | 1794.6 | 1011.0 |
| 2016-09-04 20:00:00 | GC | Futures | 1794.6 | 1797.5 | 1794.4 | 1795.4 | 3919.0 |
| 2016-09-04 21:00:00 | GC | Futures | 1795.2 | 1796.2 | 1793.3 | 1795.6 | 3117.0 |
| 2016-09-04 22:00:00 | GC | Futures | 1795.8 | 1797.5 | 1795.2 | 1797.0 | 2302.0 |
| 2016-09-04 23:00:00 | GC | Futures | 1797.0 | 1797.5 | 1796.0 | 1797.0 | 1478.0 |
| 2016-09-04 18:00:00 | ZN | Futures | 128.21876 | 128.21876 | 128.173115 | 128.173115 | 63.0 |
| 2016-09-04 20:00:00 | ZN | Futures | 128.173115 | 128.21876 | 128.173115 | 128.203545 | 324.0 |
| 2016-09-04 21:00:00 | ZN | Futures | 128.173115 | 128.173115 | 128.157899 | 128.157899 | 20.0 |
> showing 33 of 242 rows — these rows as CSV