PREVIEW / futures_daily / 2024-12-27
file: by_date/futures_daily/2024/2024-12-27.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-12-27 | ES | Futures | 6161.16 | 6164.45 | 6050.67 | 6095.42 | 1641100.0 |
| 2024-12-27 | NQ | Futures | 22284.07 | 22301.55 | 21785.51 | 21987.92 | 572604.0 |
| 2024-12-27 | YM | Futures | 43668.0 | 43710.0 | 43076.0 | 43344.0 | 107133.0 |
| 2024-12-27 | CL | Futures | 68.01 | 69.06 | 67.78 | 68.91 | 172641.0 |
| 2024-12-27 | GC | Futures | 2679.1 | 2680.0 | 2650.3 | 2657.1 | 93897.0 |
| 2024-12-27 | ZN | Futures | 108.609375 | 108.71875 | 108.359375 | 108.4375 | 989566.0 |
| 2024-12-27 | A6 | Futures | 0.6218 | 0.62265 | 0.6201 | 0.62195 | 56788.0 |
| 2024-12-27 | AD | Futures | 0.6962 | 0.69775 | 0.69415 | 0.69595 | 57133.0 |
| 2024-12-27 | ALI | Futures | 2529.12 | 2576.18 | 2526.1 | 2550.0 | 3389.0 |
| 2024-12-27 | B | Futures | 72.78 | 73.93 | 72.63 | 73.79 | 271155.0 |
| 2024-12-27 | B6 | Futures | 1.2518 | 1.2584 | 1.2496 | 1.2572 | 57803.0 |
| 2024-12-27 | BFX | Futures | 4229.9 | 4229.9 | 4229.9 | 4229.9 | 0.0 |
| 2024-12-27 | BR | Futures | 0.15756 | 0.15756 | 0.15756 | 0.15756 | 0.0 |
| 2024-12-27 | BTC | Futures | 101904.3 | 103641.8 | 98966.5 | 100361.7 | 7880.0 |
| 2024-12-27 | BZ | Futures | 71.48 | 72.55 | 71.3 | 72.43 | 24950.0 |
| 2024-12-27 | C | Futures | 8820.0 | 8950.0 | 8069.0 | 8117.0 | 7777.0 |
| 2024-12-27 | CB | Futures | 272.25 | 272.25 | 270.525 | 271.0 | 26.0 |
| 2024-12-27 | CC | Futures | 9684.0 | 9778.0 | 8538.0 | 8792.0 | 13447.0 |
| 2024-12-27 | CNH | Futures | 7.286 | 7.2915 | 7.2755 | 7.2795 | 1376.0 |
| 2024-12-27 | CSC | Futures | 1.912 | 1.948 | 1.909 | 1.948 | 49.0 |
| 2024-12-27 | CT | Futures | 76.22 | 76.58 | 75.81 | 76.46 | 8142.0 |
| 2024-12-27 | DC | Futures | 19.29 | 19.66 | 19.18 | 19.64 | 395.0 |
| 2024-12-27 | DX | Futures | 107.895 | 107.995 | 107.66 | 107.792 | 12300.0 |
| 2024-12-27 | E1 | Futures | 1.12275 | 1.12285 | 1.11755 | 1.1187 | 14785.0 |
| 2024-12-27 | E6 | Futures | 1.0461 | 1.0482 | 1.04425 | 1.0466 | 141014.0 |
| 2024-12-27 | E7 | Futures | 1.0462 | 1.0481 | 1.0444 | 1.0466 | 2818.0 |
| 2024-12-27 | EBM | Futures | 239.29 | 241.62 | 237.47 | 241.36 | 16654.0 |
| 2024-12-27 | ER | Futures | 97.74 | 97.755 | 97.735 | 97.745 | 130036.0 |
| 2024-12-27 | ESG | Futures | 534.3 | 534.3 | 526.14 | 528.72 | 434.0 |
| 2024-12-27 | EW | Futures | 3195.1 | 3195.5 | 3142.1 | 3162.1 | 6239.0 |
| 2024-12-27 | FBON | Futures | 124.58 | 124.71 | 124.03 | 124.35 | 113.0 |
| 2024-12-27 | FBTP | Futures | 120.31 | 120.31 | 119.41 | 119.85 | 163565.0 |
| 2024-12-27 | FBTS | Futures | 107.46 | 107.49 | 107.29 | 107.43 | 95448.0 |
| 2024-12-27 | FCE | Futures | 7314.8 | 7381.9 | 7292.7 | 7374.9 | 30788.0 |
| 2024-12-27 | FDAX | Futures | 20164.0 | 20166.0 | 19964.0 | 20103.0 | 31031.0 |
| 2024-12-27 | FDIV | Futures | 185.5 | 185.5 | 185.5 | 185.5 | 0.0 |
| 2024-12-27 | FDXM | Futures | 20172.0 | 20192.0 | 19964.0 | 20103.0 | 17803.0 |
| 2024-12-27 | FDXS | Futures | 20120.0 | 20190.0 | 19963.0 | 20103.0 | 11999.0 |
| 2024-12-27 | FESX | Futures | 4934.0 | 4935.0 | 4867.0 | 4913.0 | 372990.0 |
| 2024-12-27 | FEU3 | Futures | 97.74 | 97.75 | 97.74 | 97.75 | 23079.0 |
| 2024-12-27 | FGBL | Futures | 133.71 | 133.79 | 132.81 | 133.02 | 540218.0 |
| 2024-12-27 | FGBM | Futures | 117.99 | 118.01 | 117.56 | 117.65 | 375355.0 |
| 2024-12-27 | FGBS | Futures | 107.035 | 107.055 | 106.925 | 106.95 | 325727.0 |
| 2024-12-27 | FGBX | Futures | 133.0 | 133.38 | 131.0 | 131.46 | 69663.0 |
| 2024-12-27 | FMWO | Futures | 12371.6 | 12390.0 | 12200.0 | 12263.3 | 3727.0 |
| 2024-12-27 | FOAT | Futures | 123.71 | 123.77 | 123.02 | 123.25 | 94896.0 |
| 2024-12-27 | FSMX | Futures | 25757.0 | 26024.0 | 25757.0 | 25876.0 | 997.0 |
| 2024-12-27 | FTDX | Futures | 3478.0 | 3478.0 | 3469.0 | 3474.0 | 2.0 |
| 2024-12-27 | FTI | Futures | 878.18 | 883.58 | 875.88 | 882.35 | 8992.0 |
| 2024-12-27 | FTUK | Futures | 8156.5 | 8173.5 | 8128.5 | 8155.0 | 57961.0 |
> showing 50 of 130 rows — these rows as CSV