PREVIEW / futures_daily / 2009-10-13
file: by_date/futures_daily/2009/2009-10-13.parquet size: 8 KB rows: 85
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-13 | ES | Futures | 1033.02 | 1036.15 | 1025.3 | 1030.85 | 1519381.0 |
| 2009-10-13 | NQ | Futures | 1950.64 | 1959.39 | 1941.89 | 1949.23 | 218745.0 |
| 2009-10-13 | YM | Futures | 8914.3 | 8940.7 | 8859.9 | 8905.3 | 114151.0 |
| 2009-10-13 | CL | Futures | 181.2 | 184.62 | 180.36 | 183.63 | 361151.0 |
| 2009-10-13 | GC | Futures | 1458.5 | 1478.8 | 1454.6 | 1472.3 | 141180.0 |
| 2009-10-13 | ZN | Futures | 94.525868 | 94.87458 | 94.43869 | 94.774948 | 698467.0 |
| 2009-10-13 | A6 | Futures | 0.72886 | 0.73354 | 0.72578 | 0.72692 | 85631.0 |
| 2009-10-13 | AD | Futures | 0.95307 | 0.96047 | 0.95041 | 0.95219 | 67175.0 |
| 2009-10-13 | B | Futures | 67.0 | 68.53 | 66.73 | 68.09 | 142575.0 |
| 2009-10-13 | B6 | Futures | 1.6439 | 1.6569 | 1.6338 | 1.6531 | 132274.0 |
| 2009-10-13 | BFX | Futures | 2892.9 | 2892.9 | 2862.2 | 2869.5 | 2955.0 |
| 2009-10-13 | BR | Futures | 0.22889 | 0.22889 | 0.22778 | 0.22778 | 7.0 |
| 2009-10-13 | BZ | Futures | 70.6 | 71.41 | 70.6 | 71.41 | 2.0 |
| 2009-10-13 | C | Futures | 2161.0 | 2201.0 | 2146.0 | 2151.0 | 3836.0 |
| 2009-10-13 | CB | Futures | 71.811 | 71.811 | 71.811 | 71.811 | 1.0 |
| 2009-10-13 | CC | Futures | 2712.0 | 2775.0 | 2707.0 | 2717.0 | 6863.0 |
| 2009-10-13 | CT | Futures | 55.75 | 56.91 | 55.24 | 56.85 | 12836.0 |
| 2009-10-13 | DC | Futures | 25.28 | 25.51 | 24.85 | 24.93 | 367.0 |
| 2009-10-13 | DX | Futures | 77.868 | 78.072 | 77.511 | 77.761 | 8231.0 |
| 2009-10-13 | E1 | Futures | 1.28709 | 1.29633 | 1.28563 | 1.29078 | 39351.0 |
| 2009-10-13 | E6 | Futures | 1.75081 | 1.76278 | 1.74904 | 1.75638 | 247927.0 |
| 2009-10-13 | E7 | Futures | 1.7344 | 1.7458 | 1.7323 | 1.7396 | 4418.0 |
| 2009-10-13 | ED | Futures | 94.1812 | 94.2001 | 94.1765 | 94.1907 | 127084.0 |
| 2009-10-13 | ER | Futures | 97.061 | 97.091 | 97.056 | 97.081 | 115858.0 |
| 2009-10-13 | EW | Futures | 678.4 | 681.1 | 672.1 | 675.5 | 32318.0 |
| 2009-10-13 | FCE | Futures | 2527.7 | 2532.6 | 2495.3 | 2502.2 | 116971.0 |
| 2009-10-13 | FDAX | Futures | 6281.0 | 6301.7 | 6198.9 | 6225.5 | 147502.0 |
| 2009-10-13 | FESX | Futures | 1728.0 | 1733.4 | 1705.3 | 1713.1 | 1110600.0 |
| 2009-10-13 | FGBL | Futures | 94.22 | 94.48 | 94.16 | 94.44 | 661314.0 |
| 2009-10-13 | FGBM | Futures | 99.2 | 99.44 | 99.14 | 99.42 | 426983.0 |
| 2009-10-13 | FGBS | Futures | 104.6 | 104.702 | 104.566 | 104.697 | 414281.0 |
| 2009-10-13 | FTI | Futures | 260.94 | 262.54 | 259.8 | 260.37 | 28229.0 |
| 2009-10-13 | FTUK | Futures | 3439.4 | 3444.1 | 3396.6 | 3408.2 | 119830.0 |
| 2009-10-13 | G | Futures | 78.15 | 78.35 | 77.99 | 78.15 | 109018.0 |
| 2009-10-13 | GF | Futures | 258.825 | 259.375 | 255.867 | 256.211 | 2935.0 |
| 2009-10-13 | GSCI | Futures | 963.79 | 964.18 | 950.41 | 963.2 | 5594.0 |
| 2009-10-13 | HE | Futures | 82.623 | 82.813 | 80.298 | 81.822 | 14323.0 |
| 2009-10-13 | HG | Futures | 3.9646 | 4.021 | 3.8405 | 3.8942 | 22215.0 |
| 2009-10-13 | HO | Futures | 1.8553 | 1.8947 | 1.8541 | 1.89 | 25927.0 |
| 2009-10-13 | HRC | Futures | 2738.7 | 2738.7 | 2738.7 | 2738.7 | 10.0 |
| 2009-10-13 | J1 | Futures | 0.0139882 | 0.014046 | 0.0139279 | 0.0139882 | 97970.0 |
| 2009-10-13 | J7 | Futures | 0.01379 | 0.013864 | 0.013747 | 0.013806 | 74.0 |
| 2009-10-13 | JB | Futures | 117.23 | 117.47 | 117.21 | 117.43 | 1090.0 |
| 2009-10-13 | KC | Futures | 364.67 | 368.9 | 358.47 | 365.47 | 9118.0 |
| 2009-10-13 | KE | Futures | 2368.4 | 2452.15 | 2342.81 | 2442.85 | 15830.0 |
| 2009-10-13 | L | Futures | 97.779 | 97.799 | 97.77 | 97.779 | 17935.0 |
| 2009-10-13 | LBS | Futures | 690.4 | 698.6 | 686.8 | 693.3 | 1813.0 |
| 2009-10-13 | LE | Futures | 142.963 | 143.13 | 140.954 | 141.749 | 14127.0 |
| 2009-10-13 | MFS | Futures | 1260.8 | 1261.8 | 1251.3 | 1258.7 | 348.0 |
| 2009-10-13 | MME | Futures | 804.5 | 806.2 | 796.5 | 805.2 | 363.0 |
> showing 50 of 85 rows — these rows as CSV