PREVIEW / futures_daily / 2021-05-03
file: by_date/futures_daily/2021/2021-05-03.parquet size: 10 KB rows: 113
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 |
|---|---|---|---|---|---|---|---|
| 2021-05-03 | ES | Futures | 4692.29 | 4715.85 | 4691.73 | 4697.06 | 1256240.0 |
| 2021-05-03 | NQ | Futures | 16009.75 | 16087.31 | 15884.89 | 15905.65 | 473913.0 |
| 2021-05-03 | YM | Futures | 36613.3 | 36925.0 | 36607.8 | 36808.1 | 126286.0 |
| 2021-05-03 | CL | Futures | 45.31 | 46.05 | 44.79 | 45.92 | 285969.0 |
| 2021-05-03 | GC | Futures | 2072.8 | 2108.9 | 2069.9 | 2100.6 | 204543.0 |
| 2021-05-03 | ZN | Futures | 132.719966 | 133.1754 | 132.500101 | 133.002649 | 1540326.0 |
| 2021-05-03 | A6 | Futures | 0.79115 | 0.79654 | 0.79028 | 0.79643 | 79541.0 |
| 2021-05-03 | AD | Futures | 0.82478 | 0.82605 | 0.82256 | 0.82549 | 65336.0 |
| 2021-05-03 | ALI | Futures | 2765.78 | 2765.78 | 2765.78 | 2765.78 | 0.0 |
| 2021-05-03 | B | Futures | 43.62 | 44.36 | 43.23 | 44.19 | 148711.0 |
| 2021-05-03 | B6 | Futures | 1.4029 | 1.4149 | 1.4014 | 1.413 | 72450.0 |
| 2021-05-03 | BR | Futures | 0.14589 | 0.14712 | 0.14471 | 0.14597 | 10728.0 |
| 2021-05-03 | BTC | Futures | 78696.5 | 81900.4 | 77861.0 | 79773.7 | 5621.0 |
| 2021-05-03 | BZ | Futures | 42.62 | 43.3 | 42.18 | 43.12 | 17852.0 |
| 2021-05-03 | CB | Futures | 147.301 | 148.003 | 147.074 | 147.28 | 40.0 |
| 2021-05-03 | CC | Futures | 1591.0 | 1607.0 | 1565.0 | 1578.0 | 16051.0 |
| 2021-05-03 | CNH | Futures | 6.2889 | 6.3004 | 6.286 | 6.286 | 596.0 |
| 2021-05-03 | CSC | Futures | 3.019 | 3.04 | 2.998 | 3.005 | 96.0 |
| 2021-05-03 | CT | Futures | 82.43 | 83.21 | 81.59 | 81.92 | 8709.0 |
| 2021-05-03 | DC | Futures | 28.16 | 28.27 | 27.72 | 27.93 | 405.0 |
| 2021-05-03 | DX | Futures | 88.2 | 88.311 | 87.789 | 87.868 | 23126.0 |
| 2021-05-03 | E1 | Futures | 1.23443 | 1.23893 | 1.2315 | 1.23657 | 18866.0 |
| 2021-05-03 | E6 | Futures | 1.28288 | 1.28789 | 1.28112 | 1.28683 | 125856.0 |
| 2021-05-03 | E7 | Futures | 1.2759 | 1.2813 | 1.2746 | 1.2804 | 3587.0 |
| 2021-05-03 | EBM | Futures | 330.79 | 334.3 | 306.84 | 310.99 | 7359.0 |
| 2021-05-03 | ED | Futures | 96.4932 | 96.498 | 96.4835 | 96.4932 | 101113.0 |
| 2021-05-03 | ER | Futures | 98.455 | 98.46 | 98.45 | 98.455 | 42030.0 |
| 2021-05-03 | ESG | Futures | 390.11 | 390.59 | 388.71 | 389.04 | 583.0 |
| 2021-05-03 | EW | Futures | 2926.5 | 2947.9 | 2919.9 | 2927.8 | 9727.0 |
| 2021-05-03 | FBON | Futures | 147.1 | 147.33 | 146.61 | 147.24 | 540.0 |
| 2021-05-03 | FBTP | Futures | 137.03 | 137.49 | 136.62 | 137.34 | 131034.0 |
| 2021-05-03 | FBTS | Futures | 109.991 | 110.059 | 109.942 | 110.03 | 81625.0 |
| 2021-05-03 | FCE | Futures | 6144.9 | 6189.8 | 6120.7 | 6176.5 | 35944.0 |
| 2021-05-03 | FDAX | Futures | 16191.2 | 16289.3 | 16114.5 | 16242.4 | 51224.0 |
| 2021-05-03 | FDIV | Futures | 182.84 | 183.04 | 182.84 | 183.04 | 30.0 |
| 2021-05-03 | FDXM | Futures | 16164.1 | 16269.5 | 16095.9 | 16222.6 | 50233.0 |
| 2021-05-03 | FDXS | Futures | 16076.8 | 16181.7 | 16009.1 | 16136.1 | 2072.0 |
| 2021-05-03 | FESX | Futures | 3732.7 | 3758.2 | 3712.9 | 3744.1 | 554026.0 |
| 2021-05-03 | FGBL | Futures | 166.2 | 166.55 | 165.7 | 166.37 | 611314.0 |
| 2021-05-03 | FGBM | Futures | 134.47 | 134.57 | 134.3 | 134.54 | 366289.0 |
| 2021-05-03 | FGBS | Futures | 112.634 | 112.634 | 112.604 | 112.624 | 238471.0 |
| 2021-05-03 | FGBX | Futures | 213.82 | 215.2 | 212.78 | 214.5 | 63576.0 |
| 2021-05-03 | FOAT | Futures | 154.34 | 154.77 | 153.94 | 154.59 | 167226.0 |
| 2021-05-03 | FTI | Futures | 669.84 | 674.21 | 666.66 | 672.59 | 15215.0 |
| 2021-05-03 | GF | Futures | 237.181 | 240.324 | 234.981 | 238.977 | 1868.0 |
| 2021-05-03 | GSCI | Futures | 469.73 | 473.8 | 469.73 | 472.97 | 79.0 |
| 2021-05-03 | HE | Futures | 82.084 | 83.693 | 81.992 | 83.304 | 25301.0 |
| 2021-05-03 | HG | Futures | 4.9057 | 4.9865 | 4.876 | 4.9788 | 40973.0 |
| 2021-05-03 | HH | Futures | 9.333 | 9.387 | 9.175 | 9.383 | 2345.0 |
| 2021-05-03 | HO | Futures | 1.0361 | 1.0591 | 1.0303 | 1.0542 | 46033.0 |
> showing 50 of 113 rows — these rows as CSV