PREVIEW / futures_1hour / 2008-06-08
file: by_date/futures_1hour/2008/2008-06-08.parquet size: 13 KB rows: 233
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-06-08 18:00:00 | ES | Futures | 1265.51 | 1265.97 | 1264.34 | 1265.27 | 6820.0 |
| 2008-06-08 19:00:00 | ES | Futures | 1265.27 | 1267.14 | 1264.81 | 1266.44 | 2976.0 |
| 2008-06-08 20:00:00 | ES | Futures | 1266.44 | 1266.67 | 1265.51 | 1266.44 | 2065.0 |
| 2008-06-08 21:00:00 | ES | Futures | 1266.2 | 1268.53 | 1266.2 | 1268.53 | 2216.0 |
| 2008-06-08 22:00:00 | ES | Futures | 1268.53 | 1269.0 | 1268.07 | 1268.3 | 1540.0 |
| 2008-06-08 23:00:00 | ES | Futures | 1268.53 | 1269.23 | 1268.07 | 1268.77 | 1414.0 |
| 2008-06-08 18:00:00 | NQ | Futures | 2248.49 | 2250.47 | 2245.66 | 2249.9 | 523.0 |
| 2008-06-08 19:00:00 | NQ | Futures | 2249.62 | 2251.32 | 2248.49 | 2250.47 | 220.0 |
| 2008-06-08 20:00:00 | NQ | Futures | 2249.62 | 2251.03 | 2249.62 | 2250.75 | 49.0 |
| 2008-06-08 21:00:00 | NQ | Futures | 2250.18 | 2255.28 | 2249.9 | 2254.71 | 312.0 |
| 2008-06-08 22:00:00 | NQ | Futures | 2253.86 | 2256.12 | 2253.01 | 2254.14 | 152.0 |
| 2008-06-08 23:00:00 | NQ | Futures | 2254.14 | 2256.97 | 2254.14 | 2256.12 | 211.0 |
| 2008-06-08 18:00:00 | YM | Futures | 11093.7 | 11093.7 | 11082.8 | 11087.4 | 226.0 |
| 2008-06-08 19:00:00 | YM | Futures | 11087.4 | 11102.8 | 11086.5 | 11099.2 | 240.0 |
| 2008-06-08 20:00:00 | YM | Futures | 11101.0 | 11101.9 | 11090.1 | 11100.1 | 164.0 |
| 2008-06-08 21:00:00 | YM | Futures | 11101.9 | 11115.5 | 11098.3 | 11113.7 | 179.0 |
| 2008-06-08 22:00:00 | YM | Futures | 11113.7 | 11120.1 | 11113.7 | 11115.5 | 163.0 |
| 2008-06-08 23:00:00 | YM | Futures | 11116.4 | 11121.0 | 11111.9 | 11119.2 | 147.0 |
| 2008-06-08 18:00:00 | CL | Futures | 525.9 | 526.01 | 522.66 | 525.33 | 1444.0 |
| 2008-06-08 19:00:00 | CL | Futures | 525.25 | 525.71 | 524.91 | 525.13 | 239.0 |
| 2008-06-08 20:00:00 | CL | Futures | 525.4 | 525.4 | 524.18 | 524.87 | 217.0 |
| 2008-06-08 21:00:00 | CL | Futures | 524.87 | 524.98 | 523.27 | 523.88 | 446.0 |
| 2008-06-08 22:00:00 | CL | Futures | 524.14 | 525.25 | 523.42 | 524.91 | 431.0 |
| 2008-06-08 23:00:00 | CL | Futures | 524.79 | 525.1 | 524.68 | 524.72 | 169.0 |
| 2008-06-08 18:00:00 | GC | Futures | 1306.1 | 1308.2 | 1305.3 | 1307.7 | 807.0 |
| 2008-06-08 19:00:00 | GC | Futures | 1307.4 | 1308.7 | 1306.9 | 1307.7 | 306.0 |
| 2008-06-08 20:00:00 | GC | Futures | 1307.7 | 1308.7 | 1301.7 | 1301.8 | 2064.0 |
| 2008-06-08 21:00:00 | GC | Futures | 1301.8 | 1303.1 | 1301.8 | 1302.8 | 510.0 |
| 2008-06-08 22:00:00 | GC | Futures | 1302.7 | 1304.6 | 1301.2 | 1302.1 | 889.0 |
| 2008-06-08 23:00:00 | GC | Futures | 1302.1 | 1304.6 | 1302.0 | 1302.5 | 1019.0 |
| 2008-06-08 18:00:00 | ZN | Futures | 85.534582 | 85.557984 | 85.51118 | 85.51118 | 969.0 |
| 2008-06-08 19:00:00 | ZN | Futures | 85.522881 | 85.534582 | 85.487778 | 85.487778 | 1888.0 |
| 2008-06-08 20:00:00 | ZN | Futures | 85.476077 | 85.499479 | 85.405871 | 85.429273 | 3829.0 |
| 2008-06-08 21:00:00 | ZN | Futures | 85.429273 | 85.452675 | 85.382469 | 85.39417 | 2043.0 |
| 2008-06-08 22:00:00 | ZN | Futures | 85.39417 | 85.429273 | 85.39417 | 85.417572 | 526.0 |
| 2008-06-08 23:00:00 | ZN | Futures | 85.417572 | 85.440974 | 85.39417 | 85.39417 | 761.0 |
> showing 36 of 233 rows — these rows as CSV