PREVIEW / futures_daily / 2019-10-28
file: by_date/futures_daily/2019/2019-10-28.parquet size: 10 KB rows: 120
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-10-28 | ES | Futures | 3272.6 | 3293.98 | 3272.33 | 3286.95 | 1041931.0 |
| 2019-10-28 | NQ | Futures | 9274.68 | 9366.3 | 9274.68 | 9328.56 | 309114.0 |
| 2019-10-28 | YM | Futures | 28271.9 | 28470.3 | 28266.7 | 28400.0 | 137575.0 |
| 2019-10-28 | CL | Futures | 57.88 | 58.15 | 56.78 | 57.02 | 437020.0 |
| 2019-10-28 | GC | Futures | 1859.5 | 1863.6 | 1840.8 | 1845.1 | 318126.0 |
| 2019-10-28 | ZN | Futures | 128.412229 | 128.412229 | 127.885759 | 127.99415 | 1104455.0 |
| 2019-10-28 | A6 | Futures | 0.70091 | 0.70337 | 0.69978 | 0.70266 | 51809.0 |
| 2019-10-28 | AD | Futures | 0.77169 | 0.77219 | 0.77048 | 0.77184 | 57961.0 |
| 2019-10-28 | ALI | Futures | 2118.39 | 2121.12 | 2118.39 | 2121.12 | 33.0 |
| 2019-10-28 | B | Futures | 49.26 | 49.52 | 48.58 | 48.85 | 170446.0 |
| 2019-10-28 | B6 | Futures | 1.306 | 1.3113 | 1.3047 | 1.3092 | 72983.0 |
| 2019-10-28 | BR | Futures | 0.20204 | 0.20301 | 0.20087 | 0.20225 | 10389.0 |
| 2019-10-28 | BTC | Futures | 14007.4 | 14512.8 | 13473.1 | 13761.9 | 6474.0 |
| 2019-10-28 | BZ | Futures | 48.54 | 48.82 | 47.92 | 48.19 | 18852.0 |
| 2019-10-28 | C | Futures | 1690.0 | 1696.0 | 1674.0 | 1691.0 | 6927.0 |
| 2019-10-28 | CB | Futures | 244.707 | 245.71 | 244.707 | 245.71 | 2.0 |
| 2019-10-28 | CC | Futures | 1601.0 | 1620.0 | 1588.0 | 1616.0 | 18841.0 |
| 2019-10-28 | CNH | Futures | 7.0418 | 7.0587 | 7.0408 | 7.0542 | 299.0 |
| 2019-10-28 | CSC | Futures | 3.343 | 3.372 | 3.335 | 3.355 | 42.0 |
| 2019-10-28 | CT | Futures | 63.38 | 63.56 | 62.76 | 63.07 | 14899.0 |
| 2019-10-28 | DC | Futures | 27.84 | 28.1 | 27.78 | 27.9 | 335.0 |
| 2019-10-28 | DX | Futures | 94.333 | 94.396 | 94.183 | 94.26 | 7772.0 |
| 2019-10-28 | E1 | Futures | 1.16094 | 1.16105 | 1.15795 | 1.16059 | 18837.0 |
| 2019-10-28 | E6 | Futures | 1.20494 | 1.20775 | 1.20445 | 1.20678 | 95771.0 |
| 2019-10-28 | E7 | Futures | 1.1987 | 1.2014 | 1.198 | 1.2005 | 1682.0 |
| 2019-10-28 | EBM | Futures | 197.28 | 197.28 | 195.91 | 196.19 | 22103.0 |
| 2019-10-28 | ED | Futures | 95.3229 | 95.3229 | 95.3083 | 95.318 | 190576.0 |
| 2019-10-28 | ER | Futures | 98.411 | 98.411 | 98.396 | 98.406 | 64141.0 |
| 2019-10-28 | EW | Futures | 2058.8 | 2080.7 | 2058.3 | 2070.2 | 9164.0 |
| 2019-10-28 | FBON | Futures | 144.68 | 144.72 | 144.2 | 144.28 | 475.0 |
| 2019-10-28 | FBTP | Futures | 130.99 | 131.11 | 130.42 | 130.73 | 93845.0 |
| 2019-10-28 | FBTS | Futures | 108.346 | 108.365 | 108.25 | 108.298 | 33747.0 |
| 2019-10-28 | FCE | Futures | 5197.7 | 5214.5 | 5180.9 | 5199.1 | 57140.0 |
| 2019-10-28 | FDAX | Futures | 13626.3 | 13694.9 | 13589.9 | 13663.7 | 79490.0 |
| 2019-10-28 | FDIV | Futures | 158.71 | 159.27 | 158.66 | 159.13 | 85.0 |
| 2019-10-28 | FDXM | Futures | 13444.2 | 13516.1 | 13413.0 | 13485.3 | 29893.0 |
| 2019-10-28 | FESX | Futures | 3174.6 | 3182.5 | 3161.5 | 3175.5 | 560909.0 |
| 2019-10-28 | FGBL | Futures | 165.44 | 165.53 | 164.76 | 164.9 | 569508.0 |
| 2019-10-28 | FGBM | Futures | 134.03 | 134.08 | 133.86 | 133.93 | 301315.0 |
| 2019-10-28 | FGBS | Futures | 112.754 | 112.759 | 112.724 | 112.734 | 184990.0 |
| 2019-10-28 | FGBX | Futures | 215.67 | 215.9 | 213.28 | 213.62 | 40692.0 |
| 2019-10-28 | FMWO | Futures | 7407.4 | 7447.3 | 7406.3 | 7443.8 | 2578.0 |
| 2019-10-28 | FOAT | Futures | 152.88 | 152.96 | 152.27 | 152.43 | 172771.0 |
| 2019-10-28 | FTDX | Futures | 2781.2 | 2788.1 | 2771.8 | 2787.6 | 128.0 |
| 2019-10-28 | FTI | Futures | 555.85 | 556.61 | 552.75 | 555.06 | 19653.0 |
| 2019-10-28 | FTUK | Futures | 6772.7 | 6788.4 | 6736.1 | 6779.2 | 67356.0 |
| 2019-10-28 | FVSA | Futures | 154.5 | 156.63 | 152.91 | 156.09 | 24969.0 |
| 2019-10-28 | FXXP | Futures | 359.2 | 360.8 | 358.4 | 360.5 | 35537.0 |
| 2019-10-28 | G | Futures | 121.08 | 121.25 | 120.61 | 120.75 | 162145.0 |
| 2019-10-28 | GF | Futures | 304.355 | 305.925 | 302.994 | 305.088 | 1738.0 |
> showing 50 of 120 rows — these rows as CSV