PREVIEW / futures_daily / 2010-12-02
file: by_date/futures_daily/2010/2010-12-02.parquet size: 9 KB rows: 91
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-02 | ES | Futures | 1180.11 | 1198.98 | 1178.15 | 1198.49 | 2037342.0 |
| 2010-12-02 | NQ | Futures | 2448.07 | 2481.81 | 2445.52 | 2479.82 | 235665.0 |
| 2010-12-02 | YM | Futures | 10452.2 | 10576.0 | 10431.7 | 10573.2 | 113143.0 |
| 2010-12-02 | CL | Futures | 178.24 | 180.97 | 177.15 | 180.7 | 330642.0 |
| 2010-12-02 | GC | Futures | 1886.1 | 1902.6 | 1880.9 | 1888.4 | 134387.0 |
| 2010-12-02 | ZN | Futures | 102.290115 | 102.419155 | 101.799762 | 101.980418 | 133912.0 |
| 2010-12-02 | A6 | Futures | 0.81075 | 0.81999 | 0.80672 | 0.81839 | 111835.0 |
| 2010-12-02 | AD | Futures | 0.97271 | 0.98787 | 0.97202 | 0.98698 | 104978.0 |
| 2010-12-02 | B | Futures | 75.36 | 77.09 | 75.13 | 76.97 | 108192.0 |
| 2010-12-02 | B6 | Futures | 1.6203 | 1.6264 | 1.6102 | 1.6172 | 139426.0 |
| 2010-12-02 | BFX | Futures | 2980.1 | 3024.0 | 2967.6 | 3017.7 | 114.0 |
| 2010-12-02 | BR | Futures | 0.24774 | 0.24905 | 0.24774 | 0.24903 | 81.0 |
| 2010-12-02 | BZ | Futures | 80.18 | 81.57 | 80.07 | 81.57 | 434.0 |
| 2010-12-02 | C | Futures | 2032.0 | 2122.0 | 2018.0 | 2085.0 | 4391.0 |
| 2010-12-02 | CC | Futures | 2233.0 | 2370.0 | 2233.0 | 2327.0 | 14701.0 |
| 2010-12-02 | CSC | Futures | 3.388 | 3.388 | 3.365 | 3.372 | 27.0 |
| 2010-12-02 | CT | Futures | 104.91 | 108.34 | 104.91 | 108.34 | 8861.0 |
| 2010-12-02 | DC | Futures | 23.0 | 23.0 | 22.75 | 22.77 | 87.0 |
| 2010-12-02 | DX | Futures | 81.067 | 81.318 | 80.355 | 80.592 | 36098.0 |
| 2010-12-02 | E1 | Futures | 1.30925 | 1.32789 | 1.3057 | 1.32107 | 51247.0 |
| 2010-12-02 | E6 | Futures | 1.55239 | 1.56694 | 1.5447 | 1.56162 | 486962.0 |
| 2010-12-02 | E7 | Futures | 1.5405 | 1.555 | 1.533 | 1.5498 | 7351.0 |
| 2010-12-02 | ED | Futures | 94.7126 | 94.7363 | 94.7078 | 94.7316 | 259555.0 |
| 2010-12-02 | ER | Futures | 97.271 | 97.296 | 97.262 | 97.276 | 139414.0 |
| 2010-12-02 | EW | Futures | 853.5 | 867.6 | 851.5 | 867.4 | 21399.0 |
| 2010-12-02 | FBTP | Futures | 64.62 | 65.19 | 64.5 | 65.08 | 10114.0 |
| 2010-12-02 | FCE | Futures | 2465.5 | 2517.7 | 2442.4 | 2508.7 | 191677.0 |
| 2010-12-02 | FDAX | Futures | 7395.7 | 7494.1 | 7360.2 | 7483.9 | 220595.0 |
| 2010-12-02 | FESX | Futures | 1705.1 | 1745.0 | 1687.6 | 1738.1 | 2059949.0 |
| 2010-12-02 | FEU3 | Futures | 97.835 | 97.845 | 97.835 | 97.84 | 166.0 |
| 2010-12-02 | FGBL | Futures | 100.36 | 100.44 | 99.85 | 100.01 | 1136110.0 |
| 2010-12-02 | FGBM | Futures | 105.37 | 105.53 | 105.07 | 105.24 | 808108.0 |
| 2010-12-02 | FGBS | Futures | 107.568 | 107.676 | 107.538 | 107.598 | 666994.0 |
| 2010-12-02 | FGBX | Futures | 101.55 | 101.64 | 100.37 | 100.93 | 10840.0 |
| 2010-12-02 | FTDX | Futures | 692.3 | 706.9 | 691.9 | 705.5 | 1488.0 |
| 2010-12-02 | FTI | Futures | 271.46 | 275.32 | 269.45 | 274.8 | 53839.0 |
| 2010-12-02 | FTUK | Futures | 3915.9 | 3998.2 | 3904.5 | 3988.5 | 137347.0 |
| 2010-12-02 | FXXP | Futures | 173.3 | 175.7 | 173.3 | 175.7 | 930.0 |
| 2010-12-02 | G | Futures | 82.03 | 82.2 | 81.8 | 81.91 | 94549.0 |
| 2010-12-02 | GF | Futures | 296.064 | 296.437 | 293.573 | 295.628 | 2210.0 |
| 2010-12-02 | GSCI | Futures | 968.31 | 979.95 | 965.7 | 979.22 | 303.0 |
| 2010-12-02 | HE | Futures | 94.153 | 95.94 | 94.028 | 95.313 | 13218.0 |
| 2010-12-02 | HG | Futures | 5.2696 | 5.3269 | 5.2396 | 5.3029 | 32047.0 |
| 2010-12-02 | HO | Futures | 2.0228 | 2.0648 | 2.0181 | 2.0606 | 14468.0 |
| 2010-12-02 | HRC | Futures | 2391.9 | 2391.9 | 2391.9 | 2391.9 | 0.0 |
| 2010-12-02 | J1 | Futures | 0.0149275 | 0.0150481 | 0.0148886 | 0.0149652 | 133364.0 |
| 2010-12-02 | J7 | Futures | 0.014824 | 0.014944 | 0.014789 | 0.014863 | 297.0 |
| 2010-12-02 | JB | Futures | 120.24 | 120.29 | 119.99 | 120.14 | 3454.0 |
| 2010-12-02 | KC | Futures | 498.18 | 502.35 | 493.89 | 499.53 | 5030.0 |
| 2010-12-02 | KE | Futures | 3243.47 | 3360.61 | 3213.93 | 3266.9 | 20916.0 |
> showing 50 of 91 rows — these rows as CSV