PREVIEW / futures_daily / 2010-03-31
file: by_date/futures_daily/2010/2010-03-31.parquet size: 9 KB rows: 90
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-03-31 | ES | Futures | 1138.36 | 1139.82 | 1130.81 | 1134.7 | 2109287.0 |
| 2010-03-31 | NQ | Futures | 2228.59 | 2232.0 | 2214.98 | 2218.67 | 232540.0 |
| 2010-03-31 | YM | Futures | 9975.9 | 9977.7 | 9901.4 | 9925.3 | 116772.0 |
| 2010-03-31 | CL | Futures | 193.03 | 196.19 | 192.37 | 195.97 | 371961.0 |
| 2010-03-31 | GC | Futures | 1516.2 | 1536.5 | 1513.5 | 1529.1 | 108481.0 |
| 2010-03-31 | ZN | Futures | 94.670232 | 94.989073 | 94.59371 | 94.887044 | 1014099.0 |
| 2010-03-31 | A6 | Futures | 0.74808 | 0.74947 | 0.74323 | 0.74643 | 95772.0 |
| 2010-03-31 | AD | Futures | 0.96791 | 0.97452 | 0.96771 | 0.97245 | 82354.0 |
| 2010-03-31 | B | Futures | 72.32 | 74.44 | 72.32 | 74.33 | 90534.0 |
| 2010-03-31 | B6 | Futures | 1.5638 | 1.578 | 1.5612 | 1.5754 | 124487.0 |
| 2010-03-31 | BFX | Futures | 2980.5 | 2996.2 | 2967.0 | 2977.6 | 273.0 |
| 2010-03-31 | BR | Futures | 0.22605 | 0.22615 | 0.22605 | 0.22615 | 161.0 |
| 2010-03-31 | C | Futures | 2274.0 | 2279.0 | 2242.0 | 2266.0 | 5705.0 |
| 2010-03-31 | CB | Futures | 74.518 | 74.518 | 74.271 | 74.271 | 19.0 |
| 2010-03-31 | CC | Futures | 2506.0 | 2532.0 | 2447.0 | 2513.0 | 8295.0 |
| 2010-03-31 | CT | Futures | 64.73 | 66.46 | 64.65 | 65.5 | 15931.0 |
| 2010-03-31 | DC | Futures | 23.22 | 23.35 | 22.77 | 22.92 | 302.0 |
| 2010-03-31 | DX | Futures | 82.761 | 83.035 | 82.179 | 82.377 | 33572.0 |
| 2010-03-31 | E1 | Futures | 1.23525 | 1.25565 | 1.23248 | 1.24946 | 63108.0 |
| 2010-03-31 | E6 | Futures | 1.58769 | 1.60283 | 1.58343 | 1.59822 | 375318.0 |
| 2010-03-31 | E7 | Futures | 1.5744 | 1.5897 | 1.5706 | 1.5851 | 4364.0 |
| 2010-03-31 | EBM | Futures | 207.68 | 208.91 | 205.22 | 205.63 | 4627.0 |
| 2010-03-31 | ED | Futures | 94.385 | 94.3992 | 94.3755 | 94.3944 | 162262.0 |
| 2010-03-31 | ER | Futures | 97.394 | 97.404 | 97.384 | 97.399 | 211403.0 |
| 2010-03-31 | EW | Futures | 772.2 | 774.8 | 765.2 | 767.8 | 30767.0 |
| 2010-03-31 | FBTP | Futures | 64.84 | 64.94 | 64.79 | 64.91 | 3554.0 |
| 2010-03-31 | FCE | Futures | 2553.1 | 2559.2 | 2522.7 | 2540.9 | 113431.0 |
| 2010-03-31 | FDAX | Futures | 6698.1 | 6716.1 | 6651.3 | 6680.2 | 125102.0 |
| 2010-03-31 | FESX | Futures | 1759.4 | 1761.9 | 1737.4 | 1745.9 | 1143625.0 |
| 2010-03-31 | FEU3 | Futures | 97.953 | 97.958 | 97.948 | 97.958 | 1560.0 |
| 2010-03-31 | FGBL | Futures | 96.19 | 96.4 | 96.13 | 96.26 | 837461.0 |
| 2010-03-31 | FGBM | Futures | 101.81 | 101.97 | 101.78 | 101.87 | 523833.0 |
| 2010-03-31 | FGBS | Futures | 106.4 | 106.449 | 106.375 | 106.39 | 590810.0 |
| 2010-03-31 | FGBX | Futures | 91.22 | 91.78 | 91.22 | 91.48 | 4188.0 |
| 2010-03-31 | FTDX | Futures | 712.8 | 723.4 | 712.8 | 719.9 | 468.0 |
| 2010-03-31 | FTI | Futures | 277.61 | 279.15 | 276.23 | 277.73 | 29215.0 |
| 2010-03-31 | FTUK | Futures | 3801.8 | 3825.2 | 3788.3 | 3796.8 | 119221.0 |
| 2010-03-31 | G | Futures | 76.13 | 76.57 | 76.13 | 76.41 | 117359.0 |
| 2010-03-31 | GF | Futures | 284.361 | 288.862 | 283.513 | 288.144 | 882.0 |
| 2010-03-31 | GSCI | Futures | 976.24 | 980.57 | 967.04 | 975.32 | 3424.0 |
| 2010-03-31 | HE | Futures | 98.616 | 99.257 | 97.64 | 98.403 | 544.0 |
| 2010-03-31 | HG | Futures | 4.8488 | 4.8823 | 4.8112 | 4.855 | 30979.0 |
| 2010-03-31 | HO | Futures | 1.9561 | 1.9991 | 1.9524 | 1.9967 | 19165.0 |
| 2010-03-31 | HRC | Futures | 3221.8 | 3221.8 | 3221.8 | 3221.8 | 0.0 |
| 2010-03-31 | J1 | Futures | 0.0135512 | 0.0135613 | 0.0134318 | 0.0134569 | 151553.0 |
| 2010-03-31 | J7 | Futures | 0.013446 | 0.013447 | 0.013327 | 0.01335 | 226.0 |
| 2010-03-31 | JB | Futures | 117.53 | 117.6 | 117.33 | 117.37 | 1313.0 |
| 2010-03-31 | KC | Futures | 356.99 | 357.12 | 345.95 | 349.67 | 17796.0 |
| 2010-03-31 | KE | Futures | 2121.47 | 2133.66 | 2045.03 | 2046.14 | 14849.0 |
| 2010-03-31 | L | Futures | 97.878 | 97.878 | 97.868 | 97.868 | 22664.0 |
> showing 50 of 90 rows — these rows as CSV