PREVIEW / futures_daily / 2011-12-02
file: by_date/futures_daily/2011/2011-12-02.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-02 | ES | Futures | 1241.32 | 1260.54 | 1239.82 | 1241.32 | 2179603.0 |
| 2011-12-02 | NQ | Futures | 2635.91 | 2676.43 | 2626.21 | 2629.06 | 201365.0 |
| 2011-12-02 | YM | Futures | 11528.9 | 11698.9 | 11520.2 | 11527.9 | 105275.0 |
| 2011-12-02 | CL | Futures | 187.47 | 190.39 | 187.02 | 189.27 | 245915.0 |
| 2011-12-02 | GC | Futures | 2360.7 | 2385.9 | 2351.6 | 2364.5 | 107014.0 |
| 2011-12-02 | ZN | Futures | 111.643457 | 112.072494 | 111.107161 | 111.978643 | 94385.0 |
| 2011-12-02 | A6 | Futures | 0.89714 | 0.90656 | 0.89512 | 0.8982 | 114665.0 |
| 2011-12-02 | AD | Futures | 0.98635 | 0.99225 | 0.98074 | 0.98254 | 80187.0 |
| 2011-12-02 | B | Futures | 96.98 | 98.09 | 96.56 | 97.75 | 87272.0 |
| 2011-12-02 | B6 | Futures | 1.6372 | 1.6414 | 1.6254 | 1.6274 | 83475.0 |
| 2011-12-02 | BFX | Futures | 2482.4 | 2487.4 | 2469.4 | 2471.5 | 12.0 |
| 2011-12-02 | BR | Futures | 0.25619 | 0.25619 | 0.25619 | 0.25619 | 609.0 |
| 2011-12-02 | BZ | Futures | 104.04 | 104.04 | 102.6 | 103.73 | 397.0 |
| 2011-12-02 | C | Futures | 1515.0 | 1527.0 | 1481.0 | 1484.0 | 2533.0 |
| 2011-12-02 | CB | Futures | 88.539 | 89.346 | 88.404 | 88.404 | 58.0 |
| 2011-12-02 | CC | Futures | 1779.0 | 1792.0 | 1720.0 | 1727.0 | 11988.0 |
| 2011-12-02 | CSC | Futures | 3.976 | 3.988 | 3.976 | 3.988 | 7.0 |
| 2011-12-02 | CT | Futures | 117.51 | 118.84 | 117.1 | 118.29 | 4296.0 |
| 2011-12-02 | DC | Futures | 28.61 | 28.81 | 28.58 | 28.78 | 108.0 |
| 2011-12-02 | DX | Futures | 76.863 | 77.447 | 76.633 | 77.291 | 20883.0 |
| 2011-12-02 | E1 | Futures | 1.4326 | 1.4406 | 1.41987 | 1.42486 | 18697.0 |
| 2011-12-02 | E6 | Futures | 1.60875 | 1.61951 | 1.59704 | 1.60206 | 281905.0 |
| 2011-12-02 | E7 | Futures | 1.5951 | 1.606 | 1.5835 | 1.5884 | 4679.0 |
| 2011-12-02 | ED | Futures | 94.965 | 94.9698 | 94.9387 | 94.9507 | 227765.0 |
| 2011-12-02 | ER | Futures | 97.356 | 97.371 | 97.292 | 97.297 | 200697.0 |
| 2011-12-02 | EW | Futures | 882.2 | 897.4 | 880.9 | 882.8 | 22973.0 |
| 2011-12-02 | FBTP | Futures | 57.96 | 58.85 | 57.56 | 57.66 | 11858.0 |
| 2011-12-02 | FBTS | Futures | 78.468 | 79.752 | 78.131 | 78.179 | 1562.0 |
| 2011-12-02 | FCE | Futures | 2255.3 | 2287.1 | 2214.6 | 2259.9 | 81379.0 |
| 2011-12-02 | FDAX | Futures | 6612.6 | 6704.9 | 6565.4 | 6599.6 | 148634.0 |
| 2011-12-02 | FESX | Futures | 1549.1 | 1579.0 | 1547.8 | 1555.7 | 1171722.0 |
| 2011-12-02 | FEU3 | Futures | 97.915 | 97.915 | 97.856 | 97.856 | 290.0 |
| 2011-12-02 | FGBL | Futures | 109.14 | 109.73 | 108.84 | 109.64 | 717736.0 |
| 2011-12-02 | FGBM | Futures | 111.69 | 111.77 | 111.37 | 111.72 | 404199.0 |
| 2011-12-02 | FGBS | Futures | 109.63 | 109.65 | 109.551 | 109.611 | 511123.0 |
| 2011-12-02 | FGBX | Futures | 109.49 | 110.91 | 109.32 | 110.68 | 9844.0 |
| 2011-12-02 | FTDX | Futures | 646.3 | 646.8 | 638.0 | 640.8 | 108.0 |
| 2011-12-02 | FTI | Futures | 251.52 | 255.47 | 251.06 | 252.7 | 37134.0 |
| 2011-12-02 | FTUK | Futures | 3950.9 | 4018.0 | 3949.4 | 3983.5 | 104971.0 |
| 2011-12-02 | FVSA | Futures | 14652.46 | 14652.46 | 14224.02 | 14588.19 | 1818.0 |
| 2011-12-02 | FXXP | Futures | 168.3 | 169.1 | 167.3 | 167.6 | 1976.0 |
| 2011-12-02 | G | Futures | 92.33 | 92.67 | 91.85 | 92.3 | 98547.0 |
| 2011-12-02 | GF | Futures | 314.764 | 317.457 | 314.764 | 316.811 | 2595.0 |
| 2011-12-02 | GSCI | Futures | 1019.44 | 1023.78 | 1014.09 | 1020.84 | 108.0 |
| 2011-12-02 | HE | Futures | 111.537 | 111.938 | 109.842 | 109.996 | 15095.0 |
| 2011-12-02 | HG | Futures | 4.6706 | 4.7926 | 4.6528 | 4.7279 | 39535.0 |
| 2011-12-02 | HO | Futures | 2.4252 | 2.4494 | 2.409 | 2.4265 | 15073.0 |
| 2011-12-02 | HRC | Futures | 2867.9 | 2867.9 | 2867.9 | 2867.9 | 0.0 |
| 2011-12-02 | J1 | Futures | 0.0161715 | 0.0161715 | 0.0160936 | 0.0160999 | 63697.0 |
| 2011-12-02 | J7 | Futures | 0.01606 | 0.016068 | 0.016 | 0.016002 | 225.0 |
> showing 50 of 97 rows — these rows as CSV