PREVIEW / futures_daily / 2008-03-18
file: by_date/futures_daily/2008/2008-03-18.parquet size: 8 KB rows: 82
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-03-18 | ES | Futures | 1186.65 | 1235.72 | 1184.1 | 1235.26 | 3129809.0 |
| 2008-03-18 | NQ | Futures | 1896.13 | 1981.64 | 1894.17 | 1979.68 | 573469.0 |
| 2008-03-18 | YM | Futures | 10652.9 | 11018.8 | 10645.0 | 11015.2 | 216700.0 |
| 2008-03-18 | CL | Futures | 455.01 | 473.53 | 453.27 | 471.79 | 317657.0 |
| 2008-03-18 | GC | Futures | 1434.9 | 1448.8 | 1422.2 | 1435.8 | 169337.0 |
| 2008-03-18 | ZN | Futures | 87.232679 | 87.323772 | 86.503937 | 86.663349 | 1188601.0 |
| 2008-03-18 | A6 | Futures | 0.69295 | 0.70203 | 0.69119 | 0.70005 | 46856.0 |
| 2008-03-18 | AD | Futures | 0.98191 | 0.99075 | 0.98171 | 0.98918 | 41185.0 |
| 2008-03-18 | B | Futures | 122.11 | 126.73 | 121.38 | 125.99 | 123014.0 |
| 2008-03-18 | B6 | Futures | 2.0272 | 2.0563 | 2.0243 | 2.0474 | 112267.0 |
| 2008-03-18 | BFX | Futures | 4018.5 | 4165.1 | 4018.5 | 4144.0 | 14557.0 |
| 2008-03-18 | BZ | Futures | 119.5 | 124.2 | 119.5 | 123.58 | 1949.0 |
| 2008-03-18 | C | Futures | 1221.0 | 1237.0 | 1182.0 | 1234.0 | 12930.0 |
| 2008-03-18 | CB | Futures | 89.011 | 89.011 | 88.378 | 88.378 | 5.0 |
| 2008-03-18 | CC | Futures | 2459.0 | 2466.0 | 2374.0 | 2389.0 | 483.0 |
| 2008-03-18 | CT | Futures | 87.58 | 90.29 | 86.34 | 88.43 | 13713.0 |
| 2008-03-18 | DC | Futures | 45.69 | 46.18 | 45.69 | 46.1 | 56.0 |
| 2008-03-18 | DX | Futures | 77.388 | 78.142 | 77.017 | 78.142 | 23.0 |
| 2008-03-18 | E1 | Futures | 1.35347 | 1.36119 | 1.32709 | 1.33601 | 57544.0 |
| 2008-03-18 | E6 | Futures | 1.82332 | 1.8352 | 1.81004 | 1.82123 | 242195.0 |
| 2008-03-18 | E7 | Futures | 1.8075 | 1.8192 | 1.7945 | 1.8056 | 2556.0 |
| 2008-03-18 | EBM | Futures | 242.29 | 245.99 | 241.63 | 244.03 | 1521.0 |
| 2008-03-18 | ED | Futures | 92.2613 | 92.2801 | 92.0402 | 92.0684 | 452395.0 |
| 2008-03-18 | ER | Futures | 94.106 | 94.125 | 93.993 | 94.076 | 234181.0 |
| 2008-03-18 | EW | Futures | 736.9 | 768.9 | 735.2 | 767.9 | 48050.0 |
| 2008-03-18 | FCE | Futures | 2889.3 | 2970.9 | 2876.8 | 2950.0 | 195450.0 |
| 2008-03-18 | FDAX | Futures | 7203.4 | 7438.2 | 7176.1 | 7438.2 | 87104.0 |
| 2008-03-18 | FESX | Futures | 1991.6 | 2073.6 | 1991.0 | 2073.6 | 1574682.0 |
| 2008-03-18 | FEU3 | Futures | 94.64 | 94.64 | 94.576 | 94.605 | 7703.0 |
| 2008-03-18 | FGBL | Futures | 89.0 | 89.02 | 88.4 | 88.4 | 1127835.0 |
| 2008-03-18 | FGBM | Futures | 94.96 | 94.98 | 94.36 | 94.36 | 630061.0 |
| 2008-03-18 | FGBS | Futures | 102.236 | 102.236 | 101.809 | 101.809 | 944205.0 |
| 2008-03-18 | FGBX | Futures | 77.69 | 77.85 | 77.35 | 77.59 | 3615.0 |
| 2008-03-18 | FTDX | Futures | 641.0 | 653.7 | 633.8 | 633.8 | 5740.0 |
| 2008-03-18 | FTI | Futures | 314.42 | 319.58 | 313.56 | 319.1 | 47654.0 |
| 2008-03-18 | FTUK | Futures | 3562.4 | 3640.1 | 3559.2 | 3629.5 | 231781.0 |
| 2008-03-18 | G | Futures | 70.86 | 70.95 | 70.47 | 70.62 | 97183.0 |
| 2008-03-18 | GF | Futures | 290.987 | 294.635 | 290.916 | 293.276 | 81.0 |
| 2008-03-18 | GSCI | Futures | 1808.49 | 1869.39 | 1808.49 | 1869.39 | 1128.0 |
| 2008-03-18 | HE | Futures | 131.025 | 131.866 | 129.196 | 131.866 | 57.0 |
| 2008-03-18 | HG | Futures | 5.1907 | 5.2486 | 5.1063 | 5.2263 | 9000.0 |
| 2008-03-18 | HO | Futures | 3.4061 | 3.5104 | 3.3719 | 3.4941 | 12878.0 |
| 2008-03-18 | J1 | Futures | 0.013164 | 0.0132227 | 0.0128118 | 0.0129292 | 163517.0 |
| 2008-03-18 | J7 | Futures | 0.012855 | 0.012941 | 0.01255 | 0.012657 | 69.0 |
| 2008-03-18 | JB | Futures | 118.0 | 118.03 | 117.07 | 117.21 | 2853.0 |
| 2008-03-18 | KC | Futures | 433.92 | 441.02 | 424.14 | 434.08 | 30204.0 |
| 2008-03-18 | KE | Futures | 6395.75 | 6525.97 | 6323.25 | 6513.89 | 4395.0 |
| 2008-03-18 | L | Futures | 93.765 | 93.825 | 93.716 | 93.745 | 181192.0 |
| 2008-03-18 | LE | Futures | 189.414 | 192.83 | 189.047 | 192.304 | 3273.0 |
| 2008-03-18 | MP | Futures | 0.04378 | 0.04422 | 0.04372 | 0.04422 | 31671.0 |
> showing 50 of 82 rows — these rows as CSV