PREVIEW / futures_1hour / 2008-08-03
file: by_date/futures_1hour/2008/2008-08-03.parquet size: 13 KB rows: 232
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-03 18:00:00 | ES | Futures | 1172.54 | 1174.39 | 1171.14 | 1173.7 | 2837.0 |
| 2008-08-03 19:00:00 | ES | Futures | 1173.7 | 1173.7 | 1172.77 | 1173.23 | 973.0 |
| 2008-08-03 20:00:00 | ES | Futures | 1173.23 | 1173.93 | 1171.37 | 1171.61 | 2249.0 |
| 2008-08-03 21:00:00 | ES | Futures | 1171.84 | 1172.07 | 1170.68 | 1171.14 | 2037.0 |
| 2008-08-03 22:00:00 | ES | Futures | 1171.14 | 1171.61 | 1169.75 | 1169.98 | 1693.0 |
| 2008-08-03 23:00:00 | ES | Futures | 1170.21 | 1170.68 | 1169.98 | 1170.68 | 852.0 |
| 2008-08-03 18:00:00 | NQ | Futures | 2062.69 | 2067.19 | 2061.85 | 2065.5 | 321.0 |
| 2008-08-03 19:00:00 | NQ | Futures | 2065.22 | 2066.07 | 2063.53 | 2064.38 | 102.0 |
| 2008-08-03 20:00:00 | NQ | Futures | 2064.38 | 2065.78 | 2061.85 | 2061.85 | 109.0 |
| 2008-08-03 21:00:00 | NQ | Futures | 2061.85 | 2061.85 | 2059.88 | 2059.88 | 113.0 |
| 2008-08-03 22:00:00 | NQ | Futures | 2060.16 | 2062.69 | 2059.03 | 2059.6 | 59.0 |
| 2008-08-03 23:00:00 | NQ | Futures | 2059.03 | 2059.88 | 2058.75 | 2059.6 | 75.0 |
| 2008-08-03 18:00:00 | YM | Futures | 10279.4 | 10294.8 | 10279.4 | 10291.2 | 262.0 |
| 2008-08-03 19:00:00 | YM | Futures | 10291.2 | 10293.9 | 10284.8 | 10290.3 | 84.0 |
| 2008-08-03 20:00:00 | YM | Futures | 10288.5 | 10293.0 | 10273.0 | 10273.0 | 118.0 |
| 2008-08-03 21:00:00 | YM | Futures | 10275.7 | 10277.5 | 10265.7 | 10267.6 | 161.0 |
| 2008-08-03 22:00:00 | YM | Futures | 10272.1 | 10275.7 | 10262.1 | 10263.0 | 210.0 |
| 2008-08-03 23:00:00 | YM | Futures | 10261.2 | 10267.6 | 10261.2 | 10265.7 | 56.0 |
| 2008-08-03 18:00:00 | CL | Futures | 476.32 | 477.57 | 474.02 | 475.98 | 798.0 |
| 2008-08-03 19:00:00 | CL | Futures | 475.98 | 476.7 | 475.68 | 476.7 | 247.0 |
| 2008-08-03 20:00:00 | CL | Futures | 476.51 | 476.66 | 475.83 | 476.25 | 278.0 |
| 2008-08-03 21:00:00 | CL | Futures | 476.25 | 477.34 | 476.1 | 477.34 | 512.0 |
| 2008-08-03 22:00:00 | CL | Futures | 477.31 | 477.72 | 476.97 | 477.16 | 623.0 |
| 2008-08-03 23:00:00 | CL | Futures | 477.19 | 477.57 | 476.44 | 477.19 | 200.0 |
| 2008-08-03 18:00:00 | GC | Futures | 1311.6 | 1317.0 | 1311.5 | 1314.9 | 417.0 |
| 2008-08-03 19:00:00 | GC | Futures | 1315.5 | 1315.9 | 1310.3 | 1311.2 | 484.0 |
| 2008-08-03 20:00:00 | GC | Futures | 1311.3 | 1313.6 | 1309.5 | 1312.2 | 687.0 |
| 2008-08-03 21:00:00 | GC | Futures | 1312.2 | 1315.8 | 1311.9 | 1315.2 | 264.0 |
| 2008-08-03 22:00:00 | GC | Futures | 1315.3 | 1316.8 | 1314.8 | 1316.0 | 326.0 |
| 2008-08-03 23:00:00 | GC | Futures | 1315.8 | 1317.9 | 1315.5 | 1317.2 | 551.0 |
| 2008-08-03 18:00:00 | ZN | Futures | 86.18984 | 86.248345 | 86.178139 | 86.213242 | 979.0 |
| 2008-08-03 19:00:00 | ZN | Futures | 86.213242 | 86.248345 | 86.166438 | 86.248345 | 974.0 |
| 2008-08-03 20:00:00 | ZN | Futures | 86.248345 | 86.260046 | 86.154737 | 86.154737 | 2277.0 |
| 2008-08-03 21:00:00 | ZN | Futures | 86.166438 | 86.213242 | 86.119634 | 86.143036 | 3463.0 |
| 2008-08-03 22:00:00 | ZN | Futures | 86.143036 | 86.166438 | 86.096232 | 86.107933 | 2516.0 |
| 2008-08-03 23:00:00 | ZN | Futures | 86.119634 | 86.143036 | 86.107933 | 86.119634 | 1280.0 |
> showing 36 of 232 rows — these rows as CSV