PREVIEW / futures_1hour / 2013-05-05
file: by_date/futures_1hour/2013/2013-05-05.parquet size: 14 KB rows: 266
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 |
|---|---|---|---|---|---|---|---|
| 2013-05-05 18:00:00 | ES | Futures | 1657.04 | 1659.62 | 1656.78 | 1659.1 | 4561.0 |
| 2013-05-05 19:00:00 | ES | Futures | 1659.36 | 1659.36 | 1657.56 | 1658.07 | 3255.0 |
| 2013-05-05 20:00:00 | ES | Futures | 1658.07 | 1658.84 | 1657.3 | 1658.33 | 2956.0 |
| 2013-05-05 21:00:00 | ES | Futures | 1658.59 | 1658.84 | 1657.56 | 1657.56 | 4275.0 |
| 2013-05-05 22:00:00 | ES | Futures | 1657.56 | 1659.1 | 1657.56 | 1658.07 | 3301.0 |
| 2013-05-05 23:00:00 | ES | Futures | 1658.33 | 1658.59 | 1657.81 | 1658.07 | 1309.0 |
| 2013-05-05 18:00:00 | NQ | Futures | 3426.22 | 3434.39 | 3425.93 | 3434.39 | 1573.0 |
| 2013-05-05 19:00:00 | NQ | Futures | 3434.39 | 3434.97 | 3431.47 | 3432.35 | 1036.0 |
| 2013-05-05 20:00:00 | NQ | Futures | 3432.35 | 3434.1 | 3431.47 | 3433.22 | 431.0 |
| 2013-05-05 21:00:00 | NQ | Futures | 3433.22 | 3433.52 | 3430.89 | 3430.89 | 524.0 |
| 2013-05-05 22:00:00 | NQ | Futures | 3431.18 | 3433.81 | 3430.89 | 3432.93 | 578.0 |
| 2013-05-05 23:00:00 | NQ | Futures | 3432.64 | 3432.93 | 3430.89 | 3431.18 | 271.0 |
| 2013-05-05 18:00:00 | YM | Futures | 15064.1 | 15083.3 | 15060.0 | 15082.3 | 427.0 |
| 2013-05-05 19:00:00 | YM | Futures | 15082.3 | 15086.3 | 15071.2 | 15074.2 | 816.0 |
| 2013-05-05 20:00:00 | YM | Futures | 15074.2 | 15083.3 | 15070.2 | 15080.3 | 360.0 |
| 2013-05-05 21:00:00 | YM | Futures | 15080.3 | 15080.3 | 15070.2 | 15073.2 | 542.0 |
| 2013-05-05 22:00:00 | YM | Futures | 15072.2 | 15081.3 | 15071.2 | 15074.2 | 339.0 |
| 2013-05-05 23:00:00 | YM | Futures | 15072.2 | 15075.2 | 15069.1 | 15074.2 | 218.0 |
| 2013-05-05 18:00:00 | CL | Futures | 150.1 | 152.07 | 150.06 | 151.76 | 5757.0 |
| 2013-05-05 19:00:00 | CL | Futures | 151.78 | 152.28 | 151.74 | 152.17 | 2530.0 |
| 2013-05-05 20:00:00 | CL | Futures | 152.15 | 152.53 | 152.0 | 152.48 | 2603.0 |
| 2013-05-05 21:00:00 | CL | Futures | 152.48 | 152.59 | 151.59 | 151.67 | 3773.0 |
| 2013-05-05 22:00:00 | CL | Futures | 151.7 | 151.71 | 151.46 | 151.51 | 1220.0 |
| 2013-05-05 23:00:00 | CL | Futures | 151.49 | 151.96 | 151.46 | 151.65 | 2505.0 |
| 2013-05-05 18:00:00 | GC | Futures | 2019.0 | 2019.0 | 2014.9 | 2018.6 | 951.0 |
| 2013-05-05 19:00:00 | GC | Futures | 2018.6 | 2019.0 | 2017.6 | 2019.0 | 477.0 |
| 2013-05-05 20:00:00 | GC | Futures | 2018.7 | 2025.4 | 2017.9 | 2025.4 | 2532.0 |
| 2013-05-05 21:00:00 | GC | Futures | 2025.4 | 2030.5 | 2022.6 | 2026.3 | 5144.0 |
| 2013-05-05 22:00:00 | GC | Futures | 2026.1 | 2030.3 | 2025.0 | 2026.5 | 2223.0 |
| 2013-05-05 23:00:00 | GC | Futures | 2026.7 | 2026.7 | 2024.8 | 2025.7 | 996.0 |
| 2013-05-05 18:00:00 | ZN | Futures | 119.456447 | 119.456447 | 119.414321 | 119.428363 | 4342.0 |
| 2013-05-05 19:00:00 | ZN | Futures | 119.428363 | 119.470489 | 119.428363 | 119.456447 | 2772.0 |
| 2013-05-05 20:00:00 | ZN | Futures | 119.456447 | 119.470489 | 119.442405 | 119.456447 | 2090.0 |
| 2013-05-05 21:00:00 | ZN | Futures | 119.442405 | 119.470489 | 119.428363 | 119.470489 | 3127.0 |
| 2013-05-05 22:00:00 | ZN | Futures | 119.456447 | 119.470489 | 119.428363 | 119.428363 | 4418.0 |
| 2013-05-05 23:00:00 | ZN | Futures | 119.456447 | 119.470489 | 119.428363 | 119.442405 | 1311.0 |
> showing 36 of 266 rows — these rows as CSV