PREVIEW / futures_daily / 2010-05-26
file: by_date/futures_daily/2010/2010-05-26.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-05-26 | ES | Futures | 1044.39 | 1060.94 | 1032.7 | 1033.43 | 2929237.0 |
| 2010-05-26 | NQ | Futures | 2058.43 | 2098.42 | 2029.22 | 2032.34 | 391061.0 |
| 2010-05-26 | YM | Futures | 9211.1 | 9339.8 | 9115.5 | 9120.1 | 168453.0 |
| 2010-05-26 | CL | Futures | 153.3 | 156.89 | 151.44 | 156.48 | 405519.0 |
| 2010-05-26 | GC | Futures | 1643.7 | 1662.4 | 1640.6 | 1657.7 | 155669.0 |
| 2010-05-26 | ZN | Futures | 99.223279 | 99.350816 | 98.572844 | 98.891685 | 2339058.0 |
| 2010-05-26 | A6 | Futures | 0.67825 | 0.68703 | 0.67045 | 0.67579 | 146787.0 |
| 2010-05-26 | AD | Futures | 0.92635 | 0.93306 | 0.91855 | 0.92723 | 100709.0 |
| 2010-05-26 | B | Futures | 62.63 | 63.89 | 61.87 | 63.6 | 66936.0 |
| 2010-05-26 | B6 | Futures | 1.498 | 1.4998 | 1.4878 | 1.4962 | 109077.0 |
| 2010-05-26 | BFX | Futures | 2679.9 | 2736.4 | 2679.7 | 2699.9 | 447.0 |
| 2010-05-26 | BZ | Futures | 68.59 | 68.59 | 68.59 | 68.59 | 12.0 |
| 2010-05-26 | C | Futures | 2381.0 | 2421.0 | 2373.0 | 2416.0 | 5071.0 |
| 2010-05-26 | CB | Futures | 77.017 | 77.5 | 77.017 | 77.017 | 12.0 |
| 2010-05-26 | CC | Futures | 2458.0 | 2472.0 | 2410.0 | 2440.0 | 10022.0 |
| 2010-05-26 | CT | Futures | 65.23 | 65.89 | 64.98 | 65.05 | 7484.0 |
| 2010-05-26 | DC | Futures | 22.19 | 22.42 | 22.19 | 22.36 | 56.0 |
| 2010-05-26 | DX | Futures | 87.884 | 88.649 | 87.782 | 88.41 | 25877.0 |
| 2010-05-26 | E1 | Futures | 1.13995 | 1.14351 | 1.13364 | 1.13574 | 55168.0 |
| 2010-05-26 | E6 | Futures | 1.46347 | 1.46454 | 1.43969 | 1.44336 | 352971.0 |
| 2010-05-26 | E7 | Futures | 1.4523 | 1.4523 | 1.4278 | 1.4315 | 7097.0 |
| 2010-05-26 | ED | Futures | 94.0486 | 94.1363 | 94.0391 | 94.0913 | 332536.0 |
| 2010-05-26 | ER | Futures | 97.321 | 97.35 | 97.316 | 97.345 | 159251.0 |
| 2010-05-26 | EW | Futures | 720.3 | 738.6 | 717.2 | 719.2 | 36672.0 |
| 2010-05-26 | FBTP | Futures | 64.66 | 64.71 | 64.34 | 64.42 | 7870.0 |
| 2010-05-26 | FCE | Futures | 2223.0 | 2267.8 | 2203.5 | 2241.3 | 171360.0 |
| 2010-05-26 | FDAX | Futures | 6223.9 | 6341.4 | 6195.1 | 6268.5 | 190581.0 |
| 2010-05-26 | FESX | Futures | 1539.0 | 1565.3 | 1516.9 | 1543.2 | 2075816.0 |
| 2010-05-26 | FEU3 | Futures | 97.884 | 97.904 | 97.884 | 97.904 | 1228.0 |
| 2010-05-26 | FGBL | Futures | 100.77 | 100.85 | 100.36 | 100.45 | 1136668.0 |
| 2010-05-26 | FGBM | Futures | 105.21 | 105.3 | 105.01 | 105.06 | 600950.0 |
| 2010-05-26 | FGBS | Futures | 107.55 | 107.589 | 107.501 | 107.54 | 548741.0 |
| 2010-05-26 | FGBX | Futures | 99.76 | 99.76 | 98.86 | 99.11 | 3088.0 |
| 2010-05-26 | FTDX | Futures | 621.3 | 635.9 | 617.3 | 632.3 | 731.0 |
| 2010-05-26 | FTI | Futures | 243.19 | 248.22 | 241.97 | 245.35 | 41668.0 |
| 2010-05-26 | FTUK | Futures | 3377.2 | 3440.5 | 3357.9 | 3395.8 | 155920.0 |
| 2010-05-26 | G | Futures | 80.04 | 80.11 | 79.48 | 79.69 | 151875.0 |
| 2010-05-26 | GF | Futures | 272.445 | 273.582 | 270.93 | 273.582 | 2517.0 |
| 2010-05-26 | GSCI | Futures | 822.82 | 832.99 | 822.82 | 829.6 | 172.0 |
| 2010-05-26 | HE | Futures | 102.006 | 103.232 | 101.88 | 102.634 | 7043.0 |
| 2010-05-26 | HG | Futures | 4.194 | 4.2347 | 4.1451 | 4.1831 | 25892.0 |
| 2010-05-26 | HO | Futures | 1.6927 | 1.737 | 1.6927 | 1.7314 | 12486.0 |
| 2010-05-26 | J1 | Futures | 0.0139221 | 0.0140013 | 0.0138693 | 0.0139661 | 145295.0 |
| 2010-05-26 | J7 | Futures | 0.013807 | 0.013888 | 0.01376 | 0.013855 | 348.0 |
| 2010-05-26 | JB | Futures | 119.79 | 119.82 | 119.46 | 119.5 | 3622.0 |
| 2010-05-26 | KC | Futures | 337.02 | 344.26 | 336.64 | 339.44 | 10158.0 |
| 2010-05-26 | KE | Futures | 2115.04 | 2149.82 | 2099.82 | 2124.82 | 8489.0 |
| 2010-05-26 | KRW | Futures | 0.000781 | 0.000781 | 0.000781 | 0.000781 | 2.0 |
| 2010-05-26 | L | Futures | 97.839 | 97.918 | 97.839 | 97.898 | 99309.0 |
| 2010-05-26 | LBS | Futures | 710.6 | 711.9 | 696.4 | 696.4 | 579.0 |
> showing 50 of 89 rows — these rows as CSV