PREVIEW / futures_daily / 2012-02-06
file: by_date/futures_daily/2012/2012-02-06.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 |
|---|---|---|---|---|---|---|---|
| 2012-02-06 | ES | Futures | 1341.27 | 1345.28 | 1334.99 | 1343.78 | 1196876.0 |
| 2012-02-06 | NQ | Futures | 2881.58 | 2889.01 | 2871.0 | 2888.44 | 156417.0 |
| 2012-02-06 | YM | Futures | 12359.2 | 12372.8 | 12303.1 | 12355.3 | 71110.0 |
| 2012-02-06 | CL | Futures | 182.67 | 182.69 | 180.13 | 181.12 | 257715.0 |
| 2012-02-06 | GC | Futures | 2318.0 | 2331.3 | 2295.3 | 2309.9 | 137271.0 |
| 2012-02-06 | ZN | Futures | 113.678351 | 113.907895 | 113.51632 | 113.786372 | 715193.0 |
| 2012-02-06 | A6 | Futures | 0.95338 | 0.95338 | 0.94626 | 0.95062 | 91506.0 |
| 2012-02-06 | AD | Futures | 1.00924 | 1.00995 | 1.00332 | 1.00653 | 76603.0 |
| 2012-02-06 | B | Futures | 102.01 | 103.66 | 100.96 | 102.98 | 118276.0 |
| 2012-02-06 | B6 | Futures | 1.6531 | 1.6555 | 1.6438 | 1.6539 | 74051.0 |
| 2012-02-06 | BFX | Futures | 2744.2 | 2749.4 | 2731.4 | 2746.9 | 29.0 |
| 2012-02-06 | BR | Futures | 0.27014 | 0.27149 | 0.26733 | 0.27037 | 576.0 |
| 2012-02-06 | BZ | Futures | 107.87 | 109.96 | 107.82 | 109.75 | 872.0 |
| 2012-02-06 | C | Futures | 1546.0 | 1546.0 | 1486.0 | 1501.0 | 6615.0 |
| 2012-02-06 | CB | Futures | 81.421 | 81.421 | 80.465 | 80.734 | 15.0 |
| 2012-02-06 | CC | Futures | 1771.0 | 1795.0 | 1724.0 | 1742.0 | 10235.0 |
| 2012-02-06 | CSC | Futures | 3.795 | 3.805 | 3.793 | 3.793 | 37.0 |
| 2012-02-06 | CT | Futures | 124.88 | 125.27 | 123.51 | 124.04 | 10449.0 |
| 2012-02-06 | DC | Futures | 26.51 | 26.68 | 26.23 | 26.65 | 249.0 |
| 2012-02-06 | DX | Futures | 77.077 | 77.52 | 76.989 | 77.073 | 18534.0 |
| 2012-02-06 | E1 | Futures | 1.42867 | 1.43103 | 1.4179 | 1.42919 | 24684.0 |
| 2012-02-06 | E6 | Futures | 1.56859 | 1.5711 | 1.55724 | 1.56883 | 279685.0 |
| 2012-02-06 | E7 | Futures | 1.5546 | 1.5567 | 1.543 | 1.5545 | 4976.0 |
| 2012-02-06 | EBM | Futures | 284.68 | 291.56 | 283.37 | 291.23 | 18444.0 |
| 2012-02-06 | ED | Futures | 95.1202 | 95.1298 | 95.1059 | 95.1107 | 131853.0 |
| 2012-02-06 | ER | Futures | 97.449 | 97.464 | 97.43 | 97.454 | 81383.0 |
| 2012-02-06 | EW | Futures | 973.2 | 977.0 | 968.8 | 973.7 | 13376.0 |
| 2012-02-06 | FBTP | Futures | 64.28 | 64.72 | 63.64 | 64.71 | 13121.0 |
| 2012-02-06 | FBTS | Futures | 84.264 | 84.569 | 84.192 | 84.457 | 1242.0 |
| 2012-02-06 | FCE | Futures | 2431.4 | 2432.8 | 2407.1 | 2424.2 | 71044.0 |
| 2012-02-06 | FDAX | Futures | 7458.5 | 7494.4 | 7419.3 | 7472.3 | 114099.0 |
| 2012-02-06 | FESX | Futures | 1678.7 | 1680.1 | 1662.0 | 1676.1 | 750274.0 |
| 2012-02-06 | FGBL | Futures | 112.06 | 112.6 | 112.03 | 112.19 | 555461.0 |
| 2012-02-06 | FGBM | Futures | 113.12 | 113.51 | 113.11 | 113.3 | 324657.0 |
| 2012-02-06 | FGBS | Futures | 109.864 | 109.939 | 109.859 | 109.904 | 285802.0 |
| 2012-02-06 | FGBX | Futures | 116.47 | 117.55 | 116.4 | 116.86 | 3970.0 |
| 2012-02-06 | FTDX | Futures | 712.0 | 721.8 | 711.6 | 714.8 | 184.0 |
| 2012-02-06 | FTI | Futures | 271.77 | 272.27 | 269.8 | 271.18 | 23737.0 |
| 2012-02-06 | FTUK | Futures | 4228.1 | 4228.8 | 4197.8 | 4216.6 | 75296.0 |
| 2012-02-06 | FVSA | Futures | 9660.77 | 9968.07 | 9622.36 | 9756.8 | 4670.0 |
| 2012-02-06 | FXXP | Futures | 186.0 | 186.5 | 185.4 | 186.0 | 2703.0 |
| 2012-02-06 | G | Futures | 93.72 | 94.0 | 93.53 | 93.64 | 100792.0 |
| 2012-02-06 | GF | Futures | 325.954 | 327.809 | 325.689 | 326.855 | 2802.0 |
| 2012-02-06 | GSCI | Futures | 1038.71 | 1048.57 | 1032.38 | 1045.44 | 536.0 |
| 2012-02-06 | HE | Futures | 107.042 | 108.25 | 106.77 | 107.012 | 14884.0 |
| 2012-02-06 | HG | Futures | 5.1461 | 5.1467 | 5.0491 | 5.0973 | 40332.0 |
| 2012-02-06 | HO | Futures | 2.5238 | 2.5831 | 2.5098 | 2.566 | 72627.0 |
| 2012-02-06 | HRC | Futures | 2837.4 | 2837.4 | 2837.4 | 2837.4 | 0.0 |
| 2012-02-06 | J1 | Futures | 0.0164151 | 0.0164201 | 0.0163536 | 0.0164013 | 56680.0 |
| 2012-02-06 | J7 | Futures | 0.016338 | 0.01635 | 0.016288 | 0.016333 | 212.0 |
> showing 50 of 97 rows — these rows as CSV