PREVIEW / futures_daily / 2009-01-12
file: by_date/futures_daily/2009/2009-01-12.parquet size: 8 KB rows: 84
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-01-12 | ES | Futures | 835.7 | 836.17 | 812.32 | 819.64 | 1654564.0 |
| 2009-01-12 | NQ | Futures | 1365.06 | 1370.65 | 1326.21 | 1348.29 | 224799.0 |
| 2009-01-12 | YM | Futures | 7603.9 | 7611.1 | 7452.6 | 7518.5 | 133550.0 |
| 2009-01-12 | CL | Futures | 160.99 | 161.98 | 148.8 | 149.24 | 272828.0 |
| 2009-01-12 | GC | Futures | 1193.6 | 1195.5 | 1136.4 | 1144.7 | 132306.0 |
| 2009-01-12 | ZN | Futures | 96.100851 | 96.662635 | 95.706408 | 96.638729 | 316431.0 |
| 2009-01-12 | A6 | Futures | 0.55263 | 0.55263 | 0.5351 | 0.53772 | 28700.0 |
| 2009-01-12 | AD | Futures | 0.82708 | 0.82747 | 0.8036 | 0.80831 | 29716.0 |
| 2009-01-12 | B | Futures | 48.99 | 48.99 | 46.24 | 46.97 | 121611.0 |
| 2009-01-12 | B6 | Futures | 1.5709 | 1.5721 | 1.5357 | 1.5401 | 56300.0 |
| 2009-01-12 | BFX | Futures | 2180.1 | 2180.1 | 2168.3 | 2168.3 | 101.0 |
| 2009-01-12 | BZ | Futures | 47.48 | 47.82 | 46.54 | 47.16 | 91.0 |
| 2009-01-12 | C | Futures | 1798.0 | 1813.0 | 1717.0 | 1767.0 | 16063.0 |
| 2009-01-12 | CB | Futures | 77.829 | 77.829 | 77.333 | 77.333 | 28.0 |
| 2009-01-12 | CC | Futures | 2281.0 | 2281.0 | 2162.0 | 2211.0 | 14929.0 |
| 2009-01-12 | CT | Futures | 47.86 | 48.65 | 45.34 | 45.43 | 8103.0 |
| 2009-01-12 | DC | Futures | 27.43 | 28.1 | 27.13 | 27.45 | 185.0 |
| 2009-01-12 | DX | Futures | 86.444 | 87.299 | 86.444 | 86.838 | 2562.0 |
| 2009-01-12 | E1 | Futures | 1.19425 | 1.19863 | 1.18255 | 1.19478 | 26849.0 |
| 2009-01-12 | E6 | Futures | 1.5888 | 1.59235 | 1.56938 | 1.58229 | 138495.0 |
| 2009-01-12 | E7 | Futures | 1.5727 | 1.574 | 1.551 | 1.5642 | 2512.0 |
| 2009-01-12 | EBM | Futures | 228.17 | 233.92 | 218.97 | 218.97 | 3989.0 |
| 2009-01-12 | ED | Futures | 93.3591 | 93.4486 | 93.3591 | 93.4298 | 216537.0 |
| 2009-01-12 | ER | Futures | 96.116 | 96.204 | 96.076 | 96.189 | 117062.0 |
| 2009-01-12 | EW | Futures | 513.4 | 518.5 | 497.6 | 502.6 | 28384.0 |
| 2009-01-12 | FCE | Futures | 2035.4 | 2045.6 | 2002.0 | 2010.7 | 40189.0 |
| 2009-01-12 | FDAX | Futures | 5202.5 | 5250.5 | 5102.6 | 5174.1 | 125015.0 |
| 2009-01-12 | FESX | Futures | 1422.5 | 1434.6 | 1392.7 | 1413.3 | 906325.0 |
| 2009-01-12 | FEU3 | Futures | 96.657 | 96.766 | 96.657 | 96.756 | 793.0 |
| 2009-01-12 | FGBL | Futures | 93.11 | 93.53 | 92.93 | 93.47 | 439621.0 |
| 2009-01-12 | FGBM | Futures | 97.73 | 97.95 | 97.56 | 97.93 | 303663.0 |
| 2009-01-12 | FGBS | Futures | 103.532 | 103.589 | 103.407 | 103.58 | 350582.0 |
| 2009-01-12 | FGBX | Futures | 85.7 | 85.7 | 84.97 | 85.31 | 1139.0 |
| 2009-01-12 | FTDX | Futures | 434.9 | 437.6 | 418.8 | 428.7 | 209.0 |
| 2009-01-12 | FTI | Futures | 212.98 | 214.44 | 210.04 | 210.93 | 2149.0 |
| 2009-01-12 | FTUK | Futures | 2888.2 | 2913.1 | 2840.7 | 2886.2 | 92103.0 |
| 2009-01-12 | G | Futures | 76.56 | 76.65 | 76.25 | 76.58 | 64665.0 |
| 2009-01-12 | GF | Futures | 260.135 | 264.063 | 259.855 | 261.819 | 367.0 |
| 2009-01-12 | GSCI | Futures | 818.75 | 821.33 | 809.14 | 809.14 | 56.0 |
| 2009-01-12 | HE | Futures | 120.528 | 121.205 | 118.595 | 118.837 | 7371.0 |
| 2009-01-12 | HG | Futures | 2.1809 | 2.2463 | 2.0479 | 2.095 | 14423.0 |
| 2009-01-12 | HO | Futures | 1.6626 | 1.6822 | 1.6077 | 1.6388 | 18724.0 |
| 2009-01-12 | HRC | Futures | 3130.5 | 3130.5 | 3130.5 | 3130.5 | 0.0 |
| 2009-01-12 | J1 | Futures | 0.0140144 | 0.0142216 | 0.0139967 | 0.0141912 | 69429.0 |
| 2009-01-12 | J7 | Futures | 0.013865 | 0.014046 | 0.013836 | 0.014021 | 87.0 |
| 2009-01-12 | KC | Futures | 333.68 | 339.68 | 326.67 | 327.24 | 8213.0 |
| 2009-01-12 | KE | Futures | 3247.73 | 3282.7 | 2952.93 | 2972.92 | 9059.0 |
| 2009-01-12 | L | Futures | 96.965 | 97.063 | 96.95 | 97.053 | 64739.0 |
| 2009-01-12 | LBS | Futures | 1015.3 | 1018.1 | 971.5 | 978.8 | 71.0 |
| 2009-01-12 | LE | Futures | 148.353 | 149.606 | 147.638 | 148.309 | 7349.0 |
> showing 50 of 84 rows — these rows as CSV