PREVIEW / futures_daily / 2008-07-16
file: by_date/futures_daily/2008/2008-07-16.parquet size: 8 KB rows: 81
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-16 | ES | Futures | 1121.74 | 1152.73 | 1112.26 | 1147.87 | 2893515.0 |
| 2008-07-16 | NQ | Futures | 2005.48 | 2058.32 | 1986.57 | 2052.2 | 542827.0 |
| 2008-07-16 | YM | Futures | 9699.1 | 9975.3 | 9636.9 | 9952.2 | 243946.0 |
| 2008-07-16 | CL | Futures | 604.69 | 607.3 | 576.43 | 587.37 | 147590.0 |
| 2008-07-16 | GC | Futures | 1385.7 | 1391.4 | 1356.9 | 1363.3 | 173591.0 |
| 2008-07-16 | ZN | Futures | 85.125328 | 85.251899 | 84.423429 | 84.596027 | 1168307.0 |
| 2008-07-16 | A6 | Futures | 0.74999 | 0.75215 | 0.74543 | 0.74582 | 45666.0 |
| 2008-07-16 | AD | Futures | 0.97993 | 0.98179 | 0.97659 | 0.98003 | 33917.0 |
| 2008-07-16 | B | Futures | 167.53 | 168.12 | 159.97 | 162.75 | 131606.0 |
| 2008-07-16 | B6 | Futures | 2.0551 | 2.0598 | 2.0453 | 2.0488 | 69428.0 |
| 2008-07-16 | BFX | Futures | 3285.3 | 3306.9 | 3176.6 | 3305.1 | 3335.0 |
| 2008-07-16 | BZ | Futures | 164.17 | 164.86 | 159.22 | 160.35 | 415.0 |
| 2008-07-16 | C | Futures | 1366.0 | 1392.0 | 1359.0 | 1391.0 | 7641.0 |
| 2008-07-16 | CC | Futures | 2662.0 | 2726.0 | 2639.0 | 2708.0 | 7295.0 |
| 2008-07-16 | CT | Futures | 73.91 | 74.33 | 72.91 | 74.13 | 630.0 |
| 2008-07-16 | DC | Futures | 53.24 | 53.59 | 52.74 | 52.98 | 206.0 |
| 2008-07-16 | DX | Futures | 76.479 | 76.596 | 75.95 | 76.559 | 204.0 |
| 2008-07-16 | E1 | Futures | 1.32257 | 1.32963 | 1.30884 | 1.31017 | 75623.0 |
| 2008-07-16 | E6 | Futures | 1.85693 | 1.86126 | 1.8437 | 1.84499 | 208932.0 |
| 2008-07-16 | E7 | Futures | 1.8382 | 1.8431 | 1.8261 | 1.8271 | 2641.0 |
| 2008-07-16 | ED | Futures | 91.7115 | 91.7351 | 91.6879 | 91.7068 | 199491.0 |
| 2008-07-16 | ER | Futures | 93.595 | 93.61 | 93.585 | 93.6 | 75540.0 |
| 2008-07-16 | EW | Futures | 763.6 | 783.6 | 758.9 | 782.6 | 33039.0 |
| 2008-07-16 | FCE | Futures | 2664.9 | 2719.0 | 2615.7 | 2686.1 | 218150.0 |
| 2008-07-16 | FDAX | Futures | 6904.9 | 7036.5 | 6766.5 | 7036.5 | 232583.0 |
| 2008-07-16 | FESX | Futures | 1862.9 | 1900.4 | 1823.5 | 1900.4 | 2312730.0 |
| 2008-07-16 | FEU3 | Futures | 94.147 | 94.157 | 94.132 | 94.152 | 984.0 |
| 2008-07-16 | FGBL | Futures | 84.56 | 84.86 | 84.38 | 84.38 | 886379.0 |
| 2008-07-16 | FGBM | Futures | 90.43 | 90.6 | 90.21 | 90.21 | 561298.0 |
| 2008-07-16 | FGBS | Futures | 99.536 | 99.594 | 99.458 | 99.458 | 539649.0 |
| 2008-07-16 | FGBX | Futures | 75.11 | 75.59 | 74.99 | 75.38 | 2226.0 |
| 2008-07-16 | FTDX | Futures | 633.4 | 646.1 | 619.8 | 646.1 | 909.0 |
| 2008-07-16 | FTI | Futures | 295.79 | 296.33 | 286.92 | 294.78 | 37436.0 |
| 2008-07-16 | FTUK | Futures | 3366.7 | 3388.7 | 3286.4 | 3333.7 | 155473.0 |
| 2008-07-16 | G | Futures | 67.76 | 68.06 | 67.69 | 67.75 | 66864.0 |
| 2008-07-16 | GF | Futures | 302.392 | 302.392 | 299.883 | 301.375 | 412.0 |
| 2008-07-16 | GSCI | Futures | 2163.01 | 2166.21 | 2100.66 | 2127.29 | 352.0 |
| 2008-07-16 | HE | Futures | 150.928 | 154.225 | 149.279 | 153.026 | 7234.0 |
| 2008-07-16 | HG | Futures | 5.1393 | 5.179 | 5.0598 | 5.0877 | 13281.0 |
| 2008-07-16 | HO | Futures | 4.6001 | 4.6259 | 4.4066 | 4.4997 | 17297.0 |
| 2008-07-16 | J1 | Futures | 0.0121949 | 0.0123031 | 0.0121301 | 0.0121619 | 150690.0 |
| 2008-07-16 | J7 | Futures | 0.011966 | 0.012084 | 0.011928 | 0.011953 | 81.0 |
| 2008-07-16 | JB | Futures | 114.18 | 114.21 | 113.81 | 113.96 | 631.0 |
| 2008-07-16 | KC | Futures | 427.52 | 430.56 | 421.15 | 427.67 | 8291.0 |
| 2008-07-16 | KE | Futures | 4469.18 | 4593.84 | 4404.2 | 4564.66 | 11459.0 |
| 2008-07-16 | L | Futures | 93.378 | 93.388 | 93.368 | 93.373 | 32446.0 |
| 2008-07-16 | LE | Futures | 197.224 | 197.688 | 195.789 | 196.993 | 7282.0 |
| 2008-07-16 | MP | Futures | 0.04641 | 0.04675 | 0.0463 | 0.04663 | 39591.0 |
| 2008-07-16 | N6 | Futures | 0.58897 | 0.59105 | 0.58674 | 0.5892 | 3638.0 |
| 2008-07-16 | NG | Futures | 805.964 | 808.989 | 782.037 | 802.093 | 89560.0 |
> showing 50 of 81 rows — these rows as CSV