PREVIEW / futures_daily / 2024-09-23
file: by_date/futures_daily/2024/2024-09-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-09-23 | ES | Futures | 5894.78 | 5917.79 | 5877.64 | 5909.87 | 1077941.0 |
| 2024-09-23 | NQ | Futures | 20555.37 | 20682.56 | 20468.44 | 20596.4 | 394947.0 |
| 2024-09-23 | YM | Futures | 42921.4 | 43009.3 | 42765.8 | 42947.7 | 91631.0 |
| 2024-09-23 | CL | Futures | 67.83 | 68.3 | 66.1 | 66.93 | 338267.0 |
| 2024-09-23 | GC | Futures | 2701.9 | 2715.8 | 2694.1 | 2708.3 | 170494.0 |
| 2024-09-23 | ZN | Futures | 114.863658 | 114.973171 | 114.503829 | 114.910592 | 1834960.0 |
| 2024-09-23 | A6 | Futures | 0.68098 | 0.68563 | 0.68023 | 0.68498 | 104939.0 |
| 2024-09-23 | AD | Futures | 0.74017 | 0.74458 | 0.73932 | 0.74378 | 97109.0 |
| 2024-09-23 | ALI | Futures | 2492.85 | 2500.31 | 2457.36 | 2497.74 | 1900.0 |
| 2024-09-23 | B | Futures | 73.33 | 73.78 | 71.75 | 72.54 | 273950.0 |
| 2024-09-23 | B6 | Futures | 1.3319 | 1.3352 | 1.3241 | 1.3339 | 117323.0 |
| 2024-09-23 | BFX | Futures | 4258.0 | 4258.0 | 4258.0 | 4258.0 | 0.0 |
| 2024-09-23 | BR | Futures | 0.17484 | 0.17508 | 0.1741 | 0.17508 | 851.0 |
| 2024-09-23 | BTC | Futures | 69294.9 | 71386.9 | 68738.8 | 69762.8 | 10084.0 |
| 2024-09-23 | BZ | Futures | 71.82 | 72.21 | 70.24 | 70.99 | 29116.0 |
| 2024-09-23 | C | Futures | 5195.0 | 5223.0 | 5127.0 | 5165.0 | 4622.0 |
| 2024-09-23 | CB | Futures | 302.944 | 302.944 | 299.313 | 299.573 | 20.0 |
| 2024-09-23 | CC | Futures | 6225.0 | 6510.0 | 6195.0 | 6376.0 | 8558.0 |
| 2024-09-23 | CNH | Futures | 6.9527 | 6.9806 | 6.9163 | 6.9641 | 602.0 |
| 2024-09-23 | CSC | Futures | 2.257 | 2.258 | 2.237 | 2.25 | 113.0 |
| 2024-09-23 | CT | Futures | 83.17 | 83.18 | 80.46 | 80.54 | 12.0 |
| 2024-09-23 | DC | Futures | 21.39 | 21.86 | 21.37 | 21.74 | 183.0 |
| 2024-09-23 | DX | Futures | 100.185 | 100.664 | 100.161 | 100.285 | 23443.0 |
| 2024-09-23 | E1 | Futures | 1.19861 | 1.20487 | 1.19609 | 1.20356 | 23294.0 |
| 2024-09-23 | E6 | Futures | 1.12447 | 1.12487 | 1.11649 | 1.11985 | 240087.0 |
| 2024-09-23 | E7 | Futures | 1.1241 | 1.1244 | 1.116 | 1.1195 | 4148.0 |
| 2024-09-23 | EBM | Futures | 236.6 | 241.52 | 236.33 | 240.7 | 37562.0 |
| 2024-09-23 | ER | Futures | 97.604 | 97.72 | 97.604 | 97.659 | 393536.0 |
| 2024-09-23 | ESG | Futures | 507.76 | 508.79 | 506.9 | 507.92 | 742.0 |
| 2024-09-23 | EW | Futures | 3171.0 | 3187.8 | 3159.5 | 3181.7 | 11658.0 |
| 2024-09-23 | FBON | Futures | 125.36 | 125.91 | 125.36 | 125.81 | 178.0 |
| 2024-09-23 | FBTP | Futures | 120.1 | 120.54 | 120.05 | 120.37 | 296488.0 |
| 2024-09-23 | FBTS | Futures | 107.44 | 107.59 | 107.42 | 107.57 | 148722.0 |
| 2024-09-23 | FCE | Futures | 7545.6 | 7558.6 | 7481.9 | 7535.5 | 33300.0 |
| 2024-09-23 | FDAX | Futures | 19099.2 | 19244.6 | 19034.6 | 19187.1 | 32849.0 |
| 2024-09-23 | FDIV | Futures | 191.05 | 191.4 | 191.05 | 191.4 | 145.0 |
| 2024-09-23 | FDXM | Futures | 19061.9 | 19202.0 | 18992.4 | 19145.6 | 19456.0 |
| 2024-09-23 | FDXS | Futures | 18998.1 | 19160.0 | 18941.8 | 19102.7 | 23224.0 |
| 2024-09-23 | FESX | Futures | 4909.9 | 4934.9 | 4888.8 | 4918.9 | 443302.0 |
| 2024-09-23 | FEU3 | Futures | 97.604 | 97.679 | 97.599 | 97.664 | 7460.0 |
| 2024-09-23 | FGBL | Futures | 135.91 | 136.58 | 135.77 | 136.25 | 1214981.0 |
| 2024-09-23 | FGBM | Futures | 118.86 | 119.3 | 118.79 | 119.12 | 970098.0 |
| 2024-09-23 | FGBS | Futures | 107.215 | 107.415 | 107.194 | 107.345 | 656673.0 |
| 2024-09-23 | FGBX | Futures | 135.23 | 136.47 | 134.97 | 135.55 | 109210.0 |
| 2024-09-23 | FMWO | Futures | 12208.0 | 12234.9 | 12147.8 | 12217.3 | 4474.0 |
| 2024-09-23 | FOAT | Futures | 125.8 | 126.26 | 125.72 | 126.0 | 262349.0 |
| 2024-09-23 | FSMX | Futures | 26038.6 | 26360.7 | 26038.6 | 26243.7 | 69.0 |
| 2024-09-23 | FTDX | Futures | 3346.8 | 3368.6 | 3346.8 | 3353.9 | 29.0 |
| 2024-09-23 | FTI | Futures | 909.66 | 915.1 | 906.08 | 913.44 | 6846.0 |
| 2024-09-23 | FTUK | Futures | 8279.3 | 8338.4 | 8274.8 | 8326.9 | 77961.0 |
> showing 50 of 130 rows — these rows as CSV