PREVIEW / futures_daily / 2017-11-24
file: by_date/futures_daily/2017/2017-11-24.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 |
|---|---|---|---|---|---|---|---|
| 2017-11-24 | ES | Futures | 2820.66 | 2831.27 | 2816.58 | 2829.09 | 551196.0 |
| 2017-11-24 | NQ | Futures | 7503.71 | 7536.31 | 7489.03 | 7533.37 | 118443.0 |
| 2017-11-24 | YM | Futures | 24800.0 | 24888.7 | 24744.1 | 24833.8 | 74052.0 |
| 2017-11-24 | CL | Futures | 58.11 | 59.11 | 57.81 | 59.01 | 577826.0 |
| 2017-11-24 | GC | Futures | 1643.8 | 1645.6 | 1635.2 | 1638.0 | 347029.0 |
| 2017-11-24 | ZN | Futures | 123.331909 | 123.378124 | 123.131645 | 123.20867 | 903231.0 |
| 2017-11-24 | A6 | Futures | 0.78341 | 0.78578 | 0.78218 | 0.78321 | 81081.0 |
| 2017-11-24 | AD | Futures | 0.80094 | 0.80308 | 0.79829 | 0.80053 | 64020.0 |
| 2017-11-24 | B | Futures | 44.81 | 45.23 | 44.76 | 45.17 | 152696.0 |
| 2017-11-24 | B6 | Futures | 1.3898 | 1.3938 | 1.3851 | 1.3907 | 121611.0 |
| 2017-11-24 | BR | Futures | 0.23294 | 0.23294 | 0.23294 | 0.23294 | 3.0 |
| 2017-11-24 | BZ | Futures | 44.33 | 44.83 | 44.09 | 44.77 | 21047.0 |
| 2017-11-24 | C | Futures | 1512.0 | 1512.0 | 1477.0 | 1500.0 | 4628.0 |
| 2017-11-24 | CC | Futures | 1575.0 | 1582.0 | 1554.0 | 1572.0 | 11401.0 |
| 2017-11-24 | CNH | Futures | 6.7818 | 6.7847 | 6.7536 | 6.7711 | 59.0 |
| 2017-11-24 | CT | Futures | 83.09 | 84.19 | 83.01 | 84.01 | 16314.0 |
| 2017-11-24 | DX | Futures | 87.073 | 87.133 | 86.605 | 86.696 | 17459.0 |
| 2017-11-24 | E1 | Futures | 1.24741 | 1.2512 | 1.24582 | 1.24986 | 28186.0 |
| 2017-11-24 | E6 | Futures | 1.3503 | 1.36456 | 1.34956 | 1.36262 | 263437.0 |
| 2017-11-24 | E7 | Futures | 1.3432 | 1.3573 | 1.3425 | 1.3555 | 5703.0 |
| 2017-11-24 | EBM | Futures | 170.73 | 171.0 | 169.92 | 170.19 | 16550.0 |
| 2017-11-24 | ED | Futures | 95.4552 | 95.46 | 95.4552 | 95.4552 | 106743.0 |
| 2017-11-24 | ER | Futures | 98.347 | 98.347 | 98.342 | 98.342 | 18034.0 |
| 2017-11-24 | EW | Futures | 1973.2 | 1981.7 | 1968.5 | 1974.5 | 4481.0 |
| 2017-11-24 | FBON | Futures | 126.45 | 126.45 | 126.13 | 126.2 | 328.0 |
| 2017-11-24 | FBTP | Futures | 112.99 | 113.1 | 112.62 | 112.72 | 62853.0 |
| 2017-11-24 | FBTS | Futures | 103.842 | 103.869 | 103.805 | 103.814 | 51950.0 |
| 2017-11-24 | FCE | Futures | 4811.8 | 4854.4 | 4811.4 | 4826.6 | 54803.0 |
| 2017-11-24 | FDAX | Futures | 13661.7 | 13831.5 | 13637.0 | 13731.6 | 90400.0 |
| 2017-11-24 | FDXM | Futures | 13551.1 | 13715.8 | 13522.0 | 13615.7 | 31009.0 |
| 2017-11-24 | FESX | Futures | 2908.3 | 2936.0 | 2907.5 | 2919.7 | 900893.0 |
| 2017-11-24 | FGBL | Futures | 150.7 | 150.74 | 150.41 | 150.59 | 521536.0 |
| 2017-11-24 | FGBM | Futures | 129.95 | 129.99 | 129.88 | 129.97 | 294386.0 |
| 2017-11-24 | FGBS | Futures | 112.472 | 112.487 | 112.462 | 112.482 | 222366.0 |
| 2017-11-24 | FGBX | Futures | 170.97 | 171.14 | 170.07 | 170.58 | 42915.0 |
| 2017-11-24 | FMWO | Futures | 6836.0 | 6858.4 | 6833.6 | 6854.9 | 1625.0 |
| 2017-11-24 | FOAT | Futures | 139.17 | 139.21 | 138.78 | 138.99 | 109006.0 |
| 2017-11-24 | FTDX | Futures | 2575.3 | 2579.3 | 2563.8 | 2566.8 | 118.0 |
| 2017-11-24 | FTI | Futures | 502.64 | 504.68 | 501.62 | 501.89 | 19637.0 |
| 2017-11-24 | FTUK | Futures | 6436.9 | 6443.4 | 6411.3 | 6434.3 | 63289.0 |
| 2017-11-24 | FVSA | Futures | 311.05 | 312.23 | 304.01 | 308.71 | 10509.0 |
| 2017-11-24 | FXXP | Futures | 329.1 | 330.1 | 328.0 | 328.4 | 23147.0 |
| 2017-11-24 | G | Futures | 114.7 | 114.76 | 114.53 | 114.73 | 338326.0 |
| 2017-11-24 | GF | Futures | 329.814 | 332.03 | 328.084 | 331.435 | 2972.0 |
| 2017-11-24 | GSCI | Futures | 502.96 | 502.96 | 501.62 | 502.55 | 289.0 |
| 2017-11-24 | HE | Futures | 92.576 | 93.577 | 92.476 | 92.576 | 10175.0 |
| 2017-11-24 | HG | Futures | 3.7815 | 3.8288 | 3.7665 | 3.8204 | 44604.0 |
| 2017-11-24 | HH | Futures | 17.835 | 17.835 | 16.918 | 16.918 | 1083.0 |
| 2017-11-24 | HO | Futures | 1.268 | 1.2806 | 1.2608 | 1.2795 | 9871.0 |
| 2017-11-24 | HRC | Futures | 1502.7 | 1502.7 | 1502.7 | 1502.7 | 20.0 |
> showing 50 of 107 rows — these rows as CSV