PREVIEW / futures_daily / 2015-02-20
file: by_date/futures_daily/2015/2015-02-20.parquet size: 9 KB rows: 105
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-20 | ES | Futures | 2196.88 | 2210.24 | 2182.46 | 2208.41 | 1645222.0 |
| 2015-02-20 | NQ | Futures | 5124.14 | 5157.5 | 5100.64 | 5149.37 | 235154.0 |
| 2015-02-20 | YM | Futures | 18299.0 | 18455.8 | 18182.9 | 18438.5 | 159649.0 |
| 2015-02-20 | CL | Futures | 96.48 | 97.12 | 93.83 | 94.01 | 366125.0 |
| 2015-02-20 | GC | Futures | 1579.5 | 1589.0 | 1566.0 | 1575.4 | 109248.0 |
| 2015-02-20 | ZN | Futures | 120.173339 | 120.821094 | 119.952513 | 120.040844 | 1547608.0 |
| 2015-02-20 | A6 | Futures | 0.76202 | 0.768 | 0.76202 | 0.76731 | 76471.0 |
| 2015-02-20 | AD | Futures | 0.81473 | 0.81962 | 0.81036 | 0.81239 | 69729.0 |
| 2015-02-20 | ALI | Futures | 2726.18 | 2726.18 | 2726.18 | 2726.18 | 0.0 |
| 2015-02-20 | B | Futures | 59.6 | 60.54 | 59.22 | 59.62 | 221755.0 |
| 2015-02-20 | B6 | Futures | 1.6204 | 1.6226 | 1.6131 | 1.6186 | 105831.0 |
| 2015-02-20 | BFX | Futures | 4353.4 | 4375.2 | 4352.2 | 4375.2 | 51.0 |
| 2015-02-20 | BR | Futures | 0.19158 | 0.19279 | 0.19045 | 0.19139 | 1497.0 |
| 2015-02-20 | BZ | Futures | 59.35 | 60.37 | 59.1 | 59.47 | 33712.0 |
| 2015-02-20 | C | Futures | 2205.0 | 2227.0 | 2202.0 | 2225.0 | 7718.0 |
| 2015-02-20 | CB | Futures | 146.455 | 146.455 | 146.455 | 146.455 | 3.0 |
| 2015-02-20 | CC | Futures | 2185.0 | 2203.0 | 2176.0 | 2199.0 | 13259.0 |
| 2015-02-20 | CSC | Futures | 4.492 | 4.503 | 4.438 | 4.452 | 91.0 |
| 2015-02-20 | CT | Futures | 82.25 | 82.69 | 81.7 | 82.6 | 5975.0 |
| 2015-02-20 | DC | Futures | 36.77 | 36.84 | 36.23 | 36.3 | 319.0 |
| 2015-02-20 | DX | Futures | 89.427 | 89.82 | 89.082 | 89.3 | 48776.0 |
| 2015-02-20 | E1 | Futures | 1.34523 | 1.36362 | 1.34038 | 1.35609 | 21105.0 |
| 2015-02-20 | E6 | Futures | 1.33716 | 1.34493 | 1.32693 | 1.34081 | 149963.0 |
| 2015-02-20 | E7 | Futures | 1.329 | 1.3368 | 1.3191 | 1.3328 | 6111.0 |
| 2015-02-20 | EBM | Futures | 302.92 | 303.73 | 300.89 | 301.3 | 11395.0 |
| 2015-02-20 | ED | Futures | 95.4474 | 95.4474 | 95.4402 | 95.445 | 148876.0 |
| 2015-02-20 | ER | Futures | 98.043 | 98.048 | 98.028 | 98.033 | 103628.0 |
| 2015-02-20 | EW | Futures | 1573.7 | 1585.0 | 1562.2 | 1582.7 | 22263.0 |
| 2015-02-20 | FBTP | Futures | 100.84 | 101.38 | 100.73 | 101.23 | 96936.0 |
| 2015-02-20 | FBTS | Futures | 99.289 | 99.36 | 99.271 | 99.342 | 17350.0 |
| 2015-02-20 | FCE | Futures | 3922.4 | 3975.7 | 3888.7 | 3929.7 | 125066.0 |
| 2015-02-20 | FDAX | Futures | 12185.4 | 12394.7 | 12154.4 | 12266.5 | 133520.0 |
| 2015-02-20 | FESX | Futures | 2505.3 | 2550.7 | 2489.4 | 2516.1 | 1351551.0 |
| 2015-02-20 | FGBL | Futures | 138.76 | 139.39 | 138.51 | 139.06 | 758727.0 |
| 2015-02-20 | FGBM | Futures | 124.59 | 124.73 | 124.54 | 124.66 | 442176.0 |
| 2015-02-20 | FGBS | Futures | 111.198 | 111.228 | 111.193 | 111.213 | 181364.0 |
| 2015-02-20 | FGBX | Futures | 165.18 | 166.8 | 163.59 | 165.5 | 29859.0 |
| 2015-02-20 | FMWO | Futures | 5805.4 | 5806.6 | 5779.4 | 5802.9 | 939.0 |
| 2015-02-20 | FOAT | Futures | 127.18 | 127.69 | 127.18 | 127.53 | 60755.0 |
| 2015-02-20 | FTDX | Futures | 1443.4 | 1473.5 | 1443.4 | 1456.6 | 226.0 |
| 2015-02-20 | FTI | Futures | 405.36 | 410.5 | 402.59 | 405.79 | 37050.0 |
| 2015-02-20 | FTUK | Futures | 5341.6 | 5400.1 | 5336.5 | 5361.1 | 97077.0 |
| 2015-02-20 | FVSA | Futures | 2081.4 | 2170.92 | 2054.54 | 2090.35 | 15241.0 |
| 2015-02-20 | FXXP | Futures | 287.6 | 289.5 | 287.4 | 288.9 | 7136.0 |
| 2015-02-20 | G | Futures | 102.66 | 103.32 | 102.53 | 103.11 | 183668.0 |
| 2015-02-20 | GF | Futures | 341.695 | 342.75 | 335.707 | 336.002 | 3371.0 |
| 2015-02-20 | GSCI | Futures | 726.54 | 726.54 | 714.77 | 715.11 | 58.0 |
| 2015-02-20 | HE | Futures | 90.555 | 92.366 | 88.945 | 90.421 | 22975.0 |
| 2015-02-20 | HG | Futures | 3.3205 | 3.3256 | 3.2716 | 3.2919 | 32081.0 |
| 2015-02-20 | HH | Futures | 35.203 | 37.267 | 35.203 | 36.93 | 7312.0 |
> showing 50 of 105 rows — these rows as CSV