PREVIEW / futures_daily / 2014-11-21
file: by_date/futures_daily/2014/2014-11-21.parquet size: 9 KB rows: 107
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-21 | ES | Futures | 2143.75 | 2164.64 | 2141.14 | 2153.67 | 1634315.0 |
| 2014-11-21 | NQ | Futures | 4920.43 | 4965.63 | 4911.16 | 4924.78 | 285753.0 |
| 2014-11-21 | YM | Futures | 17952.0 | 18129.5 | 17934.8 | 18038.2 | 129823.0 |
| 2014-11-21 | CL | Futures | 147.07 | 150.03 | 145.77 | 147.49 | 275317.0 |
| 2014-11-21 | GC | Futures | 1566.1 | 1584.0 | 1555.8 | 1571.0 | 199906.0 |
| 2014-11-21 | ZN | Futures | 118.568672 | 118.759038 | 118.422237 | 118.729751 | 1133366.0 |
| 2014-11-21 | A6 | Futures | 0.83623 | 0.84634 | 0.83497 | 0.84041 | 122559.0 |
| 2014-11-21 | AD | Futures | 0.89792 | 0.90727 | 0.8964 | 0.90331 | 81434.0 |
| 2014-11-21 | ALI | Futures | 3084.16 | 3084.16 | 3084.16 | 3084.16 | 0.0 |
| 2014-11-21 | B | Futures | 82.66 | 84.38 | 81.75 | 83.08 | 264605.0 |
| 2014-11-21 | B6 | Futures | 1.649 | 1.6515 | 1.6423 | 1.6443 | 82233.0 |
| 2014-11-21 | BFX | Futures | 3877.4 | 3921.3 | 3877.4 | 3921.3 | 45.0 |
| 2014-11-21 | BR | Futures | 0.21148 | 0.21461 | 0.21058 | 0.21388 | 1049.0 |
| 2014-11-21 | BZ | Futures | 83.66 | 85.22 | 82.6 | 83.93 | 19896.0 |
| 2014-11-21 | C | Futures | 2020.0 | 2020.0 | 2010.0 | 2017.0 | 5161.0 |
| 2014-11-21 | CB | Futures | 138.219 | 138.629 | 138.219 | 138.629 | 4.0 |
| 2014-11-21 | CC | Futures | 2082.0 | 2085.0 | 2067.0 | 2083.0 | 6491.0 |
| 2014-11-21 | CNH | Futures | 7.0292 | 7.0439 | 7.0292 | 7.039 | 2.0 |
| 2014-11-21 | CSC | Futures | 4.801 | 4.838 | 4.728 | 4.83 | 95.0 |
| 2014-11-21 | CT | Futures | 74.27 | 75.76 | 74.14 | 75.72 | 233.0 |
| 2014-11-21 | DC | Futures | 38.82 | 39.55 | 38.55 | 39.39 | 867.0 |
| 2014-11-21 | DX | Futures | 83.27 | 83.992 | 83.066 | 83.92 | 55316.0 |
| 2014-11-21 | E1 | Futures | 1.33428 | 1.33722 | 1.31714 | 1.31829 | 58876.0 |
| 2014-11-21 | E6 | Futures | 1.47668 | 1.47963 | 1.45691 | 1.45832 | 322282.0 |
| 2014-11-21 | E7 | Futures | 1.4673 | 1.4703 | 1.4476 | 1.4491 | 4922.0 |
| 2014-11-21 | ED | Futures | 95.4374 | 95.4422 | 95.4374 | 95.4398 | 64765.0 |
| 2014-11-21 | ER | Futures | 97.999 | 98.004 | 97.994 | 97.999 | 51225.0 |
| 2014-11-21 | EW | Futures | 1498.6 | 1516.1 | 1496.3 | 1504.4 | 15672.0 |
| 2014-11-21 | FBTP | Futures | 96.1 | 96.76 | 96.05 | 96.72 | 86740.0 |
| 2014-11-21 | FBTS | Futures | 98.579 | 98.73 | 98.579 | 98.694 | 14643.0 |
| 2014-11-21 | FCE | Futures | 3433.6 | 3524.0 | 3429.6 | 3514.7 | 141380.0 |
| 2014-11-21 | FDAX | Futures | 10417.2 | 10666.9 | 10414.4 | 10660.9 | 162090.0 |
| 2014-11-21 | FDIV | Futures | 138.17 | 138.81 | 138.17 | 138.81 | 20.0 |
| 2014-11-21 | FESX | Futures | 2247.0 | 2312.9 | 2247.0 | 2310.7 | 1721053.0 |
| 2014-11-21 | FEU3 | Futures | 98.621 | 98.621 | 98.621 | 98.621 | 500.0 |
| 2014-11-21 | FGBL | Futures | 133.55 | 133.95 | 133.5 | 133.88 | 565357.0 |
| 2014-11-21 | FGBM | Futures | 123.11 | 123.23 | 123.08 | 123.2 | 323249.0 |
| 2014-11-21 | FGBS | Futures | 110.838 | 110.878 | 110.823 | 110.858 | 346614.0 |
| 2014-11-21 | FGBX | Futures | 146.48 | 147.32 | 146.36 | 147.12 | 19692.0 |
| 2014-11-21 | FMWO | Futures | 5796.5 | 5796.5 | 5788.9 | 5795.2 | 1285.0 |
| 2014-11-21 | FOAT | Futures | 123.13 | 123.49 | 123.05 | 123.43 | 55778.0 |
| 2014-11-21 | FTDX | Futures | 1250.4 | 1261.8 | 1231.0 | 1258.4 | 260.0 |
| 2014-11-21 | FTI | Futures | 362.85 | 369.33 | 362.85 | 368.29 | 40515.0 |
| 2014-11-21 | FTUK | Futures | 5185.4 | 5239.2 | 5173.4 | 5222.9 | 119201.0 |
| 2014-11-21 | FVSA | Futures | 1547.19 | 1560.38 | 1520.82 | 1538.4 | 4818.0 |
| 2014-11-21 | FXXP | Futures | 257.3 | 262.4 | 256.7 | 262.3 | 17068.0 |
| 2014-11-21 | G | Futures | 100.0 | 100.46 | 100.0 | 100.38 | 184687.0 |
| 2014-11-21 | GF | Futures | 377.817 | 380.063 | 377.055 | 379.221 | 2554.0 |
| 2014-11-21 | GSCI | Futures | 886.7 | 894.55 | 881.55 | 886.61 | 45.0 |
| 2014-11-21 | HE | Futures | 122.283 | 122.451 | 120.942 | 121.344 | 13002.0 |
> showing 50 of 107 rows — these rows as CSV