PREVIEW / futures_daily / 2015-06-12
file: by_date/futures_daily/2015/2015-06-12.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 |
|---|---|---|---|---|---|---|---|
| 2015-06-12 | ES | Futures | 2217.53 | 2217.8 | 2197.82 | 2200.71 | 1134193.0 |
| 2015-06-12 | NQ | Futures | 5212.16 | 5214.49 | 5163.98 | 5172.11 | 153829.0 |
| 2015-06-12 | YM | Futures | 18456.6 | 18456.6 | 18250.2 | 18300.5 | 119066.0 |
| 2015-06-12 | CL | Futures | 101.76 | 101.89 | 100.38 | 100.76 | 246898.0 |
| 2015-06-12 | GC | Futures | 1542.1 | 1545.9 | 1535.3 | 1540.0 | 86352.0 |
| 2015-06-12 | ZN | Futures | 119.557597 | 119.915286 | 119.334041 | 119.52779 | 1308870.0 |
| 2015-06-12 | A6 | Futures | 0.76377 | 0.76456 | 0.75674 | 0.76258 | 68204.0 |
| 2015-06-12 | AD | Futures | 0.83017 | 0.8315 | 0.8268 | 0.82843 | 56299.0 |
| 2015-06-12 | ALI | Futures | 2349.28 | 2349.28 | 2349.28 | 2349.28 | 0.0 |
| 2015-06-12 | B | Futures | 61.62 | 61.74 | 60.7 | 60.81 | 225877.0 |
| 2015-06-12 | B6 | Futures | 1.6319 | 1.6407 | 1.6269 | 1.6359 | 112669.0 |
| 2015-06-12 | BZ | Futures | 61.66 | 61.85 | 60.82 | 60.94 | 17768.0 |
| 2015-06-12 | C | Futures | 2249.0 | 2280.0 | 2248.0 | 2272.0 | 3324.0 |
| 2015-06-12 | CC | Futures | 2280.0 | 2319.0 | 2274.0 | 2313.0 | 20500.0 |
| 2015-06-12 | CNH | Futures | 7.0192 | 7.0243 | 7.0192 | 7.0207 | 4.0 |
| 2015-06-12 | CSC | Futures | 4.675 | 4.678 | 4.635 | 4.635 | 19.0 |
| 2015-06-12 | CT | Futures | 80.48 | 81.81 | 80.02 | 80.71 | 19249.0 |
| 2015-06-12 | DC | Futures | 37.94 | 38.09 | 37.36 | 37.51 | 51.0 |
| 2015-06-12 | DX | Futures | 89.331 | 89.879 | 88.9 | 89.15 | 83203.0 |
| 2015-06-12 | E1 | Futures | 1.36326 | 1.37875 | 1.35665 | 1.37265 | 23682.0 |
| 2015-06-12 | E6 | Futures | 1.32222 | 1.32891 | 1.31165 | 1.32457 | 318836.0 |
| 2015-06-12 | E7 | Futures | 1.3147 | 1.3216 | 1.3045 | 1.3173 | 4946.0 |
| 2015-06-12 | EBM | Futures | 294.71 | 296.35 | 293.07 | 295.53 | 5571.0 |
| 2015-06-12 | ED | Futures | 95.5551 | 95.5647 | 95.5503 | 95.5551 | 211154.0 |
| 2015-06-12 | ER | Futures | 98.068 | 98.073 | 98.043 | 98.053 | 168597.0 |
| 2015-06-12 | EW | Futures | 1607.5 | 1608.4 | 1596.6 | 1599.9 | 30340.0 |
| 2015-06-12 | FBTP | Futures | 97.81 | 97.81 | 96.21 | 96.89 | 141282.0 |
| 2015-06-12 | FBTS | Futures | 99.634 | 99.634 | 99.261 | 99.456 | 43781.0 |
| 2015-06-12 | FCE | Futures | 4128.2 | 4133.7 | 4035.7 | 4077.0 | 2956.0 |
| 2015-06-12 | FDAX | Futures | 12548.6 | 12611.8 | 12277.3 | 12418.7 | 136414.0 |
| 2015-06-12 | FESX | Futures | 2622.8 | 2628.7 | 2559.2 | 2588.0 | 545662.0 |
| 2015-06-12 | FGBL | Futures | 134.64 | 134.99 | 133.77 | 134.76 | 780067.0 |
| 2015-06-12 | FGBM | Futures | 123.48 | 123.65 | 123.31 | 123.54 | 562876.0 |
| 2015-06-12 | FGBS | Futures | 111.098 | 111.133 | 111.088 | 111.113 | 298361.0 |
| 2015-06-12 | FGBX | Futures | 151.38 | 152.33 | 149.35 | 151.62 | 34807.0 |
| 2015-06-12 | FMWO | Futures | 5871.7 | 5884.1 | 5843.4 | 5868.0 | 379.0 |
| 2015-06-12 | FOAT | Futures | 123.22 | 123.31 | 122.25 | 122.9 | 109320.0 |
| 2015-06-12 | FTDX | Futures | 1580.2 | 1580.2 | 1551.4 | 1562.3 | 20.0 |
| 2015-06-12 | FTI | Futures | 422.1 | 422.1 | 413.58 | 416.9 | 875.0 |
| 2015-06-12 | FTUK | Futures | 5386.6 | 5389.8 | 5332.2 | 5356.4 | 50564.0 |
| 2015-06-12 | FVSA | Futures | 1758.74 | 1815.09 | 1714.47 | 1790.94 | 10912.0 |
| 2015-06-12 | FXXP | Futures | 300.0 | 301.4 | 297.0 | 298.4 | 26801.0 |
| 2015-06-12 | G | Futures | 101.39 | 101.92 | 101.01 | 101.82 | 188714.0 |
| 2015-06-12 | GF | Futures | 384.031 | 384.031 | 377.995 | 379.908 | 4621.0 |
| 2015-06-12 | GSCI | Futures | 734.99 | 735.82 | 729.24 | 729.32 | 977.0 |
| 2015-06-12 | HE | Futures | 86.065 | 86.065 | 84.76 | 84.896 | 15520.0 |
| 2015-06-12 | HG | Futures | 3.3544 | 3.3676 | 3.3375 | 3.3601 | 40112.0 |
| 2015-06-12 | HH | Futures | 34.033 | 34.203 | 33.34 | 33.413 | 1011.0 |
| 2015-06-12 | HO | Futures | 1.5565 | 1.5599 | 1.5342 | 1.5376 | 14525.0 |
| 2015-06-12 | HRC | Futures | 1693.2 | 1693.2 | 1693.2 | 1693.2 | 0.0 |
> showing 50 of 103 rows — these rows as CSV