PREVIEW / futures_daily / 2024-06-24
file: by_date/futures_daily/2024/2024-06-24.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-06-24 | ES | Futures | 5720.73 | 5741.38 | 5691.55 | 5698.52 | 1410359.0 |
| 2024-06-24 | NQ | Futures | 20742.59 | 20758.66 | 20445.41 | 20468.99 | 683900.0 |
| 2024-06-24 | YM | Futures | 40370.9 | 40789.0 | 40242.5 | 40631.0 | 132945.0 |
| 2024-06-24 | CL | Futures | 73.49 | 74.7 | 73.29 | 74.57 | 271745.0 |
| 2024-06-24 | GC | Futures | 2439.7 | 2454.3 | 2435.5 | 2451.1 | 117625.0 |
| 2024-06-24 | ZN | Futures | 111.030247 | 111.265847 | 110.936007 | 111.10878 | 1193239.0 |
| 2024-06-24 | A6 | Futures | 0.66639 | 0.66924 | 0.66504 | 0.66854 | 68661.0 |
| 2024-06-24 | AD | Futures | 0.73529 | 0.73771 | 0.73459 | 0.7376 | 89092.0 |
| 2024-06-24 | ALI | Futures | 2556.31 | 2619.53 | 2549.28 | 2577.38 | 2576.0 |
| 2024-06-24 | B | Futures | 81.03 | 82.15 | 80.77 | 82.01 | 179764.0 |
| 2024-06-24 | B6 | Futures | 1.2643 | 1.2702 | 1.2636 | 1.2695 | 76053.0 |
| 2024-06-24 | BFX | Futures | 4010.2 | 4010.2 | 4010.2 | 4010.2 | 0.0 |
| 2024-06-24 | BR | Futures | 0.1774 | 0.17885 | 0.1774 | 0.17779 | 5.0 |
| 2024-06-24 | BTC | Futures | 73511.8 | 73511.8 | 67112.2 | 67915.7 | 6257.0 |
| 2024-06-24 | BZ | Futures | 79.6 | 80.61 | 79.26 | 80.46 | 28043.0 |
| 2024-06-24 | C | Futures | 7366.0 | 7485.0 | 6636.0 | 6868.0 | 3557.0 |
| 2024-06-24 | CB | Futures | 299.348 | 299.348 | 297.406 | 297.406 | 32.0 |
| 2024-06-24 | CC | Futures | 6070.0 | 6224.0 | 5363.0 | 5548.0 | 17031.0 |
| 2024-06-24 | CNH | Futures | 7.1512 | 7.1552 | 7.1409 | 7.1458 | 646.0 |
| 2024-06-24 | CSC | Futures | 1.992 | 2.002 | 1.976 | 1.998 | 28.0 |
| 2024-06-24 | CT | Futures | 80.43 | 81.68 | 80.43 | 81.19 | 60.0 |
| 2024-06-24 | DC | Futures | 18.93 | 19.16 | 18.93 | 19.1 | 291.0 |
| 2024-06-24 | DX | Futures | 104.955 | 105.015 | 104.477 | 104.583 | 9007.0 |
| 2024-06-24 | E1 | Futures | 1.15121 | 1.1533 | 1.15029 | 1.15233 | 22253.0 |
| 2024-06-24 | E6 | Futures | 1.08164 | 1.08718 | 1.08083 | 1.08607 | 151459.0 |
| 2024-06-24 | E7 | Futures | 1.0816 | 1.0868 | 1.0806 | 1.0857 | 2290.0 |
| 2024-06-24 | EBM | Futures | 262.26 | 263.72 | 257.87 | 259.63 | 38924.0 |
| 2024-06-24 | ER | Futures | 97.518 | 97.533 | 97.518 | 97.523 | 99853.0 |
| 2024-06-24 | ESG | Futures | 492.18 | 494.16 | 490.42 | 490.8 | 346.0 |
| 2024-06-24 | EW | Futures | 3021.8 | 3054.2 | 3008.4 | 3035.6 | 9417.0 |
| 2024-06-24 | FBON | Futures | 122.48 | 122.89 | 122.48 | 122.72 | 38.0 |
| 2024-06-24 | FBTP | Futures | 116.2 | 116.38 | 116.06 | 116.15 | 190612.0 |
| 2024-06-24 | FBTS | Futures | 106.031 | 106.051 | 105.971 | 106.001 | 106126.0 |
| 2024-06-24 | FCE | Futures | 7871.3 | 7974.8 | 7871.3 | 7955.2 | 42287.0 |
| 2024-06-24 | FDAX | Futures | 18787.8 | 18959.6 | 18720.3 | 18947.3 | 40987.0 |
| 2024-06-24 | FDIV | Futures | 186.16 | 187.36 | 186.16 | 187.36 | 22.0 |
| 2024-06-24 | FDXM | Futures | 18705.4 | 18871.4 | 18633.2 | 18859.1 | 29214.0 |
| 2024-06-24 | FDXS | Futures | 18661.6 | 18823.0 | 18585.5 | 18809.8 | 34257.0 |
| 2024-06-24 | FESX | Futures | 4997.2 | 5049.6 | 4973.0 | 5038.5 | 599381.0 |
| 2024-06-24 | FEU3 | Futures | 97.528 | 97.528 | 97.523 | 97.528 | 1049.0 |
| 2024-06-24 | FGBL | Futures | 134.0 | 134.1 | 133.59 | 133.75 | 876729.0 |
| 2024-06-24 | FGBM | Futures | 117.63 | 117.7 | 117.38 | 117.46 | 513854.0 |
| 2024-06-24 | FGBS | Futures | 106.616 | 106.626 | 106.505 | 106.53 | 435979.0 |
| 2024-06-24 | FGBX | Futures | 133.77 | 134.03 | 132.67 | 132.97 | 77843.0 |
| 2024-06-24 | FMWO | Futures | 11727.3 | 11810.1 | 11717.9 | 11795.4 | 4016.0 |
| 2024-06-24 | FOAT | Futures | 123.71 | 123.99 | 123.61 | 123.76 | 170400.0 |
| 2024-06-24 | FSMX | Futures | 25767.1 | 26134.1 | 25748.9 | 26121.0 | 202.0 |
| 2024-06-24 | FTDX | Futures | 3415.2 | 3415.7 | 3399.4 | 3399.4 | 4.0 |
| 2024-06-24 | FTI | Futures | 941.45 | 946.06 | 938.0 | 942.32 | 9272.0 |
| 2024-06-24 | FTUK | Futures | 8301.3 | 8374.0 | 8269.8 | 8368.0 | 91368.0 |
> showing 50 of 130 rows — these rows as CSV