PREVIEW / futures_daily / 2010-12-08
file: by_date/futures_daily/2010/2010-12-08.parquet size: 9 KB rows: 92
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-08 | ES | Futures | 1198.49 | 1204.86 | 1193.1 | 1204.37 | 2142544.0 |
| 2010-12-08 | NQ | Futures | 2483.51 | 2496.83 | 2471.89 | 2495.13 | 206132.0 |
| 2010-12-08 | YM | Futures | 10562.0 | 10593.7 | 10500.6 | 10577.8 | 110089.0 |
| 2010-12-08 | CL | Futures | 181.42 | 182.74 | 179.33 | 181.28 | 383144.0 |
| 2010-12-08 | GC | Futures | 1904.7 | 1910.3 | 1865.0 | 1880.1 | 218896.0 |
| 2010-12-08 | ZN | Futures | 101.167465 | 101.206461 | 99.932606 | 100.491542 | 1668807.0 |
| 2010-12-08 | A6 | Futures | 0.82401 | 0.82662 | 0.81797 | 0.82192 | 127583.0 |
| 2010-12-08 | AD | Futures | 0.97905 | 0.9844 | 0.97687 | 0.98044 | 94652.0 |
| 2010-12-08 | B | Futures | 77.32 | 78.0 | 76.69 | 77.25 | 116092.0 |
| 2010-12-08 | B6 | Futures | 1.6363 | 1.6441 | 1.6265 | 1.6408 | 112254.0 |
| 2010-12-08 | BFX | Futures | 3026.4 | 3036.7 | 3006.4 | 3022.8 | 159.0 |
| 2010-12-08 | BR | Futures | 0.25228 | 0.25228 | 0.24959 | 0.25039 | 140.0 |
| 2010-12-08 | BZ | Futures | 81.58 | 82.02 | 81.58 | 81.86 | 359.0 |
| 2010-12-08 | C | Futures | 2210.0 | 2221.0 | 2190.0 | 2192.0 | 7285.0 |
| 2010-12-08 | CB | Futures | 97.388 | 97.975 | 97.388 | 97.975 | 20.0 |
| 2010-12-08 | CC | Futures | 2491.0 | 2513.0 | 2460.0 | 2463.0 | 8714.0 |
| 2010-12-08 | CT | Futures | 111.29 | 114.66 | 108.41 | 113.15 | 15452.0 |
| 2010-12-08 | DC | Futures | 22.31 | 22.42 | 22.23 | 22.26 | 131.0 |
| 2010-12-08 | DX | Futures | 80.24 | 80.681 | 80.165 | 80.263 | 36351.0 |
| 2010-12-08 | E1 | Futures | 1.32947 | 1.33328 | 1.32409 | 1.33052 | 48414.0 |
| 2010-12-08 | E6 | Futures | 1.56931 | 1.57085 | 1.5589 | 1.56848 | 371737.0 |
| 2010-12-08 | E7 | Futures | 1.5572 | 1.5588 | 1.5468 | 1.5566 | 4924.0 |
| 2010-12-08 | EBM | Futures | 206.3 | 214.02 | 206.3 | 214.02 | 8736.0 |
| 2010-12-08 | ED | Futures | 94.753 | 94.7553 | 94.7482 | 94.753 | 194132.0 |
| 2010-12-08 | ER | Futures | 97.281 | 97.281 | 97.271 | 97.276 | 113749.0 |
| 2010-12-08 | EW | Futures | 871.9 | 877.2 | 868.0 | 872.8 | 33631.0 |
| 2010-12-08 | FBTP | Futures | 64.31 | 64.68 | 64.31 | 64.53 | 2790.0 |
| 2010-12-08 | FCE | Futures | 2535.1 | 2583.0 | 2529.1 | 2564.6 | 119675.0 |
| 2010-12-08 | FDAX | Futures | 7509.2 | 7544.7 | 7482.8 | 7502.2 | 145132.0 |
| 2010-12-08 | FESX | Futures | 1740.0 | 1771.2 | 1735.0 | 1760.6 | 1092713.0 |
| 2010-12-08 | FEU3 | Futures | 97.845 | 97.845 | 97.84 | 97.84 | 482.0 |
| 2010-12-08 | FGBL | Futures | 98.44 | 99.04 | 98.37 | 98.51 | 847579.0 |
| 2010-12-08 | FGBM | Futures | 104.77 | 104.87 | 104.31 | 104.36 | 601306.0 |
| 2010-12-08 | FGBS | Futures | 107.543 | 107.563 | 107.282 | 107.311 | 667152.0 |
| 2010-12-08 | FGBX | Futures | 96.98 | 97.94 | 96.56 | 97.16 | 6518.0 |
| 2010-12-08 | FTDX | Futures | 714.3 | 724.9 | 713.0 | 724.0 | 792.0 |
| 2010-12-08 | FTI | Futures | 276.81 | 280.43 | 276.41 | 279.03 | 34571.0 |
| 2010-12-08 | FTUK | Futures | 4003.3 | 4028.6 | 3985.4 | 4007.1 | 96099.0 |
| 2010-12-08 | FXXP | Futures | 177.3 | 177.8 | 177.3 | 177.8 | 8249.0 |
| 2010-12-08 | G | Futures | 81.23 | 81.47 | 81.02 | 81.09 | 128024.0 |
| 2010-12-08 | GF | Futures | 292.452 | 294.943 | 291.206 | 294.382 | 2890.0 |
| 2010-12-08 | GSCI | Futures | 985.49 | 990.62 | 976.29 | 990.53 | 3096.0 |
| 2010-12-08 | HE | Futures | 94.529 | 95.595 | 93.808 | 94.906 | 13564.0 |
| 2010-12-08 | HG | Futures | 5.3495 | 5.4888 | 5.3016 | 5.4648 | 44782.0 |
| 2010-12-08 | HO | Futures | 2.0658 | 2.0928 | 2.0537 | 2.0783 | 14720.0 |
| 2010-12-08 | HRC | Futures | 2455.4 | 2455.4 | 2455.4 | 2455.4 | 0.0 |
| 2010-12-08 | J1 | Futures | 0.0150431 | 0.0150506 | 0.0148999 | 0.0149552 | 162596.0 |
| 2010-12-08 | J7 | Futures | 0.014939 | 0.014939 | 0.014799 | 0.014853 | 228.0 |
| 2010-12-08 | KC | Futures | 508.23 | 511.67 | 493.52 | 501.86 | 11742.0 |
| 2010-12-08 | KE | Futures | 3383.03 | 3445.16 | 3339.22 | 3412.57 | 17299.0 |
> showing 50 of 92 rows — these rows as CSV