PREVIEW / futures_daily / 2023-09-26
file: by_date/futures_daily/2023/2023-09-26.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 |
|---|---|---|---|---|---|---|---|
| 2023-09-26 | ES | Futures | 4690.39 | 4690.39 | 4608.5 | 4618.4 | 1758048.0 |
| 2023-09-26 | NQ | Futures | 16133.26 | 16133.26 | 15828.11 | 15880.72 | 667617.0 |
| 2023-09-26 | YM | Futures | 36089.6 | 36089.6 | 35585.5 | 35648.7 | 182086.0 |
| 2023-09-26 | CL | Futures | 79.25 | 80.0 | 77.76 | 79.7 | 318016.0 |
| 2023-09-26 | GC | Futures | 2083.5 | 2083.9 | 2064.2 | 2067.0 | 212263.0 |
| 2023-09-26 | ZN | Futures | 109.723763 | 110.040609 | 109.517813 | 109.612867 | 1603850.0 |
| 2023-09-26 | A6 | Futures | 0.64947 | 0.65012 | 0.64574 | 0.64639 | 93892.0 |
| 2023-09-26 | AD | Futures | 0.75014 | 0.75044 | 0.74606 | 0.74641 | 75924.0 |
| 2023-09-26 | ALI | Futures | 2462.07 | 2479.96 | 2449.13 | 2474.73 | 2587.0 |
| 2023-09-26 | B | Futures | 82.66 | 83.41 | 81.35 | 83.17 | 436801.0 |
| 2023-09-26 | B6 | Futures | 1.2223 | 1.2226 | 1.2161 | 1.2166 | 80996.0 |
| 2023-09-26 | BFX | Futures | 3841.9 | 3841.9 | 3841.9 | 3841.9 | 0.0 |
| 2023-09-26 | BR | Futures | 0.18757 | 0.18757 | 0.18738 | 0.18738 | 4.0 |
| 2023-09-26 | BTC | Futures | 35334.8 | 35481.7 | 34994.3 | 35274.8 | 4954.0 |
| 2023-09-26 | BZ | Futures | 82.5 | 83.24 | 81.19 | 82.99 | 30366.0 |
| 2023-09-26 | C | Futures | 2481.0 | 2510.0 | 2480.0 | 2492.0 | 4167.0 |
| 2023-09-26 | CB | Futures | 269.186 | 273.396 | 268.939 | 270.92 | 75.0 |
| 2023-09-26 | CC | Futures | 2042.0 | 2065.0 | 2035.0 | 2042.0 | 19988.0 |
| 2023-09-26 | CNH | Futures | 7.0682 | 7.0827 | 7.0607 | 7.0651 | 360.0 |
| 2023-09-26 | CSC | Futures | 2.034 | 2.034 | 2.002 | 2.003 | 61.0 |
| 2023-09-26 | CT | Futures | 107.29 | 108.28 | 106.32 | 107.51 | 22834.0 |
| 2023-09-26 | DC | Futures | 19.16 | 19.16 | 18.74 | 18.84 | 271.0 |
| 2023-09-26 | DX | Futures | 104.214 | 104.525 | 104.13 | 104.495 | 11634.0 |
| 2023-09-26 | E1 | Futures | 1.1606 | 1.16102 | 1.15577 | 1.15666 | 20455.0 |
| 2023-09-26 | E6 | Futures | 1.08162 | 1.08329 | 1.07841 | 1.07882 | 158317.0 |
| 2023-09-26 | E7 | Futures | 1.0817 | 1.0834 | 1.0786 | 1.0791 | 3870.0 |
| 2023-09-26 | EBM | Futures | 331.74 | 332.77 | 327.28 | 329.68 | 37995.0 |
| 2023-09-26 | ER | Futures | 97.761 | 97.761 | 97.751 | 97.756 | 83526.0 |
| 2023-09-26 | ESG | Futures | 402.45 | 402.85 | 397.84 | 398.38 | 2155.0 |
| 2023-09-26 | EW | Futures | 2653.0 | 2653.0 | 2606.6 | 2608.2 | 12008.0 |
| 2023-09-26 | FBON | Futures | 118.45 | 118.77 | 118.28 | 118.4 | 218.0 |
| 2023-09-26 | FBTP | Futures | 109.24 | 109.47 | 108.5 | 108.96 | 243607.0 |
| 2023-09-26 | FBTS | Futures | 105.471 | 105.491 | 105.329 | 105.39 | 178530.0 |
| 2023-09-26 | FCE | Futures | 7672.1 | 7676.5 | 7593.6 | 7637.7 | 64297.0 |
| 2023-09-26 | FDAX | Futures | 16370.7 | 16379.2 | 16152.7 | 16214.8 | 67471.0 |
| 2023-09-26 | FDIV | Futures | 177.05 | 177.74 | 176.7 | 177.0 | 53.0 |
| 2023-09-26 | FDXM | Futures | 16374.8 | 16374.8 | 16151.6 | 16208.4 | 47720.0 |
| 2023-09-26 | FDXS | Futures | 16260.6 | 16267.9 | 16044.0 | 16102.6 | 28189.0 |
| 2023-09-26 | FESX | Futures | 4221.7 | 4221.7 | 4168.3 | 4183.4 | 993676.0 |
| 2023-09-26 | FEU3 | Futures | 97.756 | 97.756 | 97.756 | 97.756 | 0.0 |
| 2023-09-26 | FGBL | Futures | 130.97 | 131.45 | 130.83 | 131.03 | 845942.0 |
| 2023-09-26 | FGBM | Futures | 117.08 | 117.27 | 116.99 | 117.09 | 605106.0 |
| 2023-09-26 | FGBS | Futures | 106.984 | 107.04 | 106.963 | 106.994 | 550439.0 |
| 2023-09-26 | FGBX | Futures | 125.93 | 127.2 | 125.6 | 126.16 | 99185.0 |
| 2023-09-26 | FMWO | Futures | 9968.6 | 9973.0 | 9847.2 | 9886.9 | 4690.0 |
| 2023-09-26 | FOAT | Futures | 122.15 | 122.6 | 122.0 | 122.19 | 166452.0 |
| 2023-09-26 | FSMX | Futures | 26804.1 | 27030.1 | 26585.3 | 26585.3 | 517.0 |
| 2023-09-26 | FTDX | Futures | 3117.3 | 3125.6 | 3106.9 | 3109.5 | 29.0 |
| 2023-09-26 | FTI | Futures | 753.6 | 753.86 | 747.94 | 750.64 | 15011.0 |
| 2023-09-26 | FTUK | Futures | 7742.7 | 7761.4 | 7692.4 | 7732.7 | 90845.0 |
> showing 50 of 130 rows — these rows as CSV