PREVIEW / futures_daily / 2010-10-07
file: by_date/futures_daily/2010/2010-10-07.parquet size: 9 KB rows: 90
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-07 | ES | Futures | 1132.82 | 1140.66 | 1124.49 | 1133.56 | 1988730.0 |
| 2010-10-07 | NQ | Futures | 2272.6 | 2290.18 | 2260.7 | 2283.66 | 285357.0 |
| 2010-10-07 | YM | Futures | 10147.0 | 10211.2 | 10081.9 | 10153.5 | 133681.0 |
| 2010-10-07 | CL | Futures | 173.5 | 175.91 | 168.77 | 170.16 | 450952.0 |
| 2010-10-07 | GC | Futures | 1835.7 | 1856.7 | 1803.1 | 1814.6 | 267432.0 |
| 2010-10-07 | ZN | Futures | 104.987053 | 105.193518 | 104.883821 | 104.999957 | 1027586.0 |
| 2010-10-07 | A6 | Futures | 0.81361 | 0.82594 | 0.81268 | 0.81713 | 106939.0 |
| 2010-10-07 | AD | Futures | 0.97846 | 0.98153 | 0.96855 | 0.97122 | 98305.0 |
| 2010-10-07 | B | Futures | 73.32 | 74.02 | 71.4 | 71.84 | 145570.0 |
| 2010-10-07 | B6 | Futures | 1.6482 | 1.6623 | 1.6421 | 1.6476 | 129770.0 |
| 2010-10-07 | BFX | Futures | 2985.5 | 2996.5 | 2971.4 | 2977.9 | 92.0 |
| 2010-10-07 | BR | Futures | 0.25285 | 0.25285 | 0.25071 | 0.25076 | 80.0 |
| 2010-10-07 | BZ | Futures | 78.1 | 78.1 | 75.94 | 76.39 | 124.0 |
| 2010-10-07 | C | Futures | 2026.0 | 2042.0 | 2007.0 | 2008.0 | 3883.0 |
| 2010-10-07 | CC | Futures | 2273.0 | 2314.0 | 2265.0 | 2269.0 | 6344.0 |
| 2010-10-07 | CT | Futures | 84.47 | 87.82 | 84.34 | 87.82 | 17113.0 |
| 2010-10-07 | DC | Futures | 25.44 | 25.49 | 25.25 | 25.34 | 129.0 |
| 2010-10-07 | DX | Futures | 77.953 | 78.188 | 77.396 | 77.889 | 32037.0 |
| 2010-10-07 | E1 | Futures | 1.3661 | 1.37647 | 1.35402 | 1.35914 | 52427.0 |
| 2010-10-07 | E6 | Futures | 1.64619 | 1.65861 | 1.63815 | 1.64679 | 449914.0 |
| 2010-10-07 | E7 | Futures | 1.6339 | 1.646 | 1.6258 | 1.6343 | 6548.0 |
| 2010-10-07 | ED | Futures | 94.7363 | 94.7458 | 94.7363 | 94.7363 | 177071.0 |
| 2010-10-07 | ER | Futures | 97.267 | 97.276 | 97.242 | 97.252 | 140122.0 |
| 2010-10-07 | EW | Futures | 789.8 | 796.5 | 783.9 | 790.3 | 25331.0 |
| 2010-10-07 | FBTP | Futures | 67.77 | 67.88 | 67.56 | 67.69 | 1940.0 |
| 2010-10-07 | FCE | Futures | 2460.6 | 2493.7 | 2448.5 | 2475.4 | 141660.0 |
| 2010-10-07 | FDAX | Futures | 6733.7 | 6811.1 | 6714.3 | 6754.7 | 141906.0 |
| 2010-10-07 | FESX | Futures | 1722.5 | 1746.9 | 1713.2 | 1731.3 | 1222519.0 |
| 2010-10-07 | FEU3 | Futures | 97.82 | 97.82 | 97.815 | 97.815 | 60.0 |
| 2010-10-07 | FGBL | Futures | 104.23 | 104.3 | 103.9 | 104.1 | 909723.0 |
| 2010-10-07 | FGBM | Futures | 106.75 | 106.8 | 106.53 | 106.68 | 441592.0 |
| 2010-10-07 | FGBS | Futures | 107.573 | 107.598 | 107.44 | 107.519 | 429378.0 |
| 2010-10-07 | FGBX | Futures | 108.68 | 108.75 | 107.61 | 108.02 | 3272.0 |
| 2010-10-07 | FTDX | Futures | 676.1 | 683.1 | 676.1 | 679.6 | 686.0 |
| 2010-10-07 | FTI | Futures | 269.25 | 272.1 | 267.69 | 270.77 | 33844.0 |
| 2010-10-07 | FTUK | Futures | 3913.8 | 3931.1 | 3878.2 | 3898.3 | 97486.0 |
| 2010-10-07 | G | Futures | 84.77 | 84.89 | 84.58 | 84.72 | 86059.0 |
| 2010-10-07 | GF | Futures | 274.749 | 274.937 | 273.554 | 273.931 | 1985.0 |
| 2010-10-07 | GSCI | Futures | 939.76 | 943.6 | 915.4 | 920.24 | 1927.0 |
| 2010-10-07 | HE | Futures | 97.163 | 97.941 | 95.471 | 96.486 | 25643.0 |
| 2010-10-07 | HG | Futures | 5.0218 | 5.0511 | 4.8803 | 4.911 | 41651.0 |
| 2010-10-07 | HO | Futures | 1.9674 | 1.9837 | 1.9075 | 1.917 | 34369.0 |
| 2010-10-07 | HRC | Futures | 2572.4 | 2572.4 | 2572.4 | 2572.4 | 0.0 |
| 2010-10-07 | J1 | Futures | 0.0151637 | 0.0153069 | 0.0151348 | 0.0152642 | 116516.0 |
| 2010-10-07 | J7 | Futures | 0.015051 | 0.015199 | 0.01503 | 0.015159 | 358.0 |
| 2010-10-07 | JB | Futures | 122.76 | 122.86 | 122.46 | 122.46 | 2329.0 |
| 2010-10-07 | KC | Futures | 436.71 | 441.92 | 429.64 | 430.14 | 9057.0 |
| 2010-10-07 | KE | Futures | 2905.84 | 2978.85 | 2904.8 | 2918.36 | 10428.0 |
| 2010-10-07 | L | Futures | 98.165 | 98.175 | 98.135 | 98.165 | 51548.0 |
| 2010-10-07 | LBS | Futures | 647.0 | 659.2 | 635.9 | 648.7 | 555.0 |
> showing 50 of 90 rows — these rows as CSV