PREVIEW / futures_daily / 2011-10-26
file: by_date/futures_daily/2011/2011-10-26.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-10-26 | ES | Futures | 1222.85 | 1240.32 | 1214.37 | 1235.33 | 2697660.0 |
| 2011-10-26 | NQ | Futures | 2651.89 | 2682.71 | 2610.23 | 2655.6 | 322352.0 |
| 2011-10-26 | YM | Futures | 11209.0 | 11367.5 | 11174.4 | 11337.7 | 141154.0 |
| 2011-10-26 | CL | Futures | 173.7 | 176.2 | 168.84 | 169.22 | 411445.0 |
| 2011-10-26 | GC | Futures | 2304.9 | 2333.1 | 2290.5 | 2327.0 | 151505.0 |
| 2011-10-26 | ZN | Futures | 110.865828 | 110.90605 | 110.208865 | 110.329532 | 1324570.0 |
| 2011-10-26 | A6 | Futures | 0.91139 | 0.91174 | 0.90181 | 0.90787 | 150868.0 |
| 2011-10-26 | AD | Futures | 0.98364 | 0.99565 | 0.98194 | 0.99295 | 97006.0 |
| 2011-10-26 | B | Futures | 97.0 | 97.76 | 95.34 | 95.44 | 100807.0 |
| 2011-10-26 | B6 | Futures | 1.6698 | 1.6734 | 1.6574 | 1.6645 | 100933.0 |
| 2011-10-26 | BFX | Futures | 2549.8 | 2558.0 | 2549.8 | 2558.0 | 51.0 |
| 2011-10-26 | BR | Futures | 0.25295 | 0.25476 | 0.25295 | 0.2546 | 166.0 |
| 2011-10-26 | BZ | Futures | 101.81 | 101.81 | 100.72 | 100.78 | 1030.0 |
| 2011-10-26 | C | Futures | 1782.0 | 1810.0 | 1780.0 | 1799.0 | 6325.0 |
| 2011-10-26 | CB | Futures | 95.341 | 95.341 | 94.793 | 94.793 | 12.0 |
| 2011-10-26 | CC | Futures | 2079.0 | 2133.0 | 2077.0 | 2112.0 | 15437.0 |
| 2011-10-26 | CT | Futures | 128.51 | 129.86 | 128.25 | 129.34 | 6982.0 |
| 2011-10-26 | DC | Futures | 28.68 | 29.2 | 28.66 | 29.0 | 249.0 |
| 2011-10-26 | DX | Futures | 75.082 | 75.464 | 74.674 | 75.075 | 32010.0 |
| 2011-10-26 | E1 | Futures | 1.49611 | 1.50464 | 1.4822 | 1.48902 | 27329.0 |
| 2011-10-26 | E6 | Futures | 1.66182 | 1.66971 | 1.64844 | 1.66015 | 353908.0 |
| 2011-10-26 | E7 | Futures | 1.6471 | 1.6553 | 1.6345 | 1.646 | 5724.0 |
| 2011-10-26 | ED | Futures | 94.9555 | 94.965 | 94.9411 | 94.9507 | 138938.0 |
| 2011-10-26 | ER | Futures | 97.199 | 97.228 | 97.184 | 97.209 | 120243.0 |
| 2011-10-26 | EW | Futures | 867.2 | 880.8 | 855.4 | 874.4 | 27839.0 |
| 2011-10-26 | FBTP | Futures | 61.18 | 61.39 | 60.96 | 61.18 | 7878.0 |
| 2011-10-26 | FBTS | Futures | 81.598 | 81.735 | 81.55 | 81.631 | 1304.0 |
| 2011-10-26 | FCE | Futures | 2271.1 | 2314.2 | 2254.2 | 2271.8 | 85390.0 |
| 2011-10-26 | FDAX | Futures | 6558.3 | 6683.2 | 6469.3 | 6532.8 | 180452.0 |
| 2011-10-26 | FESX | Futures | 1550.4 | 1577.7 | 1534.5 | 1545.8 | 1188455.0 |
| 2011-10-26 | FEU3 | Futures | 97.742 | 97.766 | 97.742 | 97.766 | 1.0 |
| 2011-10-26 | FGBL | Futures | 109.49 | 110.07 | 109.0 | 109.73 | 901416.0 |
| 2011-10-26 | FGBM | Futures | 110.6 | 111.06 | 110.39 | 110.87 | 482326.0 |
| 2011-10-26 | FGBS | Futures | 109.039 | 109.148 | 108.969 | 109.104 | 452100.0 |
| 2011-10-26 | FGBX | Futures | 110.86 | 111.94 | 109.85 | 111.26 | 4160.0 |
| 2011-10-26 | FTDX | Futures | 642.6 | 653.2 | 640.8 | 645.4 | 104.0 |
| 2011-10-26 | FTI | Futures | 251.11 | 254.0 | 248.71 | 250.4 | 38586.0 |
| 2011-10-26 | FTUK | Futures | 3922.2 | 4007.9 | 3922.2 | 3964.2 | 108604.0 |
| 2011-10-26 | FVSA | Futures | 15230.54 | 15793.09 | 14793.0 | 15501.39 | 4333.0 |
| 2011-10-26 | FXXP | Futures | 167.6 | 168.9 | 166.2 | 167.3 | 434.0 |
| 2011-10-26 | G | Futures | 90.56 | 91.17 | 90.4 | 90.91 | 135626.0 |
| 2011-10-26 | GF | Futures | 314.086 | 316.631 | 313.146 | 313.588 | 2437.0 |
| 2011-10-26 | GSCI | Futures | 1015.42 | 1020.2 | 999.2 | 999.75 | 173.0 |
| 2011-10-26 | HE | Futures | 112.311 | 112.921 | 111.636 | 111.861 | 18957.0 |
| 2011-10-26 | HG | Futures | 4.517 | 4.7479 | 4.4939 | 4.6183 | 60718.0 |
| 2011-10-26 | HO | Futures | 2.4483 | 2.4662 | 2.4243 | 2.4266 | 64998.0 |
| 2011-10-26 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 0.0 |
| 2011-10-26 | J1 | Futures | 0.0165245 | 0.0166087 | 0.0164743 | 0.0165082 | 77710.0 |
| 2011-10-26 | J7 | Futures | 0.016418 | 0.016505 | 0.016376 | 0.016408 | 788.0 |
| 2011-10-26 | JB | Futures | 124.25 | 124.59 | 124.23 | 124.55 | 3487.0 |
> showing 50 of 97 rows — these rows as CSV