PREVIEW / futures_daily / 2024-08-05
file: by_date/futures_daily/2024/2024-08-05.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-08-05 | ES | Futures | 5505.37 | 5521.38 | 5288.46 | 5389.16 | 3436090.0 |
| 2024-08-05 | NQ | Futures | 19058.76 | 19058.76 | 17981.97 | 18668.31 | 937137.0 |
| 2024-08-05 | YM | Futures | 40405.6 | 40535.1 | 39302.2 | 39615.3 | 242089.0 |
| 2024-08-05 | CL | Futures | 68.84 | 69.07 | 66.48 | 67.66 | 500151.0 |
| 2024-08-05 | GC | Futures | 2542.7 | 2553.4 | 2454.4 | 2495.8 | 352229.0 |
| 2024-08-05 | ZN | Futures | 114.768428 | 115.710826 | 114.360055 | 114.674188 | 3977072.0 |
| 2024-08-05 | A6 | Futures | 0.65297 | 0.65327 | 0.63645 | 0.65022 | 215622.0 |
| 2024-08-05 | AD | Futures | 0.72534 | 0.72866 | 0.72143 | 0.72741 | 149172.0 |
| 2024-08-05 | ALI | Futures | 2263.75 | 2289.8 | 2234.87 | 2257.05 | 1891.0 |
| 2024-08-05 | B | Futures | 75.58 | 75.71 | 73.09 | 74.3 | 557814.0 |
| 2024-08-05 | B6 | Futures | 1.2807 | 1.2819 | 1.2712 | 1.276 | 167251.0 |
| 2024-08-05 | BFX | Futures | 3869.2 | 3869.2 | 3869.2 | 3869.2 | 0.0 |
| 2024-08-05 | BR | Futures | 0.16829 | 0.16906 | 0.16399 | 0.16761 | 22369.0 |
| 2024-08-05 | BTC | Futures | 66039.5 | 66667.6 | 55362.9 | 60303.1 | 30884.0 |
| 2024-08-05 | BZ | Futures | 73.88 | 74.17 | 71.6 | 72.79 | 59442.0 |
| 2024-08-05 | C | Futures | 5942.0 | 6274.0 | 5814.0 | 6212.0 | 3876.0 |
| 2024-08-05 | CB | Futures | 304.689 | 305.854 | 303.572 | 305.175 | 23.0 |
| 2024-08-05 | CC | Futures | 5268.0 | 5564.0 | 5199.0 | 5467.0 | 14290.0 |
| 2024-08-05 | CNH | Futures | 7.0382 | 7.0476 | 6.9656 | 7.012 | 2405.0 |
| 2024-08-05 | CSC | Futures | 1.919 | 1.919 | 1.866 | 1.866 | 637.0 |
| 2024-08-05 | CT | Futures | 75.36 | 76.09 | 73.78 | 74.76 | 16.0 |
| 2024-08-05 | DC | Futures | 18.9 | 18.9 | 18.21 | 18.23 | 1730.0 |
| 2024-08-05 | DX | Futures | 102.463 | 102.537 | 101.443 | 101.958 | 59112.0 |
| 2024-08-05 | E1 | Futures | 1.19359 | 1.21417 | 1.19119 | 1.20352 | 97450.0 |
| 2024-08-05 | E6 | Futures | 1.10229 | 1.11141 | 1.09967 | 1.10557 | 427573.0 |
| 2024-08-05 | E7 | Futures | 1.102 | 1.111 | 1.0993 | 1.1053 | 18038.0 |
| 2024-08-05 | EBM | Futures | 255.54 | 255.54 | 251.16 | 252.03 | 23722.0 |
| 2024-08-05 | ER | Futures | 97.695 | 97.867 | 97.664 | 97.7 | 369692.0 |
| 2024-08-05 | ESG | Futures | 468.54 | 468.76 | 457.33 | 461.86 | 1819.0 |
| 2024-08-05 | EW | Futures | 2989.3 | 2994.6 | 2845.1 | 2931.7 | 23636.0 |
| 2024-08-05 | FBON | Futures | 125.65 | 125.78 | 124.81 | 125.06 | 282.0 |
| 2024-08-05 | FBTP | Futures | 119.11 | 119.11 | 118.33 | 118.56 | 358713.0 |
| 2024-08-05 | FBTS | Futures | 107.19 | 107.231 | 106.918 | 106.979 | 204472.0 |
| 2024-08-05 | FCE | Futures | 7264.5 | 7384.3 | 7205.6 | 7331.0 | 108576.0 |
| 2024-08-05 | FDAX | Futures | 18051.4 | 18144.5 | 17499.1 | 17796.7 | 80627.0 |
| 2024-08-05 | FDIV | Futures | 173.24 | 173.99 | 173.24 | 173.69 | 13.0 |
| 2024-08-05 | FDXM | Futures | 18000.0 | 18059.0 | 17417.7 | 17713.9 | 70035.0 |
| 2024-08-05 | FDXS | Futures | 17959.0 | 18012.8 | 17372.2 | 17667.6 | 76578.0 |
| 2024-08-05 | FESX | Futures | 4674.5 | 4694.7 | 4531.3 | 4625.1 | 1708977.0 |
| 2024-08-05 | FEU3 | Futures | 97.755 | 97.771 | 97.7 | 97.71 | 99.0 |
| 2024-08-05 | FGBL | Futures | 136.9 | 137.7 | 136.28 | 136.6 | 1435664.0 |
| 2024-08-05 | FGBM | Futures | 119.28 | 119.88 | 118.94 | 119.13 | 1106718.0 |
| 2024-08-05 | FGBS | Futures | 107.275 | 107.598 | 107.155 | 107.255 | 1439626.0 |
| 2024-08-05 | FGBX | Futures | 139.22 | 140.75 | 138.48 | 139.04 | 176349.0 |
| 2024-08-05 | FMWO | Futures | 11276.8 | 11288.3 | 10899.6 | 11155.3 | 18683.0 |
| 2024-08-05 | FOAT | Futures | 126.39 | 126.64 | 125.77 | 125.97 | 309762.0 |
| 2024-08-05 | FSMX | Futures | 24149.6 | 24341.2 | 23779.5 | 24266.6 | 689.0 |
| 2024-08-05 | FTDX | Futures | 3223.5 | 3282.6 | 3191.4 | 3275.5 | 43.0 |
| 2024-08-05 | FTI | Futures | 869.61 | 880.84 | 852.23 | 872.61 | 25338.0 |
| 2024-08-05 | FTUK | Futures | 8190.5 | 8215.1 | 7929.3 | 8014.6 | 191297.0 |
> showing 50 of 129 rows — these rows as CSV