PREVIEW / futures_daily / 2015-06-08
file: by_date/futures_daily/2015/2015-06-08.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2015-06-08 | ES | Futures | 2199.66 | 2200.97 | 2183.1 | 2185.2 | 1290922.0 |
| 2015-06-08 | NQ | Futures | 5200.84 | 5205.2 | 5134.09 | 5145.99 | 237404.0 |
| 2015-06-08 | YM | Futures | 18247.8 | 18268.3 | 18155.8 | 18174.2 | 149125.0 |
| 2015-06-08 | CL | Futures | 99.08 | 99.37 | 97.23 | 97.71 | 339845.0 |
| 2015-06-08 | GC | Futures | 1529.1 | 1537.3 | 1526.1 | 1532.7 | 107088.0 |
| 2015-06-08 | ZN | Futures | 119.28933 | 119.661923 | 119.214812 | 119.557597 | 891268.0 |
| 2015-06-08 | A6 | Futures | 0.75122 | 0.76049 | 0.74944 | 0.75871 | 89324.0 |
| 2015-06-08 | AD | Futures | 0.82047 | 0.82445 | 0.81863 | 0.82282 | 61492.0 |
| 2015-06-08 | ALI | Futures | 2305.46 | 2305.46 | 2305.46 | 2305.46 | 0.0 |
| 2015-06-08 | B | Futures | 59.8 | 60.25 | 59.31 | 59.49 | 208398.0 |
| 2015-06-08 | B6 | Futures | 1.6062 | 1.6172 | 1.602 | 1.6138 | 94136.0 |
| 2015-06-08 | BFX | Futures | 4400.9 | 4400.9 | 4381.0 | 4381.0 | 10.0 |
| 2015-06-08 | BR | Futures | 0.18647 | 0.18719 | 0.18575 | 0.18662 | 73.0 |
| 2015-06-08 | BZ | Futures | 59.9 | 60.34 | 59.44 | 59.61 | 13949.0 |
| 2015-06-08 | C | Futures | 2282.0 | 2289.0 | 2268.0 | 2280.0 | 4877.0 |
| 2015-06-08 | CB | Futures | 160.271 | 160.271 | 158.832 | 159.663 | 5.0 |
| 2015-06-08 | CC | Futures | 2269.0 | 2296.0 | 2269.0 | 2291.0 | 19503.0 |
| 2015-06-08 | CNH | Futures | 6.9811 | 6.9828 | 6.9777 | 6.9777 | 29.0 |
| 2015-06-08 | CSC | Futures | 4.586 | 4.647 | 4.586 | 4.622 | 22.0 |
| 2015-06-08 | CT | Futures | 81.14 | 81.94 | 80.84 | 81.63 | 16119.0 |
| 2015-06-08 | DC | Futures | 37.11 | 37.58 | 37.11 | 37.56 | 45.0 |
| 2015-06-08 | DX | Futures | 90.559 | 90.7 | 89.277 | 89.505 | 57543.0 |
| 2015-06-08 | E1 | Futures | 1.35521 | 1.37713 | 1.35189 | 1.37177 | 24163.0 |
| 2015-06-08 | E6 | Futures | 1.30552 | 1.32986 | 1.3034 | 1.32621 | 300374.0 |
| 2015-06-08 | E7 | Futures | 1.2981 | 1.322 | 1.2961 | 1.3185 | 6096.0 |
| 2015-06-08 | EBM | Futures | 302.09 | 305.78 | 300.04 | 305.37 | 6951.0 |
| 2015-06-08 | ED | Futures | 95.5621 | 95.5669 | 95.5597 | 95.5645 | 84816.0 |
| 2015-06-08 | ER | Futures | 98.077 | 98.082 | 98.073 | 98.082 | 23917.0 |
| 2015-06-08 | EW | Futures | 1600.3 | 1601.7 | 1588.4 | 1588.8 | 10827.0 |
| 2015-06-08 | FBTP | Futures | 97.03 | 97.4 | 96.67 | 97.02 | 72972.0 |
| 2015-06-08 | FBTS | Futures | 99.688 | 99.714 | 99.67 | 99.706 | 19987.0 |
| 2015-06-08 | FCE | Futures | 4088.8 | 4089.2 | 4004.5 | 4031.9 | 99556.0 |
| 2015-06-08 | FDAX | Futures | 12427.6 | 12452.6 | 12194.6 | 12299.5 | 112835.0 |
| 2015-06-08 | FESX | Futures | 2588.6 | 2590.1 | 2532.6 | 2557.6 | 1023365.0 |
| 2015-06-08 | FGBL | Futures | 134.56 | 134.93 | 134.04 | 134.21 | 549445.0 |
| 2015-06-08 | FGBM | Futures | 123.52 | 123.59 | 123.34 | 123.4 | 392640.0 |
| 2015-06-08 | FGBS | Futures | 111.108 | 111.113 | 111.073 | 111.083 | 190910.0 |
| 2015-06-08 | FGBX | Futures | 151.83 | 153.41 | 150.47 | 151.04 | 38069.0 |
| 2015-06-08 | FMWO | Futures | 5838.4 | 5838.4 | 5813.8 | 5813.8 | 840.0 |
| 2015-06-08 | FOAT | Futures | 123.31 | 123.5 | 122.79 | 122.91 | 87039.0 |
| 2015-06-08 | FTDX | Futures | 1568.7 | 1570.1 | 1551.4 | 1560.7 | 80.0 |
| 2015-06-08 | FTI | Futures | 418.29 | 418.9 | 411.41 | 414.09 | 33856.0 |
| 2015-06-08 | FTUK | Futures | 5358.1 | 5374.2 | 5324.2 | 5351.0 | 81632.0 |
| 2015-06-08 | FVSA | Futures | 1820.59 | 1886.3 | 1793.53 | 1863.11 | 19500.0 |
| 2015-06-08 | FXXP | Futures | 298.6 | 299.0 | 294.3 | 295.8 | 10434.0 |
| 2015-06-08 | G | Futures | 100.97 | 101.2 | 100.69 | 101.18 | 115801.0 |
| 2015-06-08 | GF | Futures | 377.655 | 379.313 | 375.998 | 378.888 | 2612.0 |
| 2015-06-08 | GSCI | Futures | 733.1 | 733.52 | 731.14 | 732.33 | 2424.0 |
| 2015-06-08 | HE | Futures | 88.404 | 88.676 | 87.751 | 88.078 | 16774.0 |
| 2015-06-08 | HG | Futures | 3.3908 | 3.3952 | 3.3657 | 3.3833 | 45201.0 |
> showing 50 of 106 rows — these rows as CSV