PREVIEW / futures_daily / 2023-07-21
file: by_date/futures_daily/2023/2023-07-21.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-07-21 | ES | Futures | 4945.02 | 4970.74 | 4940.15 | 4943.4 | 1432643.0 |
| 2023-07-21 | NQ | Futures | 17058.96 | 17199.56 | 16984.01 | 17003.43 | 704413.0 |
| 2023-07-21 | YM | Futures | 37635.5 | 37745.0 | 37566.4 | 37619.5 | 144932.0 |
| 2023-07-21 | CL | Futures | 65.58 | 66.96 | 65.58 | 66.77 | 308106.0 |
| 2023-07-21 | GC | Futures | 2168.0 | 2172.2 | 2153.4 | 2161.9 | 156540.0 |
| 2023-07-21 | ZN | Futures | 114.121897 | 114.424059 | 114.058284 | 114.23322 | 1012410.0 |
| 2023-07-21 | A6 | Futures | 0.68793 | 0.68879 | 0.68216 | 0.68307 | 64109.0 |
| 2023-07-21 | AD | Futures | 0.76775 | 0.76881 | 0.76451 | 0.76578 | 63492.0 |
| 2023-07-21 | ALI | Futures | 2459.71 | 2459.71 | 2439.59 | 2453.29 | 2237.0 |
| 2023-07-21 | B | Futures | 69.89 | 71.17 | 69.78 | 71.02 | 294345.0 |
| 2023-07-21 | B6 | Futures | 1.2896 | 1.293 | 1.2842 | 1.2885 | 105583.0 |
| 2023-07-21 | BFX | Futures | 4190.0 | 4190.0 | 4190.0 | 4190.0 | 0.0 |
| 2023-07-21 | BR | Futures | 0.19343 | 0.19427 | 0.19198 | 0.1939 | 398.0 |
| 2023-07-21 | BTC | Futures | 40130.4 | 40398.7 | 39882.3 | 40083.5 | 5304.0 |
| 2023-07-21 | BZ | Futures | 69.67 | 71.05 | 69.67 | 70.9 | 23563.0 |
| 2023-07-21 | C | Futures | 2127.0 | 2166.0 | 2122.0 | 2158.0 | 5365.0 |
| 2023-07-21 | CB | Futures | 241.641 | 242.879 | 240.307 | 241.45 | 76.0 |
| 2023-07-21 | CC | Futures | 1953.0 | 1987.0 | 1948.0 | 1980.0 | 17637.0 |
| 2023-07-21 | CNH | Futures | 6.877 | 6.8911 | 6.8658 | 6.8905 | 829.0 |
| 2023-07-21 | CSC | Futures | 1.952 | 2.031 | 1.952 | 1.994 | 216.0 |
| 2023-07-21 | CT | Futures | 108.28 | 108.31 | 105.01 | 106.04 | 48.0 |
| 2023-07-21 | DC | Futures | 17.94 | 18.78 | 17.94 | 18.39 | 748.0 |
| 2023-07-21 | DX | Futures | 98.6 | 99.012 | 98.546 | 98.888 | 13828.0 |
| 2023-07-21 | E1 | Futures | 1.23163 | 1.23497 | 1.23046 | 1.23221 | 14209.0 |
| 2023-07-21 | E6 | Futures | 1.14258 | 1.14371 | 1.13992 | 1.14166 | 134579.0 |
| 2023-07-21 | E7 | Futures | 1.1426 | 1.1439 | 1.14 | 1.1417 | 3333.0 |
| 2023-07-21 | EBM | Futures | 373.07 | 373.8 | 360.62 | 362.09 | 38393.0 |
| 2023-07-21 | ER | Futures | 97.807 | 97.817 | 97.797 | 97.812 | 69023.0 |
| 2023-07-21 | ESG | Futures | 429.6 | 431.08 | 428.73 | 428.84 | 236.0 |
| 2023-07-21 | EW | Futures | 2888.2 | 2902.8 | 2874.3 | 2877.6 | 9707.0 |
| 2023-07-21 | FBON | Futures | 122.16 | 122.57 | 122.16 | 122.5 | 70.0 |
| 2023-07-21 | FBTP | Futures | 113.81 | 114.44 | 113.8 | 114.36 | 87591.0 |
| 2023-07-21 | FBTS | Futures | 105.997 | 106.108 | 105.997 | 106.098 | 63216.0 |
| 2023-07-21 | FCE | Futures | 8007.4 | 8076.1 | 8005.8 | 8065.8 | 46508.0 |
| 2023-07-21 | FDAX | Futures | 17170.5 | 17235.1 | 17142.0 | 17222.4 | 44864.0 |
| 2023-07-21 | FDIV | Futures | 188.52 | 189.03 | 188.52 | 189.03 | 30.0 |
| 2023-07-21 | FDXM | Futures | 17230.2 | 17304.6 | 17211.1 | 17292.9 | 34731.0 |
| 2023-07-21 | FDXS | Futures | 17132.5 | 17192.7 | 17101.9 | 17182.1 | 14728.0 |
| 2023-07-21 | FESX | Futures | 4433.0 | 4475.5 | 4432.0 | 4470.5 | 606448.0 |
| 2023-07-21 | FEU3 | Futures | 97.807 | 97.807 | 97.807 | 97.807 | 0.0 |
| 2023-07-21 | FGBL | Futures | 134.6 | 135.11 | 134.47 | 135.0 | 470137.0 |
| 2023-07-21 | FGBM | Futures | 118.3 | 118.5 | 118.2 | 118.46 | 353150.0 |
| 2023-07-21 | FGBS | Futures | 107.32 | 107.376 | 107.279 | 107.366 | 275619.0 |
| 2023-07-21 | FGBX | Futures | 139.55 | 140.8 | 139.37 | 140.53 | 48199.0 |
| 2023-07-21 | FMWO | Futures | 10602.6 | 10632.8 | 10591.5 | 10621.6 | 5896.0 |
| 2023-07-21 | FOAT | Futures | 125.8 | 126.3 | 125.68 | 126.18 | 111114.0 |
| 2023-07-21 | FSMX | Futures | 29441.4 | 29496.5 | 29357.1 | 29496.5 | 63.0 |
| 2023-07-21 | FTDX | Futures | 3378.7 | 3415.0 | 3378.1 | 3415.0 | 13.0 |
| 2023-07-21 | FTI | Futures | 805.59 | 812.27 | 804.85 | 811.4 | 16209.0 |
| 2023-07-21 | FTUK | Futures | 7765.8 | 7791.2 | 7752.6 | 7776.4 | 82640.0 |
> showing 50 of 130 rows — these rows as CSV