PREVIEW / futures_daily / 2011-03-02
file: by_date/futures_daily/2011/2011-03-02.parquet size: 9 KB rows: 94
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-03-02 | ES | Futures | 1280.85 | 1293.16 | 1275.93 | 1285.28 | 2680941.0 |
| 2011-03-02 | NQ | Futures | 2623.97 | 2657.75 | 2613.19 | 2637.6 | 335530.0 |
| 2011-03-02 | YM | Futures | 11251.7 | 11329.4 | 11209.6 | 11274.2 | 127201.0 |
| 2011-03-02 | CL | Futures | 195.23 | 199.15 | 192.76 | 198.63 | 446378.0 |
| 2011-03-02 | GC | Futures | 1947.3 | 1955.6 | 1938.2 | 1951.1 | 160582.0 |
| 2011-03-02 | ZN | Futures | 100.283566 | 100.42655 | 99.789622 | 99.880612 | 100121.0 |
| 2011-03-02 | A6 | Futures | 0.85818 | 0.86208 | 0.85377 | 0.86081 | 93375.0 |
| 2011-03-02 | AD | Futures | 1.01795 | 1.02202 | 1.01488 | 1.02073 | 68830.0 |
| 2011-03-02 | B | Futures | 98.52 | 99.71 | 97.04 | 98.54 | 103313.0 |
| 2011-03-02 | B6 | Futures | 1.6868 | 1.6953 | 1.6819 | 1.6938 | 104401.0 |
| 2011-03-02 | BFX | Futures | 3118.8 | 3118.8 | 3086.2 | 3108.1 | 82.0 |
| 2011-03-02 | BR | Futures | 0.26081 | 0.26081 | 0.26002 | 0.26024 | 195.0 |
| 2011-03-02 | BZ | Futures | 102.95 | 104.79 | 102.94 | 103.8 | 1829.0 |
| 2011-03-02 | C | Futures | 2554.0 | 2573.0 | 2513.0 | 2572.0 | 2147.0 |
| 2011-03-02 | CB | Futures | 117.321 | 117.629 | 117.321 | 117.335 | 55.0 |
| 2011-03-02 | CC | Futures | 2912.0 | 2966.0 | 2876.0 | 2945.0 | 8089.0 |
| 2011-03-02 | CSC | Futures | 4.348 | 4.348 | 4.322 | 4.34 | 22.0 |
| 2011-03-02 | CT | Futures | 178.31 | 179.38 | 172.85 | 179.38 | 7391.0 |
| 2011-03-02 | DC | Futures | 29.46 | 29.46 | 29.08 | 29.17 | 70.0 |
| 2011-03-02 | DX | Futures | 76.941 | 77.071 | 76.402 | 76.551 | 32438.0 |
| 2011-03-02 | E1 | Futures | 1.41153 | 1.42464 | 1.41087 | 1.41913 | 61773.0 |
| 2011-03-02 | E6 | Futures | 1.62953 | 1.64325 | 1.62574 | 1.6397 | 336858.0 |
| 2011-03-02 | E7 | Futures | 1.6175 | 1.631 | 1.6138 | 1.6275 | 5400.0 |
| 2011-03-02 | EBM | Futures | 233.76 | 234.67 | 232.4 | 233.31 | 2252.0 |
| 2011-03-02 | ED | Futures | 94.8646 | 94.867 | 94.8622 | 94.8622 | 127401.0 |
| 2011-03-02 | ER | Futures | 97.286 | 97.296 | 97.281 | 97.291 | 80995.0 |
| 2011-03-02 | EW | Futures | 932.8 | 945.7 | 929.6 | 939.1 | 27221.0 |
| 2011-03-02 | FBTP | Futures | 63.66 | 63.77 | 63.6 | 63.73 | 8446.0 |
| 2011-03-02 | FCE | Futures | 2681.4 | 2694.7 | 2664.1 | 2681.7 | 165385.0 |
| 2011-03-02 | FDAX | Futures | 7662.5 | 7717.7 | 7630.4 | 7701.1 | 161737.0 |
| 2011-03-02 | FESX | Futures | 1833.4 | 1848.9 | 1826.5 | 1839.6 | 1465809.0 |
| 2011-03-02 | FEU3 | Futures | 97.845 | 97.85 | 97.845 | 97.85 | 252.0 |
| 2011-03-02 | FGBL | Futures | 98.5 | 98.59 | 97.95 | 98.1 | 991283.0 |
| 2011-03-02 | FGBM | Futures | 103.71 | 103.78 | 103.33 | 103.48 | 648647.0 |
| 2011-03-02 | FGBS | Futures | 106.66 | 106.675 | 106.571 | 106.601 | 590148.0 |
| 2011-03-02 | FGBX | Futures | 96.03 | 96.16 | 94.99 | 95.23 | 6548.0 |
| 2011-03-02 | FTDX | Futures | 783.3 | 790.7 | 775.8 | 790.3 | 1423.0 |
| 2011-03-02 | FTI | Futures | 294.74 | 296.32 | 294.34 | 295.47 | 50239.0 |
| 2011-03-02 | FTUK | Futures | 4069.7 | 4117.2 | 4062.7 | 4102.7 | 132349.0 |
| 2011-03-02 | FXXP | Futures | 183.4 | 183.9 | 182.4 | 183.6 | 1033.0 |
| 2011-03-02 | G | Futures | 80.93 | 81.09 | 80.68 | 80.7 | 118971.0 |
| 2011-03-02 | GF | Futures | 316.974 | 320.983 | 315.741 | 319.133 | 2161.0 |
| 2011-03-02 | GSCI | Futures | 1111.55 | 1120.97 | 1107.62 | 1117.05 | 148.0 |
| 2011-03-02 | HE | Futures | 102.622 | 103.351 | 101.893 | 102.972 | 18533.0 |
| 2011-03-02 | HG | Futures | 5.9473 | 6.0186 | 5.9327 | 5.9913 | 25069.0 |
| 2011-03-02 | HO | Futures | 2.5462 | 2.5803 | 2.5214 | 2.5596 | 22504.0 |
| 2011-03-02 | HRC | Futures | 3063.5 | 3063.5 | 3063.5 | 3063.5 | 0.0 |
| 2011-03-02 | J1 | Futures | 0.0153357 | 0.0153972 | 0.015293 | 0.0153382 | 133769.0 |
| 2011-03-02 | J7 | Futures | 0.015229 | 0.015286 | 0.015187 | 0.015229 | 566.0 |
| 2011-03-02 | JB | Futures | 120.35 | 120.82 | 120.29 | 120.76 | 2204.0 |
> showing 50 of 94 rows — these rows as CSV