PREVIEW / futures_daily / 2013-10-09
file: by_date/futures_daily/2013/2013-10-09.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-09 | ES | Futures | 1692.87 | 1703.4 | 1684.65 | 1693.64 | 2485975.0 |
| 2013-10-09 | NQ | Futures | 3613.55 | 3633.94 | 3572.78 | 3597.76 | 441570.0 |
| 2013-10-09 | YM | Futures | 14612.5 | 14708.0 | 14574.7 | 14654.3 | 236854.0 |
| 2013-10-09 | CL | Futures | 183.22 | 183.68 | 179.13 | 179.89 | 283131.0 |
| 2013-10-09 | GC | Futures | 1745.2 | 1750.1 | 1712.2 | 1728.8 | 158401.0 |
| 2013-10-09 | ZN | Futures | 114.442032 | 114.65446 | 114.243766 | 114.442032 | 1015011.0 |
| 2013-10-09 | A6 | Futures | 0.88556 | 0.89 | 0.88509 | 0.8884 | 69611.0 |
| 2013-10-09 | AD | Futures | 0.97288 | 0.9743 | 0.96925 | 0.97056 | 56676.0 |
| 2013-10-09 | B | Futures | 108.99 | 109.11 | 107.04 | 107.92 | 209391.0 |
| 2013-10-09 | B6 | Futures | 1.6872 | 1.6915 | 1.6699 | 1.674 | 119438.0 |
| 2013-10-09 | BR | Futures | 0.22797 | 0.22835 | 0.22715 | 0.22794 | 23.0 |
| 2013-10-09 | BZ | Futures | 109.54 | 109.74 | 107.79 | 108.56 | 6081.0 |
| 2013-10-09 | C | Futures | 1882.0 | 1885.0 | 1867.0 | 1873.0 | 8308.0 |
| 2013-10-09 | CB | Futures | 70.738 | 70.738 | 70.45 | 70.498 | 11.0 |
| 2013-10-09 | CC | Futures | 2035.0 | 2037.0 | 2007.0 | 2014.0 | 8359.0 |
| 2013-10-09 | CSC | Futures | 3.29 | 3.306 | 3.284 | 3.298 | 17.0 |
| 2013-10-09 | CT | Futures | 98.13 | 98.42 | 97.49 | 97.6 | 14000.0 |
| 2013-10-09 | DC | Futures | 25.18 | 25.37 | 25.16 | 25.34 | 174.0 |
| 2013-10-09 | DX | Futures | 76.195 | 77.048 | 76.176 | 76.668 | 29224.0 |
| 2013-10-09 | E1 | Futures | 1.42259 | 1.42644 | 1.40884 | 1.41256 | 43094.0 |
| 2013-10-09 | E6 | Futures | 1.60224 | 1.60601 | 1.59174 | 1.5961 | 198604.0 |
| 2013-10-09 | E7 | Futures | 1.5914 | 1.5957 | 1.5816 | 1.5858 | 4071.0 |
| 2013-10-09 | ED | Futures | 95.2873 | 95.3016 | 95.273 | 95.2969 | 296021.0 |
| 2013-10-09 | ER | Futures | 97.813 | 97.832 | 97.808 | 97.813 | 102945.0 |
| 2013-10-09 | EW | Futures | 1246.7 | 1253.3 | 1236.9 | 1242.9 | 27930.0 |
| 2013-10-09 | FBTP | Futures | 79.36 | 79.49 | 79.24 | 79.33 | 31043.0 |
| 2013-10-09 | FBTS | Futures | 94.042 | 94.094 | 94.007 | 94.042 | 4599.0 |
| 2013-10-09 | FCE | Futures | 3191.1 | 3214.2 | 3175.3 | 3185.7 | 104218.0 |
| 2013-10-09 | FDAX | Futures | 9496.6 | 9536.5 | 9417.8 | 9440.6 | 97941.0 |
| 2013-10-09 | FDIV | Futures | 134.06 | 134.06 | 133.12 | 133.12 | 2.0 |
| 2013-10-09 | FESX | Futures | 2029.8 | 2043.9 | 2022.8 | 2027.7 | 938717.0 |
| 2013-10-09 | FEU3 | Futures | 98.453 | 98.453 | 98.438 | 98.438 | 1.0 |
| 2013-10-09 | FGBL | Futures | 119.43 | 119.76 | 119.31 | 119.42 | 649841.0 |
| 2013-10-09 | FGBM | Futures | 117.55 | 117.72 | 117.51 | 117.56 | 519159.0 |
| 2013-10-09 | FGBS | Futures | 110.433 | 110.458 | 110.413 | 110.418 | 306183.0 |
| 2013-10-09 | FGBX | Futures | 119.94 | 120.56 | 119.85 | 120.08 | 27926.0 |
| 2013-10-09 | FMWO | Futures | 4975.1 | 4975.1 | 4975.1 | 4975.1 | 0.0 |
| 2013-10-09 | FOAT | Futures | 106.87 | 107.08 | 106.74 | 106.8 | 34318.0 |
| 2013-10-09 | FTDX | Futures | 1013.9 | 1014.4 | 1001.2 | 1003.5 | 40.0 |
| 2013-10-09 | FTI | Futures | 320.67 | 320.67 | 316.86 | 317.9 | 34862.0 |
| 2013-10-09 | FTUK | Futures | 4735.2 | 4758.8 | 4716.0 | 4726.2 | 95887.0 |
| 2013-10-09 | FVSA | Futures | 2790.88 | 2940.86 | 2771.32 | 2934.34 | 8591.0 |
| 2013-10-09 | FXXP | Futures | 222.8 | 223.6 | 221.5 | 221.8 | 4386.0 |
| 2013-10-09 | G | Futures | 92.71 | 93.12 | 92.68 | 92.83 | 105277.0 |
| 2013-10-09 | GF | Futures | 268.742 | 268.824 | 267.071 | 268.253 | 1729.0 |
| 2013-10-09 | GSCI | Futures | 1070.34 | 1071.85 | 1058.37 | 1061.3 | 1735.0 |
| 2013-10-09 | HE | Futures | 111.636 | 111.984 | 109.326 | 109.516 | 28229.0 |
| 2013-10-09 | HG | Futures | 4.1652 | 4.1766 | 4.0772 | 4.0911 | 66898.0 |
| 2013-10-09 | HH | Futures | 39.445 | 39.584 | 39.221 | 39.274 | 3944.0 |
| 2013-10-09 | HO | Futures | 2.4294 | 2.4294 | 2.39 | 2.4129 | 27622.0 |
> showing 50 of 103 rows — these rows as CSV