PREVIEW / futures_1hour / 2016-11-13
file: by_date/futures_1hour/2016/2016-11-13.parquet size: 16 KB rows: 294
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-13 18:00:00 | ES | Futures | 2355.66 | 2360.01 | 2354.3 | 2359.2 | 14827.0 |
| 2016-11-13 19:00:00 | ES | Futures | 2359.2 | 2363.01 | 2358.38 | 2363.01 | 15612.0 |
| 2016-11-13 20:00:00 | ES | Futures | 2362.73 | 2365.73 | 2357.29 | 2357.56 | 24223.0 |
| 2016-11-13 21:00:00 | ES | Futures | 2357.29 | 2362.19 | 2357.02 | 2361.92 | 8388.0 |
| 2016-11-13 22:00:00 | ES | Futures | 2361.65 | 2363.28 | 2361.1 | 2361.65 | 5759.0 |
| 2016-11-13 23:00:00 | ES | Futures | 2361.65 | 2364.64 | 2361.1 | 2364.09 | 4659.0 |
| 2016-11-13 18:00:00 | NQ | Futures | 5671.94 | 5691.63 | 5668.07 | 5688.65 | 2431.0 |
| 2016-11-13 19:00:00 | NQ | Futures | 5687.76 | 5701.78 | 5687.16 | 5701.48 | 2080.0 |
| 2016-11-13 20:00:00 | NQ | Futures | 5701.18 | 5709.53 | 5680.3 | 5680.3 | 4722.0 |
| 2016-11-13 21:00:00 | NQ | Futures | 5680.6 | 5691.63 | 5680.0 | 5690.44 | 1686.0 |
| 2016-11-13 22:00:00 | NQ | Futures | 5690.44 | 5696.71 | 5689.84 | 5694.02 | 1373.0 |
| 2016-11-13 23:00:00 | NQ | Futures | 5693.72 | 5699.69 | 5692.83 | 5697.6 | 630.0 |
| 2016-11-13 18:00:00 | YM | Futures | 20324.8 | 20376.7 | 20316.2 | 20363.7 | 3043.0 |
| 2016-11-13 19:00:00 | YM | Futures | 20363.7 | 20403.7 | 20358.3 | 20401.6 | 3300.0 |
| 2016-11-13 20:00:00 | YM | Futures | 20402.6 | 20425.3 | 20370.2 | 20371.3 | 5322.0 |
| 2016-11-13 21:00:00 | YM | Futures | 20371.3 | 20402.6 | 20369.1 | 20401.6 | 2265.0 |
| 2016-11-13 22:00:00 | YM | Futures | 20401.6 | 20417.8 | 20397.2 | 20401.6 | 1643.0 |
| 2016-11-13 23:00:00 | YM | Futures | 20401.6 | 20419.9 | 20397.2 | 20413.4 | 853.0 |
| 2016-11-13 18:00:00 | CL | Futures | 42.99 | 43.37 | 42.93 | 43.37 | 724.0 |
| 2016-11-13 19:00:00 | CL | Futures | 43.35 | 43.45 | 43.35 | 43.43 | 569.0 |
| 2016-11-13 20:00:00 | CL | Futures | 43.42 | 43.44 | 43.16 | 43.16 | 1316.0 |
| 2016-11-13 21:00:00 | CL | Futures | 43.16 | 43.27 | 43.1 | 43.24 | 1019.0 |
| 2016-11-13 22:00:00 | CL | Futures | 43.25 | 43.28 | 43.13 | 43.21 | 625.0 |
| 2016-11-13 23:00:00 | CL | Futures | 43.21 | 43.27 | 43.21 | 43.24 | 264.0 |
| 2016-11-13 18:00:00 | GC | Futures | 1661.0 | 1665.4 | 1659.5 | 1663.1 | 5418.0 |
| 2016-11-13 19:00:00 | GC | Futures | 1663.1 | 1663.9 | 1653.9 | 1656.0 | 9760.0 |
| 2016-11-13 20:00:00 | GC | Futures | 1656.0 | 1656.2 | 1640.9 | 1647.8 | 26993.0 |
| 2016-11-13 21:00:00 | GC | Futures | 1647.8 | 1649.7 | 1645.7 | 1648.4 | 7977.0 |
| 2016-11-13 22:00:00 | GC | Futures | 1648.3 | 1650.7 | 1645.2 | 1645.5 | 6062.0 |
| 2016-11-13 23:00:00 | GC | Futures | 1645.5 | 1646.8 | 1643.8 | 1645.1 | 4484.0 |
| 2016-11-13 18:00:00 | ZN | Futures | 124.780967 | 124.780967 | 124.627711 | 124.689013 | 25400.0 |
| 2016-11-13 19:00:00 | ZN | Futures | 124.673688 | 124.719665 | 124.382502 | 124.474455 | 58432.0 |
| 2016-11-13 20:00:00 | ZN | Futures | 124.474455 | 124.551083 | 124.428478 | 124.551083 | 39887.0 |
| 2016-11-13 21:00:00 | ZN | Futures | 124.551083 | 124.59706 | 124.413153 | 124.489781 | 23740.0 |
| 2016-11-13 22:00:00 | ZN | Futures | 124.474455 | 124.505106 | 124.45913 | 124.489781 | 7437.0 |
| 2016-11-13 23:00:00 | ZN | Futures | 124.505106 | 124.505106 | 124.397827 | 124.397827 | 17009.0 |
> showing 36 of 294 rows — these rows as CSV