PREVIEW / futures_daily / 2021-06-23
file: by_date/futures_daily/2021/2021-06-23.parquet size: 10 KB rows: 122
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-06-23 | ES | Futures | 4763.26 | 4775.35 | 4755.39 | 4756.52 | 938299.0 |
| 2021-06-23 | NQ | Futures | 16467.73 | 16515.9 | 16418.99 | 16455.04 | 366489.0 |
| 2021-06-23 | YM | Futures | 36719.4 | 36825.7 | 36597.9 | 36605.5 | 111673.0 |
| 2021-06-23 | CL | Futures | 52.3 | 53.26 | 52.24 | 52.42 | 429207.0 |
| 2021-06-23 | GC | Futures | 2080.9 | 2100.2 | 2073.9 | 2085.9 | 179273.0 |
| 2021-06-23 | ZN | Futures | 133.994015 | 134.073086 | 133.709358 | 133.78843 | 1303395.0 |
| 2021-06-23 | A6 | Futures | 0.7748 | 0.77956 | 0.77326 | 0.7768 | 76427.0 |
| 2021-06-23 | AD | Futures | 0.82386 | 0.82751 | 0.82234 | 0.82391 | 72168.0 |
| 2021-06-23 | ALI | Futures | 2794.84 | 2821.24 | 2790.82 | 2813.2 | 932.0 |
| 2021-06-23 | B | Futures | 48.88 | 49.71 | 48.84 | 49.16 | 229037.0 |
| 2021-06-23 | B6 | Futures | 1.4163 | 1.4219 | 1.414 | 1.418 | 81941.0 |
| 2021-06-23 | BFX | Futures | 4211.2 | 4211.2 | 4201.0 | 4201.0 | 1.0 |
| 2021-06-23 | BR | Futures | 0.15999 | 0.16043 | 0.15959 | 0.15991 | 1016.0 |
| 2021-06-23 | BTC | Futures | 47174.8 | 50471.0 | 46044.7 | 47667.5 | 7184.0 |
| 2021-06-23 | BZ | Futures | 47.73 | 48.52 | 47.71 | 48.0 | 32883.0 |
| 2021-06-23 | C | Futures | 1455.0 | 1455.0 | 1441.0 | 1445.0 | 1979.0 |
| 2021-06-23 | CB | Futures | 144.015 | 144.015 | 142.41 | 142.41 | 32.0 |
| 2021-06-23 | CC | Futures | 1568.0 | 1573.0 | 1545.0 | 1554.0 | 11565.0 |
| 2021-06-23 | CNH | Futures | 6.2851 | 6.2965 | 6.2791 | 6.2823 | 213.0 |
| 2021-06-23 | CSC | Futures | 2.529 | 2.532 | 2.511 | 2.515 | 183.0 |
| 2021-06-23 | CT | Futures | 78.79 | 80.8 | 78.51 | 80.62 | 2443.0 |
| 2021-06-23 | DC | Futures | 23.14 | 23.15 | 22.83 | 22.96 | 214.0 |
| 2021-06-23 | DX | Futures | 88.67 | 88.824 | 88.447 | 88.718 | 18701.0 |
| 2021-06-23 | E1 | Futures | 1.2256 | 1.22931 | 1.22313 | 1.22549 | 19486.0 |
| 2021-06-23 | E6 | Futures | 1.27227 | 1.27536 | 1.26903 | 1.27094 | 157596.0 |
| 2021-06-23 | E7 | Futures | 1.2661 | 1.2689 | 1.2627 | 1.2646 | 4773.0 |
| 2021-06-23 | EBM | Futures | 306.36 | 308.19 | 303.05 | 304.15 | 14909.0 |
| 2021-06-23 | ED | Futures | 96.5345 | 96.5393 | 96.5248 | 96.5297 | 139833.0 |
| 2021-06-23 | ER | Futures | 98.455 | 98.46 | 98.45 | 98.455 | 39305.0 |
| 2021-06-23 | ESG | Futures | 393.41 | 393.96 | 392.59 | 392.63 | 175.0 |
| 2021-06-23 | EW | Futures | 2867.2 | 2883.3 | 2861.1 | 2869.3 | 9129.0 |
| 2021-06-23 | FBON | Futures | 147.59 | 147.97 | 147.51 | 147.61 | 826.0 |
| 2021-06-23 | FBTP | Futures | 137.63 | 138.03 | 137.42 | 137.53 | 107698.0 |
| 2021-06-23 | FBTS | Futures | 110.059 | 110.107 | 110.049 | 110.059 | 66358.0 |
| 2021-06-23 | FCE | Futures | 6585.2 | 6588.2 | 6509.5 | 6515.5 | 51109.0 |
| 2021-06-23 | FDAX | Futures | 16745.5 | 16771.2 | 16532.4 | 16575.2 | 57418.0 |
| 2021-06-23 | FDXM | Futures | 16646.5 | 16688.0 | 16450.3 | 16493.0 | 43407.0 |
| 2021-06-23 | FDXS | Futures | 16549.2 | 16583.1 | 16344.8 | 16388.2 | 4720.0 |
| 2021-06-23 | FESX | Futures | 3898.2 | 3904.8 | 3846.5 | 3856.5 | 580829.0 |
| 2021-06-23 | FGBL | Futures | 166.63 | 167.06 | 166.38 | 166.78 | 687022.0 |
| 2021-06-23 | FGBM | Futures | 134.43 | 134.59 | 134.36 | 134.51 | 403443.0 |
| 2021-06-23 | FGBS | Futures | 112.544 | 112.564 | 112.534 | 112.549 | 269533.0 |
| 2021-06-23 | FGBX | Futures | 216.01 | 217.44 | 215.54 | 216.33 | 73247.0 |
| 2021-06-23 | FMWO | Futures | 10597.7 | 10603.6 | 10557.7 | 10574.2 | 2689.0 |
| 2021-06-23 | FOAT | Futures | 154.47 | 154.88 | 154.32 | 154.63 | 154459.0 |
| 2021-06-23 | FTDX | Futures | 3574.2 | 3581.9 | 3567.0 | 3570.1 | 28.0 |
| 2021-06-23 | FTI | Futures | 693.48 | 696.95 | 689.67 | 689.96 | 15480.0 |
| 2021-06-23 | FTUK | Futures | 6905.0 | 6946.9 | 6885.4 | 6905.0 | 77615.0 |
| 2021-06-23 | FVSA | Futures | 84.81 | 85.96 | 83.44 | 83.66 | 31403.0 |
| 2021-06-23 | FXXP | Futures | 432.2 | 433.5 | 429.1 | 429.8 | 66893.0 |
> showing 50 of 122 rows — these rows as CSV