PREVIEW / futures_daily / 2017-05-15
file: by_date/futures_daily/2017/2017-05-15.parquet size: 9 KB rows: 109
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 |
|---|---|---|---|---|---|---|---|
| 2017-05-15 | ES | Futures | 2594.29 | 2608.95 | 2593.47 | 2604.87 | 1041264.0 |
| 2017-05-15 | NQ | Futures | 6701.03 | 6721.06 | 6692.79 | 6714.87 | 180918.0 |
| 2017-05-15 | YM | Futures | 22006.6 | 22118.4 | 21996.0 | 22084.7 | 90412.0 |
| 2017-05-15 | CL | Futures | 49.92 | 51.76 | 49.8 | 50.92 | 295658.0 |
| 2017-05-15 | GC | Futures | 1570.8 | 1582.4 | 1568.8 | 1572.9 | 189226.0 |
| 2017-05-15 | ZN | Futures | 123.428829 | 123.536373 | 123.24447 | 123.352013 | 928493.0 |
| 2017-05-15 | A6 | Futures | 0.75833 | 0.76387 | 0.75761 | 0.76059 | 81193.0 |
| 2017-05-15 | AD | Futures | 0.74432 | 0.75014 | 0.74351 | 0.74774 | 70929.0 |
| 2017-05-15 | ALI | Futures | 2536.02 | 2536.02 | 2536.02 | 2536.02 | 0.0 |
| 2017-05-15 | B | Futures | 36.5 | 37.74 | 36.39 | 37.16 | 331418.0 |
| 2017-05-15 | B6 | Futures | 1.3531 | 1.3579 | 1.3517 | 1.3531 | 72253.0 |
| 2017-05-15 | BR | Futures | 0.23086 | 0.23339 | 0.23086 | 0.23245 | 3654.0 |
| 2017-05-15 | BZ | Futures | 36.2 | 37.47 | 36.06 | 36.9 | 31972.0 |
| 2017-05-15 | C | Futures | 1596.0 | 1657.0 | 1596.0 | 1609.0 | 15193.0 |
| 2017-05-15 | CB | Futures | 278.627 | 285.34 | 278.627 | 285.34 | 48.0 |
| 2017-05-15 | CC | Futures | 1563.0 | 1580.0 | 1553.0 | 1560.0 | 26519.0 |
| 2017-05-15 | CNH | Futures | 7.205 | 7.205 | 7.1914 | 7.1952 | 24.0 |
| 2017-05-15 | CSC | Futures | 3.607 | 3.656 | 3.603 | 3.656 | 66.0 |
| 2017-05-15 | CT | Futures | 91.95 | 96.55 | 91.39 | 94.49 | 67921.0 |
| 2017-05-15 | DC | Futures | 30.31 | 30.78 | 30.15 | 30.76 | 418.0 |
| 2017-05-15 | DX | Futures | 92.291 | 92.365 | 91.927 | 92.049 | 18479.0 |
| 2017-05-15 | E1 | Futures | 1.23749 | 1.24329 | 1.23563 | 1.24268 | 23437.0 |
| 2017-05-15 | E6 | Futures | 1.26129 | 1.26797 | 1.2602 | 1.26653 | 133125.0 |
| 2017-05-15 | E7 | Futures | 1.2549 | 1.2614 | 1.2538 | 1.2601 | 3073.0 |
| 2017-05-15 | EBM | Futures | 187.9 | 188.17 | 186.5 | 186.5 | 11306.0 |
| 2017-05-15 | ED | Futures | 95.6123 | 95.6147 | 95.5954 | 95.6026 | 479427.0 |
| 2017-05-15 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.337 | 25030.0 |
| 2017-05-15 | EW | Futures | 1826.8 | 1845.8 | 1826.3 | 1838.3 | 13130.0 |
| 2017-05-15 | FBON | Futures | 122.35 | 122.65 | 122.24 | 122.5 | 410.0 |
| 2017-05-15 | FBTP | Futures | 106.05 | 106.14 | 105.81 | 105.9 | 58779.0 |
| 2017-05-15 | FBTS | Futures | 102.299 | 102.308 | 102.272 | 102.299 | 13826.0 |
| 2017-05-15 | FCE | Futures | 4809.0 | 4816.2 | 4778.4 | 4807.2 | 84887.0 |
| 2017-05-15 | FDAX | Futures | 13529.4 | 13559.0 | 13434.9 | 13505.1 | 68532.0 |
| 2017-05-15 | FDXM | Futures | 13409.0 | 13440.4 | 13315.9 | 13386.5 | 18151.0 |
| 2017-05-15 | FESX | Futures | 2951.6 | 2956.5 | 2932.8 | 2947.5 | 680799.0 |
| 2017-05-15 | FGBL | Futures | 147.82 | 147.87 | 147.47 | 147.52 | 553378.0 |
| 2017-05-15 | FGBM | Futures | 129.03 | 129.11 | 128.97 | 129.0 | 345241.0 |
| 2017-05-15 | FGBS | Futures | 112.192 | 112.237 | 112.192 | 112.207 | 187672.0 |
| 2017-05-15 | FGBX | Futures | 166.17 | 166.27 | 164.57 | 164.73 | 38760.0 |
| 2017-05-15 | FMWO | Futures | 6384.4 | 6401.3 | 6377.2 | 6397.6 | 3950.0 |
| 2017-05-15 | FOAT | Futures | 134.1 | 134.19 | 133.72 | 133.76 | 105673.0 |
| 2017-05-15 | FTDX | Futures | 2176.4 | 2199.4 | 2167.1 | 2179.8 | 167.0 |
| 2017-05-15 | FTI | Futures | 489.42 | 489.69 | 487.68 | 489.05 | 8629.0 |
| 2017-05-15 | FTUK | Futures | 6338.2 | 6357.5 | 6329.3 | 6346.8 | 75507.0 |
| 2017-05-15 | FVSA | Futures | 531.6 | 545.14 | 526.52 | 529.91 | 23466.0 |
| 2017-05-15 | FXXP | Futures | 332.9 | 333.2 | 331.2 | 332.1 | 22218.0 |
| 2017-05-15 | G | Futures | 115.54 | 115.61 | 115.11 | 115.32 | 126368.0 |
| 2017-05-15 | GF | Futures | 335.918 | 338.607 | 325.107 | 327.686 | 6255.0 |
| 2017-05-15 | GSCI | Futures | 476.18 | 476.18 | 471.01 | 471.01 | 144.0 |
| 2017-05-15 | HE | Futures | 84.445 | 84.662 | 83.363 | 83.58 | 14802.0 |
> showing 50 of 109 rows — these rows as CSV