PREVIEW / futures_daily / 2024-07-31
file: by_date/futures_daily/2024/2024-07-31.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-31 | ES | Futures | 5634.22 | 5772.37 | 5630.86 | 5740.87 | 2156505.0 |
| 2024-07-31 | NQ | Futures | 19551.81 | 20362.51 | 19547.66 | 20214.56 | 762246.0 |
| 2024-07-31 | YM | Futures | 41586.5 | 42245.2 | 41559.0 | 41884.3 | 169551.0 |
| 2024-07-31 | CL | Futures | 69.79 | 72.96 | 69.74 | 72.27 | 460315.0 |
| 2024-07-31 | GC | Futures | 2507.3 | 2549.1 | 2500.7 | 2525.0 | 176268.0 |
| 2024-07-31 | ZN | Futures | 112.145418 | 112.915044 | 112.051179 | 112.396725 | 3268894.0 |
| 2024-07-31 | A6 | Futures | 0.65542 | 0.65733 | 0.64961 | 0.65622 | 174495.0 |
| 2024-07-31 | AD | Futures | 0.72665 | 0.72992 | 0.7261 | 0.72947 | 112062.0 |
| 2024-07-31 | ALI | Futures | 2251.38 | 2331.58 | 2248.8 | 2306.82 | 1241.0 |
| 2024-07-31 | B | Futures | 76.51 | 79.46 | 76.41 | 78.73 | 513538.0 |
| 2024-07-31 | B6 | Futures | 1.2835 | 1.2867 | 1.2822 | 1.2857 | 115007.0 |
| 2024-07-31 | BFX | Futures | 4111.7 | 4111.7 | 4111.7 | 4111.7 | 0.0 |
| 2024-07-31 | BR | Futures | 0.17137 | 0.17181 | 0.1692 | 0.1706 | 18860.0 |
| 2024-07-31 | BTC | Futures | 74955.5 | 75544.3 | 72931.2 | 73665.7 | 7240.0 |
| 2024-07-31 | BZ | Futures | 74.91 | 77.85 | 74.86 | 77.12 | 54838.0 |
| 2024-07-31 | C | Futures | 6490.0 | 6523.0 | 6308.0 | 6354.0 | 3066.0 |
| 2024-07-31 | CB | Futures | 305.903 | 305.903 | 303.621 | 303.961 | 10.0 |
| 2024-07-31 | CC | Futures | 5692.0 | 5779.0 | 5576.0 | 5669.0 | 8340.0 |
| 2024-07-31 | CNH | Futures | 7.1246 | 7.1355 | 7.0974 | 7.1127 | 1448.0 |
| 2024-07-31 | CSC | Futures | 2.034 | 2.047 | 1.993 | 1.993 | 320.0 |
| 2024-07-31 | CT | Futures | 76.78 | 76.79 | 75.44 | 76.36 | 39.0 |
| 2024-07-31 | DC | Futures | 20.07 | 20.18 | 19.57 | 19.64 | 1012.0 |
| 2024-07-31 | DX | Futures | 103.696 | 103.771 | 103.089 | 103.327 | 22366.0 |
| 2024-07-31 | E1 | Futures | 1.15997 | 1.16761 | 1.15946 | 1.16461 | 51756.0 |
| 2024-07-31 | E6 | Futures | 1.09216 | 1.09579 | 1.0907 | 1.09322 | 258611.0 |
| 2024-07-31 | E7 | Futures | 1.0916 | 1.0954 | 1.0904 | 1.0929 | 5054.0 |
| 2024-07-31 | EBM | Futures | 250.87 | 258.17 | 250.87 | 257.29 | 36801.0 |
| 2024-07-31 | ER | Futures | 97.594 | 97.614 | 97.584 | 97.599 | 229252.0 |
| 2024-07-31 | ESG | Futures | 494.04 | 495.46 | 492.08 | 493.96 | 1269.0 |
| 2024-07-31 | EW | Futures | 3156.6 | 3219.4 | 3149.1 | 3174.3 | 15381.0 |
| 2024-07-31 | FBON | Futures | 124.24 | 124.74 | 124.15 | 124.6 | 378.0 |
| 2024-07-31 | FBTP | Futures | 118.25 | 118.68 | 118.22 | 118.57 | 245239.0 |
| 2024-07-31 | FBTS | Futures | 106.797 | 106.848 | 106.747 | 106.817 | 153888.0 |
| 2024-07-31 | FCE | Futures | 7724.3 | 7782.1 | 7708.4 | 7727.3 | 47775.0 |
| 2024-07-31 | FDAX | Futures | 18976.0 | 19108.9 | 18939.1 | 19029.1 | 42015.0 |
| 2024-07-31 | FDIV | Futures | 185.56 | 185.56 | 185.46 | 185.46 | 1.0 |
| 2024-07-31 | FDXM | Futures | 18878.5 | 19020.0 | 18849.0 | 18940.6 | 28288.0 |
| 2024-07-31 | FDXS | Futures | 18827.1 | 18969.3 | 18800.7 | 18891.1 | 27440.0 |
| 2024-07-31 | FESX | Futures | 4911.4 | 4992.1 | 4904.4 | 4938.7 | 723206.0 |
| 2024-07-31 | FEU3 | Futures | 97.604 | 97.609 | 97.599 | 97.604 | 654.0 |
| 2024-07-31 | FGBL | Futures | 134.8 | 135.44 | 134.75 | 135.12 | 1048629.0 |
| 2024-07-31 | FGBM | Futures | 118.13 | 118.51 | 118.13 | 118.29 | 815494.0 |
| 2024-07-31 | FGBS | Futures | 106.832 | 106.943 | 106.822 | 106.857 | 592715.0 |
| 2024-07-31 | FGBX | Futures | 134.19 | 135.82 | 134.13 | 135.54 | 135062.0 |
| 2024-07-31 | FMWO | Futures | 11788.1 | 11926.4 | 11788.1 | 11873.0 | 8187.0 |
| 2024-07-31 | FOAT | Futures | 125.07 | 125.69 | 125.01 | 125.45 | 237120.0 |
| 2024-07-31 | FSMX | Futures | 25837.6 | 25977.8 | 25686.4 | 25761.0 | 713.0 |
| 2024-07-31 | FTDX | Futures | 3426.4 | 3446.8 | 3426.4 | 3446.8 | 12.0 |
| 2024-07-31 | FTI | Futures | 928.93 | 948.24 | 928.93 | 932.98 | 13206.0 |
| 2024-07-31 | FTUK | Futures | 8325.4 | 8432.7 | 8311.9 | 8380.1 | 97178.0 |
> showing 50 of 130 rows — these rows as CSV