PREVIEW / futures_1hour / 2011-04-17
file: by_date/futures_1hour/2011/2011-04-17.parquet size: 14 KB rows: 271
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-17 18:00:00 | ES | Futures | 1309.97 | 1310.47 | 1308.48 | 1309.73 | 8060.0 |
| 2011-04-17 19:00:00 | ES | Futures | 1309.73 | 1309.73 | 1307.49 | 1308.24 | 4894.0 |
| 2011-04-17 20:00:00 | ES | Futures | 1308.24 | 1309.23 | 1306.99 | 1307.49 | 10437.0 |
| 2011-04-17 21:00:00 | ES | Futures | 1307.24 | 1307.99 | 1306.25 | 1307.74 | 8688.0 |
| 2011-04-17 22:00:00 | ES | Futures | 1307.74 | 1309.23 | 1307.49 | 1308.98 | 4418.0 |
| 2011-04-17 23:00:00 | ES | Futures | 1308.98 | 1309.48 | 1307.74 | 1307.74 | 3346.0 |
| 2011-04-17 18:00:00 | NQ | Futures | 2652.49 | 2654.5 | 2650.48 | 2653.93 | 664.0 |
| 2011-04-17 19:00:00 | NQ | Futures | 2654.21 | 2654.79 | 2650.77 | 2651.63 | 762.0 |
| 2011-04-17 20:00:00 | NQ | Futures | 2651.92 | 2653.64 | 2649.62 | 2650.19 | 402.0 |
| 2011-04-17 21:00:00 | NQ | Futures | 2650.48 | 2651.92 | 2648.18 | 2651.92 | 652.0 |
| 2011-04-17 22:00:00 | NQ | Futures | 2651.92 | 2654.79 | 2651.34 | 2654.5 | 1183.0 |
| 2011-04-17 23:00:00 | NQ | Futures | 2654.5 | 2654.79 | 2651.34 | 2651.34 | 395.0 |
| 2011-04-17 18:00:00 | YM | Futures | 11846.2 | 11849.1 | 11836.6 | 11849.1 | 490.0 |
| 2011-04-17 19:00:00 | YM | Futures | 11848.2 | 11848.2 | 11831.8 | 11836.6 | 194.0 |
| 2011-04-17 20:00:00 | YM | Futures | 11837.6 | 11845.3 | 11829.9 | 11829.9 | 295.0 |
| 2011-04-17 21:00:00 | YM | Futures | 11831.8 | 11833.7 | 11823.1 | 11832.8 | 371.0 |
| 2011-04-17 22:00:00 | YM | Futures | 11833.7 | 11844.3 | 11831.8 | 11842.4 | 287.0 |
| 2011-04-17 23:00:00 | YM | Futures | 11842.4 | 11842.4 | 11831.8 | 11831.8 | 99.0 |
| 2011-04-17 18:00:00 | CL | Futures | 190.71 | 190.73 | 190.1 | 190.17 | 991.0 |
| 2011-04-17 19:00:00 | CL | Futures | 190.17 | 190.43 | 190.15 | 190.43 | 324.0 |
| 2011-04-17 20:00:00 | CL | Futures | 190.41 | 190.45 | 189.76 | 189.76 | 851.0 |
| 2011-04-17 21:00:00 | CL | Futures | 189.76 | 189.91 | 189.43 | 189.67 | 1738.0 |
| 2011-04-17 22:00:00 | CL | Futures | 189.67 | 190.05 | 189.67 | 190.03 | 524.0 |
| 2011-04-17 23:00:00 | CL | Futures | 190.03 | 190.28 | 189.95 | 189.96 | 484.0 |
| 2011-04-17 18:00:00 | GC | Futures | 2076.9 | 2077.2 | 2074.8 | 2074.8 | 1163.0 |
| 2011-04-17 19:00:00 | GC | Futures | 2075.1 | 2078.4 | 2073.8 | 2078.3 | 1375.0 |
| 2011-04-17 20:00:00 | GC | Futures | 2078.3 | 2079.3 | 2074.8 | 2075.3 | 1862.0 |
| 2011-04-17 21:00:00 | GC | Futures | 2075.3 | 2076.5 | 2073.1 | 2074.1 | 2261.0 |
| 2011-04-17 22:00:00 | GC | Futures | 2074.2 | 2076.0 | 2073.3 | 2074.5 | 1285.0 |
| 2011-04-17 23:00:00 | GC | Futures | 2074.8 | 2076.2 | 2073.7 | 2074.5 | 870.0 |
| 2011-04-17 18:00:00 | ZN | Futures | 101.996023 | 102.049236 | 101.969417 | 101.996023 | 1955.0 |
| 2011-04-17 19:00:00 | ZN | Futures | 102.009326 | 102.062539 | 101.98272 | 102.035933 | 3806.0 |
| 2011-04-17 20:00:00 | ZN | Futures | 102.035933 | 102.062539 | 102.02263 | 102.049236 | 3554.0 |
| 2011-04-17 21:00:00 | ZN | Futures | 102.049236 | 102.062539 | 101.996023 | 102.009326 | 5866.0 |
| 2011-04-17 22:00:00 | ZN | Futures | 102.009326 | 102.009326 | 101.929507 | 101.956113 | 6023.0 |
| 2011-04-17 23:00:00 | ZN | Futures | 101.94281 | 101.94281 | 101.9029 | 101.94281 | 2220.0 |
> showing 36 of 271 rows — these rows as CSV