PREVIEW / futures_daily / 2010-10-20
file: by_date/futures_daily/2010/2010-10-20.parquet size: 9 KB rows: 91
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-10-20 | ES | Futures | 1140.91 | 1156.59 | 1137.48 | 1151.44 | 2289137.0 |
| 2010-10-20 | NQ | Futures | 2344.89 | 2379.47 | 2338.65 | 2362.75 | 288963.0 |
| 2010-10-20 | YM | Futures | 10178.7 | 10330.3 | 10145.2 | 10294.0 | 147845.0 |
| 2010-10-20 | CL | Futures | 164.79 | 170.25 | 164.73 | 170.17 | 422745.0 |
| 2010-10-20 | GC | Futures | 1813.8 | 1832.4 | 1809.3 | 1827.1 | 162768.0 |
| 2010-10-20 | ZN | Futures | 104.832205 | 105.064477 | 104.612837 | 104.922533 | 962548.0 |
| 2010-10-20 | A6 | Futures | 0.80966 | 0.82477 | 0.80572 | 0.82234 | 123250.0 |
| 2010-10-20 | AD | Futures | 0.95795 | 0.96934 | 0.95607 | 0.96776 | 97818.0 |
| 2010-10-20 | B | Futures | 69.45 | 71.83 | 69.3 | 71.75 | 199633.0 |
| 2010-10-20 | B6 | Futures | 1.6295 | 1.6478 | 1.6237 | 1.6452 | 109383.0 |
| 2010-10-20 | BFX | Futures | 3033.3 | 3046.3 | 3027.4 | 3046.3 | 95.0 |
| 2010-10-20 | BR | Futures | 0.25306 | 0.2537 | 0.25298 | 0.2537 | 60.0 |
| 2010-10-20 | BZ | Futures | 74.93 | 76.31 | 74.44 | 76.29 | 258.0 |
| 2010-10-20 | C | Futures | 2019.0 | 2039.0 | 2009.0 | 2030.0 | 2740.0 |
| 2010-10-20 | CB | Futures | 99.978 | 101.644 | 99.978 | 101.644 | 5.0 |
| 2010-10-20 | CC | Futures | 2274.0 | 2318.0 | 2264.0 | 2299.0 | 6304.0 |
| 2010-10-20 | CT | Futures | 93.09 | 96.71 | 92.62 | 96.71 | 10950.0 |
| 2010-10-20 | DC | Futures | 24.22 | 24.76 | 24.22 | 24.72 | 336.0 |
| 2010-10-20 | DX | Futures | 78.84 | 78.86 | 77.526 | 77.661 | 32183.0 |
| 2010-10-20 | E1 | Futures | 1.35297 | 1.37227 | 1.35166 | 1.36413 | 39779.0 |
| 2010-10-20 | E6 | Futures | 1.62431 | 1.65388 | 1.61911 | 1.64998 | 438765.0 |
| 2010-10-20 | E7 | Futures | 1.6117 | 1.6412 | 1.6066 | 1.6375 | 7637.0 |
| 2010-10-20 | ED | Futures | 94.7078 | 94.7221 | 94.7031 | 94.7126 | 212233.0 |
| 2010-10-20 | ER | Futures | 97.178 | 97.183 | 97.139 | 97.154 | 194069.0 |
| 2010-10-20 | EW | Futures | 796.5 | 807.8 | 792.9 | 803.7 | 25841.0 |
| 2010-10-20 | FBTP | Futures | 67.83 | 67.85 | 67.62 | 67.7 | 5932.0 |
| 2010-10-20 | FCE | Futures | 2520.0 | 2543.9 | 2506.0 | 2535.3 | 116930.0 |
| 2010-10-20 | FDAX | Futures | 6990.8 | 7041.3 | 6960.1 | 7031.1 | 125105.0 |
| 2010-10-20 | FESX | Futures | 1764.4 | 1781.2 | 1755.6 | 1774.4 | 977128.0 |
| 2010-10-20 | FEU3 | Futures | 97.736 | 97.736 | 97.716 | 97.716 | 1.0 |
| 2010-10-20 | FGBL | Futures | 103.11 | 103.16 | 102.65 | 102.76 | 973226.0 |
| 2010-10-20 | FGBM | Futures | 106.26 | 106.3 | 105.9 | 105.99 | 581660.0 |
| 2010-10-20 | FGBS | Futures | 107.366 | 107.381 | 107.228 | 107.248 | 746907.0 |
| 2010-10-20 | FGBX | Futures | 105.83 | 106.25 | 105.43 | 105.76 | 6646.0 |
| 2010-10-20 | FTDX | Futures | 698.1 | 703.3 | 692.3 | 703.3 | 339.0 |
| 2010-10-20 | FTI | Futures | 271.01 | 271.89 | 269.65 | 271.25 | 22929.0 |
| 2010-10-20 | FTUK | Futures | 3906.6 | 3956.3 | 3898.6 | 3943.9 | 84526.0 |
| 2010-10-20 | G | Futures | 84.43 | 84.61 | 84.23 | 84.39 | 143295.0 |
| 2010-10-20 | GF | Futures | 279.663 | 279.663 | 277.46 | 277.712 | 1384.0 |
| 2010-10-20 | GSCI | Futures | 920.51 | 933.88 | 914.73 | 933.72 | 595.0 |
| 2010-10-20 | HE | Futures | 91.885 | 93.982 | 91.716 | 93.001 | 15951.0 |
| 2010-10-20 | HG | Futures | 4.9751 | 5.0958 | 4.965 | 5.0631 | 33685.0 |
| 2010-10-20 | HO | Futures | 1.8631 | 1.9181 | 1.8629 | 1.9175 | 48260.0 |
| 2010-10-20 | HRC | Futures | 2527.3 | 2527.3 | 2527.3 | 2527.3 | 0.0 |
| 2010-10-20 | J1 | Futures | 0.0154011 | 0.0155455 | 0.0153885 | 0.0154815 | 104738.0 |
| 2010-10-20 | J7 | Futures | 0.015294 | 0.015436 | 0.015284 | 0.015375 | 309.0 |
| 2010-10-20 | JB | Futures | 122.34 | 122.53 | 122.29 | 122.38 | 980.0 |
| 2010-10-20 | KC | Futures | 471.18 | 491.39 | 470.93 | 487.92 | 15456.0 |
| 2010-10-20 | KE | Futures | 2991.37 | 3059.17 | 2991.37 | 3045.61 | 10490.0 |
| 2010-10-20 | L | Futures | 98.155 | 98.165 | 98.135 | 98.155 | 34050.0 |
> showing 50 of 91 rows — these rows as CSV