PREVIEW / futures_daily / 2011-03-10
file: by_date/futures_daily/2011/2011-03-10.parquet size: 9 KB rows: 93
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-10 | ES | Futures | 1295.12 | 1296.6 | 1272.49 | 1273.96 | 2605190.0 |
| 2011-03-10 | NQ | Futures | 2625.11 | 2628.8 | 2583.1 | 2591.9 | 346788.0 |
| 2011-03-10 | YM | Futures | 11394.0 | 11402.5 | 11189.0 | 11206.9 | 55445.0 |
| 2011-03-10 | CL | Futures | 202.94 | 204.13 | 195.5 | 199.54 | 432988.0 |
| 2011-03-10 | GC | Futures | 1942.2 | 1943.1 | 1904.0 | 1916.9 | 204144.0 |
| 2011-03-10 | ZN | Futures | 100.196989 | 101.026587 | 100.157484 | 100.815895 | 1533954.0 |
| 2011-03-10 | A6 | Futures | 0.85665 | 0.85768 | 0.84687 | 0.84799 | 100522.0 |
| 2011-03-10 | AD | Futures | 1.0246 | 1.0261 | 1.01723 | 1.01913 | 82888.0 |
| 2011-03-10 | B | Futures | 98.56 | 98.87 | 96.2 | 97.84 | 169056.0 |
| 2011-03-10 | B6 | Futures | 1.6798 | 1.6826 | 1.6643 | 1.6654 | 117331.0 |
| 2011-03-10 | BR | Futures | 0.26024 | 0.26026 | 0.25971 | 0.26026 | 162.0 |
| 2011-03-10 | BZ | Futures | 102.17 | 103.83 | 101.49 | 103.07 | 1968.0 |
| 2011-03-10 | C | Futures | 2463.0 | 2487.0 | 2382.0 | 2478.0 | 18035.0 |
| 2011-03-10 | CB | Futures | 124.082 | 124.082 | 123.789 | 124.082 | 3.0 |
| 2011-03-10 | CC | Futures | 2812.0 | 2821.0 | 2675.0 | 2769.0 | 17513.0 |
| 2011-03-10 | CSC | Futures | 4.26 | 4.268 | 4.26 | 4.268 | 2.0 |
| 2011-03-10 | CT | Futures | 182.79 | 185.74 | 179.18 | 179.72 | 9666.0 |
| 2011-03-10 | DC | Futures | 29.17 | 29.31 | 28.57 | 28.76 | 264.0 |
| 2011-03-10 | DX | Futures | 76.581 | 77.253 | 76.526 | 77.17 | 27451.0 |
| 2011-03-10 | E1 | Futures | 1.40956 | 1.41179 | 1.39935 | 1.40603 | 52940.0 |
| 2011-03-10 | E6 | Futures | 1.64479 | 1.6468 | 1.62939 | 1.63176 | 224783.0 |
| 2011-03-10 | E7 | Futures | 1.6325 | 1.6345 | 1.6173 | 1.6196 | 2497.0 |
| 2011-03-10 | EBM | Futures | 217.0 | 217.23 | 206.66 | 212.53 | 14601.0 |
| 2011-03-10 | ED | Futures | 94.8645 | 94.8692 | 94.855 | 94.8645 | 225160.0 |
| 2011-03-10 | ER | Futures | 97.227 | 97.247 | 97.222 | 97.242 | 151054.0 |
| 2011-03-10 | EW | Futures | 945.9 | 949.6 | 933.4 | 938.4 | 45942.0 |
| 2011-03-10 | FBTP | Futures | 62.95 | 63.05 | 62.73 | 62.99 | 6700.0 |
| 2011-03-10 | FCE | Futures | 2641.5 | 2645.5 | 2617.3 | 2633.9 | 182079.0 |
| 2011-03-10 | FDAX | Futures | 7589.7 | 7615.4 | 7520.6 | 7554.9 | 187794.0 |
| 2011-03-10 | FESX | Futures | 1822.2 | 1823.5 | 1801.0 | 1813.2 | 108069.0 |
| 2011-03-10 | FEU3 | Futures | 97.77 | 97.785 | 97.77 | 97.785 | 218.0 |
| 2011-03-10 | FGBL | Futures | 97.47 | 97.83 | 97.4 | 97.64 | 965677.0 |
| 2011-03-10 | FGBM | Futures | 102.84 | 103.15 | 102.81 | 103.02 | 504221.0 |
| 2011-03-10 | FGBS | Futures | 106.285 | 106.389 | 106.266 | 106.345 | 608123.0 |
| 2011-03-10 | FGBX | Futures | 93.97 | 94.87 | 93.97 | 94.69 | 3190.0 |
| 2011-03-10 | FTDX | Futures | 785.0 | 785.9 | 785.0 | 785.9 | 1.0 |
| 2011-03-10 | FTI | Futures | 296.24 | 296.24 | 292.45 | 293.83 | 1536.0 |
| 2011-03-10 | FTUK | Futures | 4123.5 | 4123.5 | 4043.0 | 4057.4 | 63780.0 |
| 2011-03-10 | FXXP | Futures | 182.7 | 182.7 | 182.7 | 182.7 | 13492.0 |
| 2011-03-10 | G | Futures | 81.05 | 81.23 | 80.89 | 81.19 | 108749.0 |
| 2011-03-10 | GF | Futures | 326.101 | 326.888 | 323.137 | 324.77 | 2411.0 |
| 2011-03-10 | GSCI | Futures | 1119.4 | 1119.4 | 1098.27 | 1109.54 | 2547.0 |
| 2011-03-10 | HE | Futures | 104.664 | 105.743 | 103.555 | 104.839 | 26613.0 |
| 2011-03-10 | HG | Futures | 5.6143 | 5.633 | 5.5091 | 5.591 | 40450.0 |
| 2011-03-10 | HO | Futures | 2.5668 | 2.5832 | 2.5031 | 2.5486 | 19403.0 |
| 2011-03-10 | HRC | Futures | 3081.2 | 3081.2 | 3081.2 | 3081.2 | 0.0 |
| 2011-03-10 | J1 | Futures | 0.0151875 | 0.0152001 | 0.0151121 | 0.0151448 | 97712.0 |
| 2011-03-10 | J7 | Futures | 0.01508 | 0.015094 | 0.015022 | 0.015052 | 309.0 |
| 2011-03-10 | JB | Futures | 120.65 | 120.78 | 120.46 | 120.72 | 2618.0 |
| 2011-03-10 | KC | Futures | 715.23 | 715.23 | 675.36 | 679.97 | 16031.0 |
> showing 50 of 93 rows — these rows as CSV