PREVIEW / futures_daily / 2021-01-19
file: by_date/futures_daily/2021/2021-01-19.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 |
|---|---|---|---|---|---|---|---|
| 2021-01-19 | ES | Futures | 4203.01 | 4255.69 | 4192.36 | 4248.4 | 1315580.0 |
| 2021-01-19 | NQ | Futures | 14734.06 | 15032.22 | 14679.56 | 14977.72 | 481603.0 |
| 2021-01-19 | YM | Futures | 33075.8 | 33458.1 | 33075.8 | 33291.8 | 191002.0 |
| 2021-01-19 | CL | Futures | 36.72 | 37.56 | 36.59 | 37.42 | 533781.0 |
| 2021-01-19 | GC | Futures | 2151.0 | 2170.1 | 2118.1 | 2164.4 | 331589.0 |
| 2021-01-19 | ZN | Futures | 136.185772 | 136.247936 | 135.921575 | 136.201313 | 1497258.0 |
| 2021-01-19 | A6 | Futures | 0.79049 | 0.79264 | 0.78587 | 0.78961 | 132306.0 |
| 2021-01-19 | AD | Futures | 0.79586 | 0.79672 | 0.7915 | 0.79571 | 85100.0 |
| 2021-01-19 | ALI | Futures | 2277.14 | 2298.7 | 2276.26 | 2298.7 | 119.0 |
| 2021-01-19 | B | Futures | 34.74 | 35.42 | 34.67 | 35.3 | 261102.0 |
| 2021-01-19 | B6 | Futures | 1.3802 | 1.3853 | 1.3733 | 1.3848 | 94679.0 |
| 2021-01-19 | BR | Futures | 0.14661 | 0.14852 | 0.14525 | 0.14571 | 671.0 |
| 2021-01-19 | BTC | Futures | 47144.3 | 49621.8 | 45375.6 | 47593.0 | 14757.0 |
| 2021-01-19 | BZ | Futures | 33.87 | 34.7 | 33.73 | 34.59 | 36910.0 |
| 2021-01-19 | C | Futures | 1497.0 | 1521.0 | 1472.0 | 1508.0 | 10604.0 |
| 2021-01-19 | CB | Futures | 144.655 | 146.731 | 144.655 | 146.731 | 28.0 |
| 2021-01-19 | CC | Futures | 1673.0 | 1712.0 | 1657.0 | 1702.0 | 24116.0 |
| 2021-01-19 | CNH | Futures | 6.3469 | 6.3697 | 6.3381 | 6.3418 | 926.0 |
| 2021-01-19 | CSC | Futures | 3.329 | 3.329 | 3.259 | 3.273 | 104.0 |
| 2021-01-19 | CT | Futures | 78.14 | 79.08 | 78.02 | 78.4 | 16481.0 |
| 2021-01-19 | DC | Futures | 28.74 | 28.81 | 28.08 | 28.25 | 392.0 |
| 2021-01-19 | DX | Futures | 87.693 | 87.736 | 87.383 | 87.476 | 29112.0 |
| 2021-01-19 | E1 | Futures | 1.2689 | 1.27511 | 1.26619 | 1.27206 | 26138.0 |
| 2021-01-19 | E6 | Futures | 1.2915 | 1.29834 | 1.28846 | 1.29631 | 228555.0 |
| 2021-01-19 | E7 | Futures | 1.2849 | 1.2918 | 1.2822 | 1.2899 | 9902.0 |
| 2021-01-19 | EBM | Futures | 293.97 | 296.13 | 289.04 | 290.58 | 46717.0 |
| 2021-01-19 | ED | Futures | 96.5228 | 96.5228 | 96.5131 | 96.5131 | 120279.0 |
| 2021-01-19 | ER | Futures | 98.47 | 98.47 | 98.465 | 98.47 | 18287.0 |
| 2021-01-19 | ESG | Futures | 349.96 | 350.37 | 348.26 | 350.0 | 356.0 |
| 2021-01-19 | EW | Futures | 2594.2 | 2621.5 | 2576.3 | 2612.4 | 14035.0 |
| 2021-01-19 | FBON | Futures | 150.08 | 150.42 | 150.08 | 150.42 | 550.0 |
| 2021-01-19 | FBTP | Futures | 138.38 | 138.89 | 138.19 | 138.87 | 120615.0 |
| 2021-01-19 | FBTS | Futures | 109.874 | 109.952 | 109.845 | 109.952 | 81801.0 |
| 2021-01-19 | FCE | Futures | 5477.8 | 5482.1 | 5422.0 | 5428.7 | 50924.0 |
| 2021-01-19 | FDAX | Futures | 14805.4 | 14873.6 | 14700.9 | 14722.2 | 43197.0 |
| 2021-01-19 | FDIV | Futures | 165.73 | 165.73 | 164.82 | 164.82 | 212.0 |
| 2021-01-19 | FDXM | Futures | 14780.8 | 14829.7 | 14660.7 | 14680.9 | 30160.0 |
| 2021-01-19 | FESX | Futures | 3350.9 | 3363.0 | 3328.6 | 3335.1 | 601945.0 |
| 2021-01-19 | FGBL | Futures | 169.88 | 170.01 | 169.68 | 169.97 | 720922.0 |
| 2021-01-19 | FGBM | Futures | 135.13 | 135.15 | 135.05 | 135.12 | 357837.0 |
| 2021-01-19 | FGBS | Futures | 112.704 | 112.709 | 112.674 | 112.689 | 383289.0 |
| 2021-01-19 | FGBX | Futures | 233.43 | 233.89 | 232.63 | 233.79 | 89795.0 |
| 2021-01-19 | FMWO | Futures | 9615.2 | 9655.5 | 9605.7 | 9614.0 | 2472.0 |
| 2021-01-19 | FOAT | Futures | 158.28 | 158.49 | 158.2 | 158.48 | 208082.0 |
| 2021-01-19 | FTDX | Futures | 3396.4 | 3416.0 | 3396.4 | 3410.3 | 146.0 |
| 2021-01-19 | FTI | Futures | 611.72 | 613.69 | 607.73 | 609.76 | 15160.0 |
| 2021-01-19 | FTUK | Futures | 6452.8 | 6476.8 | 6404.6 | 6420.0 | 81959.0 |
| 2021-01-19 | FVSA | Futures | 160.57 | 162.7 | 158.43 | 161.63 | 26652.0 |
| 2021-01-19 | FXXP | Futures | 379.6 | 381.9 | 377.9 | 378.5 | 50238.0 |
| 2021-01-19 | G | Futures | 126.04 | 126.32 | 126.04 | 126.27 | 258974.0 |
> showing 50 of 120 rows — these rows as CSV