PREVIEW / futures_daily / 2023-01-17
file: by_date/futures_daily/2023/2023-01-17.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-17 | ES | Futures | 4444.96 | 4461.83 | 4419.26 | 4433.35 | 1423931.0 |
| 2023-01-17 | NQ | Futures | 13034.12 | 13114.37 | 12918.24 | 13046.47 | 576141.0 |
| 2023-01-17 | YM | Futures | 37215.0 | 37272.3 | 36711.4 | 36765.4 | 189736.0 |
| 2023-01-17 | CL | Futures | 70.15 | 71.17 | 68.8 | 70.24 | 267914.0 |
| 2023-01-17 | GC | Futures | 2177.2 | 2186.2 | 2157.2 | 2161.4 | 268368.0 |
| 2023-01-17 | ZN | Futures | 117.956043 | 118.084483 | 117.442284 | 117.827603 | 1568077.0 |
| 2023-01-17 | A6 | Futures | 0.71299 | 0.71758 | 0.7085 | 0.71447 | 110563.0 |
| 2023-01-17 | AD | Futures | 0.75773 | 0.76011 | 0.75534 | 0.75829 | 82492.0 |
| 2023-01-17 | ALI | Futures | 2911.89 | 2938.38 | 2892.02 | 2933.69 | 806.0 |
| 2023-01-17 | B | Futures | 73.58 | 75.87 | 73.44 | 75.08 | 238298.0 |
| 2023-01-17 | B6 | Futures | 1.2339 | 1.2416 | 1.2283 | 1.2389 | 150748.0 |
| 2023-01-17 | BFX | Futures | 4251.4 | 4251.4 | 4251.4 | 4251.4 | 0.0 |
| 2023-01-17 | BR | Futures | 0.17337 | 0.17381 | 0.17171 | 0.17354 | 233.0 |
| 2023-01-17 | BTC | Futures | 28775.6 | 29790.3 | 28371.0 | 29461.2 | 12709.0 |
| 2023-01-17 | BZ | Futures | 73.88 | 75.07 | 72.51 | 74.29 | 36658.0 |
| 2023-01-17 | C | Futures | 1608.0 | 1623.0 | 1597.0 | 1608.0 | 9705.0 |
| 2023-01-17 | CB | Futures | 235.892 | 235.892 | 234.57 | 234.668 | 15.0 |
| 2023-01-17 | CC | Futures | 1542.0 | 1561.0 | 1530.0 | 1541.0 | 23486.0 |
| 2023-01-17 | CNH | Futures | 6.33 | 6.4237 | 6.2759 | 6.4084 | 2487.0 |
| 2023-01-17 | CSC | Futures | 2.381 | 2.409 | 2.372 | 2.381 | 91.0 |
| 2023-01-17 | CT | Futures | 108.05 | 109.13 | 107.49 | 108.6 | 14294.0 |
| 2023-01-17 | DC | Futures | 22.77 | 22.91 | 22.51 | 22.55 | 200.0 |
| 2023-01-17 | DX | Futures | 99.21 | 99.483 | 98.856 | 99.304 | 27427.0 |
| 2023-01-17 | E1 | Futures | 1.17937 | 1.18997 | 1.17704 | 1.18562 | 29395.0 |
| 2023-01-17 | E6 | Futures | 1.12584 | 1.12988 | 1.11937 | 1.12129 | 286676.0 |
| 2023-01-17 | E7 | Futures | 1.1242 | 1.1291 | 1.1188 | 1.1205 | 11414.0 |
| 2023-01-17 | EBM | Futures | 422.86 | 424.34 | 417.32 | 423.97 | 32668.0 |
| 2023-01-17 | ED | Futures | 94.4819 | 94.4918 | 94.462 | 94.4819 | 111210.0 |
| 2023-01-17 | ER | Futures | 97.685 | 97.806 | 97.665 | 97.756 | 234503.0 |
| 2023-01-17 | ESG | Futures | 378.96 | 381.36 | 378.79 | 379.33 | 525.0 |
| 2023-01-17 | EW | Futures | 2790.8 | 2800.7 | 2775.8 | 2781.9 | 10572.0 |
| 2023-01-17 | FBON | Futures | 124.03 | 125.4 | 123.71 | 125.26 | 265.0 |
| 2023-01-17 | FBTP | Futures | 112.07 | 113.83 | 111.67 | 113.49 | 161904.0 |
| 2023-01-17 | FBTS | Futures | 106.724 | 107.237 | 106.634 | 107.176 | 111350.0 |
| 2023-01-17 | FCE | Futures | 7655.4 | 7734.8 | 7641.9 | 7703.8 | 51046.0 |
| 2023-01-17 | FDAX | Futures | 16416.2 | 16570.8 | 16363.3 | 16468.1 | 51389.0 |
| 2023-01-17 | FDIV | Futures | 179.63 | 180.57 | 179.63 | 180.57 | 12.0 |
| 2023-01-17 | FDXM | Futures | 16317.3 | 16470.9 | 16264.7 | 16368.9 | 51329.0 |
| 2023-01-17 | FDXS | Futures | 16224.5 | 16370.8 | 16165.8 | 16269.4 | 20696.0 |
| 2023-01-17 | FESX | Futures | 4138.6 | 4174.3 | 4121.7 | 4150.5 | 790296.0 |
| 2023-01-17 | FEU3 | Futures | 97.741 | 97.822 | 97.741 | 97.822 | 6.0 |
| 2023-01-17 | FGBL | Futures | 138.5 | 139.8 | 137.94 | 139.54 | 955713.0 |
| 2023-01-17 | FGBM | Futures | 120.65 | 121.38 | 120.42 | 121.25 | 739948.0 |
| 2023-01-17 | FGBS | Futures | 108.43 | 108.629 | 108.297 | 108.599 | 486121.0 |
| 2023-01-17 | FGBX | Futures | 150.64 | 153.09 | 149.57 | 152.56 | 66990.0 |
| 2023-01-17 | FMWO | Futures | 9676.2 | 9738.1 | 9654.5 | 9686.5 | 2978.0 |
| 2023-01-17 | FOAT | Futures | 129.61 | 130.97 | 129.13 | 130.77 | 181821.0 |
| 2023-01-17 | FSMX | Futures | 30440.3 | 30562.3 | 30263.2 | 30420.2 | 266.0 |
| 2023-01-17 | FTDX | Futures | 3415.7 | 3437.1 | 3414.1 | 3437.1 | 27.0 |
| 2023-01-17 | FTI | Futures | 773.79 | 778.77 | 769.39 | 775.71 | 14547.0 |
> showing 50 of 131 rows — these rows as CSV