PREVIEW / futures_daily / 2018-05-10
file: by_date/futures_daily/2018/2018-05-10.parquet size: 10 KB rows: 112
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-05-10 | ES | Futures | 2931.81 | 2963.35 | 2928.28 | 2956.55 | 1173629.0 |
| 2018-05-10 | NQ | Futures | 8071.31 | 8159.38 | 8062.82 | 8152.07 | 292974.0 |
| 2018-05-10 | YM | Futures | 25817.8 | 26088.5 | 25778.8 | 26010.6 | 155974.0 |
| 2018-05-10 | CL | Futures | 71.49 | 72.15 | 70.82 | 71.62 | 749808.0 |
| 2018-05-10 | GC | Futures | 1676.0 | 1689.6 | 1673.2 | 1688.2 | 373535.0 |
| 2018-05-10 | ZN | Futures | 118.330481 | 118.78023 | 118.314973 | 118.501076 | 1424795.0 |
| 2018-05-10 | A6 | Futures | 0.76707 | 0.7753 | 0.76656 | 0.77499 | 125951.0 |
| 2018-05-10 | AD | Futures | 0.78743 | 0.79456 | 0.78733 | 0.79355 | 101179.0 |
| 2018-05-10 | B | Futures | 56.75 | 57.16 | 56.07 | 56.77 | 314193.0 |
| 2018-05-10 | B6 | Futures | 1.4056 | 1.4124 | 1.396 | 1.4024 | 221143.0 |
| 2018-05-10 | BR | Futures | 0.21127 | 0.21462 | 0.21127 | 0.21454 | 3971.0 |
| 2018-05-10 | BTC | Futures | 12996.6 | 13221.3 | 12694.7 | 12764.9 | 3063.0 |
| 2018-05-10 | BZ | Futures | 56.06 | 56.55 | 55.49 | 56.19 | 32445.0 |
| 2018-05-10 | C | Futures | 1746.0 | 1763.0 | 1734.0 | 1757.0 | 5631.0 |
| 2018-05-10 | CB | Futures | 295.269 | 295.269 | 295.269 | 295.269 | 2.0 |
| 2018-05-10 | CC | Futures | 2019.0 | 2030.0 | 1978.0 | 2014.0 | 15134.0 |
| 2018-05-10 | CNH | Futures | 6.4543 | 6.4543 | 6.4229 | 6.4229 | 52.0 |
| 2018-05-10 | CSC | Futures | 3.572 | 3.572 | 3.528 | 3.532 | 65.0 |
| 2018-05-10 | CT | Futures | 97.77 | 97.95 | 95.54 | 96.12 | 21069.0 |
| 2018-05-10 | DC | Futures | 28.64 | 28.75 | 28.3 | 28.34 | 290.0 |
| 2018-05-10 | DX | Futures | 87.716 | 87.74 | 87.136 | 87.255 | 34751.0 |
| 2018-05-10 | E1 | Futures | 1.20129 | 1.20863 | 1.20105 | 1.20514 | 24122.0 |
| 2018-05-10 | E6 | Futures | 1.33878 | 1.34925 | 1.33759 | 1.34694 | 332089.0 |
| 2018-05-10 | E7 | Futures | 1.3315 | 1.3419 | 1.3305 | 1.3398 | 5912.0 |
| 2018-05-10 | EBM | Futures | 181.51 | 182.03 | 180.2 | 180.47 | 10747.0 |
| 2018-05-10 | ED | Futures | 94.9403 | 94.9597 | 94.9403 | 94.95 | 213365.0 |
| 2018-05-10 | ER | Futures | 98.337 | 98.342 | 98.332 | 98.332 | 166971.0 |
| 2018-05-10 | EW | Futures | 2039.3 | 2058.0 | 2037.5 | 2052.1 | 10368.0 |
| 2018-05-10 | FBON | Futures | 129.28 | 129.38 | 129.12 | 129.28 | 379.0 |
| 2018-05-10 | FBTP | Futures | 114.63 | 114.78 | 114.28 | 114.38 | 143269.0 |
| 2018-05-10 | FBTS | Futures | 104.223 | 104.223 | 104.093 | 104.112 | 101077.0 |
| 2018-05-10 | FCE | Futures | 4927.9 | 4932.3 | 4903.8 | 4925.2 | 54229.0 |
| 2018-05-10 | FDAX | Futures | 13501.4 | 13549.7 | 13433.8 | 13533.6 | 74324.0 |
| 2018-05-10 | FDXM | Futures | 13374.5 | 13426.0 | 13314.7 | 13413.1 | 24605.0 |
| 2018-05-10 | FESX | Futures | 2942.2 | 2945.5 | 2922.2 | 2938.9 | 654183.0 |
| 2018-05-10 | FGBL | Futures | 149.48 | 149.86 | 149.45 | 149.69 | 575507.0 |
| 2018-05-10 | FGBM | Futures | 129.64 | 129.8 | 129.62 | 129.71 | 364474.0 |
| 2018-05-10 | FGBS | Futures | 112.512 | 112.537 | 112.507 | 112.532 | 481529.0 |
| 2018-05-10 | FGBX | Futures | 169.21 | 170.12 | 169.04 | 169.66 | 36017.0 |
| 2018-05-10 | FMWO | Futures | 7018.0 | 7067.1 | 7016.9 | 7054.2 | 1813.0 |
| 2018-05-10 | FOAT | Futures | 138.47 | 138.91 | 138.47 | 138.66 | 91126.0 |
| 2018-05-10 | FTDX | Futures | 2752.7 | 2765.6 | 2748.3 | 2762.6 | 103.0 |
| 2018-05-10 | FTI | Futures | 516.95 | 517.92 | 516.67 | 517.41 | 112.0 |
| 2018-05-10 | FTUK | Futures | 6765.9 | 6795.1 | 6720.8 | 6787.5 | 134367.0 |
| 2018-05-10 | FVSA | Futures | 315.72 | 327.2 | 306.53 | 308.83 | 27430.0 |
| 2018-05-10 | FXXP | Futures | 337.1 | 337.6 | 335.2 | 336.8 | 29355.0 |
| 2018-05-10 | G | Futures | 113.58 | 114.01 | 113.38 | 113.87 | 214462.0 |
| 2018-05-10 | GF | Futures | 295.147 | 299.187 | 292.402 | 298.203 | 6391.0 |
| 2018-05-10 | GSCI | Futures | 546.73 | 546.95 | 542.07 | 546.39 | 2466.0 |
| 2018-05-10 | HE | Futures | 80.167 | 81.375 | 79.93 | 81.244 | 26926.0 |
> showing 50 of 112 rows — these rows as CSV