PREVIEW / futures_daily / 2012-02-21
file: by_date/futures_daily/2012/2012-02-21.parquet size: 9 KB rows: 98
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-21 | ES | Futures | 1371.62 | 1374.38 | 1360.58 | 1364.85 | 1584418.0 |
| 2012-02-21 | NQ | Futures | 2966.2 | 2975.35 | 2943.9 | 2963.06 | 187245.0 |
| 2012-02-21 | YM | Futures | 12565.2 | 12595.2 | 12476.2 | 12518.8 | 115310.0 |
| 2012-02-21 | CL | Futures | 194.06 | 197.26 | 193.8 | 196.84 | 316239.0 |
| 2012-02-21 | GC | Futures | 2314.6 | 2359.4 | 2312.7 | 2354.9 | 202405.0 |
| 2012-02-21 | ZN | Futures | 113.030227 | 113.070735 | 112.665657 | 112.895201 | 1011044.0 |
| 2012-02-21 | A6 | Futures | 0.95552 | 0.95961 | 0.94519 | 0.94671 | 165155.0 |
| 2012-02-21 | AD | Futures | 1.00964 | 1.01276 | 1.00553 | 1.00683 | 104473.0 |
| 2012-02-21 | B | Futures | 106.94 | 108.55 | 106.17 | 108.35 | 149941.0 |
| 2012-02-21 | B6 | Futures | 1.6574 | 1.6616 | 1.6484 | 1.6498 | 128533.0 |
| 2012-02-21 | BFX | Futures | 2805.3 | 2805.9 | 2786.3 | 2792.7 | 64.0 |
| 2012-02-21 | BR | Futures | 0.2729 | 0.2729 | 0.27271 | 0.27271 | 23.0 |
| 2012-02-21 | BZ | Futures | 114.66 | 115.65 | 113.16 | 115.47 | 495.0 |
| 2012-02-21 | C | Futures | 1539.0 | 1580.0 | 1535.0 | 1578.0 | 3250.0 |
| 2012-02-21 | CB | Futures | 85.04 | 85.04 | 85.04 | 85.04 | 7.0 |
| 2012-02-21 | CC | Futures | 1784.0 | 1862.0 | 1784.0 | 1844.0 | 10378.0 |
| 2012-02-21 | CSC | Futures | 3.752 | 3.752 | 3.71 | 3.715 | 74.0 |
| 2012-02-21 | CT | Futures | 118.31 | 118.8 | 117.36 | 117.53 | 7467.0 |
| 2012-02-21 | DC | Futures | 26.14 | 26.21 | 25.86 | 25.86 | 412.0 |
| 2012-02-21 | DX | Futures | 77.087 | 77.242 | 76.79 | 77.024 | 23333.0 |
| 2012-02-21 | E1 | Futures | 1.4326 | 1.44691 | 1.43247 | 1.43995 | 60464.0 |
| 2012-02-21 | E6 | Futures | 1.57851 | 1.58915 | 1.57565 | 1.58342 | 384165.0 |
| 2012-02-21 | E7 | Futures | 1.5633 | 1.5744 | 1.5615 | 1.5689 | 8157.0 |
| 2012-02-21 | EBM | Futures | 283.69 | 283.69 | 276.81 | 277.47 | 3564.0 |
| 2012-02-21 | ED | Futures | 95.082 | 95.0892 | 95.0701 | 95.082 | 132297.0 |
| 2012-02-21 | ER | Futures | 97.44 | 97.449 | 97.435 | 97.44 | 58792.0 |
| 2012-02-21 | EW | Futures | 995.5 | 998.9 | 982.5 | 987.6 | 18352.0 |
| 2012-02-21 | FBTP | Futures | 65.03 | 66.13 | 64.98 | 65.66 | 15359.0 |
| 2012-02-21 | FBTS | Futures | 84.577 | 84.834 | 84.577 | 84.746 | 1239.0 |
| 2012-02-21 | FCE | Futures | 2456.5 | 2457.6 | 2429.3 | 2447.0 | 99760.0 |
| 2012-02-21 | FDAX | Futures | 7684.4 | 7703.1 | 7588.8 | 7637.4 | 138476.0 |
| 2012-02-21 | FESX | Futures | 1710.2 | 1710.8 | 1686.8 | 1700.8 | 1019261.0 |
| 2012-02-21 | FGBL | Futures | 111.58 | 111.92 | 111.43 | 111.64 | 623290.0 |
| 2012-02-21 | FGBM | Futures | 112.92 | 113.13 | 112.87 | 112.99 | 346401.0 |
| 2012-02-21 | FGBS | Futures | 109.755 | 109.805 | 109.745 | 109.785 | 280229.0 |
| 2012-02-21 | FGBX | Futures | 115.83 | 116.33 | 115.59 | 115.83 | 5103.0 |
| 2012-02-21 | FTDX | Futures | 734.3 | 734.8 | 722.7 | 728.7 | 295.0 |
| 2012-02-21 | FTI | Futures | 279.97 | 280.01 | 276.86 | 277.86 | 30742.0 |
| 2012-02-21 | FTUK | Futures | 4266.3 | 4281.1 | 4244.3 | 4263.5 | 83682.0 |
| 2012-02-21 | FVSA | Futures | 10319.05 | 10528.09 | 10148.01 | 10243.03 | 5219.0 |
| 2012-02-21 | FXXP | Futures | 188.6 | 189.1 | 187.8 | 188.2 | 3181.0 |
| 2012-02-21 | G | Futures | 92.95 | 93.4 | 92.92 | 93.3 | 210562.0 |
| 2012-02-21 | GF | Futures | 335.921 | 336.823 | 335.444 | 336.345 | 1795.0 |
| 2012-02-21 | GSCI | Futures | 1094.08 | 1104.79 | 1092.9 | 1104.79 | 236.0 |
| 2012-02-21 | HE | Futures | 109.006 | 109.096 | 108.19 | 108.552 | 12378.0 |
| 2012-02-21 | HG | Futures | 4.9295 | 5.0514 | 4.8935 | 5.0403 | 24608.0 |
| 2012-02-21 | HO | Futures | 2.5977 | 2.6506 | 2.597 | 2.6443 | 20914.0 |
| 2012-02-21 | HRC | Futures | 2731.0 | 2731.0 | 2731.0 | 2731.0 | 0.0 |
| 2012-02-21 | J1 | Futures | 0.0157509 | 0.0158249 | 0.0157195 | 0.0157584 | 111019.0 |
| 2012-02-21 | J7 | Futures | 0.015687 | 0.015758 | 0.015658 | 0.015693 | 496.0 |
> showing 50 of 98 rows — these rows as CSV