PREVIEW / futures_daily / 2023-11-09
file: by_date/futures_daily/2023/2023-11-09.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-11-09 | ES | Futures | 4702.43 | 4723.57 | 4664.43 | 4669.25 | 1972630.0 |
| 2023-11-09 | NQ | Futures | 16572.77 | 16678.0 | 16443.81 | 16464.58 | 710427.0 |
| 2023-11-09 | YM | Futures | 35947.6 | 36078.0 | 35690.8 | 35721.3 | 158262.0 |
| 2023-11-09 | CL | Futures | 67.72 | 69.07 | 67.33 | 67.8 | 303430.0 |
| 2023-11-09 | GC | Futures | 2105.5 | 2122.7 | 2097.7 | 2120.9 | 214077.0 |
| 2023-11-09 | ZN | Futures | 109.945555 | 110.040609 | 108.915806 | 109.026702 | 2122373.0 |
| 2023-11-09 | A6 | Futures | 0.64614 | 0.64876 | 0.64211 | 0.64271 | 92399.0 |
| 2023-11-09 | AD | Futures | 0.73124 | 0.73371 | 0.73003 | 0.73023 | 75567.0 |
| 2023-11-09 | ALI | Futures | 2466.49 | 2467.58 | 2443.75 | 2450.05 | 2593.0 |
| 2023-11-09 | B | Futures | 72.46 | 74.08 | 72.22 | 72.74 | 306111.0 |
| 2023-11-09 | B6 | Futures | 1.2293 | 1.2316 | 1.222 | 1.2228 | 88535.0 |
| 2023-11-09 | BR | Futures | 0.19152 | 0.19204 | 0.18992 | 0.19077 | 10846.0 |
| 2023-11-09 | BTC | Futures | 47308.3 | 50310.1 | 47013.4 | 48245.6 | 16525.0 |
| 2023-11-09 | BZ | Futures | 72.2 | 73.74 | 71.9 | 72.41 | 32592.0 |
| 2023-11-09 | C | Futures | 2841.0 | 2897.0 | 2839.0 | 2893.0 | 5792.0 |
| 2023-11-09 | CB | Futures | 257.547 | 257.547 | 254.6 | 257.547 | 31.0 |
| 2023-11-09 | CC | Futures | 2292.0 | 2314.0 | 2285.0 | 2298.0 | 32345.0 |
| 2023-11-09 | CNH | Futures | 7.0445 | 7.0585 | 7.0387 | 7.0566 | 7004.0 |
| 2023-11-09 | CSC | Futures | 1.952 | 1.952 | 1.922 | 1.926 | 128.0 |
| 2023-11-09 | CT | Futures | 91.44 | 94.23 | 91.32 | 93.3 | 35683.0 |
| 2023-11-09 | DC | Futures | 18.44 | 18.6 | 18.26 | 18.33 | 902.0 |
| 2023-11-09 | DX | Futures | 104.002 | 104.397 | 103.815 | 104.347 | 16141.0 |
| 2023-11-09 | E1 | Futures | 1.17156 | 1.17198 | 1.16506 | 1.16579 | 16579.0 |
| 2023-11-09 | E6 | Futures | 1.09123 | 1.09281 | 1.08619 | 1.08691 | 165952.0 |
| 2023-11-09 | E7 | Futures | 1.0913 | 1.0929 | 1.0864 | 1.0871 | 4832.0 |
| 2023-11-09 | EBM | Futures | 323.85 | 324.54 | 318.36 | 320.08 | 37692.0 |
| 2023-11-09 | ER | Futures | 97.792 | 97.797 | 97.787 | 97.792 | 67762.0 |
| 2023-11-09 | ESG | Futures | 408.86 | 409.82 | 404.58 | 404.81 | 989.0 |
| 2023-11-09 | EW | Futures | 2555.1 | 2574.2 | 2525.3 | 2529.6 | 12118.0 |
| 2023-11-09 | FBON | Futures | 120.64 | 120.66 | 120.22 | 120.31 | 32.0 |
| 2023-11-09 | FBTP | Futures | 111.68 | 111.75 | 111.11 | 111.4 | 198745.0 |
| 2023-11-09 | FBTS | Futures | 105.997 | 106.007 | 105.926 | 105.987 | 120468.0 |
| 2023-11-09 | FCE | Futures | 7503.7 | 7602.4 | 7497.3 | 7592.8 | 50926.0 |
| 2023-11-09 | FDAX | Futures | 16092.6 | 16251.7 | 16078.9 | 16231.7 | 59606.0 |
| 2023-11-09 | FDIV | Futures | 169.68 | 169.93 | 169.68 | 169.93 | 5.0 |
| 2023-11-09 | FDXM | Futures | 16087.3 | 16245.3 | 16072.6 | 16225.3 | 46452.0 |
| 2023-11-09 | FDXS | Futures | 15969.7 | 16140.2 | 15968.7 | 16119.3 | 23061.0 |
| 2023-11-09 | FESX | Futures | 4214.7 | 4276.1 | 4214.7 | 4270.0 | 908984.0 |
| 2023-11-09 | FEU3 | Futures | 97.787 | 97.787 | 97.787 | 97.787 | 8.0 |
| 2023-11-09 | FGBL | Futures | 132.97 | 133.11 | 131.93 | 132.61 | 950924.0 |
| 2023-11-09 | FGBM | Futures | 117.99 | 118.06 | 117.67 | 117.92 | 695166.0 |
| 2023-11-09 | FGBS | Futures | 107.178 | 107.188 | 107.111 | 107.157 | 554103.0 |
| 2023-11-09 | FGBX | Futures | 130.86 | 131.1 | 126.98 | 128.85 | 144399.0 |
| 2023-11-09 | FMWO | Futures | 9968.6 | 10027.1 | 9912.3 | 10008.3 | 3204.0 |
| 2023-11-09 | FOAT | Futures | 124.18 | 124.26 | 123.11 | 123.82 | 170661.0 |
| 2023-11-09 | FSMX | Futures | 26246.4 | 26657.2 | 26237.1 | 26620.3 | 480.0 |
| 2023-11-09 | FTDX | Futures | 3139.1 | 3155.2 | 3139.1 | 3152.1 | 13.0 |
| 2023-11-09 | FTI | Futures | 758.76 | 770.71 | 757.21 | 769.92 | 23685.0 |
| 2023-11-09 | FTUK | Futures | 7451.6 | 7538.2 | 7436.0 | 7527.6 | 99693.0 |
| 2023-11-09 | FVSA | Futures | 22.58 | 23.06 | 21.82 | 22.1 | 27072.0 |
> showing 50 of 129 rows — these rows as CSV