PREVIEW / futures_daily / 2020-12-09
file: by_date/futures_daily/2020/2020-12-09.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 |
|---|---|---|---|---|---|---|---|
| 2020-12-09 | ES | Futures | 4165.59 | 4173.45 | 4111.38 | 4125.98 | 1792176.0 |
| 2020-12-09 | NQ | Futures | 14653.41 | 14673.96 | 14247.63 | 14317.39 | 635769.0 |
| 2020-12-09 | YM | Futures | 32519.2 | 32630.0 | 32239.2 | 32365.2 | 187331.0 |
| 2020-12-09 | CL | Futures | 32.43 | 32.89 | 31.97 | 32.38 | 434976.0 |
| 2020-12-09 | GC | Futures | 2205.8 | 2206.4 | 2150.3 | 2162.4 | 219587.0 |
| 2020-12-09 | ZN | Futures | 136.978363 | 137.009445 | 136.729707 | 136.885117 | 1118052.0 |
| 2020-12-09 | A6 | Futures | 0.76079 | 0.76844 | 0.76017 | 0.76351 | 188584.0 |
| 2020-12-09 | AD | Futures | 0.79054 | 0.79358 | 0.78963 | 0.79054 | 132119.0 |
| 2020-12-09 | ALI | Futures | 2388.62 | 2417.79 | 2388.62 | 2413.96 | 257.0 |
| 2020-12-09 | B | Futures | 30.86 | 31.31 | 30.59 | 30.88 | 267786.0 |
| 2020-12-09 | B6 | Futures | 1.3546 | 1.3667 | 1.3543 | 1.3584 | 153784.0 |
| 2020-12-09 | BR | Futures | 0.15293 | 0.15293 | 0.15012 | 0.15016 | 288.0 |
| 2020-12-09 | BTC | Futures | 24341.8 | 24341.8 | 23065.1 | 23996.6 | 6752.0 |
| 2020-12-09 | BZ | Futures | 30.18 | 30.62 | 29.9 | 30.2 | 36534.0 |
| 2020-12-09 | C | Futures | 1503.0 | 1504.0 | 1474.0 | 1477.0 | 718.0 |
| 2020-12-09 | CB | Futures | 156.883 | 156.883 | 155.498 | 156.883 | 33.0 |
| 2020-12-09 | CC | Futures | 1697.0 | 1717.0 | 1669.0 | 1675.0 | 18301.0 |
| 2020-12-09 | CNH | Futures | 6.3827 | 6.4042 | 6.3633 | 6.3975 | 1644.0 |
| 2020-12-09 | CSC | Futures | 3.047 | 3.061 | 3.038 | 3.054 | 63.0 |
| 2020-12-09 | CT | Futures | 69.56 | 70.74 | 69.43 | 70.58 | 14697.0 |
| 2020-12-09 | DC | Futures | 25.78 | 26.03 | 25.59 | 25.97 | 163.0 |
| 2020-12-09 | DX | Futures | 87.811 | 88.101 | 87.603 | 87.983 | 26091.0 |
| 2020-12-09 | E1 | Futures | 1.27398 | 1.27659 | 1.27036 | 1.27274 | 41827.0 |
| 2020-12-09 | E6 | Futures | 1.29685 | 1.30141 | 1.29182 | 1.29332 | 427302.0 |
| 2020-12-09 | E7 | Futures | 1.2903 | 1.2948 | 1.2852 | 1.2868 | 9451.0 |
| 2020-12-09 | EBM | Futures | 247.75 | 250.21 | 246.82 | 249.91 | 20882.0 |
| 2020-12-09 | ED | Futures | 96.4866 | 96.5059 | 96.4842 | 96.5035 | 426561.0 |
| 2020-12-09 | ER | Futures | 98.475 | 98.48 | 98.47 | 98.48 | 38359.0 |
| 2020-12-09 | ESG | Futures | 342.71 | 343.25 | 338.42 | 339.37 | 1451.0 |
| 2020-12-09 | EW | Futures | 2409.1 | 2420.5 | 2379.4 | 2393.5 | 19795.0 |
| 2020-12-09 | FBON | Futures | 150.78 | 151.01 | 150.72 | 151.01 | 78.0 |
| 2020-12-09 | FBTP | Futures | 138.74 | 138.93 | 138.63 | 138.89 | 81626.0 |
| 2020-12-09 | FBTS | Futures | 110.039 | 110.058 | 110.02 | 110.049 | 36810.0 |
| 2020-12-09 | FCE | Futures | 5453.0 | 5463.2 | 5391.5 | 5409.1 | 53331.0 |
| 2020-12-09 | FDAX | Futures | 14206.7 | 14347.5 | 14158.8 | 14238.2 | 75049.0 |
| 2020-12-09 | FDIV | Futures | 160.52 | 160.52 | 159.81 | 159.81 | 403.0 |
| 2020-12-09 | FDXM | Futures | 14131.9 | 14274.1 | 14087.4 | 14166.4 | 46502.0 |
| 2020-12-09 | FESX | Futures | 3270.9 | 3288.5 | 3247.8 | 3265.3 | 796496.0 |
| 2020-12-09 | FGBL | Futures | 170.62 | 170.83 | 170.46 | 170.72 | 419738.0 |
| 2020-12-09 | FGBM | Futures | 135.48 | 135.56 | 135.45 | 135.53 | 259950.0 |
| 2020-12-09 | FGBS | Futures | 112.835 | 112.84 | 112.82 | 112.83 | 234998.0 |
| 2020-12-09 | FGBX | Futures | 236.24 | 236.8 | 235.23 | 236.38 | 46821.0 |
| 2020-12-09 | FMWO | Futures | 9339.2 | 9361.7 | 9217.2 | 9306.0 | 3831.0 |
| 2020-12-09 | FOAT | Futures | 159.09 | 159.24 | 158.92 | 159.15 | 114175.0 |
| 2020-12-09 | FTDX | Futures | 3225.8 | 3271.0 | 3187.7 | 3211.4 | 24.0 |
| 2020-12-09 | FTI | Futures | 578.5 | 581.3 | 576.07 | 579.08 | 20945.0 |
| 2020-12-09 | FTUK | Futures | 6284.6 | 6322.4 | 6241.2 | 6276.5 | 109260.0 |
| 2020-12-09 | FVSA | Futures | 146.53 | 150.61 | 140.24 | 143.94 | 24727.0 |
| 2020-12-09 | FXXP | Futures | 366.7 | 367.6 | 364.4 | 366.1 | 79999.0 |
| 2020-12-09 | G | Futures | 126.56 | 126.62 | 126.27 | 126.6 | 233674.0 |
> showing 50 of 120 rows — these rows as CSV