PREVIEW / futures_daily / 2010-06-02
file: by_date/futures_daily/2010/2010-06-02.parquet size: 9 KB rows: 88
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-02 | ES | Futures | 1041.22 | 1069.46 | 1039.27 | 1068.0 | 2214865.0 |
| 2010-06-02 | NQ | Futures | 2078.28 | 2131.88 | 2074.31 | 2131.6 | 307154.0 |
| 2010-06-02 | YM | Futures | 9210.1 | 9418.8 | 9193.6 | 9405.9 | 129149.0 |
| 2010-06-02 | CL | Futures | 157.42 | 161.77 | 156.85 | 159.43 | 391034.0 |
| 2010-06-02 | GC | Futures | 1674.7 | 1676.3 | 1657.3 | 1667.7 | 90250.0 |
| 2010-06-02 | ZN | Futures | 98.687627 | 98.751395 | 98.164728 | 98.254003 | 127566.0 |
| 2010-06-02 | A6 | Futures | 0.68063 | 0.69031 | 0.67817 | 0.68547 | 106791.0 |
| 2010-06-02 | AD | Futures | 0.93602 | 0.95172 | 0.93355 | 0.94915 | 89861.0 |
| 2010-06-02 | B | Futures | 64.19 | 66.21 | 63.88 | 65.45 | 88419.0 |
| 2010-06-02 | B6 | Futures | 1.5206 | 1.5337 | 1.511 | 1.5203 | 133683.0 |
| 2010-06-02 | BFX | Futures | 2786.6 | 2819.4 | 2778.4 | 2813.8 | 391.0 |
| 2010-06-02 | BZ | Futures | 70.59 | 70.59 | 70.59 | 70.59 | 2.0 |
| 2010-06-02 | C | Futures | 2425.0 | 2507.0 | 2424.0 | 2504.0 | 6651.0 |
| 2010-06-02 | CC | Futures | 2500.0 | 2562.0 | 2497.0 | 2555.0 | 11454.0 |
| 2010-06-02 | CT | Futures | 62.79 | 63.17 | 62.25 | 62.31 | 16851.0 |
| 2010-06-02 | DC | Futures | 22.23 | 22.6 | 22.22 | 22.52 | 82.0 |
| 2010-06-02 | DX | Futures | 87.97 | 88.431 | 87.853 | 88.038 | 16985.0 |
| 2010-06-02 | E1 | Futures | 1.13772 | 1.14193 | 1.13469 | 1.13916 | 32807.0 |
| 2010-06-02 | E6 | Futures | 1.44514 | 1.45223 | 1.44029 | 1.44798 | 333002.0 |
| 2010-06-02 | E7 | Futures | 1.4332 | 1.4401 | 1.4285 | 1.4361 | 5242.0 |
| 2010-06-02 | ED | Futures | 94.1907 | 94.2144 | 94.1884 | 94.2073 | 127196.0 |
| 2010-06-02 | ER | Futures | 97.36 | 97.37 | 97.355 | 97.36 | 65760.0 |
| 2010-06-02 | EW | Futures | 721.4 | 742.8 | 721.4 | 740.4 | 31524.0 |
| 2010-06-02 | FBTP | Futures | 64.0 | 64.0 | 63.54 | 63.57 | 7211.0 |
| 2010-06-02 | FCE | Futures | 2286.4 | 2349.0 | 2267.5 | 2313.2 | 131590.0 |
| 2010-06-02 | FDAX | Futures | 6440.3 | 6569.8 | 6382.7 | 6508.3 | 166544.0 |
| 2010-06-02 | FESX | Futures | 1570.2 | 1614.9 | 1557.9 | 1591.0 | 1400844.0 |
| 2010-06-02 | FEU3 | Futures | 97.924 | 97.924 | 97.919 | 97.919 | 79.0 |
| 2010-06-02 | FGBL | Futures | 100.45 | 100.81 | 100.38 | 100.52 | 1102957.0 |
| 2010-06-02 | FGBM | Futures | 104.91 | 105.08 | 104.87 | 104.94 | 579803.0 |
| 2010-06-02 | FGBS | Futures | 107.623 | 107.662 | 107.613 | 107.638 | 789959.0 |
| 2010-06-02 | FGBX | Futures | 99.65 | 100.14 | 99.45 | 99.78 | 10079.0 |
| 2010-06-02 | FTDX | Futures | 649.2 | 663.3 | 647.4 | 654.9 | 911.0 |
| 2010-06-02 | FTI | Futures | 249.37 | 257.39 | 248.89 | 253.77 | 39429.0 |
| 2010-06-02 | FTUK | Futures | 3439.4 | 3529.8 | 3431.3 | 3481.7 | 134322.0 |
| 2010-06-02 | G | Futures | 79.64 | 80.04 | 79.48 | 79.8 | 96983.0 |
| 2010-06-02 | GF | Futures | 276.045 | 278.066 | 274.719 | 276.992 | 2432.0 |
| 2010-06-02 | GSCI | Futures | 837.08 | 847.69 | 829.77 | 840.03 | 321.0 |
| 2010-06-02 | HE | Futures | 103.074 | 103.856 | 102.604 | 102.823 | 17103.0 |
| 2010-06-02 | HG | Futures | 4.1281 | 4.1621 | 4.0338 | 4.1288 | 30064.0 |
| 2010-06-02 | HO | Futures | 1.761 | 1.8088 | 1.7528 | 1.7966 | 7921.0 |
| 2010-06-02 | HRC | Futures | 3017.0 | 3017.0 | 3017.0 | 3017.0 | 0.0 |
| 2010-06-02 | J1 | Futures | 0.0138228 | 0.0138228 | 0.0136141 | 0.0136405 | 131956.0 |
| 2010-06-02 | J7 | Futures | 0.013699 | 0.013704 | 0.013508 | 0.013532 | 435.0 |
| 2010-06-02 | JB | Futures | 119.51 | 119.56 | 119.35 | 119.49 | 3255.0 |
| 2010-06-02 | KC | Futures | 346.67 | 350.61 | 343.24 | 343.75 | 15163.0 |
| 2010-06-02 | KE | Futures | 2078.09 | 2093.3 | 2054.17 | 2059.61 | 15623.0 |
| 2010-06-02 | L | Futures | 97.947 | 97.947 | 97.908 | 97.918 | 59624.0 |
| 2010-06-02 | LBS | Futures | 690.2 | 705.4 | 684.9 | 690.2 | 1211.0 |
| 2010-06-02 | LE | Futures | 145.844 | 148.041 | 145.641 | 147.675 | 19847.0 |
> showing 50 of 88 rows — these rows as CSV