PREVIEW / futures_daily / 2011-06-15
file: by_date/futures_daily/2011/2011-06-15.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-15 | ES | Futures | 1274.94 | 1274.94 | 1247.13 | 1251.35 | 3639073.0 |
| 2011-06-15 | NQ | Futures | 2557.08 | 2558.5 | 2504.98 | 2510.96 | 408611.0 |
| 2011-06-15 | YM | Futures | 11356.2 | 11357.2 | 11147.3 | 11185.1 | 188290.0 |
| 2011-06-15 | CL | Futures | 191.88 | 192.63 | 181.27 | 182.78 | 222394.0 |
| 2011-06-15 | GC | Futures | 2064.1 | 2078.5 | 2049.8 | 2065.6 | 152879.0 |
| 2011-06-15 | ZN | Futures | 104.377508 | 105.441906 | 104.350899 | 105.322162 | 1939190.0 |
| 2011-06-15 | A6 | Futures | 0.91778 | 0.92074 | 0.90508 | 0.90621 | 145666.0 |
| 2011-06-15 | AD | Futures | 1.0278 | 1.0296 | 1.01303 | 1.01483 | 136548.0 |
| 2011-06-15 | B | Futures | 101.89 | 102.14 | 96.1 | 96.69 | 303648.0 |
| 2011-06-15 | B6 | Futures | 1.7012 | 1.7023 | 1.6798 | 1.6811 | 142039.0 |
| 2011-06-15 | BFX | Futures | 3069.4 | 3069.4 | 3034.7 | 3041.6 | 492.0 |
| 2011-06-15 | BR | Futures | 0.27559 | 0.27559 | 0.27394 | 0.27394 | 100.0 |
| 2011-06-15 | BZ | Futures | 104.63 | 105.2 | 100.77 | 100.82 | 972.0 |
| 2011-06-15 | C | Futures | 2014.0 | 2029.0 | 1994.0 | 1998.0 | 9482.0 |
| 2011-06-15 | CB | Futures | 116.71 | 116.71 | 115.203 | 115.614 | 51.0 |
| 2011-06-15 | CC | Futures | 2386.0 | 2389.0 | 2326.0 | 2358.0 | 9120.0 |
| 2011-06-15 | CT | Futures | 153.91 | 156.38 | 148.75 | 150.4 | 8246.0 |
| 2011-06-15 | DC | Futures | 31.05 | 31.07 | 30.57 | 30.57 | 209.0 |
| 2011-06-15 | DX | Futures | 74.098 | 75.4 | 74.098 | 75.338 | 40965.0 |
| 2011-06-15 | E1 | Futures | 1.5481 | 1.54993 | 1.53032 | 1.53385 | 55348.0 |
| 2011-06-15 | E6 | Futures | 1.71039 | 1.71146 | 1.67677 | 1.67844 | 412224.0 |
| 2011-06-15 | E7 | Futures | 1.6977 | 1.6987 | 1.6643 | 1.6662 | 6007.0 |
| 2011-06-15 | ED | Futures | 94.9668 | 94.9716 | 94.9144 | 94.9191 | 696523.0 |
| 2011-06-15 | ER | Futures | 97.311 | 97.331 | 97.272 | 97.296 | 228117.0 |
| 2011-06-15 | EW | Futures | 937.0 | 937.4 | 917.7 | 920.2 | 38835.0 |
| 2011-06-15 | FBTP | Futures | 65.27 | 65.3 | 64.94 | 64.95 | 7422.0 |
| 2011-06-15 | FCE | Futures | 2678.1 | 2680.9 | 2616.9 | 2643.7 | 140031.0 |
| 2011-06-15 | FDAX | Futures | 7679.3 | 7692.1 | 7551.7 | 7603.0 | 251111.0 |
| 2011-06-15 | FESX | Futures | 1781.2 | 1782.5 | 1735.0 | 1753.0 | 1382582.0 |
| 2011-06-15 | FEU3 | Futures | 97.85 | 97.85 | 97.835 | 97.835 | 7.0 |
| 2011-06-15 | FGBL | Futures | 100.77 | 101.36 | 100.65 | 101.04 | 1074519.0 |
| 2011-06-15 | FGBM | Futures | 105.13 | 105.6 | 105.08 | 105.41 | 666794.0 |
| 2011-06-15 | FGBS | Futures | 106.985 | 107.214 | 106.98 | 107.134 | 888272.0 |
| 2011-06-15 | FGBX | Futures | 96.08 | 96.98 | 95.57 | 96.32 | 7190.0 |
| 2011-06-15 | FTDX | Futures | 795.3 | 795.8 | 784.6 | 788.2 | 5208.0 |
| 2011-06-15 | FTI | Futures | 276.68 | 277.13 | 272.5 | 274.42 | 27784.0 |
| 2011-06-15 | FTUK | Futures | 4076.1 | 4076.1 | 3990.0 | 4030.6 | 156019.0 |
| 2011-06-15 | FXXP | Futures | 182.7 | 182.8 | 181.0 | 181.1 | 9507.0 |
| 2011-06-15 | G | Futures | 84.36 | 84.74 | 84.06 | 84.53 | 147155.0 |
| 2011-06-15 | GF | Futures | 296.487 | 298.637 | 293.989 | 295.093 | 3038.0 |
| 2011-06-15 | GSCI | Futures | 1096.31 | 1101.91 | 1062.24 | 1070.68 | 945.0 |
| 2011-06-15 | HE | Futures | 100.798 | 102.158 | 100.665 | 101.625 | 12996.0 |
| 2011-06-15 | HG | Futures | 5.5228 | 5.5574 | 5.4451 | 5.4763 | 38685.0 |
| 2011-06-15 | HO | Futures | 2.5555 | 2.5555 | 2.4314 | 2.4419 | 11316.0 |
| 2011-06-15 | HRC | Futures | 3068.8 | 3068.8 | 3068.8 | 3068.8 | 0.0 |
| 2011-06-15 | J1 | Futures | 0.0156184 | 0.0156435 | 0.0155116 | 0.0155367 | 134899.0 |
| 2011-06-15 | J7 | Futures | 0.015522 | 0.015541 | 0.015412 | 0.015433 | 433.0 |
| 2011-06-15 | JB | Futures | 122.61 | 122.61 | 122.37 | 122.42 | 1827.0 |
| 2011-06-15 | KC | Futures | 641.94 | 647.46 | 624.32 | 629.83 | 8536.0 |
| 2011-06-15 | KE | Futures | 3317.72 | 3330.56 | 3217.99 | 3235.77 | 19470.0 |
> showing 50 of 94 rows — these rows as CSV