PREVIEW / futures_daily / 2022-12-20
file: by_date/futures_daily/2022/2022-12-20.parquet size: 10 KB rows: 131
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-20 | ES | Futures | 4248.98 | 4275.24 | 4205.58 | 4256.16 | 1541868.0 |
| 2022-12-20 | NQ | Futures | 12550.4 | 12622.79 | 12394.4 | 12542.82 | 625090.0 |
| 2022-12-20 | YM | Futures | 35609.1 | 35883.6 | 35323.8 | 35720.4 | 156315.0 |
| 2022-12-20 | CL | Futures | 66.16 | 67.2 | 65.01 | 66.56 | 254792.0 |
| 2022-12-20 | GC | Futures | 2033.4 | 2073.7 | 2029.9 | 2065.8 | 197496.0 |
| 2022-12-20 | ZN | Futures | 117.281734 | 117.313844 | 116.430819 | 116.655589 | 1401157.0 |
| 2022-12-20 | A6 | Futures | 0.6857 | 0.69019 | 0.67836 | 0.68346 | 99507.0 |
| 2022-12-20 | AD | Futures | 0.74373 | 0.74763 | 0.74099 | 0.74601 | 72202.0 |
| 2022-12-20 | ALI | Futures | 2658.27 | 2717.03 | 2658.27 | 2669.46 | 1765.0 |
| 2022-12-20 | B | Futures | 70.13 | 70.69 | 68.41 | 69.9 | 183945.0 |
| 2022-12-20 | B6 | Futures | 1.2273 | 1.235 | 1.221 | 1.2295 | 88059.0 |
| 2022-12-20 | BFX | Futures | 3939.8 | 3939.8 | 3939.8 | 3939.8 | 0.0 |
| 2022-12-20 | BR | Futures | 0.16921 | 0.16935 | 0.16921 | 0.16935 | 5.0 |
| 2022-12-20 | BTC | Futures | 22385.6 | 23441.4 | 22317.0 | 23091.7 | 5601.0 |
| 2022-12-20 | BZ | Futures | 69.41 | 69.95 | 67.7 | 69.16 | 19646.0 |
| 2022-12-20 | C | Futures | 1547.0 | 1564.0 | 1541.0 | 1556.0 | 6371.0 |
| 2022-12-20 | CB | Futures | 235.916 | 236.381 | 234.913 | 234.913 | 52.0 |
| 2022-12-20 | CC | Futures | 1457.0 | 1478.0 | 1451.0 | 1458.0 | 19135.0 |
| 2022-12-20 | CNH | Futures | 6.5966 | 6.602 | 6.5622 | 6.5695 | 403.0 |
| 2022-12-20 | CSC | Futures | 2.472 | 2.48 | 2.434 | 2.442 | 222.0 |
| 2022-12-20 | CT | Futures | 110.26 | 115.5 | 109.67 | 115.19 | 16356.0 |
| 2022-12-20 | DC | Futures | 23.63 | 23.75 | 23.24 | 23.24 | 301.0 |
| 2022-12-20 | DX | Futures | 101.471 | 101.515 | 100.528 | 100.728 | 30548.0 |
| 2022-12-20 | E1 | Futures | 1.18117 | 1.18703 | 1.17867 | 1.18448 | 18105.0 |
| 2022-12-20 | E6 | Futures | 1.10498 | 1.11026 | 1.10193 | 1.10643 | 173751.0 |
| 2022-12-20 | E7 | Futures | 1.1043 | 1.1096 | 1.1012 | 1.1058 | 8243.0 |
| 2022-12-20 | EBM | Futures | 440.97 | 441.34 | 435.06 | 438.39 | 14766.0 |
| 2022-12-20 | ED | Futures | 94.452 | 94.452 | 94.4122 | 94.447 | 81973.0 |
| 2022-12-20 | ER | Futures | 97.65 | 97.65 | 97.615 | 97.615 | 100804.0 |
| 2022-12-20 | ESG | Futures | 360.61 | 365.24 | 360.53 | 363.77 | 2865.0 |
| 2022-12-20 | EW | Futures | 2583.4 | 2611.5 | 2556.2 | 2596.9 | 10920.0 |
| 2022-12-20 | FBON | Futures | 120.64 | 121.43 | 120.57 | 120.68 | 454.0 |
| 2022-12-20 | FBTP | Futures | 107.9 | 108.37 | 107.65 | 107.91 | 87863.0 |
| 2022-12-20 | FBTS | Futures | 105.961 | 106.072 | 105.831 | 105.911 | 69565.0 |
| 2022-12-20 | FCE | Futures | 7007.4 | 7073.5 | 6977.3 | 7046.7 | 46065.0 |
| 2022-12-20 | FDAX | Futures | 15120.4 | 15153.9 | 14877.2 | 15065.2 | 51089.0 |
| 2022-12-20 | FDIV | Futures | 161.53 | 161.53 | 161.53 | 161.53 | 0.0 |
| 2022-12-20 | FDXM | Futures | 15028.2 | 15062.5 | 14786.4 | 14974.4 | 41746.0 |
| 2022-12-20 | FDXS | Futures | 14934.7 | 14969.9 | 14698.7 | 14883.4 | 21352.0 |
| 2022-12-20 | FESX | Futures | 3788.8 | 3800.7 | 3729.2 | 3778.9 | 553510.0 |
| 2022-12-20 | FEU3 | Futures | 97.686 | 97.686 | 97.686 | 97.686 | 0.0 |
| 2022-12-20 | FGBL | Futures | 137.48 | 137.5 | 136.05 | 136.18 | 599450.0 |
| 2022-12-20 | FGBM | Futures | 120.22 | 120.22 | 119.61 | 119.66 | 363598.0 |
| 2022-12-20 | FGBS | Futures | 108.445 | 108.455 | 108.297 | 108.317 | 240385.0 |
| 2022-12-20 | FGBX | Futures | 152.91 | 153.11 | 148.2 | 148.9 | 53948.0 |
| 2022-12-20 | FMWO | Futures | 9196.5 | 9233.2 | 9116.4 | 9165.6 | 6783.0 |
| 2022-12-20 | FOAT | Futures | 128.5 | 128.59 | 126.49 | 126.96 | 159569.0 |
| 2022-12-20 | FSMX | Futures | 26404.2 | 26609.9 | 26395.7 | 26547.4 | 465.0 |
| 2022-12-20 | FTDX | Futures | 3114.0 | 3127.9 | 3098.0 | 3103.9 | 87.0 |
| 2022-12-20 | FTI | Futures | 711.75 | 720.94 | 711.7 | 717.71 | 15139.0 |
> showing 50 of 131 rows — these rows as CSV