PREVIEW / futures_daily / 2024-08-06
file: by_date/futures_daily/2024/2024-08-06.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-08-06 | ES | Futures | 5422.73 | 5517.76 | 5393.55 | 5439.52 | 2172067.0 |
| 2024-08-06 | NQ | Futures | 18826.35 | 19155.4 | 18619.34 | 18840.08 | 697089.0 |
| 2024-08-06 | YM | Futures | 39787.6 | 40382.2 | 39525.6 | 39916.1 | 176254.0 |
| 2024-08-06 | CL | Futures | 68.51 | 69.16 | 66.97 | 67.9 | 352250.0 |
| 2024-08-06 | GC | Futures | 2503.3 | 2511.2 | 2472.7 | 2482.8 | 186107.0 |
| 2024-08-06 | ZN | Futures | 114.611361 | 114.689894 | 113.810322 | 113.983096 | 2774865.0 |
| 2024-08-06 | A6 | Futures | 0.65112 | 0.65587 | 0.64886 | 0.65492 | 140315.0 |
| 2024-08-06 | AD | Futures | 0.72781 | 0.73142 | 0.726 | 0.73077 | 111019.0 |
| 2024-08-06 | ALI | Futures | 2266.33 | 2318.17 | 2239.0 | 2302.44 | 5209.0 |
| 2024-08-06 | B | Futures | 75.42 | 75.81 | 73.6 | 74.48 | 393032.0 |
| 2024-08-06 | B6 | Futures | 1.2781 | 1.2805 | 1.2674 | 1.2699 | 147186.0 |
| 2024-08-06 | BFX | Futures | 3868.2 | 3868.2 | 3868.2 | 3868.2 | 0.0 |
| 2024-08-06 | BR | Futures | 0.16843 | 0.17084 | 0.16742 | 0.17022 | 25733.0 |
| 2024-08-06 | BTC | Futures | 61351.7 | 64396.5 | 60819.0 | 64088.1 | 11490.0 |
| 2024-08-06 | BZ | Futures | 73.68 | 74.22 | 72.11 | 72.96 | 45238.0 |
| 2024-08-06 | C | Futures | 6249.0 | 6426.0 | 6160.0 | 6418.0 | 3395.0 |
| 2024-08-06 | CB | Futures | 304.665 | 304.932 | 301.8 | 302.723 | 33.0 |
| 2024-08-06 | CC | Futures | 5487.0 | 5644.0 | 5380.0 | 5544.0 | 11173.0 |
| 2024-08-06 | CNH | Futures | 7.012 | 7.0397 | 7.0106 | 7.0397 | 1663.0 |
| 2024-08-06 | CSC | Futures | 1.875 | 1.939 | 1.866 | 1.911 | 252.0 |
| 2024-08-06 | CT | Futures | 74.91 | 74.91 | 74.36 | 74.36 | 7.0 |
| 2024-08-06 | DC | Futures | 18.31 | 18.92 | 18.23 | 18.71 | 1302.0 |
| 2024-08-06 | DX | Futures | 102.129 | 102.488 | 101.97 | 102.232 | 22556.0 |
| 2024-08-06 | E1 | Futures | 1.20169 | 1.20418 | 1.1943 | 1.20001 | 65844.0 |
| 2024-08-06 | E6 | Futures | 1.10567 | 1.10672 | 1.10073 | 1.1032 | 262991.0 |
| 2024-08-06 | E7 | Futures | 1.1056 | 1.1064 | 1.1004 | 1.1028 | 7082.0 |
| 2024-08-06 | EBM | Futures | 251.74 | 256.12 | 251.45 | 254.95 | 22442.0 |
| 2024-08-06 | ER | Futures | 97.69 | 97.695 | 97.624 | 97.664 | 204928.0 |
| 2024-08-06 | ESG | Futures | 466.82 | 473.29 | 462.76 | 466.74 | 866.0 |
| 2024-08-06 | EW | Futures | 2948.6 | 2996.6 | 2913.2 | 2959.6 | 17597.0 |
| 2024-08-06 | FBON | Futures | 124.88 | 125.5 | 124.79 | 125.19 | 364.0 |
| 2024-08-06 | FBTP | Futures | 118.56 | 118.89 | 118.22 | 118.63 | 294158.0 |
| 2024-08-06 | FBTS | Futures | 107.019 | 107.039 | 106.878 | 106.948 | 179096.0 |
| 2024-08-06 | FCE | Futures | 7389.4 | 7389.4 | 7247.6 | 7310.6 | 78722.0 |
| 2024-08-06 | FDAX | Futures | 17941.0 | 18057.5 | 17704.7 | 17803.9 | 51514.0 |
| 2024-08-06 | FDIV | Futures | 172.44 | 172.44 | 172.09 | 172.09 | 1.0 |
| 2024-08-06 | FDXM | Futures | 17837.1 | 17967.4 | 17622.3 | 17721.0 | 49871.0 |
| 2024-08-06 | FDXS | Futures | 17788.4 | 17920.4 | 17576.2 | 17674.7 | 32171.0 |
| 2024-08-06 | FESX | Futures | 4668.4 | 4701.7 | 4595.8 | 4626.1 | 1087430.0 |
| 2024-08-06 | FEU3 | Futures | 97.68 | 97.7 | 97.659 | 97.669 | 1194.0 |
| 2024-08-06 | FGBL | Futures | 136.14 | 137.0 | 135.85 | 136.43 | 1107569.0 |
| 2024-08-06 | FGBM | Futures | 118.9 | 119.32 | 118.68 | 118.98 | 905262.0 |
| 2024-08-06 | FGBS | Futures | 107.129 | 107.285 | 107.054 | 107.17 | 753378.0 |
| 2024-08-06 | FGBX | Futures | 138.52 | 140.15 | 137.86 | 138.96 | 128958.0 |
| 2024-08-06 | FMWO | Futures | 11243.3 | 11341.8 | 11110.2 | 11197.2 | 11433.0 |
| 2024-08-06 | FOAT | Futures | 125.72 | 126.52 | 125.55 | 126.16 | 264396.0 |
| 2024-08-06 | FSMX | Futures | 24538.9 | 24568.1 | 24112.3 | 24397.7 | 356.0 |
| 2024-08-06 | FTDX | Futures | 3295.9 | 3295.9 | 3286.2 | 3286.2 | 16.0 |
| 2024-08-06 | FTI | Futures | 881.76 | 886.54 | 869.3 | 878.89 | 19014.0 |
| 2024-08-06 | FTUK | Futures | 8069.2 | 8135.9 | 7962.4 | 8035.1 | 132970.0 |
> showing 50 of 130 rows — these rows as CSV