PREVIEW / futures_daily / 2009-08-26
file: by_date/futures_daily/2009/2009-08-26.parquet size: 8 KB rows: 85
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-26 | ES | Futures | 984.15 | 990.14 | 978.87 | 985.11 | 1886346.0 |
| 2009-08-26 | NQ | Futures | 1842.96 | 1857.32 | 1832.83 | 1842.96 | 262334.0 |
| 2009-08-26 | YM | Futures | 8590.3 | 8636.3 | 8547.0 | 8594.8 | 139458.0 |
| 2009-08-26 | CL | Futures | 178.02 | 181.24 | 176.32 | 178.22 | 255501.0 |
| 2009-08-26 | GC | Futures | 1308.1 | 1315.7 | 1301.1 | 1307.5 | 68602.0 |
| 2009-08-26 | ZN | Futures | 92.96048 | 93.108232 | 92.788103 | 92.985105 | 1041353.0 |
| 2009-08-26 | A6 | Futures | 0.66974 | 0.67312 | 0.66219 | 0.66428 | 87286.0 |
| 2009-08-26 | AD | Futures | 0.90909 | 0.91196 | 0.89773 | 0.89931 | 65189.0 |
| 2009-08-26 | B | Futures | 68.1 | 69.13 | 67.38 | 68.31 | 53053.0 |
| 2009-08-26 | B6 | Futures | 1.702 | 1.7035 | 1.6831 | 1.6912 | 104778.0 |
| 2009-08-26 | BFX | Futures | 2753.8 | 2756.8 | 2728.4 | 2728.8 | 151.0 |
| 2009-08-26 | BR | Futures | 0.21029 | 0.21031 | 0.20965 | 0.21031 | 434.0 |
| 2009-08-26 | BZ | Futures | 71.23 | 71.23 | 70.63 | 71.1 | 6.0 |
| 2009-08-26 | C | Futures | 2011.0 | 2011.0 | 1985.0 | 1989.0 | 725.0 |
| 2009-08-26 | CC | Futures | 2633.0 | 2633.0 | 2581.0 | 2596.0 | 4202.0 |
| 2009-08-26 | CT | Futures | 49.73 | 50.38 | 48.74 | 48.98 | 166.0 |
| 2009-08-26 | DC | Futures | 23.4 | 23.48 | 22.71 | 22.75 | 212.0 |
| 2009-08-26 | DX | Futures | 80.261 | 80.752 | 80.025 | 80.573 | 9161.0 |
| 2009-08-26 | E1 | Futures | 1.24754 | 1.25151 | 1.2351 | 1.23894 | 39115.0 |
| 2009-08-26 | E6 | Futures | 1.6972 | 1.70384 | 1.68639 | 1.69055 | 197537.0 |
| 2009-08-26 | E7 | Futures | 1.6797 | 1.6862 | 1.6691 | 1.6732 | 1667.0 |
| 2009-08-26 | ED | Futures | 94.0652 | 94.0794 | 94.0605 | 94.0746 | 90698.0 |
| 2009-08-26 | ER | Futures | 97.139 | 97.144 | 97.13 | 97.144 | 42489.0 |
| 2009-08-26 | EW | Futures | 636.7 | 641.3 | 633.4 | 637.3 | 30260.0 |
| 2009-08-26 | FCE | Futures | 2399.3 | 2415.0 | 2390.1 | 2398.7 | 103622.0 |
| 2009-08-26 | FDAX | Futures | 6089.3 | 6115.6 | 6035.5 | 6064.6 | 124451.0 |
| 2009-08-26 | FESX | Futures | 1667.7 | 1677.2 | 1657.0 | 1663.5 | 1005719.0 |
| 2009-08-26 | FEU3 | Futures | 97.712 | 97.722 | 97.712 | 97.722 | 501.0 |
| 2009-08-26 | FGBL | Futures | 93.1 | 93.41 | 92.94 | 93.35 | 697811.0 |
| 2009-08-26 | FGBM | Futures | 98.43 | 98.62 | 98.29 | 98.58 | 367970.0 |
| 2009-08-26 | FGBS | Futures | 104.167 | 104.263 | 104.109 | 104.244 | 462867.0 |
| 2009-08-26 | FGBX | Futures | 86.51 | 87.07 | 86.32 | 86.97 | 2315.0 |
| 2009-08-26 | FTDX | Futures | 629.5 | 642.4 | 625.9 | 628.2 | 400.0 |
| 2009-08-26 | FTI | Futures | 247.15 | 249.46 | 245.79 | 246.57 | 35559.0 |
| 2009-08-26 | FTUK | Futures | 3258.3 | 3268.9 | 3231.4 | 3243.7 | 89883.0 |
| 2009-08-26 | G | Futures | 76.93 | 77.14 | 76.82 | 76.98 | 114302.0 |
| 2009-08-26 | GF | Futures | 276.587 | 276.863 | 274.375 | 274.513 | 851.0 |
| 2009-08-26 | GSCI | Futures | 940.62 | 942.46 | 931.45 | 940.62 | 339.0 |
| 2009-08-26 | HE | Futures | 72.963 | 73.45 | 69.552 | 70.527 | 11230.0 |
| 2009-08-26 | HG | Futures | 3.9715 | 4.0768 | 3.9555 | 4.0092 | 12477.0 |
| 2009-08-26 | HO | Futures | 1.8744 | 1.8825 | 1.8365 | 1.8686 | 10661.0 |
| 2009-08-26 | HRC | Futures | 2586.5 | 2586.5 | 2586.5 | 2586.5 | 0.0 |
| 2009-08-26 | J1 | Futures | 0.0133684 | 0.0134112 | 0.013303 | 0.0133722 | 70751.0 |
| 2009-08-26 | J7 | Futures | 0.013191 | 0.013222 | 0.013115 | 0.013188 | 46.0 |
| 2009-08-26 | JB | Futures | 117.02 | 117.1 | 116.97 | 116.99 | 1666.0 |
| 2009-08-26 | KC | Futures | 320.46 | 329.3 | 318.74 | 328.64 | 7664.0 |
| 2009-08-26 | KE | Futures | 2419.58 | 2461.46 | 2414.93 | 2452.15 | 7280.0 |
| 2009-08-26 | L | Futures | 97.612 | 97.681 | 97.602 | 97.651 | 71149.0 |
| 2009-08-26 | LBS | Futures | 727.4 | 738.8 | 718.5 | 729.5 | 581.0 |
| 2009-08-26 | LE | Futures | 147.679 | 147.887 | 145.389 | 145.473 | 20772.0 |
> showing 50 of 85 rows — these rows as CSV