PREVIEW / futures_daily / 2023-08-31
file: by_date/futures_daily/2023/2023-08-31.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-08-31 | ES | Futures | 4902.52 | 4917.95 | 4887.09 | 4890.61 | 1395751.0 |
| 2023-08-31 | NQ | Futures | 16974.71 | 17076.47 | 16915.9 | 17001.79 | 584743.0 |
| 2023-08-31 | YM | Futures | 37221.0 | 37384.7 | 36952.1 | 36974.5 | 152651.0 |
| 2023-08-31 | CL | Futures | 71.41 | 73.15 | 71.22 | 73.1 | 368848.0 |
| 2023-08-31 | GC | Futures | 2121.3 | 2126.3 | 2116.2 | 2116.7 | 133712.0 |
| 2023-08-31 | ZN | Futures | 112.372537 | 112.611086 | 112.29302 | 112.531569 | 79211.0 |
| 2023-08-31 | A6 | Futures | 0.65627 | 0.65957 | 0.6548 | 0.65622 | 121509.0 |
| 2023-08-31 | AD | Futures | 0.74678 | 0.7484 | 0.74547 | 0.74759 | 78723.0 |
| 2023-08-31 | ALI | Futures | 2419.91 | 2447.48 | 2419.36 | 2424.05 | 517.0 |
| 2023-08-31 | B | Futures | 75.96 | 77.43 | 75.83 | 77.39 | 434973.0 |
| 2023-08-31 | B6 | Futures | 1.2742 | 1.2759 | 1.2676 | 1.2687 | 90261.0 |
| 2023-08-31 | BFX | Futures | 4024.1 | 4024.1 | 4024.1 | 4024.1 | 0.0 |
| 2023-08-31 | BR | Futures | 0.1879 | 0.1879 | 0.1879 | 0.1879 | 71.0 |
| 2023-08-31 | BTC | Futures | 36508.1 | 36934.7 | 34675.0 | 34981.7 | 10310.0 |
| 2023-08-31 | BZ | Futures | 75.78 | 77.25 | 75.67 | 77.21 | 33559.0 |
| 2023-08-31 | C | Futures | 2440.0 | 2502.0 | 2439.0 | 2465.0 | 7897.0 |
| 2023-08-31 | CB | Futures | 255.541 | 255.541 | 255.541 | 255.541 | 17.0 |
| 2023-08-31 | CC | Futures | 2129.0 | 2145.0 | 2113.0 | 2122.0 | 26120.0 |
| 2023-08-31 | CNH | Futures | 7.0197 | 7.022 | 6.9954 | 7.0034 | 308.0 |
| 2023-08-31 | CSC | Futures | 2.14 | 2.14 | 2.14 | 2.14 | 4.0 |
| 2023-08-31 | CT | Futures | 109.62 | 110.37 | 109.44 | 109.81 | 7.0 |
| 2023-08-31 | DC | Futures | 20.0 | 20.09 | 19.93 | 20.07 | 83.0 |
| 2023-08-31 | DX | Futures | 101.131 | 101.725 | 101.004 | 101.624 | 17585.0 |
| 2023-08-31 | E1 | Futures | 1.21004 | 1.21126 | 1.20097 | 1.20288 | 23575.0 |
| 2023-08-31 | E6 | Futures | 1.11925 | 1.12032 | 1.10958 | 1.1106 | 253955.0 |
| 2023-08-31 | E7 | Futures | 1.1191 | 1.1203 | 1.1097 | 1.1107 | 4908.0 |
| 2023-08-31 | EBM | Futures | 329.87 | 332.8 | 325.48 | 328.4 | 6119.0 |
| 2023-08-31 | ER | Futures | 97.828 | 97.914 | 97.807 | 97.899 | 521640.0 |
| 2023-08-31 | ESG | Futures | 426.36 | 427.23 | 424.94 | 425.04 | 411.0 |
| 2023-08-31 | EW | Futures | 2801.1 | 2814.7 | 2797.3 | 2799.7 | 7696.0 |
| 2023-08-31 | FBON | Futures | 121.43 | 122.36 | 121.43 | 122.35 | 505.0 |
| 2023-08-31 | FBTP | Futures | 113.21 | 114.09 | 112.97 | 114.02 | 249757.0 |
| 2023-08-31 | FBTS | Futures | 106.017 | 106.33 | 105.967 | 106.32 | 167997.0 |
| 2023-08-31 | FCE | Futures | 7991.2 | 8004.7 | 7903.0 | 7927.3 | 45481.0 |
| 2023-08-31 | FDAX | Futures | 16868.9 | 17010.7 | 16856.2 | 16935.6 | 56610.0 |
| 2023-08-31 | FDIV | Futures | 184.54 | 184.54 | 184.54 | 184.54 | 0.0 |
| 2023-08-31 | FDXM | Futures | 16943.2 | 17082.5 | 16927.3 | 17004.9 | 44118.0 |
| 2023-08-31 | FDXS | Futures | 16837.9 | 16970.9 | 16816.7 | 16896.0 | 19639.0 |
| 2023-08-31 | FESX | Futures | 4386.4 | 4401.6 | 4348.9 | 4369.2 | 877264.0 |
| 2023-08-31 | FEU3 | Futures | 97.899 | 97.899 | 97.899 | 97.899 | 0.0 |
| 2023-08-31 | FGBL | Futures | 133.73 | 134.91 | 133.48 | 134.86 | 1160616.0 |
| 2023-08-31 | FGBM | Futures | 118.21 | 118.83 | 118.04 | 118.78 | 1139707.0 |
| 2023-08-31 | FGBS | Futures | 107.32 | 107.576 | 107.284 | 107.545 | 1229451.0 |
| 2023-08-31 | FGBX | Futures | 135.14 | 137.32 | 134.61 | 137.15 | 146136.0 |
| 2023-08-31 | FMWO | Futures | 10425.9 | 10451.7 | 10387.9 | 10421.5 | 3681.0 |
| 2023-08-31 | FOAT | Futures | 125.1 | 126.22 | 124.85 | 126.18 | 303936.0 |
| 2023-08-31 | FSMX | Futures | 28908.8 | 29154.3 | 28908.8 | 28984.7 | 162.0 |
| 2023-08-31 | FTDX | Futures | 3346.0 | 3362.9 | 3346.0 | 3356.0 | 63.0 |
| 2023-08-31 | FTI | Futures | 779.58 | 783.54 | 774.83 | 776.84 | 12797.0 |
| 2023-08-31 | FTUK | Futures | 7605.2 | 7638.7 | 7554.4 | 7583.4 | 109678.0 |
> showing 50 of 130 rows — these rows as CSV