PREVIEW / futures_daily / 2010-05-18
file: by_date/futures_daily/2010/2010-05-18.parquet size: 9 KB rows: 90
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-18 | ES | Futures | 1105.73 | 1117.42 | 1086.01 | 1089.42 | 3092769.0 |
| 2010-05-18 | NQ | Futures | 2169.32 | 2191.73 | 2129.05 | 2141.81 | 405003.0 |
| 2010-05-18 | YM | Futures | 9747.9 | 9834.3 | 9616.5 | 9643.1 | 201071.0 |
| 2010-05-18 | CL | Futures | 161.64 | 164.86 | 157.92 | 159.08 | 413717.0 |
| 2010-05-18 | GC | Futures | 1679.2 | 1687.1 | 1655.5 | 1666.5 | 185969.0 |
| 2010-05-18 | ZN | Futures | 97.488785 | 98.27951 | 97.386756 | 98.113713 | 1441663.0 |
| 2010-05-18 | A6 | Futures | 0.71772 | 0.71895 | 0.70541 | 0.70697 | 131980.0 |
| 2010-05-18 | AD | Futures | 0.95655 | 0.96346 | 0.94816 | 0.94885 | 92849.0 |
| 2010-05-18 | B | Futures | 67.07 | 67.81 | 65.52 | 65.89 | 211604.0 |
| 2010-05-18 | B6 | Futures | 1.5037 | 1.5077 | 1.4851 | 1.4868 | 141555.0 |
| 2010-05-18 | BFX | Futures | 2805.7 | 2840.8 | 2796.6 | 2825.7 | 2103.0 |
| 2010-05-18 | BR | Futures | 0.22574 | 0.22574 | 0.22451 | 0.22451 | 45.0 |
| 2010-05-18 | BZ | Futures | 71.26 | 71.31 | 68.97 | 69.34 | 32.0 |
| 2010-05-18 | C | Futures | 2218.0 | 2252.0 | 2203.0 | 2246.0 | 6877.0 |
| 2010-05-18 | CB | Futures | 79.946 | 79.946 | 78.959 | 78.959 | 7.0 |
| 2010-05-18 | CC | Futures | 2381.0 | 2398.0 | 2356.0 | 2393.0 | 10300.0 |
| 2010-05-18 | CT | Futures | 64.7 | 65.52 | 64.66 | 65.33 | 8613.0 |
| 2010-05-18 | DC | Futures | 22.53 | 22.69 | 22.16 | 22.2 | 316.0 |
| 2010-05-18 | DX | Futures | 87.524 | 88.694 | 87.195 | 88.482 | 45174.0 |
| 2010-05-18 | E1 | Futures | 1.16391 | 1.16865 | 1.14351 | 1.14772 | 63943.0 |
| 2010-05-18 | E6 | Futures | 1.46679 | 1.47246 | 1.43887 | 1.44407 | 550193.0 |
| 2010-05-18 | E7 | Futures | 1.4548 | 1.4604 | 1.4271 | 1.4322 | 9664.0 |
| 2010-05-18 | ED | Futures | 94.1765 | 94.2168 | 94.1434 | 94.1599 | 318071.0 |
| 2010-05-18 | ER | Futures | 97.326 | 97.35 | 97.291 | 97.34 | 157044.0 |
| 2010-05-18 | EW | Futures | 769.0 | 780.4 | 755.3 | 758.1 | 31622.0 |
| 2010-05-18 | FBTP | Futures | 64.68 | 65.01 | 64.66 | 64.78 | 2982.0 |
| 2010-05-18 | FCE | Futures | 2327.8 | 2375.2 | 2308.9 | 2360.9 | 92495.0 |
| 2010-05-18 | FDAX | Futures | 6651.3 | 6729.7 | 6630.7 | 6700.3 | 211786.0 |
| 2010-05-18 | FESX | Futures | 1607.5 | 1646.1 | 1595.3 | 1636.3 | 2040251.0 |
| 2010-05-18 | FEU3 | Futures | 97.904 | 97.904 | 97.899 | 97.899 | 27.0 |
| 2010-05-18 | FGBL | Futures | 98.65 | 99.74 | 98.53 | 99.0 | 1071747.0 |
| 2010-05-18 | FGBM | Futures | 104.08 | 104.68 | 104.02 | 104.27 | 466562.0 |
| 2010-05-18 | FGBS | Futures | 107.393 | 107.535 | 107.349 | 107.388 | 508802.0 |
| 2010-05-18 | FGBX | Futures | 95.27 | 97.16 | 94.92 | 95.77 | 4302.0 |
| 2010-05-18 | FTDX | Futures | 685.9 | 688.1 | 672.1 | 681.0 | 243.0 |
| 2010-05-18 | FTI | Futures | 260.34 | 261.99 | 255.42 | 260.14 | 26159.0 |
| 2010-05-18 | FTUK | Futures | 3581.2 | 3601.5 | 3508.8 | 3580.9 | 135260.0 |
| 2010-05-18 | G | Futures | 78.42 | 78.64 | 78.26 | 78.53 | 83429.0 |
| 2010-05-18 | GF | Futures | 283.939 | 285.96 | 283.497 | 284.381 | 2382.0 |
| 2010-05-18 | GSCI | Futures | 856.38 | 864.82 | 842.47 | 846.12 | 696.0 |
| 2010-05-18 | HE | Futures | 102.54 | 103.546 | 102.069 | 102.194 | 13817.0 |
| 2010-05-18 | HG | Futures | 4.0276 | 4.1675 | 3.9937 | 4.1159 | 38264.0 |
| 2010-05-18 | HO | Futures | 1.8093 | 1.8227 | 1.7666 | 1.7753 | 5975.0 |
| 2010-05-18 | J1 | Futures | 0.0135789 | 0.0136568 | 0.0135273 | 0.0136292 | 130724.0 |
| 2010-05-18 | J7 | Futures | 0.013494 | 0.013547 | 0.013422 | 0.01352 | 187.0 |
| 2010-05-18 | JB | Futures | 118.88 | 118.93 | 118.8 | 118.86 | 1805.0 |
| 2010-05-18 | KC | Futures | 337.79 | 342.36 | 337.66 | 340.83 | 9791.0 |
| 2010-05-18 | KE | Futures | 2130.25 | 2145.47 | 2117.21 | 2121.56 | 8326.0 |
| 2010-05-18 | KRW | Futures | 0.0008539 | 0.0008539 | 0.0008539 | 0.0008539 | 9.0 |
| 2010-05-18 | L | Futures | 97.819 | 97.848 | 97.819 | 97.838 | 46618.0 |
> showing 50 of 90 rows — these rows as CSV