PREVIEW / futures_daily / 2018-10-17
file: by_date/futures_daily/2018/2018-10-17.parquet size: 10 KB rows: 115
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-17 | ES | Futures | 3054.25 | 3062.93 | 3018.47 | 3054.25 | 1948526.0 |
| 2018-10-17 | NQ | Futures | 8525.31 | 8558.7 | 8387.96 | 8494.53 | 663303.0 |
| 2018-10-17 | YM | Futures | 27089.5 | 27215.9 | 26811.5 | 27101.1 | 270453.0 |
| 2018-10-17 | CL | Futures | 75.11 | 75.34 | 72.3 | 72.64 | 431861.0 |
| 2018-10-17 | GC | Futures | 1556.4 | 1562.6 | 1550.9 | 1555.6 | 235331.0 |
| 2018-10-17 | ZN | Futures | 117.658626 | 117.829822 | 117.378486 | 117.580809 | 1593614.0 |
| 2018-10-17 | A6 | Futures | 0.73549 | 0.73714 | 0.73158 | 0.73272 | 83323.0 |
| 2018-10-17 | AD | Futures | 0.78265 | 0.78275 | 0.77714 | 0.77795 | 63905.0 |
| 2018-10-17 | B | Futures | 60.06 | 60.14 | 58.17 | 58.82 | 336595.0 |
| 2018-10-17 | B6 | Futures | 1.3595 | 1.3604 | 1.3509 | 1.3531 | 97044.0 |
| 2018-10-17 | BR | Futures | 0.20296 | 0.20708 | 0.20296 | 0.20647 | 353.0 |
| 2018-10-17 | BTC | Futures | 9300.3 | 9350.8 | 9235.4 | 9264.2 | 1189.0 |
| 2018-10-17 | BZ | Futures | 59.51 | 59.68 | 57.74 | 58.38 | 38202.0 |
| 2018-10-17 | C | Futures | 1484.0 | 1497.0 | 1471.0 | 1496.0 | 7009.0 |
| 2018-10-17 | CB | Futures | 271.567 | 271.567 | 270.786 | 271.267 | 39.0 |
| 2018-10-17 | CC | Futures | 1544.0 | 1559.0 | 1524.0 | 1555.0 | 18800.0 |
| 2018-10-17 | CNH | Futures | 6.9621 | 6.9757 | 6.9604 | 6.9754 | 219.0 |
| 2018-10-17 | CSC | Futures | 3.13 | 3.13 | 3.094 | 3.116 | 83.0 |
| 2018-10-17 | CT | Futures | 88.06 | 88.23 | 87.17 | 87.46 | 11790.0 |
| 2018-10-17 | DC | Futures | 26.26 | 26.26 | 25.96 | 26.06 | 201.0 |
| 2018-10-17 | DX | Futures | 90.054 | 90.605 | 90.03 | 90.53 | 24832.0 |
| 2018-10-17 | E1 | Futures | 1.20315 | 1.20362 | 1.19663 | 1.19758 | 22798.0 |
| 2018-10-17 | E6 | Futures | 1.29279 | 1.29368 | 1.28417 | 1.28539 | 217562.0 |
| 2018-10-17 | E7 | Futures | 1.2865 | 1.2873 | 1.2778 | 1.2791 | 4507.0 |
| 2018-10-17 | EBM | Futures | 211.31 | 211.83 | 209.76 | 210.01 | 11331.0 |
| 2018-10-17 | ED | Futures | 95.0378 | 95.0427 | 95.0134 | 95.0232 | 408396.0 |
| 2018-10-17 | ER | Futures | 98.381 | 98.386 | 98.377 | 98.381 | 88769.0 |
| 2018-10-17 | EW | Futures | 2018.4 | 2022.5 | 1990.7 | 2013.7 | 21152.0 |
| 2018-10-17 | FBON | Futures | 126.58 | 126.8 | 126.42 | 126.46 | 1060.0 |
| 2018-10-17 | FBTP | Futures | 104.3 | 104.78 | 103.36 | 103.57 | 102449.0 |
| 2018-10-17 | FBTS | Futures | 101.516 | 101.769 | 101.291 | 101.385 | 85721.0 |
| 2018-10-17 | FCE | Futures | 4629.8 | 4657.1 | 4577.9 | 4603.4 | 162458.0 |
| 2018-10-17 | FDAX | Futures | 12402.3 | 12448.0 | 12257.2 | 12314.5 | 114980.0 |
| 2018-10-17 | FDIV | Futures | 140.16 | 140.2 | 138.9 | 138.9 | 750.0 |
| 2018-10-17 | FDXM | Futures | 12185.9 | 12232.4 | 12044.4 | 12101.2 | 53371.0 |
| 2018-10-17 | FESX | Futures | 2734.4 | 2747.8 | 2703.3 | 2715.9 | 1145683.0 |
| 2018-10-17 | FGBL | Futures | 151.91 | 152.4 | 151.9 | 152.32 | 682476.0 |
| 2018-10-17 | FGBM | Futures | 130.56 | 130.75 | 130.56 | 130.73 | 408370.0 |
| 2018-10-17 | FGBS | Futures | 112.598 | 112.628 | 112.593 | 112.623 | 401443.0 |
| 2018-10-17 | FGBX | Futures | 174.73 | 175.98 | 174.73 | 175.88 | 50729.0 |
| 2018-10-17 | FMWO | Futures | 7001.8 | 7001.8 | 6913.8 | 6939.3 | 16937.0 |
| 2018-10-17 | FOAT | Futures | 139.37 | 139.75 | 139.36 | 139.69 | 142482.0 |
| 2018-10-17 | FTDX | Futures | 2641.7 | 2684.5 | 2623.1 | 2639.8 | 418.0 |
| 2018-10-17 | FTI | Futures | 489.86 | 495.97 | 488.37 | 490.4 | 32019.0 |
| 2018-10-17 | FTUK | Futures | 6301.9 | 6316.6 | 6247.8 | 6271.1 | 111172.0 |
| 2018-10-17 | FVSA | Futures | 323.45 | 339.62 | 318.7 | 330.11 | 36769.0 |
| 2018-10-17 | FXXP | Futures | 315.8 | 317.2 | 312.6 | 313.8 | 66195.0 |
| 2018-10-17 | G | Futures | 113.59 | 113.9 | 113.54 | 113.85 | 224138.0 |
| 2018-10-17 | GF | Futures | 320.885 | 321.405 | 318.546 | 318.858 | 3335.0 |
| 2018-10-17 | GSCI | Futures | 551.59 | 551.65 | 546.16 | 546.16 | 49.0 |
> showing 50 of 115 rows — these rows as CSV