PREVIEW / futures_daily / 2017-11-03
file: by_date/futures_daily/2017/2017-11-03.parquet size: 9 KB rows: 111
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 |
|---|---|---|---|---|---|---|---|
| 2017-11-03 | ES | Futures | 2803.53 | 2812.23 | 2799.18 | 2809.24 | 992681.0 |
| 2017-11-03 | NQ | Futures | 7344.26 | 7396.24 | 7324.88 | 7388.89 | 301691.0 |
| 2017-11-03 | YM | Futures | 24768.4 | 24809.5 | 24727.2 | 24762.0 | 97920.0 |
| 2017-11-03 | CL | Futures | 55.19 | 56.23 | 54.86 | 56.11 | 614159.0 |
| 2017-11-03 | GC | Futures | 1625.5 | 1630.2 | 1610.7 | 1614.9 | 373412.0 |
| 2017-11-03 | ZN | Futures | 123.393529 | 123.640008 | 123.254885 | 123.393529 | 1373893.0 |
| 2017-11-03 | A6 | Futures | 0.79339 | 0.7936 | 0.78558 | 0.78671 | 118787.0 |
| 2017-11-03 | AD | Futures | 0.79433 | 0.80043 | 0.7929 | 0.79753 | 87957.0 |
| 2017-11-03 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2017-11-03 | B | Futures | 43.06 | 44.02 | 42.86 | 43.9 | 272739.0 |
| 2017-11-03 | B6 | Futures | 1.3628 | 1.371 | 1.3609 | 1.3641 | 143905.0 |
| 2017-11-03 | BR | Futures | 0.23106 | 0.23117 | 0.22551 | 0.22743 | 4603.0 |
| 2017-11-03 | BZ | Futures | 42.57 | 43.62 | 42.48 | 43.51 | 25695.0 |
| 2017-11-03 | C | Futures | 1516.0 | 1527.0 | 1503.0 | 1525.0 | 10225.0 |
| 2017-11-03 | CB | Futures | 284.731 | 286.085 | 284.605 | 286.085 | 8.0 |
| 2017-11-03 | CC | Futures | 1530.0 | 1533.0 | 1511.0 | 1530.0 | 31657.0 |
| 2017-11-03 | CSC | Futures | 3.431 | 3.445 | 3.429 | 3.439 | 40.0 |
| 2017-11-03 | CT | Futures | 81.12 | 81.48 | 80.28 | 80.72 | 17444.0 |
| 2017-11-03 | DC | Futures | 27.71 | 27.84 | 27.61 | 27.77 | 222.0 |
| 2017-11-03 | DX | Futures | 88.475 | 88.765 | 88.013 | 88.707 | 24482.0 |
| 2017-11-03 | E1 | Futures | 1.22687 | 1.23298 | 1.22296 | 1.22503 | 26138.0 |
| 2017-11-03 | E6 | Futures | 1.33319 | 1.33758 | 1.32645 | 1.32748 | 231121.0 |
| 2017-11-03 | E7 | Futures | 1.3262 | 1.3302 | 1.3194 | 1.3205 | 4544.0 |
| 2017-11-03 | EBM | Futures | 175.86 | 176.13 | 173.97 | 174.78 | 17678.0 |
| 2017-11-03 | ED | Futures | 95.4891 | 95.4939 | 95.4794 | 95.4842 | 283109.0 |
| 2017-11-03 | ER | Futures | 98.347 | 98.347 | 98.342 | 98.347 | 10643.0 |
| 2017-11-03 | EW | Futures | 1944.0 | 1951.7 | 1941.3 | 1950.2 | 9194.0 |
| 2017-11-03 | FBON | Futures | 126.25 | 126.51 | 126.23 | 126.34 | 542.0 |
| 2017-11-03 | FBTP | Futures | 112.72 | 112.97 | 112.58 | 112.72 | 85068.0 |
| 2017-11-03 | FBTS | Futures | 103.649 | 103.668 | 103.631 | 103.649 | 34094.0 |
| 2017-11-03 | FCE | Futures | 4943.5 | 4948.0 | 4925.2 | 4943.1 | 50308.0 |
| 2017-11-03 | FDAX | Futures | 14163.6 | 14192.0 | 14109.5 | 14168.9 | 63268.0 |
| 2017-11-03 | FDIV | Futures | 158.36 | 158.44 | 158.36 | 158.44 | 30.0 |
| 2017-11-03 | FDXM | Futures | 14044.1 | 14072.2 | 13990.9 | 14049.3 | 21245.0 |
| 2017-11-03 | FESX | Futures | 3011.9 | 3013.5 | 2994.8 | 3005.4 | 652507.0 |
| 2017-11-03 | FEU3 | Futures | 99.016 | 99.016 | 99.016 | 99.016 | 6.0 |
| 2017-11-03 | FGBL | Futures | 150.39 | 150.71 | 150.35 | 150.47 | 570056.0 |
| 2017-11-03 | FGBM | Futures | 130.12 | 130.19 | 130.07 | 130.11 | 330264.0 |
| 2017-11-03 | FGBS | Futures | 112.552 | 112.567 | 112.547 | 112.547 | 124295.0 |
| 2017-11-03 | FGBX | Futures | 169.03 | 169.77 | 168.97 | 169.22 | 39973.0 |
| 2017-11-03 | FMWO | Futures | 6795.8 | 6798.2 | 6788.8 | 6797.0 | 225.0 |
| 2017-11-03 | FOAT | Futures | 138.09 | 138.32 | 138.08 | 138.16 | 86226.0 |
| 2017-11-03 | FTDX | Futures | 2555.4 | 2576.8 | 2555.4 | 2575.8 | 142.0 |
| 2017-11-03 | FTI | Futures | 513.07 | 513.72 | 511.64 | 513.35 | 19950.0 |
| 2017-11-03 | FTUK | Futures | 6545.8 | 6552.3 | 6518.9 | 6535.0 | 74931.0 |
| 2017-11-03 | FVSA | Futures | 333.81 | 333.81 | 323.58 | 326.14 | 17244.0 |
| 2017-11-03 | FXXP | Futures | 335.7 | 336.1 | 334.8 | 336.0 | 21070.0 |
| 2017-11-03 | G | Futures | 114.63 | 114.87 | 114.39 | 114.52 | 175866.0 |
| 2017-11-03 | GF | Futures | 344.183 | 348.062 | 343.536 | 346.715 | 2408.0 |
| 2017-11-03 | GSCI | Futures | 490.94 | 495.95 | 490.0 | 495.6 | 641.0 |
> showing 50 of 111 rows — these rows as CSV