PREVIEW / futures_daily / 2016-02-04
file: by_date/futures_daily/2016/2016-02-04.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-02-04 | ES | Futures | 2037.74 | 2053.23 | 2019.04 | 2037.74 | 2255360.0 |
| 2016-02-04 | NQ | Futures | 4888.23 | 4931.31 | 4822.29 | 4871.82 | 383175.0 |
| 2016-02-04 | YM | Futures | 16823.8 | 16979.0 | 16688.2 | 16896.2 | 269221.0 |
| 2016-02-04 | CL | Futures | 47.12 | 48.4 | 45.42 | 45.69 | 696721.0 |
| 2016-02-04 | GC | Futures | 1468.0 | 1487.8 | 1464.4 | 1487.3 | 177206.0 |
| 2016-02-04 | ZN | Futures | 125.1459 | 125.582106 | 124.995484 | 125.401607 | 1708898.0 |
| 2016-02-04 | A6 | Futures | 0.71642 | 0.72454 | 0.71562 | 0.72053 | 92613.0 |
| 2016-02-04 | AD | Futures | 0.74169 | 0.74957 | 0.74098 | 0.74486 | 92251.0 |
| 2016-02-04 | ALI | Futures | 2129.53 | 2129.53 | 2129.53 | 2129.53 | 7.0 |
| 2016-02-04 | B | Futures | 29.68 | 30.12 | 28.7 | 28.96 | 323933.0 |
| 2016-02-04 | B6 | Futures | 1.5355 | 1.5439 | 1.5288 | 1.5361 | 123990.0 |
| 2016-02-04 | BFX | Futures | 4071.0 | 4090.2 | 4012.1 | 4027.1 | 22.0 |
| 2016-02-04 | BR | Futures | 0.16032 | 0.16211 | 0.15969 | 0.16054 | 1579.0 |
| 2016-02-04 | BZ | Futures | 29.4 | 29.88 | 28.49 | 28.74 | 37559.0 |
| 2016-02-04 | C | Futures | 2115.0 | 2148.0 | 2069.0 | 2072.0 | 7405.0 |
| 2016-02-04 | CB | Futures | 277.697 | 278.625 | 277.697 | 278.625 | 10.0 |
| 2016-02-04 | CC | Futures | 2110.0 | 2111.0 | 2024.0 | 2029.0 | 16105.0 |
| 2016-02-04 | CNH | Futures | 7.294 | 7.294 | 7.2424 | 7.2494 | 34.0 |
| 2016-02-04 | CSC | Futures | 3.77 | 3.797 | 3.765 | 3.78 | 107.0 |
| 2016-02-04 | CT | Futures | 72.5 | 72.5 | 70.27 | 70.55 | 31484.0 |
| 2016-02-04 | DC | Futures | 30.06 | 30.21 | 29.93 | 30.17 | 223.0 |
| 2016-02-04 | DX | Futures | 90.785 | 91.061 | 89.93 | 90.133 | 48431.0 |
| 2016-02-04 | E1 | Futures | 1.25907 | 1.27422 | 1.25503 | 1.27347 | 41793.0 |
| 2016-02-04 | E6 | Futures | 1.29747 | 1.31548 | 1.29554 | 1.3122 | 309206.0 |
| 2016-02-04 | E7 | Futures | 1.2902 | 1.308 | 1.2882 | 1.3048 | 7628.0 |
| 2016-02-04 | EBM | Futures | 224.59 | 225.3 | 223.18 | 224.24 | 19269.0 |
| 2016-02-04 | ED | Futures | 95.6506 | 95.6602 | 95.6458 | 95.6506 | 203174.0 |
| 2016-02-04 | ER | Futures | 98.288 | 98.293 | 98.278 | 98.288 | 55652.0 |
| 2016-02-04 | EW | Futures | 1367.2 | 1386.6 | 1355.8 | 1375.9 | 23531.0 |
| 2016-02-04 | FBON | Futures | 117.33 | 117.35 | 116.47 | 116.79 | 589.0 |
| 2016-02-04 | FBTP | Futures | 106.14 | 106.22 | 105.36 | 105.61 | 118569.0 |
| 2016-02-04 | FBTS | Futures | 101.006 | 101.006 | 100.962 | 100.989 | 22223.0 |
| 2016-02-04 | FCE | Futures | 3606.3 | 3609.7 | 3505.1 | 3550.4 | 124212.0 |
| 2016-02-04 | FDAX | Futures | 10412.1 | 10431.6 | 10041.8 | 10186.6 | 146370.0 |
| 2016-02-04 | FDIV | Futures | 123.54 | 123.54 | 123.31 | 123.31 | 1.0 |
| 2016-02-04 | FDXM | Futures | 9953.4 | 9971.1 | 9603.0 | 9738.8 | 30681.0 |
| 2016-02-04 | FESX | Futures | 2237.7 | 2241.5 | 2177.6 | 2211.1 | 1614065.0 |
| 2016-02-04 | FGBL | Futures | 144.31 | 144.43 | 143.89 | 144.13 | 817647.0 |
| 2016-02-04 | FGBM | Futures | 127.19 | 127.23 | 127.05 | 127.12 | 461965.0 |
| 2016-02-04 | FGBS | Futures | 111.748 | 111.758 | 111.718 | 111.723 | 194283.0 |
| 2016-02-04 | FGBX | Futures | 168.16 | 168.63 | 167.38 | 168.08 | 49089.0 |
| 2016-02-04 | FMWO | Futures | 5235.6 | 5250.5 | 5178.3 | 5216.9 | 982.0 |
| 2016-02-04 | FOAT | Futures | 131.35 | 131.49 | 131.09 | 131.27 | 196267.0 |
| 2016-02-04 | FTDX | Futures | 1602.4 | 1602.4 | 1549.1 | 1562.1 | 260.0 |
| 2016-02-04 | FTI | Futures | 372.03 | 374.73 | 366.9 | 368.85 | 42798.0 |
| 2016-02-04 | FTUK | Futures | 4771.2 | 4808.3 | 4713.3 | 4772.4 | 163903.0 |
| 2016-02-04 | FVSA | Futures | 2907.85 | 3002.62 | 2872.94 | 2937.78 | 7735.0 |
| 2016-02-04 | FXXP | Futures | 262.4 | 262.5 | 254.5 | 257.8 | 32602.0 |
| 2016-02-04 | G | Futures | 107.29 | 107.35 | 106.92 | 107.13 | 226386.0 |
| 2016-02-04 | GF | Futures | 310.532 | 312.348 | 305.329 | 307.341 | 4060.0 |
> showing 50 of 110 rows — these rows as CSV