PREVIEW / futures_daily / 2024-07-23
file: by_date/futures_daily/2024/2024-07-23.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-07-23 | ES | Futures | 5792.25 | 5814.98 | 5771.6 | 5783.47 | 1385653.0 |
| 2024-07-23 | NQ | Futures | 20708.65 | 20815.14 | 20590.76 | 20649.58 | 601990.0 |
| 2024-07-23 | YM | Futures | 41486.6 | 41600.8 | 41368.3 | 41417.2 | 115515.0 |
| 2024-07-23 | CL | Futures | 72.6 | 73.03 | 70.87 | 71.39 | 417941.0 |
| 2024-07-23 | GC | Futures | 2507.1 | 2523.3 | 2497.9 | 2516.8 | 171191.0 |
| 2024-07-23 | ZN | Futures | 111.328673 | 111.579979 | 111.29726 | 111.454326 | 1402604.0 |
| 2024-07-23 | A6 | Futures | 0.66609 | 0.66649 | 0.66293 | 0.66318 | 92435.0 |
| 2024-07-23 | AD | Futures | 0.73153 | 0.73178 | 0.73007 | 0.73057 | 58272.0 |
| 2024-07-23 | ALI | Futures | 2344.47 | 2362.78 | 2330.03 | 2332.35 | 1864.0 |
| 2024-07-23 | B | Futures | 79.18 | 79.7 | 77.51 | 77.99 | 384324.0 |
| 2024-07-23 | B6 | Futures | 1.2934 | 1.2937 | 1.2889 | 1.2905 | 69599.0 |
| 2024-07-23 | BFX | Futures | 4023.2 | 4023.2 | 4023.2 | 4023.2 | 0.0 |
| 2024-07-23 | BR | Futures | 0.17215 | 0.17268 | 0.17161 | 0.17176 | 2244.0 |
| 2024-07-23 | BTC | Futures | 77609.0 | 77654.6 | 74645.8 | 74725.6 | 12316.0 |
| 2024-07-23 | BZ | Futures | 77.55 | 78.09 | 75.96 | 76.42 | 45436.0 |
| 2024-07-23 | C | Futures | 6713.0 | 6802.0 | 6622.0 | 6729.0 | 2778.0 |
| 2024-07-23 | CB | Futures | 302.019 | 302.99 | 302.019 | 302.019 | 43.0 |
| 2024-07-23 | CC | Futures | 5779.0 | 5881.0 | 5731.0 | 5805.0 | 6276.0 |
| 2024-07-23 | CNH | Futures | 7.1784 | 7.1799 | 7.1695 | 7.1744 | 518.0 |
| 2024-07-23 | CSC | Futures | 1.988 | 2.004 | 1.975 | 1.993 | 184.0 |
| 2024-07-23 | CT | Futures | 79.35 | 79.35 | 75.93 | 76.42 | 94.0 |
| 2024-07-23 | DC | Futures | 19.23 | 19.55 | 19.23 | 19.46 | 672.0 |
| 2024-07-23 | DX | Futures | 103.512 | 103.726 | 103.398 | 103.642 | 8510.0 |
| 2024-07-23 | E1 | Futures | 1.15279 | 1.15355 | 1.14897 | 1.15029 | 26306.0 |
| 2024-07-23 | E6 | Futures | 1.10028 | 1.10078 | 1.09539 | 1.09625 | 187637.0 |
| 2024-07-23 | E7 | Futures | 1.1 | 1.1003 | 1.0951 | 1.0959 | 3243.0 |
| 2024-07-23 | EBM | Futures | 263.42 | 263.72 | 259.63 | 262.84 | 23859.0 |
| 2024-07-23 | ER | Futures | 97.533 | 97.548 | 97.528 | 97.538 | 96818.0 |
| 2024-07-23 | ESG | Futures | 501.79 | 502.11 | 499.32 | 499.74 | 122.0 |
| 2024-07-23 | EW | Futures | 3127.8 | 3145.1 | 3112.0 | 3133.4 | 8873.0 |
| 2024-07-23 | FBON | Futures | 123.13 | 123.53 | 123.13 | 123.36 | 46.0 |
| 2024-07-23 | FBTP | Futures | 117.48 | 117.81 | 117.33 | 117.58 | 214450.0 |
| 2024-07-23 | FBTS | Futures | 106.394 | 106.495 | 106.394 | 106.454 | 131040.0 |
| 2024-07-23 | FCE | Futures | 7837.4 | 7869.2 | 7746.3 | 7803.1 | 49554.0 |
| 2024-07-23 | FDAX | Futures | 19047.6 | 19201.0 | 18989.3 | 19094.6 | 39095.0 |
| 2024-07-23 | FDIV | Futures | 188.35 | 188.35 | 188.35 | 188.35 | 0.0 |
| 2024-07-23 | FDXM | Futures | 18951.8 | 19111.6 | 18900.9 | 19005.7 | 23706.0 |
| 2024-07-23 | FDXS | Futures | 18869.8 | 19061.6 | 18852.5 | 18956.1 | 25889.0 |
| 2024-07-23 | FESX | Futures | 4990.1 | 5021.4 | 4965.9 | 4985.1 | 589251.0 |
| 2024-07-23 | FEU3 | Futures | 97.533 | 97.548 | 97.533 | 97.548 | 812.0 |
| 2024-07-23 | FGBL | Futures | 133.18 | 133.77 | 133.08 | 133.68 | 727180.0 |
| 2024-07-23 | FGBM | Futures | 117.19 | 117.51 | 117.16 | 117.46 | 548426.0 |
| 2024-07-23 | FGBS | Futures | 106.429 | 106.56 | 106.424 | 106.535 | 592931.0 |
| 2024-07-23 | FGBX | Futures | 131.16 | 132.5 | 130.91 | 132.3 | 85397.0 |
| 2024-07-23 | FMWO | Futures | 11922.2 | 11968.3 | 11897.1 | 11961.0 | 2841.0 |
| 2024-07-23 | FOAT | Futures | 124.2 | 124.48 | 124.06 | 124.2 | 235282.0 |
| 2024-07-23 | FSMX | Futures | 25745.9 | 25786.2 | 25653.1 | 25682.4 | 149.0 |
| 2024-07-23 | FTDX | Futures | 3430.0 | 3441.7 | 3423.9 | 3431.5 | 7.0 |
| 2024-07-23 | FTI | Futures | 933.5 | 934.52 | 925.57 | 927.64 | 9283.0 |
| 2024-07-23 | FTUK | Futures | 8240.2 | 8260.2 | 8179.5 | 8190.5 | 75771.0 |
> showing 50 of 130 rows — these rows as CSV