PREVIEW / futures_daily / 2024-10-29
file: by_date/futures_daily/2024/2024-10-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 |
|---|---|---|---|---|---|---|---|
| 2024-10-29 | ES | Futures | 6002.2 | 6019.33 | 5972.02 | 6006.29 | 1195753.0 |
| 2024-10-29 | NQ | Futures | 21040.53 | 21294.14 | 20957.71 | 21228.75 | 498020.0 |
| 2024-10-29 | YM | Futures | 43091.2 | 43145.7 | 42809.2 | 42893.1 | 105163.0 |
| 2024-10-29 | CL | Futures | 65.83 | 66.32 | 64.57 | 65.05 | 291929.0 |
| 2024-10-29 | GC | Futures | 2812.2 | 2846.3 | 2809.9 | 2839.6 | 207424.0 |
| 2024-10-29 | ZN | Futures | 110.811671 | 111.046342 | 110.436197 | 110.889895 | 2372559.0 |
| 2024-10-29 | A6 | Futures | 0.65859 | 0.65859 | 0.65455 | 0.65559 | 89532.0 |
| 2024-10-29 | AD | Futures | 0.72268 | 0.72333 | 0.72033 | 0.72093 | 70517.0 |
| 2024-10-29 | ALI | Futures | 2706.41 | 2726.36 | 2674.17 | 2703.08 | 489.0 |
| 2024-10-29 | B | Futures | 71.0 | 71.55 | 69.73 | 70.18 | 381254.0 |
| 2024-10-29 | B6 | Futures | 1.2965 | 1.3011 | 1.2952 | 1.2999 | 81424.0 |
| 2024-10-29 | BFX | Futures | 4297.6 | 4297.6 | 4297.6 | 4297.6 | 0.0 |
| 2024-10-29 | BR | Futures | 0.17045 | 0.17098 | 0.16855 | 0.16874 | 17050.0 |
| 2024-10-29 | BTC | Futures | 76219.8 | 80528.1 | 76176.5 | 79290.2 | 13100.0 |
| 2024-10-29 | BZ | Futures | 69.71 | 70.12 | 68.34 | 68.78 | 35127.0 |
| 2024-10-29 | C | Futures | 5350.0 | 5712.0 | 5344.0 | 5682.0 | 5082.0 |
| 2024-10-29 | CB | Futures | 280.898 | 284.788 | 280.898 | 283.673 | 109.0 |
| 2024-10-29 | CC | Futures | 5651.0 | 6004.0 | 5648.0 | 5951.0 | 9564.0 |
| 2024-10-29 | CNH | Futures | 7.0881 | 7.1095 | 7.0871 | 7.0916 | 702.0 |
| 2024-10-29 | CSC | Futures | 2.043 | 2.053 | 2.03 | 2.033 | 295.0 |
| 2024-10-29 | CT | Futures | 77.13 | 77.96 | 76.74 | 77.35 | 17990.0 |
| 2024-10-29 | DC | Futures | 20.1 | 20.11 | 19.88 | 19.9 | 1364.0 |
| 2024-10-29 | DX | Futures | 103.845 | 104.229 | 103.806 | 103.906 | 21332.0 |
| 2024-10-29 | E1 | Futures | 1.17256 | 1.17408 | 1.16661 | 1.16964 | 23022.0 |
| 2024-10-29 | E6 | Futures | 1.08802 | 1.08937 | 1.0836 | 1.08807 | 220104.0 |
| 2024-10-29 | E7 | Futures | 1.0876 | 1.089 | 1.0833 | 1.0877 | 3607.0 |
| 2024-10-29 | EBM | Futures | 237.15 | 241.52 | 236.6 | 240.15 | 41419.0 |
| 2024-10-29 | ER | Futures | 97.865 | 97.871 | 97.85 | 97.865 | 143033.0 |
| 2024-10-29 | ESG | Futures | 519.1 | 519.1 | 516.93 | 518.15 | 216.0 |
| 2024-10-29 | EW | Futures | 3190.4 | 3196.0 | 3158.8 | 3192.3 | 8869.0 |
| 2024-10-29 | FBON | Futures | 125.65 | 125.74 | 124.9 | 124.97 | 108.0 |
| 2024-10-29 | FBTP | Futures | 120.75 | 120.8 | 119.94 | 120.01 | 292559.0 |
| 2024-10-29 | FBTS | Futures | 107.45 | 107.45 | 107.26 | 107.29 | 146580.0 |
| 2024-10-29 | FCE | Futures | 7589.7 | 7629.7 | 7506.2 | 7521.2 | 40275.0 |
| 2024-10-29 | FDAX | Futures | 19812.1 | 19939.3 | 19752.5 | 19774.8 | 36909.0 |
| 2024-10-29 | FDIV | Futures | 192.41 | 192.41 | 192.26 | 192.26 | 10.0 |
| 2024-10-29 | FDXM | Futures | 19773.3 | 19897.2 | 19709.8 | 19731.9 | 33037.0 |
| 2024-10-29 | FDXS | Futures | 19726.0 | 19850.6 | 19666.6 | 19687.8 | 24077.0 |
| 2024-10-29 | FESX | Futures | 4994.0 | 5023.0 | 4967.9 | 4972.0 | 524241.0 |
| 2024-10-29 | FEU3 | Futures | 97.865 | 97.865 | 97.855 | 97.865 | 4278.0 |
| 2024-10-29 | FGBL | Futures | 134.91 | 134.99 | 134.17 | 134.24 | 1087406.0 |
| 2024-10-29 | FGBM | Futures | 118.49 | 118.54 | 118.09 | 118.13 | 779845.0 |
| 2024-10-29 | FGBS | Futures | 107.245 | 107.26 | 107.119 | 107.139 | 623247.0 |
| 2024-10-29 | FGBX | Futures | 133.0 | 133.14 | 131.4 | 131.68 | 106573.0 |
| 2024-10-29 | FMWO | Futures | 12278.4 | 12292.9 | 12217.3 | 12263.9 | 4009.0 |
| 2024-10-29 | FOAT | Futures | 125.39 | 125.43 | 124.54 | 124.61 | 195554.0 |
| 2024-10-29 | FSMX | Futures | 27438.1 | 27446.1 | 27207.0 | 27240.0 | 191.0 |
| 2024-10-29 | FTDX | Futures | 3481.6 | 3481.6 | 3481.6 | 3481.6 | 0.0 |
| 2024-10-29 | FTI | Futures | 904.61 | 907.58 | 900.47 | 901.49 | 6812.0 |
| 2024-10-29 | FTUK | Futures | 8336.4 | 8368.5 | 8240.2 | 8259.3 | 82162.0 |
> showing 50 of 130 rows — these rows as CSV