PREVIEW / futures_daily / 2011-07-26
file: by_date/futures_daily/2011/2011-07-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-07-26 | ES | Futures | 1324.34 | 1330.55 | 1316.4 | 1317.14 | 1698186.0 |
| 2011-07-26 | NQ | Futures | 2759.21 | 2773.44 | 2747.54 | 2759.78 | 185139.0 |
| 2011-07-26 | YM | Futures | 11863.9 | 11914.9 | 11744.8 | 11753.3 | 107046.0 |
| 2011-07-26 | CL | Futures | 190.02 | 192.83 | 187.35 | 190.86 | 332692.0 |
| 2011-07-26 | GC | Futures | 2182.0 | 2191.6 | 2174.2 | 2186.3 | 103276.0 |
| 2011-07-26 | ZN | Futures | 105.708006 | 106.133765 | 105.401991 | 106.04063 | 1091010.0 |
| 2011-07-26 | A6 | Futures | 0.93701 | 0.94762 | 0.93483 | 0.94692 | 89343.0 |
| 2011-07-26 | AD | Futures | 1.05255 | 1.05974 | 1.05195 | 1.05704 | 65909.0 |
| 2011-07-26 | B | Futures | 100.55 | 101.77 | 99.63 | 101.11 | 65468.0 |
| 2011-07-26 | B6 | Futures | 1.6928 | 1.7081 | 1.6911 | 1.7074 | 95720.0 |
| 2011-07-26 | BFX | Futures | 3023.5 | 3025.9 | 3001.1 | 3011.3 | 97.0 |
| 2011-07-26 | BR | Futures | 0.28954 | 0.28954 | 0.28833 | 0.28878 | 875.0 |
| 2011-07-26 | BZ | Futures | 104.43 | 104.43 | 104.43 | 104.43 | 248.0 |
| 2011-07-26 | C | Futures | 2013.0 | 2034.0 | 2009.0 | 2027.0 | 6055.0 |
| 2011-07-26 | CB | Futures | 112.874 | 113.422 | 112.326 | 113.422 | 8.0 |
| 2011-07-26 | CC | Futures | 2370.0 | 2410.0 | 2365.0 | 2390.0 | 15231.0 |
| 2011-07-26 | CT | Futures | 126.76 | 131.19 | 121.34 | 131.19 | 88.0 |
| 2011-07-26 | DC | Futures | 33.78 | 34.01 | 33.26 | 33.64 | 244.0 |
| 2011-07-26 | DX | Futures | 73.593 | 73.677 | 72.895 | 72.919 | 28211.0 |
| 2011-07-26 | E1 | Futures | 1.62304 | 1.63573 | 1.62121 | 1.63364 | 32932.0 |
| 2011-07-26 | E6 | Futures | 1.70492 | 1.72274 | 1.70267 | 1.72191 | 286679.0 |
| 2011-07-26 | E7 | Futures | 1.6926 | 1.71 | 1.6902 | 1.7093 | 4829.0 |
| 2011-07-26 | ED | Futures | 94.9477 | 94.9668 | 94.9382 | 94.9573 | 158954.0 |
| 2011-07-26 | ER | Futures | 97.346 | 97.351 | 97.321 | 97.326 | 90727.0 |
| 2011-07-26 | EW | Futures | 974.6 | 979.8 | 965.1 | 966.2 | 15066.0 |
| 2011-07-26 | FBTP | Futures | 61.28 | 61.7 | 60.79 | 61.25 | 9964.0 |
| 2011-07-26 | FCE | Futures | 2694.0 | 2706.3 | 2657.3 | 2674.3 | 125583.0 |
| 2011-07-26 | FDAX | Futures | 7876.0 | 7905.9 | 7818.8 | 7875.4 | 127390.0 |
| 2011-07-26 | FESX | Futures | 1760.7 | 1772.2 | 1746.6 | 1760.7 | 1110254.0 |
| 2011-07-26 | FEU3 | Futures | 97.88 | 97.88 | 97.865 | 97.865 | 71.0 |
| 2011-07-26 | FGBL | Futures | 102.68 | 103.12 | 102.49 | 102.96 | 831128.0 |
| 2011-07-26 | FGBM | Futures | 106.35 | 106.68 | 106.27 | 106.55 | 472800.0 |
| 2011-07-26 | FGBS | Futures | 107.487 | 107.577 | 107.428 | 107.512 | 510483.0 |
| 2011-07-26 | FGBX | Futures | 97.42 | 98.91 | 97.38 | 98.6 | 3754.0 |
| 2011-07-26 | FTDX | Futures | 759.1 | 759.1 | 752.0 | 756.0 | 290.0 |
| 2011-07-26 | FTI | Futures | 278.46 | 279.58 | 276.51 | 277.88 | 30356.0 |
| 2011-07-26 | FTUK | Futures | 4139.9 | 4171.3 | 4130.1 | 4155.4 | 89994.0 |
| 2011-07-26 | FXXP | Futures | 183.3 | 183.3 | 181.7 | 182.6 | 1560.0 |
| 2011-07-26 | G | Futures | 85.84 | 86.11 | 85.73 | 85.92 | 170637.0 |
| 2011-07-26 | GF | Futures | 316.765 | 319.321 | 314.731 | 316.3 | 2598.0 |
| 2011-07-26 | GSCI | Futures | 1124.0 | 1128.08 | 1109.58 | 1124.4 | 211.0 |
| 2011-07-26 | HE | Futures | 111.376 | 111.404 | 108.677 | 110.688 | 11224.0 |
| 2011-07-26 | HG | Futures | 5.8285 | 5.9303 | 5.8106 | 5.9197 | 28091.0 |
| 2011-07-26 | HO | Futures | 2.5167 | 2.5503 | 2.495 | 2.5301 | 47787.0 |
| 2011-07-26 | HRC | Futures | 3010.8 | 3010.8 | 3010.8 | 3010.8 | 0.0 |
| 2011-07-26 | J1 | Futures | 0.0160608 | 0.0161564 | 0.0159527 | 0.0161451 | 94883.0 |
| 2011-07-26 | J7 | Futures | 0.015965 | 0.016046 | 0.015824 | 0.016037 | 416.0 |
| 2011-07-26 | JB | Futures | 123.25 | 123.31 | 123.19 | 123.23 | 16.0 |
| 2011-07-26 | KC | Futures | 576.06 | 585.17 | 574.4 | 579.49 | 12167.0 |
| 2011-07-26 | KE | Futures | 2957.58 | 3008.47 | 2934.53 | 2997.91 | 9271.0 |
> showing 50 of 95 rows — these rows as CSV