PREVIEW / futures_daily / 2024-08-23
file: by_date/futures_daily/2024/2024-08-23.parquet size: 10 KB rows: 129
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-23 | ES | Futures | 5781.93 | 5848.55 | 5781.93 | 5838.48 | 1415472.0 |
| 2024-08-23 | NQ | Futures | 20335.04 | 20628.07 | 20304.21 | 20510.45 | 581201.0 |
| 2024-08-23 | YM | Futures | 41644.6 | 42122.9 | 41642.6 | 42085.1 | 140263.0 |
| 2024-08-23 | CL | Futures | 68.77 | 70.76 | 68.65 | 70.54 | 313764.0 |
| 2024-08-23 | GC | Futures | 2574.1 | 2608.2 | 2572.8 | 2599.9 | 164613.0 |
| 2024-08-23 | ZN | Futures | 113.935976 | 114.407175 | 113.857442 | 114.297228 | 3189187.0 |
| 2024-08-23 | A6 | Futures | 0.67185 | 0.68126 | 0.6717 | 0.68056 | 122401.0 |
| 2024-08-23 | AD | Futures | 0.73866 | 0.74504 | 0.73866 | 0.74419 | 117221.0 |
| 2024-08-23 | ALI | Futures | 2483.89 | 2556.57 | 2481.57 | 2549.61 | 1545.0 |
| 2024-08-23 | B | Futures | 75.23 | 77.2 | 75.02 | 76.95 | 216340.0 |
| 2024-08-23 | B6 | Futures | 1.309 | 1.3229 | 1.3087 | 1.3202 | 185988.0 |
| 2024-08-23 | BFX | Futures | 4107.4 | 4107.4 | 4107.4 | 4107.4 | 0.0 |
| 2024-08-23 | BR | Futures | 0.17248 | 0.1761 | 0.17239 | 0.17596 | 26157.0 |
| 2024-08-23 | BTC | Futures | 67974.1 | 71776.0 | 67699.4 | 71568.5 | 19987.0 |
| 2024-08-23 | BZ | Futures | 73.57 | 75.61 | 73.51 | 75.39 | 19275.0 |
| 2024-08-23 | C | Futures | 6243.0 | 6329.0 | 6189.0 | 6208.0 | 2175.0 |
| 2024-08-23 | CB | Futures | 309.169 | 309.169 | 309.169 | 309.169 | 7.0 |
| 2024-08-23 | CC | Futures | 6346.0 | 6462.0 | 6263.0 | 6396.0 | 7278.0 |
| 2024-08-23 | CNH | Futures | 7.0367 | 7.0397 | 7.0056 | 7.0111 | 3271.0 |
| 2024-08-23 | CSC | Futures | 2.079 | 2.089 | 2.052 | 2.081 | 131.0 |
| 2024-08-23 | CT | Futures | 79.1 | 80.08 | 79.1 | 80.08 | 9.0 |
| 2024-08-23 | DC | Futures | 20.19 | 20.34 | 19.91 | 20.14 | 893.0 |
| 2024-08-23 | DX | Futures | 100.846 | 100.955 | 99.971 | 100.091 | 24724.0 |
| 2024-08-23 | E1 | Futures | 1.19853 | 1.20576 | 1.19578 | 1.20459 | 30256.0 |
| 2024-08-23 | E6 | Futures | 1.12083 | 1.12975 | 1.12012 | 1.12839 | 250831.0 |
| 2024-08-23 | E7 | Futures | 1.1205 | 1.1293 | 1.1198 | 1.128 | 5257.0 |
| 2024-08-23 | EBM | Futures | 230.13 | 231.59 | 226.33 | 227.21 | 10324.0 |
| 2024-08-23 | ER | Futures | 97.629 | 97.644 | 97.624 | 97.639 | 107816.0 |
| 2024-08-23 | ESG | Futures | 499.38 | 502.99 | 498.22 | 502.71 | 712.0 |
| 2024-08-23 | EW | Futures | 3100.4 | 3169.8 | 3100.3 | 3160.9 | 9848.0 |
| 2024-08-23 | FBON | Futures | 125.18 | 125.68 | 125.07 | 125.52 | 107.0 |
| 2024-08-23 | FBTP | Futures | 118.87 | 119.45 | 118.87 | 119.37 | 171595.0 |
| 2024-08-23 | FBTS | Futures | 106.979 | 107.15 | 106.979 | 107.15 | 103710.0 |
| 2024-08-23 | FCE | Futures | 7673.4 | 7730.8 | 7669.3 | 7722.7 | 26793.0 |
| 2024-08-23 | FDAX | Futures | 18962.7 | 19156.0 | 18927.9 | 19119.2 | 39631.0 |
| 2024-08-23 | FDIV | Futures | 185.56 | 187.06 | 185.56 | 187.06 | 14.0 |
| 2024-08-23 | FDXM | Futures | 18855.1 | 19066.8 | 18839.8 | 19030.2 | 18552.0 |
| 2024-08-23 | FDXS | Futures | 18787.5 | 19017.0 | 18787.5 | 18980.4 | 15275.0 |
| 2024-08-23 | FESX | Futures | 4928.6 | 4976.0 | 4924.6 | 4963.9 | 498302.0 |
| 2024-08-23 | FEU3 | Futures | 97.639 | 97.649 | 97.634 | 97.649 | 2325.0 |
| 2024-08-23 | FGBL | Futures | 135.66 | 135.99 | 135.46 | 135.95 | 643435.0 |
| 2024-08-23 | FGBM | Futures | 118.55 | 118.75 | 118.45 | 118.73 | 390851.0 |
| 2024-08-23 | FGBS | Futures | 107.013 | 107.089 | 106.968 | 107.079 | 423703.0 |
| 2024-08-23 | FGBX | Futures | 136.75 | 137.11 | 136.13 | 137.01 | 68687.0 |
| 2024-08-23 | FMWO | Futures | 12005.0 | 12118.1 | 12002.9 | 12097.2 | 8573.0 |
| 2024-08-23 | FOAT | Futures | 126.01 | 126.42 | 125.9 | 126.36 | 113457.0 |
| 2024-08-23 | FSMX | Futures | 25262.9 | 25495.8 | 25262.9 | 25468.6 | 95.0 |
| 2024-08-23 | FTDX | Futures | 3411.7 | 3420.3 | 3411.7 | 3420.3 | 2.0 |
| 2024-08-23 | FTI | Futures | 917.1 | 920.79 | 915.24 | 918.61 | 6677.0 |
| 2024-08-23 | FTUK | Futures | 8339.9 | 8384.1 | 8329.4 | 8375.0 | 49958.0 |
> showing 50 of 129 rows — these rows as CSV