PREVIEW / futures_1hour / 2008-08-31
file: by_date/futures_1hour/2008/2008-08-31.parquet size: 12 KB rows: 194
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-08-31 18:00:00 | ES | Futures | 1191.83 | 1191.83 | 1190.66 | 1190.9 | 2875.0 |
| 2008-08-31 19:00:00 | ES | Futures | 1190.9 | 1191.83 | 1190.9 | 1191.83 | 1352.0 |
| 2008-08-31 20:00:00 | ES | Futures | 1191.83 | 1192.29 | 1190.9 | 1191.59 | 2669.0 |
| 2008-08-31 21:00:00 | ES | Futures | 1191.59 | 1191.83 | 1190.43 | 1190.66 | 1489.0 |
| 2008-08-31 22:00:00 | ES | Futures | 1190.43 | 1190.9 | 1189.97 | 1190.2 | 886.0 |
| 2008-08-31 23:00:00 | ES | Futures | 1190.2 | 1190.43 | 1188.11 | 1188.34 | 1700.0 |
| 2008-08-31 18:00:00 | NQ | Futures | 2109.95 | 2109.95 | 2105.45 | 2106.57 | 146.0 |
| 2008-08-31 19:00:00 | NQ | Futures | 2106.01 | 2107.13 | 2105.73 | 2106.01 | 35.0 |
| 2008-08-31 20:00:00 | NQ | Futures | 2106.57 | 2107.7 | 2106.29 | 2107.42 | 38.0 |
| 2008-08-31 21:00:00 | NQ | Futures | 2106.85 | 2107.42 | 2105.73 | 2105.73 | 20.0 |
| 2008-08-31 22:00:00 | NQ | Futures | 2105.73 | 2107.13 | 2104.88 | 2106.29 | 164.0 |
| 2008-08-31 23:00:00 | NQ | Futures | 2105.45 | 2105.45 | 2103.48 | 2103.48 | 199.0 |
| 2008-08-31 18:00:00 | YM | Futures | 10494.8 | 10494.8 | 10481.1 | 10483.9 | 438.0 |
| 2008-08-31 19:00:00 | YM | Futures | 10484.8 | 10489.3 | 10482.0 | 10488.4 | 118.0 |
| 2008-08-31 20:00:00 | YM | Futures | 10491.1 | 10493.0 | 10482.0 | 10489.3 | 91.0 |
| 2008-08-31 21:00:00 | YM | Futures | 10489.3 | 10490.2 | 10480.2 | 10481.1 | 60.0 |
| 2008-08-31 22:00:00 | YM | Futures | 10483.9 | 10484.8 | 10473.0 | 10474.8 | 188.0 |
| 2008-08-31 23:00:00 | YM | Futures | 10476.6 | 10477.5 | 10461.1 | 10462.1 | 123.0 |
| 2008-08-31 14:00:00 | CL | Futures | 441.05 | 448.42 | 441.05 | 446.19 | 1931.0 |
| 2008-08-31 15:00:00 | CL | Futures | 446.23 | 447.1 | 442.07 | 442.26 | 1764.0 |
| 2008-08-31 16:00:00 | CL | Futures | 442.26 | 443.28 | 441.77 | 442.64 | 635.0 |
| 2008-08-31 17:00:00 | CL | Futures | 442.86 | 442.9 | 440.71 | 441.54 | 624.0 |
| 2008-08-31 18:00:00 | CL | Futures | 441.5 | 442.79 | 441.43 | 442.37 | 797.0 |
| 2008-08-31 19:00:00 | CL | Futures | 442.37 | 443.01 | 441.99 | 442.6 | 370.0 |
| 2008-08-31 20:00:00 | CL | Futures | 442.52 | 443.32 | 439.69 | 440.06 | 846.0 |
| 2008-08-31 21:00:00 | CL | Futures | 440.06 | 440.86 | 439.46 | 440.06 | 545.0 |
| 2008-08-31 22:00:00 | CL | Futures | 440.18 | 441.01 | 438.06 | 441.01 | 663.0 |
| 2008-08-31 23:00:00 | CL | Futures | 440.59 | 440.93 | 439.95 | 440.29 | 275.0 |
| 2008-08-31 18:00:00 | GC | Futures | 1202.0 | 1202.9 | 1196.4 | 1196.7 | 470.0 |
| 2008-08-31 19:00:00 | GC | Futures | 1197.4 | 1198.2 | 1196.9 | 1197.7 | 98.0 |
| 2008-08-31 20:00:00 | GC | Futures | 1197.7 | 1199.9 | 1192.0 | 1192.6 | 923.0 |
| 2008-08-31 21:00:00 | GC | Futures | 1192.2 | 1194.3 | 1191.2 | 1192.7 | 1053.0 |
| 2008-08-31 22:00:00 | GC | Futures | 1192.7 | 1193.7 | 1191.4 | 1193.7 | 262.0 |
| 2008-08-31 23:00:00 | GC | Futures | 1193.9 | 1194.2 | 1193.0 | 1193.4 | 326.0 |
| 2008-08-31 18:00:00 | ZN | Futures | 87.359944 | 87.453552 | 87.324841 | 87.418449 | 119.0 |
| 2008-08-31 19:00:00 | ZN | Futures | 87.418449 | 87.453552 | 87.406748 | 87.453552 | 105.0 |
| 2008-08-31 20:00:00 | ZN | Futures | 87.465253 | 87.476954 | 87.43015 | 87.43015 | 67.0 |
| 2008-08-31 21:00:00 | ZN | Futures | 87.441851 | 87.441851 | 87.406748 | 87.406748 | 286.0 |
| 2008-08-31 22:00:00 | ZN | Futures | 87.418449 | 87.43015 | 87.418449 | 87.418449 | 51.0 |
| 2008-08-31 23:00:00 | ZN | Futures | 87.406748 | 87.418449 | 87.406748 | 87.418449 | 91.0 |
> showing 40 of 194 rows — these rows as CSV