PREVIEW / futures_daily / 2010-07-19
file: by_date/futures_daily/2010/2010-07-19.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-07-19 | ES | Futures | 1035.58 | 1044.6 | 1030.95 | 1037.53 | 1760879.0 |
| 2010-07-19 | NQ | Futures | 2037.85 | 2061.34 | 2017.48 | 2043.51 | 301727.0 |
| 2010-07-19 | YM | Futures | 9288.4 | 9369.8 | 9263.5 | 9301.4 | 129194.0 |
| 2010-07-19 | CL | Futures | 161.51 | 165.82 | 161.04 | 163.27 | 308732.0 |
| 2010-07-19 | GC | Futures | 1628.3 | 1629.6 | 1605.4 | 1612.2 | 119208.0 |
| 2010-07-19 | ZN | Futures | 101.118291 | 101.15671 | 100.74691 | 100.836553 | 707638.0 |
| 2010-07-19 | A6 | Futures | 0.71405 | 0.71795 | 0.71082 | 0.71679 | 89570.0 |
| 2010-07-19 | AD | Futures | 0.93374 | 0.93997 | 0.93276 | 0.93582 | 66966.0 |
| 2010-07-19 | B | Futures | 65.68 | 67.49 | 65.37 | 66.11 | 143252.0 |
| 2010-07-19 | B6 | Futures | 1.5865 | 1.5929 | 1.5773 | 1.581 | 79665.0 |
| 2010-07-19 | BFX | Futures | 2776.2 | 2807.9 | 2768.7 | 2776.3 | 795.0 |
| 2010-07-19 | BR | Futures | 0.23229 | 0.23229 | 0.23171 | 0.23171 | 19.0 |
| 2010-07-19 | BZ | Futures | 70.24 | 72.11 | 69.88 | 70.66 | 259.0 |
| 2010-07-19 | C | Futures | 2653.0 | 2688.0 | 2536.0 | 2557.0 | 9392.0 |
| 2010-07-19 | CB | Futures | 85.226 | 85.226 | 85.226 | 85.226 | 1.0 |
| 2010-07-19 | CC | Futures | 2652.0 | 2656.0 | 2457.0 | 2486.0 | 19403.0 |
| 2010-07-19 | CT | Futures | 67.43 | 68.26 | 66.17 | 66.26 | 149.0 |
| 2010-07-19 | DC | Futures | 23.06 | 23.22 | 22.86 | 23.06 | 168.0 |
| 2010-07-19 | DX | Futures | 83.445 | 83.652 | 83.153 | 83.36 | 18743.0 |
| 2010-07-19 | E1 | Futures | 1.25239 | 1.25803 | 1.24438 | 1.24818 | 31149.0 |
| 2010-07-19 | E6 | Futures | 1.52613 | 1.53606 | 1.52175 | 1.53228 | 226230.0 |
| 2010-07-19 | E7 | Futures | 1.5143 | 1.525 | 1.511 | 1.5212 | 2910.0 |
| 2010-07-19 | ED | Futures | 94.404 | 94.4277 | 94.3945 | 94.4182 | 152159.0 |
| 2010-07-19 | ER | Futures | 97.173 | 97.178 | 97.149 | 97.154 | 117384.0 |
| 2010-07-19 | EW | Futures | 709.9 | 716.4 | 704.1 | 712.4 | 24090.0 |
| 2010-07-19 | FBTP | Futures | 65.16 | 65.26 | 65.07 | 65.21 | 2110.0 |
| 2010-07-19 | FCE | Futures | 2303.7 | 2319.5 | 2280.8 | 2286.0 | 110727.0 |
| 2010-07-19 | FDAX | Futures | 6582.3 | 6626.3 | 6526.2 | 6550.2 | 110936.0 |
| 2010-07-19 | FESX | Futures | 1637.7 | 1655.1 | 1624.1 | 1631.5 | 1051802.0 |
| 2010-07-19 | FEU3 | Futures | 97.711 | 97.721 | 97.711 | 97.711 | 33.0 |
| 2010-07-19 | FGBL | Futures | 100.88 | 101.17 | 100.42 | 100.54 | 677007.0 |
| 2010-07-19 | FGBM | Futures | 104.9 | 105.07 | 104.59 | 104.67 | 423565.0 |
| 2010-07-19 | FGBS | Futures | 107.313 | 107.362 | 107.195 | 107.23 | 385508.0 |
| 2010-07-19 | FGBX | Futures | 100.3 | 100.93 | 99.6 | 99.89 | 1504.0 |
| 2010-07-19 | FTDX | Futures | 680.9 | 686.7 | 677.0 | 680.5 | 280.0 |
| 2010-07-19 | FTI | Futures | 256.47 | 257.62 | 253.85 | 254.56 | 26944.0 |
| 2010-07-19 | FTUK | Futures | 3513.1 | 3555.0 | 3495.9 | 3521.0 | 89380.0 |
| 2010-07-19 | G | Futures | 81.59 | 81.74 | 81.26 | 81.38 | 65061.0 |
| 2010-07-19 | GF | Futures | 286.087 | 289.118 | 286.087 | 289.055 | 2688.0 |
| 2010-07-19 | GSCI | Futures | 853.94 | 866.08 | 847.24 | 853.77 | 767.0 |
| 2010-07-19 | HE | Futures | 99.405 | 100.316 | 98.828 | 99.102 | 12032.0 |
| 2010-07-19 | HG | Futures | 3.9281 | 3.9676 | 3.9174 | 3.9348 | 23531.0 |
| 2010-07-19 | HO | Futures | 1.7778 | 1.8279 | 1.7752 | 1.7889 | 30469.0 |
| 2010-07-19 | HRC | Futures | 2875.5 | 2875.5 | 2875.5 | 2875.5 | 0.0 |
| 2010-07-19 | J1 | Futures | 0.0145425 | 0.0145575 | 0.014433 | 0.0145135 | 96024.0 |
| 2010-07-19 | J7 | Futures | 0.014423 | 0.014447 | 0.014327 | 0.014404 | 146.0 |
| 2010-07-19 | KC | Futures | 418.52 | 419.15 | 404.96 | 411.36 | 10847.0 |
| 2010-07-19 | KE | Futures | 2536.58 | 2601.57 | 2515.27 | 2536.58 | 12199.0 |
| 2010-07-19 | L | Futures | 98.066 | 98.076 | 98.056 | 98.076 | 11718.0 |
| 2010-07-19 | LBS | Futures | 611.1 | 613.1 | 585.7 | 586.6 | 334.0 |
> showing 50 of 89 rows — these rows as CSV