PREVIEW / futures_daily / 2023-10-26
file: by_date/futures_daily/2023/2023-10-26.parquet size: 10 KB rows: 129
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-10-26 | ES | Futures | 4497.72 | 4500.93 | 4438.04 | 4449.02 | 2419407.0 |
| 2023-10-26 | NQ | Futures | 15567.75 | 15604.44 | 15260.44 | 15318.45 | 987597.0 |
| 2023-10-26 | YM | Futures | 34897.3 | 34942.5 | 34551.1 | 34597.4 | 246580.0 |
| 2023-10-26 | CL | Futures | 76.42 | 76.62 | 73.9 | 74.49 | 341792.0 |
| 2023-10-26 | GC | Futures | 2143.9 | 2157.4 | 2133.6 | 2150.6 | 214053.0 |
| 2023-10-26 | ZN | Futures | 107.125626 | 107.886056 | 106.935518 | 107.822687 | 2427261.0 |
| 2023-10-26 | A6 | Futures | 0.63707 | 0.63934 | 0.63314 | 0.63903 | 156972.0 |
| 2023-10-26 | AD | Futures | 0.73124 | 0.73159 | 0.72872 | 0.73023 | 94533.0 |
| 2023-10-26 | ALI | Futures | 2424.58 | 2438.55 | 2402.94 | 2407.32 | 1983.0 |
| 2023-10-26 | B | Futures | 80.76 | 81.16 | 78.64 | 79.14 | 358872.0 |
| 2023-10-26 | B6 | Futures | 1.2119 | 1.2148 | 1.2077 | 1.2144 | 93204.0 |
| 2023-10-26 | BR | Futures | 0.18733 | 0.18804 | 0.18695 | 0.18785 | 15595.0 |
| 2023-10-26 | BTC | Futures | 45886.0 | 46331.7 | 44765.3 | 44968.4 | 11346.0 |
| 2023-10-26 | BZ | Futures | 80.51 | 80.76 | 78.29 | 78.78 | 25159.0 |
| 2023-10-26 | C | Futures | 2755.0 | 2814.0 | 2750.0 | 2797.0 | 8126.0 |
| 2023-10-26 | CB | Futures | 270.424 | 270.424 | 262.5 | 265.67 | 33.0 |
| 2023-10-26 | CC | Futures | 2181.0 | 2239.0 | 2177.0 | 2223.0 | 22206.0 |
| 2023-10-26 | CNH | Futures | 7.09 | 7.09 | 7.0798 | 7.0803 | 586.0 |
| 2023-10-26 | CSC | Futures | 1.961 | 1.964 | 1.946 | 1.964 | 196.0 |
| 2023-10-26 | CT | Futures | 102.12 | 103.88 | 101.82 | 103.14 | 19467.0 |
| 2023-10-26 | DC | Futures | 18.64 | 18.95 | 18.46 | 18.74 | 830.0 |
| 2023-10-26 | DX | Futures | 104.959 | 105.334 | 104.92 | 104.981 | 16599.0 |
| 2023-10-26 | E1 | Futures | 1.17649 | 1.17691 | 1.17151 | 1.17345 | 20561.0 |
| 2023-10-26 | E6 | Futures | 1.07744 | 1.07755 | 1.07261 | 1.07668 | 206007.0 |
| 2023-10-26 | E7 | Futures | 1.0775 | 1.0777 | 1.0729 | 1.0769 | 4349.0 |
| 2023-10-26 | EBM | Futures | 318.7 | 324.19 | 318.36 | 320.42 | 38364.0 |
| 2023-10-26 | ER | Futures | 97.777 | 97.797 | 97.761 | 97.797 | 172445.0 |
| 2023-10-26 | ESG | Futures | 387.14 | 390.06 | 384.36 | 385.01 | 1467.0 |
| 2023-10-26 | EW | Futures | 2469.8 | 2497.5 | 2450.1 | 2477.7 | 15599.0 |
| 2023-10-26 | FBON | Futures | 117.0 | 118.07 | 116.87 | 117.84 | 141.0 |
| 2023-10-26 | FBTP | Futures | 107.03 | 108.31 | 106.82 | 107.94 | 241032.0 |
| 2023-10-26 | FBTS | Futures | 105.197 | 105.491 | 105.157 | 105.471 | 104666.0 |
| 2023-10-26 | FCE | Futures | 7329.8 | 7393.8 | 7294.6 | 7364.0 | 68442.0 |
| 2023-10-26 | FDAX | Futures | 15665.9 | 15672.3 | 15521.6 | 15603.8 | 85913.0 |
| 2023-10-26 | FDIV | Futures | 165.0 | 165.0 | 165.0 | 165.0 | 0.0 |
| 2023-10-26 | FDXM | Futures | 15665.0 | 15667.1 | 15515.5 | 15597.6 | 60009.0 |
| 2023-10-26 | FDXS | Futures | 15568.0 | 15568.0 | 15415.2 | 15495.8 | 29673.0 |
| 2023-10-26 | FESX | Futures | 4080.7 | 4108.9 | 4057.6 | 4090.8 | 848643.0 |
| 2023-10-26 | FEU3 | Futures | 97.792 | 97.792 | 97.792 | 97.792 | 0.0 |
| 2023-10-26 | FGBL | Futures | 130.03 | 130.93 | 129.68 | 130.61 | 1002748.0 |
| 2023-10-26 | FGBM | Futures | 116.91 | 117.4 | 116.8 | 117.25 | 732758.0 |
| 2023-10-26 | FGBS | Futures | 107.025 | 107.142 | 106.984 | 107.127 | 535922.0 |
| 2023-10-26 | FGBX | Futures | 122.1 | 123.68 | 121.28 | 122.92 | 93768.0 |
| 2023-10-26 | FMWO | Futures | 9508.3 | 9566.8 | 9446.5 | 9503.9 | 7962.0 |
| 2023-10-26 | FOAT | Futures | 120.84 | 121.67 | 120.52 | 121.43 | 198880.0 |
| 2023-10-26 | FSMX | Futures | 24511.6 | 24748.8 | 24413.0 | 24600.9 | 259.0 |
| 2023-10-26 | FTDX | Futures | 2914.2 | 2969.3 | 2914.2 | 2962.5 | 9.0 |
| 2023-10-26 | FTI | Futures | 737.8 | 742.89 | 734.09 | 739.85 | 17366.0 |
| 2023-10-26 | FTUK | Futures | 7459.6 | 7474.2 | 7396.7 | 7430.9 | 102763.0 |
| 2023-10-26 | FVSA | Futures | 29.1 | 29.51 | 28.27 | 28.75 | 19733.0 |
> showing 50 of 129 rows — these rows as CSV