PREVIEW / futures_1hour / 2008-01-27
file: by_date/futures_1hour/2008/2008-01-27.parquet size: 11 KB rows: 177
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-01-27 18:00:00 | ES | Futures | 1245.99 | 1246.69 | 1241.56 | 1243.66 | 5432.0 |
| 2008-01-27 19:00:00 | ES | Futures | 1243.66 | 1244.82 | 1238.53 | 1241.79 | 6375.0 |
| 2008-01-27 20:00:00 | ES | Futures | 1241.79 | 1242.02 | 1238.29 | 1240.86 | 4211.0 |
| 2008-01-27 21:00:00 | ES | Futures | 1241.32 | 1242.49 | 1239.69 | 1241.56 | 2657.0 |
| 2008-01-27 22:00:00 | ES | Futures | 1241.79 | 1241.79 | 1235.73 | 1235.96 | 6220.0 |
| 2008-01-27 23:00:00 | ES | Futures | 1236.19 | 1236.43 | 1234.1 | 1234.56 | 4587.0 |
| 2008-01-27 18:00:00 | NQ | Futures | 2039.7 | 2041.4 | 2033.17 | 2035.73 | 586.0 |
| 2008-01-27 19:00:00 | NQ | Futures | 2036.01 | 2037.43 | 2027.21 | 2032.04 | 342.0 |
| 2008-01-27 20:00:00 | NQ | Futures | 2031.47 | 2031.75 | 2027.21 | 2030.62 | 240.0 |
| 2008-01-27 21:00:00 | NQ | Futures | 2031.75 | 2033.74 | 2030.33 | 2032.04 | 214.0 |
| 2008-01-27 22:00:00 | NQ | Futures | 2032.32 | 2032.32 | 2020.12 | 2021.82 | 724.0 |
| 2008-01-27 23:00:00 | NQ | Futures | 2020.97 | 2022.1 | 2016.71 | 2018.7 | 291.0 |
| 2008-01-27 18:00:00 | YM | Futures | 11120.9 | 11136.4 | 11103.7 | 11114.6 | 454.0 |
| 2008-01-27 19:00:00 | YM | Futures | 11119.1 | 11127.3 | 11077.3 | 11099.1 | 307.0 |
| 2008-01-27 20:00:00 | YM | Futures | 11098.2 | 11108.2 | 11077.3 | 11090.0 | 305.0 |
| 2008-01-27 21:00:00 | YM | Futures | 11091.9 | 11104.6 | 11085.5 | 11096.4 | 172.0 |
| 2008-01-27 22:00:00 | YM | Futures | 11096.4 | 11096.4 | 11054.6 | 11060.1 | 602.0 |
| 2008-01-27 23:00:00 | YM | Futures | 11061.0 | 11062.8 | 11047.3 | 11049.2 | 245.0 |
| 2008-01-27 18:00:00 | CL | Futures | 338.48 | 338.81 | 336.8 | 336.98 | 1014.0 |
| 2008-01-27 19:00:00 | CL | Futures | 336.95 | 337.47 | 336.54 | 336.61 | 489.0 |
| 2008-01-27 20:00:00 | CL | Futures | 336.61 | 337.1 | 336.35 | 336.8 | 525.0 |
| 2008-01-27 21:00:00 | CL | Futures | 336.83 | 336.83 | 335.75 | 336.27 | 554.0 |
| 2008-01-27 22:00:00 | CL | Futures | 336.27 | 336.68 | 335.64 | 335.79 | 408.0 |
| 2008-01-27 23:00:00 | CL | Futures | 335.71 | 335.79 | 335.49 | 335.75 | 259.0 |
| 2008-01-27 18:00:00 | GC | Futures | 1336.4 | 1341.0 | 1334.9 | 1340.9 | 219.0 |
| 2008-01-27 19:00:00 | GC | Futures | 1340.7 | 1347.4 | 1340.2 | 1340.2 | 358.0 |
| 2008-01-27 20:00:00 | GC | Futures | 1340.4 | 1344.5 | 1340.0 | 1344.5 | 99.0 |
| 2008-01-27 21:00:00 | GC | Futures | 1344.8 | 1345.0 | 1342.2 | 1344.1 | 136.0 |
| 2008-01-27 22:00:00 | GC | Futures | 1343.8 | 1350.6 | 1342.8 | 1349.6 | 622.0 |
| 2008-01-27 23:00:00 | GC | Futures | 1349.5 | 1349.5 | 1348.0 | 1348.6 | 353.0 |
| 2008-01-27 18:00:00 | ZN | Futures | 85.419742 | 85.453919 | 85.40835 | 85.419742 | 2522.0 |
| 2008-01-27 19:00:00 | ZN | Futures | 85.40835 | 85.40835 | 85.271642 | 85.271642 | 6272.0 |
| 2008-01-27 20:00:00 | ZN | Futures | 85.271642 | 85.362781 | 85.271642 | 85.328604 | 4173.0 |
| 2008-01-27 21:00:00 | ZN | Futures | 85.339996 | 85.385565 | 85.339996 | 85.374173 | 4620.0 |
| 2008-01-27 22:00:00 | ZN | Futures | 85.385565 | 85.431135 | 85.362781 | 85.40835 | 3868.0 |
| 2008-01-27 23:00:00 | ZN | Futures | 85.40835 | 85.522273 | 85.40835 | 85.522273 | 6609.0 |
> showing 36 of 177 rows — these rows as CSV