PREVIEW / futures_daily / 2023-01-06
file: by_date/futures_daily/2023/2023-01-06.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-06 | ES | Futures | 4238.19 | 4344.07 | 4222.72 | 4329.42 | 2026154.0 |
| 2023-01-06 | NQ | Futures | 12164.6 | 12531.6 | 12066.12 | 12472.96 | 736332.0 |
| 2023-01-06 | YM | Futures | 35751.7 | 36595.8 | 35697.7 | 36497.4 | 238427.0 |
| 2023-01-06 | CL | Futures | 64.58 | 65.89 | 63.95 | 64.41 | 258128.0 |
| 2023-01-06 | GC | Futures | 2077.7 | 2122.2 | 2076.9 | 2115.9 | 215367.0 |
| 2023-01-06 | ZN | Futures | 116.125774 | 117.506504 | 115.740454 | 117.362009 | 2171557.0 |
| 2023-01-06 | A6 | Futures | 0.69065 | 0.70432 | 0.68672 | 0.70386 | 101320.0 |
| 2023-01-06 | AD | Futures | 0.74819 | 0.75565 | 0.74266 | 0.7556 | 98157.0 |
| 2023-01-06 | ALI | Futures | 2576.56 | 2623.29 | 2551.94 | 2583.84 | 1987.0 |
| 2023-01-06 | B | Futures | 68.86 | 70.42 | 68.21 | 68.66 | 215424.0 |
| 2023-01-06 | B6 | Futures | 1.2027 | 1.2217 | 1.1956 | 1.2214 | 103736.0 |
| 2023-01-06 | BFX | Futures | 4124.3 | 4124.3 | 4124.3 | 4124.3 | 0.0 |
| 2023-01-06 | BR | Futures | 0.16444 | 0.16872 | 0.16435 | 0.1685 | 605.0 |
| 2023-01-06 | BTC | Futures | 23071.2 | 23427.7 | 22824.4 | 23167.2 | 6144.0 |
| 2023-01-06 | BZ | Futures | 68.14 | 69.67 | 67.49 | 67.94 | 23767.0 |
| 2023-01-06 | C | Futures | 1622.0 | 1625.0 | 1601.0 | 1602.0 | 6368.0 |
| 2023-01-06 | CB | Futures | 230.924 | 230.924 | 230.924 | 230.924 | 1.0 |
| 2023-01-06 | CC | Futures | 1527.0 | 1528.0 | 1501.0 | 1520.0 | 20198.0 |
| 2023-01-06 | CNH | Futures | 6.5048 | 6.5048 | 6.446 | 6.4526 | 1535.0 |
| 2023-01-06 | CSC | Futures | 2.405 | 2.415 | 2.404 | 2.415 | 39.0 |
| 2023-01-06 | CT | Futures | 108.29 | 112.9 | 107.67 | 112.35 | 16468.0 |
| 2023-01-06 | DC | Futures | 22.93 | 22.94 | 22.63 | 22.87 | 290.0 |
| 2023-01-06 | DX | Futures | 101.928 | 102.569 | 100.742 | 100.767 | 38586.0 |
| 2023-01-06 | E1 | Futures | 1.16851 | 1.18041 | 1.16188 | 1.17997 | 20493.0 |
| 2023-01-06 | E6 | Futures | 1.09411 | 1.10716 | 1.08982 | 1.1069 | 233778.0 |
| 2023-01-06 | E7 | Futures | 1.0933 | 1.1064 | 1.0887 | 1.1062 | 8848.0 |
| 2023-01-06 | EBM | Futures | 445.78 | 448.0 | 442.45 | 443.56 | 12939.0 |
| 2023-01-06 | ED | Futures | 94.3724 | 94.4421 | 94.3525 | 94.4271 | 98417.0 |
| 2023-01-06 | ER | Futures | 97.65 | 97.655 | 97.62 | 97.65 | 122500.0 |
| 2023-01-06 | ESG | Futures | 361.65 | 370.4 | 360.87 | 368.91 | 921.0 |
| 2023-01-06 | EW | Futures | 2626.3 | 2696.0 | 2622.4 | 2690.9 | 14176.0 |
| 2023-01-06 | FBON | Futures | 122.26 | 123.1 | 121.41 | 123.08 | 142.0 |
| 2023-01-06 | FBTP | Futures | 109.47 | 110.73 | 108.72 | 110.58 | 125107.0 |
| 2023-01-06 | FBTS | Futures | 106.202 | 106.363 | 105.961 | 106.343 | 84845.0 |
| 2023-01-06 | FCE | Futures | 7427.3 | 7526.2 | 7383.1 | 7497.2 | 53243.0 |
| 2023-01-06 | FDAX | Futures | 15694.3 | 15935.3 | 15613.2 | 15849.9 | 59281.0 |
| 2023-01-06 | FDIV | Futures | 174.94 | 174.94 | 174.64 | 174.64 | 2.0 |
| 2023-01-06 | FDXM | Futures | 15606.1 | 15838.2 | 15518.0 | 15754.4 | 48378.0 |
| 2023-01-06 | FDXS | Futures | 15489.9 | 15741.9 | 15422.6 | 15658.6 | 20267.0 |
| 2023-01-06 | FESX | Futures | 3945.8 | 4019.3 | 3932.9 | 3997.5 | 813512.0 |
| 2023-01-06 | FEU3 | Futures | 97.716 | 97.716 | 97.716 | 97.716 | 0.0 |
| 2023-01-06 | FGBL | Futures | 136.35 | 137.75 | 136.01 | 137.71 | 753862.0 |
| 2023-01-06 | FGBM | Futures | 119.77 | 120.39 | 119.47 | 120.31 | 485484.0 |
| 2023-01-06 | FGBS | Futures | 108.205 | 108.358 | 108.082 | 108.327 | 353635.0 |
| 2023-01-06 | FGBX | Futures | 146.63 | 150.06 | 146.48 | 149.98 | 58343.0 |
| 2023-01-06 | FMWO | Futures | 9238.9 | 9430.1 | 9170.2 | 9348.8 | 2621.0 |
| 2023-01-06 | FOAT | Futures | 127.5 | 128.83 | 127.09 | 128.78 | 152222.0 |
| 2023-01-06 | FSMX | Futures | 28403.7 | 29040.1 | 28208.5 | 28728.3 | 632.0 |
| 2023-01-06 | FTDX | Futures | 3219.0 | 3243.6 | 3192.9 | 3238.2 | 14.0 |
| 2023-01-06 | FTI | Futures | 739.34 | 749.72 | 732.25 | 744.84 | 21870.0 |
> showing 50 of 131 rows — these rows as CSV