PREVIEW / futures_1hour / 2008-05-18
file: by_date/futures_1hour/2008/2008-05-18.parquet size: 13 KB rows: 221
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-05-18 18:00:00 | ES | Futures | 1327.44 | 1328.14 | 1327.21 | 1327.67 | 3119.0 |
| 2008-05-18 19:00:00 | ES | Futures | 1327.67 | 1327.91 | 1327.21 | 1327.21 | 584.0 |
| 2008-05-18 20:00:00 | ES | Futures | 1327.21 | 1327.44 | 1326.04 | 1326.98 | 3030.0 |
| 2008-05-18 21:00:00 | ES | Futures | 1327.21 | 1327.67 | 1326.51 | 1326.74 | 1454.0 |
| 2008-05-18 22:00:00 | ES | Futures | 1326.74 | 1327.44 | 1326.51 | 1326.74 | 704.0 |
| 2008-05-18 23:00:00 | ES | Futures | 1326.74 | 1327.21 | 1326.74 | 1327.21 | 291.0 |
| 2008-05-18 18:00:00 | NQ | Futures | 2302.79 | 2304.2 | 2302.22 | 2303.36 | 247.0 |
| 2008-05-18 19:00:00 | NQ | Futures | 2303.07 | 2303.36 | 2302.51 | 2302.79 | 29.0 |
| 2008-05-18 20:00:00 | NQ | Futures | 2302.22 | 2302.22 | 2299.96 | 2301.94 | 153.0 |
| 2008-05-18 21:00:00 | NQ | Futures | 2301.94 | 2302.79 | 2299.96 | 2299.96 | 74.0 |
| 2008-05-18 22:00:00 | NQ | Futures | 2300.53 | 2300.81 | 2299.96 | 2300.53 | 73.0 |
| 2008-05-18 23:00:00 | NQ | Futures | 2300.25 | 2301.66 | 2299.96 | 2301.09 | 83.0 |
| 2008-05-18 18:00:00 | YM | Futures | 11799.7 | 11803.4 | 11790.7 | 11794.3 | 72.0 |
| 2008-05-18 19:00:00 | YM | Futures | 11792.5 | 11795.2 | 11787.0 | 11790.7 | 125.0 |
| 2008-05-18 20:00:00 | YM | Futures | 11789.8 | 11791.6 | 11785.2 | 11788.8 | 86.0 |
| 2008-05-18 21:00:00 | YM | Futures | 11788.8 | 11793.4 | 11785.2 | 11786.1 | 116.0 |
| 2008-05-18 22:00:00 | YM | Futures | 11785.2 | 11789.8 | 11784.3 | 11787.0 | 108.0 |
| 2008-05-18 23:00:00 | YM | Futures | 11787.0 | 11792.5 | 11784.3 | 11787.9 | 44.0 |
| 2008-05-18 18:00:00 | CL | Futures | 480.84 | 481.8 | 480.04 | 481.34 | 582.0 |
| 2008-05-18 19:00:00 | CL | Futures | 481.41 | 482.06 | 481.41 | 481.91 | 335.0 |
| 2008-05-18 20:00:00 | CL | Futures | 481.95 | 481.95 | 481.38 | 481.8 | 144.0 |
| 2008-05-18 21:00:00 | CL | Futures | 481.72 | 481.87 | 481.53 | 481.76 | 156.0 |
| 2008-05-18 22:00:00 | CL | Futures | 481.76 | 482.18 | 481.19 | 481.38 | 335.0 |
| 2008-05-18 23:00:00 | CL | Futures | 481.41 | 482.71 | 481.38 | 482.56 | 224.0 |
| 2008-05-18 18:00:00 | GC | Futures | 1308.6 | 1312.6 | 1307.7 | 1312.5 | 1153.0 |
| 2008-05-18 19:00:00 | GC | Futures | 1312.6 | 1312.9 | 1310.0 | 1312.6 | 1024.0 |
| 2008-05-18 20:00:00 | GC | Futures | 1312.6 | 1313.1 | 1310.7 | 1311.0 | 1338.0 |
| 2008-05-18 21:00:00 | GC | Futures | 1311.0 | 1312.0 | 1308.6 | 1310.7 | 977.0 |
| 2008-05-18 22:00:00 | GC | Futures | 1310.5 | 1310.7 | 1308.3 | 1309.0 | 419.0 |
| 2008-05-18 23:00:00 | GC | Futures | 1309.0 | 1312.5 | 1308.4 | 1312.0 | 943.0 |
| 2008-05-18 18:00:00 | ZN | Futures | 85.257098 | 85.280222 | 85.233974 | 85.245536 | 665.0 |
| 2008-05-18 19:00:00 | ZN | Futures | 85.257098 | 85.257098 | 85.199289 | 85.210851 | 1179.0 |
| 2008-05-18 20:00:00 | ZN | Futures | 85.199289 | 85.245536 | 85.187727 | 85.233974 | 6169.0 |
| 2008-05-18 21:00:00 | ZN | Futures | 85.233974 | 85.245536 | 85.210851 | 85.233974 | 1323.0 |
| 2008-05-18 22:00:00 | ZN | Futures | 85.245536 | 85.291784 | 85.233974 | 85.233974 | 2103.0 |
| 2008-05-18 23:00:00 | ZN | Futures | 85.233974 | 85.233974 | 85.187727 | 85.210851 | 2514.0 |
> showing 36 of 221 rows — these rows as CSV