PREVIEW / futures_daily / 2024-06-18
file: by_date/futures_daily/2024/2024-06-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-06-18 | ES | Futures | 5730.54 | 5745.77 | 5723.82 | 5742.67 | 1561429.0 |
| 2024-06-18 | NQ | Futures | 20927.32 | 21007.64 | 20858.92 | 20930.69 | 578901.0 |
| 2024-06-18 | YM | Futures | 40064.0 | 40168.0 | 39946.7 | 40063.0 | 124950.0 |
| 2024-06-18 | CL | Futures | 73.01 | 73.86 | 72.32 | 73.73 | 485710.0 |
| 2024-06-18 | GC | Futures | 2439.9 | 2455.1 | 2425.8 | 2453.7 | 154251.0 |
| 2024-06-18 | ZN | Futures | 110.9203 | 111.470033 | 110.778941 | 111.375793 | 1819290.0 |
| 2024-06-18 | A6 | Futures | 0.66378 | 0.66839 | 0.66263 | 0.66829 | 100384.0 |
| 2024-06-18 | AD | Futures | 0.73374 | 0.73459 | 0.73203 | 0.73424 | 94717.0 |
| 2024-06-18 | ALI | Futures | 2590.65 | 2594.81 | 2546.68 | 2565.67 | 6093.0 |
| 2024-06-18 | B | Futures | 80.38 | 81.51 | 79.77 | 81.36 | 402243.0 |
| 2024-06-18 | B6 | Futures | 1.2703 | 1.2724 | 1.2672 | 1.2713 | 85514.0 |
| 2024-06-18 | BFX | Futures | 3904.3 | 3904.3 | 3904.3 | 3904.3 | 0.0 |
| 2024-06-18 | BR | Futures | 0.17663 | 0.17663 | 0.17663 | 0.17663 | 0.0 |
| 2024-06-18 | BTC | Futures | 76297.3 | 76554.7 | 73305.8 | 73757.7 | 9773.0 |
| 2024-06-18 | BZ | Futures | 78.95 | 79.96 | 78.26 | 79.82 | 45690.0 |
| 2024-06-18 | C | Futures | 7583.0 | 7699.0 | 7394.0 | 7594.0 | 1259.0 |
| 2024-06-18 | CB | Futures | 300.101 | 301.047 | 299.105 | 301.047 | 72.0 |
| 2024-06-18 | CC | Futures | 6380.0 | 6650.0 | 6314.0 | 6578.0 | 10723.0 |
| 2024-06-18 | CNH | Futures | 7.1315 | 7.1379 | 7.131 | 7.1315 | 752.0 |
| 2024-06-18 | CSC | Futures | 1.955 | 1.963 | 1.929 | 1.934 | 231.0 |
| 2024-06-18 | CT | Futures | 82.58 | 84.86 | 81.27 | 83.78 | 9937.0 |
| 2024-06-18 | DC | Futures | 18.86 | 18.96 | 18.53 | 18.63 | 235.0 |
| 2024-06-18 | DX | Futures | 104.363 | 104.642 | 104.199 | 104.339 | 13072.0 |
| 2024-06-18 | E1 | Futures | 1.15707 | 1.16629 | 1.15661 | 1.16481 | 49105.0 |
| 2024-06-18 | E6 | Futures | 1.08612 | 1.08894 | 1.08375 | 1.08672 | 167608.0 |
| 2024-06-18 | E7 | Futures | 1.0858 | 1.0885 | 1.0834 | 1.0864 | 3216.0 |
| 2024-06-18 | EBM | Futures | 267.22 | 271.6 | 266.93 | 267.51 | 37150.0 |
| 2024-06-18 | ER | Futures | 97.503 | 97.503 | 97.482 | 97.498 | 154769.0 |
| 2024-06-18 | ESG | Futures | 493.6 | 496.24 | 493.6 | 495.36 | 3778.0 |
| 2024-06-18 | EW | Futures | 3008.8 | 3021.9 | 2996.7 | 3014.9 | 10881.0 |
| 2024-06-18 | FBON | Futures | 122.34 | 122.81 | 122.33 | 122.77 | 83.0 |
| 2024-06-18 | FBTP | Futures | 115.98 | 116.62 | 115.9 | 116.41 | 246310.0 |
| 2024-06-18 | FBTS | Futures | 105.9 | 106.031 | 105.84 | 105.981 | 160748.0 |
| 2024-06-18 | FCE | Futures | 7854.8 | 7886.7 | 7803.3 | 7872.3 | 57081.0 |
| 2024-06-18 | FDAX | Futures | 18785.7 | 18829.7 | 18682.4 | 18741.8 | 37454.0 |
| 2024-06-18 | FDIV | Futures | 184.26 | 185.66 | 184.26 | 185.01 | 7.0 |
| 2024-06-18 | FDXM | Futures | 18692.2 | 18743.1 | 18596.5 | 18654.5 | 4341.0 |
| 2024-06-18 | FDXS | Futures | 18640.3 | 18706.3 | 18549.9 | 18605.8 | 1365.0 |
| 2024-06-18 | FESX | Futures | 4994.1 | 5015.3 | 4966.9 | 4996.1 | 1336747.0 |
| 2024-06-18 | FEU3 | Futures | 97.503 | 97.503 | 97.487 | 97.503 | 1581.0 |
| 2024-06-18 | FGBL | Futures | 133.87 | 134.17 | 133.53 | 133.98 | 953907.0 |
| 2024-06-18 | FGBM | Futures | 117.54 | 117.65 | 117.3 | 117.54 | 776986.0 |
| 2024-06-18 | FGBS | Futures | 106.535 | 106.57 | 106.444 | 106.54 | 705867.0 |
| 2024-06-18 | FGBX | Futures | 134.58 | 135.28 | 133.81 | 134.84 | 93901.0 |
| 2024-06-18 | FMWO | Futures | 11766.1 | 11797.5 | 11744.1 | 11771.3 | 48662.0 |
| 2024-06-18 | FOAT | Futures | 123.59 | 124.31 | 123.55 | 123.99 | 247896.0 |
| 2024-06-18 | FSMX | Futures | 26114.9 | 26179.5 | 26065.5 | 26100.8 | 5867.0 |
| 2024-06-18 | FTDX | Futures | 3441.2 | 3441.2 | 3435.6 | 3440.7 | 578.0 |
| 2024-06-18 | FTI | Futures | 945.1 | 947.73 | 940.99 | 944.82 | 10948.0 |
| 2024-06-18 | FTUK | Futures | 8241.2 | 8272.8 | 8226.6 | 8262.2 | 229423.0 |
> showing 50 of 130 rows — these rows as CSV