PREVIEW / futures_daily / 2024-07-01
file: by_date/futures_daily/2024/2024-07-01.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-07-01 | ES | Futures | 5716.34 | 5723.31 | 5685.61 | 5715.82 | 1432355.0 |
| 2024-07-01 | NQ | Futures | 20696.21 | 20804.0 | 20532.21 | 20781.2 | 639341.0 |
| 2024-07-01 | YM | Futures | 40341.4 | 40591.2 | 40162.9 | 40291.4 | 147942.0 |
| 2024-07-01 | CL | Futures | 74.4 | 76.4 | 74.34 | 76.17 | 345780.0 |
| 2024-07-01 | GC | Futures | 2442.5 | 2455.7 | 2434.1 | 2445.3 | 142601.0 |
| 2024-07-01 | ZN | Futures | 110.166382 | 110.323448 | 109.648063 | 109.742302 | 2221764.0 |
| 2024-07-01 | A6 | Futures | 0.66999 | 0.67195 | 0.66659 | 0.66729 | 105676.0 |
| 2024-07-01 | AD | Futures | 0.73605 | 0.73685 | 0.73223 | 0.73243 | 98365.0 |
| 2024-07-01 | ALI | Futures | 2573.48 | 2600.8 | 2568.54 | 2571.66 | 5666.0 |
| 2024-07-01 | B | Futures | 81.74 | 83.64 | 81.69 | 83.37 | 401364.0 |
| 2024-07-01 | B6 | Futures | 1.2651 | 1.2723 | 1.2637 | 1.2644 | 119685.0 |
| 2024-07-01 | BFX | Futures | 3934.6 | 3934.6 | 3934.6 | 3934.6 | 0.0 |
| 2024-07-01 | BR | Futures | 0.17147 | 0.17166 | 0.16925 | 0.17031 | 627.0 |
| 2024-07-01 | BTC | Futures | 70759.3 | 73323.7 | 70759.3 | 72594.3 | 9316.0 |
| 2024-07-01 | BZ | Futures | 80.09 | 81.96 | 80.07 | 81.69 | 55468.0 |
| 2024-07-01 | C | Futures | 6581.0 | 6675.0 | 6352.0 | 6619.0 | 4283.0 |
| 2024-07-01 | CB | Futures | 308.816 | 309.059 | 308.574 | 308.574 | 24.0 |
| 2024-07-01 | CC | Futures | 5215.0 | 5354.0 | 4876.0 | 5109.0 | 10787.0 |
| 2024-07-01 | CNH | Futures | 7.1661 | 7.1754 | 7.1651 | 7.1744 | 509.0 |
| 2024-07-01 | CSC | Futures | 1.937 | 1.954 | 1.926 | 1.95 | 107.0 |
| 2024-07-01 | CT | Futures | 80.94 | 81.67 | 80.83 | 81.15 | 22.0 |
| 2024-07-01 | DC | Futures | 18.72 | 18.9 | 18.55 | 18.8 | 279.0 |
| 2024-07-01 | DX | Futures | 104.855 | 105.114 | 104.567 | 105.046 | 18383.0 |
| 2024-07-01 | E1 | Futures | 1.14439 | 1.1449 | 1.13664 | 1.13782 | 33738.0 |
| 2024-07-01 | E6 | Futures | 1.08521 | 1.08975 | 1.084 | 1.08501 | 241963.0 |
| 2024-07-01 | E7 | Futures | 1.0836 | 1.0893 | 1.0836 | 1.0847 | 4265.0 |
| 2024-07-01 | EBM | Futures | 262.26 | 270.14 | 260.5 | 268.97 | 47401.0 |
| 2024-07-01 | ER | Futures | 97.533 | 97.533 | 97.503 | 97.523 | 146887.0 |
| 2024-07-01 | ESG | Futures | 491.46 | 492.58 | 489.86 | 492.06 | 265.0 |
| 2024-07-01 | EW | Futures | 3012.8 | 3024.4 | 2976.2 | 2979.5 | 15567.0 |
| 2024-07-01 | FBON | Futures | 121.26 | 121.8 | 121.14 | 121.28 | 274.0 |
| 2024-07-01 | FBTP | Futures | 115.11 | 115.29 | 114.59 | 114.68 | 252059.0 |
| 2024-07-01 | FBTS | Futures | 105.94 | 105.981 | 105.749 | 105.819 | 134917.0 |
| 2024-07-01 | FCE | Futures | 7893.4 | 7968.1 | 7794.0 | 7802.8 | 86094.0 |
| 2024-07-01 | FDAX | Futures | 18925.9 | 19055.7 | 18846.1 | 18910.5 | 43969.0 |
| 2024-07-01 | FDIV | Futures | 187.01 | 187.21 | 187.01 | 187.21 | 10.0 |
| 2024-07-01 | FDXM | Futures | 18803.2 | 18967.1 | 18758.4 | 18822.5 | 30486.0 |
| 2024-07-01 | FDXS | Futures | 18717.5 | 18916.5 | 18710.3 | 18773.3 | 28672.0 |
| 2024-07-01 | FESX | Futures | 5016.3 | 5063.7 | 5000.2 | 5013.3 | 731446.0 |
| 2024-07-01 | FEU3 | Futures | 97.523 | 97.528 | 97.518 | 97.528 | 464.0 |
| 2024-07-01 | FGBL | Futures | 132.51 | 132.61 | 131.67 | 131.77 | 1103578.0 |
| 2024-07-01 | FGBM | Futures | 117.07 | 117.08 | 116.58 | 116.62 | 715975.0 |
| 2024-07-01 | FGBS | Futures | 106.429 | 106.434 | 106.253 | 106.288 | 828111.0 |
| 2024-07-01 | FGBX | Futures | 129.99 | 130.37 | 128.04 | 128.16 | 113274.0 |
| 2024-07-01 | FMWO | Futures | 11798.6 | 11798.6 | 11706.4 | 11736.8 | 6570.0 |
| 2024-07-01 | FOAT | Futures | 122.82 | 123.06 | 122.14 | 122.2 | 242684.0 |
| 2024-07-01 | FSMX | Futures | 25922.3 | 25922.3 | 25686.4 | 25691.4 | 86.0 |
| 2024-07-01 | FTDX | Futures | 3420.8 | 3422.9 | 3409.1 | 3409.1 | 28.0 |
| 2024-07-01 | FTI | Futures | 946.72 | 951.79 | 936.68 | 938.07 | 11319.0 |
| 2024-07-01 | FTUK | Futures | 8225.1 | 8284.3 | 8207.1 | 8235.2 | 104542.0 |
> showing 50 of 129 rows — these rows as CSV