PREVIEW / futures_1hour / 2009-05-03
file: by_date/futures_1hour/2009/2009-05-03.parquet size: 13 KB rows: 225
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-05-03 18:00:00 | ES | Futures | 839.68 | 845.43 | 839.68 | 843.99 | 10344.0 |
| 2009-05-03 19:00:00 | ES | Futures | 843.75 | 844.47 | 842.55 | 844.23 | 1818.0 |
| 2009-05-03 20:00:00 | ES | Futures | 844.23 | 844.23 | 842.31 | 843.03 | 3011.0 |
| 2009-05-03 21:00:00 | ES | Futures | 842.79 | 843.99 | 842.55 | 843.27 | 3238.0 |
| 2009-05-03 22:00:00 | ES | Futures | 843.27 | 845.43 | 842.79 | 844.95 | 4260.0 |
| 2009-05-03 23:00:00 | ES | Futures | 845.19 | 845.67 | 842.07 | 842.07 | 4806.0 |
| 2009-05-03 18:00:00 | NQ | Futures | 1588.34 | 1598.57 | 1588.34 | 1595.73 | 833.0 |
| 2009-05-03 19:00:00 | NQ | Futures | 1596.01 | 1596.58 | 1593.46 | 1596.3 | 212.0 |
| 2009-05-03 20:00:00 | NQ | Futures | 1596.3 | 1596.3 | 1592.6 | 1594.88 | 218.0 |
| 2009-05-03 21:00:00 | NQ | Futures | 1594.88 | 1597.43 | 1594.02 | 1595.73 | 400.0 |
| 2009-05-03 22:00:00 | NQ | Futures | 1596.87 | 1599.99 | 1595.16 | 1599.71 | 208.0 |
| 2009-05-03 23:00:00 | NQ | Futures | 1598.57 | 1599.99 | 1594.59 | 1595.16 | 349.0 |
| 2009-05-03 18:00:00 | YM | Futures | 7510.6 | 7561.1 | 7510.6 | 7550.1 | 504.0 |
| 2009-05-03 19:00:00 | YM | Futures | 7547.3 | 7547.3 | 7538.1 | 7547.3 | 113.0 |
| 2009-05-03 20:00:00 | YM | Futures | 7548.2 | 7549.2 | 7532.6 | 7539.1 | 192.0 |
| 2009-05-03 21:00:00 | YM | Futures | 7539.1 | 7552.8 | 7536.3 | 7546.4 | 287.0 |
| 2009-05-03 22:00:00 | YM | Futures | 7547.3 | 7561.1 | 7540.0 | 7559.3 | 257.0 |
| 2009-05-03 23:00:00 | YM | Futures | 7559.3 | 7563.0 | 7535.4 | 7541.8 | 349.0 |
| 2009-05-03 18:00:00 | CL | Futures | 127.719 | 129.37 | 127.719 | 129.103 | 838.0 |
| 2009-05-03 19:00:00 | CL | Futures | 129.03 | 129.2 | 128.18 | 128.544 | 321.0 |
| 2009-05-03 20:00:00 | CL | Futures | 128.52 | 129.248 | 128.229 | 129.224 | 355.0 |
| 2009-05-03 21:00:00 | CL | Futures | 129.151 | 129.806 | 128.957 | 129.612 | 648.0 |
| 2009-05-03 22:00:00 | CL | Futures | 129.685 | 129.709 | 129.418 | 129.564 | 195.0 |
| 2009-05-03 23:00:00 | CL | Futures | 129.588 | 129.831 | 128.52 | 129.103 | 533.0 |
| 2009-05-03 18:00:00 | GC | Futures | 1259.5 | 1260.6 | 1256.8 | 1259.8 | 444.0 |
| 2009-05-03 19:00:00 | GC | Futures | 1259.6 | 1260.3 | 1258.8 | 1259.6 | 90.0 |
| 2009-05-03 20:00:00 | GC | Futures | 1259.5 | 1259.8 | 1257.6 | 1258.8 | 280.0 |
| 2009-05-03 21:00:00 | GC | Futures | 1258.5 | 1267.6 | 1258.5 | 1265.9 | 1416.0 |
| 2009-05-03 22:00:00 | GC | Futures | 1265.9 | 1266.6 | 1264.6 | 1265.6 | 404.0 |
| 2009-05-03 23:00:00 | GC | Futures | 1265.9 | 1268.0 | 1265.6 | 1266.6 | 487.0 |
| 2009-05-03 18:00:00 | ZN | Futures | 94.393381 | 94.40559 | 94.295703 | 94.307913 | 931.0 |
| 2009-05-03 19:00:00 | ZN | Futures | 94.307913 | 94.320122 | 94.283493 | 94.307913 | 611.0 |
| 2009-05-03 20:00:00 | ZN | Futures | 94.307913 | 94.320122 | 94.295703 | 94.307913 | 531.0 |
| 2009-05-03 21:00:00 | ZN | Futures | 94.320122 | 94.320122 | 94.295703 | 94.295703 | 248.0 |
| 2009-05-03 22:00:00 | ZN | Futures | 94.295703 | 94.295703 | 94.198025 | 94.222445 | 2057.0 |
| 2009-05-03 23:00:00 | ZN | Futures | 94.210235 | 94.246864 | 94.198025 | 94.234654 | 820.0 |
> showing 36 of 225 rows — these rows as CSV