PREVIEW / futures_daily / 2014-11-12
file: by_date/futures_daily/2014/2014-11-12.parquet size: 9 KB rows: 104
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-11-12 | ES | Futures | 2127.3 | 2128.08 | 2117.11 | 2126.78 | 1082280.0 |
| 2014-11-12 | NQ | Futures | 4848.29 | 4866.25 | 4828.87 | 4863.06 | 202720.0 |
| 2014-11-12 | YM | Futures | 17815.0 | 17839.4 | 17736.9 | 17832.3 | 103752.0 |
| 2014-11-12 | CL | Futures | 148.8 | 149.91 | 147.13 | 148.18 | 359951.0 |
| 2014-11-12 | GC | Futures | 1525.5 | 1533.8 | 1516.9 | 1520.3 | 183582.0 |
| 2014-11-12 | ZN | Futures | 118.261158 | 118.671177 | 118.187941 | 118.39295 | 1011849.0 |
| 2014-11-12 | A6 | Futures | 0.84255 | 0.84789 | 0.84002 | 0.84498 | 92829.0 |
| 2014-11-12 | AD | Futures | 0.89518 | 0.90006 | 0.89366 | 0.89782 | 62684.0 |
| 2014-11-12 | ALI | Futures | 3121.13 | 3121.13 | 3121.13 | 3121.13 | 8.0 |
| 2014-11-12 | B | Futures | 84.78 | 85.19 | 83.23 | 83.87 | 269319.0 |
| 2014-11-12 | B6 | Futures | 1.6725 | 1.6752 | 1.6578 | 1.6584 | 141612.0 |
| 2014-11-12 | BR | Futures | 0.2101 | 0.21183 | 0.20789 | 0.20991 | 1171.0 |
| 2014-11-12 | BZ | Futures | 85.51 | 86.06 | 84.1 | 84.72 | 16491.0 |
| 2014-11-12 | C | Futures | 2057.0 | 2067.0 | 2020.0 | 2025.0 | 5144.0 |
| 2014-11-12 | CB | Futures | 131.802 | 131.802 | 130.492 | 130.492 | 12.0 |
| 2014-11-12 | CC | Futures | 2151.0 | 2152.0 | 2107.0 | 2116.0 | 25371.0 |
| 2014-11-12 | CNH | Futures | 7.0428 | 7.0431 | 7.0419 | 7.0431 | 1.0 |
| 2014-11-12 | CSC | Futures | 4.872 | 4.912 | 4.828 | 4.912 | 61.0 |
| 2014-11-12 | CT | Futures | 80.07 | 80.65 | 78.44 | 78.49 | 21046.0 |
| 2014-11-12 | DC | Futures | 38.89 | 39.45 | 38.41 | 39.3 | 573.0 |
| 2014-11-12 | DX | Futures | 83.313 | 83.517 | 83.033 | 83.447 | 32512.0 |
| 2014-11-12 | E1 | Futures | 1.32558 | 1.32929 | 1.32123 | 1.32264 | 42419.0 |
| 2014-11-12 | E6 | Futures | 1.46868 | 1.4715 | 1.4622 | 1.46373 | 234136.0 |
| 2014-11-12 | E7 | Futures | 1.4593 | 1.4623 | 1.453 | 1.4545 | 3752.0 |
| 2014-11-12 | ED | Futures | 95.4374 | 95.4422 | 95.4374 | 95.4374 | 63870.0 |
| 2014-11-12 | ER | Futures | 97.999 | 98.004 | 97.994 | 97.999 | 25697.0 |
| 2014-11-12 | EW | Futures | 1492.8 | 1498.6 | 1485.1 | 1498.2 | 13966.0 |
| 2014-11-12 | FBTP | Futures | 95.56 | 95.81 | 95.33 | 95.36 | 48732.0 |
| 2014-11-12 | FBTS | Futures | 98.526 | 98.544 | 98.455 | 98.481 | 12342.0 |
| 2014-11-12 | FCE | Futures | 3424.3 | 3428.4 | 3374.9 | 3378.9 | 13984.0 |
| 2014-11-12 | FDAX | Futures | 10244.6 | 10252.3 | 10063.9 | 10083.1 | 127947.0 |
| 2014-11-12 | FESX | Futures | 2239.0 | 2241.2 | 2197.7 | 2202.1 | 989315.0 |
| 2014-11-12 | FEU3 | Futures | 98.626 | 98.626 | 98.626 | 98.626 | 100.0 |
| 2014-11-12 | FGBL | Futures | 133.32 | 133.65 | 133.3 | 133.46 | 600003.0 |
| 2014-11-12 | FGBM | Futures | 123.19 | 123.26 | 123.18 | 123.21 | 313566.0 |
| 2014-11-12 | FGBS | Futures | 110.923 | 110.928 | 110.913 | 110.923 | 155754.0 |
| 2014-11-12 | FGBX | Futures | 145.56 | 146.6 | 145.5 | 145.96 | 26866.0 |
| 2014-11-12 | FMWO | Futures | 5699.9 | 5705.0 | 5684.9 | 5694.9 | 176.0 |
| 2014-11-12 | FOAT | Futures | 122.82 | 123.04 | 122.72 | 122.79 | 56924.0 |
| 2014-11-12 | FTDX | Futures | 1208.8 | 1208.8 | 1198.9 | 1199.8 | 81.0 |
| 2014-11-12 | FTI | Futures | 359.42 | 359.64 | 357.46 | 357.46 | 47.0 |
| 2014-11-12 | FTUK | Futures | 5115.5 | 5116.6 | 5084.1 | 5095.0 | 76343.0 |
| 2014-11-12 | FVSA | Futures | 1520.82 | 1564.78 | 1498.84 | 1560.38 | 7479.0 |
| 2014-11-12 | FXXP | Futures | 256.3 | 256.6 | 253.4 | 253.7 | 6251.0 |
| 2014-11-12 | G | Futures | 98.92 | 99.39 | 98.81 | 99.19 | 165005.0 |
| 2014-11-12 | GF | Futures | 373.284 | 375.45 | 370.917 | 374.447 | 2723.0 |
| 2014-11-12 | GSCI | Futures | 895.06 | 898.02 | 888.98 | 891.18 | 2238.0 |
| 2014-11-12 | HE | Futures | 121.468 | 122.713 | 120.627 | 122.04 | 27463.0 |
| 2014-11-12 | HG | Futures | 3.8471 | 3.861 | 3.8274 | 3.8369 | 40491.0 |
| 2014-11-12 | HH | Futures | 49.795 | 50.105 | 49.652 | 49.879 | 6746.0 |
> showing 50 of 104 rows — these rows as CSV