PREVIEW / futures_daily / 2011-10-27
file: by_date/futures_daily/2011/2011-10-27.parquet size: 9 KB rows: 95
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-27 | ES | Futures | 1235.83 | 1286.99 | 1235.33 | 1280.25 | 3324091.0 |
| 2011-10-27 | NQ | Futures | 2659.31 | 2749.48 | 2658.45 | 2732.36 | 329377.0 |
| 2011-10-27 | YM | Futures | 11341.5 | 11746.9 | 11341.5 | 11689.3 | 138909.0 |
| 2011-10-27 | CL | Futures | 170.68 | 176.82 | 170.23 | 176.27 | 327446.0 |
| 2011-10-27 | GC | Futures | 2331.6 | 2364.5 | 2305.0 | 2359.7 | 156347.0 |
| 2011-10-27 | ZN | Futures | 110.329532 | 110.463606 | 109.136273 | 109.243532 | 1676052.0 |
| 2011-10-27 | A6 | Futures | 0.90893 | 0.93989 | 0.90805 | 0.93734 | 186612.0 |
| 2011-10-27 | AD | Futures | 0.99435 | 1.01026 | 0.99435 | 1.00866 | 96421.0 |
| 2011-10-27 | B | Futures | 95.86 | 99.12 | 95.85 | 98.46 | 138945.0 |
| 2011-10-27 | B6 | Futures | 1.6653 | 1.6838 | 1.6642 | 1.681 | 121904.0 |
| 2011-10-27 | BR | Futures | 0.25833 | 0.26253 | 0.25833 | 0.26253 | 383.0 |
| 2011-10-27 | BZ | Futures | 103.08 | 104.62 | 103.08 | 103.96 | 1076.0 |
| 2011-10-27 | C | Futures | 1821.0 | 1827.0 | 1800.0 | 1814.0 | 6271.0 |
| 2011-10-27 | CC | Futures | 2123.0 | 2170.0 | 2118.0 | 2161.0 | 16424.0 |
| 2011-10-27 | CSC | Futures | 4.146 | 4.146 | 4.098 | 4.098 | 9.0 |
| 2011-10-27 | CT | Futures | 129.31 | 134.49 | 128.81 | 134.49 | 14569.0 |
| 2011-10-27 | DC | Futures | 29.02 | 29.45 | 29.02 | 29.37 | 296.0 |
| 2011-10-27 | DX | Futures | 75.057 | 75.062 | 73.491 | 73.639 | 45345.0 |
| 2011-10-27 | E1 | Futures | 1.48915 | 1.53285 | 1.48823 | 1.5276 | 34158.0 |
| 2011-10-27 | E6 | Futures | 1.66027 | 1.7021 | 1.65632 | 1.69732 | 432110.0 |
| 2011-10-27 | E7 | Futures | 1.6461 | 1.6876 | 1.6422 | 1.6828 | 8732.0 |
| 2011-10-27 | ED | Futures | 94.9507 | 94.9936 | 94.9459 | 94.9889 | 210664.0 |
| 2011-10-27 | ER | Futures | 97.204 | 97.209 | 97.164 | 97.184 | 133904.0 |
| 2011-10-27 | EW | Futures | 874.9 | 922.2 | 874.9 | 914.8 | 42093.0 |
| 2011-10-27 | FBTP | Futures | 61.52 | 62.2 | 61.4 | 61.5 | 9168.0 |
| 2011-10-27 | FBTS | Futures | 81.871 | 82.216 | 81.783 | 81.799 | 1818.0 |
| 2011-10-27 | FCE | Futures | 2342.5 | 2447.0 | 2332.8 | 2416.5 | 150484.0 |
| 2011-10-27 | FDAX | Futures | 6732.1 | 6994.8 | 6707.6 | 6874.3 | 207622.0 |
| 2011-10-27 | FESX | Futures | 1590.3 | 1668.1 | 1588.3 | 1640.8 | 2213942.0 |
| 2011-10-27 | FGBL | Futures | 108.86 | 109.05 | 107.73 | 108.18 | 1040210.0 |
| 2011-10-27 | FGBM | Futures | 110.43 | 110.58 | 109.73 | 110.0 | 515871.0 |
| 2011-10-27 | FGBS | Futures | 108.989 | 109.049 | 108.726 | 108.81 | 654208.0 |
| 2011-10-27 | FGBX | Futures | 109.85 | 109.85 | 106.79 | 107.6 | 6651.0 |
| 2011-10-27 | FTDX | Futures | 660.6 | 667.5 | 658.7 | 658.7 | 213.0 |
| 2011-10-27 | FTI | Futures | 257.15 | 263.39 | 255.49 | 260.13 | 43113.0 |
| 2011-10-27 | FTUK | Futures | 3999.7 | 4136.4 | 3991.1 | 4082.2 | 142144.0 |
| 2011-10-27 | FVSA | Futures | 14584.64 | 14584.64 | 13042.84 | 13147.01 | 4056.0 |
| 2011-10-27 | FXXP | Futures | 172.0 | 174.2 | 170.8 | 173.4 | 1849.0 |
| 2011-10-27 | G | Futures | 90.04 | 90.45 | 89.52 | 89.74 | 120321.0 |
| 2011-10-27 | GF | Futures | 313.699 | 315.801 | 312.648 | 313.312 | 2118.0 |
| 2011-10-27 | GSCI | Futures | 1023.88 | 1033.83 | 1022.08 | 1033.44 | 274.0 |
| 2011-10-27 | HE | Futures | 112.054 | 113.243 | 111.186 | 111.379 | 19553.0 |
| 2011-10-27 | HG | Futures | 4.6308 | 4.9246 | 4.6288 | 4.8856 | 58937.0 |
| 2011-10-27 | HO | Futures | 2.4303 | 2.5043 | 2.4302 | 2.493 | 67292.0 |
| 2011-10-27 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 0.0 |
| 2011-10-27 | J1 | Futures | 0.0164931 | 0.0166175 | 0.0164818 | 0.0165534 | 94461.0 |
| 2011-10-27 | J7 | Futures | 0.016408 | 0.016517 | 0.016383 | 0.016453 | 630.0 |
| 2011-10-27 | JB | Futures | 124.56 | 124.57 | 124.36 | 124.42 | 2299.0 |
| 2011-10-27 | KC | Futures | 551.41 | 567.79 | 551.41 | 552.82 | 11797.0 |
| 2011-10-27 | KE | Futures | 2683.15 | 2766.45 | 2683.15 | 2762.7 | 8514.0 |
> showing 50 of 95 rows — these rows as CSV