PREVIEW / futures_1hour / 2009-11-29
file: by_date/futures_1hour/2009/2009-11-29.parquet size: 13 KB rows: 230
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-11-29 18:00:00 | ES | Futures | 1057.54 | 1062.14 | 1057.3 | 1059.72 | 18749.0 |
| 2009-11-29 19:00:00 | ES | Futures | 1059.72 | 1060.45 | 1058.02 | 1059.48 | 11624.0 |
| 2009-11-29 20:00:00 | ES | Futures | 1059.48 | 1063.84 | 1059.24 | 1062.14 | 18385.0 |
| 2009-11-29 21:00:00 | ES | Futures | 1061.9 | 1062.87 | 1061.17 | 1062.38 | 5713.0 |
| 2009-11-29 22:00:00 | ES | Futures | 1062.38 | 1062.87 | 1061.17 | 1061.9 | 4848.0 |
| 2009-11-29 23:00:00 | ES | Futures | 1061.9 | 1063.35 | 1061.66 | 1062.38 | 5549.0 |
| 2009-11-29 18:00:00 | NQ | Futures | 2011.19 | 2023.45 | 2011.19 | 2016.89 | 1846.0 |
| 2009-11-29 19:00:00 | NQ | Futures | 2016.89 | 2017.75 | 2013.76 | 2016.32 | 499.0 |
| 2009-11-29 20:00:00 | NQ | Futures | 2016.32 | 2024.88 | 2016.32 | 2021.46 | 1199.0 |
| 2009-11-29 21:00:00 | NQ | Futures | 2021.46 | 2023.45 | 2020.6 | 2022.31 | 376.0 |
| 2009-11-29 22:00:00 | NQ | Futures | 2022.88 | 2023.45 | 2020.6 | 2022.03 | 501.0 |
| 2009-11-29 23:00:00 | NQ | Futures | 2021.74 | 2024.59 | 2021.46 | 2022.88 | 310.0 |
| 2009-11-29 18:00:00 | YM | Futures | 9589.3 | 9621.8 | 9588.3 | 9606.0 | 816.0 |
| 2009-11-29 19:00:00 | YM | Futures | 9606.0 | 9610.7 | 9594.9 | 9604.2 | 513.0 |
| 2009-11-29 20:00:00 | YM | Futures | 9605.1 | 9643.2 | 9603.2 | 9621.8 | 1173.0 |
| 2009-11-29 21:00:00 | YM | Futures | 9622.8 | 9631.1 | 9616.2 | 9624.6 | 402.0 |
| 2009-11-29 22:00:00 | YM | Futures | 9624.6 | 9628.3 | 9616.2 | 9621.8 | 415.0 |
| 2009-11-29 23:00:00 | YM | Futures | 9620.9 | 9632.1 | 9620.0 | 9624.6 | 324.0 |
| 2009-11-29 18:00:00 | CL | Futures | 168.44 | 169.93 | 168.44 | 169.31 | 6036.0 |
| 2009-11-29 19:00:00 | CL | Futures | 169.33 | 169.33 | 167.87 | 168.4 | 4594.0 |
| 2009-11-29 20:00:00 | CL | Futures | 168.4 | 170.17 | 168.4 | 169.62 | 5518.0 |
| 2009-11-29 21:00:00 | CL | Futures | 169.57 | 170.19 | 169.44 | 169.95 | 1404.0 |
| 2009-11-29 22:00:00 | CL | Futures | 169.95 | 169.95 | 169.64 | 169.86 | 1088.0 |
| 2009-11-29 23:00:00 | CL | Futures | 169.86 | 170.04 | 169.71 | 169.71 | 898.0 |
| 2009-11-29 18:00:00 | GC | Futures | 1665.8 | 1670.0 | 1644.3 | 1651.7 | 9598.0 |
| 2009-11-29 19:00:00 | GC | Futures | 1651.8 | 1657.3 | 1648.6 | 1653.8 | 3676.0 |
| 2009-11-29 20:00:00 | GC | Futures | 1653.6 | 1662.8 | 1653.6 | 1659.6 | 6904.0 |
| 2009-11-29 21:00:00 | GC | Futures | 1659.7 | 1662.1 | 1656.9 | 1662.1 | 1907.0 |
| 2009-11-29 22:00:00 | GC | Futures | 1662.2 | 1662.5 | 1658.0 | 1660.4 | 1377.0 |
| 2009-11-29 23:00:00 | GC | Futures | 1660.4 | 1662.7 | 1660.1 | 1660.5 | 1357.0 |
| 2009-11-29 18:00:00 | ZN | Futures | 97.155496 | 97.193139 | 97.092758 | 97.105306 | 2900.0 |
| 2009-11-29 19:00:00 | ZN | Futures | 97.117853 | 97.205686 | 97.105306 | 97.142949 | 1299.0 |
| 2009-11-29 20:00:00 | ZN | Futures | 97.130401 | 97.142949 | 97.067663 | 97.080211 | 1586.0 |
| 2009-11-29 21:00:00 | ZN | Futures | 97.080211 | 97.105306 | 97.080211 | 97.092758 | 356.0 |
| 2009-11-29 22:00:00 | ZN | Futures | 97.105306 | 97.117853 | 97.092758 | 97.117853 | 555.0 |
| 2009-11-29 23:00:00 | ZN | Futures | 97.130401 | 97.130401 | 97.080211 | 97.080211 | 614.0 |
> showing 36 of 230 rows — these rows as CSV