PREVIEW / futures_daily / 2021-11-19
file: by_date/futures_daily/2021/2021-11-19.parquet size: 10 KB rows: 125
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-11-19 | ES | Futures | 5292.9 | 5313.43 | 5269.27 | 5280.8 | 1344893.0 |
| 2021-11-19 | NQ | Futures | 19030.65 | 19175.08 | 19015.66 | 19113.39 | 549031.0 |
| 2021-11-19 | YM | Futures | 38979.9 | 39156.1 | 38609.9 | 38678.5 | 172852.0 |
| 2021-11-19 | CL | Futures | 58.88 | 59.67 | 56.48 | 57.12 | 623448.0 |
| 2021-11-19 | GC | Futures | 2170.9 | 2179.4 | 2151.5 | 2160.2 | 234083.0 |
| 2021-11-19 | ZN | Futures | 132.796215 | 133.479503 | 132.637311 | 133.098133 | 2136578.0 |
| 2021-11-19 | A6 | Futures | 0.74598 | 0.74747 | 0.74086 | 0.74173 | 83206.0 |
| 2021-11-19 | AD | Futures | 0.80547 | 0.80674 | 0.80171 | 0.80186 | 76533.0 |
| 2021-11-19 | ALI | Futures | 3025.59 | 3029.78 | 2982.55 | 3016.65 | 1405.0 |
| 2021-11-19 | B | Futures | 55.37 | 56.22 | 53.35 | 53.93 | 479928.0 |
| 2021-11-19 | B6 | Futures | 1.3703 | 1.3714 | 1.3609 | 1.3651 | 104833.0 |
| 2021-11-19 | BFX | Futures | 4314.1 | 4314.1 | 4310.0 | 4310.0 | 2.0 |
| 2021-11-19 | BR | Futures | 0.14609 | 0.14678 | 0.14435 | 0.14439 | 7076.0 |
| 2021-11-19 | BTC | Futures | 74363.7 | 76945.7 | 73244.0 | 76273.9 | 8253.0 |
| 2021-11-19 | BZ | Futures | 54.08 | 54.89 | 52.1 | 52.66 | 44180.0 |
| 2021-11-19 | C | Futures | 1462.0 | 1462.0 | 1447.0 | 1458.0 | 860.0 |
| 2021-11-19 | CB | Futures | 156.811 | 159.963 | 156.811 | 159.963 | 18.0 |
| 2021-11-19 | CC | Futures | 1622.0 | 1631.0 | 1601.0 | 1625.0 | 15487.0 |
| 2021-11-19 | CNH | Futures | 6.1195 | 6.133 | 6.1191 | 6.1288 | 265.0 |
| 2021-11-19 | CSC | Futures | 2.389 | 2.501 | 2.389 | 2.485 | 244.0 |
| 2021-11-19 | CT | Futures | 109.78 | 112.27 | 109.4 | 111.27 | 4626.0 |
| 2021-11-19 | DC | Futures | 22.82 | 24.06 | 22.82 | 23.95 | 1300.0 |
| 2021-11-19 | DX | Futures | 92.351 | 92.994 | 92.351 | 92.784 | 25091.0 |
| 2021-11-19 | E1 | Futures | 1.21048 | 1.21138 | 1.20623 | 1.20679 | 24471.0 |
| 2021-11-19 | E6 | Futures | 1.20877 | 1.20883 | 1.19571 | 1.1999 | 253560.0 |
| 2021-11-19 | E7 | Futures | 1.2024 | 1.2024 | 1.1893 | 1.1934 | 6149.0 |
| 2021-11-19 | EBM | Futures | 439.41 | 445.65 | 433.16 | 440.51 | 14834.0 |
| 2021-11-19 | ED | Futures | 96.5223 | 96.5271 | 96.5126 | 96.515 | 192690.0 |
| 2021-11-19 | ER | Futures | 98.499 | 98.504 | 98.494 | 98.499 | 50556.0 |
| 2021-11-19 | ESG | Futures | 445.49 | 445.53 | 443.34 | 443.77 | 199.0 |
| 2021-11-19 | EW | Futures | 3102.4 | 3114.8 | 3064.8 | 3087.4 | 12591.0 |
| 2021-11-19 | FBON | Futures | 149.1 | 150.06 | 149.02 | 149.99 | 211.0 |
| 2021-11-19 | FBTP | Futures | 138.44 | 139.31 | 138.3 | 139.23 | 131877.0 |
| 2021-11-19 | FBTS | Futures | 110.458 | 110.574 | 110.419 | 110.545 | 51958.0 |
| 2021-11-19 | FCE | Futures | 7244.1 | 7262.4 | 7143.9 | 7188.0 | 83649.0 |
| 2021-11-19 | FDAX | Futures | 17363.4 | 17416.8 | 17194.5 | 17283.2 | 96307.0 |
| 2021-11-19 | FDIV | Futures | 185.93 | 186.32 | 185.54 | 186.23 | 31.0 |
| 2021-11-19 | FDXM | Futures | 17407.4 | 17467.5 | 17242.4 | 17332.4 | 56781.0 |
| 2021-11-19 | FDXS | Futures | 17247.9 | 17305.3 | 17082.3 | 17171.5 | 38893.0 |
| 2021-11-19 | FESX | Futures | 4199.7 | 4212.6 | 4143.7 | 4170.5 | 1013390.0 |
| 2021-11-19 | FGBL | Futures | 168.68 | 169.87 | 168.47 | 169.77 | 891764.0 |
| 2021-11-19 | FGBM | Futures | 134.88 | 135.38 | 134.8 | 135.31 | 508749.0 |
| 2021-11-19 | FGBS | Futures | 112.82 | 112.905 | 112.795 | 112.885 | 306587.0 |
| 2021-11-19 | FGBX | Futures | 231.24 | 233.55 | 230.47 | 233.14 | 89543.0 |
| 2021-11-19 | FMWO | Futures | 11498.4 | 11523.2 | 11417.1 | 11471.3 | 5913.0 |
| 2021-11-19 | FOAT | Futures | 156.33 | 157.31 | 156.05 | 157.16 | 198878.0 |
| 2021-11-19 | FTDX | Futures | 4038.1 | 4111.5 | 4038.1 | 4090.9 | 244.0 |
| 2021-11-19 | FTI | Futures | 788.91 | 790.06 | 781.85 | 783.77 | 25010.0 |
| 2021-11-19 | FTUK | Futures | 7173.2 | 7198.4 | 7100.1 | 7129.2 | 102159.0 |
| 2021-11-19 | FVSA | Futures | 63.0 | 65.54 | 61.58 | 63.8 | 42606.0 |
> showing 50 of 125 rows — these rows as CSV