PREVIEW / futures_1hour / 2008-08-17
file: by_date/futures_1hour/2008/2008-08-17.parquet size: 13 KB rows: 219
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-08-17 18:00:00 | ES | Futures | 1208.1 | 1208.33 | 1206.47 | 1206.93 | 5304.0 |
| 2008-08-17 19:00:00 | ES | Futures | 1206.7 | 1207.17 | 1205.77 | 1206.47 | 1822.0 |
| 2008-08-17 20:00:00 | ES | Futures | 1206.47 | 1207.4 | 1206.24 | 1207.17 | 1868.0 |
| 2008-08-17 21:00:00 | ES | Futures | 1207.17 | 1208.33 | 1206.93 | 1207.86 | 1364.0 |
| 2008-08-17 22:00:00 | ES | Futures | 1207.63 | 1208.1 | 1206.93 | 1207.17 | 649.0 |
| 2008-08-17 23:00:00 | ES | Futures | 1206.93 | 1207.17 | 1206.47 | 1206.7 | 965.0 |
| 2008-08-17 18:00:00 | NQ | Futures | 2209.8 | 2210.93 | 2207.27 | 2208.12 | 223.0 |
| 2008-08-17 19:00:00 | NQ | Futures | 2207.84 | 2209.52 | 2206.43 | 2206.99 | 205.0 |
| 2008-08-17 20:00:00 | NQ | Futures | 2208.68 | 2209.24 | 2206.99 | 2209.24 | 73.0 |
| 2008-08-17 21:00:00 | NQ | Futures | 2209.24 | 2210.93 | 2208.68 | 2209.8 | 102.0 |
| 2008-08-17 22:00:00 | NQ | Futures | 2209.8 | 2210.09 | 2208.96 | 2208.96 | 52.0 |
| 2008-08-17 23:00:00 | NQ | Futures | 2208.96 | 2208.96 | 2207.55 | 2208.12 | 119.0 |
| 2008-08-17 18:00:00 | YM | Futures | 10598.4 | 10603.8 | 10583.8 | 10584.7 | 189.0 |
| 2008-08-17 19:00:00 | YM | Futures | 10584.7 | 10590.2 | 10581.1 | 10584.7 | 78.0 |
| 2008-08-17 20:00:00 | YM | Futures | 10588.4 | 10589.3 | 10582.9 | 10586.6 | 81.0 |
| 2008-08-17 21:00:00 | YM | Futures | 10590.2 | 10597.5 | 10590.2 | 10593.8 | 119.0 |
| 2008-08-17 22:00:00 | YM | Futures | 10594.7 | 10594.7 | 10586.6 | 10589.3 | 121.0 |
| 2008-08-17 23:00:00 | YM | Futures | 10585.7 | 10586.6 | 10581.1 | 10584.7 | 77.0 |
| 2008-08-17 18:00:00 | CL | Futures | 431.07 | 432.28 | 428.91 | 430.2 | 332.0 |
| 2008-08-17 19:00:00 | CL | Futures | 430.2 | 432.35 | 429.97 | 431.86 | 138.0 |
| 2008-08-17 20:00:00 | CL | Futures | 431.82 | 434.81 | 431.71 | 434.05 | 434.0 |
| 2008-08-17 21:00:00 | CL | Futures | 434.17 | 434.24 | 433.33 | 433.64 | 179.0 |
| 2008-08-17 22:00:00 | CL | Futures | 433.6 | 433.86 | 433.11 | 433.49 | 173.0 |
| 2008-08-17 23:00:00 | CL | Futures | 433.52 | 435.23 | 433.41 | 435.04 | 189.0 |
| 2008-08-17 18:00:00 | GC | Futures | 1135.4 | 1143.1 | 1135.4 | 1141.5 | 800.0 |
| 2008-08-17 19:00:00 | GC | Futures | 1141.6 | 1142.1 | 1134.8 | 1137.5 | 555.0 |
| 2008-08-17 20:00:00 | GC | Futures | 1137.2 | 1148.1 | 1135.6 | 1146.1 | 1769.0 |
| 2008-08-17 21:00:00 | GC | Futures | 1145.5 | 1147.3 | 1142.1 | 1146.2 | 950.0 |
| 2008-08-17 22:00:00 | GC | Futures | 1145.6 | 1146.1 | 1143.2 | 1143.9 | 393.0 |
| 2008-08-17 23:00:00 | GC | Futures | 1144.5 | 1149.2 | 1143.9 | 1149.2 | 902.0 |
| 2008-08-17 18:00:00 | ZN | Futures | 87.020614 | 87.09082 | 86.985511 | 87.067418 | 2265.0 |
| 2008-08-17 19:00:00 | ZN | Futures | 87.067418 | 87.067418 | 86.997212 | 87.008913 | 1092.0 |
| 2008-08-17 20:00:00 | ZN | Futures | 87.008913 | 87.020614 | 86.950408 | 86.97381 | 3064.0 |
| 2008-08-17 21:00:00 | ZN | Futures | 86.985511 | 86.985511 | 86.950408 | 86.962109 | 1457.0 |
| 2008-08-17 22:00:00 | ZN | Futures | 86.950408 | 86.962109 | 86.938706 | 86.950408 | 1105.0 |
| 2008-08-17 23:00:00 | ZN | Futures | 86.950408 | 86.997212 | 86.950408 | 86.985511 | 2262.0 |
> showing 36 of 219 rows — these rows as CSV