PREVIEW / futures_daily / 2008-09-26
file: by_date/futures_daily/2008/2008-09-26.parquet size: 8 KB rows: 83
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2008-09-26 | ES | Futures | 1141.48 | 1149.96 | 1115.59 | 1143.6 | 2225525.0 |
| 2008-09-26 | NQ | Futures | 1872.84 | 1884.02 | 1823.07 | 1873.12 | 363341.0 |
| 2008-09-26 | YM | Futures | 9778.9 | 9929.1 | 9594.2 | 9902.4 | 193261.0 |
| 2008-09-26 | CL | Futures | 465.13 | 466.9 | 450.23 | 461.63 | 168454.0 |
| 2008-09-26 | GC | Futures | 1234.2 | 1286.7 | 1218.4 | 1242.5 | 167403.0 |
| 2008-09-26 | ZN | Futures | 85.604484 | 86.083701 | 85.510978 | 85.885001 | 607197.0 |
| 2008-09-26 | A6 | Futures | 0.65293 | 0.65537 | 0.64466 | 0.64962 | 26787.0 |
| 2008-09-26 | AD | Futures | 0.95593 | 0.9579 | 0.95208 | 0.95692 | 23249.0 |
| 2008-09-26 | B | Futures | 121.75 | 122.32 | 119.07 | 121.79 | 47591.0 |
| 2008-09-26 | B6 | Futures | 1.9042 | 1.9143 | 1.8997 | 1.909 | 60721.0 |
| 2008-09-26 | BFX | Futures | 3185.8 | 3201.5 | 3156.1 | 3156.1 | 213.0 |
| 2008-09-26 | BZ | Futures | 116.77 | 116.77 | 116.77 | 116.77 | 733.0 |
| 2008-09-26 | C | Futures | 1356.0 | 1368.0 | 1342.0 | 1358.0 | 3369.0 |
| 2008-09-26 | CB | Futures | 96.065 | 96.065 | 95.909 | 95.909 | 8.0 |
| 2008-09-26 | CC | Futures | 2434.0 | 2463.0 | 2408.0 | 2437.0 | 3891.0 |
| 2008-09-26 | CT | Futures | 59.89 | 60.12 | 59.89 | 60.12 | 5822.0 |
| 2008-09-26 | DC | Futures | 41.91 | 42.16 | 41.78 | 41.78 | 39.0 |
| 2008-09-26 | DX | Futures | 80.615 | 80.945 | 80.505 | 80.709 | 3080.0 |
| 2008-09-26 | E1 | Futures | 1.23083 | 1.23817 | 1.22856 | 1.23136 | 39742.0 |
| 2008-09-26 | E6 | Futures | 1.72677 | 1.73386 | 1.71921 | 1.7276 | 173796.0 |
| 2008-09-26 | E7 | Futures | 1.7098 | 1.7171 | 1.7026 | 1.711 | 2628.0 |
| 2008-09-26 | ED | Futures | 91.2794 | 91.3644 | 91.0999 | 91.3361 | 334458.0 |
| 2008-09-26 | ER | Futures | 93.442 | 93.625 | 93.403 | 93.541 | 214398.0 |
| 2008-09-26 | EW | Futures | 746.8 | 751.5 | 730.6 | 741.6 | 30814.0 |
| 2008-09-26 | FCE | Futures | 2674.7 | 2708.4 | 2641.0 | 2679.8 | 133932.0 |
| 2008-09-26 | FDAX | Futures | 6884.5 | 6906.9 | 6773.8 | 6859.9 | 179527.0 |
| 2008-09-26 | FESX | Futures | 1838.9 | 1854.6 | 1814.6 | 1841.2 | 1563629.0 |
| 2008-09-26 | FEU3 | Futures | 93.973 | 94.152 | 93.973 | 94.097 | 2471.0 |
| 2008-09-26 | FGBL | Futures | 85.46 | 85.82 | 85.4 | 85.63 | 624822.0 |
| 2008-09-26 | FGBM | Futures | 91.61 | 92.01 | 91.53 | 91.85 | 499296.0 |
| 2008-09-26 | FGBS | Futures | 100.082 | 100.361 | 100.005 | 100.25 | 592877.0 |
| 2008-09-26 | FGBX | Futures | 75.95 | 75.95 | 74.74 | 75.13 | 2221.0 |
| 2008-09-26 | FTDX | Futures | 660.9 | 664.4 | 644.8 | 654.6 | 583.0 |
| 2008-09-26 | FTI | Futures | 281.66 | 282.39 | 272.2 | 274.67 | 36645.0 |
| 2008-09-26 | FTUK | Futures | 3353.9 | 3362.0 | 3299.1 | 3338.0 | 124034.0 |
| 2008-09-26 | G | Futures | 68.84 | 69.24 | 68.84 | 69.08 | 60335.0 |
| 2008-09-26 | GF | Futures | 287.317 | 288.056 | 283.218 | 284.361 | 212.0 |
| 2008-09-26 | GSCI | Futures | 1637.76 | 1644.76 | 1620.02 | 1644.76 | 58.0 |
| 2008-09-26 | HE | Futures | 143.754 | 145.004 | 141.58 | 143.591 | 4266.0 |
| 2008-09-26 | HG | Futures | 4.3905 | 4.3926 | 4.2624 | 4.3037 | 9049.0 |
| 2008-09-26 | HO | Futures | 3.4909 | 3.4909 | 3.3896 | 3.4561 | 9415.0 |
| 2008-09-26 | J1 | Futures | 0.0119503 | 0.0121259 | 0.0119503 | 0.0120046 | 110211.0 |
| 2008-09-26 | J7 | Futures | 0.011795 | 0.011919 | 0.011793 | 0.011822 | 47.0 |
| 2008-09-26 | JB | Futures | 114.39 | 114.52 | 113.99 | 114.19 | 1736.0 |
| 2008-09-26 | KC | Futures | 405.89 | 406.04 | 391.88 | 395.71 | 22305.0 |
| 2008-09-26 | KE | Futures | 3928.66 | 3935.1 | 3841.01 | 3844.88 | 6356.0 |
| 2008-09-26 | L | Futures | 93.111 | 93.299 | 93.111 | 93.264 | 84397.0 |
| 2008-09-26 | LE | Futures | 188.847 | 189.03 | 187.517 | 188.48 | 3763.0 |
| 2008-09-26 | MP | Futures | 0.04509 | 0.04509 | 0.04465 | 0.04481 | 10006.0 |
| 2008-09-26 | N6 | Futures | 0.53018 | 0.53692 | 0.52862 | 0.5312 | 1677.0 |
> showing 50 of 83 rows — these rows as CSV