PREVIEW / futures_daily / 2023-10-04
file: by_date/futures_daily/2023/2023-10-04.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-10-04 | ES | Futures | 4562.74 | 4606.9 | 4533.58 | 4600.21 | 2168271.0 |
| 2023-10-04 | NQ | Futures | 15879.38 | 16140.82 | 15744.74 | 16106.01 | 803257.0 |
| 2023-10-04 | YM | Futures | 34914.1 | 35103.6 | 34750.0 | 35070.9 | 232770.0 |
| 2023-10-04 | CL | Futures | 78.84 | 78.99 | 74.2 | 74.26 | 459995.0 |
| 2023-10-04 | GC | Futures | 1979.7 | 1988.4 | 1972.1 | 1975.5 | 195048.0 |
| 2023-10-04 | ZN | Futures | 108.107848 | 108.694013 | 107.585052 | 108.59896 | 2537554.0 |
| 2023-10-04 | A6 | Futures | 0.63707 | 0.6411 | 0.63546 | 0.63898 | 135503.0 |
| 2023-10-04 | AD | Futures | 0.73603 | 0.73709 | 0.73235 | 0.73396 | 121100.0 |
| 2023-10-04 | ALI | Futures | 2523.72 | 2523.72 | 2465.64 | 2477.75 | 6349.0 |
| 2023-10-04 | B | Futures | 81.92 | 82.07 | 77.16 | 77.21 | 525561.0 |
| 2023-10-04 | B6 | Futures | 1.2085 | 1.2187 | 1.2048 | 1.2148 | 135840.0 |
| 2023-10-04 | BFX | Futures | 3745.6 | 3745.6 | 3745.6 | 3745.6 | 0.0 |
| 2023-10-04 | BR | Futures | 0.18064 | 0.18229 | 0.17998 | 0.18154 | 232.0 |
| 2023-10-04 | BTC | Futures | 36750.4 | 37411.4 | 36416.5 | 37090.9 | 5558.0 |
| 2023-10-04 | BZ | Futures | 81.67 | 81.87 | 76.97 | 77.04 | 49185.0 |
| 2023-10-04 | C | Futures | 2472.0 | 2477.0 | 2450.0 | 2462.0 | 6192.0 |
| 2023-10-04 | CB | Futures | 269.434 | 271.415 | 269.434 | 271.415 | 1.0 |
| 2023-10-04 | CC | Futures | 1992.0 | 2015.0 | 1989.0 | 2002.0 | 15882.0 |
| 2023-10-04 | CNH | Futures | 7.076 | 7.0837 | 7.0658 | 7.0745 | 221.0 |
| 2023-10-04 | CSC | Futures | 2.0 | 2.0 | 1.983 | 1.989 | 302.0 |
| 2023-10-04 | CT | Futures | 106.98 | 107.21 | 105.63 | 106.09 | 12113.0 |
| 2023-10-04 | DC | Futures | 18.81 | 18.82 | 18.62 | 18.72 | 243.0 |
| 2023-10-04 | DX | Futures | 105.363 | 105.521 | 104.806 | 105.087 | 16093.0 |
| 2023-10-04 | E1 | Futures | 1.148 | 1.15661 | 1.14554 | 1.15341 | 24081.0 |
| 2023-10-04 | E6 | Futures | 1.06808 | 1.075 | 1.06666 | 1.072 | 234369.0 |
| 2023-10-04 | E7 | Futures | 1.0684 | 1.0752 | 1.067 | 1.0722 | 4513.0 |
| 2023-10-04 | EBM | Futures | 323.16 | 323.85 | 319.39 | 321.11 | 37712.0 |
| 2023-10-04 | ER | Futures | 97.777 | 97.782 | 97.766 | 97.777 | 105742.0 |
| 2023-10-04 | ESG | Futures | 392.85 | 398.65 | 392.79 | 398.26 | 1274.0 |
| 2023-10-04 | EW | Futures | 2557.9 | 2576.4 | 2540.0 | 2573.2 | 14597.0 |
| 2023-10-04 | FBON | Futures | 116.36 | 117.24 | 116.13 | 116.85 | 165.0 |
| 2023-10-04 | FBTP | Futures | 106.81 | 107.76 | 106.43 | 107.18 | 251274.0 |
| 2023-10-04 | FBTS | Futures | 105.228 | 105.4 | 105.096 | 105.289 | 163455.0 |
| 2023-10-04 | FCE | Futures | 7538.6 | 7606.5 | 7493.4 | 7547.3 | 67701.0 |
| 2023-10-04 | FDAX | Futures | 16022.0 | 16114.7 | 15872.4 | 16028.3 | 69989.0 |
| 2023-10-04 | FDIV | Futures | 171.07 | 172.62 | 171.07 | 172.27 | 3.0 |
| 2023-10-04 | FDXM | Futures | 16009.4 | 16109.5 | 15867.2 | 16022.0 | 46258.0 |
| 2023-10-04 | FDXS | Futures | 15871.4 | 16003.2 | 15763.6 | 15917.4 | 33359.0 |
| 2023-10-04 | FESX | Futures | 4149.2 | 4179.4 | 4110.9 | 4151.2 | 918712.0 |
| 2023-10-04 | FEU3 | Futures | 97.771 | 97.771 | 97.771 | 97.771 | 0.0 |
| 2023-10-04 | FGBL | Futures | 129.28 | 129.87 | 128.73 | 129.49 | 1083204.0 |
| 2023-10-04 | FGBM | Futures | 116.59 | 116.83 | 116.39 | 116.67 | 681025.0 |
| 2023-10-04 | FGBS | Futures | 107.014 | 107.076 | 106.948 | 107.035 | 617801.0 |
| 2023-10-04 | FGBX | Futures | 120.74 | 122.69 | 119.41 | 121.71 | 142721.0 |
| 2023-10-04 | FMWO | Futures | 9698.2 | 9774.3 | 9629.7 | 9721.3 | 4704.0 |
| 2023-10-04 | FOAT | Futures | 120.39 | 120.93 | 119.79 | 120.52 | 222659.0 |
| 2023-10-04 | FSMX | Futures | 25822.2 | 26282.3 | 25822.2 | 26132.4 | 585.0 |
| 2023-10-04 | FTDX | Futures | 3076.3 | 3124.1 | 3075.2 | 3124.1 | 5.0 |
| 2023-10-04 | FTI | Futures | 745.66 | 754.38 | 743.38 | 749.48 | 17762.0 |
| 2023-10-04 | FTUK | Futures | 7575.0 | 7588.1 | 7478.8 | 7504.5 | 120332.0 |
> showing 50 of 130 rows — these rows as CSV