PREVIEW / futures_daily / 2024-10-23
file: by_date/futures_daily/2024/2024-10-23.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-23 | ES | Futures | 6022.91 | 6029.56 | 5934.67 | 5972.27 | 1468269.0 |
| 2024-10-23 | NQ | Futures | 21048.74 | 21070.79 | 20595.37 | 20740.51 | 619162.0 |
| 2024-10-23 | YM | Futures | 43449.9 | 43517.6 | 42958.8 | 43187.2 | 130296.0 |
| 2024-10-23 | CL | Futures | 69.05 | 69.41 | 67.87 | 68.49 | 293835.0 |
| 2024-10-23 | GC | Futures | 2820.7 | 2830.9 | 2779.4 | 2786.8 | 214515.0 |
| 2024-10-23 | ZN | Futures | 111.437461 | 111.500039 | 111.093276 | 111.1715 | 1944719.0 |
| 2024-10-23 | A6 | Futures | 0.66839 | 0.66924 | 0.66149 | 0.66254 | 73739.0 |
| 2024-10-23 | AD | Futures | 0.72634 | 0.72659 | 0.72424 | 0.72539 | 70099.0 |
| 2024-10-23 | ALI | Futures | 2663.94 | 2714.59 | 2655.5 | 2701.04 | 1943.0 |
| 2024-10-23 | B | Futures | 75.06 | 75.38 | 73.76 | 74.3 | 288437.0 |
| 2024-10-23 | B6 | Futures | 1.298 | 1.299 | 1.2901 | 1.2916 | 71437.0 |
| 2024-10-23 | BFX | Futures | 4297.1 | 4297.1 | 4297.1 | 4297.1 | 0.0 |
| 2024-10-23 | BR | Futures | 0.1702 | 0.17064 | 0.16947 | 0.1705 | 2744.0 |
| 2024-10-23 | BTC | Futures | 73888.4 | 74172.5 | 71265.5 | 72522.3 | 12272.0 |
| 2024-10-23 | BZ | Futures | 73.39 | 73.74 | 72.21 | 72.72 | 28090.0 |
| 2024-10-23 | C | Futures | 5352.0 | 5416.0 | 5219.0 | 5275.0 | 4094.0 |
| 2024-10-23 | CB | Futures | 284.27 | 284.581 | 280.742 | 281.157 | 26.0 |
| 2024-10-23 | CC | Futures | 5831.0 | 5915.0 | 5674.0 | 5733.0 | 9041.0 |
| 2024-10-23 | CNH | Futures | 7.0782 | 7.0886 | 7.0782 | 7.0801 | 1016.0 |
| 2024-10-23 | CSC | Futures | 2.101 | 2.119 | 2.082 | 2.093 | 250.0 |
| 2024-10-23 | CT | Futures | 79.02 | 79.75 | 78.78 | 79.49 | 16046.0 |
| 2024-10-23 | DC | Futures | 20.42 | 20.75 | 20.31 | 20.54 | 748.0 |
| 2024-10-23 | DX | Futures | 103.641 | 104.125 | 103.641 | 103.992 | 21155.0 |
| 2024-10-23 | E1 | Futures | 1.17322 | 1.17378 | 1.16898 | 1.17115 | 18659.0 |
| 2024-10-23 | E6 | Futures | 1.08691 | 1.08767 | 1.0831 | 1.08505 | 175534.0 |
| 2024-10-23 | E7 | Futures | 1.0867 | 1.0873 | 1.0828 | 1.0847 | 3304.0 |
| 2024-10-23 | EBM | Futures | 243.16 | 245.07 | 241.52 | 244.53 | 36001.0 |
| 2024-10-23 | ER | Futures | 97.85 | 97.865 | 97.83 | 97.85 | 341987.0 |
| 2024-10-23 | ESG | Futures | 519.9 | 519.9 | 513.16 | 515.69 | 640.0 |
| 2024-10-23 | EW | Futures | 3190.1 | 3194.4 | 3151.3 | 3172.3 | 6058.0 |
| 2024-10-23 | FBON | Futures | 125.0 | 125.36 | 125.0 | 125.19 | 432.0 |
| 2024-10-23 | FBTP | Futures | 120.02 | 120.37 | 120.01 | 120.26 | 301535.0 |
| 2024-10-23 | FBTS | Futures | 107.37 | 107.5 | 107.37 | 107.46 | 192502.0 |
| 2024-10-23 | FCE | Futures | 7557.7 | 7565.7 | 7475.2 | 7512.2 | 30750.0 |
| 2024-10-23 | FDAX | Futures | 19768.7 | 19781.8 | 19601.1 | 19685.9 | 36242.0 |
| 2024-10-23 | FDIV | Futures | 192.16 | 192.36 | 192.16 | 192.36 | 1.0 |
| 2024-10-23 | FDXM | Futures | 19723.9 | 19737.0 | 19559.7 | 19643.3 | 31027.0 |
| 2024-10-23 | FDXS | Futures | 19661.6 | 19690.8 | 19515.9 | 19599.3 | 28387.0 |
| 2024-10-23 | FESX | Futures | 4967.9 | 4973.0 | 4922.9 | 4946.9 | 522335.0 |
| 2024-10-23 | FEU3 | Futures | 97.835 | 97.86 | 97.835 | 97.85 | 3804.0 |
| 2024-10-23 | FGBL | Futures | 134.61 | 134.68 | 134.32 | 134.44 | 1203802.0 |
| 2024-10-23 | FGBM | Futures | 118.3 | 118.41 | 118.21 | 118.31 | 759897.0 |
| 2024-10-23 | FGBS | Futures | 107.184 | 107.26 | 107.149 | 107.22 | 836193.0 |
| 2024-10-23 | FGBX | Futures | 131.82 | 131.92 | 130.84 | 131.24 | 111039.0 |
| 2024-10-23 | FMWO | Futures | 12298.1 | 12311.6 | 12137.5 | 12215.2 | 5021.0 |
| 2024-10-23 | FOAT | Futures | 124.92 | 125.07 | 124.73 | 124.91 | 191040.0 |
| 2024-10-23 | FSMX | Futures | 27325.1 | 27343.1 | 27213.0 | 27239.0 | 77.0 |
| 2024-10-23 | FTDX | Futures | 3468.4 | 3468.4 | 3468.4 | 3468.4 | 0.0 |
| 2024-10-23 | FTI | Futures | 905.51 | 907.03 | 893.56 | 897.02 | 6605.0 |
| 2024-10-23 | FTUK | Futures | 8362.0 | 8369.5 | 8285.8 | 8301.3 | 63883.0 |
> showing 50 of 130 rows — these rows as CSV