PREVIEW / futures_1hour / 2008-11-30
file: by_date/futures_1hour/2008/2008-11-30.parquet size: 13 KB rows: 220
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-30 18:00:00 | ES | Futures | 849.57 | 849.57 | 838.69 | 839.63 | 9450.0 |
| 2008-11-30 19:00:00 | ES | Futures | 839.63 | 839.63 | 836.32 | 837.5 | 6975.0 |
| 2008-11-30 20:00:00 | ES | Futures | 837.5 | 838.92 | 837.03 | 837.74 | 2367.0 |
| 2008-11-30 21:00:00 | ES | Futures | 837.98 | 841.29 | 837.5 | 840.11 | 3064.0 |
| 2008-11-30 22:00:00 | ES | Futures | 840.34 | 841.05 | 839.4 | 840.58 | 1214.0 |
| 2008-11-30 23:00:00 | ES | Futures | 840.58 | 842.24 | 838.92 | 840.34 | 1928.0 |
| 2008-11-30 18:00:00 | NQ | Futures | 1342.1 | 1344.92 | 1328.8 | 1331.06 | 515.0 |
| 2008-11-30 19:00:00 | NQ | Futures | 1329.64 | 1329.64 | 1325.68 | 1327.66 | 334.0 |
| 2008-11-30 20:00:00 | NQ | Futures | 1328.51 | 1330.21 | 1327.38 | 1328.8 | 185.0 |
| 2008-11-30 21:00:00 | NQ | Futures | 1328.8 | 1333.89 | 1328.8 | 1332.19 | 247.0 |
| 2008-11-30 22:00:00 | NQ | Futures | 1332.19 | 1333.04 | 1331.06 | 1332.47 | 56.0 |
| 2008-11-30 23:00:00 | NQ | Futures | 1332.76 | 1334.46 | 1329.93 | 1332.19 | 124.0 |
| 2008-11-30 18:00:00 | YM | Futures | 8022.9 | 8033.8 | 7958.3 | 7965.6 | 679.0 |
| 2008-11-30 19:00:00 | YM | Futures | 7965.6 | 7965.6 | 7938.3 | 7947.4 | 425.0 |
| 2008-11-30 20:00:00 | YM | Futures | 7945.6 | 7958.3 | 7941.9 | 7951.0 | 302.0 |
| 2008-11-30 21:00:00 | YM | Futures | 7951.0 | 7978.3 | 7951.0 | 7965.6 | 440.0 |
| 2008-11-30 22:00:00 | YM | Futures | 7967.4 | 7971.9 | 7953.7 | 7966.5 | 302.0 |
| 2008-11-30 23:00:00 | YM | Futures | 7965.6 | 7979.2 | 7953.7 | 7964.7 | 251.0 |
| 2008-11-30 18:00:00 | CL | Futures | 201.74 | 201.74 | 197.49 | 197.97 | 2092.0 |
| 2008-11-30 19:00:00 | CL | Futures | 197.97 | 198.23 | 195.79 | 195.83 | 1901.0 |
| 2008-11-30 20:00:00 | CL | Futures | 195.9 | 197.19 | 195.61 | 196.68 | 989.0 |
| 2008-11-30 21:00:00 | CL | Futures | 196.6 | 197.05 | 196.01 | 196.79 | 366.0 |
| 2008-11-30 22:00:00 | CL | Futures | 196.86 | 198.52 | 196.86 | 197.64 | 413.0 |
| 2008-11-30 23:00:00 | CL | Futures | 197.6 | 197.93 | 196.38 | 197.08 | 458.0 |
| 2008-11-30 18:00:00 | GC | Futures | 1167.7 | 1169.2 | 1164.2 | 1165.0 | 464.0 |
| 2008-11-30 19:00:00 | GC | Futures | 1165.0 | 1165.0 | 1158.0 | 1160.8 | 862.0 |
| 2008-11-30 20:00:00 | GC | Futures | 1160.8 | 1161.3 | 1155.8 | 1156.1 | 1193.0 |
| 2008-11-30 21:00:00 | GC | Futures | 1155.9 | 1160.3 | 1152.9 | 1158.8 | 822.0 |
| 2008-11-30 22:00:00 | GC | Futures | 1158.6 | 1159.2 | 1157.5 | 1158.3 | 138.0 |
| 2008-11-30 23:00:00 | GC | Futures | 1158.3 | 1159.5 | 1157.2 | 1159.3 | 316.0 |
| 2008-11-30 18:00:00 | ZN | Futures | 92.915858 | 92.915858 | 92.762298 | 92.833172 | 208.0 |
| 2008-11-30 19:00:00 | ZN | Futures | 92.82136 | 92.856797 | 92.809547 | 92.844984 | 128.0 |
| 2008-11-30 20:00:00 | ZN | Futures | 92.82136 | 92.833172 | 92.809547 | 92.833172 | 120.0 |
| 2008-11-30 21:00:00 | ZN | Futures | 92.833172 | 92.927671 | 92.833172 | 92.927671 | 55.0 |
| 2008-11-30 22:00:00 | ZN | Futures | 92.927671 | 93.104856 | 92.927671 | 93.081231 | 200.0 |
| 2008-11-30 23:00:00 | ZN | Futures | 93.057606 | 93.069419 | 92.97492 | 93.057606 | 305.0 |
> showing 36 of 220 rows — these rows as CSV