PREVIEW / futures_daily / 2009-03-05
file: by_date/futures_daily/2009/2009-03-05.parquet size: 8 KB rows: 86
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-03-05 | ES | Futures | 669.97 | 672.1 | 638.58 | 647.78 | 3338389.0 |
| 2009-03-05 | NQ | Futures | 1254.66 | 1254.66 | 1198.48 | 1210.78 | 426158.0 |
| 2009-03-05 | YM | Futures | 6086.7 | 6109.0 | 5817.8 | 5904.2 | 250150.0 |
| 2009-03-05 | CL | Futures | 127.87 | 128.66 | 120.66 | 122.77 | 306347.0 |
| 2009-03-05 | GC | Futures | 1258.4 | 1301.0 | 1257.6 | 1287.5 | 107514.0 |
| 2009-03-05 | ZN | Futures | 93.471226 | 94.642605 | 93.279981 | 94.439406 | 50719.0 |
| 2009-03-05 | A6 | Futures | 0.51353 | 0.51401 | 0.50378 | 0.50457 | 38555.0 |
| 2009-03-05 | AD | Futures | 0.77108 | 0.77167 | 0.76067 | 0.76135 | 39042.0 |
| 2009-03-05 | B | Futures | 46.17 | 46.28 | 43.06 | 43.83 | 96536.0 |
| 2009-03-05 | B6 | Futures | 1.4739 | 1.479 | 1.4584 | 1.4662 | 71422.0 |
| 2009-03-05 | BFX | Futures | 1751.5 | 1751.5 | 1709.4 | 1710.3 | 137.0 |
| 2009-03-05 | BZ | Futures | 46.91 | 46.91 | 44.97 | 45.72 | 13.0 |
| 2009-03-05 | C | Futures | 1818.0 | 1836.0 | 1812.0 | 1814.0 | 2761.0 |
| 2009-03-05 | CB | Futures | 77.038 | 77.339 | 77.038 | 77.188 | 7.0 |
| 2009-03-05 | CC | Futures | 2041.0 | 2057.0 | 1980.0 | 1993.0 | 5812.0 |
| 2009-03-05 | CT | Futures | 39.76 | 40.18 | 38.84 | 39.04 | 7877.0 |
| 2009-03-05 | DC | Futures | 27.31 | 27.72 | 27.31 | 27.4 | 137.0 |
| 2009-03-05 | DX | Futures | 92.1 | 92.909 | 92.048 | 92.494 | 4400.0 |
| 2009-03-05 | E1 | Futures | 1.13829 | 1.13896 | 1.12553 | 1.13523 | 32748.0 |
| 2009-03-05 | E6 | Futures | 1.49728 | 1.49823 | 1.47514 | 1.48497 | 197584.0 |
| 2009-03-05 | E7 | Futures | 1.481 | 1.481 | 1.46 | 1.468 | 1605.0 |
| 2009-03-05 | EBM | Futures | 210.53 | 212.08 | 208.21 | 210.14 | 2447.0 |
| 2009-03-05 | ED | Futures | 92.9636 | 92.973 | 92.9235 | 92.9424 | 169613.0 |
| 2009-03-05 | ER | Futures | 96.498 | 96.518 | 96.439 | 96.454 | 228699.0 |
| 2009-03-05 | EW | Futures | 419.4 | 421.0 | 398.9 | 404.6 | 33912.0 |
| 2009-03-05 | FCE | Futures | 1644.6 | 1661.1 | 1581.6 | 1601.9 | 149959.0 |
| 2009-03-05 | FDAX | Futures | 4184.9 | 4218.2 | 3991.7 | 4044.6 | 209366.0 |
| 2009-03-05 | FESX | Futures | 1097.4 | 1107.1 | 1048.5 | 1065.2 | 1769575.0 |
| 2009-03-05 | FEU3 | Futures | 97.076 | 97.081 | 97.017 | 97.027 | 576.0 |
| 2009-03-05 | FGBL | Futures | 93.02 | 94.08 | 92.84 | 93.7 | 1106605.0 |
| 2009-03-05 | FGBM | Futures | 98.36 | 98.92 | 98.26 | 98.57 | 594131.0 |
| 2009-03-05 | FGBS | Futures | 104.083 | 104.237 | 104.021 | 104.021 | 770373.0 |
| 2009-03-05 | FGBX | Futures | 83.76 | 85.63 | 83.35 | 84.78 | 9093.0 |
| 2009-03-05 | FTDX | Futures | 392.0 | 392.9 | 370.5 | 375.9 | 645.0 |
| 2009-03-05 | FTI | Futures | 170.56 | 171.45 | 161.19 | 163.19 | 43307.0 |
| 2009-03-05 | FTUK | Futures | 2362.7 | 2368.6 | 2266.0 | 2306.3 | 133895.0 |
| 2009-03-05 | G | Futures | 75.39 | 78.02 | 75.35 | 77.12 | 150463.0 |
| 2009-03-05 | GF | Futures | 260.907 | 260.977 | 257.681 | 258.662 | 384.0 |
| 2009-03-05 | GSCI | Futures | 723.39 | 731.7 | 709.82 | 716.39 | 321.0 |
| 2009-03-05 | HE | Futures | 119.997 | 121.108 | 119.078 | 120.673 | 6210.0 |
| 2009-03-05 | HG | Futures | 2.4162 | 2.4232 | 2.302 | 2.3295 | 10293.0 |
| 2009-03-05 | HO | Futures | 1.3236 | 1.3569 | 1.2841 | 1.3101 | 10093.0 |
| 2009-03-05 | HRC | Futures | 2959.0 | 2959.0 | 2959.0 | 2959.0 | 0.0 |
| 2009-03-05 | J1 | Futures | 0.0127462 | 0.0129294 | 0.0126717 | 0.0128549 | 98293.0 |
| 2009-03-05 | J7 | Futures | 0.01261 | 0.012771 | 0.012529 | 0.0127 | 140.0 |
| 2009-03-05 | JB | Futures | 116.1 | 116.17 | 115.78 | 116.12 | 2019.0 |
| 2009-03-05 | KC | Futures | 305.91 | 306.33 | 300.57 | 305.77 | 7401.0 |
| 2009-03-05 | KE | Futures | 2792.86 | 2810.12 | 2741.1 | 2760.82 | 5169.0 |
| 2009-03-05 | L | Futures | 96.581 | 96.659 | 96.325 | 96.541 | 113829.0 |
| 2009-03-05 | LBS | Futures | 877.8 | 877.8 | 835.8 | 841.4 | 154.0 |
> showing 50 of 86 rows — these rows as CSV