PREVIEW / futures_1hour / 2015-07-05
file: by_date/futures_1hour/2015/2015-07-05.parquet size: 15 KB rows: 287
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-07-05 18:00:00 | ES | Futures | 2169.66 | 2174.98 | 2166.46 | 2173.65 | 52409.0 |
| 2015-07-05 19:00:00 | ES | Futures | 2173.65 | 2176.05 | 2172.59 | 2174.45 | 12118.0 |
| 2015-07-05 20:00:00 | ES | Futures | 2174.45 | 2178.98 | 2174.45 | 2176.58 | 16731.0 |
| 2015-07-05 21:00:00 | ES | Futures | 2176.31 | 2177.91 | 2175.78 | 2176.85 | 6674.0 |
| 2015-07-05 22:00:00 | ES | Futures | 2176.85 | 2177.91 | 2175.78 | 2176.85 | 5114.0 |
| 2015-07-05 23:00:00 | ES | Futures | 2176.85 | 2178.44 | 2176.58 | 2177.91 | 6355.0 |
| 2015-07-05 18:00:00 | NQ | Futures | 5165.67 | 5168.03 | 5139.64 | 5165.07 | 4527.0 |
| 2015-07-05 19:00:00 | NQ | Futures | 5164.48 | 5170.4 | 5163.6 | 5165.07 | 1496.0 |
| 2015-07-05 20:00:00 | NQ | Futures | 5165.96 | 5177.2 | 5165.37 | 5171.58 | 1741.0 |
| 2015-07-05 21:00:00 | NQ | Futures | 5171.29 | 5176.02 | 5170.1 | 5174.84 | 963.0 |
| 2015-07-05 22:00:00 | NQ | Futures | 5174.84 | 5176.31 | 5172.77 | 5173.65 | 851.0 |
| 2015-07-05 23:00:00 | NQ | Futures | 5173.95 | 5176.31 | 5172.77 | 5174.84 | 551.0 |
| 2015-07-05 18:00:00 | YM | Futures | 18342.8 | 18365.0 | 18281.7 | 18355.5 | 4278.0 |
| 2015-07-05 19:00:00 | YM | Futures | 18354.4 | 18372.3 | 18349.2 | 18365.0 | 994.0 |
| 2015-07-05 20:00:00 | YM | Futures | 18363.9 | 18397.6 | 18362.9 | 18381.8 | 2081.0 |
| 2015-07-05 21:00:00 | YM | Futures | 18380.8 | 18390.3 | 18375.5 | 18380.8 | 916.0 |
| 2015-07-05 22:00:00 | YM | Futures | 18382.9 | 18388.1 | 18375.5 | 18379.7 | 622.0 |
| 2015-07-05 23:00:00 | YM | Futures | 18380.8 | 18391.3 | 18377.6 | 18386.0 | 588.0 |
| 2015-07-05 18:00:00 | CL | Futures | 81.79 | 82.15 | 81.1 | 81.82 | 10419.0 |
| 2015-07-05 19:00:00 | CL | Futures | 81.83 | 81.85 | 81.55 | 81.64 | 1820.0 |
| 2015-07-05 20:00:00 | CL | Futures | 81.62 | 82.44 | 81.62 | 82.31 | 3844.0 |
| 2015-07-05 21:00:00 | CL | Futures | 82.31 | 82.34 | 82.0 | 82.09 | 2697.0 |
| 2015-07-05 22:00:00 | CL | Futures | 82.07 | 82.1 | 81.89 | 81.92 | 1890.0 |
| 2015-07-05 23:00:00 | CL | Futures | 81.92 | 81.97 | 81.83 | 81.88 | 1672.0 |
| 2015-07-05 18:00:00 | GC | Futures | 1601.4 | 1603.0 | 1597.8 | 1601.6 | 5778.0 |
| 2015-07-05 19:00:00 | GC | Futures | 1601.9 | 1601.9 | 1598.4 | 1600.1 | 1749.0 |
| 2015-07-05 20:00:00 | GC | Futures | 1600.1 | 1601.8 | 1596.9 | 1598.6 | 2650.0 |
| 2015-07-05 21:00:00 | GC | Futures | 1598.8 | 1598.8 | 1593.3 | 1594.1 | 2801.0 |
| 2015-07-05 22:00:00 | GC | Futures | 1594.1 | 1594.7 | 1593.0 | 1593.2 | 1606.0 |
| 2015-07-05 23:00:00 | GC | Futures | 1593.0 | 1593.9 | 1592.6 | 1593.4 | 972.0 |
| 2015-07-05 18:00:00 | ZN | Futures | 122.167698 | 122.363094 | 121.972301 | 122.092545 | 76973.0 |
| 2015-07-05 19:00:00 | ZN | Futures | 122.092545 | 122.122606 | 122.032423 | 122.047454 | 16670.0 |
| 2015-07-05 20:00:00 | ZN | Futures | 122.047454 | 122.062484 | 121.91218 | 121.957271 | 20656.0 |
| 2015-07-05 21:00:00 | ZN | Futures | 121.957271 | 121.987332 | 121.882119 | 121.91218 | 13368.0 |
| 2015-07-05 22:00:00 | ZN | Futures | 121.91218 | 121.987332 | 121.897149 | 121.987332 | 6450.0 |
| 2015-07-05 23:00:00 | ZN | Futures | 121.987332 | 122.032423 | 121.942241 | 122.032423 | 6238.0 |
> showing 36 of 287 rows — these rows as CSV