PREVIEW / futures_daily / 2024-08-14
file: by_date/futures_daily/2024/2024-08-14.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-14 | ES | Futures | 5637.06 | 5668.31 | 5617.69 | 5657.2 | 1301826.0 |
| 2024-08-14 | NQ | Futures | 19793.8 | 19901.84 | 19613.73 | 19810.12 | 553997.0 |
| 2024-08-14 | YM | Futures | 40676.9 | 40984.8 | 40571.8 | 40911.4 | 121965.0 |
| 2024-08-14 | CL | Futures | 72.68 | 73.07 | 71.32 | 71.49 | 344944.0 |
| 2024-08-14 | GC | Futures | 2559.0 | 2572.7 | 2528.3 | 2531.9 | 187384.0 |
| 2024-08-14 | ZN | Futures | 114.281522 | 114.658481 | 114.014509 | 114.360055 | 2029311.0 |
| 2024-08-14 | A6 | Futures | 0.66484 | 0.66589 | 0.66113 | 0.66198 | 112520.0 |
| 2024-08-14 | AD | Futures | 0.73389 | 0.73489 | 0.73293 | 0.73364 | 69184.0 |
| 2024-08-14 | ALI | Futures | 2318.94 | 2361.24 | 2311.72 | 2327.97 | 1273.0 |
| 2024-08-14 | B | Futures | 78.88 | 79.31 | 77.52 | 77.67 | 359131.0 |
| 2024-08-14 | B6 | Futures | 1.2865 | 1.287 | 1.2816 | 1.2831 | 82157.0 |
| 2024-08-14 | BFX | Futures | 4030.7 | 4030.7 | 4030.7 | 4030.7 | 0.0 |
| 2024-08-14 | BR | Futures | 0.17678 | 0.17745 | 0.17562 | 0.1762 | 30970.0 |
| 2024-08-14 | BTC | Futures | 68714.3 | 69757.3 | 66005.9 | 66258.2 | 7782.0 |
| 2024-08-14 | BZ | Futures | 77.26 | 77.69 | 75.95 | 76.09 | 50327.0 |
| 2024-08-14 | C | Futures | 6484.0 | 6484.0 | 6327.0 | 6353.0 | 1789.0 |
| 2024-08-14 | CB | Futures | 308.744 | 309.302 | 307.36 | 308.549 | 35.0 |
| 2024-08-14 | CC | Futures | 5800.0 | 5817.0 | 5636.0 | 5705.0 | 8139.0 |
| 2024-08-14 | CNH | Futures | 7.0343 | 7.0382 | 7.0165 | 7.0338 | 3469.0 |
| 2024-08-14 | CSC | Futures | 2.025 | 2.029 | 2.006 | 2.025 | 143.0 |
| 2024-08-14 | CT | Futures | 75.23 | 75.88 | 74.27 | 74.34 | 31.0 |
| 2024-08-14 | DC | Futures | 19.68 | 19.72 | 19.51 | 19.69 | 712.0 |
| 2024-08-14 | DX | Futures | 101.901 | 102.01 | 101.577 | 101.861 | 13038.0 |
| 2024-08-14 | E1 | Futures | 1.18304 | 1.18748 | 1.18075 | 1.18243 | 26123.0 |
| 2024-08-14 | E6 | Futures | 1.10944 | 1.11484 | 1.10869 | 1.11171 | 251997.0 |
| 2024-08-14 | E7 | Futures | 1.1092 | 1.115 | 1.1084 | 1.1114 | 4228.0 |
| 2024-08-14 | EBM | Futures | 245.32 | 245.32 | 240.06 | 240.94 | 28774.0 |
| 2024-08-14 | ER | Futures | 97.649 | 97.659 | 97.634 | 97.654 | 127866.0 |
| 2024-08-14 | ESG | Futures | 485.43 | 487.08 | 483.21 | 486.52 | 182.0 |
| 2024-08-14 | EW | Futures | 3018.5 | 3044.4 | 3003.7 | 3014.8 | 7547.0 |
| 2024-08-14 | FBON | Futures | 125.74 | 125.74 | 125.32 | 125.67 | 36.0 |
| 2024-08-14 | FBTP | Futures | 119.36 | 119.51 | 118.97 | 119.33 | 162150.0 |
| 2024-08-14 | FBTS | Futures | 107.15 | 107.15 | 106.989 | 107.089 | 87446.0 |
| 2024-08-14 | FCE | Futures | 7451.7 | 7492.0 | 7442.7 | 7482.3 | 51240.0 |
| 2024-08-14 | FDAX | Futures | 18338.8 | 18402.2 | 18301.0 | 18358.2 | 30997.0 |
| 2024-08-14 | FDIV | Futures | 176.38 | 177.03 | 176.38 | 177.03 | 39.0 |
| 2024-08-14 | FDXM | Futures | 18239.2 | 18326.7 | 18215.8 | 18272.8 | 21747.0 |
| 2024-08-14 | FDXS | Futures | 18195.6 | 18269.7 | 18167.1 | 18225.0 | 15950.0 |
| 2024-08-14 | FESX | Futures | 4768.3 | 4792.5 | 4757.2 | 4781.4 | 560379.0 |
| 2024-08-14 | FEU3 | Futures | 97.664 | 97.664 | 97.644 | 97.654 | 1333.0 |
| 2024-08-14 | FGBL | Futures | 136.33 | 136.57 | 135.96 | 136.49 | 690667.0 |
| 2024-08-14 | FGBM | Futures | 118.96 | 119.08 | 118.79 | 119.04 | 553555.0 |
| 2024-08-14 | FGBS | Futures | 107.149 | 107.2 | 107.094 | 107.165 | 396960.0 |
| 2024-08-14 | FGBX | Futures | 138.24 | 138.68 | 137.07 | 138.34 | 85460.0 |
| 2024-08-14 | FMWO | Futures | 11651.9 | 11696.9 | 11611.0 | 11664.5 | 6912.0 |
| 2024-08-14 | FOAT | Futures | 126.44 | 126.78 | 126.02 | 126.54 | 176050.0 |
| 2024-08-14 | FSMX | Futures | 24686.1 | 24856.5 | 24686.1 | 24777.8 | 154.0 |
| 2024-08-14 | FTDX | Futures | 3360.2 | 3379.5 | 3360.2 | 3367.3 | 29.0 |
| 2024-08-14 | FTI | Futures | 900.11 | 901.72 | 893.56 | 899.43 | 7812.0 |
| 2024-08-14 | FTUK | Futures | 8284.8 | 8338.4 | 8269.3 | 8304.4 | 76268.0 |
> showing 50 of 130 rows — these rows as CSV