PREVIEW / futures_1hour / 2009-04-19
file: by_date/futures_1hour/2009/2009-04-19.parquet size: 13 KB rows: 227
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-19 18:00:00 | ES | Futures | 829.61 | 829.61 | 826.26 | 826.98 | 6138.0 |
| 2009-04-19 19:00:00 | ES | Futures | 826.98 | 827.22 | 826.02 | 826.74 | 2922.0 |
| 2009-04-19 20:00:00 | ES | Futures | 826.5 | 827.7 | 824.82 | 825.3 | 4092.0 |
| 2009-04-19 21:00:00 | ES | Futures | 825.3 | 826.26 | 824.1 | 824.34 | 4815.0 |
| 2009-04-19 22:00:00 | ES | Futures | 824.34 | 824.34 | 822.9 | 824.1 | 4839.0 |
| 2009-04-19 23:00:00 | ES | Futures | 823.86 | 825.06 | 823.86 | 824.34 | 2417.0 |
| 2009-04-19 18:00:00 | NQ | Futures | 1533.79 | 1533.79 | 1528.96 | 1531.23 | 333.0 |
| 2009-04-19 19:00:00 | NQ | Futures | 1530.95 | 1530.95 | 1528.96 | 1530.09 | 87.0 |
| 2009-04-19 20:00:00 | NQ | Futures | 1530.38 | 1531.51 | 1527.25 | 1527.82 | 150.0 |
| 2009-04-19 21:00:00 | NQ | Futures | 1528.39 | 1529.24 | 1524.98 | 1525.55 | 252.0 |
| 2009-04-19 22:00:00 | NQ | Futures | 1525.55 | 1525.83 | 1522.14 | 1524.13 | 410.0 |
| 2009-04-19 23:00:00 | NQ | Futures | 1524.41 | 1526.68 | 1523.84 | 1525.26 | 130.0 |
| 2009-04-19 18:00:00 | YM | Futures | 7415.0 | 7418.7 | 7392.9 | 7398.5 | 235.0 |
| 2009-04-19 19:00:00 | YM | Futures | 7397.5 | 7397.5 | 7388.4 | 7391.1 | 418.0 |
| 2009-04-19 20:00:00 | YM | Futures | 7390.2 | 7398.5 | 7378.2 | 7381.0 | 367.0 |
| 2009-04-19 21:00:00 | YM | Futures | 7381.0 | 7388.4 | 7371.8 | 7374.6 | 265.0 |
| 2009-04-19 22:00:00 | YM | Futures | 7373.6 | 7374.6 | 7362.6 | 7373.6 | 255.0 |
| 2009-04-19 23:00:00 | YM | Futures | 7373.6 | 7383.8 | 7372.7 | 7376.4 | 226.0 |
| 2009-04-19 18:00:00 | CL | Futures | 126.85 | 127.21 | 126.82 | 127.06 | 384.0 |
| 2009-04-19 19:00:00 | CL | Futures | 127.02 | 127.04 | 126.87 | 126.94 | 116.0 |
| 2009-04-19 20:00:00 | CL | Futures | 126.92 | 126.94 | 126.7 | 126.7 | 480.0 |
| 2009-04-19 21:00:00 | CL | Futures | 126.7 | 126.72 | 125.56 | 125.63 | 1300.0 |
| 2009-04-19 22:00:00 | CL | Futures | 125.66 | 125.66 | 125.05 | 125.56 | 447.0 |
| 2009-04-19 23:00:00 | CL | Futures | 125.49 | 125.49 | 125.12 | 125.36 | 223.0 |
| 2009-04-19 18:00:00 | GC | Futures | 1234.9 | 1235.1 | 1231.8 | 1233.5 | 327.0 |
| 2009-04-19 19:00:00 | GC | Futures | 1233.5 | 1236.1 | 1233.5 | 1234.6 | 357.0 |
| 2009-04-19 20:00:00 | GC | Futures | 1234.6 | 1235.5 | 1228.4 | 1230.2 | 1006.0 |
| 2009-04-19 21:00:00 | GC | Futures | 1230.2 | 1232.4 | 1229.5 | 1231.5 | 724.0 |
| 2009-04-19 22:00:00 | GC | Futures | 1231.8 | 1235.9 | 1231.4 | 1234.5 | 877.0 |
| 2009-04-19 23:00:00 | GC | Futures | 1234.5 | 1234.9 | 1232.7 | 1233.2 | 394.0 |
| 2009-04-19 18:00:00 | ZN | Futures | 95.504466 | 95.553305 | 95.455627 | 95.480046 | 298.0 |
| 2009-04-19 19:00:00 | ZN | Futures | 95.480046 | 95.565514 | 95.467836 | 95.553305 | 911.0 |
| 2009-04-19 20:00:00 | ZN | Futures | 95.565514 | 95.675402 | 95.565514 | 95.663192 | 4441.0 |
| 2009-04-19 21:00:00 | ZN | Futures | 95.663192 | 95.675402 | 95.638773 | 95.663192 | 3009.0 |
| 2009-04-19 22:00:00 | ZN | Futures | 95.663192 | 95.712031 | 95.663192 | 95.699821 | 1706.0 |
| 2009-04-19 23:00:00 | ZN | Futures | 95.687611 | 95.699821 | 95.626563 | 95.650982 | 1212.0 |
> showing 36 of 227 rows — these rows as CSV