PREVIEW / futures_daily / 2023-07-26
file: by_date/futures_daily/2023/2023-07-26.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-07-26 | ES | Futures | 4986.72 | 4993.21 | 4953.15 | 4976.43 | 1372426.0 |
| 2023-07-26 | NQ | Futures | 17211.6 | 17221.45 | 16976.08 | 17080.85 | 683826.0 |
| 2023-07-26 | YM | Futures | 37805.5 | 38046.8 | 37696.1 | 37923.5 | 173876.0 |
| 2023-07-26 | CL | Futures | 68.74 | 69.11 | 68.05 | 68.25 | 322031.0 |
| 2023-07-26 | GC | Futures | 2158.8 | 2174.2 | 2155.6 | 2163.6 | 104370.0 |
| 2023-07-26 | ZN | Futures | 113.756121 | 114.169607 | 113.644798 | 114.1378 | 1297820.0 |
| 2023-07-26 | A6 | Futures | 0.68925 | 0.68945 | 0.68286 | 0.68793 | 88445.0 |
| 2023-07-26 | AD | Futures | 0.76754 | 0.7677 | 0.76381 | 0.76628 | 61427.0 |
| 2023-07-26 | ALI | Futures | 2488.22 | 2488.22 | 2451.33 | 2461.11 | 1174.0 |
| 2023-07-26 | B | Futures | 73.28 | 73.83 | 72.75 | 73.06 | 333939.0 |
| 2023-07-26 | B6 | Futures | 1.2929 | 1.2987 | 1.2902 | 1.2983 | 77156.0 |
| 2023-07-26 | BFX | Futures | 4181.2 | 4181.2 | 4181.2 | 4181.2 | 0.0 |
| 2023-07-26 | BR | Futures | 0.19525 | 0.19627 | 0.1939 | 0.19604 | 13384.0 |
| 2023-07-26 | BTC | Futures | 39037.0 | 39606.6 | 38871.4 | 39229.1 | 4034.0 |
| 2023-07-26 | BZ | Futures | 73.15 | 73.61 | 72.54 | 72.84 | 21006.0 |
| 2023-07-26 | C | Futures | 2199.0 | 2240.0 | 2190.0 | 2234.0 | 6536.0 |
| 2023-07-26 | CB | Futures | 252.189 | 252.88 | 249.832 | 252.404 | 67.0 |
| 2023-07-26 | CC | Futures | 2012.0 | 2069.0 | 2008.0 | 2059.0 | 40035.0 |
| 2023-07-26 | CNH | Futures | 6.8421 | 6.8636 | 6.8417 | 6.8429 | 1309.0 |
| 2023-07-26 | CSC | Futures | 2.006 | 2.012 | 1.959 | 1.977 | 306.0 |
| 2023-07-26 | CT | Futures | 109.98 | 112.58 | 109.56 | 112.15 | 25.0 |
| 2023-07-26 | DC | Futures | 18.55 | 18.63 | 18.04 | 18.3 | 434.0 |
| 2023-07-26 | DX | Futures | 99.14 | 99.272 | 98.689 | 98.729 | 18449.0 |
| 2023-07-26 | E1 | Futures | 1.23518 | 1.24091 | 1.23243 | 1.24075 | 19977.0 |
| 2023-07-26 | E6 | Futures | 1.13444 | 1.13966 | 1.13255 | 1.13925 | 174937.0 |
| 2023-07-26 | E7 | Futures | 1.1345 | 1.1398 | 1.1327 | 1.1394 | 4748.0 |
| 2023-07-26 | EBM | Futures | 377.83 | 380.03 | 364.65 | 371.24 | 40813.0 |
| 2023-07-26 | ER | Futures | 97.853 | 97.853 | 97.833 | 97.838 | 114325.0 |
| 2023-07-26 | ESG | Futures | 432.44 | 433.25 | 430.53 | 431.78 | 359.0 |
| 2023-07-26 | EW | Futures | 2885.5 | 2909.5 | 2879.9 | 2901.0 | 11357.0 |
| 2023-07-26 | FBON | Futures | 122.75 | 122.75 | 121.94 | 122.03 | 38.0 |
| 2023-07-26 | FBTP | Futures | 114.36 | 114.42 | 113.91 | 114.0 | 116484.0 |
| 2023-07-26 | FBTS | Futures | 106.169 | 106.179 | 106.007 | 106.027 | 89448.0 |
| 2023-07-26 | FCE | Futures | 7995.5 | 8015.0 | 7865.1 | 7934.9 | 71317.0 |
| 2023-07-26 | FDAX | Futures | 17259.5 | 17291.2 | 17026.6 | 17162.1 | 72974.0 |
| 2023-07-26 | FDIV | Futures | 188.42 | 188.42 | 187.86 | 187.86 | 3.0 |
| 2023-07-26 | FDXM | Futures | 17324.8 | 17361.0 | 17096.3 | 17232.4 | 53435.0 |
| 2023-07-26 | FDXS | Futures | 17217.0 | 17250.8 | 16987.8 | 17122.0 | 28207.0 |
| 2023-07-26 | FESX | Futures | 4452.2 | 4458.3 | 4387.4 | 4422.9 | 890398.0 |
| 2023-07-26 | FEU3 | Futures | 97.833 | 97.833 | 97.833 | 97.833 | 0.0 |
| 2023-07-26 | FGBL | Futures | 135.21 | 135.35 | 134.48 | 134.69 | 595791.0 |
| 2023-07-26 | FGBM | Futures | 118.64 | 118.71 | 118.2 | 118.27 | 590495.0 |
| 2023-07-26 | FGBS | Futures | 107.427 | 107.448 | 107.269 | 107.294 | 395474.0 |
| 2023-07-26 | FGBX | Futures | 140.41 | 140.72 | 138.73 | 139.28 | 61405.0 |
| 2023-07-26 | FMWO | Futures | 10651.8 | 10661.9 | 10604.9 | 10623.9 | 3811.0 |
| 2023-07-26 | FOAT | Futures | 126.35 | 126.49 | 125.65 | 125.83 | 117498.0 |
| 2023-07-26 | FSMX | Futures | 29551.6 | 29554.7 | 29360.2 | 29518.3 | 27.0 |
| 2023-07-26 | FTDX | Futures | 3444.0 | 3445.0 | 3420.3 | 3424.0 | 32.0 |
| 2023-07-26 | FTI | Futures | 815.84 | 816.21 | 807.74 | 813.03 | 15759.0 |
| 2023-07-26 | FTUK | Futures | 7792.7 | 7817.1 | 7740.4 | 7787.6 | 84019.0 |
> showing 50 of 130 rows — these rows as CSV