PREVIEW / futures_daily / 2023-11-24
file: by_date/futures_daily/2023/2023-11-24.parquet size: 10 KB rows: 129
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-24 | ES | Futures | 4885.19 | 4895.9 | 4883.05 | 4889.74 | 572702.0 |
| 2023-11-24 | NQ | Futures | 17307.18 | 17360.87 | 17247.83 | 17290.19 | 296604.0 |
| 2023-11-24 | YM | Futures | 37160.9 | 37295.6 | 37128.3 | 37285.1 | 84103.0 |
| 2023-11-24 | CL | Futures | 68.73 | 69.0 | 67.19 | 67.61 | 281147.0 |
| 2023-11-24 | GC | Futures | 2143.9 | 2158.2 | 2143.6 | 2156.6 | 214880.0 |
| 2023-11-24 | ZN | Futures | 110.357455 | 110.484193 | 109.834659 | 109.898028 | 2272498.0 |
| 2023-11-24 | A6 | Futures | 0.6599 | 0.66494 | 0.65975 | 0.66474 | 91533.0 |
| 2023-11-24 | AD | Futures | 0.73678 | 0.74182 | 0.73542 | 0.74092 | 115896.0 |
| 2023-11-24 | ALI | Futures | 2427.87 | 2438.27 | 2418.01 | 2421.57 | 1629.0 |
| 2023-11-24 | B | Futures | 74.01 | 74.73 | 72.85 | 73.26 | 114142.0 |
| 2023-11-24 | B6 | Futures | 1.2505 | 1.2622 | 1.2496 | 1.2615 | 124118.0 |
| 2023-11-24 | BR | Futures | 0.19209 | 0.19209 | 0.19209 | 0.19209 | 0.0 |
| 2023-11-24 | BTC | Futures | 49359.8 | 50798.8 | 48527.3 | 49785.7 | 10216.0 |
| 2023-11-24 | BZ | Futures | 73.88 | 74.39 | 72.57 | 72.93 | 19356.0 |
| 2023-11-24 | C | Futures | 2903.0 | 2912.0 | 2889.0 | 2897.0 | 2632.0 |
| 2023-11-24 | CB | Futures | 251.655 | 251.655 | 251.655 | 251.655 | 0.0 |
| 2023-11-24 | CC | Futures | 2376.0 | 2386.0 | 2359.0 | 2366.0 | 13856.0 |
| 2023-11-24 | CNH | Futures | 6.9321 | 6.9325 | 6.9054 | 6.917 | 3261.0 |
| 2023-11-24 | CSC | Futures | 1.855 | 1.855 | 1.855 | 1.855 | 0.0 |
| 2023-11-24 | CT | Futures | 97.03 | 98.27 | 96.41 | 97.38 | 13408.0 |
| 2023-11-24 | DC | Futures | 17.59 | 17.59 | 17.59 | 17.59 | 0.0 |
| 2023-11-24 | DX | Futures | 102.227 | 102.34 | 101.857 | 101.905 | 9236.0 |
| 2023-11-24 | E1 | Futures | 1.19024 | 1.19365 | 1.18851 | 1.19307 | 20146.0 |
| 2023-11-24 | E6 | Futures | 1.10883 | 1.11463 | 1.10822 | 1.11412 | 198786.0 |
| 2023-11-24 | E7 | Futures | 1.1092 | 1.1148 | 1.1089 | 1.1144 | 5653.0 |
| 2023-11-24 | EBM | Futures | 304.3 | 306.01 | 300.18 | 300.52 | 16033.0 |
| 2023-11-24 | ER | Futures | 97.792 | 97.802 | 97.787 | 97.797 | 97654.0 |
| 2023-11-24 | ESG | Futures | 424.55 | 424.55 | 422.84 | 423.34 | 272.0 |
| 2023-11-24 | EW | Futures | 2673.2 | 2688.9 | 2667.5 | 2684.9 | 6262.0 |
| 2023-11-24 | FBON | Futures | 120.85 | 121.08 | 120.62 | 120.9 | 35.0 |
| 2023-11-24 | FBTP | Futures | 112.2 | 112.52 | 112.03 | 112.29 | 141206.0 |
| 2023-11-24 | FBTS | Futures | 106.088 | 106.118 | 106.047 | 106.078 | 91143.0 |
| 2023-11-24 | FCE | Futures | 7730.4 | 7759.1 | 7723.0 | 7751.1 | 25420.0 |
| 2023-11-24 | FDAX | Futures | 16892.2 | 16947.0 | 16869.1 | 16934.4 | 37242.0 |
| 2023-11-24 | FDIV | Futures | 172.92 | 172.92 | 171.12 | 172.72 | 5.0 |
| 2023-11-24 | FDXM | Futures | 16881.4 | 16940.4 | 16862.4 | 16927.7 | 28962.0 |
| 2023-11-24 | FDXS | Futures | 16775.3 | 16829.7 | 16752.3 | 16817.2 | 11093.0 |
| 2023-11-24 | FESX | Futures | 4401.0 | 4418.1 | 4392.9 | 4414.1 | 404431.0 |
| 2023-11-24 | FEU3 | Futures | 97.787 | 97.797 | 97.787 | 97.797 | 1635.0 |
| 2023-11-24 | FGBL | Futures | 132.71 | 132.8 | 132.27 | 132.49 | 618964.0 |
| 2023-11-24 | FGBM | Futures | 117.73 | 117.77 | 117.6 | 117.64 | 466091.0 |
| 2023-11-24 | FGBS | Futures | 107.019 | 107.035 | 106.984 | 106.984 | 379580.0 |
| 2023-11-24 | FGBX | Futures | 130.9 | 130.98 | 129.42 | 130.1 | 78914.0 |
| 2023-11-24 | FMWO | Futures | 10380.2 | 10410.0 | 10380.2 | 10401.2 | 1504.0 |
| 2023-11-24 | FOAT | Futures | 124.19 | 124.25 | 123.76 | 124.04 | 118222.0 |
| 2023-11-24 | FSMX | Futures | 26808.2 | 27013.7 | 26723.0 | 27006.5 | 50.0 |
| 2023-11-24 | FTDX | Futures | 3260.2 | 3266.9 | 3260.2 | 3266.4 | 12.0 |
| 2023-11-24 | FTI | Futures | 787.04 | 792.2 | 786.32 | 791.45 | 6523.0 |
| 2023-11-24 | FTUK | Futures | 7567.9 | 7578.5 | 7525.1 | 7567.9 | 56862.0 |
| 2023-11-24 | FVSA | Futures | 20.3 | 20.64 | 19.88 | 20.16 | 11134.0 |
> showing 50 of 129 rows — these rows as CSV