PREVIEW / futures_daily / 2023-07-05
file: by_date/futures_daily/2023/2023-07-05.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-05 | ES | Futures | 4864.61 | 4866.51 | 4836.73 | 4855.68 | 1193759.0 |
| 2023-07-05 | NQ | Futures | 16803.2 | 16885.26 | 16691.87 | 16807.3 | 519857.0 |
| 2023-07-05 | YM | Futures | 36801.2 | 36826.7 | 36596.1 | 36674.8 | 144068.0 |
| 2023-07-05 | CL | Futures | 60.88 | 62.63 | 60.66 | 62.3 | 456809.0 |
| 2023-07-05 | GC | Futures | 2120.7 | 2135.9 | 2113.0 | 2118.5 | 245932.0 |
| 2023-07-05 | ZN | Futures | 113.915154 | 114.121897 | 113.31083 | 113.342636 | 1640832.0 |
| 2023-07-05 | A6 | Futures | 0.67739 | 0.68079 | 0.6743 | 0.67567 | 115238.0 |
| 2023-07-05 | AD | Futures | 0.76345 | 0.76623 | 0.76093 | 0.76168 | 90238.0 |
| 2023-07-05 | ALI | Futures | 2371.67 | 2400.51 | 2358.64 | 2371.95 | 3984.0 |
| 2023-07-05 | B | Futures | 66.61 | 67.42 | 65.97 | 67.15 | 293737.0 |
| 2023-07-05 | B6 | Futures | 1.2716 | 1.2764 | 1.2708 | 1.272 | 114010.0 |
| 2023-07-05 | BFX | Futures | 3926.6 | 3926.6 | 3926.6 | 3926.6 | 0.0 |
| 2023-07-05 | BR | Futures | 0.1924 | 0.19264 | 0.19003 | 0.19035 | 54.0 |
| 2023-07-05 | BTC | Futures | 42222.8 | 42551.4 | 40801.0 | 41143.1 | 9567.0 |
| 2023-07-05 | BZ | Futures | 65.54 | 67.29 | 65.4 | 67.03 | 35538.0 |
| 2023-07-05 | C | Futures | 2172.0 | 2188.0 | 2165.0 | 2170.0 | 802.0 |
| 2023-07-05 | CB | Futures | 230.021 | 230.497 | 230.021 | 230.021 | 20.0 |
| 2023-07-05 | CC | Futures | 1957.0 | 1976.0 | 1945.0 | 1953.0 | 22860.0 |
| 2023-07-05 | CNH | Futures | 6.9339 | 6.9531 | 6.9097 | 6.9509 | 748.0 |
| 2023-07-05 | CSC | Futures | 1.816 | 1.822 | 1.804 | 1.807 | 111.0 |
| 2023-07-05 | CT | Futures | 102.45 | 102.9 | 101.23 | 101.68 | 39.0 |
| 2023-07-05 | DC | Futures | 16.53 | 16.55 | 16.36 | 16.45 | 161.0 |
| 2023-07-05 | DX | Futures | 100.783 | 101.102 | 100.685 | 101.082 | 11659.0 |
| 2023-07-05 | E1 | Futures | 1.19302 | 1.19509 | 1.1884 | 1.18925 | 25070.0 |
| 2023-07-05 | E6 | Futures | 1.12109 | 1.12135 | 1.11454 | 1.1148 | 243866.0 |
| 2023-07-05 | E7 | Futures | 1.1207 | 1.1213 | 1.1147 | 1.1149 | 5401.0 |
| 2023-07-05 | EBM | Futures | 333.16 | 345.61 | 333.16 | 341.58 | 25360.0 |
| 2023-07-05 | ER | Futures | 97.797 | 97.822 | 97.797 | 97.807 | 126738.0 |
| 2023-07-05 | ESG | Futures | 421.27 | 421.76 | 420.21 | 421.14 | 603.0 |
| 2023-07-05 | EW | Futures | 2802.8 | 2808.1 | 2773.1 | 2777.9 | 9269.0 |
| 2023-07-05 | FBON | Futures | 121.8 | 122.21 | 121.46 | 121.65 | 1021.0 |
| 2023-07-05 | FBTP | Futures | 113.11 | 113.76 | 112.97 | 113.47 | 143535.0 |
| 2023-07-05 | FBTS | Futures | 105.563 | 105.785 | 105.532 | 105.734 | 95433.0 |
| 2023-07-05 | FCE | Futures | 8021.3 | 8021.3 | 7952.2 | 7971.2 | 51317.0 |
| 2023-07-05 | FDAX | Futures | 17090.1 | 17096.5 | 16952.5 | 16981.1 | 54000.0 |
| 2023-07-05 | FDIV | Futures | 185.97 | 187.7 | 185.97 | 186.33 | 113.0 |
| 2023-07-05 | FDXM | Futures | 17157.9 | 17167.5 | 17023.0 | 17050.6 | 31939.0 |
| 2023-07-05 | FDXS | Futures | 17053.3 | 17055.4 | 16913.9 | 16941.4 | 17108.0 |
| 2023-07-05 | FESX | Futures | 4468.4 | 4470.5 | 4422.9 | 4428.9 | 729498.0 |
| 2023-07-05 | FEU3 | Futures | 97.807 | 97.807 | 97.807 | 97.807 | 0.0 |
| 2023-07-05 | FGBL | Futures | 134.91 | 135.36 | 134.15 | 134.54 | 731127.0 |
| 2023-07-05 | FGBM | Futures | 118.17 | 118.41 | 117.94 | 118.1 | 481553.0 |
| 2023-07-05 | FGBS | Futures | 107.228 | 107.315 | 107.182 | 107.218 | 500864.0 |
| 2023-07-05 | FGBX | Futures | 141.66 | 142.52 | 139.2 | 140.43 | 74392.0 |
| 2023-07-05 | FMWO | Futures | 10376.7 | 10381.2 | 10337.6 | 10374.5 | 3487.0 |
| 2023-07-05 | FOAT | Futures | 126.04 | 126.46 | 125.45 | 125.83 | 171279.0 |
| 2023-07-05 | FSMX | Futures | 28785.0 | 28865.1 | 28668.5 | 28678.9 | 406.0 |
| 2023-07-05 | FTDX | Futures | 3352.9 | 3357.6 | 3348.1 | 3348.1 | 28.0 |
| 2023-07-05 | FTI | Futures | 817.73 | 817.94 | 808.54 | 809.94 | 16346.0 |
| 2023-07-05 | FTUK | Futures | 7645.9 | 7649.4 | 7555.4 | 7564.6 | 95111.0 |
> showing 50 of 130 rows — these rows as CSV