PREVIEW / futures_daily / 2010-01-14
file: by_date/futures_daily/2010/2010-01-14.parquet size: 9 KB rows: 89
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-01-14 | ES | Futures | 1106.51 | 1111.84 | 1103.36 | 1110.14 | 1355731.0 |
| 2010-01-14 | NQ | Futures | 2128.91 | 2137.96 | 2121.85 | 2135.7 | 206040.0 |
| 2010-01-14 | YM | Futures | 9706.2 | 9748.2 | 9686.1 | 9740.0 | 80520.0 |
| 2010-01-14 | CL | Futures | 188.89 | 190.73 | 187.35 | 188.68 | 197449.0 |
| 2010-01-14 | GC | Futures | 1566.2 | 1578.3 | 1556.3 | 1573.2 | 165713.0 |
| 2010-01-14 | ZN | Futures | 93.748829 | 94.252584 | 93.711047 | 94.101457 | 880765.0 |
| 2010-01-14 | A6 | Futures | 0.74582 | 0.7537 | 0.74444 | 0.7524 | 71794.0 |
| 2010-01-14 | AD | Futures | 0.95754 | 0.96554 | 0.95645 | 0.96524 | 63974.0 |
| 2010-01-14 | B | Futures | 71.72 | 72.05 | 70.66 | 71.25 | 151975.0 |
| 2010-01-14 | B6 | Futures | 1.6893 | 1.6972 | 1.6872 | 1.6955 | 81534.0 |
| 2010-01-14 | BFX | Futures | 2920.0 | 2920.5 | 2901.7 | 2909.0 | 776.0 |
| 2010-01-14 | BR | Futures | 0.2272 | 0.2272 | 0.2272 | 0.2272 | 53.0 |
| 2010-01-14 | C | Futures | 2326.0 | 2335.0 | 2317.0 | 2330.0 | 5951.0 |
| 2010-01-14 | CB | Futures | 72.173 | 73.037 | 72.173 | 73.037 | 9.0 |
| 2010-01-14 | CC | Futures | 2889.0 | 2937.0 | 2889.0 | 2914.0 | 5994.0 |
| 2010-01-14 | CT | Futures | 59.95 | 60.17 | 58.88 | 59.44 | 10635.0 |
| 2010-01-14 | DC | Futures | 23.62 | 23.78 | 23.55 | 23.65 | 136.0 |
| 2010-01-14 | DX | Futures | 78.223 | 78.483 | 78.111 | 78.188 | 12376.0 |
| 2010-01-14 | E1 | Futures | 1.2946 | 1.29829 | 1.2888 | 1.29539 | 44550.0 |
| 2010-01-14 | E6 | Futures | 1.71659 | 1.7231 | 1.70984 | 1.71671 | 245562.0 |
| 2010-01-14 | E7 | Futures | 1.7048 | 1.7111 | 1.6977 | 1.7048 | 3117.0 |
| 2010-01-14 | EBM | Futures | 218.01 | 219.28 | 216.74 | 217.58 | 7366.0 |
| 2010-01-14 | ED | Futures | 94.3631 | 94.3773 | 94.3631 | 94.3725 | 112593.0 |
| 2010-01-14 | ER | Futures | 97.296 | 97.321 | 97.286 | 97.316 | 213159.0 |
| 2010-01-14 | EW | Futures | 727.1 | 731.5 | 725.5 | 730.4 | 19463.0 |
| 2010-01-14 | FBTP | Futures | 63.02 | 63.16 | 62.98 | 63.09 | 5071.0 |
| 2010-01-14 | FCE | Futures | 2624.7 | 2630.2 | 2601.2 | 2616.2 | 113591.0 |
| 2010-01-14 | FDAX | Futures | 6566.7 | 6572.2 | 6505.0 | 6543.2 | 125658.0 |
| 2010-01-14 | FESX | Futures | 1794.5 | 1799.3 | 1777.8 | 1788.6 | 991121.0 |
| 2010-01-14 | FEU3 | Futures | 97.86 | 97.879 | 97.855 | 97.879 | 370.0 |
| 2010-01-14 | FGBL | Futures | 94.03 | 94.37 | 93.98 | 94.25 | 774872.0 |
| 2010-01-14 | FGBM | Futures | 99.95 | 100.2 | 99.9 | 100.15 | 511594.0 |
| 2010-01-14 | FGBS | Futures | 105.445 | 105.528 | 105.406 | 105.513 | 586805.0 |
| 2010-01-14 | FGBX | Futures | 87.1 | 87.65 | 87.01 | 87.4 | 2977.0 |
| 2010-01-14 | FTDX | Futures | 752.6 | 767.7 | 752.6 | 761.5 | 697.0 |
| 2010-01-14 | FTI | Futures | 276.88 | 277.0 | 274.64 | 276.15 | 17800.0 |
| 2010-01-14 | FTUK | Futures | 3663.3 | 3669.0 | 3637.9 | 3651.6 | 68611.0 |
| 2010-01-14 | G | Futures | 75.3 | 75.6 | 75.27 | 75.36 | 66070.0 |
| 2010-01-14 | GF | Futures | 263.772 | 266.0 | 263.299 | 264.582 | 2517.0 |
| 2010-01-14 | GSCI | Futures | 990.46 | 992.7 | 981.96 | 987.19 | 4250.0 |
| 2010-01-14 | HE | Futures | 92.43 | 93.066 | 91.694 | 92.397 | 27782.0 |
| 2010-01-14 | HG | Futures | 4.718 | 4.7511 | 4.667 | 4.6732 | 26175.0 |
| 2010-01-14 | HO | Futures | 1.962 | 1.9717 | 1.9326 | 1.9476 | 27600.0 |
| 2010-01-14 | J1 | Futures | 0.0137773 | 0.0138566 | 0.0136754 | 0.0138352 | 120078.0 |
| 2010-01-14 | J7 | Futures | 0.01361 | 0.013686 | 0.013503 | 0.013662 | 125.0 |
| 2010-01-14 | JB | Futures | 117.34 | 117.42 | 117.23 | 117.32 | 841.0 |
| 2010-01-14 | KC | Futures | 377.82 | 379.25 | 373.65 | 375.73 | 7432.0 |
| 2010-01-14 | KE | Futures | 2424.02 | 2426.28 | 2375.41 | 2383.32 | 7363.0 |
| 2010-01-14 | L | Futures | 97.819 | 97.838 | 97.819 | 97.838 | 16592.0 |
| 2010-01-14 | LBS | Futures | 803.4 | 814.0 | 798.2 | 814.0 | 835.0 |
> showing 50 of 89 rows — these rows as CSV