PREVIEW / futures_1hour / 2008-06-22
file: by_date/futures_1hour/2008/2008-06-22.parquet size: 12 KB rows: 211
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-06-22 18:00:00 | ES | Futures | 1227.85 | 1229.01 | 1226.22 | 1228.08 | 3498.0 |
| 2008-06-22 19:00:00 | ES | Futures | 1228.32 | 1229.71 | 1228.32 | 1228.78 | 1335.0 |
| 2008-06-22 20:00:00 | ES | Futures | 1228.55 | 1229.01 | 1228.32 | 1228.55 | 1632.0 |
| 2008-06-22 21:00:00 | ES | Futures | 1228.55 | 1229.48 | 1227.62 | 1229.24 | 1268.0 |
| 2008-06-22 22:00:00 | ES | Futures | 1229.48 | 1229.71 | 1228.55 | 1228.78 | 1283.0 |
| 2008-06-22 23:00:00 | ES | Futures | 1228.78 | 1230.64 | 1228.32 | 1230.17 | 1924.0 |
| 2008-06-22 18:00:00 | NQ | Futures | 2186.18 | 2189.55 | 2184.49 | 2187.3 | 369.0 |
| 2008-06-22 19:00:00 | NQ | Futures | 2187.58 | 2189.27 | 2186.74 | 2187.58 | 170.0 |
| 2008-06-22 20:00:00 | NQ | Futures | 2187.58 | 2188.43 | 2186.46 | 2187.58 | 51.0 |
| 2008-06-22 21:00:00 | NQ | Futures | 2187.02 | 2189.27 | 2185.61 | 2189.27 | 97.0 |
| 2008-06-22 22:00:00 | NQ | Futures | 2188.99 | 2190.4 | 2187.3 | 2187.86 | 358.0 |
| 2008-06-22 23:00:00 | NQ | Futures | 2187.3 | 2190.4 | 2186.74 | 2190.11 | 90.0 |
| 2008-06-22 18:00:00 | YM | Futures | 10771.1 | 10792.0 | 10769.3 | 10779.2 | 229.0 |
| 2008-06-22 19:00:00 | YM | Futures | 10782.9 | 10792.0 | 10780.2 | 10787.4 | 80.0 |
| 2008-06-22 20:00:00 | YM | Futures | 10787.4 | 10790.2 | 10782.9 | 10786.5 | 88.0 |
| 2008-06-22 21:00:00 | YM | Futures | 10785.6 | 10792.9 | 10780.2 | 10792.0 | 117.0 |
| 2008-06-22 22:00:00 | YM | Futures | 10792.9 | 10796.5 | 10791.1 | 10791.1 | 78.0 |
| 2008-06-22 23:00:00 | YM | Futures | 10790.2 | 10802.9 | 10787.4 | 10798.3 | 209.0 |
| 2008-06-22 18:00:00 | CL | Futures | 511.57 | 513.69 | 509.71 | 512.1 | 1577.0 |
| 2008-06-22 19:00:00 | CL | Futures | 511.99 | 512.78 | 511.76 | 512.52 | 277.0 |
| 2008-06-22 20:00:00 | CL | Futures | 512.37 | 514.8 | 512.25 | 514.26 | 585.0 |
| 2008-06-22 21:00:00 | CL | Futures | 514.42 | 515.36 | 514.23 | 515.02 | 632.0 |
| 2008-06-22 22:00:00 | CL | Futures | 515.02 | 515.67 | 514.61 | 514.72 | 438.0 |
| 2008-06-22 23:00:00 | CL | Futures | 514.72 | 515.63 | 514.61 | 515.55 | 230.0 |
| 2008-06-22 18:00:00 | GC | Futures | 1302.7 | 1308.0 | 1302.3 | 1307.0 | 499.0 |
| 2008-06-22 19:00:00 | GC | Futures | 1307.0 | 1308.3 | 1305.1 | 1306.9 | 606.0 |
| 2008-06-22 20:00:00 | GC | Futures | 1307.2 | 1309.2 | 1306.0 | 1306.7 | 1521.0 |
| 2008-06-22 21:00:00 | GC | Futures | 1306.7 | 1309.9 | 1306.6 | 1309.3 | 994.0 |
| 2008-06-22 22:00:00 | GC | Futures | 1309.5 | 1309.7 | 1308.0 | 1308.3 | 342.0 |
| 2008-06-22 23:00:00 | GC | Futures | 1308.0 | 1308.3 | 1307.3 | 1307.6 | 294.0 |
| 2008-06-22 18:00:00 | ZN | Futures | 84.036849 | 84.060251 | 84.001746 | 84.025148 | 1028.0 |
| 2008-06-22 19:00:00 | ZN | Futures | 84.013447 | 84.071952 | 83.990045 | 84.036849 | 2845.0 |
| 2008-06-22 20:00:00 | ZN | Futures | 84.036849 | 84.15386 | 84.036849 | 84.107055 | 4940.0 |
| 2008-06-22 21:00:00 | ZN | Futures | 84.107055 | 84.130458 | 84.095354 | 84.118756 | 2558.0 |
| 2008-06-22 22:00:00 | ZN | Futures | 84.118756 | 84.130458 | 84.083653 | 84.095354 | 1153.0 |
| 2008-06-22 23:00:00 | ZN | Futures | 84.095354 | 84.107055 | 84.083653 | 84.083653 | 438.0 |
> showing 36 of 211 rows — these rows as CSV