PREVIEW / futures_1hour / 2009-07-05
file: by_date/futures_1hour/2009/2009-07-05.parquet size: 12 KB rows: 214
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-07-05 18:00:00 | ES | Futures | 860.48 | 862.17 | 857.59 | 858.31 | 9071.0 |
| 2009-07-05 19:00:00 | ES | Futures | 858.07 | 858.79 | 857.1 | 857.59 | 2963.0 |
| 2009-07-05 20:00:00 | ES | Futures | 857.59 | 858.79 | 857.59 | 858.79 | 2626.0 |
| 2009-07-05 21:00:00 | ES | Futures | 858.79 | 859.52 | 853.73 | 854.69 | 7813.0 |
| 2009-07-05 22:00:00 | ES | Futures | 854.69 | 855.66 | 852.76 | 855.17 | 6667.0 |
| 2009-07-05 23:00:00 | ES | Futures | 855.17 | 856.38 | 854.21 | 854.93 | 3886.0 |
| 2009-07-05 18:00:00 | NQ | Futures | 1643.64 | 1645.35 | 1637.09 | 1637.09 | 788.0 |
| 2009-07-05 19:00:00 | NQ | Futures | 1637.38 | 1639.37 | 1635.95 | 1636.81 | 211.0 |
| 2009-07-05 20:00:00 | NQ | Futures | 1637.09 | 1639.08 | 1637.09 | 1638.8 | 311.0 |
| 2009-07-05 21:00:00 | NQ | Futures | 1639.37 | 1640.22 | 1629.69 | 1632.25 | 700.0 |
| 2009-07-05 22:00:00 | NQ | Futures | 1632.82 | 1633.67 | 1629.12 | 1632.82 | 448.0 |
| 2009-07-05 23:00:00 | NQ | Futures | 1632.53 | 1633.96 | 1629.69 | 1630.82 | 260.0 |
| 2009-07-05 18:00:00 | YM | Futures | 7609.8 | 7619.0 | 7584.8 | 7590.4 | 406.0 |
| 2009-07-05 19:00:00 | YM | Futures | 7590.4 | 7595.9 | 7584.8 | 7584.8 | 153.0 |
| 2009-07-05 20:00:00 | YM | Futures | 7587.6 | 7594.1 | 7586.7 | 7594.1 | 161.0 |
| 2009-07-05 21:00:00 | YM | Futures | 7594.1 | 7597.8 | 7558.9 | 7564.5 | 768.0 |
| 2009-07-05 22:00:00 | YM | Futures | 7565.4 | 7572.8 | 7551.5 | 7569.1 | 416.0 |
| 2009-07-05 23:00:00 | YM | Futures | 7565.4 | 7576.5 | 7559.8 | 7567.2 | 356.0 |
| 2009-07-05 18:00:00 | CL | Futures | 155.199 | 155.46 | 154.063 | 154.726 | 1349.0 |
| 2009-07-05 19:00:00 | CL | Futures | 154.631 | 155.081 | 154.56 | 154.631 | 363.0 |
| 2009-07-05 20:00:00 | CL | Futures | 154.702 | 154.702 | 153.755 | 154.252 | 1111.0 |
| 2009-07-05 21:00:00 | CL | Futures | 154.276 | 154.489 | 153.873 | 154.063 | 529.0 |
| 2009-07-05 22:00:00 | CL | Futures | 154.039 | 154.11 | 153.092 | 153.802 | 1812.0 |
| 2009-07-05 23:00:00 | CL | Futures | 153.802 | 154.299 | 153.755 | 154.134 | 479.0 |
| 2009-07-05 18:00:00 | GC | Futures | 1320.4 | 1320.8 | 1316.6 | 1317.4 | 390.0 |
| 2009-07-05 19:00:00 | GC | Futures | 1317.4 | 1318.9 | 1317.0 | 1318.6 | 148.0 |
| 2009-07-05 20:00:00 | GC | Futures | 1318.7 | 1319.6 | 1316.4 | 1316.9 | 449.0 |
| 2009-07-05 21:00:00 | GC | Futures | 1316.7 | 1318.0 | 1315.2 | 1317.4 | 624.0 |
| 2009-07-05 22:00:00 | GC | Futures | 1317.3 | 1318.0 | 1316.7 | 1317.0 | 566.0 |
| 2009-07-05 23:00:00 | GC | Futures | 1317.0 | 1318.4 | 1316.7 | 1317.4 | 257.0 |
| 2009-07-05 18:00:00 | ZN | Futures | 92.754375 | 92.791576 | 92.717174 | 92.791576 | 444.0 |
| 2009-07-05 19:00:00 | ZN | Futures | 92.791576 | 92.803976 | 92.766775 | 92.766775 | 651.0 |
| 2009-07-05 20:00:00 | ZN | Futures | 92.766775 | 92.828776 | 92.766775 | 92.816376 | 1570.0 |
| 2009-07-05 21:00:00 | ZN | Futures | 92.803976 | 92.853577 | 92.791576 | 92.841177 | 1217.0 |
| 2009-07-05 22:00:00 | ZN | Futures | 92.853577 | 92.903178 | 92.853577 | 92.878378 | 1729.0 |
| 2009-07-05 23:00:00 | ZN | Futures | 92.878378 | 92.890778 | 92.853577 | 92.865977 | 1152.0 |
> showing 36 of 214 rows — these rows as CSV