PREVIEW / futures_1hour / 2017-05-14
file: by_date/futures_1hour/2017/2017-05-14.parquet size: 14 KB rows: 284
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-05-14 18:00:00 | ES | Futures | 2609.88 | 2611.79 | 2609.06 | 2610.7 | 6219.0 |
| 2017-05-14 19:00:00 | ES | Futures | 2610.43 | 2611.25 | 2610.15 | 2610.15 | 3958.0 |
| 2017-05-14 20:00:00 | ES | Futures | 2610.15 | 2611.52 | 2609.33 | 2611.52 | 5748.0 |
| 2017-05-14 21:00:00 | ES | Futures | 2611.25 | 2612.61 | 2610.97 | 2612.34 | 5630.0 |
| 2017-05-14 22:00:00 | ES | Futures | 2612.34 | 2613.98 | 2611.52 | 2613.16 | 5806.0 |
| 2017-05-14 23:00:00 | ES | Futures | 2613.43 | 2614.52 | 2613.16 | 2613.16 | 3698.0 |
| 2017-05-14 18:00:00 | NQ | Futures | 6785.07 | 6788.65 | 6782.09 | 6786.57 | 1550.0 |
| 2017-05-14 19:00:00 | NQ | Futures | 6786.27 | 6788.35 | 6786.27 | 6787.16 | 611.0 |
| 2017-05-14 20:00:00 | NQ | Futures | 6786.86 | 6789.55 | 6785.37 | 6787.76 | 1183.0 |
| 2017-05-14 21:00:00 | NQ | Futures | 6788.06 | 6791.04 | 6787.46 | 6790.44 | 975.0 |
| 2017-05-14 22:00:00 | NQ | Futures | 6790.14 | 6793.42 | 6788.35 | 6792.53 | 1182.0 |
| 2017-05-14 23:00:00 | NQ | Futures | 6792.53 | 6794.62 | 6792.53 | 6793.12 | 767.0 |
| 2017-05-14 18:00:00 | YM | Futures | 22666.1 | 22674.8 | 22657.4 | 22665.0 | 899.0 |
| 2017-05-14 19:00:00 | YM | Futures | 22665.0 | 22667.2 | 22659.6 | 22660.7 | 425.0 |
| 2017-05-14 20:00:00 | YM | Futures | 22661.8 | 22674.8 | 22655.2 | 22672.6 | 971.0 |
| 2017-05-14 21:00:00 | YM | Futures | 22673.7 | 22682.4 | 22672.6 | 22680.2 | 970.0 |
| 2017-05-14 22:00:00 | YM | Futures | 22681.3 | 22693.3 | 22674.8 | 22687.9 | 1040.0 |
| 2017-05-14 23:00:00 | YM | Futures | 22687.9 | 22696.5 | 22687.9 | 22690.0 | 604.0 |
| 2017-05-14 18:00:00 | CL | Futures | 44.09 | 44.09 | 43.98 | 44.0 | 322.0 |
| 2017-05-14 19:00:00 | CL | Futures | 43.99 | 44.05 | 43.98 | 44.0 | 193.0 |
| 2017-05-14 20:00:00 | CL | Futures | 44.0 | 44.09 | 43.99 | 44.07 | 444.0 |
| 2017-05-14 21:00:00 | CL | Futures | 44.08 | 44.14 | 44.07 | 44.11 | 424.0 |
| 2017-05-14 22:00:00 | CL | Futures | 44.1 | 44.84 | 44.09 | 44.74 | 4839.0 |
| 2017-05-14 23:00:00 | CL | Futures | 44.74 | 44.84 | 44.65 | 44.71 | 2085.0 |
| 2017-05-14 18:00:00 | GC | Futures | 1649.0 | 1651.9 | 1648.3 | 1650.1 | 2395.0 |
| 2017-05-14 19:00:00 | GC | Futures | 1650.1 | 1651.3 | 1649.5 | 1650.9 | 1555.0 |
| 2017-05-14 20:00:00 | GC | Futures | 1650.7 | 1651.0 | 1648.6 | 1648.7 | 3070.0 |
| 2017-05-14 21:00:00 | GC | Futures | 1648.7 | 1650.9 | 1647.0 | 1650.6 | 5298.0 |
| 2017-05-14 22:00:00 | GC | Futures | 1650.6 | 1651.9 | 1650.2 | 1650.7 | 3906.0 |
| 2017-05-14 23:00:00 | GC | Futures | 1650.6 | 1651.9 | 1650.6 | 1651.0 | 1782.0 |
| 2017-05-14 18:00:00 | ZN | Futures | 124.523828 | 124.632325 | 124.508328 | 124.539327 | 10582.0 |
| 2017-05-14 19:00:00 | ZN | Futures | 124.539327 | 124.570326 | 124.508328 | 124.554827 | 6003.0 |
| 2017-05-14 20:00:00 | ZN | Futures | 124.570326 | 124.585826 | 124.539327 | 124.539327 | 11951.0 |
| 2017-05-14 21:00:00 | ZN | Futures | 124.539327 | 124.570326 | 124.508328 | 124.570326 | 12745.0 |
| 2017-05-14 22:00:00 | ZN | Futures | 124.554827 | 124.601326 | 124.539327 | 124.539327 | 11830.0 |
| 2017-05-14 23:00:00 | ZN | Futures | 124.539327 | 124.554827 | 124.523828 | 124.539327 | 4077.0 |
> showing 36 of 284 rows — these rows as CSV