PREVIEW / futures_1hour / 2015-08-16
file: by_date/futures_1hour/2015/2015-08-16.parquet size: 14 KB rows: 270
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-08-16 18:00:00 | ES | Futures | 2225.3 | 2227.43 | 2224.24 | 2225.84 | 4088.0 |
| 2015-08-16 19:00:00 | ES | Futures | 2226.1 | 2226.1 | 2225.04 | 2225.57 | 1612.0 |
| 2015-08-16 20:00:00 | ES | Futures | 2225.57 | 2227.97 | 2225.3 | 2227.17 | 4614.0 |
| 2015-08-16 21:00:00 | ES | Futures | 2227.17 | 2227.43 | 2224.24 | 2224.24 | 5215.0 |
| 2015-08-16 22:00:00 | ES | Futures | 2224.5 | 2225.57 | 2220.78 | 2222.11 | 6862.0 |
| 2015-08-16 23:00:00 | ES | Futures | 2222.11 | 2223.97 | 2222.11 | 2223.44 | 3044.0 |
| 2015-08-16 18:00:00 | NQ | Futures | 5362.66 | 5367.69 | 5360.0 | 5364.14 | 615.0 |
| 2015-08-16 19:00:00 | NQ | Futures | 5364.14 | 5365.03 | 5360.89 | 5364.14 | 185.0 |
| 2015-08-16 20:00:00 | NQ | Futures | 5364.14 | 5370.65 | 5363.25 | 5367.69 | 505.0 |
| 2015-08-16 21:00:00 | NQ | Futures | 5368.28 | 5368.28 | 5359.41 | 5360.59 | 792.0 |
| 2015-08-16 22:00:00 | NQ | Futures | 5360.59 | 5362.96 | 5352.9 | 5356.75 | 1025.0 |
| 2015-08-16 23:00:00 | NQ | Futures | 5356.75 | 5361.77 | 5356.15 | 5360.0 | 342.0 |
| 2015-08-16 18:00:00 | YM | Futures | 18371.3 | 18391.3 | 18368.1 | 18377.6 | 518.0 |
| 2015-08-16 19:00:00 | YM | Futures | 18379.7 | 18380.8 | 18372.3 | 18376.6 | 140.0 |
| 2015-08-16 20:00:00 | YM | Futures | 18376.6 | 18394.5 | 18374.5 | 18390.3 | 391.0 |
| 2015-08-16 21:00:00 | YM | Futures | 18390.3 | 18393.4 | 18365.0 | 18368.1 | 1131.0 |
| 2015-08-16 22:00:00 | YM | Futures | 18367.1 | 18377.6 | 18342.8 | 18352.3 | 1311.0 |
| 2015-08-16 23:00:00 | YM | Futures | 18353.4 | 18363.9 | 18351.3 | 18358.6 | 456.0 |
| 2015-08-16 18:00:00 | CL | Futures | 62.03 | 62.03 | 61.65 | 61.77 | 624.0 |
| 2015-08-16 19:00:00 | CL | Futures | 61.78 | 61.84 | 61.61 | 61.75 | 346.0 |
| 2015-08-16 20:00:00 | CL | Futures | 61.77 | 61.82 | 61.69 | 61.72 | 263.0 |
| 2015-08-16 21:00:00 | CL | Futures | 61.74 | 61.75 | 61.52 | 61.58 | 498.0 |
| 2015-08-16 22:00:00 | CL | Futures | 61.58 | 61.66 | 61.53 | 61.58 | 598.0 |
| 2015-08-16 23:00:00 | CL | Futures | 61.56 | 61.62 | 61.46 | 61.62 | 276.0 |
| 2015-08-16 18:00:00 | GC | Futures | 1520.3 | 1521.4 | 1519.5 | 1520.4 | 673.0 |
| 2015-08-16 19:00:00 | GC | Futures | 1520.6 | 1521.5 | 1520.3 | 1520.6 | 257.0 |
| 2015-08-16 20:00:00 | GC | Futures | 1520.6 | 1521.9 | 1519.9 | 1520.0 | 1307.0 |
| 2015-08-16 21:00:00 | GC | Futures | 1519.9 | 1524.7 | 1519.9 | 1523.8 | 4115.0 |
| 2015-08-16 22:00:00 | GC | Futures | 1524.0 | 1524.0 | 1521.9 | 1523.6 | 2396.0 |
| 2015-08-16 23:00:00 | GC | Futures | 1523.6 | 1524.5 | 1522.6 | 1523.6 | 1178.0 |
| 2015-08-16 18:00:00 | ZN | Futures | 122.543459 | 122.55849 | 122.513399 | 122.543459 | 2176.0 |
| 2015-08-16 19:00:00 | ZN | Futures | 122.55849 | 122.603581 | 122.528429 | 122.543459 | 2707.0 |
| 2015-08-16 20:00:00 | ZN | Futures | 122.528429 | 122.543459 | 122.483338 | 122.528429 | 2922.0 |
| 2015-08-16 21:00:00 | ZN | Futures | 122.528429 | 122.588551 | 122.513399 | 122.57352 | 7075.0 |
| 2015-08-16 22:00:00 | ZN | Futures | 122.57352 | 122.588551 | 122.55849 | 122.588551 | 1860.0 |
| 2015-08-16 23:00:00 | ZN | Futures | 122.57352 | 122.618612 | 122.57352 | 122.603581 | 2999.0 |
> showing 36 of 270 rows — these rows as CSV