PREVIEW / futures_1hour / 2015-11-29
file: by_date/futures_1hour/2015/2015-11-29.parquet size: 14 KB rows: 275
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-11-29 18:00:00 | ES | Futures | 2236.41 | 2237.21 | 2232.12 | 2233.46 | 7840.0 |
| 2015-11-29 19:00:00 | ES | Futures | 2233.46 | 2234.26 | 2231.32 | 2232.66 | 6446.0 |
| 2015-11-29 20:00:00 | ES | Futures | 2232.39 | 2234.0 | 2232.39 | 2233.73 | 3404.0 |
| 2015-11-29 21:00:00 | ES | Futures | 2234.0 | 2234.53 | 2232.93 | 2232.93 | 2605.0 |
| 2015-11-29 22:00:00 | ES | Futures | 2233.19 | 2233.46 | 2232.39 | 2232.93 | 2333.0 |
| 2015-11-29 23:00:00 | ES | Futures | 2232.66 | 2234.26 | 2232.66 | 2233.19 | 2381.0 |
| 2015-11-29 18:00:00 | NQ | Futures | 5556.83 | 5556.83 | 5544.98 | 5547.64 | 830.0 |
| 2015-11-29 19:00:00 | NQ | Futures | 5548.24 | 5551.2 | 5541.12 | 5544.98 | 941.0 |
| 2015-11-29 20:00:00 | NQ | Futures | 5544.98 | 5547.64 | 5544.09 | 5547.35 | 462.0 |
| 2015-11-29 21:00:00 | NQ | Futures | 5547.94 | 5549.42 | 5544.68 | 5545.27 | 405.0 |
| 2015-11-29 22:00:00 | NQ | Futures | 5544.68 | 5545.57 | 5542.31 | 5543.49 | 326.0 |
| 2015-11-29 23:00:00 | NQ | Futures | 5544.09 | 5547.35 | 5543.79 | 5544.38 | 217.0 |
| 2015-11-29 18:00:00 | YM | Futures | 18855.8 | 18855.8 | 18816.6 | 18825.1 | 825.0 |
| 2015-11-29 19:00:00 | YM | Futures | 18826.1 | 18834.6 | 18809.2 | 18819.8 | 1017.0 |
| 2015-11-29 20:00:00 | YM | Futures | 18821.9 | 18833.5 | 18819.8 | 18833.5 | 586.0 |
| 2015-11-29 21:00:00 | YM | Futures | 18833.5 | 18837.8 | 18825.1 | 18828.2 | 383.0 |
| 2015-11-29 22:00:00 | YM | Futures | 18826.1 | 18828.2 | 18820.8 | 18821.9 | 261.0 |
| 2015-11-29 23:00:00 | YM | Futures | 18821.9 | 18832.5 | 18821.9 | 18825.1 | 226.0 |
| 2015-11-29 18:00:00 | CL | Futures | 57.28 | 57.48 | 57.28 | 57.36 | 1546.0 |
| 2015-11-29 19:00:00 | CL | Futures | 57.36 | 57.5 | 57.35 | 57.43 | 1333.0 |
| 2015-11-29 20:00:00 | CL | Futures | 57.44 | 57.48 | 57.39 | 57.43 | 1175.0 |
| 2015-11-29 21:00:00 | CL | Futures | 57.43 | 57.44 | 57.32 | 57.36 | 1013.0 |
| 2015-11-29 22:00:00 | CL | Futures | 57.37 | 57.4 | 57.28 | 57.32 | 1024.0 |
| 2015-11-29 23:00:00 | CL | Futures | 57.32 | 57.36 | 57.25 | 57.31 | 1043.0 |
| 2015-11-29 18:00:00 | GC | Futures | 1442.2 | 1444.9 | 1442.2 | 1442.5 | 2149.0 |
| 2015-11-29 19:00:00 | GC | Futures | 1442.5 | 1444.2 | 1442.1 | 1442.9 | 3106.0 |
| 2015-11-29 20:00:00 | GC | Futures | 1442.9 | 1443.3 | 1437.4 | 1439.2 | 6558.0 |
| 2015-11-29 21:00:00 | GC | Futures | 1439.0 | 1441.8 | 1437.0 | 1441.5 | 3231.0 |
| 2015-11-29 22:00:00 | GC | Futures | 1441.4 | 1443.3 | 1439.0 | 1440.3 | 2813.0 |
| 2015-11-29 23:00:00 | GC | Futures | 1440.1 | 1441.4 | 1440.0 | 1440.1 | 1116.0 |
| 2015-11-29 18:00:00 | ZN | Futures | 122.70646 | 122.781897 | 122.70646 | 122.781897 | 941.0 |
| 2015-11-29 19:00:00 | ZN | Futures | 122.781897 | 122.781897 | 122.736635 | 122.736635 | 764.0 |
| 2015-11-29 20:00:00 | ZN | Futures | 122.751722 | 122.766809 | 122.70646 | 122.721547 | 665.0 |
| 2015-11-29 21:00:00 | ZN | Futures | 122.721547 | 122.721547 | 122.70646 | 122.70646 | 246.0 |
| 2015-11-29 22:00:00 | ZN | Futures | 122.70646 | 122.721547 | 122.691372 | 122.691372 | 85.0 |
| 2015-11-29 23:00:00 | ZN | Futures | 122.691372 | 122.691372 | 122.64611 | 122.676285 | 248.0 |
> showing 36 of 275 rows — these rows as CSV