PREVIEW / futures_daily / 2008-10-29
file: by_date/futures_daily/2008/2008-10-29.parquet size: 8 KB rows: 84
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-10-29 | ES | Futures | 883.95 | 914.55 | 860.88 | 872.89 | 3240110.0 |
| 2008-10-29 | NQ | Futures | 1460.13 | 1506.27 | 1421.83 | 1447.27 | 521645.0 |
| 2008-10-29 | YM | Futures | 8068.9 | 8305.2 | 7856.6 | 7865.4 | 324007.0 |
| 2008-10-29 | CL | Futures | 274.13 | 294.28 | 270.52 | 286.89 | 315415.0 |
| 2008-10-29 | GC | Futures | 1044.8 | 1084.2 | 1029.3 | 1054.5 | 117904.0 |
| 2008-10-29 | ZN | Futures | 85.510978 | 86.15383 | 85.17202 | 85.323967 | 556249.0 |
| 2008-10-29 | A6 | Futures | 0.51074 | 0.53349 | 0.49727 | 0.52176 | 35982.0 |
| 2008-10-29 | AD | Futures | 0.77637 | 0.81317 | 0.7664 | 0.80449 | 49212.0 |
| 2008-10-29 | B | Futures | 73.35 | 78.14 | 71.68 | 76.3 | 69002.0 |
| 2008-10-29 | B6 | Futures | 1.6511 | 1.7084 | 1.6511 | 1.6908 | 85517.0 |
| 2008-10-29 | BFX | Futures | 2252.3 | 2289.1 | 2241.1 | 2280.7 | 265.0 |
| 2008-10-29 | BZ | Futures | 73.91 | 73.91 | 73.91 | 73.91 | 59.0 |
| 2008-10-29 | C | Futures | 1155.0 | 1228.0 | 1146.0 | 1193.0 | 4357.0 |
| 2008-10-29 | CB | Futures | 88.46 | 88.771 | 88.46 | 88.46 | 2.0 |
| 2008-10-29 | CC | Futures | 1778.0 | 1951.0 | 1773.0 | 1899.0 | 7298.0 |
| 2008-10-29 | CT | Futures | 47.26 | 48.02 | 46.22 | 46.68 | 6925.0 |
| 2008-10-29 | DC | Futures | 36.37 | 36.98 | 36.32 | 36.8 | 104.0 |
| 2008-10-29 | DX | Futures | 90.556 | 91.253 | 88.99 | 89.707 | 8190.0 |
| 2008-10-29 | E1 | Futures | 1.15966 | 1.18904 | 1.15419 | 1.17649 | 60822.0 |
| 2008-10-29 | E6 | Futures | 1.50963 | 1.53326 | 1.49037 | 1.51636 | 252654.0 |
| 2008-10-29 | E7 | Futures | 1.4919 | 1.5182 | 1.4763 | 1.5018 | 4319.0 |
| 2008-10-29 | ED | Futures | 92.1814 | 92.3278 | 92.172 | 92.2475 | 181513.0 |
| 2008-10-29 | ER | Futures | 94.887 | 94.956 | 94.872 | 94.922 | 107997.0 |
| 2008-10-29 | EW | Futures | 515.7 | 539.8 | 504.6 | 516.4 | 32000.0 |
| 2008-10-29 | FCE | Futures | 1997.9 | 2125.4 | 1997.9 | 2082.7 | 197629.0 |
| 2008-10-29 | FDAX | Futures | 5430.4 | 5497.6 | 5202.8 | 5369.5 | 224802.0 |
| 2008-10-29 | FESX | Futures | 1402.8 | 1478.6 | 1392.4 | 1442.7 | 2331054.0 |
| 2008-10-29 | FEU3 | Futures | 95.496 | 95.511 | 95.481 | 95.511 | 1576.0 |
| 2008-10-29 | FGBL | Futures | 88.04 | 88.27 | 87.87 | 88.0 | 506500.0 |
| 2008-10-29 | FGBM | Futures | 94.53 | 94.87 | 94.5 | 94.7 | 383204.0 |
| 2008-10-29 | FGBS | Futures | 102.075 | 102.229 | 102.008 | 102.128 | 363603.0 |
| 2008-10-29 | FGBX | Futures | 80.33 | 80.72 | 79.71 | 79.9 | 883.0 |
| 2008-10-29 | FTDX | Futures | 429.6 | 445.6 | 428.7 | 434.0 | 619.0 |
| 2008-10-29 | FTI | Futures | 207.49 | 218.16 | 206.04 | 215.42 | 47113.0 |
| 2008-10-29 | FTUK | Futures | 2709.7 | 2811.5 | 2624.8 | 2730.8 | 211721.0 |
| 2008-10-29 | G | Futures | 69.65 | 70.07 | 69.61 | 69.76 | 57157.0 |
| 2008-10-29 | GF | Futures | 265.991 | 268.762 | 265.645 | 267.377 | 212.0 |
| 2008-10-29 | GSCI | Futures | 1166.35 | 1202.26 | 1155.64 | 1181.76 | 418.0 |
| 2008-10-29 | HE | Futures | 126.308 | 127.612 | 123.047 | 125.166 | 7224.0 |
| 2008-10-29 | HG | Futures | 2.7017 | 2.9676 | 2.589 | 2.9228 | 17024.0 |
| 2008-10-29 | HO | Futures | 2.246 | 2.3573 | 2.2236 | 2.3027 | 38290.0 |
| 2008-10-29 | J1 | Futures | 0.0127588 | 0.013182 | 0.0127082 | 0.0130354 | 123204.0 |
| 2008-10-29 | J7 | Futures | 0.012652 | 0.012967 | 0.012652 | 0.012837 | 130.0 |
| 2008-10-29 | JB | Futures | 113.94 | 115.27 | 113.94 | 114.71 | 2051.0 |
| 2008-10-29 | KC | Futures | 322.26 | 336.72 | 322.26 | 330.96 | 9416.0 |
| 2008-10-29 | KE | Futures | 2918.14 | 3161.74 | 2873.02 | 3083.12 | 9223.0 |
| 2008-10-29 | L | Futures | 94.598 | 94.682 | 94.583 | 94.642 | 31660.0 |
| 2008-10-29 | LBS | Futures | 1182.6 | 1228.0 | 1182.6 | 1206.3 | 28.0 |
| 2008-10-29 | LE | Futures | 165.241 | 168.128 | 164.095 | 166.845 | 8881.0 |
| 2008-10-29 | MP | Futures | 0.03697 | 0.03774 | 0.03677 | 0.03682 | 3886.0 |
> showing 50 of 84 rows — these rows as CSV