PREVIEW / futures_daily / 2023-05-31
file: by_date/futures_daily/2023/2023-05-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 |
|---|---|---|---|---|---|---|---|
| 2023-05-31 | ES | Futures | 4609.96 | 4615.15 | 4567.28 | 4585.34 | 2138566.0 |
| 2023-05-31 | NQ | Futures | 15960.09 | 15995.29 | 15798.24 | 15852.84 | 680429.0 |
| 2023-05-31 | YM | Futures | 35430.3 | 35443.1 | 35139.9 | 35339.2 | 174704.0 |
| 2023-05-31 | CL | Futures | 60.72 | 60.78 | 58.46 | 59.38 | 444787.0 |
| 2023-05-31 | GC | Futures | 2173.9 | 2191.1 | 2167.7 | 2179.0 | 207753.0 |
| 2023-05-31 | ZN | Futures | 115.827155 | 116.418681 | 115.763206 | 116.258809 | 117456.0 |
| 2023-05-31 | A6 | Futures | 0.66294 | 0.66512 | 0.65684 | 0.66035 | 100098.0 |
| 2023-05-31 | AD | Futures | 0.74513 | 0.74675 | 0.74224 | 0.74645 | 91367.0 |
| 2023-05-31 | ALI | Futures | 2434.71 | 2468.05 | 2431.15 | 2463.95 | 1643.0 |
| 2023-05-31 | B | Futures | 65.35 | 65.44 | 63.28 | 64.25 | 442105.0 |
| 2023-05-31 | B6 | Futures | 1.2472 | 1.2505 | 1.2407 | 1.2482 | 136291.0 |
| 2023-05-31 | BFX | Futures | 3923.4 | 3923.4 | 3923.4 | 3923.4 | 0.0 |
| 2023-05-31 | BR | Futures | 0.18108 | 0.18108 | 0.17977 | 0.18084 | 2.0 |
| 2023-05-31 | BTC | Futures | 37205.3 | 37385.3 | 35878.7 | 36098.6 | 9363.0 |
| 2023-05-31 | BZ | Futures | 65.0 | 65.14 | 62.94 | 63.92 | 34611.0 |
| 2023-05-31 | C | Futures | 1804.0 | 1811.0 | 1796.0 | 1801.0 | 7630.0 |
| 2023-05-31 | CB | Futures | 233.878 | 235.736 | 233.854 | 235.736 | 28.0 |
| 2023-05-31 | CC | Futures | 1742.0 | 1760.0 | 1738.0 | 1746.0 | 26454.0 |
| 2023-05-31 | CNH | Futures | 6.7672 | 6.8044 | 6.7633 | 6.7932 | 644.0 |
| 2023-05-31 | CSC | Futures | 2.027 | 2.027 | 2.006 | 2.006 | 179.0 |
| 2023-05-31 | CT | Futures | 107.05 | 107.05 | 104.6 | 105.77 | 19748.0 |
| 2023-05-31 | DC | Futures | 18.86 | 18.86 | 18.58 | 18.68 | 204.0 |
| 2023-05-31 | DX | Futures | 101.642 | 102.253 | 101.588 | 101.891 | 16960.0 |
| 2023-05-31 | E1 | Futures | 1.18494 | 1.18515 | 1.17321 | 1.17782 | 28813.0 |
| 2023-05-31 | E6 | Futures | 1.10528 | 1.10528 | 1.09479 | 1.09875 | 281888.0 |
| 2023-05-31 | E7 | Futures | 1.1046 | 1.1047 | 1.0943 | 1.0983 | 6677.0 |
| 2023-05-31 | EBM | Futures | 320.35 | 322.18 | 315.22 | 319.62 | 35810.0 |
| 2023-05-31 | ER | Futures | 97.873 | 97.894 | 97.873 | 97.878 | 142540.0 |
| 2023-05-31 | ESG | Futures | 400.04 | 400.36 | 397.68 | 398.82 | 546.0 |
| 2023-05-31 | EW | Futures | 2609.1 | 2610.3 | 2556.1 | 2571.2 | 17590.0 |
| 2023-05-31 | FBON | Futures | 122.76 | 123.05 | 122.41 | 122.7 | 179.0 |
| 2023-05-31 | FBTP | Futures | 112.94 | 113.33 | 112.73 | 113.08 | 250335.0 |
| 2023-05-31 | FBTS | Futures | 106.451 | 106.572 | 106.421 | 106.542 | 164637.0 |
| 2023-05-31 | FCE | Futures | 7851.9 | 7856.8 | 7743.7 | 7761.2 | 78057.0 |
| 2023-05-31 | FDAX | Futures | 17006.5 | 17006.5 | 16691.8 | 16708.9 | 78456.0 |
| 2023-05-31 | FDIV | Futures | 183.87 | 183.87 | 183.87 | 183.87 | 0.0 |
| 2023-05-31 | FDXM | Futures | 17139.6 | 17150.3 | 16835.1 | 16851.3 | 56821.0 |
| 2023-05-31 | FDXS | Futures | 17026.6 | 17026.6 | 16722.1 | 16738.1 | 24534.0 |
| 2023-05-31 | FESX | Futures | 4388.4 | 4391.5 | 4307.7 | 4308.7 | 1288084.0 |
| 2023-05-31 | FEU3 | Futures | 97.888 | 97.888 | 97.888 | 97.888 | 0.0 |
| 2023-05-31 | FGBL | Futures | 136.04 | 137.13 | 136.04 | 136.78 | 1223435.0 |
| 2023-05-31 | FGBM | Futures | 119.63 | 120.19 | 119.62 | 120.06 | 928790.0 |
| 2023-05-31 | FGBS | Futures | 108.082 | 108.267 | 108.082 | 108.215 | 828167.0 |
| 2023-05-31 | FGBX | Futures | 139.94 | 142.33 | 139.94 | 141.45 | 146732.0 |
| 2023-05-31 | FMWO | Futures | 9874.7 | 9877.0 | 9785.4 | 9787.7 | 5653.0 |
| 2023-05-31 | FOAT | Futures | 126.98 | 128.03 | 126.97 | 127.68 | 295707.0 |
| 2023-05-31 | FSMX | Futures | 28177.8 | 28177.8 | 27977.2 | 28036.3 | 639.0 |
| 2023-05-31 | FTDX | Futures | 3427.2 | 3447.0 | 3421.8 | 3424.0 | 19.0 |
| 2023-05-31 | FTI | Futures | 796.24 | 799.36 | 791.17 | 791.69 | 19052.0 |
| 2023-05-31 | FTUK | Futures | 7691.0 | 7693.0 | 7588.0 | 7598.2 | 155169.0 |
> showing 50 of 130 rows — these rows as CSV