PREVIEW / futures_daily / 2023-01-05
file: by_date/futures_daily/2023/2023-01-05.parquet size: 10 KB rows: 131
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-01-05 | ES | Futures | 4280.21 | 4296.24 | 4226.59 | 4233.77 | 1679973.0 |
| 2023-01-05 | NQ | Futures | 12332.67 | 12398.04 | 12126.72 | 12143.84 | 694452.0 |
| 2023-01-05 | YM | Futures | 36073.8 | 36167.8 | 35601.5 | 35738.8 | 173179.0 |
| 2023-01-05 | CL | Futures | 63.96 | 65.41 | 63.27 | 64.32 | 300731.0 |
| 2023-01-05 | GC | Futures | 2106.3 | 2109.8 | 2070.9 | 2083.0 | 188603.0 |
| 2023-01-05 | ZN | Futures | 116.446874 | 116.478984 | 115.676234 | 116.125774 | 1375647.0 |
| 2023-01-05 | A6 | Futures | 0.69917 | 0.70014 | 0.68881 | 0.69116 | 92280.0 |
| 2023-01-05 | AD | Futures | 0.75311 | 0.75362 | 0.74662 | 0.74819 | 73544.0 |
| 2023-01-05 | ALI | Futures | 2568.73 | 2602.02 | 2543.26 | 2551.38 | 1106.0 |
| 2023-01-05 | B | Futures | 68.3 | 69.88 | 67.82 | 68.76 | 259584.0 |
| 2023-01-05 | B6 | Futures | 1.2176 | 1.2195 | 1.1987 | 1.2033 | 97575.0 |
| 2023-01-05 | BFX | Futures | 4088.9 | 4088.9 | 4071.2 | 4085.1 | 11.0 |
| 2023-01-05 | BR | Futures | 0.16234 | 0.16515 | 0.16229 | 0.16462 | 3711.0 |
| 2023-01-05 | BTC | Futures | 23050.6 | 23160.3 | 22920.3 | 23091.7 | 3408.0 |
| 2023-01-05 | BZ | Futures | 67.52 | 69.14 | 67.11 | 68.04 | 28051.0 |
| 2023-01-05 | C | Futures | 1603.0 | 1627.0 | 1597.0 | 1620.0 | 11390.0 |
| 2023-01-05 | CB | Futures | 230.484 | 230.9 | 230.484 | 230.9 | 6.0 |
| 2023-01-05 | CC | Futures | 1521.0 | 1541.0 | 1518.0 | 1527.0 | 21327.0 |
| 2023-01-05 | CNH | Futures | 6.5201 | 6.5201 | 6.4934 | 6.5048 | 338.0 |
| 2023-01-05 | CSC | Futures | 2.377 | 2.404 | 2.377 | 2.399 | 80.0 |
| 2023-01-05 | CT | Futures | 105.57 | 109.8 | 105.56 | 108.29 | 16637.0 |
| 2023-01-05 | DC | Futures | 22.6 | 22.82 | 22.45 | 22.71 | 302.0 |
| 2023-01-05 | DX | Futures | 100.946 | 102.142 | 100.897 | 101.916 | 26336.0 |
| 2023-01-05 | E1 | Futures | 1.17693 | 1.18171 | 1.16693 | 1.16921 | 20886.0 |
| 2023-01-05 | E6 | Futures | 1.10255 | 1.1054 | 1.09324 | 1.09489 | 206216.0 |
| 2023-01-05 | E7 | Futures | 1.1021 | 1.1046 | 1.0926 | 1.0942 | 7717.0 |
| 2023-01-05 | EBM | Futures | 441.71 | 448.0 | 438.75 | 446.15 | 23917.0 |
| 2023-01-05 | ED | Futures | 94.4421 | 94.4421 | 94.3475 | 94.3824 | 84042.0 |
| 2023-01-05 | ER | Futures | 97.66 | 97.665 | 97.635 | 97.64 | 98785.0 |
| 2023-01-05 | ESG | Futures | 364.72 | 365.91 | 360.61 | 361.0 | 492.0 |
| 2023-01-05 | EW | Futures | 2654.2 | 2657.4 | 2608.5 | 2623.9 | 12394.0 |
| 2023-01-05 | FBON | Futures | 121.7 | 122.3 | 121.38 | 121.74 | 728.0 |
| 2023-01-05 | FBTP | Futures | 109.33 | 109.87 | 108.73 | 109.21 | 134670.0 |
| 2023-01-05 | FBTS | Futures | 106.353 | 106.353 | 106.102 | 106.152 | 104865.0 |
| 2023-01-05 | FCE | Futures | 7379.3 | 7425.7 | 7353.6 | 7388.0 | 51324.0 |
| 2023-01-05 | FDAX | Futures | 15719.1 | 15751.6 | 15631.6 | 15667.2 | 51511.0 |
| 2023-01-05 | FDIV | Futures | 172.66 | 173.01 | 172.36 | 172.61 | 46.0 |
| 2023-01-05 | FDXM | Futures | 15622.2 | 15655.5 | 15535.2 | 15572.8 | 40029.0 |
| 2023-01-05 | FDXS | Futures | 15534.8 | 15566.8 | 15442.9 | 15478.2 | 16426.0 |
| 2023-01-05 | FESX | Futures | 3956.7 | 3960.7 | 3929.9 | 3938.8 | 719764.0 |
| 2023-01-05 | FEU3 | Futures | 97.711 | 97.711 | 97.711 | 97.711 | 0.0 |
| 2023-01-05 | FGBL | Futures | 136.57 | 136.76 | 135.82 | 136.26 | 903073.0 |
| 2023-01-05 | FGBM | Futures | 119.94 | 119.94 | 119.46 | 119.71 | 508033.0 |
| 2023-01-05 | FGBS | Futures | 108.307 | 108.307 | 108.128 | 108.169 | 400980.0 |
| 2023-01-05 | FGBX | Futures | 147.04 | 148.18 | 145.58 | 146.61 | 79395.0 |
| 2023-01-05 | FMWO | Futures | 9267.5 | 9323.6 | 9182.8 | 9189.7 | 4324.0 |
| 2023-01-05 | FOAT | Futures | 127.71 | 127.93 | 126.95 | 127.42 | 258218.0 |
| 2023-01-05 | FSMX | Futures | 28229.7 | 28449.3 | 28190.5 | 28381.4 | 366.0 |
| 2023-01-05 | FTDX | Futures | 3207.9 | 3219.0 | 3207.9 | 3214.8 | 55.0 |
| 2023-01-05 | FTI | Futures | 736.36 | 739.03 | 732.87 | 734.64 | 19111.0 |
> showing 50 of 131 rows — these rows as CSV