PREVIEW / futures_daily / 2011-06-22
file: by_date/futures_daily/2011/2011-06-22.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-22 | ES | Futures | 1278.91 | 1284.87 | 1270.71 | 1270.96 | 1872931.0 |
| 2011-06-22 | NQ | Futures | 2554.52 | 2563.06 | 2538.01 | 2538.86 | 223745.0 |
| 2011-06-22 | YM | Futures | 11431.8 | 11476.3 | 11364.7 | 11366.6 | 102304.0 |
| 2011-06-22 | CL | Futures | 179.91 | 183.63 | 178.91 | 183.07 | 296275.0 |
| 2011-06-22 | GC | Futures | 2095.0 | 2110.4 | 2087.0 | 2102.4 | 140559.0 |
| 2011-06-22 | ZN | Futures | 105.282247 | 105.708006 | 105.175807 | 105.295552 | 1188963.0 |
| 2011-06-22 | A6 | Futures | 0.91152 | 0.91622 | 0.90874 | 0.91109 | 93842.0 |
| 2011-06-22 | AD | Futures | 1.02441 | 1.0273 | 1.02111 | 1.02471 | 73684.0 |
| 2011-06-22 | B | Futures | 94.94 | 97.95 | 94.41 | 97.72 | 216429.0 |
| 2011-06-22 | B6 | Futures | 1.6876 | 1.69 | 1.6688 | 1.6709 | 126273.0 |
| 2011-06-22 | BFX | Futures | 3059.5 | 3061.2 | 3032.8 | 3032.8 | 228.0 |
| 2011-06-22 | BR | Futures | 0.27653 | 0.27662 | 0.2759 | 0.27617 | 81.0 |
| 2011-06-22 | BZ | Futures | 99.01 | 102.06 | 99.01 | 101.9 | 1653.0 |
| 2011-06-22 | C | Futures | 2044.0 | 2053.0 | 2020.0 | 2049.0 | 5065.0 |
| 2011-06-22 | CB | Futures | 115.614 | 115.614 | 113.696 | 113.97 | 60.0 |
| 2011-06-22 | CC | Futures | 2403.0 | 2424.0 | 2366.0 | 2411.0 | 8204.0 |
| 2011-06-22 | CT | Futures | 154.6 | 159.93 | 154.6 | 159.57 | 10735.0 |
| 2011-06-22 | DC | Futures | 30.78 | 30.87 | 30.55 | 30.59 | 137.0 |
| 2011-06-22 | DX | Futures | 74.37 | 74.583 | 74.143 | 74.463 | 26431.0 |
| 2011-06-22 | E1 | Futures | 1.55674 | 1.56903 | 1.5519 | 1.55974 | 39483.0 |
| 2011-06-22 | E6 | Futures | 1.70647 | 1.7111 | 1.6991 | 1.7029 | 287842.0 |
| 2011-06-22 | E7 | Futures | 1.6929 | 1.6985 | 1.6863 | 1.6905 | 5763.0 |
| 2011-06-22 | ED | Futures | 94.9382 | 94.9525 | 94.9239 | 94.9334 | 250695.0 |
| 2011-06-22 | ER | Futures | 97.281 | 97.341 | 97.272 | 97.306 | 113788.0 |
| 2011-06-22 | EW | Futures | 944.4 | 952.3 | 939.9 | 940.7 | 17816.0 |
| 2011-06-22 | FBTP | Futures | 65.1 | 65.1 | 64.72 | 64.75 | 7359.0 |
| 2011-06-22 | FCE | Futures | 2689.9 | 2697.9 | 2676.0 | 2688.8 | 99558.0 |
| 2011-06-22 | FDAX | Futures | 7809.2 | 7839.6 | 7774.5 | 7812.4 | 133581.0 |
| 2011-06-22 | FESX | Futures | 1797.9 | 1803.0 | 1785.7 | 1795.3 | 1172414.0 |
| 2011-06-22 | FEU3 | Futures | 97.84 | 97.845 | 97.84 | 97.845 | 8.0 |
| 2011-06-22 | FGBL | Futures | 100.9 | 101.38 | 100.84 | 101.25 | 1053138.0 |
| 2011-06-22 | FGBM | Futures | 105.25 | 105.56 | 105.19 | 105.49 | 576239.0 |
| 2011-06-22 | FGBS | Futures | 107.129 | 107.259 | 107.084 | 107.224 | 549430.0 |
| 2011-06-22 | FGBX | Futures | 94.72 | 95.24 | 94.66 | 95.08 | 7772.0 |
| 2011-06-22 | FTDX | Futures | 781.0 | 785.9 | 779.7 | 782.4 | 293.0 |
| 2011-06-22 | FTI | Futures | 275.74 | 276.48 | 273.03 | 274.63 | 30444.0 |
| 2011-06-22 | FTUK | Futures | 4040.1 | 4058.5 | 4024.2 | 4048.9 | 87878.0 |
| 2011-06-22 | FXXP | Futures | 181.7 | 181.9 | 180.8 | 181.5 | 2522.0 |
| 2011-06-22 | G | Futures | 84.82 | 85.34 | 84.8 | 85.04 | 127354.0 |
| 2011-06-22 | GF | Futures | 319.728 | 322.691 | 317.171 | 320.715 | 3591.0 |
| 2011-06-22 | GSCI | Futures | 1051.36 | 1063.97 | 1049.78 | 1063.97 | 235.0 |
| 2011-06-22 | HE | Futures | 105.359 | 105.519 | 104.025 | 104.852 | 7170.0 |
| 2011-06-22 | HG | Futures | 5.4312 | 5.4405 | 5.3724 | 5.4292 | 13067.0 |
| 2011-06-22 | HO | Futures | 2.3667 | 2.4328 | 2.3514 | 2.4203 | 13279.0 |
| 2011-06-22 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-06-22 | J1 | Futures | 0.0156737 | 0.015719 | 0.0156159 | 0.0156586 | 77177.0 |
| 2011-06-22 | J7 | Futures | 0.015556 | 0.015611 | 0.015532 | 0.015554 | 228.0 |
| 2011-06-22 | JB | Futures | 122.85 | 122.95 | 122.77 | 122.95 | 1319.0 |
| 2011-06-22 | KC | Futures | 587.65 | 589.31 | 578.31 | 582.45 | 10446.0 |
| 2011-06-22 | KE | Futures | 3173.56 | 3198.24 | 2977.06 | 3041.24 | 19279.0 |
> showing 50 of 95 rows — these rows as CSV