PREVIEW / futures_daily / 2024-04-18
file: by_date/futures_daily/2024/2024-04-18.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-04-18 | ES | Futures | 5289.44 | 5323.13 | 5263.84 | 5274.81 | 1701401.0 |
| 2024-04-18 | NQ | Futures | 18556.14 | 18662.2 | 18384.44 | 18427.49 | 756158.0 |
| 2024-04-18 | YM | Futures | 39098.5 | 39438.2 | 39009.0 | 39119.1 | 182149.0 |
| 2024-04-18 | CL | Futures | 74.31 | 74.82 | 73.21 | 74.15 | 366748.0 |
| 2024-04-18 | GC | Futures | 2486.1 | 2517.6 | 2485.4 | 2507.1 | 200546.0 |
| 2024-04-18 | ZN | Futures | 108.876682 | 109.096984 | 108.404605 | 108.467548 | 2240406.0 |
| 2024-04-18 | A6 | Futures | 0.64654 | 0.64864 | 0.64468 | 0.64498 | 76811.0 |
| 2024-04-18 | AD | Futures | 0.73092 | 0.73238 | 0.73027 | 0.73062 | 72716.0 |
| 2024-04-18 | ALI | Futures | 2710.84 | 2771.24 | 2702.1 | 2755.88 | 3415.0 |
| 2024-04-18 | B | Futures | 82.09 | 82.45 | 80.84 | 81.8 | 433240.0 |
| 2024-04-18 | B6 | Futures | 1.2456 | 1.2484 | 1.2433 | 1.2435 | 78143.0 |
| 2024-04-18 | BFX | Futures | 3824.4 | 3824.4 | 3824.4 | 3824.4 | 0.0 |
| 2024-04-18 | BR | Futures | 0.18387 | 0.18411 | 0.18299 | 0.18328 | 182.0 |
| 2024-04-18 | BTC | Futures | 71955.0 | 75428.3 | 71463.0 | 74573.2 | 12012.0 |
| 2024-04-18 | BZ | Futures | 80.95 | 81.27 | 79.71 | 80.64 | 38630.0 |
| 2024-04-18 | C | Futures | 7881.0 | 8588.0 | 7881.0 | 8475.0 | 2746.0 |
| 2024-04-18 | CB | Futures | 294.597 | 295.096 | 294.597 | 295.096 | 6.0 |
| 2024-04-18 | CC | Futures | 6526.0 | 6937.0 | 6408.0 | 6880.0 | 20015.0 |
| 2024-04-18 | CNH | Futures | 7.0966 | 7.104 | 7.0927 | 7.102 | 907.0 |
| 2024-04-18 | CSC | Futures | 1.69 | 1.706 | 1.69 | 1.695 | 406.0 |
| 2024-04-18 | CT | Futures | 95.7 | 96.04 | 93.01 | 93.84 | 8597.0 |
| 2024-04-18 | DC | Futures | 16.19 | 16.44 | 16.19 | 16.3 | 762.0 |
| 2024-04-18 | DX | Futures | 105.023 | 105.241 | 104.804 | 105.213 | 13617.0 |
| 2024-04-18 | E1 | Futures | 1.13725 | 1.13977 | 1.13422 | 1.13473 | 19161.0 |
| 2024-04-18 | E6 | Futures | 1.0801 | 1.08172 | 1.07682 | 1.07718 | 156472.0 |
| 2024-04-18 | E7 | Futures | 1.08 | 1.0815 | 1.0766 | 1.077 | 3218.0 |
| 2024-04-18 | EBM | Futures | 263.22 | 267.75 | 262.25 | 266.13 | 52564.0 |
| 2024-04-18 | ER | Futures | 97.513 | 97.523 | 97.498 | 97.503 | 193028.0 |
| 2024-04-18 | ESG | Futures | 448.49 | 449.01 | 444.33 | 445.19 | 419.0 |
| 2024-04-18 | EW | Futures | 2924.2 | 2946.5 | 2905.1 | 2915.2 | 10879.0 |
| 2024-04-18 | FBON | Futures | 122.87 | 122.96 | 122.53 | 122.65 | 56.0 |
| 2024-04-18 | FBTP | Futures | 116.53 | 116.77 | 115.93 | 116.17 | 185852.0 |
| 2024-04-18 | FBTS | Futures | 106.071 | 106.141 | 105.91 | 105.96 | 143701.0 |
| 2024-04-18 | FCE | Futures | 8184.6 | 8250.1 | 8155.7 | 8204.7 | 54586.0 |
| 2024-04-18 | FDAX | Futures | 18593.0 | 18682.9 | 18526.8 | 18668.4 | 58082.0 |
| 2024-04-18 | FDIV | Futures | 185.85 | 185.85 | 185.59 | 185.59 | 2.0 |
| 2024-04-18 | FDXM | Futures | 18466.2 | 18555.5 | 18399.5 | 18542.1 | 51673.0 |
| 2024-04-18 | FDXS | Futures | 18377.1 | 18454.7 | 18299.5 | 18440.4 | 34648.0 |
| 2024-04-18 | FESX | Futures | 4909.3 | 4946.6 | 4901.2 | 4935.5 | 841291.0 |
| 2024-04-18 | FEU3 | Futures | 97.528 | 97.528 | 97.513 | 97.518 | 1946.0 |
| 2024-04-18 | FGBL | Futures | 133.49 | 133.92 | 133.04 | 133.24 | 979451.0 |
| 2024-04-18 | FGBM | Futures | 117.46 | 117.65 | 117.19 | 117.28 | 741719.0 |
| 2024-04-18 | FGBS | Futures | 106.506 | 106.551 | 106.41 | 106.43 | 711362.0 |
| 2024-04-18 | FGBX | Futures | 134.15 | 135.11 | 133.13 | 133.68 | 102617.0 |
| 2024-04-18 | FMWO | Futures | 11149.0 | 11172.5 | 11068.8 | 11157.5 | 2941.0 |
| 2024-04-18 | FOAT | Futures | 125.41 | 125.86 | 125.05 | 125.24 | 239133.0 |
| 2024-04-18 | FSMX | Futures | 26649.3 | 26853.7 | 26556.3 | 26853.7 | 257.0 |
| 2024-04-18 | FTDX | Futures | 3339.3 | 3339.3 | 3289.5 | 3329.0 | 109.0 |
| 2024-04-18 | FTI | Futures | 879.03 | 880.61 | 870.22 | 875.06 | 12283.0 |
| 2024-04-18 | FTUK | Futures | 7908.0 | 7936.1 | 7878.0 | 7917.0 | 84125.0 |
> showing 50 of 130 rows — these rows as CSV