PREVIEW / futures_daily / 2019-06-07
file: by_date/futures_daily/2019/2019-06-07.parquet size: 10 KB rows: 121
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 |
|---|---|---|---|---|---|---|---|
| 2019-06-07 | ES | Futures | 3067.7 | 3117.66 | 3065.54 | 3105.5 | 1687328.0 |
| 2019-06-07 | NQ | Futures | 8372.5 | 8587.38 | 8362.41 | 8548.78 | 484835.0 |
| 2019-06-07 | YM | Futures | 27128.9 | 27534.2 | 27109.9 | 27451.9 | 202194.0 |
| 2019-06-07 | CL | Futures | 54.5 | 55.75 | 54.01 | 55.41 | 828133.0 |
| 2019-06-07 | GC | Futures | 1667.4 | 1683.6 | 1660.7 | 1675.4 | 331289.0 |
| 2019-06-07 | ZN | Futures | 125.963026 | 126.553527 | 125.885329 | 126.196119 | 13638.0 |
| 2019-06-07 | A6 | Futures | 0.71931 | 0.72405 | 0.71797 | 0.72209 | 116184.0 |
| 2019-06-07 | AD | Futures | 0.75676 | 0.76328 | 0.7565 | 0.76191 | 101115.0 |
| 2019-06-07 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-06-07 | B | Futures | 46.45 | 47.33 | 45.98 | 47.11 | 307962.0 |
| 2019-06-07 | B6 | Futures | 1.3008 | 1.3079 | 1.3003 | 1.3055 | 99327.0 |
| 2019-06-07 | BFX | Futures | 4042.6 | 4054.3 | 4042.6 | 4054.3 | 7.0 |
| 2019-06-07 | BR | Futures | 0.20503 | 0.20503 | 0.20503 | 0.20503 | 2.0 |
| 2019-06-07 | BTC | Futures | 11932.1 | 12562.1 | 11893.7 | 12308.6 | 2925.0 |
| 2019-06-07 | BZ | Futures | 45.72 | 46.72 | 45.4 | 46.51 | 44888.0 |
| 2019-06-07 | C | Futures | 1728.0 | 1748.0 | 1719.0 | 1746.0 | 8561.0 |
| 2019-06-07 | CB | Futures | 286.465 | 286.465 | 286.056 | 286.056 | 2.0 |
| 2019-06-07 | CC | Futures | 1620.0 | 1645.0 | 1611.0 | 1643.0 | 36543.0 |
| 2019-06-07 | CNH | Futures | 6.9349 | 6.9715 | 6.9349 | 6.9536 | 1082.0 |
| 2019-06-07 | CSC | Futures | 3.003 | 3.003 | 2.996 | 2.998 | 18.0 |
| 2019-06-07 | CT | Futures | 71.8 | 71.93 | 68.66 | 68.66 | 31251.0 |
| 2019-06-07 | DC | Futures | 25.33 | 25.36 | 25.26 | 25.35 | 55.0 |
| 2019-06-07 | DX | Futures | 92.943 | 93.101 | 92.406 | 92.487 | 29823.0 |
| 2019-06-07 | E1 | Futures | 1.17799 | 1.1843 | 1.17344 | 1.18336 | 38774.0 |
| 2019-06-07 | E6 | Futures | 1.23848 | 1.24622 | 1.23563 | 1.24529 | 252288.0 |
| 2019-06-07 | E7 | Futures | 1.2324 | 1.24 | 1.2295 | 1.2392 | 4374.0 |
| 2019-06-07 | EBM | Futures | 205.84 | 207.28 | 205.55 | 206.13 | 12316.0 |
| 2019-06-07 | ED | Futures | 95.2625 | 95.3113 | 95.26 | 95.2942 | 425836.0 |
| 2019-06-07 | ER | Futures | 98.435 | 98.435 | 98.426 | 98.43 | 87707.0 |
| 2019-06-07 | EW | Futures | 1992.2 | 2016.7 | 1992.1 | 2007.6 | 11311.0 |
| 2019-06-07 | FBON | Futures | 140.66 | 141.54 | 140.61 | 141.36 | 651.0 |
| 2019-06-07 | FBTP | Futures | 116.88 | 118.69 | 116.74 | 117.85 | 127532.0 |
| 2019-06-07 | FBTS | Futures | 106.047 | 106.517 | 106.047 | 106.325 | 100818.0 |
| 2019-06-07 | FCE | Futures | 4792.6 | 4880.2 | 4788.9 | 4856.6 | 90740.0 |
| 2019-06-07 | FDAX | Futures | 12600.1 | 12733.8 | 12591.7 | 12665.9 | 105100.0 |
| 2019-06-07 | FDIV | Futures | 144.75 | 144.75 | 144.51 | 144.51 | 494.0 |
| 2019-06-07 | FDXM | Futures | 12490.9 | 12623.4 | 12484.6 | 12556.1 | 48343.0 |
| 2019-06-07 | FESX | Futures | 2914.7 | 2961.0 | 2913.0 | 2947.0 | 1113388.0 |
| 2019-06-07 | FGBL | Futures | 162.88 | 163.36 | 162.83 | 163.28 | 674789.0 |
| 2019-06-07 | FGBM | Futures | 133.95 | 134.11 | 133.9 | 134.08 | 465116.0 |
| 2019-06-07 | FGBS | Futures | 112.885 | 112.925 | 112.875 | 112.92 | 243806.0 |
| 2019-06-07 | FGBX | Futures | 204.89 | 206.93 | 204.66 | 206.46 | 53532.0 |
| 2019-06-07 | FMWO | Futures | 7091.2 | 7177.9 | 7091.2 | 7155.9 | 5541.0 |
| 2019-06-07 | FOAT | Futures | 149.69 | 150.48 | 149.69 | 150.27 | 169499.0 |
| 2019-06-07 | FTDX | Futures | 2737.3 | 2753.1 | 2730.3 | 2748.1 | 66.0 |
| 2019-06-07 | FTI | Futures | 515.46 | 521.21 | 514.99 | 519.09 | 29659.0 |
| 2019-06-07 | FTUK | Futures | 6666.0 | 6737.1 | 6659.1 | 6716.9 | 95801.0 |
| 2019-06-07 | FVSA | Futures | 223.12 | 224.54 | 217.41 | 221.69 | 34768.0 |
| 2019-06-07 | FXXP | Futures | 334.9 | 338.3 | 334.9 | 337.0 | 62848.0 |
| 2019-06-07 | G | Futures | 119.83 | 120.16 | 119.63 | 120.11 | 172330.0 |
> showing 50 of 121 rows — these rows as CSV