PREVIEW / futures_daily / 2011-06-23
file: by_date/futures_daily/2011/2011-06-23.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-06-23 | ES | Futures | 1271.21 | 1271.96 | 1248.37 | 1268.23 | 3316080.0 |
| 2011-06-23 | NQ | Futures | 2538.29 | 2566.19 | 2504.7 | 2547.97 | 415542.0 |
| 2011-06-23 | YM | Futures | 11372.3 | 11375.1 | 11158.6 | 11322.2 | 181429.0 |
| 2011-06-23 | CL | Futures | 181.13 | 181.27 | 172.1 | 174.65 | 484057.0 |
| 2011-06-23 | GC | Futures | 2095.8 | 2097.3 | 2045.7 | 2057.9 | 238418.0 |
| 2011-06-23 | ZN | Futures | 105.415296 | 106.080545 | 105.362076 | 105.88097 | 1672028.0 |
| 2011-06-23 | A6 | Futures | 0.90961 | 0.90978 | 0.89952 | 0.90334 | 164059.0 |
| 2011-06-23 | AD | Futures | 1.02301 | 1.02531 | 1.01383 | 1.01652 | 111438.0 |
| 2011-06-23 | B | Futures | 96.84 | 97.02 | 90.45 | 91.77 | 444224.0 |
| 2011-06-23 | B6 | Futures | 1.6704 | 1.6704 | 1.6563 | 1.6624 | 144067.0 |
| 2011-06-23 | BFX | Futures | 3012.7 | 3016.0 | 2975.9 | 2978.6 | 121.0 |
| 2011-06-23 | BR | Futures | 0.27524 | 0.27524 | 0.27524 | 0.27524 | 32.0 |
| 2011-06-23 | BZ | Futures | 101.0 | 101.0 | 94.39 | 95.69 | 1434.0 |
| 2011-06-23 | C | Futures | 2054.0 | 2088.0 | 2022.0 | 2043.0 | 2182.0 |
| 2011-06-23 | CB | Futures | 113.422 | 113.422 | 111.779 | 112.874 | 39.0 |
| 2011-06-23 | CC | Futures | 2411.0 | 2433.0 | 2347.0 | 2368.0 | 9663.0 |
| 2011-06-23 | CT | Futures | 160.34 | 164.99 | 160.34 | 162.87 | 5569.0 |
| 2011-06-23 | DC | Futures | 30.59 | 30.59 | 30.07 | 30.24 | 117.0 |
| 2011-06-23 | DX | Futures | 74.623 | 75.514 | 74.623 | 75.172 | 35944.0 |
| 2011-06-23 | E1 | Futures | 1.55896 | 1.56458 | 1.55046 | 1.56105 | 47789.0 |
| 2011-06-23 | E6 | Futures | 1.69875 | 1.69887 | 1.67381 | 1.68438 | 398872.0 |
| 2011-06-23 | E7 | Futures | 1.6866 | 1.6867 | 1.6616 | 1.6721 | 7403.0 |
| 2011-06-23 | ED | Futures | 94.9334 | 94.9382 | 94.8858 | 94.9096 | 506079.0 |
| 2011-06-23 | ER | Futures | 97.301 | 97.336 | 97.262 | 97.331 | 196230.0 |
| 2011-06-23 | EW | Futures | 940.7 | 943.9 | 923.4 | 941.2 | 30831.0 |
| 2011-06-23 | FBTP | Futures | 64.76 | 64.76 | 64.44 | 64.53 | 11683.0 |
| 2011-06-23 | FCE | Futures | 2670.8 | 2676.3 | 2619.7 | 2630.5 | 164042.0 |
| 2011-06-23 | FDAX | Futures | 7759.0 | 7773.9 | 7632.4 | 7662.3 | 160895.0 |
| 2011-06-23 | FESX | Futures | 1781.2 | 1785.0 | 1745.9 | 1751.7 | 1590426.0 |
| 2011-06-23 | FEU3 | Futures | 97.86 | 97.87 | 97.86 | 97.87 | 12.0 |
| 2011-06-23 | FGBL | Futures | 101.24 | 102.06 | 101.22 | 102.03 | 1165750.0 |
| 2011-06-23 | FGBM | Futures | 105.45 | 106.22 | 105.45 | 106.16 | 680531.0 |
| 2011-06-23 | FGBS | Futures | 107.219 | 107.507 | 107.214 | 107.487 | 719508.0 |
| 2011-06-23 | FGBX | Futures | 95.12 | 96.87 | 95.03 | 96.76 | 11694.0 |
| 2011-06-23 | FTDX | Futures | 778.3 | 780.1 | 768.5 | 770.8 | 168.0 |
| 2011-06-23 | FTI | Futures | 272.25 | 273.36 | 268.43 | 269.95 | 43031.0 |
| 2011-06-23 | FTUK | Futures | 4028.5 | 4030.6 | 3968.5 | 3975.6 | 117412.0 |
| 2011-06-23 | FXXP | Futures | 180.8 | 180.8 | 178.2 | 178.5 | 1592.0 |
| 2011-06-23 | G | Futures | 85.05 | 85.5 | 84.98 | 85.44 | 129809.0 |
| 2011-06-23 | GF | Futures | 319.089 | 321.18 | 314.324 | 320.367 | 3628.0 |
| 2011-06-23 | GSCI | Futures | 1030.45 | 1031.64 | 1010.34 | 1024.54 | 195.0 |
| 2011-06-23 | HE | Futures | 104.025 | 104.532 | 102.452 | 103.492 | 8206.0 |
| 2011-06-23 | HG | Futures | 5.3869 | 5.4127 | 5.3321 | 5.3625 | 16930.0 |
| 2011-06-23 | HO | Futures | 2.3953 | 2.3998 | 2.2614 | 2.2829 | 19878.0 |
| 2011-06-23 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-06-23 | J1 | Futures | 0.0156599 | 0.0156611 | 0.0155631 | 0.0156084 | 130344.0 |
| 2011-06-23 | J7 | Futures | 0.015546 | 0.015549 | 0.015462 | 0.015504 | 283.0 |
| 2011-06-23 | JB | Futures | 122.97 | 123.02 | 122.94 | 123.02 | 1187.0 |
| 2011-06-23 | KC | Futures | 582.68 | 595.7 | 571.21 | 588.36 | 13414.0 |
| 2011-06-23 | KE | Futures | 3041.24 | 3060.01 | 2922.75 | 3001.75 | 13820.0 |
> showing 50 of 95 rows — these rows as CSV