PREVIEW / futures_1hour / 2009-04-12
file: by_date/futures_1hour/2009/2009-04-12.parquet size: 12 KB rows: 218
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 |
|---|---|---|---|---|---|---|---|
| 2009-04-12 18:00:00 | ES | Futures | 813.56 | 814.28 | 811.16 | 812.12 | 7028.0 |
| 2009-04-12 19:00:00 | ES | Futures | 812.12 | 812.36 | 810.44 | 810.92 | 2403.0 |
| 2009-04-12 20:00:00 | ES | Futures | 810.92 | 812.84 | 809.96 | 812.84 | 3433.0 |
| 2009-04-12 21:00:00 | ES | Futures | 812.84 | 813.32 | 811.64 | 811.88 | 2106.0 |
| 2009-04-12 22:00:00 | ES | Futures | 811.88 | 812.36 | 811.4 | 812.12 | 1109.0 |
| 2009-04-12 23:00:00 | ES | Futures | 812.12 | 813.56 | 811.4 | 813.56 | 1502.0 |
| 2009-04-12 18:00:00 | NQ | Futures | 1513.9 | 1521.85 | 1512.76 | 1517.59 | 3485.0 |
| 2009-04-12 19:00:00 | NQ | Futures | 1517.59 | 1517.59 | 1513.9 | 1516.45 | 412.0 |
| 2009-04-12 20:00:00 | NQ | Futures | 1514.75 | 1516.74 | 1512.76 | 1516.45 | 347.0 |
| 2009-04-12 21:00:00 | NQ | Futures | 1516.45 | 1517.02 | 1513.61 | 1513.9 | 303.0 |
| 2009-04-12 22:00:00 | NQ | Futures | 1514.18 | 1515.03 | 1513.33 | 1513.61 | 240.0 |
| 2009-04-12 23:00:00 | NQ | Futures | 1513.61 | 1516.17 | 1511.91 | 1516.17 | 232.0 |
| 2009-04-12 18:00:00 | YM | Futures | 7344.2 | 7349.8 | 7324.0 | 7326.8 | 215.0 |
| 2009-04-12 19:00:00 | YM | Futures | 7331.4 | 7331.4 | 7313.9 | 7321.3 | 156.0 |
| 2009-04-12 20:00:00 | YM | Futures | 7321.3 | 7334.1 | 7312.1 | 7334.1 | 119.0 |
| 2009-04-12 21:00:00 | YM | Futures | 7335.1 | 7339.6 | 7328.6 | 7330.5 | 150.0 |
| 2009-04-12 22:00:00 | YM | Futures | 7326.8 | 7329.5 | 7322.2 | 7327.7 | 82.0 |
| 2009-04-12 23:00:00 | YM | Futures | 7326.8 | 7340.6 | 7324.0 | 7340.6 | 118.0 |
| 2009-04-12 18:00:00 | CL | Futures | 132.66 | 133.05 | 131.69 | 132.41 | 650.0 |
| 2009-04-12 19:00:00 | CL | Futures | 132.41 | 132.41 | 131.44 | 131.49 | 355.0 |
| 2009-04-12 20:00:00 | CL | Futures | 131.59 | 132.31 | 131.08 | 132.1 | 618.0 |
| 2009-04-12 21:00:00 | CL | Futures | 132.15 | 132.51 | 132.1 | 132.25 | 252.0 |
| 2009-04-12 22:00:00 | CL | Futures | 132.23 | 132.28 | 131.77 | 132.18 | 252.0 |
| 2009-04-12 23:00:00 | CL | Futures | 132.2 | 132.36 | 132.15 | 132.33 | 190.0 |
| 2009-04-12 18:00:00 | GC | Futures | 1252.9 | 1259.5 | 1252.9 | 1257.2 | 486.0 |
| 2009-04-12 19:00:00 | GC | Futures | 1256.6 | 1257.9 | 1256.1 | 1256.2 | 243.0 |
| 2009-04-12 20:00:00 | GC | Futures | 1256.4 | 1257.6 | 1254.2 | 1257.2 | 379.0 |
| 2009-04-12 21:00:00 | GC | Futures | 1257.5 | 1258.5 | 1256.2 | 1256.9 | 268.0 |
| 2009-04-12 22:00:00 | GC | Futures | 1257.2 | 1262.0 | 1256.9 | 1260.3 | 723.0 |
| 2009-04-12 23:00:00 | GC | Futures | 1260.6 | 1261.2 | 1258.9 | 1259.9 | 475.0 |
| 2009-04-12 18:00:00 | ZN | Futures | 95.480046 | 95.541095 | 95.480046 | 95.504466 | 353.0 |
| 2009-04-12 19:00:00 | ZN | Futures | 95.516675 | 95.602143 | 95.516675 | 95.589934 | 465.0 |
| 2009-04-12 20:00:00 | ZN | Futures | 95.589934 | 95.638773 | 95.577724 | 95.602143 | 435.0 |
| 2009-04-12 21:00:00 | ZN | Futures | 95.614353 | 95.626563 | 95.589934 | 95.614353 | 844.0 |
| 2009-04-12 22:00:00 | ZN | Futures | 95.602143 | 95.626563 | 95.602143 | 95.614353 | 289.0 |
| 2009-04-12 23:00:00 | ZN | Futures | 95.614353 | 95.626563 | 95.602143 | 95.614353 | 233.0 |
> showing 36 of 218 rows — these rows as CSV