PREVIEW / futures_daily / 2014-11-03
file: by_date/futures_daily/2014/2014-11-03.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-11-03 | ES | Futures | 2100.92 | 2109.28 | 2096.48 | 2100.66 | 1361523.0 |
| 2014-11-03 | NQ | Futures | 4810.04 | 4837.28 | 4800.48 | 4818.15 | 215040.0 |
| 2014-11-03 | YM | Futures | 17563.4 | 17593.9 | 17517.8 | 17536.0 | 108738.0 |
| 2014-11-03 | CL | Futures | 154.73 | 155.48 | 149.91 | 151.26 | 386045.0 |
| 2014-11-03 | GC | Futures | 1536.1 | 1539.1 | 1522.8 | 1534.4 | 129435.0 |
| 2014-11-03 | ZN | Futures | 118.480811 | 118.671177 | 118.041505 | 118.334376 | 1139895.0 |
| 2014-11-03 | A6 | Futures | 0.84877 | 0.84896 | 0.8408 | 0.84167 | 112489.0 |
| 2014-11-03 | AD | Futures | 0.89985 | 0.90087 | 0.89193 | 0.89284 | 63695.0 |
| 2014-11-03 | ALI | Futures | 3137.37 | 3137.37 | 3137.37 | 3137.37 | 11.0 |
| 2014-11-03 | B | Futures | 89.24 | 89.85 | 87.41 | 88.19 | 125254.0 |
| 2014-11-03 | B6 | Futures | 1.6786 | 1.6847 | 1.6734 | 1.6788 | 85037.0 |
| 2014-11-03 | BFX | Futures | 3807.8 | 3807.8 | 3775.3 | 3779.9 | 18.0 |
| 2014-11-03 | BR | Futures | 0.21696 | 0.22106 | 0.21347 | 0.21434 | 2947.0 |
| 2014-11-03 | BZ | Futures | 89.91 | 90.74 | 88.32 | 89.09 | 14483.0 |
| 2014-11-03 | C | Futures | 2028.0 | 2038.0 | 2010.0 | 2011.0 | 5237.0 |
| 2014-11-03 | CB | Futures | 135.078 | 135.213 | 135.078 | 135.078 | 3.0 |
| 2014-11-03 | CC | Futures | 2141.0 | 2145.0 | 2111.0 | 2112.0 | 15404.0 |
| 2014-11-03 | CNH | Futures | 7.0459 | 7.0487 | 7.0428 | 7.0487 | 45.0 |
| 2014-11-03 | CSC | Futures | 4.954 | 4.954 | 4.87 | 4.919 | 88.0 |
| 2014-11-03 | CT | Futures | 81.67 | 82.21 | 80.68 | 81.41 | 14568.0 |
| 2014-11-03 | DC | Futures | 39.51 | 39.78 | 39.03 | 39.43 | 312.0 |
| 2014-11-03 | DX | Futures | 82.71 | 83.099 | 82.705 | 82.973 | 40070.0 |
| 2014-11-03 | E1 | Futures | 1.32648 | 1.32737 | 1.3197 | 1.32558 | 42140.0 |
| 2014-11-03 | E6 | Futures | 1.47315 | 1.47315 | 1.46456 | 1.47068 | 225811.0 |
| 2014-11-03 | E7 | Futures | 1.4637 | 1.464 | 1.4552 | 1.4614 | 3366.0 |
| 2014-11-03 | ED | Futures | 95.4422 | 95.4422 | 95.4374 | 95.4374 | 49130.0 |
| 2014-11-03 | ER | Futures | 97.984 | 98.004 | 97.984 | 97.994 | 37087.0 |
| 2014-11-03 | EW | Futures | 1476.5 | 1485.1 | 1472.7 | 1475.5 | 20426.0 |
| 2014-11-03 | FBTP | Futures | 95.42 | 95.54 | 94.91 | 95.02 | 51735.0 |
| 2014-11-03 | FBTS | Futures | 98.313 | 98.375 | 98.25 | 98.268 | 11600.0 |
| 2014-11-03 | FCE | Futures | 3411.0 | 3418.7 | 3374.3 | 3380.8 | 99881.0 |
| 2014-11-03 | FDAX | Futures | 10197.5 | 10235.9 | 10115.4 | 10137.3 | 108105.0 |
| 2014-11-03 | FESX | Futures | 2248.4 | 2252.1 | 2220.2 | 2226.7 | 863672.0 |
| 2014-11-03 | FGBL | Futures | 133.18 | 133.33 | 132.74 | 132.81 | 537984.0 |
| 2014-11-03 | FGBM | Futures | 123.19 | 123.21 | 123.0 | 123.01 | 321710.0 |
| 2014-11-03 | FGBS | Futures | 110.953 | 110.953 | 110.913 | 110.913 | 193549.0 |
| 2014-11-03 | FGBX | Futures | 145.3 | 145.88 | 144.2 | 144.42 | 23253.0 |
| 2014-11-03 | FMWO | Futures | 5679.9 | 5683.6 | 5674.9 | 5674.9 | 200.0 |
| 2014-11-03 | FOAT | Futures | 122.66 | 122.99 | 122.24 | 122.32 | 68927.0 |
| 2014-11-03 | FTDX | Futures | 1173.4 | 1184.2 | 1173.4 | 1180.4 | 200.0 |
| 2014-11-03 | FTI | Futures | 359.11 | 360.25 | 356.23 | 356.93 | 28534.0 |
| 2014-11-03 | FTUK | Futures | 5041.2 | 5053.6 | 4989.0 | 4994.8 | 104344.0 |
| 2014-11-03 | FVSA | Futures | 1612.49 | 1654.15 | 1608.32 | 1654.15 | 4083.0 |
| 2014-11-03 | FXXP | Futures | 255.3 | 255.8 | 252.9 | 253.0 | 8410.0 |
| 2014-11-03 | G | Futures | 98.89 | 98.92 | 98.32 | 98.4 | 144005.0 |
| 2014-11-03 | GF | Futures | 367.22 | 370.038 | 366.046 | 368.747 | 1965.0 |
| 2014-11-03 | GSCI | Futures | 919.46 | 920.98 | 906.12 | 908.59 | 143.0 |
| 2014-11-03 | HE | Futures | 118.81 | 119.752 | 118.54 | 119.583 | 13460.0 |
| 2014-11-03 | HG | Futures | 3.8585 | 3.894 | 3.8338 | 3.8877 | 36125.0 |
| 2014-11-03 | HH | Futures | 48.067 | 48.246 | 47.59 | 48.222 | 682.0 |
> showing 50 of 105 rows — these rows as CSV