PREVIEW / futures_daily / 2023-05-23
file: by_date/futures_daily/2023/2023-05-23.parquet size: 10 KB rows: 129
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-05-23 | ES | Futures | 4603.94 | 4620.62 | 4544.3 | 4550.59 | 1685056.0 |
| 2023-05-23 | NQ | Futures | 15423.55 | 15496.72 | 15198.24 | 15219.02 | 658680.0 |
| 2023-05-23 | YM | Futures | 35786.0 | 35875.0 | 35436.7 | 35503.1 | 178436.0 |
| 2023-05-23 | CL | Futures | 62.88 | 64.35 | 62.54 | 63.59 | 317586.0 |
| 2023-05-23 | GC | Futures | 2190.2 | 2196.9 | 2170.1 | 2190.8 | 214358.0 |
| 2023-05-23 | ZN | Futures | 116.066963 | 116.322758 | 115.747219 | 116.242822 | 2835142.0 |
| 2023-05-23 | A6 | Futures | 0.67666 | 0.67767 | 0.67219 | 0.67254 | 63552.0 |
| 2023-05-23 | AD | Futures | 0.7505 | 0.75161 | 0.74802 | 0.75065 | 60693.0 |
| 2023-05-23 | ALI | Futures | 2485.54 | 2492.92 | 2436.35 | 2452.2 | 1570.0 |
| 2023-05-23 | B | Futures | 67.26 | 68.67 | 66.82 | 67.87 | 287230.0 |
| 2023-05-23 | B6 | Futures | 1.2499 | 1.2508 | 1.2433 | 1.2479 | 92572.0 |
| 2023-05-23 | BFX | Futures | 4131.3 | 4131.3 | 4131.3 | 4131.3 | 0.0 |
| 2023-05-23 | BR | Futures | 0.18151 | 0.1821 | 0.18052 | 0.18119 | 5778.0 |
| 2023-05-23 | BTC | Futures | 36234.9 | 37110.0 | 36080.1 | 36618.6 | 9455.0 |
| 2023-05-23 | BZ | Futures | 66.7 | 68.26 | 66.42 | 67.47 | 30676.0 |
| 2023-05-23 | C | Futures | 1819.0 | 1834.0 | 1807.0 | 1810.0 | 6928.0 |
| 2023-05-23 | CB | Futures | 236.212 | 236.212 | 236.212 | 236.212 | 0.0 |
| 2023-05-23 | CC | Futures | 1754.0 | 1770.0 | 1747.0 | 1751.0 | 16988.0 |
| 2023-05-23 | CNH | Futures | 6.7176 | 6.7424 | 6.7176 | 6.738 | 469.0 |
| 2023-05-23 | CSC | Futures | 2.058 | 2.092 | 2.046 | 2.07 | 388.0 |
| 2023-05-23 | CT | Futures | 108.1 | 108.53 | 106.25 | 106.87 | 15477.0 |
| 2023-05-23 | DC | Futures | 19.11 | 19.64 | 19.08 | 19.37 | 1846.0 |
| 2023-05-23 | DX | Futures | 100.831 | 101.207 | 100.728 | 101.051 | 14057.0 |
| 2023-05-23 | E1 | Futures | 1.1964 | 1.19672 | 1.18949 | 1.19185 | 13571.0 |
| 2023-05-23 | E6 | Futures | 1.11355 | 1.11433 | 1.10816 | 1.10975 | 204007.0 |
| 2023-05-23 | E7 | Futures | 1.1131 | 1.1138 | 1.1075 | 1.1093 | 3745.0 |
| 2023-05-23 | EBM | Futures | 320.72 | 332.43 | 320.72 | 332.07 | 32563.0 |
| 2023-05-23 | ER | Futures | 97.858 | 97.863 | 97.853 | 97.858 | 85939.0 |
| 2023-05-23 | ESG | Futures | 399.85 | 399.85 | 394.93 | 395.25 | 769.0 |
| 2023-05-23 | EW | Futures | 2644.0 | 2654.9 | 2612.3 | 2614.8 | 10283.0 |
| 2023-05-23 | FBON | Futures | 120.64 | 120.74 | 120.21 | 120.48 | 155.0 |
| 2023-05-23 | FBTP | Futures | 111.03 | 111.08 | 110.67 | 110.9 | 188131.0 |
| 2023-05-23 | FBTS | Futures | 106.168 | 106.219 | 106.098 | 106.168 | 114756.0 |
| 2023-05-23 | FCE | Futures | 8147.0 | 8148.1 | 7992.9 | 8039.4 | 46807.0 |
| 2023-05-23 | FDAX | Futures | 17376.6 | 17384.0 | 17167.5 | 17266.7 | 49204.0 |
| 2023-05-23 | FDIV | Futures | 190.8 | 190.91 | 190.8 | 190.91 | 35.0 |
| 2023-05-23 | FDXM | Futures | 17518.2 | 17532.2 | 17314.9 | 17413.9 | 36800.0 |
| 2023-05-23 | FDXS | Futures | 17394.2 | 17428.4 | 17198.7 | 17297.0 | 15015.0 |
| 2023-05-23 | FESX | Futures | 4491.6 | 4497.8 | 4416.0 | 4442.6 | 666188.0 |
| 2023-05-23 | FEU3 | Futures | 97.868 | 97.868 | 97.868 | 97.868 | 0.0 |
| 2023-05-23 | FGBL | Futures | 134.8 | 134.87 | 134.25 | 134.59 | 755807.0 |
| 2023-05-23 | FGBM | Futures | 119.2 | 119.22 | 118.86 | 119.07 | 629987.0 |
| 2023-05-23 | FGBS | Futures | 108.062 | 108.077 | 107.944 | 108.026 | 484402.0 |
| 2023-05-23 | FGBX | Futures | 136.43 | 136.76 | 135.29 | 136.11 | 78449.0 |
| 2023-05-23 | FMWO | Futures | 10012.6 | 10012.6 | 9867.9 | 9955.0 | 2296.0 |
| 2023-05-23 | FOAT | Futures | 125.68 | 125.75 | 125.21 | 125.5 | 209540.0 |
| 2023-05-23 | FSMX | Futures | 29130.0 | 29251.5 | 28973.8 | 28984.3 | 28.0 |
| 2023-05-23 | FTDX | Futures | 3529.4 | 3529.4 | 3502.6 | 3502.6 | 27.0 |
| 2023-05-23 | FTI | Futures | 811.93 | 813.31 | 805.96 | 810.15 | 13525.0 |
| 2023-05-23 | FTUK | Futures | 7947.9 | 7962.2 | 7884.2 | 7919.4 | 80229.0 |
> showing 50 of 129 rows — these rows as CSV