PREVIEW / futures_daily / 2009-11-20
file: by_date/futures_daily/2009/2009-11-20.parquet size: 9 KB rows: 88
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-11-20 | ES | Futures | 1055.2 | 1056.16 | 1045.07 | 1051.34 | 1451811.0 |
| 2009-11-20 | NQ | Futures | 1998.61 | 2002.56 | 1981.12 | 1990.71 | 225734.0 |
| 2009-11-20 | YM | Futures | 9374.6 | 9380.1 | 9292.9 | 9353.7 | 102314.0 |
| 2009-11-20 | CL | Futures | 190.82 | 191.3 | 186.8 | 188.53 | 263044.0 |
| 2009-11-20 | GC | Futures | 1582.9 | 1591.9 | 1565.6 | 1585.4 | 173738.0 |
| 2009-11-20 | ZN | Futures | 95.43501 | 95.634274 | 95.210838 | 95.298016 | 812742.0 |
| 2009-11-20 | A6 | Futures | 0.74146 | 0.74316 | 0.73063 | 0.7371 | 93633.0 |
| 2009-11-20 | AD | Futures | 0.92764 | 0.92882 | 0.91866 | 0.92034 | 70150.0 |
| 2009-11-20 | B | Futures | 72.39 | 72.6 | 71.07 | 71.72 | 124126.0 |
| 2009-11-20 | B6 | Futures | 1.7327 | 1.735 | 1.7123 | 1.7147 | 114426.0 |
| 2009-11-20 | BFX | Futures | 2814.0 | 2828.1 | 2798.0 | 2802.8 | 338.0 |
| 2009-11-20 | BR | Futures | 0.22857 | 0.22857 | 0.22857 | 0.22857 | 6.0 |
| 2009-11-20 | C | Futures | 2151.0 | 2251.0 | 2150.0 | 2229.0 | 5880.0 |
| 2009-11-20 | CB | Futures | 81.224 | 81.345 | 80.686 | 80.686 | 14.0 |
| 2009-11-20 | CC | Futures | 2784.0 | 2851.0 | 2728.0 | 2834.0 | 8792.0 |
| 2009-11-20 | CT | Futures | 59.54 | 61.2 | 59.5 | 60.76 | 6815.0 |
| 2009-11-20 | DC | Futures | 24.34 | 25.19 | 24.2 | 25.14 | 296.0 |
| 2009-11-20 | DX | Futures | 76.955 | 78.103 | 76.863 | 77.317 | 18011.0 |
| 2009-11-20 | E1 | Futures | 1.3036 | 1.30518 | 1.2921 | 1.29752 | 55876.0 |
| 2009-11-20 | E6 | Futures | 1.76741 | 1.76989 | 1.7539 | 1.76053 | 269615.0 |
| 2009-11-20 | E7 | Futures | 1.7509 | 1.7529 | 1.737 | 1.7437 | 3452.0 |
| 2009-11-20 | ED | Futures | 94.2805 | 94.2876 | 94.2781 | 94.2805 | 96132.0 |
| 2009-11-20 | ER | Futures | 97.164 | 97.174 | 97.154 | 97.164 | 92392.0 |
| 2009-11-20 | EW | Futures | 670.8 | 671.2 | 662.1 | 665.7 | 23836.0 |
| 2009-11-20 | FBTP | Futures | 62.92 | 62.92 | 62.69 | 62.88 | 5460.0 |
| 2009-11-20 | FCE | Futures | 2507.2 | 2512.1 | 2461.7 | 2473.0 | 115373.0 |
| 2009-11-20 | FDAX | Futures | 6240.8 | 6252.2 | 6133.6 | 6162.4 | 142591.0 |
| 2009-11-20 | FESX | Futures | 1717.3 | 1719.0 | 1684.4 | 1690.4 | 1155318.0 |
| 2009-11-20 | FEU3 | Futures | 97.741 | 97.741 | 97.736 | 97.736 | 124.0 |
| 2009-11-20 | FGBL | Futures | 94.39 | 94.55 | 94.18 | 94.45 | 680045.0 |
| 2009-11-20 | FGBM | Futures | 99.74 | 99.79 | 99.51 | 99.64 | 399867.0 |
| 2009-11-20 | FGBS | Futures | 105.069 | 105.098 | 104.958 | 104.982 | 607355.0 |
| 2009-11-20 | FGBX | Futures | 88.33 | 88.49 | 87.69 | 88.29 | 6031.0 |
| 2009-11-20 | FTDX | Futures | 680.3 | 687.4 | 672.3 | 677.2 | 396.0 |
| 2009-11-20 | FTI | Futures | 257.1 | 257.91 | 252.56 | 253.22 | 33300.0 |
| 2009-11-20 | FTUK | Futures | 3506.7 | 3521.7 | 3463.0 | 3487.2 | 100117.0 |
| 2009-11-20 | G | Futures | 77.02 | 77.21 | 76.89 | 77.11 | 50719.0 |
| 2009-11-20 | GF | Futures | 249.338 | 251.847 | 249.202 | 251.372 | 1666.0 |
| 2009-11-20 | GSCI | Futures | 979.84 | 985.84 | 974.82 | 983.13 | 79.0 |
| 2009-11-20 | HE | Futures | 84.97 | 86.978 | 84.736 | 86.141 | 8871.0 |
| 2009-11-20 | HG | Futures | 4.2987 | 4.3525 | 4.2455 | 4.3235 | 10835.0 |
| 2009-11-20 | HO | Futures | 1.9177 | 1.9376 | 1.9084 | 1.923 | 5614.0 |
| 2009-11-20 | HRC | Futures | 2637.0 | 2637.0 | 2637.0 | 2637.0 | 0.0 |
| 2009-11-20 | J1 | Futures | 0.0141176 | 0.0141602 | 0.0140874 | 0.0141163 | 68712.0 |
| 2009-11-20 | J7 | Futures | 0.013948 | 0.013975 | 0.013909 | 0.013932 | 31.0 |
| 2009-11-20 | JB | Futures | 117.5 | 117.75 | 117.41 | 117.41 | 3192.0 |
| 2009-11-20 | KC | Futures | 358.55 | 358.94 | 351.01 | 353.35 | 7876.0 |
| 2009-11-20 | KE | Futures | 2609.19 | 2654.56 | 2570.81 | 2590.58 | 7567.0 |
| 2009-11-20 | L | Futures | 97.779 | 97.799 | 97.77 | 97.789 | 32193.0 |
| 2009-11-20 | LBS | Futures | 819.9 | 821.9 | 801.5 | 810.7 | 266.0 |
> showing 50 of 88 rows — these rows as CSV