PREVIEW / futures_daily / 2010-11-16
file: by_date/futures_daily/2010/2010-11-16.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-11-16 | ES | Futures | 1171.54 | 1171.54 | 1147.77 | 1151.44 | 3168883.0 |
| 2010-11-16 | NQ | Futures | 2411.51 | 2412.07 | 2362.47 | 2370.69 | 408237.0 |
| 2010-11-16 | YM | Futures | 10391.7 | 10393.6 | 10186.1 | 10220.5 | 169486.0 |
| 2010-11-16 | CL | Futures | 174.48 | 174.95 | 169.47 | 170.11 | 224785.0 |
| 2010-11-16 | GC | Futures | 1848.3 | 1854.4 | 1806.5 | 1819.2 | 296974.0 |
| 2010-11-16 | ZN | Futures | 102.844987 | 103.33534 | 102.638523 | 103.27082 | 1719535.0 |
| 2010-11-16 | A6 | Futures | 0.82393 | 0.82745 | 0.81335 | 0.81671 | 132096.0 |
| 2010-11-16 | AD | Futures | 0.98064 | 0.98331 | 0.96558 | 0.96934 | 138584.0 |
| 2010-11-16 | B | Futures | 73.59 | 73.77 | 71.89 | 72.08 | 189949.0 |
| 2010-11-16 | B6 | Futures | 1.6661 | 1.6697 | 1.6439 | 1.6481 | 148407.0 |
| 2010-11-16 | BFX | Futures | 3039.9 | 3043.0 | 3007.8 | 3009.4 | 827.0 |
| 2010-11-16 | BR | Futures | 0.24602 | 0.24602 | 0.24456 | 0.24461 | 143.0 |
| 2010-11-16 | BZ | Futures | 77.84 | 77.85 | 76.07 | 76.25 | 631.0 |
| 2010-11-16 | C | Futures | 1996.0 | 2014.0 | 1992.0 | 2008.0 | 4086.0 |
| 2010-11-16 | CB | Futures | 96.076 | 96.09 | 96.076 | 96.09 | 1.0 |
| 2010-11-16 | CC | Futures | 2277.0 | 2286.0 | 2234.0 | 2258.0 | 5747.0 |
| 2010-11-16 | CT | Futures | 117.44 | 120.6 | 113.21 | 113.21 | 6300.0 |
| 2010-11-16 | DC | Futures | 22.33 | 22.8 | 22.23 | 22.73 | 661.0 |
| 2010-11-16 | DX | Futures | 79.031 | 79.839 | 78.695 | 79.586 | 36687.0 |
| 2010-11-16 | E1 | Futures | 1.33314 | 1.3359 | 1.31555 | 1.31857 | 50390.0 |
| 2010-11-16 | E6 | Futures | 1.6061 | 1.61485 | 1.59025 | 1.59533 | 454019.0 |
| 2010-11-16 | E7 | Futures | 1.594 | 1.6026 | 1.5783 | 1.5832 | 7061.0 |
| 2010-11-16 | ED | Futures | 94.7411 | 94.7506 | 94.7363 | 94.7411 | 231867.0 |
| 2010-11-16 | ER | Futures | 97.208 | 97.232 | 97.208 | 97.222 | 109851.0 |
| 2010-11-16 | EW | Futures | 829.3 | 829.5 | 811.0 | 815.2 | 33603.0 |
| 2010-11-16 | FBTP | Futures | 65.95 | 66.16 | 65.62 | 65.73 | 8731.0 |
| 2010-11-16 | FCE | Futures | 2570.9 | 2570.9 | 2508.3 | 2517.0 | 115452.0 |
| 2010-11-16 | FDAX | Futures | 7272.0 | 7288.7 | 7157.5 | 7182.2 | 186349.0 |
| 2010-11-16 | FESX | Futures | 1763.7 | 1766.2 | 1729.4 | 1738.1 | 1620611.0 |
| 2010-11-16 | FEU3 | Futures | 97.775 | 97.79 | 97.775 | 97.785 | 14.0 |
| 2010-11-16 | FGBL | Futures | 101.66 | 101.92 | 101.2 | 101.33 | 1117346.0 |
| 2010-11-16 | FGBM | Futures | 105.62 | 105.85 | 105.44 | 105.51 | 558962.0 |
| 2010-11-16 | FGBS | Futures | 107.194 | 107.292 | 107.174 | 107.199 | 440608.0 |
| 2010-11-16 | FGBX | Futures | 103.44 | 104.04 | 102.6 | 102.89 | 4539.0 |
| 2010-11-16 | FTDX | Futures | 687.1 | 690.6 | 673.0 | 677.4 | 658.0 |
| 2010-11-16 | FTI | Futures | 276.77 | 276.93 | 272.67 | 273.07 | 63759.0 |
| 2010-11-16 | FTUK | Futures | 3990.5 | 4006.4 | 3902.4 | 3925.6 | 142249.0 |
| 2010-11-16 | G | Futures | 82.63 | 82.99 | 82.45 | 82.48 | 157384.0 |
| 2010-11-16 | GF | Futures | 286.971 | 287.096 | 283.733 | 286.099 | 2280.0 |
| 2010-11-16 | GSCI | Futures | 941.12 | 941.12 | 919.87 | 919.95 | 502.0 |
| 2010-11-16 | HE | Futures | 94.05 | 94.49 | 91.276 | 92.46 | 16865.0 |
| 2010-11-16 | HG | Futures | 5.22 | 5.2487 | 4.919 | 4.9751 | 61849.0 |
| 2010-11-16 | HO | Futures | 1.9982 | 1.9982 | 1.9458 | 1.9479 | 51236.0 |
| 2010-11-16 | HRC | Futures | 2437.0 | 2437.0 | 2437.0 | 2437.0 | 0.0 |
| 2010-11-16 | J1 | Futures | 0.0151172 | 0.0151662 | 0.015028 | 0.0150846 | 131944.0 |
| 2010-11-16 | J7 | Futures | 0.015006 | 0.015058 | 0.014927 | 0.014981 | 353.0 |
| 2010-11-16 | JB | Futures | 120.81 | 121.33 | 120.56 | 121.25 | 4824.0 |
| 2010-11-16 | KC | Futures | 507.01 | 510.11 | 487.8 | 490.52 | 15553.0 |
| 2010-11-16 | KE | Futures | 3052.91 | 3064.38 | 2874.55 | 2878.72 | 17991.0 |
| 2010-11-16 | L | Futures | 98.155 | 98.155 | 98.106 | 98.155 | 22549.0 |
> showing 50 of 91 rows — these rows as CSV