PREVIEW / futures_1hour / 2008-09-07
file: by_date/futures_1hour/2008/2008-09-07.parquet size: 13 KB rows: 223
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-09-07 18:00:00 | ES | Futures | 1177.88 | 1180.21 | 1177.42 | 1180.21 | 9724.0 |
| 2008-09-07 19:00:00 | ES | Futures | 1180.21 | 1183.92 | 1179.74 | 1181.83 | 26501.0 |
| 2008-09-07 20:00:00 | ES | Futures | 1181.83 | 1185.09 | 1180.44 | 1184.85 | 22727.0 |
| 2008-09-07 21:00:00 | ES | Futures | 1184.85 | 1184.85 | 1183.46 | 1183.92 | 10843.0 |
| 2008-09-07 22:00:00 | ES | Futures | 1183.69 | 1187.64 | 1183.69 | 1186.02 | 16884.0 |
| 2008-09-07 23:00:00 | ES | Futures | 1186.02 | 1189.04 | 1185.32 | 1187.64 | 11358.0 |
| 2008-09-07 18:00:00 | NQ | Futures | 2028.94 | 2030.91 | 2027.25 | 2030.91 | 826.0 |
| 2008-09-07 19:00:00 | NQ | Futures | 2031.19 | 2035.41 | 2030.91 | 2032.31 | 1881.0 |
| 2008-09-07 20:00:00 | NQ | Futures | 2032.31 | 2036.81 | 2029.5 | 2036.53 | 1577.0 |
| 2008-09-07 21:00:00 | NQ | Futures | 2036.25 | 2036.53 | 2033.72 | 2034.28 | 422.0 |
| 2008-09-07 22:00:00 | NQ | Futures | 2034.28 | 2037.66 | 2034.0 | 2035.41 | 940.0 |
| 2008-09-07 23:00:00 | NQ | Futures | 2035.41 | 2040.47 | 2034.56 | 2040.47 | 1282.0 |
| 2008-09-07 18:00:00 | YM | Futures | 10383.9 | 10402.1 | 10380.3 | 10402.1 | 207.0 |
| 2008-09-07 19:00:00 | YM | Futures | 10398.4 | 10427.5 | 10396.6 | 10412.1 | 685.0 |
| 2008-09-07 20:00:00 | YM | Futures | 10411.2 | 10436.6 | 10399.3 | 10434.8 | 846.0 |
| 2008-09-07 21:00:00 | YM | Futures | 10433.9 | 10433.9 | 10421.2 | 10423.9 | 498.0 |
| 2008-09-07 22:00:00 | YM | Futures | 10424.8 | 10459.3 | 10423.0 | 10446.6 | 1453.0 |
| 2008-09-07 23:00:00 | YM | Futures | 10445.7 | 10462.1 | 10426.6 | 10450.2 | 1097.0 |
| 2008-09-07 18:00:00 | CL | Futures | 409.63 | 410.08 | 409.14 | 409.25 | 178.0 |
| 2008-09-07 19:00:00 | CL | Futures | 409.36 | 409.67 | 408.46 | 409.21 | 385.0 |
| 2008-09-07 20:00:00 | CL | Futures | 408.87 | 411.78 | 408.76 | 411.41 | 819.0 |
| 2008-09-07 21:00:00 | CL | Futures | 411.48 | 411.93 | 410.16 | 410.42 | 565.0 |
| 2008-09-07 22:00:00 | CL | Futures | 410.42 | 411.52 | 409.55 | 410.99 | 790.0 |
| 2008-09-07 23:00:00 | CL | Futures | 411.03 | 412.05 | 410.69 | 411.71 | 423.0 |
| 2008-09-07 18:00:00 | GC | Futures | 1162.5 | 1163.9 | 1160.2 | 1163.2 | 705.0 |
| 2008-09-07 19:00:00 | GC | Futures | 1163.3 | 1168.3 | 1162.5 | 1165.3 | 1571.0 |
| 2008-09-07 20:00:00 | GC | Futures | 1165.3 | 1171.7 | 1164.3 | 1168.2 | 2178.0 |
| 2008-09-07 21:00:00 | GC | Futures | 1168.7 | 1171.2 | 1166.6 | 1168.0 | 1978.0 |
| 2008-09-07 22:00:00 | GC | Futures | 1168.0 | 1169.7 | 1166.9 | 1167.3 | 914.0 |
| 2008-09-07 23:00:00 | GC | Futures | 1167.3 | 1170.0 | 1167.2 | 1168.6 | 493.0 |
| 2008-09-07 18:00:00 | ZN | Futures | 87.231232 | 87.231232 | 87.008913 | 87.008913 | 248.0 |
| 2008-09-07 19:00:00 | ZN | Futures | 87.020614 | 87.020614 | 86.798294 | 86.8685 | 391.0 |
| 2008-09-07 20:00:00 | ZN | Futures | 86.915304 | 87.032315 | 86.845098 | 87.032315 | 865.0 |
| 2008-09-07 21:00:00 | ZN | Futures | 86.938706 | 87.067418 | 86.938706 | 87.067418 | 113.0 |
| 2008-09-07 22:00:00 | ZN | Futures | 87.067418 | 87.067418 | 86.950408 | 86.950408 | 85.0 |
| 2008-09-07 23:00:00 | ZN | Futures | 86.927005 | 86.950408 | 86.927005 | 86.927005 | 176.0 |
> showing 36 of 223 rows — these rows as CSV