PREVIEW / futures_daily / 2023-01-31
file: by_date/futures_daily/2023/2023-01-31.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 |
|---|---|---|---|---|---|---|---|
| 2023-01-31 | ES | Futures | 4466.25 | 4523.75 | 4431.14 | 4522.36 | 1790751.0 |
| 2023-01-31 | NQ | Futures | 13449.94 | 13642.98 | 13323.12 | 13638.49 | 585202.0 |
| 2023-01-31 | YM | Futures | 36548.2 | 36923.2 | 36288.9 | 36912.4 | 147863.0 |
| 2023-01-31 | CL | Futures | 68.02 | 69.19 | 66.84 | 68.86 | 312734.0 |
| 2023-01-31 | GC | Futures | 2168.9 | 2178.2 | 2143.1 | 2176.4 | 194077.0 |
| 2023-01-31 | ZN | Futures | 117.554669 | 117.972098 | 117.442284 | 117.667053 | 2074922.0 |
| 2023-01-31 | A6 | Futures | 0.7211 | 0.72187 | 0.7136 | 0.72064 | 83660.0 |
| 2023-01-31 | AD | Futures | 0.75829 | 0.76311 | 0.75332 | 0.7627 | 104053.0 |
| 2023-01-31 | ALI | Futures | 2865.52 | 2941.14 | 2846.47 | 2936.73 | 1036.0 |
| 2023-01-31 | B | Futures | 73.8 | 74.82 | 72.53 | 74.54 | 327095.0 |
| 2023-01-31 | B6 | Futures | 1.2464 | 1.2481 | 1.2394 | 1.2432 | 80269.0 |
| 2023-01-31 | BFX | Futures | 4147.9 | 4147.9 | 4147.9 | 4147.9 | 0.0 |
| 2023-01-31 | BR | Futures | 0.17413 | 0.17546 | 0.17292 | 0.17502 | 6371.0 |
| 2023-01-31 | BTC | Futures | 31285.8 | 32024.5 | 31258.5 | 31805.7 | 3489.0 |
| 2023-01-31 | BZ | Futures | 73.54 | 74.58 | 72.29 | 74.3 | 30498.0 |
| 2023-01-31 | C | Futures | 1598.0 | 1600.0 | 1579.0 | 1585.0 | 4201.0 |
| 2023-01-31 | CB | Futures | 233.2 | 233.2 | 232.001 | 232.001 | 28.0 |
| 2023-01-31 | CC | Futures | 1521.0 | 1521.0 | 1500.0 | 1506.0 | 26849.0 |
| 2023-01-31 | CNH | Futures | 6.4013 | 6.4079 | 6.3927 | 6.3976 | 617.0 |
| 2023-01-31 | CSC | Futures | 2.349 | 2.349 | 2.318 | 2.332 | 192.0 |
| 2023-01-31 | CT | Futures | 111.86 | 113.89 | 111.48 | 113.06 | 22411.0 |
| 2023-01-31 | DC | Futures | 22.05 | 22.09 | 21.62 | 21.78 | 675.0 |
| 2023-01-31 | DX | Futures | 99.181 | 99.604 | 98.997 | 99.084 | 31110.0 |
| 2023-01-31 | E1 | Futures | 1.17975 | 1.19279 | 1.17503 | 1.19192 | 27722.0 |
| 2023-01-31 | E6 | Futures | 1.12631 | 1.12869 | 1.12103 | 1.12744 | 186452.0 |
| 2023-01-31 | E7 | Futures | 1.1255 | 1.1279 | 1.1203 | 1.1268 | 6091.0 |
| 2023-01-31 | EBM | Futures | 423.97 | 427.3 | 421.38 | 425.45 | 15440.0 |
| 2023-01-31 | ED | Futures | 94.5117 | 94.5415 | 94.5067 | 94.5266 | 64409.0 |
| 2023-01-31 | ER | Futures | 97.675 | 97.691 | 97.665 | 97.685 | 129087.0 |
| 2023-01-31 | ESG | Futures | 382.12 | 387.19 | 379.57 | 387.0 | 544.0 |
| 2023-01-31 | EW | Futures | 2802.4 | 2862.9 | 2782.5 | 2861.5 | 14645.0 |
| 2023-01-31 | FBON | Futures | 122.45 | 122.99 | 122.29 | 122.72 | 148.0 |
| 2023-01-31 | FBTP | Futures | 110.97 | 111.63 | 110.82 | 111.19 | 198092.0 |
| 2023-01-31 | FBTS | Futures | 106.453 | 106.734 | 106.383 | 106.514 | 151253.0 |
| 2023-01-31 | FCE | Futures | 7677.7 | 7746.7 | 7641.3 | 7704.3 | 50442.0 |
| 2023-01-31 | FDAX | Futures | 16389.2 | 16474.6 | 16253.0 | 16400.0 | 62462.0 |
| 2023-01-31 | FDIV | Futures | 179.04 | 180.43 | 178.89 | 180.43 | 20.0 |
| 2023-01-31 | FDXM | Futures | 16295.8 | 16374.2 | 16156.2 | 16301.2 | 65424.0 |
| 2023-01-31 | FDXS | Futures | 16192.5 | 16270.4 | 16058.0 | 16202.1 | 18180.0 |
| 2023-01-31 | FESX | Futures | 4133.6 | 4165.4 | 4103.8 | 4144.5 | 834537.0 |
| 2023-01-31 | FEU3 | Futures | 97.741 | 97.751 | 97.741 | 97.751 | 6.0 |
| 2023-01-31 | FGBL | Futures | 136.94 | 137.58 | 136.77 | 137.1 | 892397.0 |
| 2023-01-31 | FGBM | Futures | 119.88 | 120.2 | 119.79 | 120.05 | 770435.0 |
| 2023-01-31 | FGBS | Futures | 108.215 | 108.317 | 108.194 | 108.271 | 580195.0 |
| 2023-01-31 | FGBX | Futures | 147.4 | 148.86 | 146.36 | 147.32 | 102228.0 |
| 2023-01-31 | FMWO | Futures | 9762.1 | 9865.1 | 9675.1 | 9793.0 | 6534.0 |
| 2023-01-31 | FOAT | Futures | 128.1 | 128.71 | 127.91 | 128.29 | 215636.0 |
| 2023-01-31 | FSMX | Futures | 30528.3 | 30708.7 | 30453.0 | 30606.8 | 1166.0 |
| 2023-01-31 | FTDX | Futures | 3396.6 | 3405.6 | 3376.3 | 3397.6 | 11.0 |
| 2023-01-31 | FTI | Futures | 768.05 | 775.71 | 762.56 | 771.44 | 17456.0 |
> showing 50 of 131 rows — these rows as CSV