PREVIEW / futures_1hour / 2008-06-01
file: by_date/futures_1hour/2008/2008-06-01.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-06-01 18:00:00 | ES | Futures | 1304.62 | 1304.86 | 1302.29 | 1304.39 | 2998.0 |
| 2008-06-01 19:00:00 | ES | Futures | 1304.39 | 1304.39 | 1303.23 | 1303.23 | 1289.0 |
| 2008-06-01 20:00:00 | ES | Futures | 1302.99 | 1303.46 | 1299.27 | 1301.13 | 4648.0 |
| 2008-06-01 21:00:00 | ES | Futures | 1301.36 | 1302.06 | 1301.36 | 1301.6 | 1702.0 |
| 2008-06-01 22:00:00 | ES | Futures | 1301.6 | 1301.83 | 1301.13 | 1301.83 | 588.0 |
| 2008-06-01 23:00:00 | ES | Futures | 1301.36 | 1302.53 | 1301.13 | 1302.29 | 1211.0 |
| 2008-06-01 18:00:00 | NQ | Futures | 2304.49 | 2306.18 | 2301.09 | 2304.49 | 405.0 |
| 2008-06-01 19:00:00 | NQ | Futures | 2303.92 | 2304.2 | 2302.51 | 2302.51 | 30.0 |
| 2008-06-01 20:00:00 | NQ | Futures | 2302.22 | 2302.22 | 2297.42 | 2299.4 | 325.0 |
| 2008-06-01 21:00:00 | NQ | Futures | 2299.96 | 2301.38 | 2299.11 | 2301.38 | 87.0 |
| 2008-06-01 22:00:00 | NQ | Futures | 2301.09 | 2301.09 | 2299.4 | 2300.25 | 69.0 |
| 2008-06-01 23:00:00 | NQ | Futures | 2300.25 | 2301.09 | 2299.4 | 2300.81 | 167.0 |
| 2008-06-01 18:00:00 | YM | Futures | 11473.5 | 11478.1 | 11458.1 | 11475.4 | 128.0 |
| 2008-06-01 19:00:00 | YM | Futures | 11477.2 | 11477.2 | 11467.2 | 11469.9 | 88.0 |
| 2008-06-01 20:00:00 | YM | Futures | 11468.1 | 11471.7 | 11447.2 | 11451.7 | 327.0 |
| 2008-06-01 21:00:00 | YM | Futures | 11450.8 | 11459.9 | 11449.9 | 11459.9 | 85.0 |
| 2008-06-01 22:00:00 | YM | Futures | 11458.1 | 11459.9 | 11454.5 | 11456.3 | 26.0 |
| 2008-06-01 23:00:00 | YM | Futures | 11456.3 | 11464.5 | 11454.5 | 11461.7 | 86.0 |
| 2008-06-01 18:00:00 | CL | Futures | 486.48 | 486.48 | 485.57 | 485.65 | 322.0 |
| 2008-06-01 19:00:00 | CL | Futures | 485.84 | 486.26 | 484.58 | 485.42 | 212.0 |
| 2008-06-01 20:00:00 | CL | Futures | 485.23 | 485.61 | 484.69 | 485.34 | 165.0 |
| 2008-06-01 21:00:00 | CL | Futures | 485.34 | 485.57 | 484.92 | 485.26 | 190.0 |
| 2008-06-01 22:00:00 | CL | Futures | 485.23 | 485.42 | 484.81 | 485.23 | 241.0 |
| 2008-06-01 23:00:00 | CL | Futures | 485.23 | 485.87 | 485.23 | 485.84 | 141.0 |
| 2008-06-01 18:00:00 | GC | Futures | 1284.8 | 1287.7 | 1283.2 | 1283.8 | 404.0 |
| 2008-06-01 19:00:00 | GC | Futures | 1283.8 | 1284.8 | 1283.1 | 1283.9 | 236.0 |
| 2008-06-01 20:00:00 | GC | Futures | 1284.2 | 1285.4 | 1282.4 | 1284.2 | 766.0 |
| 2008-06-01 21:00:00 | GC | Futures | 1284.1 | 1284.8 | 1280.6 | 1281.8 | 1191.0 |
| 2008-06-01 22:00:00 | GC | Futures | 1281.6 | 1281.8 | 1279.3 | 1279.6 | 460.0 |
| 2008-06-01 23:00:00 | GC | Futures | 1279.6 | 1280.3 | 1278.0 | 1278.2 | 583.0 |
| 2008-06-01 18:00:00 | ZN | Futures | 84.239655 | 84.239655 | 84.216531 | 84.216531 | 322.0 |
| 2008-06-01 19:00:00 | ZN | Futures | 84.228093 | 84.297464 | 84.228093 | 84.297464 | 318.0 |
| 2008-06-01 20:00:00 | ZN | Futures | 84.285903 | 84.320588 | 84.285903 | 84.285903 | 524.0 |
| 2008-06-01 21:00:00 | ZN | Futures | 84.285903 | 84.285903 | 84.216531 | 84.228093 | 1008.0 |
| 2008-06-01 22:00:00 | ZN | Futures | 84.216531 | 84.251217 | 84.20497 | 84.20497 | 815.0 |
| 2008-06-01 23:00:00 | ZN | Futures | 84.216531 | 84.239655 | 84.20497 | 84.239655 | 46.0 |
> showing 36 of 219 rows — these rows as CSV