PREVIEW / futures_daily / 2012-04-25
file: by_date/futures_daily/2012/2012-04-25.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-04-25 | ES | Futures | 1381.33 | 1398.46 | 1380.07 | 1397.95 | 1827484.0 |
| 2012-04-25 | NQ | Futures | 3016.11 | 3101.18 | 3015.54 | 3098.6 | 339631.0 |
| 2012-04-25 | YM | Futures | 12611.2 | 12696.8 | 12599.6 | 12681.3 | 123032.0 |
| 2012-04-25 | CL | Futures | 190.34 | 191.82 | 189.14 | 191.0 | 276652.0 |
| 2012-04-25 | GC | Futures | 2195.3 | 2202.5 | 2172.3 | 2195.4 | 166069.0 |
| 2012-04-25 | ZN | Futures | 114.0981 | 114.179327 | 113.664884 | 114.0981 | 1280299.0 |
| 2012-04-25 | A6 | Futures | 0.92312 | 0.92708 | 0.92195 | 0.92618 | 113466.0 |
| 2012-04-25 | AD | Futures | 1.01758 | 1.02302 | 1.01698 | 1.02231 | 100661.0 |
| 2012-04-25 | B | Futures | 106.86 | 107.57 | 106.01 | 107.43 | 123140.0 |
| 2012-04-25 | B6 | Futures | 1.6939 | 1.7003 | 1.6874 | 1.6977 | 127696.0 |
| 2012-04-25 | BFX | Futures | 2685.4 | 2697.5 | 2678.3 | 2695.5 | 15.0 |
| 2012-04-25 | BR | Futures | 0.25168 | 0.25168 | 0.25168 | 0.25168 | 326.0 |
| 2012-04-25 | BZ | Futures | 113.04 | 114.48 | 113.04 | 114.48 | 615.0 |
| 2012-04-25 | C | Futures | 1492.0 | 1516.0 | 1480.0 | 1485.0 | 1938.0 |
| 2012-04-25 | CB | Futures | 75.352 | 75.352 | 75.352 | 75.352 | 2.0 |
| 2012-04-25 | CC | Futures | 1722.0 | 1738.0 | 1682.0 | 1697.0 | 10697.0 |
| 2012-04-25 | CSC | Futures | 3.412 | 3.439 | 3.412 | 3.426 | 49.0 |
| 2012-04-25 | CT | Futures | 111.94 | 113.1 | 110.83 | 111.08 | 10048.0 |
| 2012-04-25 | DC | Futures | 23.61 | 23.77 | 23.3 | 23.45 | 257.0 |
| 2012-04-25 | DX | Futures | 76.828 | 76.944 | 76.615 | 76.65 | 20417.0 |
| 2012-04-25 | E1 | Futures | 1.43913 | 1.44306 | 1.43612 | 1.44254 | 42448.0 |
| 2012-04-25 | E6 | Futures | 1.57563 | 1.58041 | 1.57277 | 1.57957 | 246699.0 |
| 2012-04-25 | E7 | Futures | 1.5606 | 1.5654 | 1.5578 | 1.5644 | 3700.0 |
| 2012-04-25 | EBM | Futures | 289.4 | 290.75 | 286.03 | 286.37 | 5299.0 |
| 2012-04-25 | ED | Futures | 95.0645 | 95.074 | 95.0549 | 95.0693 | 157313.0 |
| 2012-04-25 | ER | Futures | 97.518 | 97.538 | 97.518 | 97.533 | 105408.0 |
| 2012-04-25 | EW | Futures | 978.9 | 995.6 | 977.1 | 994.4 | 25933.0 |
| 2012-04-25 | FBTP | Futures | 65.52 | 66.02 | 65.39 | 65.66 | 13684.0 |
| 2012-04-25 | FBTS | Futures | 84.997 | 85.184 | 84.9 | 85.005 | 2126.0 |
| 2012-04-25 | FCE | Futures | 2247.1 | 2312.1 | 2243.5 | 2295.5 | 130735.0 |
| 2012-04-25 | FDAX | Futures | 7311.4 | 7451.8 | 7298.1 | 7429.1 | 157719.0 |
| 2012-04-25 | FESX | Futures | 1539.1 | 1575.0 | 1535.0 | 1564.0 | 1313745.0 |
| 2012-04-25 | FGBL | Futures | 115.22 | 115.3 | 114.83 | 114.96 | 863902.0 |
| 2012-04-25 | FGBM | Futures | 114.47 | 114.54 | 114.31 | 114.42 | 364143.0 |
| 2012-04-25 | FGBS | Futures | 110.089 | 110.143 | 110.089 | 110.128 | 330277.0 |
| 2012-04-25 | FGBX | Futures | 119.85 | 119.85 | 118.46 | 118.75 | 11780.0 |
| 2012-04-25 | FOAT | Futures | 94.49 | 94.93 | 94.38 | 94.75 | 15075.0 |
| 2012-04-25 | FTDX | Futures | 724.6 | 733.5 | 724.2 | 732.6 | 112.0 |
| 2012-04-25 | FTI | Futures | 260.6 | 264.81 | 260.34 | 263.47 | 34121.0 |
| 2012-04-25 | FTUK | Futures | 4138.5 | 4165.1 | 4133.0 | 4152.0 | 84410.0 |
| 2012-04-25 | FVSA | Futures | 9176.68 | 9209.75 | 9094.01 | 9110.55 | 1046.0 |
| 2012-04-25 | FXXP | Futures | 182.8 | 184.2 | 182.1 | 183.8 | 2108.0 |
| 2012-04-25 | G | Futures | 94.76 | 95.2 | 94.33 | 94.5 | 174129.0 |
| 2012-04-25 | GF | Futures | 309.323 | 311.302 | 307.917 | 309.531 | 2250.0 |
| 2012-04-25 | GSCI | Futures | 1070.93 | 1078.86 | 1068.78 | 1076.48 | 65.0 |
| 2012-04-25 | HE | Futures | 95.773 | 96.213 | 95.305 | 95.883 | 444.0 |
| 2012-04-25 | HG | Futures | 4.8207 | 4.8757 | 4.8062 | 4.8554 | 41602.0 |
| 2012-04-25 | HO | Futures | 2.5836 | 2.6048 | 2.5671 | 2.6034 | 65599.0 |
| 2012-04-25 | HRC | Futures | 2629.4 | 2629.4 | 2629.4 | 2629.4 | 0.0 |
| 2012-04-25 | J1 | Futures | 0.0154278 | 0.015473 | 0.0153539 | 0.0154266 | 96263.0 |
> showing 50 of 98 rows — these rows as CSV