PREVIEW / futures_daily / 2024-08-01
file: by_date/futures_daily/2024/2024-08-01.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-08-01 | ES | Futures | 5758.17 | 5785.02 | 5623.89 | 5660.56 | 2751690.0 |
| 2024-08-01 | NQ | Futures | 20305.76 | 20434.01 | 19539.63 | 19715.04 | 920616.0 |
| 2024-08-01 | YM | Futures | 41923.0 | 42120.8 | 41080.7 | 41314.2 | 215461.0 |
| 2024-08-01 | CL | Futures | 72.9 | 73.17 | 70.72 | 70.78 | 383014.0 |
| 2024-08-01 | GC | Futures | 2545.9 | 2559.3 | 2526.0 | 2533.0 | 219834.0 |
| 2024-08-01 | ZN | Futures | 112.867924 | 113.40195 | 112.632324 | 113.323417 | 3433253.0 |
| 2024-08-01 | A6 | Futures | 0.65597 | 0.65798 | 0.65057 | 0.65082 | 141213.0 |
| 2024-08-01 | AD | Futures | 0.72896 | 0.73002 | 0.72449 | 0.72474 | 107853.0 |
| 2024-08-01 | ALI | Futures | 2332.87 | 2333.64 | 2268.14 | 2300.89 | 2824.0 |
| 2024-08-01 | B | Futures | 79.31 | 79.66 | 77.35 | 77.44 | 364930.0 |
| 2024-08-01 | B6 | Futures | 1.2857 | 1.2865 | 1.2729 | 1.273 | 206450.0 |
| 2024-08-01 | BFX | Futures | 4085.8 | 4085.8 | 4085.8 | 4085.8 | 0.0 |
| 2024-08-01 | BR | Futures | 0.16983 | 0.1707 | 0.16722 | 0.16742 | 24359.0 |
| 2024-08-01 | BTC | Futures | 73306.9 | 73705.0 | 70222.7 | 71540.5 | 11015.0 |
| 2024-08-01 | BZ | Futures | 77.76 | 78.04 | 75.79 | 75.86 | 44000.0 |
| 2024-08-01 | C | Futures | 6348.0 | 6376.0 | 5903.0 | 5936.0 | 6811.0 |
| 2024-08-01 | CB | Futures | 304.301 | 305.612 | 303.985 | 304.689 | 7.0 |
| 2024-08-01 | CC | Futures | 5620.0 | 5637.0 | 5270.0 | 5297.0 | 12323.0 |
| 2024-08-01 | CNH | Futures | 7.1083 | 7.1374 | 7.0955 | 7.1345 | 1449.0 |
| 2024-08-01 | CSC | Futures | 1.992 | 1.992 | 1.964 | 1.978 | 130.0 |
| 2024-08-01 | CT | Futures | 75.94 | 77.17 | 74.93 | 75.13 | 13.0 |
| 2024-08-01 | DC | Futures | 19.64 | 19.64 | 19.27 | 19.42 | 844.0 |
| 2024-08-01 | DX | Futures | 103.313 | 103.701 | 103.099 | 103.671 | 17983.0 |
| 2024-08-01 | E1 | Futures | 1.167 | 1.17352 | 1.16583 | 1.17316 | 41386.0 |
| 2024-08-01 | E6 | Futures | 1.09312 | 1.09398 | 1.08808 | 1.08884 | 264123.0 |
| 2024-08-01 | E7 | Futures | 1.0929 | 1.0935 | 1.0878 | 1.0885 | 4430.0 |
| 2024-08-01 | EBM | Futures | 257.58 | 261.38 | 254.95 | 257.29 | 25460.0 |
| 2024-08-01 | ER | Futures | 97.594 | 97.614 | 97.589 | 97.609 | 143215.0 |
| 2024-08-01 | ESG | Futures | 494.8 | 496.4 | 482.77 | 486.03 | 604.0 |
| 2024-08-01 | EW | Futures | 3175.0 | 3195.6 | 3078.7 | 3101.9 | 14955.0 |
| 2024-08-01 | FBON | Futures | 124.88 | 125.0 | 124.51 | 124.92 | 206.0 |
| 2024-08-01 | FBTP | Futures | 118.9 | 118.91 | 118.36 | 118.75 | 273151.0 |
| 2024-08-01 | FBTS | Futures | 106.858 | 106.908 | 106.767 | 106.858 | 161516.0 |
| 2024-08-01 | FCE | Futures | 7737.6 | 7738.1 | 7523.0 | 7559.4 | 62941.0 |
| 2024-08-01 | FDAX | Futures | 19059.8 | 19072.1 | 18490.2 | 18589.4 | 62769.0 |
| 2024-08-01 | FDIV | Futures | 182.37 | 182.37 | 180.52 | 180.52 | 10.0 |
| 2024-08-01 | FDXM | Futures | 18962.0 | 18978.3 | 18405.1 | 18502.9 | 38317.0 |
| 2024-08-01 | FDXS | Futures | 18935.7 | 18935.7 | 18357.0 | 18454.5 | 31751.0 |
| 2024-08-01 | FESX | Futures | 4959.8 | 4962.9 | 4796.5 | 4827.8 | 952570.0 |
| 2024-08-01 | FEU3 | Futures | 97.599 | 97.614 | 97.594 | 97.614 | 980.0 |
| 2024-08-01 | FGBL | Futures | 135.36 | 135.94 | 135.16 | 135.86 | 1048379.0 |
| 2024-08-01 | FGBM | Futures | 118.45 | 118.73 | 118.31 | 118.64 | 750474.0 |
| 2024-08-01 | FGBS | Futures | 106.923 | 107.034 | 106.857 | 106.983 | 744499.0 |
| 2024-08-01 | FGBX | Futures | 135.88 | 137.45 | 135.56 | 137.31 | 132754.0 |
| 2024-08-01 | FMWO | Futures | 11897.1 | 11898.1 | 11594.3 | 11715.8 | 6567.0 |
| 2024-08-01 | FOAT | Futures | 125.66 | 125.96 | 125.37 | 125.82 | 337470.0 |
| 2024-08-01 | FSMX | Futures | 25636.0 | 25673.3 | 25323.4 | 25334.5 | 156.0 |
| 2024-08-01 | FTDX | Futures | 3451.9 | 3451.9 | 3399.4 | 3399.4 | 17.0 |
| 2024-08-01 | FTI | Futures | 938.13 | 938.13 | 913.88 | 919.29 | 13408.0 |
| 2024-08-01 | FTUK | Futures | 8412.6 | 8431.7 | 8279.3 | 8297.3 | 109612.0 |
> showing 50 of 130 rows — these rows as CSV