PREVIEW / futures_daily / 2011-05-26
file: by_date/futures_daily/2011/2011-05-26.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-05-26 | ES | Futures | 1303.35 | 1314.24 | 1299.39 | 1313.25 | 2286732.0 |
| 2011-05-26 | NQ | Futures | 2630.54 | 2654.74 | 2621.72 | 2648.19 | 246269.0 |
| 2011-05-26 | YM | Futures | 11619.6 | 11680.7 | 11564.2 | 11666.6 | 121304.0 |
| 2011-05-26 | CL | Futures | 194.49 | 195.76 | 191.36 | 192.55 | 332135.0 |
| 2011-05-26 | GC | Futures | 2066.4 | 2073.6 | 2051.2 | 2062.2 | 135430.0 |
| 2011-05-26 | ZN | Futures | 103.765576 | 104.371315 | 103.581221 | 104.292305 | 2282132.0 |
| 2011-05-26 | A6 | Futures | 0.9009 | 0.91162 | 0.89962 | 0.91059 | 108201.0 |
| 2011-05-26 | AD | Futures | 1.01783 | 1.02012 | 1.01385 | 1.01723 | 85804.0 |
| 2011-05-26 | B | Futures | 98.35 | 98.41 | 97.3 | 98.12 | 57177.0 |
| 2011-05-26 | B6 | Futures | 1.6901 | 1.7044 | 1.6899 | 1.7026 | 120785.0 |
| 2011-05-26 | BFX | Futures | 3150.3 | 3155.9 | 3133.1 | 3133.1 | 485.0 |
| 2011-05-26 | BR | Futures | 0.26971 | 0.27045 | 0.26971 | 0.27031 | 974.0 |
| 2011-05-26 | BZ | Futures | 101.55 | 102.31 | 101.55 | 102.31 | 335.0 |
| 2011-05-26 | C | Futures | 2010.0 | 2048.0 | 1993.0 | 2011.0 | 13869.0 |
| 2011-05-26 | CB | Futures | 118.902 | 120.272 | 117.806 | 119.71 | 42.0 |
| 2011-05-26 | CC | Futures | 2374.0 | 2438.0 | 2360.0 | 2396.0 | 15461.0 |
| 2011-05-26 | CT | Futures | 154.43 | 156.82 | 149.21 | 149.48 | 9569.0 |
| 2011-05-26 | DC | Futures | 30.95 | 31.22 | 30.93 | 31.18 | 154.0 |
| 2011-05-26 | DX | Futures | 75.715 | 75.715 | 75.039 | 75.255 | 31691.0 |
| 2011-05-26 | E1 | Futures | 1.50056 | 1.51392 | 1.49952 | 1.51183 | 44709.0 |
| 2011-05-26 | E6 | Futures | 1.66753 | 1.68234 | 1.66575 | 1.67452 | 375246.0 |
| 2011-05-26 | E7 | Futures | 1.6564 | 1.6697 | 1.6535 | 1.6621 | 7821.0 |
| 2011-05-26 | ED | Futures | 94.9502 | 94.9573 | 94.9502 | 94.9549 | 131714.0 |
| 2011-05-26 | ER | Futures | 97.316 | 97.331 | 97.306 | 97.326 | 145767.0 |
| 2011-05-26 | EW | Futures | 966.3 | 980.4 | 964.8 | 979.9 | 22006.0 |
| 2011-05-26 | FBTP | Futures | 65.07 | 65.47 | 65.07 | 65.31 | 8363.0 |
| 2011-05-26 | FCE | Futures | 2716.6 | 2730.1 | 2693.7 | 2704.4 | 128274.0 |
| 2011-05-26 | FDAX | Futures | 7688.9 | 7711.3 | 7572.0 | 7601.4 | 156420.0 |
| 2011-05-26 | FESX | Futures | 1805.5 | 1811.9 | 1781.8 | 1790.2 | 1419188.0 |
| 2011-05-26 | FEU3 | Futures | 97.855 | 97.87 | 97.855 | 97.87 | 123.0 |
| 2011-05-26 | FGBL | Futures | 99.86 | 100.49 | 99.81 | 100.43 | 1075768.0 |
| 2011-05-26 | FGBM | Futures | 104.35 | 104.72 | 104.25 | 104.68 | 742352.0 |
| 2011-05-26 | FGBS | Futures | 106.766 | 106.88 | 106.717 | 106.86 | 718152.0 |
| 2011-05-26 | FGBX | Futures | 96.79 | 98.04 | 96.63 | 97.86 | 4693.0 |
| 2011-05-26 | FTDX | Futures | 805.1 | 805.6 | 794.4 | 794.9 | 370.0 |
| 2011-05-26 | FTI | Futures | 283.45 | 284.76 | 281.64 | 282.91 | 39193.0 |
| 2011-05-26 | FTUK | Futures | 4098.7 | 4139.2 | 4095.9 | 4111.2 | 111491.0 |
| 2011-05-26 | FXXP | Futures | 184.7 | 185.7 | 184.5 | 185.1 | 4176.0 |
| 2011-05-26 | G | Futures | 83.64 | 83.92 | 82.92 | 83.83 | 136065.0 |
| 2011-05-26 | GF | Futures | 290.445 | 291.2 | 285.855 | 285.913 | 2423.0 |
| 2011-05-26 | GSCI | Futures | 1093.31 | 1093.31 | 1083.06 | 1089.56 | 227.0 |
| 2011-05-26 | HE | Futures | 93.796 | 93.928 | 92.578 | 92.975 | 10491.0 |
| 2011-05-26 | HG | Futures | 5.4504 | 5.4962 | 5.4092 | 5.4617 | 32106.0 |
| 2011-05-26 | HO | Futures | 2.4527 | 2.4612 | 2.4352 | 2.4482 | 8586.0 |
| 2011-05-26 | HRC | Futures | 3097.5 | 3138.5 | 3097.5 | 3128.3 | 6.0 |
| 2011-05-26 | J1 | Futures | 0.0153169 | 0.0154827 | 0.0153056 | 0.0154501 | 130697.0 |
| 2011-05-26 | J7 | Futures | 0.015221 | 0.015388 | 0.015221 | 0.015355 | 541.0 |
| 2011-05-26 | JB | Futures | 122.66 | 122.71 | 122.35 | 122.4 | 23.0 |
| 2011-05-26 | KC | Futures | 639.9 | 641.46 | 628.63 | 636.9 | 10526.0 |
| 2011-05-26 | KE | Futures | 3678.13 | 3800.57 | 3678.13 | 3723.55 | 15835.0 |
> showing 50 of 95 rows — these rows as CSV