PREVIEW / futures_daily / 2011-04-11
file: by_date/futures_daily/2011/2011-04-11.parquet size: 9 KB rows: 91
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-11 | ES | Futures | 1312.51 | 1316.96 | 1303.84 | 1306.32 | 1527470.0 |
| 2011-04-11 | NQ | Futures | 2645.35 | 2658.16 | 2621.72 | 2628.55 | 224000.0 |
| 2011-04-11 | YM | Futures | 11600.8 | 11649.7 | 11561.3 | 11583.9 | 88781.0 |
| 2011-04-11 | CL | Futures | 219.06 | 219.41 | 210.16 | 212.56 | 364348.0 |
| 2011-04-11 | GC | Futures | 1998.2 | 2000.5 | 1976.4 | 1987.1 | 110657.0 |
| 2011-04-11 | ZN | Futures | 99.643924 | 99.920456 | 99.499073 | 99.828279 | 724832.0 |
| 2011-04-11 | A6 | Futures | 0.89773 | 0.90039 | 0.89198 | 0.89318 | 59886.0 |
| 2011-04-11 | AD | Futures | 1.04043 | 1.04183 | 1.03804 | 1.03904 | 55620.0 |
| 2011-04-11 | B | Futures | 107.08 | 107.28 | 103.86 | 104.69 | 174499.0 |
| 2011-04-11 | B6 | Futures | 1.6997 | 1.7051 | 1.6934 | 1.6967 | 85638.0 |
| 2011-04-11 | BR | Futures | 0.27696 | 0.27696 | 0.27498 | 0.27568 | 651.0 |
| 2011-04-11 | BZ | Futures | 111.14 | 112.47 | 110.13 | 110.38 | 1297.0 |
| 2011-04-11 | C | Futures | 2087.0 | 2157.0 | 2087.0 | 2114.0 | 4923.0 |
| 2011-04-11 | CC | Futures | 2389.0 | 2451.0 | 2383.0 | 2410.0 | 12570.0 |
| 2011-04-11 | CSC | Futures | 4.564 | 4.618 | 4.564 | 4.585 | 1.0 |
| 2011-04-11 | CT | Futures | 183.3 | 185.76 | 178.26 | 182.94 | 11824.0 |
| 2011-04-11 | DC | Futures | 29.93 | 30.62 | 29.91 | 30.47 | 205.0 |
| 2011-04-11 | DX | Futures | 74.79 | 74.929 | 74.725 | 74.906 | 16889.0 |
| 2011-04-11 | E1 | Futures | 1.44177 | 1.4478 | 1.43837 | 1.44505 | 28908.0 |
| 2011-04-11 | E6 | Futures | 1.70934 | 1.71301 | 1.70567 | 1.70662 | 174733.0 |
| 2011-04-11 | E7 | Futures | 1.6971 | 1.7001 | 1.6931 | 1.6939 | 4230.0 |
| 2011-04-11 | EBM | Futures | 233.2 | 235.08 | 232.03 | 233.2 | 6737.0 |
| 2011-04-11 | ED | Futures | 94.9311 | 94.9359 | 94.9264 | 94.9311 | 119781.0 |
| 2011-04-11 | ER | Futures | 97.207 | 97.237 | 97.207 | 97.222 | 150734.0 |
| 2011-04-11 | EW | Futures | 981.8 | 984.4 | 970.1 | 972.4 | 16829.0 |
| 2011-04-11 | FBTP | Futures | 64.37 | 64.54 | 64.29 | 64.49 | 3666.0 |
| 2011-04-11 | FCE | Futures | 2697.1 | 2700.1 | 2677.5 | 2688.5 | 95780.0 |
| 2011-04-11 | FDAX | Futures | 7714.0 | 7736.4 | 7660.1 | 7716.7 | 109021.0 |
| 2011-04-11 | FESX | Futures | 1859.4 | 1863.8 | 1849.7 | 1859.4 | 777903.0 |
| 2011-04-11 | FEU3 | Futures | 97.775 | 97.775 | 97.765 | 97.765 | 3.0 |
| 2011-04-11 | FGBL | Futures | 96.02 | 96.15 | 95.91 | 95.94 | 577375.0 |
| 2011-04-11 | FGBM | Futures | 101.95 | 102.06 | 101.88 | 101.93 | 336509.0 |
| 2011-04-11 | FGBS | Futures | 106.003 | 106.033 | 105.958 | 105.998 | 322264.0 |
| 2011-04-11 | FGBX | Futures | 90.66 | 90.92 | 90.49 | 90.55 | 4132.0 |
| 2011-04-11 | FTDX | Futures | 835.1 | 839.5 | 827.9 | 831.9 | 1445.0 |
| 2011-04-11 | FTI | Futures | 298.85 | 299.47 | 297.2 | 298.56 | 1485.0 |
| 2011-04-11 | FTUK | Futures | 4209.2 | 4220.8 | 4191.7 | 4207.5 | 69112.0 |
| 2011-04-11 | FXXP | Futures | 185.1 | 185.3 | 184.8 | 185.2 | 2207.0 |
| 2011-04-11 | G | Futures | 80.56 | 80.63 | 80.4 | 80.47 | 68204.0 |
| 2011-04-11 | GF | Futures | 325.738 | 326.22 | 323.993 | 324.595 | 1785.0 |
| 2011-04-11 | GSCI | Futures | 1187.12 | 1187.12 | 1168.14 | 1173.13 | 2587.0 |
| 2011-04-11 | HE | Futures | 107.318 | 108.035 | 107.159 | 107.849 | 1045.0 |
| 2011-04-11 | HG | Futures | 6.0292 | 6.0379 | 5.9194 | 5.9407 | 38601.0 |
| 2011-04-11 | HO | Futures | 2.7628 | 2.7683 | 2.6959 | 2.7127 | 28911.0 |
| 2011-04-11 | HRC | Futures | 3106.0 | 3106.0 | 3106.0 | 3106.0 | 0.0 |
| 2011-04-11 | J1 | Futures | 0.0148006 | 0.0148722 | 0.0147566 | 0.0148445 | 98187.0 |
| 2011-04-11 | J7 | Futures | 0.014704 | 0.014779 | 0.014667 | 0.014754 | 757.0 |
| 2011-04-11 | JB | Futures | 120.54 | 120.76 | 120.54 | 120.73 | 64.0 |
| 2011-04-11 | KC | Futures | 663.37 | 671.12 | 654.03 | 665.55 | 16832.0 |
| 2011-04-11 | KE | Futures | 3770.39 | 3791.47 | 3661.01 | 3689.11 | 17278.0 |
> showing 50 of 91 rows — these rows as CSV