PREVIEW / futures_daily / 2010-06-08
file: by_date/futures_daily/2010/2010-06-08.parquet size: 8 KB rows: 87
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-06-08 | ES | Futures | 1020.77 | 1035.38 | 1013.95 | 1031.48 | 3401030.0 |
| 2010-06-08 | NQ | Futures | 2036.31 | 2062.12 | 2007.95 | 2032.34 | 409445.0 |
| 2010-06-08 | YM | Futures | 9007.0 | 9144.0 | 8892.1 | 9113.6 | 215444.0 |
| 2010-06-08 | CL | Futures | 155.71 | 158.86 | 154.81 | 157.53 | 421966.0 |
| 2010-06-08 | GC | Futures | 1695.0 | 1711.2 | 1684.6 | 1699.1 | 143916.0 |
| 2010-06-08 | ZN | Futures | 99.299801 | 99.33822 | 98.941226 | 99.197351 | 1082522.0 |
| 2010-06-08 | A6 | Futures | 0.66389 | 0.67981 | 0.66323 | 0.67349 | 150230.0 |
| 2010-06-08 | AD | Futures | 0.93029 | 0.94283 | 0.9301 | 0.93869 | 108232.0 |
| 2010-06-08 | B | Futures | 63.4 | 64.45 | 63.2 | 64.06 | 96909.0 |
| 2010-06-08 | B6 | Futures | 1.5023 | 1.5085 | 1.4894 | 1.4931 | 151769.0 |
| 2010-06-08 | BFX | Futures | 2761.6 | 2766.0 | 2710.6 | 2731.6 | 242.0 |
| 2010-06-08 | BZ | Futures | 69.08 | 69.08 | 69.08 | 69.08 | 1.0 |
| 2010-06-08 | C | Futures | 2515.0 | 2580.0 | 2508.0 | 2577.0 | 3096.0 |
| 2010-06-08 | CC | Futures | 2465.0 | 2489.0 | 2460.0 | 2486.0 | 7200.0 |
| 2010-06-08 | CT | Futures | 61.49 | 62.35 | 61.18 | 62.25 | 17686.0 |
| 2010-06-08 | DC | Futures | 22.14 | 22.2 | 22.06 | 22.14 | 54.0 |
| 2010-06-08 | DX | Futures | 89.728 | 89.834 | 89.196 | 89.655 | 34754.0 |
| 2010-06-08 | E1 | Futures | 1.13179 | 1.14614 | 1.13074 | 1.14022 | 67309.0 |
| 2010-06-08 | E6 | Futures | 1.41 | 1.42077 | 1.40799 | 1.41059 | 420693.0 |
| 2010-06-08 | E7 | Futures | 1.3984 | 1.409 | 1.3965 | 1.399 | 5297.0 |
| 2010-06-08 | ED | Futures | 94.2121 | 94.2334 | 94.2097 | 94.2286 | 114019.0 |
| 2010-06-08 | ER | Futures | 97.365 | 97.375 | 97.36 | 97.37 | 66882.0 |
| 2010-06-08 | EW | Futures | 701.3 | 709.5 | 691.3 | 703.7 | 46324.0 |
| 2010-06-08 | FBTP | Futures | 62.81 | 63.54 | 62.81 | 63.49 | 7784.0 |
| 2010-06-08 | FCE | Futures | 2254.5 | 2272.8 | 2209.1 | 2234.6 | 160882.0 |
| 2010-06-08 | FDAX | Futures | 6415.9 | 6452.3 | 6307.1 | 6368.5 | 200638.0 |
| 2010-06-08 | FESX | Futures | 1543.2 | 1557.3 | 1510.8 | 1531.0 | 2006213.0 |
| 2010-06-08 | FEU3 | Futures | 97.924 | 97.934 | 97.924 | 97.929 | 1042.0 |
| 2010-06-08 | FGBL | Futures | 100.91 | 101.48 | 100.84 | 101.38 | 870275.0 |
| 2010-06-08 | FGBM | Futures | 105.41 | 105.75 | 105.36 | 105.66 | 533973.0 |
| 2010-06-08 | FGBS | Futures | 107.696 | 107.809 | 107.677 | 107.775 | 601245.0 |
| 2010-06-08 | FGBX | Futures | 100.1 | 101.29 | 100.1 | 101.16 | 5071.0 |
| 2010-06-08 | FTDX | Futures | 648.7 | 650.0 | 633.7 | 637.7 | 662.0 |
| 2010-06-08 | FTI | Futures | 250.15 | 251.21 | 245.2 | 247.87 | 45980.0 |
| 2010-06-08 | FTUK | Futures | 3435.4 | 3439.4 | 3372.5 | 3401.9 | 155435.0 |
| 2010-06-08 | G | Futures | 80.2 | 80.51 | 80.1 | 80.37 | 89855.0 |
| 2010-06-08 | GF | Futures | 273.33 | 276.171 | 273.266 | 274.972 | 1857.0 |
| 2010-06-08 | GSCI | Futures | 825.16 | 831.16 | 821.69 | 828.56 | 3276.0 |
| 2010-06-08 | HE | Futures | 97.005 | 98.256 | 97.005 | 97.849 | 18239.0 |
| 2010-06-08 | HG | Futures | 3.7404 | 3.8145 | 3.7072 | 3.7744 | 39858.0 |
| 2010-06-08 | HO | Futures | 1.7736 | 1.7736 | 1.7474 | 1.7611 | 8743.0 |
| 2010-06-08 | J1 | Futures | 0.0137486 | 0.0138417 | 0.013677 | 0.0137712 | 173336.0 |
| 2010-06-08 | J7 | Futures | 0.013625 | 0.01373 | 0.01357 | 0.013661 | 340.0 |
| 2010-06-08 | JB | Futures | 119.8 | 119.88 | 119.73 | 119.86 | 8145.0 |
| 2010-06-08 | KC | Futures | 337.91 | 340.45 | 337.15 | 339.06 | 14931.0 |
| 2010-06-08 | KE | Futures | 2008.53 | 2023.74 | 2005.27 | 2008.53 | 13153.0 |
| 2010-06-08 | L | Futures | 97.937 | 97.997 | 97.928 | 97.987 | 68332.0 |
| 2010-06-08 | LBS | Futures | 669.8 | 677.8 | 647.2 | 662.6 | 712.0 |
| 2010-06-08 | LE | Futures | 142.875 | 143.688 | 142.59 | 142.915 | 14391.0 |
| 2010-06-08 | MFS | Futures | 1042.0 | 1054.9 | 1034.4 | 1051.5 | 912.0 |
> showing 50 of 87 rows — these rows as CSV