PREVIEW / futures_1hour / 2008-11-23
file: by_date/futures_1hour/2008/2008-11-23.parquet size: 12 KB rows: 204
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-23 18:00:00 | ES | Futures | 758.23 | 762.96 | 750.18 | 756.1 | 26519.0 |
| 2008-11-23 19:00:00 | ES | Futures | 756.33 | 756.33 | 751.84 | 754.68 | 7522.0 |
| 2008-11-23 20:00:00 | ES | Futures | 754.91 | 755.15 | 749.23 | 751.6 | 9450.0 |
| 2008-11-23 21:00:00 | ES | Futures | 751.6 | 754.68 | 749.23 | 753.73 | 6877.0 |
| 2008-11-23 22:00:00 | ES | Futures | 753.73 | 754.44 | 748.29 | 751.84 | 7273.0 |
| 2008-11-23 23:00:00 | ES | Futures | 751.84 | 764.14 | 751.6 | 760.83 | 11497.0 |
| 2008-11-23 18:00:00 | NQ | Futures | 1243.06 | 1250.7 | 1229.76 | 1240.79 | 1635.0 |
| 2008-11-23 19:00:00 | NQ | Futures | 1241.64 | 1241.64 | 1234.57 | 1238.25 | 295.0 |
| 2008-11-23 20:00:00 | NQ | Futures | 1237.96 | 1237.96 | 1228.91 | 1232.02 | 333.0 |
| 2008-11-23 21:00:00 | NQ | Futures | 1232.59 | 1239.1 | 1230.32 | 1237.12 | 252.0 |
| 2008-11-23 22:00:00 | NQ | Futures | 1237.12 | 1238.25 | 1228.06 | 1234.29 | 249.0 |
| 2008-11-23 23:00:00 | NQ | Futures | 1235.42 | 1254.09 | 1234.29 | 1247.59 | 557.0 |
| 2008-11-23 18:00:00 | YM | Futures | 7344.4 | 7403.5 | 7294.3 | 7334.4 | 1343.0 |
| 2008-11-23 19:00:00 | YM | Futures | 7336.2 | 7341.6 | 7308.9 | 7324.4 | 488.0 |
| 2008-11-23 20:00:00 | YM | Futures | 7327.1 | 7328.9 | 7279.8 | 7290.7 | 605.0 |
| 2008-11-23 21:00:00 | YM | Futures | 7294.3 | 7312.5 | 7265.2 | 7308.9 | 976.0 |
| 2008-11-23 22:00:00 | YM | Futures | 7306.2 | 7312.5 | 7258.9 | 7291.6 | 499.0 |
| 2008-11-23 23:00:00 | YM | Futures | 7291.6 | 7392.6 | 7284.3 | 7363.5 | 1206.0 |
| 2008-11-23 18:00:00 | CL | Futures | 188.26 | 189.62 | 186.74 | 187.78 | 1291.0 |
| 2008-11-23 19:00:00 | CL | Futures | 187.78 | 188.03 | 185.89 | 186.08 | 370.0 |
| 2008-11-23 20:00:00 | CL | Futures | 186.22 | 186.34 | 184.89 | 185.6 | 472.0 |
| 2008-11-23 21:00:00 | CL | Futures | 185.56 | 187.11 | 185.41 | 186.74 | 200.0 |
| 2008-11-23 22:00:00 | CL | Futures | 186.7 | 187.26 | 186.34 | 187.0 | 232.0 |
| 2008-11-23 23:00:00 | CL | Futures | 187.15 | 187.7 | 186.85 | 187.59 | 446.0 |
| 2008-11-23 18:00:00 | GC | Futures | 1144.6 | 1151.9 | 1141.6 | 1145.6 | 1714.0 |
| 2008-11-23 19:00:00 | GC | Futures | 1145.5 | 1147.6 | 1142.8 | 1143.2 | 1037.0 |
| 2008-11-23 20:00:00 | GC | Futures | 1143.2 | 1143.5 | 1133.2 | 1134.5 | 1389.0 |
| 2008-11-23 21:00:00 | GC | Futures | 1134.2 | 1137.5 | 1131.5 | 1133.2 | 1053.0 |
| 2008-11-23 22:00:00 | GC | Futures | 1132.8 | 1133.4 | 1123.1 | 1124.6 | 1052.0 |
| 2008-11-23 23:00:00 | GC | Futures | 1124.6 | 1132.2 | 1123.2 | 1130.2 | 1253.0 |
| 2008-11-23 18:00:00 | ZN | Futures | 90.7542 | 90.7542 | 90.636077 | 90.742388 | 3327.0 |
| 2008-11-23 19:00:00 | ZN | Futures | 90.742388 | 90.789637 | 90.683326 | 90.718763 | 1563.0 |
| 2008-11-23 20:00:00 | ZN | Futures | 90.730576 | 90.7542 | 90.671514 | 90.683326 | 930.0 |
| 2008-11-23 21:00:00 | ZN | Futures | 90.683326 | 90.706951 | 90.577015 | 90.659702 | 1470.0 |
| 2008-11-23 22:00:00 | ZN | Futures | 90.671514 | 90.7542 | 90.659702 | 90.742388 | 975.0 |
| 2008-11-23 23:00:00 | ZN | Futures | 90.730576 | 90.766013 | 90.577015 | 90.60064 | 2078.0 |
> showing 36 of 204 rows — these rows as CSV