PREVIEW / futures_daily / 2023-09-29
file: by_date/futures_daily/2023/2023-09-29.parquet size: 10 KB rows: 130
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-09-29 | ES | Futures | 4647.57 | 4678.88 | 4614.39 | 4629.91 | 2106053.0 |
| 2023-09-29 | NQ | Futures | 16055.02 | 16253.86 | 15984.33 | 16044.23 | 745541.0 |
| 2023-09-29 | YM | Futures | 35716.0 | 35913.9 | 35383.5 | 35490.8 | 241693.0 |
| 2023-09-29 | CL | Futures | 80.9 | 82.09 | 79.66 | 80.05 | 355782.0 |
| 2023-09-29 | GC | Futures | 2026.6 | 2042.2 | 2005.1 | 2009.2 | 245131.0 |
| 2023-09-29 | ZN | Futures | 109.470286 | 109.961397 | 109.311863 | 109.56534 | 2632521.0 |
| 2023-09-29 | A6 | Futures | 0.64962 | 0.65713 | 0.64901 | 0.65073 | 167545.0 |
| 2023-09-29 | AD | Futures | 0.74813 | 0.75221 | 0.74288 | 0.74435 | 143437.0 |
| 2023-09-29 | ALI | Futures | 2520.69 | 2597.21 | 2520.69 | 2586.48 | 828.0 |
| 2023-09-29 | B | Futures | 83.74 | 84.7 | 82.74 | 82.96 | 433926.0 |
| 2023-09-29 | B6 | Futures | 1.2215 | 1.2282 | 1.219 | 1.2215 | 134361.0 |
| 2023-09-29 | BFX | Futures | 3854.9 | 3854.9 | 3854.9 | 3854.9 | 0.0 |
| 2023-09-29 | BR | Futures | 0.18639 | 0.18695 | 0.18592 | 0.18601 | 56.0 |
| 2023-09-29 | BTC | Futures | 36396.5 | 36670.3 | 35788.9 | 36189.5 | 6417.0 |
| 2023-09-29 | BZ | Futures | 83.57 | 84.52 | 82.56 | 82.78 | 47666.0 |
| 2023-09-29 | C | Futures | 2471.0 | 2489.0 | 2439.0 | 2449.0 | 16727.0 |
| 2023-09-29 | CB | Futures | 268.443 | 268.963 | 268.047 | 268.963 | 36.0 |
| 2023-09-29 | CC | Futures | 2017.0 | 2033.0 | 1985.0 | 1994.0 | 25999.0 |
| 2023-09-29 | CNH | Futures | 7.0519 | 7.0557 | 7.0357 | 7.0488 | 504.0 |
| 2023-09-29 | CSC | Futures | 1.989 | 1.999 | 1.989 | 1.994 | 124.0 |
| 2023-09-29 | CT | Futures | 108.3 | 108.87 | 106.1 | 106.26 | 18404.0 |
| 2023-09-29 | DC | Futures | 18.66 | 18.83 | 18.6 | 18.83 | 322.0 |
| 2023-09-29 | DX | Futures | 104.441 | 104.505 | 103.908 | 104.382 | 25038.0 |
| 2023-09-29 | E1 | Futures | 1.15656 | 1.1638 | 1.15456 | 1.15587 | 37290.0 |
| 2023-09-29 | E6 | Futures | 1.07846 | 1.0838 | 1.07775 | 1.07973 | 247199.0 |
| 2023-09-29 | E7 | Futures | 1.0787 | 1.0839 | 1.0779 | 1.08 | 5020.0 |
| 2023-09-29 | EBM | Futures | 329.34 | 330.71 | 322.13 | 323.16 | 41573.0 |
| 2023-09-29 | ER | Futures | 97.756 | 97.777 | 97.751 | 97.771 | 177510.0 |
| 2023-09-29 | ESG | Futures | 402.14 | 404.0 | 398.72 | 399.76 | 1202.0 |
| 2023-09-29 | EW | Futures | 2655.0 | 2672.8 | 2634.8 | 2638.2 | 21003.0 |
| 2023-09-29 | FBON | Futures | 117.18 | 118.31 | 117.17 | 118.09 | 128.0 |
| 2023-09-29 | FBTP | Futures | 107.72 | 108.77 | 107.64 | 108.52 | 250660.0 |
| 2023-09-29 | FBTS | Futures | 105.197 | 105.45 | 105.187 | 105.39 | 181708.0 |
| 2023-09-29 | FCE | Futures | 7682.9 | 7776.0 | 7669.5 | 7699.6 | 71597.0 |
| 2023-09-29 | FDAX | Futures | 16283.3 | 16484.5 | 16247.5 | 16357.0 | 74437.0 |
| 2023-09-29 | FDIV | Futures | 177.25 | 177.25 | 176.45 | 176.45 | 10.0 |
| 2023-09-29 | FDXM | Futures | 16286.4 | 16478.0 | 16241.1 | 16350.6 | 45108.0 |
| 2023-09-29 | FDXS | Futures | 16171.6 | 16369.4 | 16137.1 | 16243.8 | 22920.0 |
| 2023-09-29 | FESX | Futures | 4212.6 | 4270.0 | 4203.6 | 4233.8 | 1140453.0 |
| 2023-09-29 | FEU3 | Futures | 97.766 | 97.766 | 97.766 | 97.766 | 0.0 |
| 2023-09-29 | FGBL | Futures | 129.75 | 130.93 | 129.58 | 130.78 | 1187750.0 |
| 2023-09-29 | FGBM | Futures | 116.47 | 117.12 | 116.4 | 117.08 | 780139.0 |
| 2023-09-29 | FGBS | Futures | 106.887 | 107.04 | 106.872 | 107.035 | 772620.0 |
| 2023-09-29 | FGBX | Futures | 123.92 | 126.1 | 123.45 | 125.5 | 138486.0 |
| 2023-09-29 | FMWO | Futures | 9902.3 | 10003.9 | 9865.9 | 9954.2 | 20388.0 |
| 2023-09-29 | FOAT | Futures | 120.83 | 122.07 | 120.71 | 121.91 | 231767.0 |
| 2023-09-29 | FSMX | Futures | 26867.8 | 27220.1 | 26867.8 | 27002.4 | 408.0 |
| 2023-09-29 | FTDX | Futures | 3164.6 | 3188.5 | 3164.6 | 3167.2 | 29.0 |
| 2023-09-29 | FTI | Futures | 756.35 | 765.74 | 754.74 | 757.86 | 20107.0 |
| 2023-09-29 | FTUK | Futures | 7713.0 | 7780.5 | 7678.8 | 7728.6 | 122742.0 |
> showing 50 of 130 rows — these rows as CSV