PREVIEW / futures_daily / 2023-11-20
file: by_date/futures_daily/2023/2023-11-20.parquet size: 10 KB rows: 128
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-20 | ES | Futures | 4845.32 | 4892.69 | 4838.1 | 4883.32 | 1220790.0 |
| 2023-11-20 | NQ | Futures | 17154.2 | 17393.52 | 17091.88 | 17360.87 | 559493.0 |
| 2023-11-20 | YM | Futures | 36809.4 | 37139.9 | 36792.6 | 37069.4 | 103045.0 |
| 2023-11-20 | CL | Futures | 67.84 | 70.23 | 67.5 | 69.66 | 270638.0 |
| 2023-11-20 | GC | Futures | 2132.8 | 2140.2 | 2118.1 | 2132.2 | 177887.0 |
| 2023-11-20 | ZN | Futures | 110.199032 | 110.436666 | 109.945555 | 110.357455 | 1607627.0 |
| 2023-11-20 | A6 | Futures | 0.65728 | 0.66232 | 0.65592 | 0.66207 | 96327.0 |
| 2023-11-20 | AD | Futures | 0.73522 | 0.73663 | 0.73346 | 0.73487 | 53502.0 |
| 2023-11-20 | ALI | Futures | 2414.17 | 2450.87 | 2414.17 | 2447.59 | 2252.0 |
| 2023-11-20 | B | Futures | 73.01 | 75.41 | 72.35 | 74.84 | 248325.0 |
| 2023-11-20 | B6 | Futures | 1.2468 | 1.2525 | 1.2453 | 1.2518 | 81999.0 |
| 2023-11-20 | BR | Futures | 0.19195 | 0.19458 | 0.1918 | 0.19378 | 8554.0 |
| 2023-11-20 | BTC | Futures | 48599.5 | 49635.0 | 48166.9 | 49307.3 | 15555.0 |
| 2023-11-20 | BZ | Futures | 72.83 | 75.05 | 72.38 | 74.5 | 24121.0 |
| 2023-11-20 | C | Futures | 2971.0 | 2972.0 | 2890.0 | 2892.0 | 2643.0 |
| 2023-11-20 | CB | Futures | 252.594 | 252.594 | 250.118 | 251.604 | 54.0 |
| 2023-11-20 | CC | Futures | 2366.0 | 2386.0 | 2337.0 | 2344.0 | 31397.0 |
| 2023-11-20 | CNH | Futures | 6.982 | 6.9863 | 6.9262 | 6.9292 | 3060.0 |
| 2023-11-20 | CSC | Futures | 1.884 | 1.884 | 1.852 | 1.853 | 362.0 |
| 2023-11-20 | CT | Futures | 95.83 | 96.47 | 93.91 | 95.06 | 7393.0 |
| 2023-11-20 | DC | Futures | 17.86 | 17.98 | 17.61 | 17.62 | 764.0 |
| 2023-11-20 | DX | Futures | 102.305 | 102.448 | 101.857 | 101.918 | 14124.0 |
| 2023-11-20 | E1 | Futures | 1.18866 | 1.19223 | 1.18698 | 1.18992 | 20606.0 |
| 2023-11-20 | E6 | Futures | 1.11138 | 1.11555 | 1.10995 | 1.11494 | 184807.0 |
| 2023-11-20 | E7 | Futures | 1.1115 | 1.1157 | 1.1101 | 1.1152 | 3706.0 |
| 2023-11-20 | EBM | Futures | 310.13 | 310.13 | 307.38 | 307.73 | 27636.0 |
| 2023-11-20 | ER | Futures | 97.782 | 97.797 | 97.782 | 97.787 | 117361.0 |
| 2023-11-20 | ESG | Futures | 419.77 | 423.77 | 419.62 | 423.04 | 506.0 |
| 2023-11-20 | EW | Futures | 2659.5 | 2678.1 | 2649.6 | 2673.0 | 11851.0 |
| 2023-11-20 | FBON | Futures | 121.42 | 121.42 | 121.08 | 121.15 | 62.0 |
| 2023-11-20 | FBTP | Futures | 113.24 | 113.24 | 112.52 | 112.73 | 207100.0 |
| 2023-11-20 | FBTS | Futures | 106.503 | 106.503 | 106.29 | 106.3 | 132739.0 |
| 2023-11-20 | FCE | Futures | 7691.2 | 7727.8 | 7688.0 | 7705.0 | 38823.0 |
| 2023-11-20 | FDAX | Futures | 16852.2 | 16859.6 | 16754.2 | 16814.3 | 54485.0 |
| 2023-11-20 | FDIV | Futures | 172.62 | 172.77 | 172.57 | 172.77 | 45.0 |
| 2023-11-20 | FDXM | Futures | 16836.1 | 16853.0 | 16746.6 | 16807.7 | 37062.0 |
| 2023-11-20 | FDXS | Futures | 16736.6 | 16743.9 | 16638.3 | 16697.9 | 14158.0 |
| 2023-11-20 | FESX | Futures | 4379.8 | 4396.9 | 4370.8 | 4384.9 | 507936.0 |
| 2023-11-20 | FEU3 | Futures | 97.787 | 97.787 | 97.787 | 97.787 | 0.0 |
| 2023-11-20 | FGBL | Futures | 133.16 | 133.18 | 132.64 | 132.85 | 737369.0 |
| 2023-11-20 | FGBM | Futures | 118.11 | 118.13 | 117.87 | 117.93 | 610161.0 |
| 2023-11-20 | FGBS | Futures | 107.183 | 107.188 | 107.086 | 107.096 | 457451.0 |
| 2023-11-20 | FGBX | Futures | 130.63 | 131.29 | 129.67 | 130.34 | 87411.0 |
| 2023-11-20 | FMWO | Futures | 10308.5 | 10393.5 | 10298.6 | 10348.2 | 2904.0 |
| 2023-11-20 | FOAT | Futures | 124.55 | 124.65 | 124.13 | 124.35 | 138428.0 |
| 2023-11-20 | FSMX | Futures | 27157.5 | 27248.9 | 27118.4 | 27198.5 | 168.0 |
| 2023-11-20 | FTDX | Futures | 3251.9 | 3272.6 | 3251.9 | 3268.5 | 25.0 |
| 2023-11-20 | FTI | Futures | 785.03 | 787.77 | 783.54 | 785.55 | 9107.0 |
| 2023-11-20 | FTUK | Futures | 7586.1 | 7586.1 | 7544.8 | 7572.0 | 74755.0 |
| 2023-11-20 | FVSA | Futures | 21.06 | 21.13 | 20.51 | 20.51 | 13090.0 |
> showing 50 of 128 rows — these rows as CSV