PREVIEW / futures_daily / 2023-04-18
file: by_date/futures_daily/2023/2023-04-18.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-04-18 | ES | Futures | 4570.56 | 4593.82 | 4556.89 | 4573.85 | 1427797.0 |
| 2023-04-18 | NQ | Futures | 14615.14 | 14742.35 | 14564.15 | 14625.12 | 576668.0 |
| 2023-04-18 | YM | Futures | 36565.0 | 36740.8 | 36356.1 | 36566.1 | 140669.0 |
| 2023-04-18 | CL | Futures | 70.62 | 71.07 | 69.67 | 70.53 | 311775.0 |
| 2023-04-18 | GC | Futures | 2227.9 | 2246.4 | 2222.8 | 2241.0 | 164975.0 |
| 2023-04-18 | ZN | Futures | 116.946258 | 117.329951 | 116.898297 | 117.138104 | 1146560.0 |
| 2023-04-18 | A6 | Futures | 0.68301 | 0.68753 | 0.68235 | 0.6854 | 57075.0 |
| 2023-04-18 | AD | Futures | 0.75703 | 0.75901 | 0.75663 | 0.75713 | 59992.0 |
| 2023-04-18 | ALI | Futures | 2622.39 | 2675.12 | 2615.84 | 2671.84 | 3297.0 |
| 2023-04-18 | B | Futures | 74.54 | 75.13 | 73.72 | 74.57 | 315698.0 |
| 2023-04-18 | B6 | Futures | 1.2449 | 1.2521 | 1.2438 | 1.25 | 74799.0 |
| 2023-04-18 | BFX | Futures | 4147.6 | 4147.6 | 4147.6 | 4147.6 | 0.0 |
| 2023-04-18 | BR | Futures | 0.18183 | 0.18241 | 0.17975 | 0.17989 | 234.0 |
| 2023-04-18 | BTC | Futures | 40248.0 | 41657.5 | 39689.7 | 41296.6 | 5579.0 |
| 2023-04-18 | BZ | Futures | 74.23 | 74.74 | 73.35 | 74.18 | 27241.0 |
| 2023-04-18 | C | Futures | 1736.0 | 1759.0 | 1729.0 | 1757.0 | 4120.0 |
| 2023-04-18 | CB | Futures | 233.934 | 233.934 | 233.641 | 233.641 | 36.0 |
| 2023-04-18 | CC | Futures | 1701.0 | 1729.0 | 1686.0 | 1721.0 | 31611.0 |
| 2023-04-18 | CNH | Futures | 6.5331 | 6.5459 | 6.528 | 6.5459 | 143.0 |
| 2023-04-18 | CSC | Futures | 2.214 | 2.24 | 2.192 | 2.217 | 182.0 |
| 2023-04-18 | CT | Futures | 108.19 | 110.31 | 108.06 | 109.81 | 10075.0 |
| 2023-04-18 | DC | Futures | 20.76 | 21.32 | 20.66 | 20.92 | 434.0 |
| 2023-04-18 | DX | Futures | 99.531 | 99.555 | 99.047 | 99.157 | 10907.0 |
| 2023-04-18 | E1 | Futures | 1.20009 | 1.20422 | 1.19977 | 1.20223 | 15522.0 |
| 2023-04-18 | E6 | Futures | 1.12738 | 1.1333 | 1.12692 | 1.13211 | 141469.0 |
| 2023-04-18 | E7 | Futures | 1.1271 | 1.1329 | 1.1264 | 1.1316 | 4891.0 |
| 2023-04-18 | EBM | Futures | 379.96 | 387.73 | 378.11 | 385.88 | 48933.0 |
| 2023-04-18 | ER | Futures | 97.858 | 97.889 | 97.833 | 97.873 | 160392.0 |
| 2023-04-18 | ESG | Futures | 395.15 | 396.05 | 393.24 | 394.46 | 380.0 |
| 2023-04-18 | EW | Futures | 2694.0 | 2709.2 | 2675.8 | 2688.6 | 8418.0 |
| 2023-04-18 | FBON | Futures | 120.51 | 121.01 | 120.29 | 120.92 | 136.0 |
| 2023-04-18 | FBTP | Futures | 110.89 | 111.47 | 110.56 | 111.14 | 131002.0 |
| 2023-04-18 | FBTS | Futures | 106.178 | 106.29 | 106.087 | 106.209 | 77429.0 |
| 2023-04-18 | FCE | Futures | 8115.2 | 8180.0 | 8104.8 | 8138.1 | 61559.0 |
| 2023-04-18 | FDAX | Futures | 17013.9 | 17127.0 | 17000.1 | 17072.6 | 45579.0 |
| 2023-04-18 | FDIV | Futures | 189.35 | 189.35 | 189.19 | 189.19 | 15.0 |
| 2023-04-18 | FDXM | Futures | 17165.4 | 17273.0 | 17145.0 | 17218.1 | 29460.0 |
| 2023-04-18 | FDXS | Futures | 17050.1 | 17155.9 | 17029.8 | 17102.5 | 14202.0 |
| 2023-04-18 | FESX | Futures | 4414.0 | 4448.7 | 4413.0 | 4433.4 | 693486.0 |
| 2023-04-18 | FEU3 | Futures | 97.878 | 97.883 | 97.878 | 97.883 | 9.0 |
| 2023-04-18 | FGBL | Futures | 134.55 | 134.98 | 134.21 | 134.68 | 714205.0 |
| 2023-04-18 | FGBM | Futures | 118.87 | 119.06 | 118.63 | 118.87 | 492085.0 |
| 2023-04-18 | FGBS | Futures | 107.97 | 108.031 | 107.847 | 107.964 | 337052.0 |
| 2023-04-18 | FGBX | Futures | 138.23 | 139.37 | 137.52 | 138.84 | 75881.0 |
| 2023-04-18 | FMWO | Futures | 9950.4 | 10004.7 | 9942.5 | 9951.6 | 4694.0 |
| 2023-04-18 | FOAT | Futures | 125.64 | 126.09 | 125.35 | 125.77 | 135769.0 |
| 2023-04-18 | FSMX | Futures | 29771.9 | 29897.6 | 29722.3 | 29746.6 | 551.0 |
| 2023-04-18 | FTDX | Futures | 3584.5 | 3604.9 | 3573.3 | 3573.3 | 53.0 |
| 2023-04-18 | FTI | Futures | 800.11 | 807.05 | 798.84 | 803.13 | 7668.0 |
| 2023-04-18 | FTUK | Futures | 8050.9 | 8071.8 | 8033.1 | 8061.1 | 72162.0 |
> showing 50 of 130 rows — these rows as CSV