PREVIEW / futures_daily / 2020-12-29
file: by_date/futures_daily/2020/2020-12-29.parquet size: 10 KB rows: 121
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 |
|---|---|---|---|---|---|---|---|
| 2020-12-29 | ES | Futures | 4181.71 | 4200.49 | 4163.22 | 4169.38 | 992636.0 |
| 2020-12-29 | NQ | Futures | 14815.96 | 14900.16 | 14773.28 | 14811.05 | 393995.0 |
| 2020-12-29 | YM | Futures | 32741.0 | 32939.7 | 32576.9 | 32654.6 | 116977.0 |
| 2020-12-29 | CL | Futures | 33.69 | 34.13 | 33.66 | 33.89 | 213778.0 |
| 2020-12-29 | GC | Futures | 2208.9 | 2224.5 | 2206.1 | 2214.6 | 149267.0 |
| 2020-12-29 | ZN | Futures | 137.227019 | 137.227019 | 137.056068 | 137.180396 | 775267.0 |
| 2020-12-29 | A6 | Futures | 0.77813 | 0.78279 | 0.77802 | 0.78125 | 71979.0 |
| 2020-12-29 | AD | Futures | 0.78841 | 0.79287 | 0.78841 | 0.79085 | 53964.0 |
| 2020-12-29 | ALI | Futures | 2342.98 | 2347.35 | 2341.82 | 2344.73 | 70.0 |
| 2020-12-29 | B | Futures | 32.23 | 32.65 | 32.18 | 32.35 | 196129.0 |
| 2020-12-29 | B6 | Futures | 1.3668 | 1.3742 | 1.3668 | 1.3718 | 76483.0 |
| 2020-12-29 | BR | Futures | 0.14993 | 0.15086 | 0.14981 | 0.15016 | 59.0 |
| 2020-12-29 | BTC | Futures | 35055.8 | 35699.6 | 33917.9 | 35387.5 | 7633.0 |
| 2020-12-29 | BZ | Futures | 31.58 | 31.98 | 31.53 | 31.7 | 18075.0 |
| 2020-12-29 | C | Futures | 1445.0 | 1456.0 | 1425.0 | 1428.0 | 5777.0 |
| 2020-12-29 | CB | Futures | 150.976 | 151.807 | 150.423 | 151.807 | 23.0 |
| 2020-12-29 | CC | Futures | 1680.0 | 1681.0 | 1640.0 | 1648.0 | 14669.0 |
| 2020-12-29 | CNH | Futures | 6.4029 | 6.4029 | 6.3868 | 6.3934 | 695.0 |
| 2020-12-29 | CSC | Futures | 3.172 | 3.188 | 3.172 | 3.183 | 12.0 |
| 2020-12-29 | CT | Futures | 74.1 | 74.64 | 73.78 | 74.4 | 9514.0 |
| 2020-12-29 | DC | Futures | 26.87 | 27.05 | 26.81 | 26.98 | 70.0 |
| 2020-12-29 | DX | Futures | 87.171 | 87.176 | 86.808 | 86.937 | 17249.0 |
| 2020-12-29 | E1 | Futures | 1.27229 | 1.2812 | 1.27229 | 1.27894 | 25078.0 |
| 2020-12-29 | E6 | Futures | 1.30624 | 1.31328 | 1.30618 | 1.31083 | 126668.0 |
| 2020-12-29 | E7 | Futures | 1.2998 | 1.3068 | 1.2997 | 1.3043 | 7747.0 |
| 2020-12-29 | EBM | Futures | 260.08 | 262.23 | 259.46 | 261.31 | 10191.0 |
| 2020-12-29 | ED | Futures | 96.5276 | 96.5276 | 96.5228 | 96.5276 | 52810.0 |
| 2020-12-29 | ER | Futures | 98.46 | 98.465 | 98.455 | 98.455 | 46448.0 |
| 2020-12-29 | ESG | Futures | 347.91 | 347.91 | 345.1 | 345.17 | 128.0 |
| 2020-12-29 | EW | Futures | 2470.9 | 2483.9 | 2427.9 | 2440.5 | 17994.0 |
| 2020-12-29 | FBON | Futures | 150.83 | 150.88 | 150.62 | 150.7 | 88.0 |
| 2020-12-29 | FBTP | Futures | 139.28 | 139.39 | 138.93 | 139.06 | 38726.0 |
| 2020-12-29 | FBTS | Futures | 110.117 | 110.117 | 110.039 | 110.058 | 16524.0 |
| 2020-12-29 | FCE | Futures | 5445.7 | 5459.8 | 5417.0 | 5445.2 | 45483.0 |
| 2020-12-29 | FDAX | Futures | 14706.2 | 14813.9 | 14582.5 | 14672.1 | 37099.0 |
| 2020-12-29 | FDIV | Futures | 165.25 | 165.25 | 164.01 | 164.01 | 110.0 |
| 2020-12-29 | FDXM | Futures | 14659.6 | 14771.3 | 14542.7 | 14630.9 | 23879.0 |
| 2020-12-29 | FESX | Futures | 3313.7 | 3336.0 | 3294.2 | 3316.5 | 459463.0 |
| 2020-12-29 | FEU3 | Futures | 99.208 | 99.208 | 99.203 | 99.208 | 27.0 |
| 2020-12-29 | FGBL | Futures | 170.16 | 170.3 | 170.08 | 170.25 | 264996.0 |
| 2020-12-29 | FGBM | Futures | 135.16 | 135.2 | 135.13 | 135.18 | 164395.0 |
| 2020-12-29 | FGBS | Futures | 112.684 | 112.699 | 112.679 | 112.694 | 131843.0 |
| 2020-12-29 | FGBX | Futures | 235.44 | 236.36 | 235.23 | 236.09 | 30795.0 |
| 2020-12-29 | FMWO | Futures | 9508.6 | 9524.0 | 9454.1 | 9489.6 | 2219.0 |
| 2020-12-29 | FOAT | Futures | 158.83 | 158.92 | 158.68 | 158.86 | 66878.0 |
| 2020-12-29 | FTDX | Futures | 3350.0 | 3368.1 | 3292.8 | 3313.4 | 23.0 |
| 2020-12-29 | FTI | Futures | 587.25 | 591.08 | 584.82 | 587.39 | 16263.0 |
| 2020-12-29 | FTUK | Futures | 6277.5 | 6385.4 | 6267.9 | 6317.9 | 95010.0 |
| 2020-12-29 | FVSA | Futures | 166.09 | 173.64 | 161.56 | 168.36 | 12834.0 |
| 2020-12-29 | FXXP | Futures | 371.8 | 373.9 | 370.8 | 372.7 | 32605.0 |
> showing 50 of 121 rows — these rows as CSV