PREVIEW / futures_1hour / 2017-01-15
file: by_date/futures_1hour/2017/2017-01-15.parquet size: 14 KB rows: 256
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-01-15 18:00:00 | ES | Futures | 2477.01 | 2477.29 | 2474.56 | 2475.11 | 5835.0 |
| 2017-01-15 19:00:00 | ES | Futures | 2475.11 | 2476.2 | 2475.11 | 2475.38 | 2588.0 |
| 2017-01-15 20:00:00 | ES | Futures | 2475.11 | 2475.65 | 2474.83 | 2475.38 | 2703.0 |
| 2017-01-15 21:00:00 | ES | Futures | 2475.38 | 2475.65 | 2474.01 | 2474.56 | 2663.0 |
| 2017-01-15 22:00:00 | ES | Futures | 2474.56 | 2475.11 | 2474.01 | 2474.83 | 1873.0 |
| 2017-01-15 23:00:00 | ES | Futures | 2474.83 | 2475.11 | 2474.29 | 2474.29 | 1716.0 |
| 2017-01-15 18:00:00 | NQ | Futures | 6033.52 | 6036.8 | 6024.87 | 6027.25 | 1410.0 |
| 2017-01-15 19:00:00 | NQ | Futures | 6026.96 | 6030.54 | 6026.36 | 6027.55 | 725.0 |
| 2017-01-15 20:00:00 | NQ | Futures | 6027.55 | 6029.34 | 6026.06 | 6029.04 | 687.0 |
| 2017-01-15 21:00:00 | NQ | Futures | 6029.04 | 6029.34 | 6026.36 | 6027.55 | 511.0 |
| 2017-01-15 22:00:00 | NQ | Futures | 6027.25 | 6029.64 | 6027.25 | 6029.04 | 378.0 |
| 2017-01-15 23:00:00 | NQ | Futures | 6029.04 | 6029.94 | 6027.85 | 6028.15 | 339.0 |
| 2017-01-15 18:00:00 | YM | Futures | 21508.7 | 21510.9 | 21477.3 | 21481.6 | 1058.0 |
| 2017-01-15 19:00:00 | YM | Futures | 21481.6 | 21489.2 | 21476.2 | 21477.3 | 536.0 |
| 2017-01-15 20:00:00 | YM | Futures | 21479.4 | 21479.4 | 21468.6 | 21475.1 | 693.0 |
| 2017-01-15 21:00:00 | YM | Futures | 21476.2 | 21477.3 | 21462.1 | 21464.3 | 656.0 |
| 2017-01-15 22:00:00 | YM | Futures | 21464.3 | 21472.9 | 21464.3 | 21469.7 | 389.0 |
| 2017-01-15 23:00:00 | YM | Futures | 21470.8 | 21474.0 | 21468.6 | 21468.6 | 389.0 |
| 2017-01-15 18:00:00 | CL | Futures | 50.53 | 50.61 | 50.39 | 50.45 | 876.0 |
| 2017-01-15 19:00:00 | CL | Futures | 50.45 | 50.49 | 50.42 | 50.45 | 280.0 |
| 2017-01-15 20:00:00 | CL | Futures | 50.46 | 50.54 | 50.46 | 50.47 | 943.0 |
| 2017-01-15 21:00:00 | CL | Futures | 50.48 | 50.58 | 50.47 | 50.57 | 634.0 |
| 2017-01-15 22:00:00 | CL | Futures | 50.58 | 50.58 | 50.51 | 50.56 | 309.0 |
| 2017-01-15 23:00:00 | CL | Futures | 50.56 | 50.57 | 50.51 | 50.53 | 261.0 |
| 2017-01-15 18:00:00 | GC | Futures | 1618.9 | 1627.4 | 1617.0 | 1624.1 | 5652.0 |
| 2017-01-15 19:00:00 | GC | Futures | 1624.3 | 1624.3 | 1621.4 | 1621.7 | 4523.0 |
| 2017-01-15 20:00:00 | GC | Futures | 1621.9 | 1623.2 | 1619.8 | 1621.4 | 7025.0 |
| 2017-01-15 21:00:00 | GC | Futures | 1621.3 | 1625.5 | 1620.4 | 1624.3 | 6710.0 |
| 2017-01-15 22:00:00 | GC | Futures | 1624.4 | 1625.5 | 1622.8 | 1623.7 | 3167.0 |
| 2017-01-15 23:00:00 | GC | Futures | 1623.7 | 1624.3 | 1622.7 | 1624.1 | 2092.0 |
| 2017-01-15 18:00:00 | ZN | Futures | 123.079247 | 123.233463 | 123.079247 | 123.20262 | 11451.0 |
| 2017-01-15 19:00:00 | ZN | Futures | 123.218041 | 123.279727 | 123.187198 | 123.218041 | 6539.0 |
| 2017-01-15 20:00:00 | ZN | Futures | 123.233463 | 123.248884 | 123.171777 | 123.233463 | 5761.0 |
| 2017-01-15 21:00:00 | ZN | Futures | 123.218041 | 123.31057 | 123.20262 | 123.248884 | 5355.0 |
| 2017-01-15 22:00:00 | ZN | Futures | 123.264306 | 123.264306 | 123.233463 | 123.248884 | 1872.0 |
| 2017-01-15 23:00:00 | ZN | Futures | 123.233463 | 123.233463 | 123.20262 | 123.233463 | 2771.0 |
> showing 36 of 256 rows — these rows as CSV