PREVIEW / futures_daily / 2023-06-28
file: by_date/futures_daily/2023/2023-06-28.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 |
|---|---|---|---|---|---|---|---|
| 2023-06-28 | ES | Futures | 4780.14 | 4797.74 | 4764.17 | 4783.93 | 1689461.0 |
| 2023-06-28 | NQ | Futures | 16509.14 | 16652.2 | 16435.83 | 16554.82 | 662146.0 |
| 2023-06-28 | YM | Futures | 36313.4 | 36365.5 | 36126.4 | 36241.1 | 150797.0 |
| 2023-06-28 | CL | Futures | 59.02 | 60.51 | 58.19 | 60.37 | 368295.0 |
| 2023-06-28 | GC | Futures | 2114.1 | 2117.4 | 2101.3 | 2113.1 | 162493.0 |
| 2023-06-28 | ZN | Futures | 114.853447 | 115.314642 | 114.821641 | 115.266932 | 1426850.0 |
| 2023-06-28 | A6 | Futures | 0.67876 | 0.67912 | 0.6698 | 0.67086 | 104133.0 |
| 2023-06-28 | AD | Futures | 0.76699 | 0.76709 | 0.76209 | 0.7635 | 75602.0 |
| 2023-06-28 | ALI | Futures | 2430.45 | 2450.69 | 2401.06 | 2409.94 | 1293.0 |
| 2023-06-28 | B | Futures | 63.68 | 65.2 | 62.96 | 65.04 | 450839.0 |
| 2023-06-28 | B6 | Futures | 1.2775 | 1.2779 | 1.2632 | 1.2674 | 128434.0 |
| 2023-06-28 | BFX | Futures | 3865.3 | 3865.3 | 3865.3 | 3865.3 | 0.0 |
| 2023-06-28 | BR | Futures | 0.18956 | 0.19054 | 0.18951 | 0.19054 | 89.0 |
| 2023-06-28 | BTC | Futures | 41659.4 | 41666.1 | 40546.2 | 40881.5 | 6418.0 |
| 2023-06-28 | BZ | Futures | 63.68 | 65.08 | 62.84 | 64.93 | 28984.0 |
| 2023-06-28 | C | Futures | 2028.0 | 2050.0 | 2022.0 | 2047.0 | 2035.0 |
| 2023-06-28 | CB | Futures | 229.545 | 229.545 | 228.33 | 228.973 | 60.0 |
| 2023-06-28 | CC | Futures | 1894.0 | 1942.0 | 1889.0 | 1935.0 | 22719.0 |
| 2023-06-28 | CNH | Futures | 6.9116 | 6.9514 | 6.9019 | 6.9286 | 695.0 |
| 2023-06-28 | CSC | Futures | 1.852 | 1.853 | 1.836 | 1.846 | 171.0 |
| 2023-06-28 | CT | Futures | 94.96 | 97.49 | 94.96 | 97.32 | 88.0 |
| 2023-06-28 | DC | Futures | 17.06 | 17.06 | 16.78 | 16.85 | 437.0 |
| 2023-06-28 | DX | Futures | 100.219 | 100.867 | 100.185 | 100.605 | 13319.0 |
| 2023-06-28 | E1 | Futures | 1.19753 | 1.19795 | 1.19047 | 1.19376 | 15260.0 |
| 2023-06-28 | E6 | Futures | 1.12641 | 1.12651 | 1.11971 | 1.12242 | 197398.0 |
| 2023-06-28 | E7 | Futures | 1.1266 | 1.1267 | 1.1198 | 1.1225 | 5333.0 |
| 2023-06-28 | EBM | Futures | 344.15 | 349.64 | 338.29 | 338.66 | 36717.0 |
| 2023-06-28 | ER | Futures | 97.766 | 97.812 | 97.761 | 97.802 | 201706.0 |
| 2023-06-28 | ESG | Futures | 413.98 | 415.99 | 413.32 | 414.85 | 430.0 |
| 2023-06-28 | EW | Futures | 2744.5 | 2749.3 | 2724.9 | 2744.4 | 10060.0 |
| 2023-06-28 | FBON | Futures | 123.21 | 123.71 | 123.13 | 123.55 | 53.0 |
| 2023-06-28 | FBTP | Futures | 115.04 | 115.52 | 114.76 | 115.09 | 131151.0 |
| 2023-06-28 | FBTS | Futures | 105.926 | 106.037 | 105.876 | 105.926 | 125296.0 |
| 2023-06-28 | FCE | Futures | 7902.6 | 7963.1 | 7901.0 | 7945.1 | 45395.0 |
| 2023-06-28 | FDAX | Futures | 16954.6 | 17064.7 | 16931.3 | 17022.4 | 51994.0 |
| 2023-06-28 | FDIV | Futures | 185.46 | 186.07 | 185.46 | 186.07 | 6.0 |
| 2023-06-28 | FDXM | Futures | 17023.0 | 17134.6 | 17001.7 | 17092.1 | 32822.0 |
| 2023-06-28 | FDXS | Futures | 16953.0 | 17024.8 | 16891.7 | 16982.6 | 19374.0 |
| 2023-06-28 | FESX | Futures | 4403.6 | 4439.1 | 4399.6 | 4429.9 | 662866.0 |
| 2023-06-28 | FEU3 | Futures | 97.792 | 97.792 | 97.792 | 97.792 | 0.0 |
| 2023-06-28 | FGBL | Futures | 135.92 | 136.54 | 135.6 | 136.27 | 723309.0 |
| 2023-06-28 | FGBM | Futures | 118.66 | 118.99 | 118.53 | 118.88 | 550721.0 |
| 2023-06-28 | FGBS | Futures | 107.361 | 107.479 | 107.34 | 107.448 | 430658.0 |
| 2023-06-28 | FGBX | Futures | 143.34 | 144.8 | 142.58 | 143.96 | 67239.0 |
| 2023-06-28 | FMWO | Futures | 10239.2 | 10282.8 | 10231.4 | 10258.2 | 2488.0 |
| 2023-06-28 | FOAT | Futures | 127.32 | 127.87 | 127.05 | 127.56 | 162493.0 |
| 2023-06-28 | FSMX | Futures | 28454.2 | 28543.7 | 28383.5 | 28543.7 | 594.0 |
| 2023-06-28 | FTDX | Futures | 3306.5 | 3338.1 | 3306.0 | 3338.1 | 25.0 |
| 2023-06-28 | FTI | Futures | 804.02 | 809.85 | 802.13 | 807.92 | 15056.0 |
| 2023-06-28 | FTUK | Futures | 7609.3 | 7651.4 | 7604.7 | 7636.2 | 78339.0 |
> showing 50 of 130 rows — these rows as CSV