PREVIEW / futures_daily / 2024-11-20
file: by_date/futures_daily/2024/2024-11-20.parquet size: 10 KB rows: 129
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-11-20 | ES | Futures | 6074.58 | 6095.04 | 6015.49 | 6074.58 | 1597257.0 |
| 2024-11-20 | NQ | Futures | 21296.19 | 21379.28 | 21003.61 | 21282.6 | 619493.0 |
| 2024-11-20 | YM | Futures | 43859.2 | 44048.1 | 43634.8 | 43973.4 | 104006.0 |
| 2024-11-20 | CL | Futures | 67.35 | 68.01 | 66.73 | 66.83 | 235637.0 |
| 2024-11-20 | GC | Futures | 2691.2 | 2714.9 | 2677.1 | 2707.5 | 182012.0 |
| 2024-11-20 | ZN | Futures | 109.857342 | 109.951211 | 109.591382 | 109.826053 | 1945465.0 |
| 2024-11-20 | A6 | Futures | 0.6532 | 0.6543 | 0.64835 | 0.6495 | 68776.0 |
| 2024-11-20 | AD | Futures | 0.71867 | 0.71897 | 0.71572 | 0.71732 | 62475.0 |
| 2024-11-20 | ALI | Futures | 2660.29 | 2703.46 | 2635.66 | 2655.47 | 2572.0 |
| 2024-11-20 | B | Futures | 72.81 | 73.37 | 72.14 | 72.24 | 260505.0 |
| 2024-11-20 | B6 | Futures | 1.2677 | 1.2718 | 1.2625 | 1.2641 | 76236.0 |
| 2024-11-20 | BFX | Futures | 4121.7 | 4121.7 | 4121.7 | 4121.7 | 0.0 |
| 2024-11-20 | BR | Futures | 0.16869 | 0.16889 | 0.16742 | 0.16791 | 3151.0 |
| 2024-11-20 | BTC | Futures | 99820.8 | 103318.3 | 99469.5 | 102426.4 | 13156.0 |
| 2024-11-20 | BZ | Futures | 71.32 | 71.9 | 70.7 | 70.81 | 26041.0 |
| 2024-11-20 | C | Futures | 7109.0 | 7158.0 | 7005.0 | 7066.0 | 3394.0 |
| 2024-11-20 | CB | Futures | 271.249 | 271.561 | 267.151 | 268.5 | 43.0 |
| 2024-11-20 | CC | Futures | 7464.0 | 7601.0 | 7296.0 | 7375.0 | 11324.0 |
| 2024-11-20 | CNH | Futures | 7.2061 | 7.222 | 7.1991 | 7.2181 | 1409.0 |
| 2024-11-20 | CSC | Futures | 1.932 | 1.933 | 1.906 | 1.932 | 242.0 |
| 2024-11-20 | CT | Futures | 73.22 | 75.61 | 73.18 | 75.05 | 11708.0 |
| 2024-11-20 | DC | Futures | 18.94 | 19.16 | 18.79 | 19.12 | 648.0 |
| 2024-11-20 | DX | Futures | 105.82 | 106.573 | 105.785 | 106.325 | 18292.0 |
| 2024-11-20 | E1 | Futures | 1.14687 | 1.14803 | 1.14228 | 1.1446 | 18174.0 |
| 2024-11-20 | E6 | Futures | 1.06527 | 1.06653 | 1.05618 | 1.0595 | 176136.0 |
| 2024-11-20 | E7 | Futures | 1.0652 | 1.0662 | 1.0559 | 1.0592 | 4388.0 |
| 2024-11-20 | EBM | Futures | 237.7 | 240.43 | 235.24 | 240.15 | 23958.0 |
| 2024-11-20 | ER | Futures | 97.78 | 97.795 | 97.77 | 97.785 | 229275.0 |
| 2024-11-20 | ESG | Futures | 526.14 | 526.14 | 519.74 | 523.57 | 251.0 |
| 2024-11-20 | EW | Futures | 3263.0 | 3280.0 | 3241.3 | 3277.2 | 6875.0 |
| 2024-11-20 | FBON | Futures | 124.66 | 124.71 | 124.35 | 124.64 | 59.0 |
| 2024-11-20 | FBTP | Futures | 119.76 | 119.86 | 119.32 | 119.62 | 223877.0 |
| 2024-11-20 | FBTS | Futures | 107.25 | 107.28 | 107.15 | 107.24 | 116174.0 |
| 2024-11-20 | FCE | Futures | 7321.6 | 7340.7 | 7245.6 | 7255.7 | 33332.0 |
| 2024-11-20 | FDAX | Futures | 19333.5 | 19448.6 | 19203.2 | 19243.6 | 41646.0 |
| 2024-11-20 | FDIV | Futures | 182.02 | 182.02 | 181.56 | 181.56 | 5.0 |
| 2024-11-20 | FDXM | Futures | 19285.6 | 19407.5 | 19162.7 | 19202.0 | 33712.0 |
| 2024-11-20 | FDXS | Futures | 19247.4 | 19363.0 | 19120.8 | 19159.0 | 30356.0 |
| 2024-11-20 | FESX | Futures | 4780.6 | 4810.7 | 4735.6 | 4749.6 | 608490.0 |
| 2024-11-20 | FEU3 | Futures | 97.775 | 97.79 | 97.775 | 97.79 | 17685.0 |
| 2024-11-20 | FGBL | Futures | 133.9 | 134.0 | 133.42 | 133.8 | 987910.0 |
| 2024-11-20 | FGBM | Futures | 117.93 | 118.01 | 117.68 | 117.9 | 686781.0 |
| 2024-11-20 | FGBS | Futures | 107.064 | 107.109 | 106.994 | 107.069 | 723033.0 |
| 2024-11-20 | FGBX | Futures | 133.86 | 134.1 | 132.68 | 133.68 | 104523.0 |
| 2024-11-20 | FMWO | Futures | 12333.4 | 12336.5 | 12187.2 | 12206.9 | 7548.0 |
| 2024-11-20 | FOAT | Futures | 124.4 | 124.45 | 123.82 | 124.21 | 213746.0 |
| 2024-11-20 | FSMX | Futures | 26403.7 | 26403.7 | 26089.6 | 26138.6 | 193.0 |
| 2024-11-20 | FTDX | Futures | 3385.8 | 3391.4 | 3371.6 | 3374.1 | 4.0 |
| 2024-11-20 | FTI | Futures | 869.75 | 871.11 | 860.39 | 862.29 | 7650.0 |
| 2024-11-20 | FTUK | Futures | 8140.5 | 8166.1 | 8108.5 | 8119.0 | 70535.0 |
> showing 50 of 129 rows — these rows as CSV