PREVIEW / futures_daily / 2023-01-23
file: by_date/futures_daily/2023/2023-01-23.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-23 | ES | Futures | 4408.47 | 4485.6 | 4401.01 | 4463.21 | 1594736.0 |
| 2023-01-23 | NQ | Futures | 13105.11 | 13448.82 | 13075.65 | 13393.83 | 593978.0 |
| 2023-01-23 | YM | Futures | 36172.1 | 36619.5 | 36097.6 | 36448.8 | 176738.0 |
| 2023-01-23 | CL | Futures | 71.41 | 72.15 | 70.77 | 71.26 | 297076.0 |
| 2023-01-23 | GC | Futures | 2182.4 | 2191.8 | 2164.4 | 2182.6 | 190094.0 |
| 2023-01-23 | ZN | Futures | 118.196868 | 118.389528 | 117.747328 | 117.843658 | 1053149.0 |
| 2023-01-23 | A6 | Futures | 0.71258 | 0.71952 | 0.71156 | 0.71748 | 80791.0 |
| 2023-01-23 | AD | Futures | 0.75859 | 0.76067 | 0.75641 | 0.75798 | 52596.0 |
| 2023-01-23 | ALI | Futures | 2903.06 | 2954.12 | 2901.95 | 2949.15 | 1005.0 |
| 2023-01-23 | B | Futures | 76.58 | 77.62 | 75.89 | 76.89 | 201595.0 |
| 2023-01-23 | B6 | Futures | 1.2516 | 1.2562 | 1.2436 | 1.2477 | 67030.0 |
| 2023-01-23 | BFX | Futures | 4180.6 | 4180.6 | 4180.6 | 4180.6 | 0.0 |
| 2023-01-23 | BR | Futures | 0.17055 | 0.17185 | 0.17024 | 0.171 | 1200.0 |
| 2023-01-23 | BTC | Futures | 30997.0 | 31867.7 | 30969.5 | 31662.0 | 10731.0 |
| 2023-01-23 | BZ | Futures | 75.77 | 77.39 | 75.66 | 76.65 | 12979.0 |
| 2023-01-23 | C | Futures | 1543.0 | 1578.0 | 1540.0 | 1568.0 | 13751.0 |
| 2023-01-23 | CB | Futures | 230.998 | 231.022 | 230.998 | 231.022 | 15.0 |
| 2023-01-23 | CC | Futures | 1502.0 | 1532.0 | 1496.0 | 1522.0 | 25402.0 |
| 2023-01-23 | CNH | Futures | 6.4104 | 6.4299 | 6.4058 | 6.4237 | 121.0 |
| 2023-01-23 | CSC | Futures | 2.371 | 2.428 | 2.351 | 2.41 | 154.0 |
| 2023-01-23 | CT | Futures | 113.69 | 116.29 | 112.51 | 114.6 | 22806.0 |
| 2023-01-23 | DC | Futures | 22.34 | 23.02 | 22.16 | 22.67 | 333.0 |
| 2023-01-23 | DX | Futures | 98.894 | 99.206 | 98.53 | 99.085 | 21423.0 |
| 2023-01-23 | E1 | Futures | 1.18801 | 1.19263 | 1.18193 | 1.18399 | 15647.0 |
| 2023-01-23 | E6 | Futures | 1.12827 | 1.13469 | 1.12636 | 1.12755 | 176164.0 |
| 2023-01-23 | E7 | Futures | 1.1275 | 1.134 | 1.1256 | 1.1269 | 6730.0 |
| 2023-01-23 | EBM | Futures | 418.79 | 419.53 | 412.14 | 412.88 | 29467.0 |
| 2023-01-23 | ED | Futures | 94.4769 | 94.4868 | 94.4719 | 94.4719 | 42297.0 |
| 2023-01-23 | ER | Futures | 97.685 | 97.691 | 97.67 | 97.68 | 107760.0 |
| 2023-01-23 | ESG | Futures | 377.58 | 384.08 | 377.17 | 382.48 | 1306.0 |
| 2023-01-23 | EW | Futures | 2760.2 | 2804.9 | 2753.1 | 2795.4 | 10507.0 |
| 2023-01-23 | FBON | Futures | 124.45 | 124.56 | 123.9 | 124.25 | 108.0 |
| 2023-01-23 | FBTP | Futures | 112.64 | 112.93 | 111.93 | 112.4 | 102920.0 |
| 2023-01-23 | FBTS | Futures | 106.765 | 106.845 | 106.654 | 106.744 | 111105.0 |
| 2023-01-23 | FCE | Futures | 7637.0 | 7673.4 | 7602.7 | 7651.6 | 40545.0 |
| 2023-01-23 | FDAX | Futures | 16364.4 | 16437.9 | 16288.7 | 16384.9 | 43928.0 |
| 2023-01-23 | FDIV | Futures | 179.34 | 179.34 | 179.34 | 179.34 | 0.0 |
| 2023-01-23 | FDXM | Futures | 16269.0 | 16332.3 | 16193.8 | 16286.1 | 48450.0 |
| 2023-01-23 | FDXS | Futures | 16151.9 | 16232.0 | 16095.3 | 16187.2 | 16996.0 |
| 2023-01-23 | FESX | Futures | 4113.7 | 4144.5 | 4102.8 | 4133.6 | 550944.0 |
| 2023-01-23 | FEU3 | Futures | 97.746 | 97.746 | 97.746 | 97.746 | 40.0 |
| 2023-01-23 | FGBL | Futures | 138.44 | 138.72 | 137.94 | 138.25 | 617044.0 |
| 2023-01-23 | FGBM | Futures | 120.49 | 120.65 | 120.26 | 120.43 | 384892.0 |
| 2023-01-23 | FGBS | Futures | 108.358 | 108.409 | 108.286 | 108.353 | 326989.0 |
| 2023-01-23 | FGBX | Futures | 150.45 | 151.11 | 148.88 | 149.78 | 64529.0 |
| 2023-01-23 | FMWO | Futures | 9667.1 | 9779.3 | 9649.9 | 9757.5 | 2639.0 |
| 2023-01-23 | FOAT | Futures | 129.85 | 130.06 | 129.19 | 129.55 | 133567.0 |
| 2023-01-23 | FSMX | Futures | 30687.5 | 30702.3 | 30430.8 | 30515.6 | 286.0 |
| 2023-01-23 | FTDX | Futures | 3410.9 | 3424.8 | 3387.0 | 3422.1 | 30.0 |
| 2023-01-23 | FTI | Futures | 769.29 | 776.8 | 766.08 | 774.43 | 15639.0 |
> showing 50 of 131 rows — these rows as CSV