PREVIEW / futures_daily / 2023-11-06
file: by_date/futures_daily/2023/2023-11-06.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-11-06 | ES | Futures | 4687.44 | 4698.41 | 4671.39 | 4692.79 | 1348878.0 |
| 2023-11-06 | NQ | Futures | 16390.12 | 16466.2 | 16337.23 | 16439.22 | 496129.0 |
| 2023-11-06 | YM | Futures | 35959.1 | 36022.3 | 35833.9 | 35952.8 | 112890.0 |
| 2023-11-06 | CL | Futures | 72.62 | 73.62 | 72.2 | 72.35 | 271131.0 |
| 2023-11-06 | GC | Futures | 2152.7 | 2153.5 | 2136.4 | 2141.1 | 146279.0 |
| 2023-11-06 | ZN | Futures | 109.739605 | 109.739605 | 109.058386 | 109.090071 | 1637310.0 |
| 2023-11-06 | A6 | Futures | 0.65693 | 0.65854 | 0.65466 | 0.65526 | 114464.0 |
| 2023-11-06 | AD | Futures | 0.73835 | 0.74006 | 0.73613 | 0.73689 | 70840.0 |
| 2023-11-06 | ALI | Futures | 2466.21 | 2503.74 | 2451.97 | 2500.45 | 2049.0 |
| 2023-11-06 | B | Futures | 77.78 | 78.61 | 77.17 | 77.44 | 239234.0 |
| 2023-11-06 | B6 | Futures | 1.2383 | 1.2437 | 1.2346 | 1.236 | 106185.0 |
| 2023-11-06 | BR | Futures | 0.1918 | 0.19246 | 0.19124 | 0.19209 | 11792.0 |
| 2023-11-06 | BTC | Futures | 46285.8 | 46954.4 | 45918.8 | 46298.9 | 5080.0 |
| 2023-11-06 | BZ | Futures | 77.28 | 78.24 | 76.85 | 77.09 | 26524.0 |
| 2023-11-06 | C | Futures | 2814.0 | 2819.0 | 2775.0 | 2805.0 | 4731.0 |
| 2023-11-06 | CB | Futures | 261.509 | 261.509 | 258.042 | 259.528 | 30.0 |
| 2023-11-06 | CC | Futures | 2274.0 | 2294.0 | 2254.0 | 2281.0 | 51622.0 |
| 2023-11-06 | CNH | Futures | 7.042 | 7.0469 | 7.0246 | 7.0357 | 1426.0 |
| 2023-11-06 | CSC | Futures | 1.941 | 1.941 | 1.928 | 1.934 | 120.0 |
| 2023-11-06 | CT | Futures | 96.83 | 97.5 | 94.93 | 95.1 | 29926.0 |
| 2023-11-06 | DC | Futures | 18.56 | 18.57 | 18.33 | 18.41 | 451.0 |
| 2023-11-06 | DX | Futures | 103.494 | 103.696 | 103.272 | 103.623 | 13611.0 |
| 2023-11-06 | E1 | Futures | 1.1723 | 1.17702 | 1.17151 | 1.17282 | 13977.0 |
| 2023-11-06 | E6 | Futures | 1.09342 | 1.09622 | 1.09215 | 1.09296 | 185350.0 |
| 2023-11-06 | E7 | Futures | 1.0936 | 1.0965 | 1.0923 | 1.0932 | 3827.0 |
| 2023-11-06 | EBM | Futures | 321.11 | 321.11 | 315.27 | 318.7 | 24171.0 |
| 2023-11-06 | ER | Futures | 97.802 | 97.807 | 97.802 | 97.807 | 50655.0 |
| 2023-11-06 | ESG | Futures | 406.54 | 407.31 | 405.33 | 407.08 | 455.0 |
| 2023-11-06 | EW | Futures | 2608.7 | 2608.7 | 2567.9 | 2578.2 | 13649.0 |
| 2023-11-06 | FBON | Futures | 120.3 | 120.3 | 119.38 | 119.5 | 64.0 |
| 2023-11-06 | FBTP | Futures | 111.08 | 111.12 | 110.13 | 110.29 | 165205.0 |
| 2023-11-06 | FBTS | Futures | 106.078 | 106.078 | 105.865 | 105.886 | 126213.0 |
| 2023-11-06 | FCE | Futures | 7526.7 | 7549.6 | 7461.6 | 7489.8 | 43348.0 |
| 2023-11-06 | FDAX | Futures | 16084.2 | 16119.0 | 15979.9 | 16019.9 | 44090.0 |
| 2023-11-06 | FDIV | Futures | 168.93 | 168.93 | 168.93 | 168.93 | 0.0 |
| 2023-11-06 | FDXM | Futures | 16078.9 | 16112.6 | 15974.7 | 16013.6 | 29614.0 |
| 2023-11-06 | FDXS | Futures | 15976.0 | 16007.4 | 15870.3 | 15909.0 | 17682.0 |
| 2023-11-06 | FESX | Futures | 4221.7 | 4232.8 | 4186.5 | 4201.6 | 652134.0 |
| 2023-11-06 | FEU3 | Futures | 97.797 | 97.802 | 97.797 | 97.802 | 3.0 |
| 2023-11-06 | FGBL | Futures | 132.51 | 132.55 | 131.56 | 131.84 | 777210.0 |
| 2023-11-06 | FGBM | Futures | 118.09 | 118.1 | 117.59 | 117.73 | 681206.0 |
| 2023-11-06 | FGBS | Futures | 107.254 | 107.269 | 107.132 | 107.178 | 445516.0 |
| 2023-11-06 | FGBX | Futures | 127.23 | 127.37 | 125.32 | 125.87 | 89862.0 |
| 2023-11-06 | FMWO | Futures | 9967.5 | 10002.8 | 9941.0 | 9982.9 | 2270.0 |
| 2023-11-06 | FOAT | Futures | 123.57 | 123.63 | 122.62 | 122.88 | 171802.0 |
| 2023-11-06 | FSMX | Futures | 26034.8 | 26034.8 | 25668.1 | 25749.3 | 519.0 |
| 2023-11-06 | FTDX | Futures | 3086.1 | 3086.1 | 3066.9 | 3073.2 | 20.0 |
| 2023-11-06 | FTI | Futures | 758.19 | 760.04 | 754.64 | 756.07 | 13924.0 |
| 2023-11-06 | FTUK | Futures | 7470.7 | 7515.6 | 7462.2 | 7489.4 | 77605.0 |
| 2023-11-06 | FVSA | Futures | 23.61 | 23.81 | 23.13 | 23.26 | 22917.0 |
> showing 50 of 129 rows — these rows as CSV