PREVIEW / futures_daily / 2015-10-26
file: by_date/futures_daily/2015/2015-10-26.parquet size: 9 KB rows: 108
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-10-26 | ES | Futures | 2197.71 | 2199.84 | 2188.67 | 2193.72 | 1184323.0 |
| 2015-10-26 | NQ | Futures | 5394.73 | 5413.44 | 5369.88 | 5397.36 | 184127.0 |
| 2015-10-26 | YM | Futures | 18103.6 | 18137.6 | 18040.6 | 18088.1 | 95416.0 |
| 2015-10-26 | CL | Futures | 71.04 | 71.36 | 69.29 | 69.83 | 302084.0 |
| 2015-10-26 | GC | Futures | 1502.3 | 1509.8 | 1500.0 | 1505.4 | 84868.0 |
| 2015-10-26 | ZN | Futures | 123.003035 | 123.257483 | 122.928197 | 123.182645 | 743734.0 |
| 2015-10-26 | A6 | Futures | 0.71943 | 0.72533 | 0.71913 | 0.72343 | 46291.0 |
| 2015-10-26 | AD | Futures | 0.77742 | 0.78039 | 0.7766 | 0.77803 | 36884.0 |
| 2015-10-26 | ALI | Futures | 2034.18 | 2034.18 | 2034.18 | 2034.18 | 8.0 |
| 2015-10-26 | B | Futures | 42.96 | 43.22 | 42.35 | 42.56 | 88809.0 |
| 2015-10-26 | B6 | Futures | 1.6117 | 1.6195 | 1.6114 | 1.6162 | 51635.0 |
| 2015-10-26 | BFX | Futures | 4277.6 | 4280.6 | 4275.8 | 4280.1 | 14.0 |
| 2015-10-26 | BR | Futures | 0.15641 | 0.15884 | 0.15512 | 0.15583 | 1563.0 |
| 2015-10-26 | BZ | Futures | 42.72 | 42.94 | 42.13 | 42.29 | 10658.0 |
| 2015-10-26 | C | Futures | 2290.0 | 2325.0 | 2288.0 | 2318.0 | 5645.0 |
| 2015-10-26 | CB | Futures | 197.315 | 198.791 | 196.847 | 198.791 | 9.0 |
| 2015-10-26 | CC | Futures | 2306.0 | 2333.0 | 2289.0 | 2327.0 | 13583.0 |
| 2015-10-26 | CNH | Futures | 7.1186 | 7.1237 | 7.1154 | 7.1154 | 163.0 |
| 2015-10-26 | CSC | Futures | 4.276 | 4.314 | 4.273 | 4.294 | 25.0 |
| 2015-10-26 | CT | Futures | 75.19 | 75.28 | 74.27 | 74.53 | 13677.0 |
| 2015-10-26 | DC | Futures | 34.34 | 34.61 | 34.08 | 34.59 | 78.0 |
| 2015-10-26 | DX | Futures | 90.94 | 90.954 | 90.519 | 90.678 | 24106.0 |
| 2015-10-26 | E1 | Futures | 1.29685 | 1.30205 | 1.29102 | 1.2914 | 21948.0 |
| 2015-10-26 | E6 | Futures | 1.2901 | 1.29748 | 1.28987 | 1.29479 | 176358.0 |
| 2015-10-26 | E7 | Futures | 1.2826 | 1.2903 | 1.2826 | 1.2876 | 2973.0 |
| 2015-10-26 | EBM | Futures | 263.8 | 264.9 | 262.34 | 264.53 | 22536.0 |
| 2015-10-26 | ED | Futures | 95.74 | 95.7448 | 95.7352 | 95.74 | 87449.0 |
| 2015-10-26 | ER | Futures | 98.2 | 98.205 | 98.195 | 98.195 | 83345.0 |
| 2015-10-26 | EW | Futures | 1512.3 | 1515.2 | 1505.2 | 1511.3 | 17107.0 |
| 2015-10-26 | FBON | Futures | 115.66 | 116.12 | 115.66 | 116.03 | 172.0 |
| 2015-10-26 | FBTP | Futures | 104.49 | 104.86 | 104.47 | 104.56 | 62514.0 |
| 2015-10-26 | FBTS | Futures | 100.57 | 100.606 | 100.525 | 100.543 | 15894.0 |
| 2015-10-26 | FCE | Futures | 4115.0 | 4115.0 | 4069.2 | 4083.3 | 69903.0 |
| 2015-10-26 | FDAX | Futures | 11905.8 | 11969.1 | 11848.0 | 11904.1 | 89205.0 |
| 2015-10-26 | FESX | Futures | 2567.7 | 2570.7 | 2545.2 | 2557.9 | 945131.0 |
| 2015-10-26 | FEU3 | Futures | 98.848 | 98.848 | 98.843 | 98.843 | 50.0 |
| 2015-10-26 | FGBL | Futures | 140.09 | 140.35 | 140.06 | 140.23 | 344427.0 |
| 2015-10-26 | FGBM | Futures | 125.73 | 125.81 | 125.71 | 125.76 | 275648.0 |
| 2015-10-26 | FGBS | Futures | 111.438 | 111.463 | 111.433 | 111.443 | 174869.0 |
| 2015-10-26 | FGBX | Futures | 160.16 | 161.14 | 160.0 | 160.83 | 21080.0 |
| 2015-10-26 | FMWO | Futures | 5692.9 | 5699.1 | 5685.5 | 5696.6 | 257.0 |
| 2015-10-26 | FOAT | Futures | 128.62 | 128.79 | 128.54 | 128.68 | 52721.0 |
| 2015-10-26 | FTDX | Futures | 1716.9 | 1729.7 | 1707.4 | 1707.9 | 283.0 |
| 2015-10-26 | FTI | Futures | 403.98 | 404.98 | 400.93 | 402.11 | 29104.0 |
| 2015-10-26 | FTUK | Futures | 5163.5 | 5172.3 | 5131.7 | 5145.8 | 62763.0 |
| 2015-10-26 | FVSA | Futures | 2063.21 | 2077.0 | 2012.67 | 2054.02 | 5376.0 |
| 2015-10-26 | FXXP | Futures | 293.4 | 294.2 | 291.8 | 292.8 | 13651.0 |
| 2015-10-26 | G | Futures | 104.79 | 105.03 | 104.56 | 104.96 | 109516.0 |
| 2015-10-26 | GF | Futures | 346.374 | 347.684 | 343.709 | 345.516 | 2970.0 |
| 2015-10-26 | GSCI | Futures | 575.64 | 575.64 | 571.28 | 572.25 | 57.0 |
> showing 50 of 108 rows — these rows as CSV