PREVIEW / futures_daily / 2024-07-26
file: by_date/futures_daily/2024/2024-07-26.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 |
|---|---|---|---|---|---|---|---|
| 2024-07-26 | ES | Futures | 5625.18 | 5710.14 | 5624.41 | 5679.93 | 1977698.0 |
| 2024-07-26 | NQ | Futures | 19694.05 | 19999.52 | 19685.76 | 19871.79 | 694702.0 |
| 2024-07-26 | YM | Futures | 41039.9 | 41804.7 | 41027.7 | 41637.5 | 155670.0 |
| 2024-07-26 | CL | Futures | 72.68 | 72.91 | 70.67 | 71.57 | 365121.0 |
| 2024-07-26 | GC | Futures | 2460.6 | 2488.0 | 2451.5 | 2479.0 | 83174.0 |
| 2024-07-26 | ZN | Futures | 111.470033 | 111.846992 | 111.312967 | 111.784166 | 1856623.0 |
| 2024-07-26 | A6 | Futures | 0.65547 | 0.65858 | 0.65527 | 0.65703 | 133462.0 |
| 2024-07-26 | AD | Futures | 0.72791 | 0.72886 | 0.72665 | 0.7273 | 78251.0 |
| 2024-07-26 | ALI | Futures | 2333.13 | 2338.8 | 2309.66 | 2329.26 | 1599.0 |
| 2024-07-26 | B | Futures | 79.3 | 79.58 | 77.34 | 78.18 | 391706.0 |
| 2024-07-26 | B6 | Futures | 1.2852 | 1.288 | 1.2851 | 1.2874 | 72981.0 |
| 2024-07-26 | BFX | Futures | 4071.9 | 4071.9 | 4071.9 | 4071.9 | 0.0 |
| 2024-07-26 | BR | Futures | 0.16997 | 0.17132 | 0.16944 | 0.16959 | 20496.0 |
| 2024-07-26 | BTC | Futures | 74703.1 | 77411.6 | 74411.5 | 77131.2 | 8446.0 |
| 2024-07-26 | BZ | Futures | 77.7 | 77.94 | 75.78 | 76.59 | 46099.0 |
| 2024-07-26 | C | Futures | 6404.0 | 6488.0 | 6238.0 | 6441.0 | 3448.0 |
| 2024-07-26 | CB | Futures | 305.782 | 305.782 | 302.261 | 302.261 | 31.0 |
| 2024-07-26 | CC | Futures | 5454.0 | 5674.0 | 5407.0 | 5631.0 | 8417.0 |
| 2024-07-26 | CNH | Futures | 7.1285 | 7.1458 | 7.1162 | 7.1443 | 841.0 |
| 2024-07-26 | CSC | Futures | 2.003 | 2.013 | 1.991 | 2.011 | 85.0 |
| 2024-07-26 | CT | Futures | 74.59 | 74.59 | 73.78 | 74.22 | 9.0 |
| 2024-07-26 | DC | Futures | 19.68 | 19.85 | 19.56 | 19.78 | 453.0 |
| 2024-07-26 | DX | Futures | 103.567 | 103.671 | 103.418 | 103.526 | 9456.0 |
| 2024-07-26 | E1 | Futures | 1.16257 | 1.1641 | 1.15849 | 1.15977 | 32032.0 |
| 2024-07-26 | E6 | Futures | 1.09534 | 1.09766 | 1.09499 | 1.0965 | 145743.0 |
| 2024-07-26 | E7 | Futures | 1.0952 | 1.0972 | 1.0947 | 1.0962 | 2113.0 |
| 2024-07-26 | EBM | Futures | 257.29 | 260.5 | 253.2 | 253.79 | 26121.0 |
| 2024-07-26 | ER | Futures | 97.563 | 97.578 | 97.563 | 97.568 | 135696.0 |
| 2024-07-26 | ESG | Futures | 485.73 | 490.88 | 485.67 | 488.88 | 297.0 |
| 2024-07-26 | EW | Futures | 3103.9 | 3155.6 | 3103.9 | 3149.5 | 10350.0 |
| 2024-07-26 | FBON | Futures | 123.28 | 123.69 | 122.9 | 123.54 | 60.0 |
| 2024-07-26 | FBTP | Futures | 117.35 | 117.77 | 116.97 | 117.68 | 227063.0 |
| 2024-07-26 | FBTS | Futures | 106.535 | 106.626 | 106.495 | 106.585 | 127640.0 |
| 2024-07-26 | FCE | Futures | 7639.3 | 7743.2 | 7621.9 | 7716.6 | 45486.0 |
| 2024-07-26 | FDAX | Futures | 18825.6 | 19011.8 | 18742.8 | 18956.5 | 38921.0 |
| 2024-07-26 | FDIV | Futures | 186.31 | 186.51 | 186.31 | 186.51 | 4.0 |
| 2024-07-26 | FDXM | Futures | 18729.9 | 18924.3 | 18657.6 | 18868.3 | 24825.0 |
| 2024-07-26 | FDXS | Futures | 18662.6 | 18873.8 | 18607.8 | 18819.0 | 22698.0 |
| 2024-07-26 | FESX | Futures | 4884.2 | 4947.7 | 4874.1 | 4930.6 | 624917.0 |
| 2024-07-26 | FEU3 | Futures | 97.573 | 97.578 | 97.568 | 97.578 | 1289.0 |
| 2024-07-26 | FGBL | Futures | 133.81 | 134.26 | 133.45 | 134.1 | 821210.0 |
| 2024-07-26 | FGBM | Futures | 117.63 | 117.9 | 117.47 | 117.81 | 623948.0 |
| 2024-07-26 | FGBS | Futures | 106.666 | 106.747 | 106.6 | 106.711 | 513791.0 |
| 2024-07-26 | FGBX | Futures | 132.18 | 132.93 | 131.1 | 132.56 | 105901.0 |
| 2024-07-26 | FMWO | Futures | 11642.5 | 11783.9 | 11642.5 | 11712.7 | 4296.0 |
| 2024-07-26 | FOAT | Futures | 124.23 | 124.64 | 123.9 | 124.53 | 185081.0 |
| 2024-07-26 | FSMX | Futures | 25263.9 | 25504.9 | 25263.9 | 25466.6 | 174.0 |
| 2024-07-26 | FTDX | Futures | 3401.5 | 3422.4 | 3400.4 | 3422.4 | 2.0 |
| 2024-07-26 | FTI | Futures | 908.7 | 922.83 | 907.37 | 918.82 | 10074.0 |
| 2024-07-26 | FTUK | Futures | 8235.2 | 8355.5 | 8220.6 | 8316.4 | 88585.0 |
> showing 50 of 130 rows — these rows as CSV