PREVIEW / futures_daily / 2015-02-19
file: by_date/futures_daily/2015/2015-02-19.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-02-19 | ES | Futures | 2196.09 | 2200.55 | 2187.71 | 2196.09 | 1143901.0 |
| 2015-02-19 | NQ | Futures | 5093.97 | 5125.3 | 5077.44 | 5120.66 | 168236.0 |
| 2015-02-19 | YM | Futures | 18318.3 | 18371.3 | 18226.7 | 18290.8 | 104132.0 |
| 2015-02-19 | CL | Futures | 94.83 | 97.55 | 92.18 | 95.9 | 554332.0 |
| 2015-02-19 | GC | Futures | 1585.3 | 1598.9 | 1575.8 | 1578.9 | 115723.0 |
| 2015-02-19 | ZN | Futures | 120.570825 | 120.835816 | 120.129174 | 120.217504 | 1230599.0 |
| 2015-02-19 | A6 | Futures | 0.76408 | 0.76731 | 0.75879 | 0.76192 | 66349.0 |
| 2015-02-19 | AD | Futures | 0.81759 | 0.81871 | 0.81086 | 0.81494 | 60834.0 |
| 2015-02-19 | ALI | Futures | 2671.33 | 2671.33 | 2671.33 | 2671.33 | 0.0 |
| 2015-02-19 | B | Futures | 58.94 | 60.38 | 57.22 | 59.61 | 303861.0 |
| 2015-02-19 | B6 | Futures | 1.6231 | 1.6259 | 1.6195 | 1.6203 | 66834.0 |
| 2015-02-19 | BFX | Futures | 4332.9 | 4378.8 | 4324.5 | 4375.2 | 267.0 |
| 2015-02-19 | BR | Futures | 0.1934 | 0.19379 | 0.19152 | 0.19186 | 2450.0 |
| 2015-02-19 | BZ | Futures | 58.52 | 60.21 | 57.08 | 59.46 | 39699.0 |
| 2015-02-19 | C | Futures | 2213.0 | 2219.0 | 2193.0 | 2210.0 | 6046.0 |
| 2015-02-19 | CB | Futures | 147.871 | 147.871 | 146.86 | 146.88 | 4.0 |
| 2015-02-19 | CC | Futures | 2187.0 | 2204.0 | 2170.0 | 2196.0 | 15860.0 |
| 2015-02-19 | CNH | Futures | 7.1446 | 7.1464 | 7.1445 | 7.1446 | 14.0 |
| 2015-02-19 | CSC | Futures | 4.566 | 4.634 | 4.492 | 4.509 | 62.0 |
| 2015-02-19 | CT | Futures | 82.54 | 83.44 | 82.0 | 82.3 | 6925.0 |
| 2015-02-19 | DC | Futures | 37.66 | 37.82 | 36.7 | 36.96 | 384.0 |
| 2015-02-19 | DX | Futures | 89.134 | 89.484 | 88.883 | 89.443 | 31840.0 |
| 2015-02-19 | E1 | Futures | 1.35647 | 1.36196 | 1.34511 | 1.34562 | 11810.0 |
| 2015-02-19 | E6 | Futures | 1.34128 | 1.34728 | 1.33599 | 1.33716 | 161069.0 |
| 2015-02-19 | E7 | Futures | 1.3334 | 1.3392 | 1.328 | 1.3292 | 2579.0 |
| 2015-02-19 | EBM | Futures | 300.49 | 306.16 | 300.08 | 303.73 | 15030.0 |
| 2015-02-19 | ED | Futures | 95.4474 | 95.4498 | 95.4426 | 95.4474 | 187221.0 |
| 2015-02-19 | ER | Futures | 98.043 | 98.048 | 98.033 | 98.038 | 54881.0 |
| 2015-02-19 | EW | Futures | 1574.6 | 1577.5 | 1567.4 | 1574.0 | 9467.0 |
| 2015-02-19 | FBTP | Futures | 100.95 | 101.49 | 100.66 | 100.98 | 107195.0 |
| 2015-02-19 | FBTS | Futures | 99.289 | 99.351 | 99.244 | 99.289 | 19925.0 |
| 2015-02-19 | FCE | Futures | 3902.5 | 3938.3 | 3880.1 | 3931.3 | 61156.0 |
| 2015-02-19 | FDAX | Futures | 12159.4 | 12239.8 | 12070.5 | 12211.0 | 116618.0 |
| 2015-02-19 | FESX | Futures | 2498.1 | 2519.7 | 2478.6 | 2513.2 | 1212742.0 |
| 2015-02-19 | FGBL | Futures | 138.95 | 139.11 | 138.63 | 138.89 | 690558.0 |
| 2015-02-19 | FGBM | Futures | 124.59 | 124.66 | 124.53 | 124.62 | 382433.0 |
| 2015-02-19 | FGBS | Futures | 111.213 | 111.218 | 111.193 | 111.208 | 169678.0 |
| 2015-02-19 | FGBX | Futures | 166.38 | 166.72 | 165.04 | 165.64 | 28942.0 |
| 2015-02-19 | FMWO | Futures | 5793.0 | 5812.8 | 5788.1 | 5810.4 | 677.0 |
| 2015-02-19 | FOAT | Futures | 127.45 | 127.56 | 127.09 | 127.3 | 83241.0 |
| 2015-02-19 | FTDX | Futures | 1444.8 | 1448.1 | 1434.0 | 1447.7 | 492.0 |
| 2015-02-19 | FTI | Futures | 403.67 | 406.31 | 401.95 | 405.79 | 23887.0 |
| 2015-02-19 | FTUK | Futures | 5344.7 | 5358.8 | 5319.8 | 5347.8 | 83001.0 |
| 2015-02-19 | FVSA | Futures | 2054.54 | 2166.45 | 2036.64 | 2059.02 | 8616.0 |
| 2015-02-19 | FXXP | Futures | 286.1 | 288.3 | 284.9 | 288.0 | 15117.0 |
| 2015-02-19 | G | Futures | 102.7 | 102.93 | 102.49 | 102.67 | 154107.0 |
| 2015-02-19 | GF | Futures | 344.184 | 344.985 | 340.472 | 341.695 | 2530.0 |
| 2015-02-19 | GSCI | Futures | 710.21 | 724.39 | 704.89 | 717.0 | 115.0 |
| 2015-02-19 | HE | Futures | 87.47 | 90.186 | 87.47 | 89.952 | 19126.0 |
| 2015-02-19 | HG | Futures | 3.3167 | 3.3282 | 3.2748 | 3.3231 | 21250.0 |
> showing 50 of 106 rows — these rows as CSV