PREVIEW / futures_daily / 2024-08-27
file: by_date/futures_daily/2024/2024-08-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-08-27 | ES | Futures | 5815.24 | 5835.38 | 5796.13 | 5830.47 | 1027658.0 |
| 2024-08-27 | NQ | Futures | 20270.01 | 20410.44 | 20148.5 | 20368.46 | 441146.0 |
| 2024-08-27 | YM | Futures | 42105.5 | 42207.5 | 41994.4 | 42172.8 | 96513.0 |
| 2024-08-27 | CL | Futures | 72.77 | 73.03 | 71.07 | 71.2 | 331162.0 |
| 2024-08-27 | GC | Futures | 2607.5 | 2615.3 | 2591.9 | 2606.6 | 146222.0 |
| 2024-08-27 | ZN | Futures | 114.187282 | 114.234402 | 113.857442 | 114.108749 | 6299327.0 |
| 2024-08-27 | A6 | Futures | 0.67851 | 0.68096 | 0.67755 | 0.68061 | 71262.0 |
| 2024-08-27 | AD | Futures | 0.74585 | 0.74811 | 0.74554 | 0.7478 | 100775.0 |
| 2024-08-27 | ALI | Futures | 2532.08 | 2561.98 | 2520.48 | 2550.64 | 2776.0 |
| 2024-08-27 | B | Futures | 78.68 | 78.98 | 77.11 | 77.21 | 431214.0 |
| 2024-08-27 | B6 | Futures | 1.3187 | 1.3266 | 1.318 | 1.3259 | 93320.0 |
| 2024-08-27 | BFX | Futures | 4109.8 | 4109.8 | 4109.8 | 4109.8 | 0.0 |
| 2024-08-27 | BR | Futures | 0.17547 | 0.17547 | 0.17547 | 0.17547 | 0.0 |
| 2024-08-27 | BTC | Futures | 70230.8 | 70346.4 | 68166.3 | 68859.9 | 8770.0 |
| 2024-08-27 | BZ | Futures | 76.98 | 77.29 | 75.48 | 75.57 | 39690.0 |
| 2024-08-27 | C | Futures | 6278.0 | 6337.0 | 5600.0 | 5668.0 | 4157.0 |
| 2024-08-27 | CB | Futures | 311.218 | 313.319 | 311.192 | 312.282 | 54.0 |
| 2024-08-27 | CC | Futures | 6497.0 | 6749.0 | 6306.0 | 6408.0 | 14107.0 |
| 2024-08-27 | CNH | Futures | 7.019 | 7.0254 | 7.0106 | 7.0135 | 2114.0 |
| 2024-08-27 | CSC | Futures | 2.152 | 2.157 | 2.152 | 2.157 | 11.0 |
| 2024-08-27 | CT | Futures | 78.94 | 79.65 | 77.87 | 78.66 | 28.0 |
| 2024-08-27 | DC | Futures | 20.91 | 21.16 | 20.87 | 20.94 | 277.0 |
| 2024-08-27 | DX | Futures | 100.249 | 100.309 | 99.886 | 99.941 | 15215.0 |
| 2024-08-27 | E1 | Futures | 1.2053 | 1.21442 | 1.20362 | 1.21361 | 25034.0 |
| 2024-08-27 | E6 | Futures | 1.12547 | 1.12859 | 1.12441 | 1.12814 | 146141.0 |
| 2024-08-27 | E7 | Futures | 1.1254 | 1.1282 | 1.1242 | 1.1278 | 2515.0 |
| 2024-08-27 | EBM | Futures | 221.37 | 226.92 | 221.37 | 226.33 | 7705.0 |
| 2024-08-27 | ER | Futures | 97.629 | 97.629 | 97.619 | 97.629 | 100205.0 |
| 2024-08-27 | ESG | Futures | 502.33 | 502.87 | 499.66 | 502.29 | 566.0 |
| 2024-08-27 | EW | Futures | 3151.1 | 3159.0 | 3123.9 | 3138.4 | 5697.0 |
| 2024-08-27 | FBON | Futures | 125.1 | 125.14 | 124.51 | 124.7 | 45.0 |
| 2024-08-27 | FBTP | Futures | 118.95 | 118.98 | 118.32 | 118.49 | 254096.0 |
| 2024-08-27 | FBTS | Futures | 107.019 | 107.029 | 106.928 | 106.968 | 162200.0 |
| 2024-08-27 | FCE | Futures | 7746.6 | 7771.5 | 7707.9 | 7711.0 | 25903.0 |
| 2024-08-27 | FDAX | Futures | 19102.8 | 19208.1 | 19096.6 | 19179.5 | 31265.0 |
| 2024-08-27 | FDIV | Futures | 188.15 | 188.55 | 187.76 | 188.05 | 12.0 |
| 2024-08-27 | FDXM | Futures | 19006.8 | 19118.7 | 19006.8 | 19090.2 | 16433.0 |
| 2024-08-27 | FDXS | Futures | 18969.3 | 19068.8 | 18958.1 | 19040.3 | 13611.0 |
| 2024-08-27 | FESX | Futures | 4949.8 | 4971.9 | 4946.7 | 4957.8 | 345395.0 |
| 2024-08-27 | FEU3 | Futures | 97.629 | 97.634 | 97.629 | 97.634 | 1091.0 |
| 2024-08-27 | FGBL | Futures | 135.66 | 135.68 | 135.05 | 135.26 | 885653.0 |
| 2024-08-27 | FGBM | Futures | 118.55 | 118.58 | 118.33 | 118.44 | 703948.0 |
| 2024-08-27 | FGBS | Futures | 107.008 | 107.029 | 106.968 | 107.003 | 390222.0 |
| 2024-08-27 | FGBX | Futures | 136.57 | 136.57 | 134.64 | 135.12 | 95552.0 |
| 2024-08-27 | FMWO | Futures | 12084.6 | 12105.6 | 12034.3 | 12080.4 | 3519.0 |
| 2024-08-27 | FOAT | Futures | 126.06 | 126.07 | 125.32 | 125.53 | 220149.0 |
| 2024-08-27 | FSMX | Futures | 25590.6 | 25604.7 | 25524.0 | 25569.4 | 163.0 |
| 2024-08-27 | FTDX | Futures | 3415.7 | 3426.4 | 3413.2 | 3425.9 | 14.0 |
| 2024-08-27 | FTI | Futures | 919.17 | 920.53 | 915.69 | 918.08 | 6469.0 |
| 2024-08-27 | FTUK | Futures | 8368.0 | 8445.2 | 8367.5 | 8396.1 | 63403.0 |
> showing 50 of 130 rows — these rows as CSV