PREVIEW / futures_daily / 2014-12-04
file: by_date/futures_daily/2014/2014-12-04.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 |
|---|---|---|---|---|---|---|---|
| 2014-12-04 | ES | Futures | 2165.43 | 2169.87 | 2153.15 | 2164.38 | 1374378.0 |
| 2014-12-04 | NQ | Futures | 4997.5 | 5016.63 | 4975.77 | 4999.24 | 248733.0 |
| 2014-12-04 | YM | Futures | 18152.9 | 18189.4 | 18059.5 | 18149.8 | 133921.0 |
| 2014-12-04 | CL | Futures | 129.93 | 131.51 | 127.4 | 128.79 | 237011.0 |
| 2014-12-04 | GC | Futures | 1582.9 | 1588.4 | 1572.1 | 1580.8 | 117722.0 |
| 2014-12-04 | ZN | Futures | 118.949404 | 119.227631 | 118.788325 | 119.125127 | 44798.0 |
| 2014-12-04 | A6 | Futures | 0.81466 | 0.81874 | 0.81145 | 0.81398 | 104860.0 |
| 2014-12-04 | AD | Futures | 0.89325 | 0.89559 | 0.89112 | 0.89193 | 54721.0 |
| 2014-12-04 | ALI | Futures | 2980.93 | 2980.93 | 2980.93 | 2980.93 | 0.0 |
| 2014-12-04 | B | Futures | 72.96 | 73.47 | 71.61 | 72.41 | 117394.0 |
| 2014-12-04 | B6 | Futures | 1.6483 | 1.6529 | 1.6441 | 1.6473 | 93071.0 |
| 2014-12-04 | BFX | Futures | 3996.8 | 4006.5 | 3951.5 | 3951.5 | 16.0 |
| 2014-12-04 | BR | Futures | 0.20836 | 0.20844 | 0.20761 | 0.20844 | 11.0 |
| 2014-12-04 | BZ | Futures | 73.55 | 74.1 | 72.26 | 73.06 | 15199.0 |
| 2014-12-04 | C | Futures | 2069.0 | 2080.0 | 2067.0 | 2076.0 | 3255.0 |
| 2014-12-04 | CB | Futures | 140.601 | 140.889 | 139.656 | 140.067 | 17.0 |
| 2014-12-04 | CC | Futures | 2103.0 | 2122.0 | 2102.0 | 2114.0 | 9393.0 |
| 2014-12-04 | CNH | Futures | 7.0648 | 7.0648 | 7.0528 | 7.0562 | 6.0 |
| 2014-12-04 | CSC | Futures | 4.674 | 4.674 | 4.634 | 4.64 | 61.0 |
| 2014-12-04 | CT | Futures | 76.03 | 77.45 | 76.03 | 77.17 | 15000.0 |
| 2014-12-04 | DC | Futures | 37.56 | 37.56 | 36.82 | 36.93 | 135.0 |
| 2014-12-04 | DX | Futures | 84.457 | 84.675 | 83.754 | 84.234 | 67520.0 |
| 2014-12-04 | E1 | Futures | 1.30781 | 1.32533 | 1.30512 | 1.31548 | 102369.0 |
| 2014-12-04 | E6 | Futures | 1.4489 | 1.46644 | 1.44514 | 1.45585 | 434195.0 |
| 2014-12-04 | E7 | Futures | 1.4401 | 1.4571 | 1.4359 | 1.4467 | 6923.0 |
| 2014-12-04 | ED | Futures | 95.4398 | 95.4422 | 95.4374 | 95.4398 | 68641.0 |
| 2014-12-04 | ER | Futures | 98.014 | 98.014 | 97.999 | 98.004 | 77450.0 |
| 2014-12-04 | EW | Futures | 1503.6 | 1506.5 | 1495.7 | 1502.7 | 14475.0 |
| 2014-12-04 | FBTP | Futures | 98.26 | 98.3 | 97.58 | 97.87 | 158406.0 |
| 2014-12-04 | FBTS | Futures | 98.801 | 98.81 | 98.668 | 98.721 | 27785.0 |
| 2014-12-04 | FCE | Futures | 3565.8 | 3585.2 | 3487.1 | 3498.5 | 151516.0 |
| 2014-12-04 | FDAX | Futures | 10972.6 | 11093.6 | 10775.4 | 10794.6 | 154786.0 |
| 2014-12-04 | FESX | Futures | 2360.7 | 2375.9 | 2304.9 | 2309.3 | 1659824.0 |
| 2014-12-04 | FGBL | Futures | 134.21 | 134.41 | 133.81 | 133.99 | 1180893.0 |
| 2014-12-04 | FGBM | Futures | 123.29 | 123.3 | 123.09 | 123.17 | 791781.0 |
| 2014-12-04 | FGBS | Futures | 110.873 | 110.878 | 110.823 | 110.833 | 464877.0 |
| 2014-12-04 | FGBX | Futures | 148.37 | 149.21 | 147.65 | 148.15 | 55813.0 |
| 2014-12-04 | FMWO | Futures | 5801.5 | 5801.5 | 5770.1 | 5770.1 | 171.0 |
| 2014-12-04 | FOAT | Futures | 124.2 | 124.25 | 123.85 | 124.04 | 150065.0 |
| 2014-12-04 | FTDX | Futures | 1294.4 | 1301.9 | 1279.2 | 1282.1 | 270.0 |
| 2014-12-04 | FTI | Futures | 374.24 | 375.98 | 367.64 | 368.2 | 43679.0 |
| 2014-12-04 | FTUK | Futures | 5207.5 | 5209.4 | 5158.8 | 5162.6 | 105428.0 |
| 2014-12-04 | FVSA | Futures | 1507.64 | 1525.22 | 1446.1 | 1520.82 | 8558.0 |
| 2014-12-04 | FXXP | Futures | 265.8 | 266.8 | 261.4 | 261.6 | 10478.0 |
| 2014-12-04 | G | Futures | 100.76 | 101.21 | 100.76 | 100.93 | 167176.0 |
| 2014-12-04 | GF | Futures | 376.814 | 380.464 | 376.292 | 378.579 | 4813.0 |
| 2014-12-04 | GSCI | Futures | 808.39 | 808.39 | 803.58 | 807.04 | 313.0 |
| 2014-12-04 | HE | Futures | 116.548 | 116.984 | 115.24 | 116.213 | 15476.0 |
| 2014-12-04 | HG | Futures | 3.6445 | 3.7219 | 3.6419 | 3.7023 | 47343.0 |
| 2014-12-04 | HH | Futures | 45.295 | 45.295 | 43.805 | 43.829 | 8113.0 |
> showing 50 of 105 rows — these rows as CSV