PREVIEW / futures_1hour / 2008-11-09
file: by_date/futures_1hour/2008/2008-11-09.parquet size: 13 KB rows: 239
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-09 18:00:00 | ES | Futures | 890.75 | 903.29 | 890.75 | 902.11 | 24723.0 |
| 2008-11-09 19:00:00 | ES | Futures | 902.11 | 906.6 | 902.11 | 904.0 | 11943.0 |
| 2008-11-09 20:00:00 | ES | Futures | 904.0 | 904.0 | 899.51 | 901.87 | 6127.0 |
| 2008-11-09 21:00:00 | ES | Futures | 901.87 | 904.71 | 900.69 | 901.87 | 7032.0 |
| 2008-11-09 22:00:00 | ES | Futures | 902.35 | 902.58 | 899.27 | 901.4 | 4180.0 |
| 2008-11-09 23:00:00 | ES | Futures | 901.4 | 903.06 | 900.69 | 900.93 | 2225.0 |
| 2008-11-09 18:00:00 | NQ | Futures | 1463.49 | 1484.99 | 1463.49 | 1481.6 | 1168.0 |
| 2008-11-09 19:00:00 | NQ | Futures | 1483.29 | 1489.52 | 1482.73 | 1484.43 | 426.0 |
| 2008-11-09 20:00:00 | NQ | Futures | 1484.43 | 1485.84 | 1479.33 | 1481.88 | 234.0 |
| 2008-11-09 21:00:00 | NQ | Futures | 1482.73 | 1487.26 | 1482.16 | 1482.45 | 125.0 |
| 2008-11-09 22:00:00 | NQ | Futures | 1482.45 | 1483.29 | 1478.48 | 1481.31 | 116.0 |
| 2008-11-09 23:00:00 | NQ | Futures | 1480.46 | 1484.99 | 1479.33 | 1479.33 | 56.0 |
| 2008-11-09 18:00:00 | YM | Futures | 8205.7 | 8329.4 | 8205.7 | 8319.4 | 1562.0 |
| 2008-11-09 19:00:00 | YM | Futures | 8319.4 | 8354.8 | 8319.4 | 8331.2 | 984.0 |
| 2008-11-09 20:00:00 | YM | Futures | 8329.4 | 8329.4 | 8291.2 | 8311.2 | 652.0 |
| 2008-11-09 21:00:00 | YM | Futures | 8311.2 | 8331.2 | 8302.1 | 8306.6 | 412.0 |
| 2008-11-09 22:00:00 | YM | Futures | 8309.4 | 8311.2 | 8283.0 | 8299.4 | 456.0 |
| 2008-11-09 23:00:00 | YM | Futures | 8296.6 | 8312.1 | 8291.2 | 8294.8 | 232.0 |
| 2008-11-09 18:00:00 | CL | Futures | 231.81 | 237.06 | 231.77 | 236.83 | 2715.0 |
| 2008-11-09 19:00:00 | CL | Futures | 236.87 | 241.18 | 236.49 | 239.72 | 2218.0 |
| 2008-11-09 20:00:00 | CL | Futures | 239.68 | 240.88 | 239.01 | 239.72 | 785.0 |
| 2008-11-09 21:00:00 | CL | Futures | 239.72 | 240.06 | 239.42 | 240.06 | 382.0 |
| 2008-11-09 22:00:00 | CL | Futures | 240.09 | 240.99 | 239.12 | 239.12 | 525.0 |
| 2008-11-09 23:00:00 | CL | Futures | 239.16 | 239.61 | 237.88 | 237.96 | 757.0 |
| 2008-11-09 18:00:00 | GC | Futures | 1055.9 | 1069.7 | 1053.9 | 1068.6 | 1738.0 |
| 2008-11-09 19:00:00 | GC | Futures | 1068.8 | 1074.8 | 1066.4 | 1068.0 | 1842.0 |
| 2008-11-09 20:00:00 | GC | Futures | 1068.0 | 1072.0 | 1064.4 | 1071.4 | 977.0 |
| 2008-11-09 21:00:00 | GC | Futures | 1071.3 | 1071.8 | 1067.6 | 1069.4 | 505.0 |
| 2008-11-09 22:00:00 | GC | Futures | 1068.8 | 1070.1 | 1061.3 | 1065.7 | 822.0 |
| 2008-11-09 23:00:00 | GC | Futures | 1065.7 | 1068.8 | 1065.1 | 1066.4 | 615.0 |
| 2008-11-09 18:00:00 | ZN | Futures | 86.773442 | 86.773442 | 86.513571 | 86.584445 | 4543.0 |
| 2008-11-09 19:00:00 | ZN | Futures | 86.572632 | 86.596257 | 86.478134 | 86.549008 | 5048.0 |
| 2008-11-09 20:00:00 | ZN | Futures | 86.56082 | 86.608069 | 86.549008 | 86.584445 | 1222.0 |
| 2008-11-09 21:00:00 | ZN | Futures | 86.584445 | 86.631694 | 86.572632 | 86.608069 | 1324.0 |
| 2008-11-09 22:00:00 | ZN | Futures | 86.608069 | 86.678943 | 86.596257 | 86.655319 | 1367.0 |
| 2008-11-09 23:00:00 | ZN | Futures | 86.667131 | 86.667131 | 86.596257 | 86.619882 | 533.0 |
> showing 36 of 239 rows — these rows as CSV