PREVIEW / futures_daily / 2014-08-29
file: by_date/futures_daily/2014/2014-08-29.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-08-29 | ES | Futures | 2076.81 | 2081.49 | 2069.54 | 2079.15 | 1042385.0 |
| 2014-08-29 | NQ | Futures | 4702.23 | 4714.34 | 4686.65 | 4709.72 | 167836.0 |
| 2014-08-29 | YM | Futures | 17249.6 | 17287.9 | 17174.9 | 17238.5 | 93034.0 |
| 2014-08-29 | CL | Futures | 176.13 | 178.82 | 175.99 | 178.74 | 234972.0 |
| 2014-08-29 | GC | Futures | 1692.6 | 1695.3 | 1684.3 | 1688.6 | 76388.0 |
| 2014-08-29 | ZN | Futures | 117.994622 | 118.082155 | 117.863322 | 117.950855 | 322488.0 |
| 2014-08-29 | A6 | Futures | 0.9034 | 0.90398 | 0.90098 | 0.90127 | 65110.0 |
| 2014-08-29 | AD | Futures | 0.9348 | 0.93916 | 0.93358 | 0.93388 | 53349.0 |
| 2014-08-29 | ALI | Futures | 3064.64 | 3064.64 | 3064.64 | 3064.64 | 0.0 |
| 2014-08-29 | B | Futures | 107.74 | 108.5 | 107.74 | 108.4 | 114759.0 |
| 2014-08-29 | B6 | Futures | 1.7437 | 1.7464 | 1.7409 | 1.741 | 87367.0 |
| 2014-08-29 | BFX | Futures | 3851.4 | 3869.3 | 3851.4 | 3869.3 | 39.0 |
| 2014-08-29 | BR | Futures | 0.23515 | 0.23575 | 0.23434 | 0.23499 | 2605.0 |
| 2014-08-29 | BZ | Futures | 108.79 | 109.25 | 108.58 | 109.17 | 11355.0 |
| 2014-08-29 | C | Futures | 2180.0 | 2205.0 | 2160.0 | 2163.0 | 4249.0 |
| 2014-08-29 | CB | Futures | 147.603 | 148.566 | 147.603 | 148.566 | 6.0 |
| 2014-08-29 | CC | Futures | 2388.0 | 2422.0 | 2377.0 | 2384.0 | 18123.0 |
| 2014-08-29 | CSC | Futures | 5.116 | 5.116 | 5.098 | 5.111 | 24.0 |
| 2014-08-29 | CT | Futures | 84.92 | 85.82 | 83.98 | 85.28 | 33.0 |
| 2014-08-29 | DC | Futures | 41.07 | 41.22 | 40.87 | 41.22 | 87.0 |
| 2014-08-29 | DX | Futures | 78.307 | 78.587 | 78.259 | 78.58 | 19818.0 |
| 2014-08-29 | E1 | Futures | 1.40071 | 1.40276 | 1.39571 | 1.39584 | 43967.0 |
| 2014-08-29 | E6 | Futures | 1.55562 | 1.55728 | 1.54972 | 1.54984 | 200142.0 |
| 2014-08-29 | E7 | Futures | 1.5454 | 1.5471 | 1.5396 | 1.5397 | 2381.0 |
| 2014-08-29 | ED | Futures | 95.4139 | 95.4162 | 95.4139 | 95.4162 | 70298.0 |
| 2014-08-29 | ER | Futures | 97.94 | 97.95 | 97.94 | 97.945 | 47392.0 |
| 2014-08-29 | EW | Futures | 1487.6 | 1493.8 | 1483.0 | 1492.5 | 11062.0 |
| 2014-08-29 | FBTP | Futures | 94.57 | 94.96 | 94.57 | 94.65 | 97817.0 |
| 2014-08-29 | FBTS | Futures | 98.774 | 98.854 | 98.765 | 98.774 | 14925.0 |
| 2014-08-29 | FCE | Futures | 3487.0 | 3499.0 | 3452.4 | 3487.4 | 83096.0 |
| 2014-08-29 | FDAX | Futures | 10451.4 | 10482.3 | 10317.1 | 10396.9 | 95543.0 |
| 2014-08-29 | FESX | Futures | 2281.4 | 2291.5 | 2255.5 | 2275.7 | 973504.0 |
| 2014-08-29 | FEU3 | Futures | 98.571 | 98.571 | 98.567 | 98.567 | 40.0 |
| 2014-08-29 | FGBL | Futures | 131.89 | 131.92 | 131.53 | 131.77 | 669645.0 |
| 2014-08-29 | FGBM | Futures | 122.5 | 122.55 | 122.38 | 122.51 | 362065.0 |
| 2014-08-29 | FGBS | Futures | 110.868 | 110.898 | 110.853 | 110.888 | 239068.0 |
| 2014-08-29 | FGBX | Futures | 144.42 | 144.58 | 143.49 | 144.04 | 24913.0 |
| 2014-08-29 | FMWO | Futures | 5795.3 | 5806.6 | 5791.5 | 5806.6 | 714.0 |
| 2014-08-29 | FOAT | Futures | 121.93 | 121.99 | 121.63 | 121.8 | 64409.0 |
| 2014-08-29 | FTDX | Futures | 1159.4 | 1160.3 | 1151.0 | 1159.4 | 68.0 |
| 2014-08-29 | FTI | Futures | 356.22 | 356.39 | 353.29 | 355.87 | 27705.0 |
| 2014-08-29 | FTUK | Futures | 5238.1 | 5251.5 | 5213.1 | 5231.5 | 99873.0 |
| 2014-08-29 | FVSA | Futures | 1459.36 | 1527.83 | 1437.96 | 1497.88 | 8817.0 |
| 2014-08-29 | FXXP | Futures | 257.6 | 258.7 | 255.7 | 257.2 | 5359.0 |
| 2014-08-29 | G | Futures | 97.3 | 97.36 | 97.02 | 97.3 | 150343.0 |
| 2014-08-29 | GF | Futures | 336.367 | 339.818 | 335.513 | 339.198 | 2080.0 |
| 2014-08-29 | GSCI | Futures | 1020.63 | 1024.32 | 1019.71 | 1024.24 | 545.0 |
| 2014-08-29 | HE | Futures | 116.12 | 119.052 | 116.09 | 118.628 | 26570.0 |
| 2014-08-29 | HG | Futures | 4.0018 | 4.0329 | 3.9898 | 4.0088 | 41772.0 |
| 2014-08-29 | HH | Futures | 49.801 | 49.801 | 49.801 | 49.801 | 6286.0 |
> showing 50 of 105 rows — these rows as CSV