PREVIEW / futures_daily / 2010-10-06
file: by_date/futures_daily/2010/2010-10-06.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-06 | ES | Futures | 1132.09 | 1136.99 | 1128.17 | 1132.82 | 1720880.0 |
| 2010-10-06 | NQ | Futures | 2289.05 | 2295.57 | 2256.73 | 2272.6 | 334881.0 |
| 2010-10-06 | YM | Futures | 10109.8 | 10157.2 | 10103.3 | 10147.9 | 125528.0 |
| 2010-10-06 | CL | Futures | 172.1 | 175.2 | 171.45 | 173.41 | 349174.0 |
| 2010-10-06 | GC | Futures | 1823.2 | 1836.4 | 1821.4 | 1831.9 | 136375.0 |
| 2010-10-06 | ZN | Futures | 104.612837 | 105.270942 | 104.561221 | 104.961245 | 1304437.0 |
| 2010-10-06 | A6 | Futures | 0.80865 | 0.81512 | 0.80698 | 0.81327 | 78820.0 |
| 2010-10-06 | AD | Futures | 0.9736 | 0.98301 | 0.97291 | 0.97964 | 103189.0 |
| 2010-10-06 | B | Futures | 72.91 | 73.86 | 72.43 | 73.2 | 144977.0 |
| 2010-10-06 | B6 | Futures | 1.6485 | 1.654 | 1.6427 | 1.6491 | 91265.0 |
| 2010-10-06 | BFX | Futures | 2973.0 | 2993.5 | 2972.7 | 2990.5 | 117.0 |
| 2010-10-06 | BR | Futures | 0.25272 | 0.25272 | 0.25093 | 0.25093 | 234.0 |
| 2010-10-06 | BZ | Futures | 77.39 | 78.51 | 77.19 | 77.83 | 129.0 |
| 2010-10-06 | C | Futures | 2008.0 | 2027.0 | 2000.0 | 2017.0 | 6004.0 |
| 2010-10-06 | CC | Futures | 2259.0 | 2278.0 | 2247.0 | 2272.0 | 4634.0 |
| 2010-10-06 | CSC | Futures | 3.757 | 3.757 | 3.757 | 3.757 | 1.0 |
| 2010-10-06 | CT | Futures | 83.5 | 84.76 | 83.03 | 84.43 | 7991.0 |
| 2010-10-06 | DC | Futures | 25.22 | 25.57 | 25.19 | 25.44 | 295.0 |
| 2010-10-06 | DX | Futures | 78.193 | 78.399 | 77.767 | 77.867 | 23442.0 |
| 2010-10-06 | E1 | Futures | 1.35875 | 1.36872 | 1.35651 | 1.36754 | 35431.0 |
| 2010-10-06 | E6 | Futures | 1.63555 | 1.64915 | 1.63141 | 1.64761 | 341495.0 |
| 2010-10-06 | E7 | Futures | 1.6241 | 1.6364 | 1.6191 | 1.6351 | 5474.0 |
| 2010-10-06 | ED | Futures | 94.7173 | 94.7411 | 94.7126 | 94.7316 | 164318.0 |
| 2010-10-06 | ER | Futures | 97.271 | 97.286 | 97.262 | 97.271 | 125599.0 |
| 2010-10-06 | EW | Futures | 795.3 | 798.9 | 786.5 | 789.8 | 23624.0 |
| 2010-10-06 | FBTP | Futures | 67.53 | 67.88 | 67.53 | 67.8 | 3749.0 |
| 2010-10-06 | FCE | Futures | 2459.0 | 2480.9 | 2454.4 | 2471.1 | 132686.0 |
| 2010-10-06 | FDAX | Futures | 6726.7 | 6775.1 | 6722.4 | 6745.5 | 129404.0 |
| 2010-10-06 | FESX | Futures | 1722.5 | 1736.9 | 1718.2 | 1726.3 | 1187021.0 |
| 2010-10-06 | FEU3 | Futures | 97.84 | 97.84 | 97.835 | 97.835 | 60.0 |
| 2010-10-06 | FGBL | Futures | 103.95 | 104.46 | 103.86 | 104.4 | 984457.0 |
| 2010-10-06 | FGBM | Futures | 106.55 | 106.86 | 106.52 | 106.82 | 520306.0 |
| 2010-10-06 | FGBS | Futures | 107.538 | 107.602 | 107.524 | 107.583 | 542759.0 |
| 2010-10-06 | FGBX | Futures | 108.26 | 109.13 | 107.97 | 108.99 | 3705.0 |
| 2010-10-06 | FTDX | Futures | 681.3 | 687.9 | 677.4 | 679.1 | 1123.0 |
| 2010-10-06 | FTI | Futures | 269.85 | 271.49 | 268.97 | 270.21 | 32481.0 |
| 2010-10-06 | FTUK | Futures | 3895.2 | 3922.1 | 3889.0 | 3909.0 | 92268.0 |
| 2010-10-06 | G | Futures | 84.53 | 84.96 | 84.51 | 84.92 | 85448.0 |
| 2010-10-06 | GF | Futures | 275.755 | 275.817 | 274.56 | 274.623 | 1173.0 |
| 2010-10-06 | GSCI | Futures | 927.58 | 938.43 | 926.91 | 931.92 | 599.0 |
| 2010-10-06 | HE | Futures | 97.535 | 98.144 | 97.129 | 97.704 | 15442.0 |
| 2010-10-06 | HG | Futures | 4.9724 | 5.0578 | 4.969 | 5.0091 | 24960.0 |
| 2010-10-06 | HO | Futures | 1.9545 | 1.9836 | 1.9413 | 1.9629 | 24109.0 |
| 2010-10-06 | HRC | Futures | 2572.4 | 2572.4 | 2572.4 | 2572.4 | 0.0 |
| 2010-10-06 | J1 | Futures | 0.0151021 | 0.0152089 | 0.0150946 | 0.0151549 | 96461.0 |
| 2010-10-06 | J7 | Futures | 0.014995 | 0.015126 | 0.014994 | 0.015051 | 218.0 |
| 2010-10-06 | JB | Futures | 122.51 | 122.95 | 122.45 | 122.79 | 2751.0 |
| 2010-10-06 | KC | Futures | 438.32 | 440.68 | 434.11 | 435.35 | 7202.0 |
| 2010-10-06 | KE | Futures | 2925.66 | 2957.99 | 2892.28 | 2910.02 | 11471.0 |
| 2010-10-06 | L | Futures | 98.155 | 98.165 | 98.145 | 98.155 | 30785.0 |
> showing 50 of 91 rows — these rows as CSV