PREVIEW / futures_1hour / 2009-11-22
file: by_date/futures_1hour/2009/2009-11-22.parquet size: 12 KB rows: 216
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-22 18:00:00 | ES | Futures | 1055.84 | 1057.06 | 1055.12 | 1056.09 | 12775.0 |
| 2009-11-22 19:00:00 | ES | Futures | 1056.33 | 1060.45 | 1056.33 | 1059.48 | 8492.0 |
| 2009-11-22 20:00:00 | ES | Futures | 1059.48 | 1059.72 | 1058.51 | 1059.24 | 3204.0 |
| 2009-11-22 21:00:00 | ES | Futures | 1059.24 | 1060.45 | 1059.24 | 1060.45 | 3182.0 |
| 2009-11-22 22:00:00 | ES | Futures | 1060.45 | 1060.69 | 1059.48 | 1060.69 | 1408.0 |
| 2009-11-22 23:00:00 | ES | Futures | 1060.45 | 1060.69 | 1059.96 | 1060.2 | 1671.0 |
| 2009-11-22 18:00:00 | NQ | Futures | 2011.19 | 2013.19 | 2010.33 | 2012.33 | 232.0 |
| 2009-11-22 19:00:00 | NQ | Futures | 2012.33 | 2020.03 | 2012.33 | 2019.17 | 523.0 |
| 2009-11-22 20:00:00 | NQ | Futures | 2019.17 | 2019.46 | 2017.46 | 2018.6 | 414.0 |
| 2009-11-22 21:00:00 | NQ | Futures | 2018.6 | 2020.6 | 2018.6 | 2020.32 | 200.0 |
| 2009-11-22 22:00:00 | NQ | Futures | 2020.32 | 2020.89 | 2018.6 | 2020.6 | 156.0 |
| 2009-11-22 23:00:00 | NQ | Futures | 2020.32 | 2020.6 | 2019.75 | 2019.75 | 101.0 |
| 2009-11-22 18:00:00 | YM | Futures | 9584.6 | 9591.1 | 9575.3 | 9590.2 | 214.0 |
| 2009-11-22 19:00:00 | YM | Futures | 9591.1 | 9621.8 | 9589.3 | 9615.3 | 555.0 |
| 2009-11-22 20:00:00 | YM | Futures | 9614.4 | 9616.2 | 9605.1 | 9611.6 | 240.0 |
| 2009-11-22 21:00:00 | YM | Futures | 9611.6 | 9620.9 | 9611.6 | 9620.9 | 175.0 |
| 2009-11-22 22:00:00 | YM | Futures | 9619.0 | 9624.6 | 9614.4 | 9622.8 | 174.0 |
| 2009-11-22 23:00:00 | YM | Futures | 9622.8 | 9625.6 | 9618.1 | 9619.0 | 175.0 |
| 2009-11-22 18:00:00 | CL | Futures | 172.32 | 173.07 | 172.1 | 172.5 | 4182.0 |
| 2009-11-22 19:00:00 | CL | Futures | 172.47 | 173.01 | 172.41 | 172.81 | 2253.0 |
| 2009-11-22 20:00:00 | CL | Futures | 172.78 | 173.14 | 172.72 | 172.96 | 1890.0 |
| 2009-11-22 21:00:00 | CL | Futures | 172.94 | 173.36 | 172.94 | 173.29 | 2268.0 |
| 2009-11-22 22:00:00 | CL | Futures | 173.29 | 173.4 | 172.83 | 173.4 | 1950.0 |
| 2009-11-22 23:00:00 | CL | Futures | 173.38 | 173.49 | 173.09 | 173.34 | 1302.0 |
| 2009-11-22 18:00:00 | GC | Futures | 1626.1 | 1636.0 | 1625.6 | 1634.7 | 5055.0 |
| 2009-11-22 19:00:00 | GC | Futures | 1634.7 | 1640.9 | 1633.5 | 1637.4 | 4748.0 |
| 2009-11-22 20:00:00 | GC | Futures | 1637.5 | 1639.5 | 1637.1 | 1639.5 | 1510.0 |
| 2009-11-22 21:00:00 | GC | Futures | 1639.5 | 1644.2 | 1638.8 | 1643.9 | 3643.0 |
| 2009-11-22 22:00:00 | GC | Futures | 1643.8 | 1644.2 | 1640.2 | 1643.3 | 2168.0 |
| 2009-11-22 23:00:00 | GC | Futures | 1643.2 | 1644.5 | 1642.2 | 1643.1 | 1908.0 |
| 2009-11-22 18:00:00 | ZN | Futures | 95.976029 | 95.988576 | 95.950934 | 95.963481 | 1795.0 |
| 2009-11-22 19:00:00 | ZN | Futures | 95.963481 | 95.976029 | 95.900743 | 95.913291 | 2142.0 |
| 2009-11-22 20:00:00 | ZN | Futures | 95.913291 | 95.938386 | 95.913291 | 95.938386 | 636.0 |
| 2009-11-22 21:00:00 | ZN | Futures | 95.938386 | 95.950934 | 95.925838 | 95.925838 | 1363.0 |
| 2009-11-22 22:00:00 | ZN | Futures | 95.938386 | 95.976029 | 95.938386 | 95.976029 | 1333.0 |
| 2009-11-22 23:00:00 | ZN | Futures | 95.976029 | 95.988576 | 95.963481 | 95.976029 | 386.0 |
> showing 36 of 216 rows — these rows as CSV