PREVIEW / futures_daily / 2023-08-09
file: by_date/futures_daily/2023/2023-08-09.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-09 | ES | Futures | 4891.15 | 4912.53 | 4849.72 | 4857.85 | 1640285.0 |
| 2023-08-09 | NQ | Futures | 16797.45 | 16885.81 | 16572.88 | 16607.62 | 652732.0 |
| 2023-08-09 | YM | Futures | 37596.2 | 37721.6 | 37335.8 | 37411.2 | 140785.0 |
| 2023-08-09 | CL | Futures | 71.81 | 73.34 | 71.62 | 73.12 | 478140.0 |
| 2023-08-09 | GC | Futures | 2109.6 | 2116.9 | 2096.5 | 2100.2 | 139259.0 |
| 2023-08-09 | ZN | Futures | 113.406249 | 113.612992 | 113.247217 | 113.374443 | 1164222.0 |
| 2023-08-09 | A6 | Futures | 0.66382 | 0.66656 | 0.66139 | 0.66321 | 57301.0 |
| 2023-08-09 | AD | Futures | 0.75355 | 0.75426 | 0.75143 | 0.7536 | 70173.0 |
| 2023-08-09 | ALI | Futures | 2434.56 | 2451.61 | 2423.66 | 2425.34 | 2628.0 |
| 2023-08-09 | B | Futures | 76.11 | 77.57 | 76.03 | 77.48 | 388299.0 |
| 2023-08-09 | B6 | Futures | 1.2777 | 1.2809 | 1.2737 | 1.2749 | 60743.0 |
| 2023-08-09 | BFX | Futures | 4087.6 | 4087.6 | 4087.6 | 4087.6 | 0.0 |
| 2023-08-09 | BR | Futures | 0.18947 | 0.19045 | 0.18886 | 0.18933 | 7629.0 |
| 2023-08-09 | BTC | Futures | 39825.2 | 40103.3 | 39023.8 | 39090.0 | 7172.0 |
| 2023-08-09 | BZ | Futures | 75.88 | 77.34 | 75.82 | 77.24 | 29154.0 |
| 2023-08-09 | C | Futures | 2194.0 | 2223.0 | 2179.0 | 2193.0 | 6551.0 |
| 2023-08-09 | CB | Futures | 253.19 | 253.475 | 252.713 | 253.475 | 31.0 |
| 2023-08-09 | CC | Futures | 1975.0 | 1988.0 | 1952.0 | 1962.0 | 43561.0 |
| 2023-08-09 | CNH | Futures | 6.9439 | 6.9522 | 6.9169 | 6.9364 | 499.0 |
| 2023-08-09 | CSC | Futures | 2.017 | 2.021 | 2.005 | 2.005 | 40.0 |
| 2023-08-09 | CT | Futures | 106.48 | 107.32 | 106.48 | 107.32 | 1.0 |
| 2023-08-09 | DC | Futures | 18.7 | 18.73 | 18.52 | 18.56 | 170.0 |
| 2023-08-09 | DX | Futures | 100.41 | 100.464 | 100.185 | 100.373 | 8116.0 |
| 2023-08-09 | E1 | Futures | 1.21673 | 1.21996 | 1.21285 | 1.21407 | 11035.0 |
| 2023-08-09 | E6 | Futures | 1.12339 | 1.12738 | 1.12293 | 1.12529 | 120915.0 |
| 2023-08-09 | E7 | Futures | 1.1234 | 1.1275 | 1.123 | 1.1253 | 3228.0 |
| 2023-08-09 | EBM | Futures | 356.23 | 357.33 | 349.27 | 354.76 | 23001.0 |
| 2023-08-09 | ER | Futures | 97.873 | 97.878 | 97.858 | 97.868 | 107554.0 |
| 2023-08-09 | ESG | Futures | 425.0 | 425.0 | 420.66 | 420.87 | 174.0 |
| 2023-08-09 | EW | Futures | 2840.7 | 2854.6 | 2819.0 | 2828.1 | 9146.0 |
| 2023-08-09 | FBON | Futures | 122.21 | 122.23 | 121.73 | 121.87 | 48.0 |
| 2023-08-09 | FBTP | Futures | 114.12 | 114.12 | 113.49 | 113.72 | 128461.0 |
| 2023-08-09 | FBTS | Futures | 106.401 | 106.411 | 106.28 | 106.32 | 113480.0 |
| 2023-08-09 | FCE | Futures | 7933.3 | 7997.1 | 7925.2 | 7931.1 | 43273.0 |
| 2023-08-09 | FDAX | Futures | 16833.9 | 16987.4 | 16821.2 | 16828.6 | 56369.0 |
| 2023-08-09 | FDIV | Futures | 184.8 | 186.53 | 183.67 | 183.67 | 37.0 |
| 2023-08-09 | FDXM | Futures | 16912.4 | 17057.0 | 16890.1 | 16897.5 | 37518.0 |
| 2023-08-09 | FDXS | Futures | 16791.4 | 16948.8 | 16781.9 | 16789.3 | 24407.0 |
| 2023-08-09 | FESX | Futures | 4387.4 | 4429.9 | 4383.3 | 4385.4 | 739092.0 |
| 2023-08-09 | FEU3 | Futures | 97.858 | 97.858 | 97.858 | 97.858 | 0.0 |
| 2023-08-09 | FGBL | Futures | 134.93 | 135.11 | 134.23 | 134.54 | 567815.0 |
| 2023-08-09 | FGBM | Futures | 118.88 | 118.94 | 118.56 | 118.69 | 440396.0 |
| 2023-08-09 | FGBS | Futures | 107.663 | 107.683 | 107.555 | 107.596 | 376852.0 |
| 2023-08-09 | FGBX | Futures | 138.14 | 138.42 | 136.27 | 137.01 | 59866.0 |
| 2023-08-09 | FMWO | Futures | 10458.4 | 10479.6 | 10363.3 | 10380.1 | 2517.0 |
| 2023-08-09 | FOAT | Futures | 126.09 | 126.23 | 125.4 | 125.69 | 105942.0 |
| 2023-08-09 | FSMX | Futures | 29421.6 | 29555.8 | 29270.8 | 29270.8 | 862.0 |
| 2023-08-09 | FTDX | Futures | 3347.6 | 3347.6 | 3313.4 | 3313.4 | 5.0 |
| 2023-08-09 | FTI | Futures | 811.48 | 814.11 | 807.37 | 808.99 | 12507.0 |
| 2023-08-09 | FTUK | Futures | 7648.4 | 7712.4 | 7648.4 | 7684.5 | 89315.0 |
> showing 50 of 130 rows — these rows as CSV