PREVIEW / futures_daily / 2023-07-14
file: by_date/futures_daily/2023/2023-07-14.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-14 | ES | Futures | 4916.05 | 4938.8 | 4906.85 | 4913.08 | 1381069.0 |
| 2023-07-14 | NQ | Futures | 17177.41 | 17350.56 | 17138.02 | 17172.21 | 629943.0 |
| 2023-07-14 | YM | Futures | 36715.1 | 36971.3 | 36659.9 | 36854.4 | 135128.0 |
| 2023-07-14 | CL | Futures | 66.73 | 66.81 | 65.03 | 65.26 | 204776.0 |
| 2023-07-14 | GC | Futures | 2160.4 | 2163.3 | 2148.9 | 2159.5 | 209306.0 |
| 2023-07-14 | ZN | Futures | 114.980674 | 115.06019 | 114.439962 | 114.567188 | 1294157.0 |
| 2023-07-14 | A6 | Futures | 0.69917 | 0.69993 | 0.69335 | 0.69431 | 98820.0 |
| 2023-07-14 | AD | Futures | 0.77143 | 0.77239 | 0.76451 | 0.76552 | 73661.0 |
| 2023-07-14 | ALI | Futures | 2506.42 | 2526.66 | 2499.77 | 2511.69 | 430.0 |
| 2023-07-14 | B | Futures | 71.52 | 71.58 | 69.68 | 69.97 | 311226.0 |
| 2023-07-14 | B6 | Futures | 1.3159 | 1.3169 | 1.3116 | 1.3129 | 90492.0 |
| 2023-07-14 | BFX | Futures | 3934.1 | 3934.1 | 3934.1 | 3934.1 | 0.0 |
| 2023-07-14 | BR | Futures | 0.19245 | 0.19343 | 0.19222 | 0.19292 | 153.0 |
| 2023-07-14 | BTC | Futures | 42269.7 | 42799.5 | 40271.2 | 40552.9 | 11611.0 |
| 2023-07-14 | BZ | Futures | 71.37 | 71.44 | 69.59 | 69.85 | 23286.0 |
| 2023-07-14 | C | Futures | 2060.0 | 2102.0 | 2043.0 | 2092.0 | 12733.0 |
| 2023-07-14 | CB | Futures | 236.688 | 241.45 | 236.688 | 240.26 | 59.0 |
| 2023-07-14 | CC | Futures | 1895.0 | 1956.0 | 1891.0 | 1943.0 | 35464.0 |
| 2023-07-14 | CNH | Futures | 6.8464 | 6.8562 | 6.824 | 6.8562 | 341.0 |
| 2023-07-14 | CSC | Futures | 1.838 | 1.85 | 1.793 | 1.808 | 306.0 |
| 2023-07-14 | CT | Futures | 102.8 | 106.24 | 102.4 | 103.02 | 263.0 |
| 2023-07-14 | DC | Futures | 17.08 | 17.12 | 16.51 | 16.57 | 607.0 |
| 2023-07-14 | DX | Futures | 97.58 | 97.815 | 97.379 | 97.717 | 17931.0 |
| 2023-07-14 | E1 | Futures | 1.24367 | 1.2468 | 1.2372 | 1.239 | 23875.0 |
| 2023-07-14 | E6 | Futures | 1.1523 | 1.1544 | 1.15031 | 1.15327 | 197925.0 |
| 2023-07-14 | E7 | Futures | 1.1523 | 1.1545 | 1.1504 | 1.1534 | 4360.0 |
| 2023-07-14 | EBM | Futures | 335.73 | 342.68 | 335.36 | 339.39 | 19482.0 |
| 2023-07-14 | ER | Futures | 97.812 | 97.812 | 97.787 | 97.787 | 76107.0 |
| 2023-07-14 | ESG | Futures | 425.85 | 428.24 | 425.62 | 426.06 | 385.0 |
| 2023-07-14 | EW | Futures | 2869.6 | 2875.5 | 2833.5 | 2845.2 | 10151.0 |
| 2023-07-14 | FBON | Futures | 122.03 | 122.3 | 121.7 | 121.81 | 72.0 |
| 2023-07-14 | FBTP | Futures | 113.66 | 113.72 | 113.2 | 113.37 | 91805.0 |
| 2023-07-14 | FBTS | Futures | 106.007 | 106.027 | 105.866 | 105.906 | 67387.0 |
| 2023-07-14 | FCE | Futures | 8003.1 | 8037.1 | 7985.2 | 8006.3 | 1273.0 |
| 2023-07-14 | FDAX | Futures | 17209.7 | 17209.7 | 17113.4 | 17157.8 | 46339.0 |
| 2023-07-14 | FDIV | Futures | 186.12 | 186.48 | 186.12 | 186.48 | 24.0 |
| 2023-07-14 | FDXM | Futures | 17279.1 | 17279.1 | 17181.3 | 17228.1 | 30343.0 |
| 2023-07-14 | FDXS | Futures | 17158.9 | 17162.1 | 17073.4 | 17117.7 | 13462.0 |
| 2023-07-14 | FESX | Futures | 4475.5 | 4492.8 | 4462.4 | 4482.6 | 599532.0 |
| 2023-07-14 | FEU3 | Futures | 97.782 | 97.782 | 97.782 | 97.782 | 0.0 |
| 2023-07-14 | FGBL | Futures | 134.83 | 134.91 | 134.31 | 134.48 | 498070.0 |
| 2023-07-14 | FGBM | Futures | 118.46 | 118.46 | 118.09 | 118.18 | 428004.0 |
| 2023-07-14 | FGBS | Futures | 107.381 | 107.381 | 107.238 | 107.264 | 324661.0 |
| 2023-07-14 | FGBX | Futures | 139.0 | 139.88 | 138.63 | 139.14 | 58488.0 |
| 2023-07-14 | FMWO | Futures | 10551.2 | 10597.0 | 10534.4 | 10575.8 | 1379.0 |
| 2023-07-14 | FOAT | Futures | 126.01 | 126.06 | 125.49 | 125.65 | 103022.0 |
| 2023-07-14 | FSMX | Futures | 29153.2 | 29233.3 | 29122.0 | 29122.0 | 58.0 |
| 2023-07-14 | FTDX | Futures | 3410.8 | 3410.8 | 3409.7 | 3409.7 | 2.0 |
| 2023-07-14 | FTI | Futures | 814.47 | 819.89 | 812.69 | 817.19 | 188.0 |
| 2023-07-14 | FTUK | Futures | 7551.9 | 7599.6 | 7533.1 | 7558.5 | 71072.0 |
> showing 50 of 130 rows — these rows as CSV