PREVIEW / futures_daily / 2024-08-02
file: by_date/futures_daily/2024/2024-08-02.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-02 | ES | Futures | 5644.03 | 5653.33 | 5507.17 | 5552.88 | 3239738.0 |
| 2024-08-02 | NQ | Futures | 19645.86 | 19669.95 | 19054.35 | 19231.05 | 842228.0 |
| 2024-08-02 | YM | Futures | 41218.4 | 41248.9 | 40298.5 | 40666.7 | 212531.0 |
| 2024-08-02 | CL | Futures | 71.3 | 71.69 | 67.69 | 68.2 | 467786.0 |
| 2024-08-02 | GC | Futures | 2543.2 | 2575.6 | 2504.7 | 2521.8 | 309937.0 |
| 2024-08-02 | ZN | Futures | 113.339123 | 114.846961 | 113.244883 | 114.737014 | 4296366.0 |
| 2024-08-02 | A6 | Futures | 0.65162 | 0.65642 | 0.65032 | 0.65317 | 161784.0 |
| 2024-08-02 | AD | Futures | 0.72529 | 0.72756 | 0.72449 | 0.72555 | 125743.0 |
| 2024-08-02 | ALI | Futures | 2277.17 | 2304.5 | 2257.57 | 2270.2 | 5084.0 |
| 2024-08-02 | B | Futures | 77.89 | 78.36 | 74.42 | 74.8 | 501310.0 |
| 2024-08-02 | B6 | Futures | 1.2739 | 1.2843 | 1.271 | 1.2808 | 166773.0 |
| 2024-08-02 | BFX | Futures | 3996.4 | 3996.4 | 3996.4 | 3996.4 | 0.0 |
| 2024-08-02 | BR | Futures | 0.16732 | 0.16872 | 0.16602 | 0.1679 | 22810.0 |
| 2024-08-02 | BTC | Futures | 73121.8 | 74091.9 | 70060.1 | 70592.8 | 11759.0 |
| 2024-08-02 | BZ | Futures | 76.36 | 76.75 | 72.9 | 73.28 | 58894.0 |
| 2024-08-02 | C | Futures | 5928.0 | 6136.0 | 5902.0 | 5955.0 | 2803.0 |
| 2024-08-02 | CB | Futures | 305.806 | 306.389 | 305.806 | 305.903 | 18.0 |
| 2024-08-02 | CC | Futures | 5339.0 | 5386.0 | 5197.0 | 5268.0 | 11475.0 |
| 2024-08-02 | CNH | Futures | 7.1246 | 7.1315 | 7.0293 | 7.0476 | 1636.0 |
| 2024-08-02 | CSC | Futures | 1.981 | 1.981 | 1.916 | 1.924 | 232.0 |
| 2024-08-02 | CT | Futures | 74.72 | 76.31 | 74.72 | 75.46 | 17.0 |
| 2024-08-02 | DC | Futures | 19.44 | 19.51 | 18.78 | 18.9 | 1297.0 |
| 2024-08-02 | DX | Futures | 103.617 | 103.686 | 102.383 | 102.461 | 34681.0 |
| 2024-08-02 | E1 | Futures | 1.17301 | 1.19425 | 1.1723 | 1.19201 | 71838.0 |
| 2024-08-02 | E6 | Futures | 1.08944 | 1.10315 | 1.08854 | 1.10179 | 402656.0 |
| 2024-08-02 | E7 | Futures | 1.0891 | 1.1027 | 1.0882 | 1.1014 | 7451.0 |
| 2024-08-02 | EBM | Futures | 257.0 | 259.04 | 255.83 | 256.71 | 14611.0 |
| 2024-08-02 | ER | Futures | 97.609 | 97.715 | 97.604 | 97.685 | 406981.0 |
| 2024-08-02 | ESG | Futures | 482.73 | 482.73 | 475.07 | 477.85 | 1128.0 |
| 2024-08-02 | EW | Futures | 3101.6 | 3102.9 | 2979.6 | 3013.2 | 18390.0 |
| 2024-08-02 | FBON | Futures | 125.18 | 125.4 | 124.91 | 125.18 | 197.0 |
| 2024-08-02 | FBTP | Futures | 118.96 | 119.18 | 118.38 | 118.76 | 316547.0 |
| 2024-08-02 | FBTS | Futures | 106.958 | 107.089 | 106.848 | 106.999 | 205164.0 |
| 2024-08-02 | FCE | Futures | 7504.6 | 7539.4 | 7411.4 | 7437.0 | 71463.0 |
| 2024-08-02 | FDAX | Futures | 18522.9 | 18556.6 | 18116.9 | 18134.2 | 74731.0 |
| 2024-08-02 | FDIV | Futures | 178.88 | 179.33 | 177.28 | 177.58 | 69.0 |
| 2024-08-02 | FDXM | Futures | 18442.8 | 18465.2 | 18032.5 | 18049.9 | 46541.0 |
| 2024-08-02 | FDXS | Futures | 18394.6 | 18422.0 | 17984.4 | 18002.7 | 43522.0 |
| 2024-08-02 | FESX | Futures | 4806.6 | 4809.6 | 4685.6 | 4693.7 | 1378231.0 |
| 2024-08-02 | FEU3 | Futures | 97.624 | 97.705 | 97.619 | 97.695 | 959.0 |
| 2024-08-02 | FGBL | Futures | 135.79 | 136.91 | 135.79 | 136.63 | 1398996.0 |
| 2024-08-02 | FGBM | Futures | 118.66 | 119.31 | 118.66 | 119.13 | 1037964.0 |
| 2024-08-02 | FGBS | Futures | 107.024 | 107.265 | 107.019 | 107.2 | 1107004.0 |
| 2024-08-02 | FGBX | Futures | 136.91 | 139.22 | 136.79 | 138.54 | 156378.0 |
| 2024-08-02 | FMWO | Futures | 11635.1 | 11635.1 | 11344.9 | 11359.6 | 7646.0 |
| 2024-08-02 | FOAT | Futures | 125.78 | 126.31 | 125.69 | 126.0 | 286110.0 |
| 2024-08-02 | FSMX | Futures | 24936.2 | 24994.6 | 24744.6 | 24773.8 | 897.0 |
| 2024-08-02 | FTDX | Futures | 3339.2 | 3352.5 | 3323.9 | 3326.5 | 20.0 |
| 2024-08-02 | FTI | Futures | 908.95 | 910.98 | 887.91 | 890.52 | 21734.0 |
| 2024-08-02 | FTUK | Futures | 8317.4 | 8323.9 | 8175.5 | 8184.5 | 130873.0 |
> showing 50 of 130 rows — these rows as CSV