PREVIEW / futures_daily / 2011-05-04
file: by_date/futures_daily/2011/2011-05-04.parquet size: 9 KB rows: 97
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-05-04 | ES | Futures | 1338.25 | 1341.46 | 1324.14 | 1329.58 | 2382666.0 |
| 2011-05-04 | NQ | Futures | 2721.65 | 2728.77 | 2693.18 | 2715.1 | 300764.0 |
| 2011-05-04 | YM | Futures | 11987.2 | 12012.6 | 11866.0 | 11913.9 | 143808.0 |
| 2011-05-04 | CL | Futures | 213.29 | 214.33 | 209.05 | 210.51 | 333018.0 |
| 2011-05-04 | GC | Futures | 2081.3 | 2089.1 | 2037.7 | 2051.0 | 242222.0 |
| 2011-05-04 | ZN | Futures | 102.382913 | 102.63311 | 102.198558 | 102.514596 | 1109365.0 |
| 2011-05-04 | A6 | Futures | 0.92483 | 0.92826 | 0.91548 | 0.91754 | 135704.0 |
| 2011-05-04 | AD | Futures | 1.04382 | 1.04671 | 1.03575 | 1.03884 | 106081.0 |
| 2011-05-04 | B | Futures | 103.48 | 104.19 | 102.06 | 102.65 | 112179.0 |
| 2011-05-04 | B6 | Futures | 1.7118 | 1.721 | 1.7083 | 1.7149 | 109433.0 |
| 2011-05-04 | BFX | Futures | 3217.5 | 3219.9 | 3166.6 | 3166.6 | 47.0 |
| 2011-05-04 | BR | Futures | 0.27594 | 0.27594 | 0.27146 | 0.27258 | 199.0 |
| 2011-05-04 | BZ | Futures | 109.58 | 109.58 | 107.87 | 108.17 | 586.0 |
| 2011-05-04 | C | Futures | 2187.0 | 2205.0 | 2134.0 | 2139.0 | 1346.0 |
| 2011-05-04 | CB | Futures | 122.029 | 122.029 | 122.029 | 122.029 | 5.0 |
| 2011-05-04 | CC | Futures | 2603.0 | 2651.0 | 2514.0 | 2556.0 | 16582.0 |
| 2011-05-04 | CSC | Futures | 4.464 | 4.464 | 4.425 | 4.451 | 16.0 |
| 2011-05-04 | CT | Futures | 155.0 | 155.62 | 149.96 | 149.96 | 4316.0 |
| 2011-05-04 | DC | Futures | 29.93 | 30.03 | 29.67 | 29.84 | 142.0 |
| 2011-05-04 | DX | Futures | 72.894 | 73.113 | 72.496 | 72.848 | 36599.0 |
| 2011-05-04 | E1 | Futures | 1.5206 | 1.5316 | 1.51392 | 1.52322 | 42918.0 |
| 2011-05-04 | E6 | Futures | 1.75388 | 1.76786 | 1.74808 | 1.75696 | 374774.0 |
| 2011-05-04 | E7 | Futures | 1.7407 | 1.7547 | 1.7351 | 1.7439 | 7781.0 |
| 2011-05-04 | EBM | Futures | 232.03 | 232.73 | 231.09 | 232.26 | 5638.0 |
| 2011-05-04 | ED | Futures | 94.9454 | 94.9549 | 94.9406 | 94.9454 | 171527.0 |
| 2011-05-04 | ER | Futures | 97.232 | 97.232 | 97.193 | 97.202 | 180243.0 |
| 2011-05-04 | EW | Futures | 991.8 | 994.2 | 978.3 | 981.3 | 21959.0 |
| 2011-05-04 | FBTP | Futures | 64.8 | 64.84 | 64.68 | 64.74 | 5404.0 |
| 2011-05-04 | FCE | Futures | 2737.9 | 2769.2 | 2710.3 | 2719.8 | 170024.0 |
| 2011-05-04 | FDAX | Futures | 7986.3 | 8074.4 | 7879.0 | 7895.6 | 179423.0 |
| 2011-05-04 | FESX | Futures | 1876.0 | 1895.2 | 1852.3 | 1857.4 | 1537645.0 |
| 2011-05-04 | FEU3 | Futures | 97.77 | 97.77 | 97.741 | 97.746 | 72.0 |
| 2011-05-04 | FGBL | Futures | 98.26 | 98.28 | 97.74 | 98.0 | 1068007.0 |
| 2011-05-04 | FGBM | Futures | 102.97 | 102.99 | 102.54 | 102.75 | 725341.0 |
| 2011-05-04 | FGBS | Futures | 106.221 | 106.221 | 106.052 | 106.097 | 1068283.0 |
| 2011-05-04 | FGBX | Futures | 94.72 | 94.72 | 93.55 | 93.96 | 4447.0 |
| 2011-05-04 | FTDX | Futures | 823.4 | 827.0 | 806.5 | 819.4 | 480.0 |
| 2011-05-04 | FTI | Futures | 292.88 | 295.64 | 290.41 | 291.27 | 40671.0 |
| 2011-05-04 | FTUK | Futures | 4211.7 | 4232.7 | 4160.6 | 4169.7 | 122085.0 |
| 2011-05-04 | FXXP | Futures | 186.3 | 187.3 | 184.3 | 184.6 | 4232.0 |
| 2011-05-04 | G | Futures | 83.13 | 83.44 | 82.85 | 83.37 | 172030.0 |
| 2011-05-04 | GF | Futures | 311.659 | 313.404 | 309.915 | 311.118 | 1002.0 |
| 2011-05-04 | GSCI | Futures | 1153.06 | 1158.45 | 1138.77 | 1141.89 | 453.0 |
| 2011-05-04 | HE | Futures | 97.899 | 98.614 | 97.264 | 97.581 | 21791.0 |
| 2011-05-04 | HG | Futures | 5.641 | 5.6523 | 5.4803 | 5.4923 | 35610.0 |
| 2011-05-04 | HO | Futures | 2.6507 | 2.664 | 2.6038 | 2.6116 | 61183.0 |
| 2011-05-04 | HRC | Futures | 3000.1 | 3000.1 | 3000.1 | 3000.1 | 0.0 |
| 2011-05-04 | J1 | Futures | 0.0155217 | 0.0156222 | 0.0154752 | 0.0155908 | 92720.0 |
| 2011-05-04 | J7 | Futures | 0.015413 | 0.015555 | 0.015382 | 0.015495 | 723.0 |
| 2011-05-04 | JB | Futures | 122.32 | 122.67 | 122.24 | 122.31 | 136.0 |
> showing 50 of 97 rows — these rows as CSV