PREVIEW / futures_daily / 2016-04-07
file: by_date/futures_daily/2016/2016-04-07.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2016-04-07 | ES | Futures | 2211.59 | 2214.01 | 2175.35 | 2185.02 | 2052195.0 |
| 2016-04-07 | NQ | Futures | 5326.89 | 5333.94 | 5229.66 | 5252.58 | 260817.0 |
| 2016-04-07 | YM | Futures | 18327.7 | 18346.4 | 18087.5 | 18152.0 | 169327.0 |
| 2016-04-07 | CL | Futures | 45.84 | 46.49 | 44.54 | 45.23 | 626749.0 |
| 2016-04-07 | GC | Futures | 1577.7 | 1604.7 | 1577.7 | 1595.1 | 189413.0 |
| 2016-04-07 | ZN | Futures | 126.173739 | 126.777225 | 126.083216 | 126.731963 | 1016410.0 |
| 2016-04-07 | A6 | Futures | 0.76686 | 0.77081 | 0.75604 | 0.75755 | 112975.0 |
| 2016-04-07 | AD | Futures | 0.78075 | 0.78535 | 0.77574 | 0.77738 | 62753.0 |
| 2016-04-07 | ALI | Futures | 2048.8 | 2048.8 | 2046.22 | 2046.22 | 5.0 |
| 2016-04-07 | B | Futures | 33.23 | 33.55 | 32.23 | 32.84 | 308721.0 |
| 2016-04-07 | B6 | Futures | 1.4873 | 1.491 | 1.4795 | 1.4808 | 86642.0 |
| 2016-04-07 | BFX | Futures | 3913.7 | 3913.7 | 3887.9 | 3887.9 | 3.0 |
| 2016-04-07 | BR | Futures | 0.17508 | 0.17508 | 0.17225 | 0.17326 | 43.0 |
| 2016-04-07 | BZ | Futures | 32.92 | 33.21 | 31.91 | 32.51 | 34351.0 |
| 2016-04-07 | C | Futures | 2272.0 | 2277.0 | 2236.0 | 2241.0 | 4236.0 |
| 2016-04-07 | CB | Futures | 260.994 | 262.792 | 260.353 | 262.152 | 32.0 |
| 2016-04-07 | CC | Futures | 2131.0 | 2134.0 | 2096.0 | 2101.0 | 28205.0 |
| 2016-04-07 | CNH | Futures | 7.072 | 7.075 | 7.0661 | 7.075 | 5.0 |
| 2016-04-07 | CSC | Futures | 3.615 | 3.635 | 3.603 | 3.62 | 56.0 |
| 2016-04-07 | CT | Futures | 67.51 | 68.19 | 67.26 | 67.8 | 22687.0 |
| 2016-04-07 | DC | Futures | 28.49 | 28.67 | 28.36 | 28.57 | 58.0 |
| 2016-04-07 | DX | Futures | 88.062 | 88.262 | 87.67 | 88.107 | 26254.0 |
| 2016-04-07 | E1 | Futures | 1.31804 | 1.32319 | 1.31489 | 1.31866 | 20425.0 |
| 2016-04-07 | E6 | Futures | 1.3315 | 1.33838 | 1.32462 | 1.32957 | 225764.0 |
| 2016-04-07 | E7 | Futures | 1.3246 | 1.3311 | 1.3175 | 1.3224 | 4576.0 |
| 2016-04-07 | EBM | Futures | 198.17 | 198.81 | 196.88 | 197.2 | 17514.0 |
| 2016-04-07 | ED | Futures | 95.7208 | 95.7352 | 95.716 | 95.7352 | 192717.0 |
| 2016-04-07 | ER | Futures | 98.264 | 98.264 | 98.259 | 98.259 | 29730.0 |
| 2016-04-07 | EW | Futures | 1513.7 | 1517.1 | 1486.6 | 1495.6 | 14611.0 |
| 2016-04-07 | FBON | Futures | 118.46 | 118.48 | 117.43 | 117.54 | 484.0 |
| 2016-04-07 | FBTP | Futures | 107.49 | 107.56 | 106.33 | 106.51 | 139309.0 |
| 2016-04-07 | FBTS | Futures | 101.015 | 101.015 | 100.863 | 100.881 | 37978.0 |
| 2016-04-07 | FCE | Futures | 3575.5 | 3595.9 | 3508.4 | 3536.3 | 86599.0 |
| 2016-04-07 | FDAX | Futures | 10397.2 | 10458.4 | 10175.4 | 10242.0 | 115424.0 |
| 2016-04-07 | FDXM | Futures | 10020.0 | 10071.7 | 9798.6 | 9861.7 | 24586.0 |
| 2016-04-07 | FESX | Futures | 2216.0 | 2226.1 | 2164.5 | 2179.3 | 1327221.0 |
| 2016-04-07 | FEU3 | Futures | 98.917 | 98.917 | 98.917 | 98.917 | 15.0 |
| 2016-04-07 | FGBL | Futures | 146.68 | 147.07 | 146.52 | 147.02 | 662487.0 |
| 2016-04-07 | FGBM | Futures | 127.6 | 127.79 | 127.57 | 127.76 | 463378.0 |
| 2016-04-07 | FGBS | Futures | 111.643 | 111.683 | 111.638 | 111.678 | 192508.0 |
| 2016-04-07 | FGBX | Futures | 176.4 | 177.47 | 175.89 | 177.04 | 30925.0 |
| 2016-04-07 | FMWO | Futures | 5545.7 | 5545.7 | 5494.7 | 5494.7 | 593.0 |
| 2016-04-07 | FOAT | Futures | 134.4 | 134.59 | 134.26 | 134.58 | 133885.0 |
| 2016-04-07 | FTDX | Futures | 1561.8 | 1573.3 | 1521.4 | 1539.5 | 178.0 |
| 2016-04-07 | FTI | Futures | 383.15 | 384.79 | 377.92 | 380.09 | 30461.0 |
| 2016-04-07 | FTUK | Futures | 5061.8 | 5078.7 | 4998.2 | 5015.1 | 117670.0 |
| 2016-04-07 | FVSA | Futures | 2727.56 | 2937.37 | 2683.39 | 2832.46 | 7979.0 |
| 2016-04-07 | FXXP | Futures | 261.7 | 262.3 | 257.0 | 258.4 | 22111.0 |
| 2016-04-07 | G | Futures | 108.94 | 109.48 | 108.87 | 109.39 | 187771.0 |
| 2016-04-07 | GF | Futures | 300.716 | 304.054 | 298.115 | 302.63 | 1646.0 |
> showing 50 of 110 rows — these rows as CSV