PREVIEW / futures_daily / 2024-01-31
file: by_date/futures_daily/2024/2024-01-31.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-01-31 | ES | Futures | 5219.02 | 5227.23 | 5151.01 | 5155.77 | 2285993.0 |
| 2024-01-31 | NQ | Futures | 18555.7 | 18628.69 | 18349.0 | 18371.11 | 816119.0 |
| 2024-01-31 | YM | Futures | 40182.0 | 40340.4 | 39847.6 | 39882.0 | 183773.0 |
| 2024-01-31 | CL | Futures | 69.06 | 69.3 | 67.01 | 67.3 | 344493.0 |
| 2024-01-31 | GC | Futures | 2167.2 | 2187.5 | 2160.3 | 2180.0 | 238373.0 |
| 2024-01-31 | ZN | Futures | 113.208025 | 114.062425 | 113.144736 | 113.74598 | 3568859.0 |
| 2024-01-31 | A6 | Futures | 0.66479 | 0.6671 | 0.65986 | 0.66429 | 178084.0 |
| 2024-01-31 | AD | Futures | 0.75189 | 0.75416 | 0.74923 | 0.75174 | 106219.0 |
| 2024-01-31 | ALI | Futures | 2468.99 | 2498.33 | 2458.56 | 2478.59 | 784.0 |
| 2024-01-31 | B | Futures | 76.13 | 76.14 | 73.95 | 74.21 | 392367.0 |
| 2024-01-31 | B6 | Futures | 1.2704 | 1.2756 | 1.2663 | 1.2716 | 160566.0 |
| 2024-01-31 | BFX | Futures | 3731.4 | 3731.4 | 3731.4 | 3731.4 | 0.0 |
| 2024-01-31 | BR | Futures | 0.19118 | 0.19251 | 0.19099 | 0.19213 | 16947.0 |
| 2024-01-31 | BTC | Futures | 55445.6 | 55972.1 | 54012.0 | 54316.5 | 7804.0 |
| 2024-01-31 | BZ | Futures | 75.07 | 75.24 | 73.08 | 73.33 | 33486.0 |
| 2024-01-31 | C | Futures | 3210.0 | 3244.0 | 3193.0 | 3222.0 | 11832.0 |
| 2024-01-31 | CB | Futures | 277.374 | 278.543 | 274.477 | 275.493 | 45.0 |
| 2024-01-31 | CC | Futures | 2775.0 | 2818.0 | 2760.0 | 2790.0 | 25256.0 |
| 2024-01-31 | CNH | Futures | 6.9855 | 6.9874 | 6.9694 | 6.9791 | 432.0 |
| 2024-01-31 | CSC | Futures | 1.735 | 1.752 | 1.696 | 1.731 | 145.0 |
| 2024-01-31 | CT | Futures | 101.81 | 102.64 | 101.6 | 102.4 | 20541.0 |
| 2024-01-31 | DC | Futures | 16.96 | 17.17 | 16.57 | 16.88 | 757.0 |
| 2024-01-31 | DX | Futures | 102.208 | 102.52 | 101.718 | 102.049 | 25377.0 |
| 2024-01-31 | E1 | Futures | 1.21082 | 1.22032 | 1.20724 | 1.21316 | 38623.0 |
| 2024-01-31 | E6 | Futures | 1.10072 | 1.10507 | 1.0951 | 1.10021 | 344623.0 |
| 2024-01-31 | E7 | Futures | 1.1004 | 1.1048 | 1.0953 | 1.1 | 10483.0 |
| 2024-01-31 | EBM | Futures | 280.99 | 281.65 | 277.69 | 278.02 | 36560.0 |
| 2024-01-31 | ER | Futures | 97.741 | 97.782 | 97.711 | 97.772 | 561323.0 |
| 2024-01-31 | ESG | Futures | 440.7 | 441.75 | 435.5 | 435.66 | 1164.0 |
| 2024-01-31 | EW | Futures | 2901.6 | 2907.5 | 2835.8 | 2837.8 | 19927.0 |
| 2024-01-31 | FBON | Futures | 124.55 | 125.15 | 124.46 | 125.14 | 70.0 |
| 2024-01-31 | FBTP | Futures | 117.57 | 118.08 | 117.36 | 117.96 | 410764.0 |
| 2024-01-31 | FBTS | Futures | 107.241 | 107.412 | 107.211 | 107.382 | 196049.0 |
| 2024-01-31 | FCE | Futures | 8040.5 | 8070.3 | 7981.4 | 8020.6 | 48860.0 |
| 2024-01-31 | FDAX | Futures | 17855.5 | 17901.5 | 17690.0 | 17797.9 | 58669.0 |
| 2024-01-31 | FDIV | Futures | 179.7 | 179.75 | 179.7 | 179.75 | 1.0 |
| 2024-01-31 | FDXM | Futures | 17722.1 | 17766.8 | 17557.9 | 17663.9 | 45939.0 |
| 2024-01-31 | FDXS | Futures | 17596.0 | 17649.7 | 17441.1 | 17547.5 | 19084.0 |
| 2024-01-31 | FESX | Futures | 4659.7 | 4676.6 | 4628.8 | 4647.8 | 912985.0 |
| 2024-01-31 | FEU3 | Futures | 97.751 | 97.782 | 97.711 | 97.782 | 1545.0 |
| 2024-01-31 | FGBL | Futures | 136.65 | 137.69 | 136.58 | 137.6 | 1575218.0 |
| 2024-01-31 | FGBM | Futures | 119.85 | 120.39 | 119.8 | 120.35 | 1270880.0 |
| 2024-01-31 | FGBS | Futures | 107.652 | 107.84 | 107.611 | 107.814 | 1198514.0 |
| 2024-01-31 | FGBX | Futures | 138.52 | 140.72 | 138.25 | 140.46 | 171970.0 |
| 2024-01-31 | FMWO | Futures | 11053.0 | 11075.9 | 10933.2 | 11025.8 | 6260.0 |
| 2024-01-31 | FOAT | Futures | 128.55 | 129.39 | 128.47 | 129.31 | 286572.0 |
| 2024-01-31 | FSMX | Futures | 26604.0 | 26736.9 | 26564.2 | 26681.7 | 554.0 |
| 2024-01-31 | FTDX | Futures | 3454.2 | 3456.2 | 3449.5 | 3454.2 | 37.0 |
| 2024-01-31 | FTI | Futures | 841.33 | 845.18 | 838.76 | 840.55 | 13402.0 |
| 2024-01-31 | FTUK | Futures | 7687.6 | 7702.1 | 7615.3 | 7657.0 | 112858.0 |
> showing 50 of 130 rows — these rows as CSV