PREVIEW / futures_daily / 2008-12-18
file: by_date/futures_daily/2008/2008-12-18.parquet size: 8 KB rows: 86
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-12-18 | ES | Futures | 856.47 | 860.72 | 824.84 | 842.78 | 2087835.0 |
| 2008-12-18 | NQ | Futures | 1372.33 | 1383.23 | 1334.32 | 1370.09 | 285614.0 |
| 2008-12-18 | YM | Futures | 7830.1 | 7896.9 | 7560.3 | 7726.8 | 177862.0 |
| 2008-12-18 | CL | Futures | 177.3 | 181.2 | 164.96 | 165.43 | 233663.0 |
| 2008-12-18 | GC | Futures | 1207.5 | 1226.4 | 1183.4 | 1199.9 | 116594.0 |
| 2008-12-18 | ZN | Futures | 97.642768 | 98.455561 | 97.391758 | 97.917683 | 321307.0 |
| 2008-12-18 | A6 | Futures | 0.55485 | 0.56231 | 0.53146 | 0.54637 | 27893.0 |
| 2008-12-18 | AD | Futures | 0.82413 | 0.83061 | 0.8088 | 0.81882 | 26409.0 |
| 2008-12-18 | B | Futures | 50.42 | 51.9 | 48.03 | 48.21 | 102200.0 |
| 2008-12-18 | B6 | Futures | 1.6104 | 1.621 | 1.5436 | 1.5638 | 79309.0 |
| 2008-12-18 | BFX | Futures | 2060.9 | 2081.8 | 2043.2 | 2073.6 | 2216.0 |
| 2008-12-18 | BZ | Futures | 52.21 | 52.57 | 49.08 | 49.2 | 902.0 |
| 2008-12-18 | C | Futures | 1710.0 | 1797.0 | 1664.0 | 1782.0 | 6983.0 |
| 2008-12-18 | CB | Futures | 79.977 | 79.977 | 77.994 | 77.994 | 30.0 |
| 2008-12-18 | CC | Futures | 2308.0 | 2398.0 | 2242.0 | 2357.0 | 9089.0 |
| 2008-12-18 | CT | Futures | 44.53 | 45.89 | 43.57 | 44.07 | 7616.0 |
| 2008-12-18 | DC | Futures | 33.95 | 33.95 | 32.58 | 33.22 | 228.0 |
| 2008-12-18 | DX | Futures | 82.54 | 84.219 | 81.684 | 83.592 | 7939.0 |
| 2008-12-18 | E1 | Futures | 1.24143 | 1.28038 | 1.22615 | 1.23971 | 47500.0 |
| 2008-12-18 | E6 | Futures | 1.7015 | 1.7388 | 1.67463 | 1.69097 | 268185.0 |
| 2008-12-18 | E7 | Futures | 1.6839 | 1.7187 | 1.655 | 1.6716 | 6109.0 |
| 2008-12-18 | EBM | Futures | 196.73 | 200.94 | 195.96 | 198.64 | 1172.0 |
| 2008-12-18 | ED | Futures | 93.0342 | 93.119 | 93.0201 | 93.0577 | 187470.0 |
| 2008-12-18 | ER | Futures | 95.645 | 95.728 | 95.645 | 95.709 | 99474.0 |
| 2008-12-18 | EW | Futures | 525.5 | 525.5 | 498.5 | 514.9 | 39279.0 |
| 2008-12-18 | FCE | Futures | 2009.2 | 2016.0 | 1948.8 | 1994.7 | 55268.0 |
| 2008-12-18 | FDAX | Futures | 5196.5 | 5254.3 | 5112.4 | 5221.0 | 55904.0 |
| 2008-12-18 | FESX | Futures | 1426.0 | 1426.0 | 1379.4 | 1414.5 | 1124066.0 |
| 2008-12-18 | FEU3 | Futures | 96.233 | 96.277 | 96.233 | 96.272 | 3866.0 |
| 2008-12-18 | FGBL | Futures | 92.96 | 93.26 | 92.64 | 93.02 | 493527.0 |
| 2008-12-18 | FGBM | Futures | 96.97 | 97.19 | 96.83 | 97.1 | 266806.0 |
| 2008-12-18 | FGBS | Futures | 102.903 | 103.028 | 102.85 | 102.98 | 259501.0 |
| 2008-12-18 | FGBX | Futures | 87.25 | 88.44 | 86.65 | 88.24 | 2683.0 |
| 2008-12-18 | FTDX | Futures | 417.9 | 425.1 | 414.4 | 423.3 | 3414.0 |
| 2008-12-18 | FTI | Futures | 199.62 | 201.46 | 198.18 | 200.38 | 9996.0 |
| 2008-12-18 | FTUK | Futures | 2806.9 | 2844.6 | 2756.4 | 2822.6 | 114993.0 |
| 2008-12-18 | G | Futures | 76.09 | 76.51 | 75.94 | 76.35 | 44702.0 |
| 2008-12-18 | GF | Futures | 259.582 | 259.582 | 252.948 | 255.436 | 626.0 |
| 2008-12-18 | GSCI | Futures | 824.22 | 824.22 | 793.3 | 800.44 | 628.0 |
| 2008-12-18 | HE | Futures | 121.108 | 121.35 | 120.287 | 120.77 | 3740.0 |
| 2008-12-18 | HG | Futures | 1.9423 | 1.9515 | 1.8107 | 1.8318 | 9789.0 |
| 2008-12-18 | HO | Futures | 1.6639 | 1.6985 | 1.5743 | 1.5793 | 11509.0 |
| 2008-12-18 | HRC | Futures | 3130.5 | 3130.5 | 3130.5 | 3130.5 | 0.0 |
| 2008-12-18 | J1 | Futures | 0.0144843 | 0.0144893 | 0.0140409 | 0.0141432 | 79988.0 |
| 2008-12-18 | J7 | Futures | 0.014325 | 0.014325 | 0.013878 | 0.013973 | 104.0 |
| 2008-12-18 | JB | Futures | 116.68 | 116.95 | 116.55 | 116.77 | 1.0 |
| 2008-12-18 | KC | Futures | 321.53 | 324.67 | 319.24 | 321.53 | 4527.0 |
| 2008-12-18 | KE | Futures | 2887.98 | 2977.92 | 2872.99 | 2950.44 | 5711.0 |
| 2008-12-18 | L | Futures | 96.728 | 96.778 | 96.625 | 96.674 | 44272.0 |
| 2008-12-18 | LBS | Futures | 1068.0 | 1083.7 | 1066.3 | 1083.7 | 10.0 |
> showing 50 of 86 rows — these rows as CSV