PREVIEW / futures_daily / 2024-07-29
file: by_date/futures_daily/2024/2024-07-29.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-29 | ES | Futures | 5677.34 | 5716.59 | 5661.33 | 5684.06 | 1697647.0 |
| 2024-07-29 | NQ | Futures | 19868.94 | 20081.91 | 19808.31 | 19907.8 | 600017.0 |
| 2024-07-29 | YM | Futures | 41664.0 | 41861.8 | 41408.0 | 41576.3 | 130218.0 |
| 2024-07-29 | CL | Futures | 71.7 | 72.06 | 69.89 | 70.32 | 362635.0 |
| 2024-07-29 | GC | Futures | 2484.8 | 2500.8 | 2465.3 | 2476.5 | 149089.0 |
| 2024-07-29 | ZN | Futures | 111.815579 | 112.098299 | 111.784166 | 111.925526 | 1565130.0 |
| 2024-07-29 | A6 | Futures | 0.65672 | 0.65858 | 0.65412 | 0.65632 | 96524.0 |
| 2024-07-29 | AD | Futures | 0.72725 | 0.72841 | 0.7258 | 0.7265 | 67527.0 |
| 2024-07-29 | ALI | Futures | 2318.17 | 2340.09 | 2265.82 | 2277.17 | 1639.0 |
| 2024-07-29 | B | Futures | 78.49 | 78.75 | 76.58 | 76.98 | 415093.0 |
| 2024-07-29 | B6 | Futures | 1.2864 | 1.289 | 1.2808 | 1.2866 | 121586.0 |
| 2024-07-29 | BFX | Futures | 4099.3 | 4099.3 | 4099.3 | 4099.3 | 0.0 |
| 2024-07-29 | BR | Futures | 0.16983 | 0.17113 | 0.16954 | 0.1707 | 20582.0 |
| 2024-07-29 | BTC | Futures | 77305.0 | 79430.3 | 75179.8 | 76105.0 | 12489.0 |
| 2024-07-29 | BZ | Futures | 76.39 | 77.14 | 75.02 | 75.41 | 52201.0 |
| 2024-07-29 | C | Futures | 6441.0 | 6464.0 | 6221.0 | 6256.0 | 3940.0 |
| 2024-07-29 | CB | Futures | 302.553 | 304.665 | 301.169 | 302.358 | 18.0 |
| 2024-07-29 | CC | Futures | 5605.0 | 5605.0 | 5352.0 | 5405.0 | 11261.0 |
| 2024-07-29 | CNH | Futures | 7.1429 | 7.1532 | 7.1394 | 7.1522 | 650.0 |
| 2024-07-29 | CSC | Futures | 2.015 | 2.021 | 2.009 | 2.021 | 95.0 |
| 2024-07-29 | CT | Futures | 75.0 | 76.09 | 75.0 | 75.84 | 23.0 |
| 2024-07-29 | DC | Futures | 19.74 | 19.9 | 19.7 | 19.9 | 671.0 |
| 2024-07-29 | DX | Futures | 103.532 | 103.98 | 103.353 | 103.78 | 14024.0 |
| 2024-07-29 | E1 | Futures | 1.15956 | 1.16165 | 1.15493 | 1.1561 | 23674.0 |
| 2024-07-29 | E6 | Futures | 1.0964 | 1.09776 | 1.09096 | 1.09287 | 203441.0 |
| 2024-07-29 | E7 | Futures | 1.0959 | 1.0974 | 1.0906 | 1.0926 | 2891.0 |
| 2024-07-29 | EBM | Futures | 251.45 | 255.54 | 251.16 | 252.33 | 27237.0 |
| 2024-07-29 | ER | Futures | 97.568 | 97.584 | 97.568 | 97.578 | 101869.0 |
| 2024-07-29 | ESG | Futures | 490.64 | 491.52 | 488.6 | 489.6 | 461.0 |
| 2024-07-29 | EW | Futures | 3148.8 | 3170.8 | 3132.9 | 3142.3 | 7369.0 |
| 2024-07-29 | FBON | Futures | 123.46 | 124.12 | 123.45 | 123.93 | 118.0 |
| 2024-07-29 | FBTP | Futures | 117.77 | 118.35 | 117.68 | 118.12 | 211205.0 |
| 2024-07-29 | FBTS | Futures | 106.626 | 106.716 | 106.606 | 106.676 | 84720.0 |
| 2024-07-29 | FCE | Futures | 7748.8 | 7752.4 | 7623.9 | 7639.3 | 36340.0 |
| 2024-07-29 | FDAX | Futures | 19036.3 | 19080.3 | 18835.9 | 18851.2 | 33338.0 |
| 2024-07-29 | FDIV | Futures | 185.06 | 185.26 | 185.06 | 185.26 | 2.0 |
| 2024-07-29 | FDXM | Futures | 18946.7 | 18990.5 | 18749.2 | 18763.5 | 24205.0 |
| 2024-07-29 | FDXS | Futures | 18887.0 | 18942.9 | 18700.2 | 18714.4 | 21492.0 |
| 2024-07-29 | FESX | Futures | 4952.8 | 4964.9 | 4875.2 | 4883.2 | 592859.0 |
| 2024-07-29 | FEU3 | Futures | 97.578 | 97.583 | 97.578 | 97.583 | 912.0 |
| 2024-07-29 | FGBL | Futures | 134.15 | 134.75 | 134.1 | 134.56 | 718223.0 |
| 2024-07-29 | FGBM | Futures | 117.83 | 118.06 | 117.8 | 117.98 | 557714.0 |
| 2024-07-29 | FGBS | Futures | 106.701 | 106.782 | 106.701 | 106.747 | 347143.0 |
| 2024-07-29 | FGBX | Futures | 132.93 | 134.64 | 132.67 | 134.11 | 103894.0 |
| 2024-07-29 | FMWO | Futures | 11795.4 | 11798.6 | 11692.8 | 11714.8 | 3717.0 |
| 2024-07-29 | FOAT | Futures | 124.55 | 125.16 | 124.53 | 124.89 | 151253.0 |
| 2024-07-29 | FSMX | Futures | 25588.6 | 25603.7 | 25380.8 | 25437.3 | 193.0 |
| 2024-07-29 | FTDX | Futures | 3441.2 | 3443.8 | 3428.0 | 3428.0 | 4.0 |
| 2024-07-29 | FTI | Futures | 922.47 | 925.21 | 915.61 | 916.25 | 8474.0 |
| 2024-07-29 | FTUK | Futures | 8349.5 | 8396.1 | 8304.4 | 8322.4 | 86799.0 |
> showing 50 of 130 rows — these rows as CSV