PREVIEW / futures_daily / 2025-01-27
file: by_date/futures_daily/2025/2025-01-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 |
|---|---|---|---|---|---|---|---|
| 2025-01-27 | ES | Futures | 6171.52 | 6174.56 | 6015.52 | 6115.39 | 2385614.0 |
| 2025-01-27 | NQ | Futures | 22061.39 | 22061.39 | 21040.7 | 21542.05 | 1056136.0 |
| 2025-01-27 | YM | Futures | 44475.0 | 44931.0 | 44009.0 | 44904.0 | 162119.0 |
| 2025-01-27 | CL | Futures | 74.25 | 74.85 | 72.09 | 72.88 | 334418.0 |
| 2025-01-27 | GC | Futures | 2805.5 | 2805.5 | 2760.2 | 2766.2 | 108672.0 |
| 2025-01-27 | ZN | Futures | 108.515625 | 109.375 | 108.5 | 109.15625 | 2872051.0 |
| 2025-01-27 | A6 | Futures | 0.63045 | 0.63085 | 0.62755 | 0.6285 | 82383.0 |
| 2025-01-27 | AD | Futures | 0.6973 | 0.69905 | 0.69575 | 0.69695 | 81305.0 |
| 2025-01-27 | ALI | Futures | 2647.15 | 2667.79 | 2611.91 | 2622.48 | 1278.0 |
| 2025-01-27 | B | Futures | 77.39 | 77.96 | 75.5 | 76.18 | 446185.0 |
| 2025-01-27 | B6 | Futures | 1.2468 | 1.252 | 1.2422 | 1.2486 | 114184.0 |
| 2025-01-27 | BFX | Futures | 4304.8 | 4304.8 | 4304.8 | 4304.8 | 0.0 |
| 2025-01-27 | BR | Futures | 0.1654 | 0.16668 | 0.16476 | 0.16584 | 6591.0 |
| 2025-01-27 | BTC | Futures | 109617.2 | 109617.2 | 102133.4 | 106017.9 | 14618.0 |
| 2025-01-27 | BZ | Futures | 76.96 | 77.51 | 75.06 | 75.75 | 46831.0 |
| 2025-01-27 | C | Futures | 9120.0 | 9214.0 | 8982.0 | 9055.0 | 3369.0 |
| 2025-01-27 | CB | Futures | 262.125 | 262.2 | 260.9 | 260.925 | 59.0 |
| 2025-01-27 | CC | Futures | 9987.0 | 10092.0 | 9810.0 | 9876.0 | 6735.0 |
| 2025-01-27 | CNH | Futures | 7.2255 | 7.261 | 7.2225 | 7.2345 | 1418.0 |
| 2025-01-27 | CSC | Futures | 1.858 | 1.899 | 1.842 | 1.899 | 251.0 |
| 2025-01-27 | CT | Futures | 75.13 | 75.66 | 74.6 | 74.66 | 19018.0 |
| 2025-01-27 | DC | Futures | 18.6 | 19.01 | 18.49 | 18.99 | 774.0 |
| 2025-01-27 | DX | Futures | 107.35 | 107.62 | 106.775 | 107.16 | 18517.0 |
| 2025-01-27 | E1 | Futures | 1.11045 | 1.12155 | 1.10815 | 1.1155 | 43944.0 |
| 2025-01-27 | E6 | Futures | 1.05095 | 1.05575 | 1.04775 | 1.0516 | 193625.0 |
| 2025-01-27 | E7 | Futures | 1.0511 | 1.0557 | 1.0476 | 1.0516 | 4371.0 |
| 2025-01-27 | EBM | Futures | 233.84 | 235.4 | 232.03 | 233.06 | 45084.0 |
| 2025-01-27 | ER | Futures | 97.52 | 97.545 | 97.52 | 97.52 | 219490.0 |
| 2025-01-27 | ESG | Futures | 525.08 | 527.62 | 520.46 | 527.22 | 1124.0 |
| 2025-01-27 | EW | Futures | 3277.8 | 3280.8 | 3236.7 | 3255.4 | 27542.0 |
| 2025-01-27 | FBON | Futures | 123.59 | 123.78 | 123.34 | 123.48 | 101.0 |
| 2025-01-27 | FBTP | Futures | 119.21 | 119.35 | 118.97 | 119.07 | 317526.0 |
| 2025-01-27 | FBTS | Futures | 107.07 | 107.12 | 107.02 | 107.06 | 203436.0 |
| 2025-01-27 | FCE | Futures | 7865.0 | 7960.0 | 7854.0 | 7925.0 | 49923.0 |
| 2025-01-27 | FDAX | Futures | 21434.0 | 21500.0 | 21192.0 | 21394.0 | 44258.0 |
| 2025-01-27 | FDIV | Futures | 193.4 | 194.9 | 193.4 | 194.9 | 12.0 |
| 2025-01-27 | FDXM | Futures | 21409.0 | 21503.0 | 21192.0 | 21394.0 | 23893.0 |
| 2025-01-27 | FDXS | Futures | 21443.0 | 21498.0 | 21192.0 | 21394.0 | 26178.0 |
| 2025-01-27 | FESX | Futures | 5201.0 | 5226.0 | 5144.0 | 5202.0 | 679589.0 |
| 2025-01-27 | FEU3 | Futures | 97.535 | 97.545 | 97.525 | 97.525 | 30022.0 |
| 2025-01-27 | FGBL | Futures | 131.38 | 132.14 | 131.38 | 131.63 | 1303751.0 |
| 2025-01-27 | FGBM | Futures | 116.68 | 117.11 | 116.68 | 116.85 | 829566.0 |
| 2025-01-27 | FGBS | Futures | 106.495 | 106.63 | 106.495 | 106.55 | 639781.0 |
| 2025-01-27 | FGBX | Futures | 127.36 | 128.74 | 127.34 | 127.78 | 124973.0 |
| 2025-01-27 | FMWO | Futures | 12420.6 | 12429.8 | 12245.9 | 12375.7 | 14334.0 |
| 2025-01-27 | FOAT | Futures | 122.44 | 122.97 | 122.44 | 122.59 | 219764.0 |
| 2025-01-27 | FSMX | Futures | 25982.0 | 26292.0 | 25930.0 | 26233.0 | 769.0 |
| 2025-01-27 | FTDX | Futures | 3569.0 | 3659.5 | 3569.0 | 3654.0 | 31.0 |
| 2025-01-27 | FTI | Futures | 889.5 | 899.15 | 886.1 | 895.28 | 12106.0 |
| 2025-01-27 | FTUK | Futures | 8448.5 | 8517.5 | 8419.5 | 8492.5 | 78616.0 |
> showing 50 of 130 rows — these rows as CSV