PREVIEW / futures_1hour / 2016-11-06
file: by_date/futures_1hour/2016/2016-11-06.parquet size: 16 KB rows: 310
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 |
|---|---|---|---|---|---|---|---|
| 2016-11-06 18:00:00 | ES | Futures | 2291.99 | 2297.44 | 2289.27 | 2291.72 | 56672.0 |
| 2016-11-06 19:00:00 | ES | Futures | 2291.72 | 2293.35 | 2288.46 | 2290.36 | 16990.0 |
| 2016-11-06 20:00:00 | ES | Futures | 2290.09 | 2292.81 | 2289.82 | 2292.81 | 15791.0 |
| 2016-11-06 21:00:00 | ES | Futures | 2292.81 | 2293.35 | 2290.36 | 2290.63 | 15438.0 |
| 2016-11-06 22:00:00 | ES | Futures | 2290.63 | 2292.54 | 2290.63 | 2292.54 | 4826.0 |
| 2016-11-06 23:00:00 | ES | Futures | 2292.54 | 2293.35 | 2291.99 | 2291.99 | 3569.0 |
| 2016-11-06 18:00:00 | NQ | Futures | 5620.33 | 5649.57 | 5620.33 | 5634.95 | 7607.0 |
| 2016-11-06 19:00:00 | NQ | Futures | 5635.55 | 5638.83 | 5626.89 | 5631.97 | 2415.0 |
| 2016-11-06 20:00:00 | NQ | Futures | 5631.67 | 5640.62 | 5630.77 | 5640.62 | 1595.0 |
| 2016-11-06 21:00:00 | NQ | Futures | 5640.32 | 5641.81 | 5635.25 | 5637.04 | 2517.0 |
| 2016-11-06 22:00:00 | NQ | Futures | 5637.04 | 5640.62 | 5635.85 | 5638.53 | 757.0 |
| 2016-11-06 23:00:00 | NQ | Futures | 5638.83 | 5640.92 | 5637.34 | 5639.13 | 493.0 |
| 2016-11-06 18:00:00 | YM | Futures | 19453.7 | 19506.7 | 19444.0 | 19460.2 | 8039.0 |
| 2016-11-06 19:00:00 | YM | Futures | 19459.1 | 19473.2 | 19435.4 | 19448.3 | 3084.0 |
| 2016-11-06 20:00:00 | YM | Futures | 19447.2 | 19474.3 | 19444.0 | 19472.1 | 2845.0 |
| 2016-11-06 21:00:00 | YM | Futures | 19472.1 | 19479.7 | 19461.3 | 19465.6 | 2895.0 |
| 2016-11-06 22:00:00 | YM | Futures | 19466.7 | 19479.7 | 19464.5 | 19477.5 | 1014.0 |
| 2016-11-06 23:00:00 | YM | Futures | 19476.4 | 19484.0 | 19475.3 | 19478.6 | 693.0 |
| 2016-11-06 18:00:00 | CL | Futures | 44.32 | 44.51 | 44.27 | 44.41 | 7563.0 |
| 2016-11-06 19:00:00 | CL | Futures | 44.41 | 44.42 | 44.22 | 44.34 | 4092.0 |
| 2016-11-06 20:00:00 | CL | Futures | 44.34 | 44.4 | 44.28 | 44.31 | 2621.0 |
| 2016-11-06 21:00:00 | CL | Futures | 44.31 | 44.41 | 44.28 | 44.41 | 2442.0 |
| 2016-11-06 22:00:00 | CL | Futures | 44.41 | 44.45 | 44.37 | 44.42 | 1610.0 |
| 2016-11-06 23:00:00 | CL | Futures | 44.42 | 44.45 | 44.41 | 44.45 | 1123.0 |
| 2016-11-06 18:00:00 | GC | Futures | 1751.4 | 1752.5 | 1743.0 | 1745.3 | 12289.0 |
| 2016-11-06 19:00:00 | GC | Futures | 1745.2 | 1750.3 | 1744.8 | 1750.0 | 6294.0 |
| 2016-11-06 20:00:00 | GC | Futures | 1750.2 | 1754.1 | 1749.9 | 1751.3 | 7210.0 |
| 2016-11-06 21:00:00 | GC | Futures | 1751.1 | 1751.1 | 1748.6 | 1749.0 | 3362.0 |
| 2016-11-06 22:00:00 | GC | Futures | 1748.8 | 1750.0 | 1747.6 | 1748.6 | 2829.0 |
| 2016-11-06 23:00:00 | GC | Futures | 1748.6 | 1750.5 | 1746.1 | 1746.4 | 2762.0 |
| 2016-11-06 18:00:00 | ZN | Futures | 127.370992 | 127.44762 | 127.279038 | 127.325015 | 49586.0 |
| 2016-11-06 19:00:00 | ZN | Futures | 127.325015 | 127.401643 | 127.30969 | 127.386318 | 18398.0 |
| 2016-11-06 20:00:00 | ZN | Futures | 127.401643 | 127.401643 | 127.340341 | 127.370992 | 7647.0 |
| 2016-11-06 21:00:00 | ZN | Futures | 127.355666 | 127.386318 | 127.340341 | 127.370992 | 6680.0 |
| 2016-11-06 22:00:00 | ZN | Futures | 127.370992 | 127.386318 | 127.340341 | 127.340341 | 5558.0 |
| 2016-11-06 23:00:00 | ZN | Futures | 127.340341 | 127.355666 | 127.340341 | 127.355666 | 4314.0 |
> showing 36 of 310 rows — these rows as CSV