PREVIEW / futures_daily / 2011-09-15
file: by_date/futures_daily/2011/2011-09-15.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-09-15 | ES | Futures | 1180.18 | 1203.39 | 1173.69 | 1202.14 | 3024123.0 |
| 2011-09-15 | NQ | Futures | 2564.28 | 2609.94 | 2556.01 | 2607.09 | 400800.0 |
| 2011-09-15 | YM | Futures | 10741.1 | 10933.3 | 10686.4 | 10927.5 | 128765.0 |
| 2011-09-15 | CL | Futures | 167.16 | 170.25 | 166.2 | 168.93 | 158805.0 |
| 2011-09-15 | GC | Futures | 2462.7 | 2470.4 | 2396.5 | 2405.2 | 237735.0 |
| 2011-09-15 | ZN | Futures | 111.68368 | 111.764124 | 110.745161 | 111.107161 | 1460451.0 |
| 2011-09-15 | A6 | Futures | 0.89266 | 0.90022 | 0.8858 | 0.89802 | 90595.0 |
| 2011-09-15 | AD | Futures | 1.00866 | 1.01566 | 1.00366 | 1.01486 | 64079.0 |
| 2011-09-15 | B | Futures | 94.03 | 97.44 | 93.53 | 96.36 | 230569.0 |
| 2011-09-15 | B6 | Futures | 1.644 | 1.6545 | 1.6406 | 1.6483 | 100645.0 |
| 2011-09-15 | BFX | Futures | 2550.4 | 2574.3 | 2547.2 | 2574.3 | 241.0 |
| 2011-09-15 | BR | Futures | 0.25928 | 0.26041 | 0.25928 | 0.25973 | 222.0 |
| 2011-09-15 | BZ | Futures | 99.2 | 100.25 | 99.16 | 99.81 | 1362.0 |
| 2011-09-15 | C | Futures | 1931.0 | 1933.0 | 1913.0 | 1918.0 | 7162.0 |
| 2011-09-15 | CC | Futures | 2199.0 | 2212.0 | 2185.0 | 2188.0 | 9286.0 |
| 2011-09-15 | CSC | Futures | 4.288 | 4.288 | 4.283 | 4.283 | 12.0 |
| 2011-09-15 | CT | Futures | 146.48 | 147.86 | 142.36 | 143.56 | 43.0 |
| 2011-09-15 | DC | Futures | 30.06 | 30.3 | 29.91 | 30.06 | 98.0 |
| 2011-09-15 | DX | Futures | 75.99 | 76.181 | 75.185 | 75.373 | 44043.0 |
| 2011-09-15 | E1 | Futures | 1.5007 | 1.52156 | 1.49584 | 1.5129 | 17123.0 |
| 2011-09-15 | E6 | Futures | 1.64138 | 1.66433 | 1.63672 | 1.65836 | 250410.0 |
| 2011-09-15 | E7 | Futures | 1.6271 | 1.65 | 1.623 | 1.6442 | 4311.0 |
| 2011-09-15 | ED | Futures | 94.9316 | 95.0462 | 94.9316 | 95.0127 | 605542.0 |
| 2011-09-15 | ER | Futures | 97.282 | 97.327 | 97.169 | 97.292 | 320780.0 |
| 2011-09-15 | EW | Futures | 854.2 | 870.4 | 849.5 | 867.1 | 34505.0 |
| 2011-09-15 | FBTP | Futures | 62.05 | 62.36 | 61.91 | 62.0 | 9568.0 |
| 2011-09-15 | FBTS | Futures | 81.35 | 81.51 | 81.237 | 81.414 | 1368.0 |
| 2011-09-15 | FCE | Futures | 2117.8 | 2201.7 | 2106.3 | 2172.1 | 84807.0 |
| 2011-09-15 | FDAX | Futures | 5761.4 | 5964.4 | 5741.6 | 5876.3 | 270393.0 |
| 2011-09-15 | FESX | Futures | 1391.5 | 1444.7 | 1379.5 | 1421.4 | 2030695.0 |
| 2011-09-15 | FEU3 | Futures | 97.816 | 97.851 | 97.801 | 97.851 | 123.0 |
| 2011-09-15 | FGBL | Futures | 110.69 | 110.79 | 109.32 | 110.03 | 1114937.0 |
| 2011-09-15 | FGBM | Futures | 110.71 | 110.76 | 109.94 | 110.34 | 636129.0 |
| 2011-09-15 | FGBS | Futures | 108.969 | 109.009 | 108.726 | 108.895 | 692921.0 |
| 2011-09-15 | FGBX | Futures | 111.5 | 111.59 | 108.86 | 109.83 | 8907.0 |
| 2011-09-15 | FTDX | Futures | 650.4 | 659.6 | 639.4 | 652.7 | 845.0 |
| 2011-09-15 | FTI | Futures | 228.98 | 233.0 | 228.19 | 231.38 | 30221.0 |
| 2011-09-15 | FTUK | Futures | 3781.5 | 3849.3 | 3757.1 | 3815.9 | 127334.0 |
| 2011-09-15 | FVSA | Futures | 17328.31 | 17412.83 | 16905.66 | 17032.46 | 4130.0 |
| 2011-09-15 | FXXP | Futures | 156.4 | 160.2 | 156.4 | 158.4 | 9115.0 |
| 2011-09-15 | G | Futures | 92.03 | 92.23 | 90.97 | 91.47 | 162671.0 |
| 2011-09-15 | GF | Futures | 314.209 | 315.85 | 311.379 | 311.945 | 3849.0 |
| 2011-09-15 | GSCI | Futures | 1045.23 | 1052.76 | 1042.62 | 1043.97 | 149.0 |
| 2011-09-15 | HE | Futures | 108.458 | 109.313 | 108.245 | 108.703 | 20170.0 |
| 2011-09-15 | HG | Futures | 5.1734 | 5.2667 | 5.1529 | 5.2362 | 41684.0 |
| 2011-09-15 | HO | Futures | 2.3716 | 2.4565 | 2.3675 | 2.4381 | 20286.0 |
| 2011-09-15 | HRC | Futures | 2910.3 | 2910.3 | 2910.3 | 2910.3 | 0.0 |
| 2011-09-15 | J1 | Futures | 0.0164052 | 0.0164353 | 0.0162682 | 0.0164127 | 87972.0 |
| 2011-09-15 | J7 | Futures | 0.016311 | 0.016334 | 0.016172 | 0.016313 | 484.0 |
| 2011-09-15 | JB | Futures | 124.48 | 124.63 | 124.44 | 124.57 | 1144.0 |
> showing 50 of 97 rows — these rows as CSV