PREVIEW / futures_daily / 2008-11-18
file: by_date/futures_daily/2008/2008-11-18.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-11-18 | ES | Futures | 801.09 | 818.27 | 776.6 | 815.92 | 3277728.0 |
| 2008-11-18 | NQ | Futures | 1296.28 | 1314.74 | 1244.83 | 1313.06 | 437110.0 |
| 2008-11-18 | YM | Futures | 7336.0 | 7576.7 | 7181.4 | 7545.6 | 335735.0 |
| 2008-11-18 | CL | Futures | 234.38 | 238.73 | 229.81 | 231.54 | 156195.0 |
| 2008-11-18 | GC | Futures | 1030.5 | 1042.7 | 1021.3 | 1024.7 | 95165.0 |
| 2008-11-18 | ZN | Futures | 87.977191 | 88.748614 | 87.942127 | 88.620043 | 569275.0 |
| 2008-11-18 | A6 | Futures | 0.50767 | 0.51664 | 0.50294 | 0.50562 | 21158.0 |
| 2008-11-18 | AD | Futures | 0.80212 | 0.80952 | 0.7957 | 0.79689 | 23587.0 |
| 2008-11-18 | B | Futures | 59.58 | 60.31 | 58.25 | 58.92 | 103953.0 |
| 2008-11-18 | B6 | Futures | 1.5521 | 1.5661 | 1.546 | 1.5476 | 57892.0 |
| 2008-11-18 | BFX | Futures | 2278.1 | 2278.1 | 2227.5 | 2257.6 | 15885.0 |
| 2008-11-18 | BR | Futures | 0.16363 | 0.16514 | 0.16306 | 0.16325 | 225.0 |
| 2008-11-18 | BZ | Futures | 58.0 | 58.49 | 57.01 | 57.08 | 125.0 |
| 2008-11-18 | C | Futures | 1284.0 | 1305.0 | 1275.0 | 1302.0 | 3121.0 |
| 2008-11-18 | CC | Futures | 1757.0 | 1814.0 | 1750.0 | 1805.0 | 4755.0 |
| 2008-11-18 | CT | Futures | 39.53 | 39.83 | 38.58 | 39.22 | 5666.0 |
| 2008-11-18 | DC | Futures | 38.02 | 38.63 | 37.72 | 38.4 | 186.0 |
| 2008-11-18 | DX | Futures | 91.619 | 91.981 | 91.263 | 91.923 | 2376.0 |
| 2008-11-18 | E1 | Futures | 1.11386 | 1.11613 | 1.10852 | 1.10919 | 20990.0 |
| 2008-11-18 | E6 | Futures | 1.49037 | 1.49888 | 1.48281 | 1.48423 | 141195.0 |
| 2008-11-18 | E7 | Futures | 1.4762 | 1.4842 | 1.4687 | 1.47 | 2564.0 |
| 2008-11-18 | ED | Futures | 92.427 | 92.5285 | 92.4034 | 92.5144 | 114058.0 |
| 2008-11-18 | ER | Futures | 95.129 | 95.153 | 95.094 | 95.134 | 80232.0 |
| 2008-11-18 | EW | Futures | 482.2 | 490.7 | 462.1 | 490.3 | 40246.0 |
| 2008-11-18 | FCE | Futures | 1895.4 | 1947.6 | 1856.8 | 1927.2 | 168064.0 |
| 2008-11-18 | FDAX | Futures | 5093.8 | 5183.8 | 4984.2 | 5117.3 | 190204.0 |
| 2008-11-18 | FESX | Futures | 1362.3 | 1399.3 | 1334.5 | 1379.6 | 1832728.0 |
| 2008-11-18 | FEU3 | Futures | 95.709 | 95.714 | 95.694 | 95.699 | 2181.0 |
| 2008-11-18 | FGBL | Futures | 89.43 | 89.71 | 89.31 | 89.36 | 541040.0 |
| 2008-11-18 | FGBM | Futures | 95.94 | 95.99 | 95.81 | 95.85 | 299112.0 |
| 2008-11-18 | FGBS | Futures | 102.73 | 102.769 | 102.653 | 102.668 | 322675.0 |
| 2008-11-18 | FGBX | Futures | 80.07 | 80.8 | 79.78 | 80.26 | 958.0 |
| 2008-11-18 | FTDX | Futures | 444.7 | 444.7 | 401.9 | 439.4 | 673.0 |
| 2008-11-18 | FTI | Futures | 196.81 | 203.46 | 192.19 | 201.3 | 47979.0 |
| 2008-11-18 | FTUK | Futures | 2676.0 | 2756.7 | 2607.9 | 2714.6 | 161665.0 |
| 2008-11-18 | G | Futures | 71.34 | 71.61 | 71.33 | 71.34 | 69384.0 |
| 2008-11-18 | GF | Futures | 259.513 | 261.518 | 252.257 | 252.257 | 609.0 |
| 2008-11-18 | GSCI | Futures | 995.44 | 998.7 | 977.4 | 977.4 | 386.0 |
| 2008-11-18 | HE | Futures | 119.948 | 120.915 | 119.417 | 120.238 | 3854.0 |
| 2008-11-18 | HG | Futures | 2.3188 | 2.4054 | 2.2731 | 2.3526 | 8092.0 |
| 2008-11-18 | HO | Futures | 2.0296 | 2.0628 | 2.0055 | 2.0102 | 3288.0 |
| 2008-11-18 | J1 | Futures | 0.0131276 | 0.0131681 | 0.0129735 | 0.0131087 | 97701.0 |
| 2008-11-18 | J7 | Futures | 0.012884 | 0.012958 | 0.012776 | 0.012909 | 64.0 |
| 2008-11-18 | JB | Futures | 115.27 | 115.57 | 115.27 | 115.38 | 709.0 |
| 2008-11-18 | KC | Futures | 323.74 | 330.23 | 323.74 | 326.24 | 4543.0 |
| 2008-11-18 | KE | Futures | 2923.29 | 2990.32 | 2892.36 | 2892.36 | 8366.0 |
| 2008-11-18 | L | Futures | 95.679 | 95.817 | 95.679 | 95.733 | 45141.0 |
| 2008-11-18 | LBS | Futures | 1239.6 | 1240.2 | 1212.2 | 1212.2 | 32.0 |
| 2008-11-18 | LE | Futures | 159.132 | 160.25 | 156.18 | 156.717 | 5254.0 |
| 2008-11-18 | MP | Futures | 0.0367 | 0.03696 | 0.03651 | 0.03685 | 3278.0 |
> showing 50 of 84 rows — these rows as CSV