PREVIEW / futures_daily / 2023-01-24
file: by_date/futures_daily/2023/2023-01-24.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-24 | ES | Futures | 4463.21 | 4475.37 | 4428.65 | 4459.06 | 1472856.0 |
| 2023-01-24 | NQ | Futures | 13392.7 | 13479.68 | 13283.56 | 13366.33 | 511370.0 |
| 2023-01-24 | YM | Futures | 36454.2 | 36642.2 | 36175.4 | 36555.8 | 160727.0 |
| 2023-01-24 | CL | Futures | 71.26 | 71.79 | 69.55 | 69.96 | 288207.0 |
| 2023-01-24 | GC | Futures | 2186.4 | 2199.8 | 2170.8 | 2190.3 | 201713.0 |
| 2023-01-24 | ZN | Futures | 117.907878 | 118.293198 | 117.586779 | 118.196868 | 1278470.0 |
| 2023-01-24 | A6 | Futures | 0.71835 | 0.72136 | 0.71472 | 0.72054 | 68613.0 |
| 2023-01-24 | AD | Futures | 0.7591 | 0.76047 | 0.75661 | 0.75955 | 54064.0 |
| 2023-01-24 | ALI | Futures | 2942.25 | 2970.95 | 2932.04 | 2961.02 | 1483.0 |
| 2023-01-24 | B | Futures | 76.75 | 77.28 | 74.92 | 75.22 | 233701.0 |
| 2023-01-24 | B6 | Futures | 1.2491 | 1.2527 | 1.2375 | 1.2449 | 80833.0 |
| 2023-01-24 | BFX | Futures | 4172.6 | 4172.6 | 4172.6 | 4172.6 | 0.0 |
| 2023-01-24 | BR | Futures | 0.17037 | 0.17283 | 0.17024 | 0.17234 | 2799.0 |
| 2023-01-24 | BTC | Futures | 31662.0 | 32004.0 | 31436.3 | 31812.5 | 4435.0 |
| 2023-01-24 | BZ | Futures | 76.44 | 77.03 | 74.67 | 74.99 | 14375.0 |
| 2023-01-24 | C | Futures | 1565.0 | 1579.0 | 1556.0 | 1561.0 | 8480.0 |
| 2023-01-24 | CB | Futures | 231.512 | 233.004 | 231.487 | 231.487 | 25.0 |
| 2023-01-24 | CC | Futures | 1515.0 | 1526.0 | 1503.0 | 1509.0 | 17767.0 |
| 2023-01-24 | CNH | Futures | 6.4142 | 6.4421 | 6.4133 | 6.425 | 672.0 |
| 2023-01-24 | CSC | Futures | 2.422 | 2.446 | 2.389 | 2.4 | 142.0 |
| 2023-01-24 | CT | Futures | 114.5 | 114.5 | 112.29 | 113.09 | 13358.0 |
| 2023-01-24 | DC | Futures | 22.89 | 23.17 | 22.51 | 22.58 | 457.0 |
| 2023-01-24 | DX | Futures | 98.943 | 99.366 | 98.666 | 98.851 | 22219.0 |
| 2023-01-24 | E1 | Futures | 1.18492 | 1.18823 | 1.17709 | 1.18334 | 14524.0 |
| 2023-01-24 | E6 | Futures | 1.12879 | 1.13164 | 1.12512 | 1.13019 | 150809.0 |
| 2023-01-24 | E7 | Futures | 1.1283 | 1.1308 | 1.1244 | 1.1294 | 6545.0 |
| 2023-01-24 | EBM | Futures | 412.51 | 418.79 | 412.51 | 416.58 | 23319.0 |
| 2023-01-24 | ED | Futures | 94.4819 | 94.4868 | 94.4719 | 94.4819 | 40506.0 |
| 2023-01-24 | ER | Futures | 97.675 | 97.685 | 97.66 | 97.685 | 144715.0 |
| 2023-01-24 | ESG | Futures | 382.03 | 383.56 | 379.89 | 381.83 | 308.0 |
| 2023-01-24 | EW | Futures | 2793.8 | 2799.9 | 2770.7 | 2785.7 | 10199.0 |
| 2023-01-24 | FBON | Futures | 124.14 | 124.72 | 123.92 | 124.58 | 72.0 |
| 2023-01-24 | FBTP | Futures | 112.19 | 113.32 | 112.18 | 113.19 | 120151.0 |
| 2023-01-24 | FBTS | Futures | 106.674 | 106.945 | 106.674 | 106.925 | 100205.0 |
| 2023-01-24 | FCE | Futures | 7673.9 | 7690.8 | 7627.7 | 7671.7 | 37169.0 |
| 2023-01-24 | FDAX | Futures | 16403.3 | 16444.3 | 16290.9 | 16378.4 | 45204.0 |
| 2023-01-24 | FDIV | Futures | 180.08 | 180.08 | 179.83 | 179.83 | 2.0 |
| 2023-01-24 | FDXM | Futures | 16306.6 | 16345.2 | 16192.7 | 16279.7 | 49306.0 |
| 2023-01-24 | FDXS | Futures | 16206.4 | 16246.9 | 16093.2 | 16180.7 | 14283.0 |
| 2023-01-24 | FESX | Futures | 4139.6 | 4149.5 | 4112.7 | 4136.6 | 594250.0 |
| 2023-01-24 | FEU3 | Futures | 97.741 | 97.751 | 97.741 | 97.751 | 17.0 |
| 2023-01-24 | FGBL | Futures | 138.16 | 138.77 | 137.82 | 138.61 | 820001.0 |
| 2023-01-24 | FGBM | Futures | 120.39 | 120.66 | 120.26 | 120.6 | 471521.0 |
| 2023-01-24 | FGBS | Futures | 108.307 | 108.445 | 108.292 | 108.425 | 381235.0 |
| 2023-01-24 | FGBX | Futures | 149.47 | 151.64 | 148.98 | 151.23 | 94989.0 |
| 2023-01-24 | FMWO | Futures | 9767.8 | 9771.3 | 9684.2 | 9757.5 | 2020.0 |
| 2023-01-24 | FOAT | Futures | 129.37 | 130.21 | 129.22 | 130.04 | 162108.0 |
| 2023-01-24 | FSMX | Futures | 30631.2 | 30669.4 | 30306.7 | 30470.0 | 620.0 |
| 2023-01-24 | FTDX | Futures | 3436.0 | 3436.0 | 3386.4 | 3395.0 | 13.0 |
| 2023-01-24 | FTI | Futures | 776.69 | 777.21 | 769.39 | 772.94 | 12740.0 |
> showing 50 of 131 rows — these rows as CSV