PREVIEW / futures_daily / 2023-01-18
file: by_date/futures_daily/2023/2023-01-18.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-18 | ES | Futures | 4432.25 | 4459.89 | 4360.65 | 4362.86 | 1902551.0 |
| 2023-01-18 | NQ | Futures | 13041.14 | 13197.98 | 12870.82 | 12879.52 | 619614.0 |
| 2023-01-18 | YM | Futures | 36750.3 | 36885.4 | 36057.6 | 36080.3 | 200014.0 |
| 2023-01-18 | CL | Futures | 71.02 | 72.17 | 69.16 | 69.67 | 326230.0 |
| 2023-01-18 | GC | Futures | 2162.8 | 2183.9 | 2148.6 | 2158.1 | 218967.0 |
| 2023-01-18 | ZN | Futures | 117.715218 | 119.144113 | 117.650998 | 119.095948 | 2306893.0 |
| 2023-01-18 | A6 | Futures | 0.71442 | 0.72207 | 0.70896 | 0.70993 | 115479.0 |
| 2023-01-18 | AD | Futures | 0.75813 | 0.76016 | 0.75174 | 0.75235 | 79097.0 |
| 2023-01-18 | ALI | Futures | 2933.69 | 2998.55 | 2890.36 | 2952.46 | 1592.0 |
| 2023-01-18 | B | Futures | 75.55 | 76.77 | 73.72 | 74.26 | 288148.0 |
| 2023-01-18 | B6 | Futures | 1.2402 | 1.2552 | 1.2368 | 1.2455 | 111967.0 |
| 2023-01-18 | BFX | Futures | 4215.0 | 4215.0 | 4215.0 | 4215.0 | 0.0 |
| 2023-01-18 | BR | Futures | 0.1743 | 0.17493 | 0.17073 | 0.17185 | 254.0 |
| 2023-01-18 | BTC | Futures | 29241.8 | 29886.3 | 28055.6 | 28521.9 | 13106.0 |
| 2023-01-18 | BZ | Futures | 74.98 | 75.95 | 72.98 | 73.48 | 26461.0 |
| 2023-01-18 | C | Futures | 1608.0 | 1614.0 | 1581.0 | 1586.0 | 12249.0 |
| 2023-01-18 | CB | Futures | 234.668 | 234.668 | 230.019 | 230.019 | 115.0 |
| 2023-01-18 | CC | Futures | 1546.0 | 1555.0 | 1527.0 | 1529.0 | 19652.0 |
| 2023-01-18 | CNH | Futures | 6.4084 | 6.4238 | 6.3789 | 6.4063 | 406.0 |
| 2023-01-18 | CSC | Futures | 2.386 | 2.397 | 2.372 | 2.381 | 63.0 |
| 2023-01-18 | CT | Futures | 108.66 | 113.17 | 108.66 | 111.21 | 21390.0 |
| 2023-01-18 | DC | Futures | 22.56 | 22.78 | 22.42 | 22.52 | 326.0 |
| 2023-01-18 | DX | Futures | 99.415 | 99.803 | 98.452 | 99.271 | 40255.0 |
| 2023-01-18 | E1 | Futures | 1.18589 | 1.20312 | 1.18236 | 1.1935 | 27085.0 |
| 2023-01-18 | E6 | Futures | 1.12077 | 1.13107 | 1.11844 | 1.12154 | 248977.0 |
| 2023-01-18 | E7 | Futures | 1.1203 | 1.1303 | 1.1178 | 1.1209 | 10567.0 |
| 2023-01-18 | EBM | Futures | 425.08 | 429.88 | 424.34 | 426.93 | 22269.0 |
| 2023-01-18 | ED | Futures | 94.4719 | 94.5067 | 94.462 | 94.5018 | 120465.0 |
| 2023-01-18 | ER | Futures | 97.736 | 97.756 | 97.706 | 97.746 | 170775.0 |
| 2023-01-18 | ESG | Futures | 379.33 | 381.53 | 373.3 | 373.41 | 531.0 |
| 2023-01-18 | EW | Futures | 2780.0 | 2810.2 | 2744.5 | 2745.7 | 12470.0 |
| 2023-01-18 | FBON | Futures | 126.1 | 126.79 | 125.01 | 126.46 | 265.0 |
| 2023-01-18 | FBTP | Futures | 114.04 | 115.29 | 113.05 | 115.01 | 177151.0 |
| 2023-01-18 | FBTS | Futures | 107.297 | 107.397 | 106.975 | 107.347 | 138036.0 |
| 2023-01-18 | FCE | Futures | 7710.3 | 7746.2 | 7670.7 | 7709.2 | 68361.0 |
| 2023-01-18 | FDAX | Futures | 16447.6 | 16568.6 | 16404.4 | 16477.8 | 51179.0 |
| 2023-01-18 | FDIV | Futures | 180.48 | 180.48 | 180.48 | 180.48 | 0.0 |
| 2023-01-18 | FDXM | Futures | 16347.4 | 16467.7 | 16304.4 | 16378.5 | 50196.0 |
| 2023-01-18 | FDXS | Futures | 16243.7 | 16365.5 | 16206.4 | 16279.0 | 15993.0 |
| 2023-01-18 | FESX | Futures | 4149.5 | 4179.3 | 4129.6 | 4153.5 | 873433.0 |
| 2023-01-18 | FEU3 | Futures | 97.822 | 97.822 | 97.817 | 97.817 | 2.0 |
| 2023-01-18 | FGBL | Futures | 139.41 | 140.96 | 139.25 | 140.58 | 964694.0 |
| 2023-01-18 | FGBM | Futures | 121.18 | 121.61 | 120.98 | 121.47 | 780849.0 |
| 2023-01-18 | FGBS | Futures | 108.594 | 108.691 | 108.486 | 108.614 | 585479.0 |
| 2023-01-18 | FGBX | Futures | 152.25 | 157.59 | 151.97 | 156.49 | 94703.0 |
| 2023-01-18 | FMWO | Futures | 9733.5 | 9759.8 | 9566.3 | 9662.5 | 4540.0 |
| 2023-01-18 | FOAT | Futures | 130.65 | 132.38 | 130.5 | 132.03 | 198908.0 |
| 2023-01-18 | FSMX | Futures | 30649.3 | 30879.5 | 30559.1 | 30707.6 | 292.0 |
| 2023-01-18 | FTDX | Futures | 3450.4 | 3455.2 | 3433.9 | 3433.9 | 17.0 |
| 2023-01-18 | FTI | Futures | 778.94 | 782.75 | 770.69 | 775.99 | 21754.0 |
> showing 50 of 131 rows — these rows as CSV