PREVIEW / futures_daily / 2011-06-03
file: by_date/futures_daily/2011/2011-06-03.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-06-03 | ES | Futures | 1299.14 | 1300.38 | 1281.57 | 1283.3 | 2677734.0 |
| 2011-06-03 | NQ | Futures | 2648.76 | 2651.33 | 2602.07 | 2605.2 | 288850.0 |
| 2011-06-03 | YM | Futures | 11504.0 | 11515.3 | 11359.2 | 11399.6 | 124048.0 |
| 2011-06-03 | CL | Futures | 193.78 | 193.78 | 188.5 | 192.53 | 351309.0 |
| 2011-06-03 | GC | Futures | 2077.5 | 2095.6 | 2063.8 | 2087.5 | 153260.0 |
| 2011-06-03 | ZN | Futures | 104.858539 | 105.51695 | 104.832202 | 105.121903 | 88311.0 |
| 2011-06-03 | A6 | Futures | 0.91411 | 0.9232 | 0.90759 | 0.91943 | 165195.0 |
| 2011-06-03 | AD | Futures | 1.02042 | 1.02152 | 1.01036 | 1.01863 | 119834.0 |
| 2011-06-03 | B | Futures | 98.72 | 99.14 | 96.71 | 98.78 | 83067.0 |
| 2011-06-03 | B6 | Futures | 1.7007 | 1.7077 | 1.6914 | 1.7053 | 109334.0 |
| 2011-06-03 | BFX | Futures | 3098.8 | 3111.0 | 3081.0 | 3103.9 | 597.0 |
| 2011-06-03 | BR | Futures | 0.27706 | 0.2782 | 0.27573 | 0.27818 | 639.0 |
| 2011-06-03 | BZ | Futures | 101.71 | 103.35 | 101.1 | 103.01 | 522.0 |
| 2011-06-03 | C | Futures | 1952.0 | 1954.0 | 1925.0 | 1935.0 | 5288.0 |
| 2011-06-03 | CC | Futures | 2309.0 | 2313.0 | 2270.0 | 2291.0 | 10764.0 |
| 2011-06-03 | CT | Futures | 163.54 | 166.77 | 159.02 | 159.98 | 12378.0 |
| 2011-06-03 | DC | Futures | 31.83 | 32.05 | 31.32 | 31.53 | 288.0 |
| 2011-06-03 | DX | Futures | 73.994 | 74.133 | 73.357 | 73.439 | 35136.0 |
| 2011-06-03 | E1 | Futures | 1.55451 | 1.57193 | 1.55032 | 1.56577 | 50175.0 |
| 2011-06-03 | E6 | Futures | 1.71586 | 1.73422 | 1.71136 | 1.73197 | 364897.0 |
| 2011-06-03 | E7 | Futures | 1.7034 | 1.7214 | 1.6989 | 1.7191 | 6642.0 |
| 2011-06-03 | ED | Futures | 94.9644 | 94.9668 | 94.9621 | 94.9644 | 88818.0 |
| 2011-06-03 | ER | Futures | 97.326 | 97.341 | 97.316 | 97.321 | 142515.0 |
| 2011-06-03 | EW | Futures | 967.3 | 968.3 | 953.2 | 954.5 | 27144.0 |
| 2011-06-03 | FBTP | Futures | 65.51 | 65.89 | 65.46 | 65.83 | 10452.0 |
| 2011-06-03 | FCE | Futures | 2698.5 | 2703.0 | 2658.9 | 2690.9 | 152784.0 |
| 2011-06-03 | FDAX | Futures | 7581.6 | 7633.4 | 7499.4 | 7584.8 | 161102.0 |
| 2011-06-03 | FESX | Futures | 1787.6 | 1793.4 | 1759.4 | 1783.1 | 1541218.0 |
| 2011-06-03 | FEU3 | Futures | 97.865 | 97.865 | 97.865 | 97.865 | 9.0 |
| 2011-06-03 | FGBL | Futures | 100.4 | 100.85 | 100.04 | 100.2 | 1526608.0 |
| 2011-06-03 | FGBM | Futures | 104.59 | 104.93 | 104.29 | 104.44 | 901680.0 |
| 2011-06-03 | FGBS | Futures | 106.776 | 106.905 | 106.692 | 106.741 | 1031726.0 |
| 2011-06-03 | FGBX | Futures | 97.56 | 98.42 | 96.94 | 97.27 | 13108.0 |
| 2011-06-03 | FTDX | Futures | 802.0 | 809.2 | 799.3 | 806.0 | 631.0 |
| 2011-06-03 | FTI | Futures | 280.33 | 280.45 | 276.6 | 278.9 | 39197.0 |
| 2011-06-03 | FTUK | Futures | 4114.7 | 4115.8 | 4061.6 | 4094.8 | 116971.0 |
| 2011-06-03 | FXXP | Futures | 183.8 | 184.7 | 181.9 | 183.1 | 1557.0 |
| 2011-06-03 | G | Futures | 84.17 | 84.53 | 84.0 | 84.14 | 105208.0 |
| 2011-06-03 | GF | Futures | 288.063 | 290.329 | 285.855 | 288.76 | 2221.0 |
| 2011-06-03 | GSCI | Futures | 1088.3 | 1098.95 | 1081.42 | 1098.95 | 251.0 |
| 2011-06-03 | HE | Futures | 94.183 | 94.476 | 93.196 | 93.73 | 11582.0 |
| 2011-06-03 | HG | Futures | 5.4444 | 5.5049 | 5.378 | 5.4929 | 40578.0 |
| 2011-06-03 | HO | Futures | 2.4926 | 2.504 | 2.4444 | 2.5001 | 11934.0 |
| 2011-06-03 | HRC | Futures | 3118.0 | 3118.0 | 3118.0 | 3118.0 | 10.0 |
| 2011-06-03 | J1 | Futures | 0.0155229 | 0.0156951 | 0.0155091 | 0.0156536 | 138658.0 |
| 2011-06-03 | J7 | Futures | 0.015413 | 0.015598 | 0.015413 | 0.015558 | 439.0 |
| 2011-06-03 | JB | Futures | 122.8 | 122.88 | 122.64 | 122.88 | 5833.0 |
| 2011-06-03 | KC | Futures | 626.47 | 656.57 | 615.92 | 649.73 | 19000.0 |
| 2011-06-03 | KE | Futures | 3594.2 | 3644.56 | 3553.71 | 3610.98 | 14628.0 |
| 2011-06-03 | L | Futures | 98.413 | 98.443 | 98.413 | 98.433 | 30241.0 |
> showing 50 of 94 rows — these rows as CSV