PREVIEW / futures_daily / 2014-12-02
file: by_date/futures_daily/2014/2014-12-02.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 |
|---|---|---|---|---|---|---|---|
| 2014-12-02 | ES | Futures | 2142.45 | 2160.2 | 2142.18 | 2158.11 | 1152160.0 |
| 2014-12-02 | NQ | Futures | 4968.53 | 5000.69 | 4966.21 | 4989.97 | 226496.0 |
| 2014-12-02 | YM | Futures | 18012.9 | 18145.8 | 18012.9 | 18121.4 | 112138.0 |
| 2014-12-02 | CL | Futures | 133.48 | 133.63 | 128.52 | 128.93 | 360300.0 |
| 2014-12-02 | GC | Futures | 1587.2 | 1587.2 | 1559.4 | 1569.9 | 169349.0 |
| 2014-12-02 | ZN | Futures | 119.38871 | 119.417997 | 118.920117 | 118.978691 | 116736.0 |
| 2014-12-02 | A6 | Futures | 0.82457 | 0.82953 | 0.81874 | 0.8201 | 97951.0 |
| 2014-12-02 | AD | Futures | 0.89691 | 0.89721 | 0.88898 | 0.8903 | 66994.0 |
| 2014-12-02 | ALI | Futures | 2968.86 | 2968.86 | 2968.86 | 2968.86 | 21.0 |
| 2014-12-02 | B | Futures | 75.44 | 75.84 | 73.14 | 73.29 | 115329.0 |
| 2014-12-02 | B6 | Futures | 1.6533 | 1.6547 | 1.6429 | 1.6436 | 76141.0 |
| 2014-12-02 | BFX | Futures | 3973.6 | 3981.7 | 3969.9 | 3970.6 | 41.0 |
| 2014-12-02 | BR | Futures | 0.20974 | 0.20974 | 0.20861 | 0.20905 | 60.0 |
| 2014-12-02 | BZ | Futures | 76.4 | 76.51 | 73.82 | 73.94 | 15389.0 |
| 2014-12-02 | C | Futures | 2087.0 | 2102.0 | 2074.0 | 2075.0 | 2439.0 |
| 2014-12-02 | CB | Futures | 137.192 | 137.849 | 137.192 | 137.849 | 15.0 |
| 2014-12-02 | CC | Futures | 2132.0 | 2146.0 | 2092.0 | 2110.0 | 13683.0 |
| 2014-12-02 | CNH | Futures | 7.0657 | 7.0657 | 7.0625 | 7.0625 | 1.0 |
| 2014-12-02 | CSC | Futures | 4.697 | 4.717 | 4.617 | 4.685 | 93.0 |
| 2014-12-02 | CT | Futures | 75.61 | 76.48 | 75.32 | 75.84 | 13284.0 |
| 2014-12-02 | DC | Futures | 37.33 | 37.54 | 36.7 | 37.35 | 168.0 |
| 2014-12-02 | DX | Futures | 83.56 | 84.229 | 83.531 | 84.203 | 36441.0 |
| 2014-12-02 | E1 | Futures | 1.32558 | 1.32622 | 1.3142 | 1.31471 | 36414.0 |
| 2014-12-02 | E6 | Futures | 1.46821 | 1.4688 | 1.45703 | 1.45738 | 191569.0 |
| 2014-12-02 | E7 | Futures | 1.4591 | 1.4594 | 1.4479 | 1.4482 | 2778.0 |
| 2014-12-02 | ED | Futures | 95.4398 | 95.4422 | 95.4374 | 95.4398 | 106990.0 |
| 2014-12-02 | ER | Futures | 97.999 | 98.009 | 97.999 | 98.009 | 34350.0 |
| 2014-12-02 | EW | Futures | 1483.3 | 1495.9 | 1482.2 | 1491.7 | 12484.0 |
| 2014-12-02 | FBTP | Futures | 98.0 | 98.08 | 97.76 | 97.95 | 168851.0 |
| 2014-12-02 | FBTS | Futures | 98.73 | 98.766 | 98.703 | 98.739 | 38634.0 |
| 2014-12-02 | FCE | Futures | 3556.0 | 3580.4 | 3538.2 | 3550.8 | 99612.0 |
| 2014-12-02 | FDAX | Futures | 10935.9 | 11001.6 | 10857.5 | 10890.4 | 120429.0 |
| 2014-12-02 | FDIV | Futures | 143.81 | 143.81 | 142.79 | 142.79 | 32.0 |
| 2014-12-02 | FESX | Futures | 2346.2 | 2362.2 | 2332.5 | 2344.1 | 994596.0 |
| 2014-12-02 | FGBL | Futures | 134.08 | 134.38 | 134.04 | 134.16 | 1000590.0 |
| 2014-12-02 | FGBM | Futures | 123.04 | 123.19 | 123.01 | 123.13 | 801493.0 |
| 2014-12-02 | FGBS | Futures | 110.813 | 110.853 | 110.808 | 110.848 | 477147.0 |
| 2014-12-02 | FGBX | Futures | 148.13 | 149.19 | 148.01 | 148.61 | 47880.0 |
| 2014-12-02 | FMWO | Futures | 5772.6 | 5777.7 | 5772.6 | 5777.7 | 2.0 |
| 2014-12-02 | FOAT | Futures | 124.2 | 124.42 | 124.09 | 124.14 | 105616.0 |
| 2014-12-02 | FTDX | Futures | 1269.3 | 1275.0 | 1263.6 | 1266.0 | 153.0 |
| 2014-12-02 | FTI | Futures | 369.07 | 373.68 | 368.85 | 372.59 | 37907.0 |
| 2014-12-02 | FTUK | Futures | 5173.4 | 5225.2 | 5169.6 | 5207.1 | 108003.0 |
| 2014-12-02 | FVSA | Futures | 1560.38 | 1591.15 | 1538.4 | 1551.59 | 4840.0 |
| 2014-12-02 | FXXP | Futures | 263.4 | 264.9 | 262.8 | 263.3 | 17864.0 |
| 2014-12-02 | G | Futures | 101.54 | 101.54 | 100.9 | 101.06 | 184477.0 |
| 2014-12-02 | GF | Futures | 376.292 | 380.183 | 375.209 | 377.937 | 6489.0 |
| 2014-12-02 | GSCI | Futures | 827.82 | 827.82 | 812.79 | 815.4 | 761.0 |
| 2014-12-02 | HE | Futures | 119.131 | 120.371 | 118.225 | 119.399 | 16631.0 |
| 2014-12-02 | HG | Futures | 3.6826 | 3.6826 | 3.6127 | 3.673 | 52831.0 |
> showing 50 of 106 rows — these rows as CSV