PREVIEW / futures_daily / 2011-04-04
file: by_date/futures_daily/2011/2011-04-04.parquet size: 9 KB rows: 93
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-04 | ES | Futures | 1313.74 | 1319.44 | 1311.27 | 1315.97 | 1273974.0 |
| 2011-04-04 | NQ | Futures | 2661.86 | 2676.1 | 2644.49 | 2665.56 | 213559.0 |
| 2011-04-04 | YM | Futures | 11572.6 | 11607.4 | 11551.0 | 11599.0 | 59990.0 |
| 2011-04-04 | CL | Futures | 209.41 | 210.36 | 208.04 | 209.76 | 228494.0 |
| 2011-04-04 | GC | Futures | 1935.5 | 1949.5 | 1934.3 | 1939.6 | 83872.0 |
| 2011-04-04 | ZN | Futures | 100.289166 | 100.671045 | 100.183821 | 100.473521 | 827356.0 |
| 2011-04-04 | A6 | Futures | 0.88341 | 0.88564 | 0.87869 | 0.88049 | 54940.0 |
| 2011-04-04 | AD | Futures | 1.03018 | 1.03386 | 1.0262 | 1.02759 | 55984.0 |
| 2011-04-04 | B | Futures | 100.74 | 102.54 | 100.53 | 102.35 | 116348.0 |
| 2011-04-04 | B6 | Futures | 1.6723 | 1.679 | 1.6718 | 1.6738 | 81906.0 |
| 2011-04-04 | BFX | Futures | 3114.5 | 3124.8 | 3102.7 | 3102.7 | 131.0 |
| 2011-04-04 | BR | Futures | 0.2704 | 0.2704 | 0.2697 | 0.27001 | 147.0 |
| 2011-04-04 | BZ | Futures | 106.67 | 108.06 | 106.4 | 107.91 | 1118.0 |
| 2011-04-04 | C | Futures | 2169.0 | 2197.0 | 2146.0 | 2160.0 | 4449.0 |
| 2011-04-04 | CB | Futures | 114.402 | 115.282 | 114.402 | 115.282 | 5.0 |
| 2011-04-04 | CC | Futures | 2420.0 | 2479.0 | 2398.0 | 2419.0 | 11929.0 |
| 2011-04-04 | CSC | Futures | 4.309 | 4.309 | 4.291 | 4.291 | 2.0 |
| 2011-04-04 | CT | Futures | 174.38 | 175.7 | 171.88 | 174.86 | 6688.0 |
| 2011-04-04 | DC | Futures | 28.69 | 28.74 | 28.39 | 28.46 | 231.0 |
| 2011-04-04 | DX | Futures | 75.85 | 75.855 | 75.556 | 75.779 | 13605.0 |
| 2011-04-04 | E1 | Futures | 1.41663 | 1.42514 | 1.41441 | 1.4182 | 31322.0 |
| 2011-04-04 | E6 | Futures | 1.68399 | 1.68778 | 1.67878 | 1.68174 | 204570.0 |
| 2011-04-04 | E7 | Futures | 1.6712 | 1.6751 | 1.6663 | 1.6692 | 4052.0 |
| 2011-04-04 | EBM | Futures | 228.74 | 232.26 | 227.8 | 231.09 | 5382.0 |
| 2011-04-04 | ED | Futures | 94.8883 | 94.9121 | 94.8835 | 94.9073 | 249874.0 |
| 2011-04-04 | ER | Futures | 97.277 | 97.286 | 97.267 | 97.286 | 59713.0 |
| 2011-04-04 | EW | Futures | 987.7 | 992.7 | 986.2 | 989.0 | 17706.0 |
| 2011-04-04 | FBTP | Futures | 63.88 | 64.3 | 63.88 | 64.23 | 3733.0 |
| 2011-04-04 | FCE | Futures | 2693.8 | 2702.5 | 2685.8 | 2692.5 | 76612.0 |
| 2011-04-04 | FDAX | Futures | 7683.6 | 7709.7 | 7669.2 | 7687.9 | 85245.0 |
| 2011-04-04 | FESX | Futures | 1847.2 | 1854.2 | 1840.8 | 1847.8 | 707322.0 |
| 2011-04-04 | FEU3 | Futures | 97.82 | 97.83 | 97.82 | 97.83 | 25.0 |
| 2011-04-04 | FGBL | Futures | 96.91 | 96.98 | 96.69 | 96.95 | 578857.0 |
| 2011-04-04 | FGBM | Futures | 102.45 | 102.55 | 102.35 | 102.54 | 383738.0 |
| 2011-04-04 | FGBS | Futures | 106.186 | 106.211 | 106.147 | 106.206 | 334085.0 |
| 2011-04-04 | FGBX | Futures | 92.65 | 92.82 | 92.27 | 92.73 | 3437.0 |
| 2011-04-04 | FTDX | Futures | 835.1 | 842.6 | 835.1 | 842.6 | 96.0 |
| 2011-04-04 | FTI | Futures | 299.79 | 301.38 | 299.09 | 300.32 | 25659.0 |
| 2011-04-04 | FTUK | Futures | 4173.9 | 4199.8 | 4160.6 | 4184.0 | 79961.0 |
| 2011-04-04 | FXXP | Futures | 184.7 | 185.1 | 183.7 | 184.7 | 2084.0 |
| 2011-04-04 | G | Futures | 81.18 | 81.18 | 80.88 | 81.13 | 79275.0 |
| 2011-04-04 | GF | Futures | 334.571 | 334.753 | 332.212 | 333.361 | 421.0 |
| 2011-04-04 | GSCI | Futures | 1147.27 | 1156.59 | 1147.04 | 1156.35 | 260.0 |
| 2011-04-04 | HE | Futures | 108.54 | 109.762 | 108.487 | 109.762 | 259.0 |
| 2011-04-04 | HG | Futures | 5.6736 | 5.7415 | 5.6257 | 5.6676 | 25114.0 |
| 2011-04-04 | HO | Futures | 2.6176 | 2.648 | 2.615 | 2.6435 | 15245.0 |
| 2011-04-04 | HRC | Futures | 3070.7 | 3070.7 | 3070.7 | 3070.7 | 0.0 |
| 2011-04-04 | J1 | Futures | 0.0149337 | 0.014989 | 0.0148935 | 0.0149476 | 88289.0 |
| 2011-04-04 | J7 | Futures | 0.014847 | 0.014895 | 0.014806 | 0.014856 | 417.0 |
| 2011-04-04 | JB | Futures | 121.15 | 121.25 | 121.07 | 121.13 | 25.0 |
> showing 50 of 93 rows — these rows as CSV