PREVIEW / futures_daily / 2023-02-27
file: by_date/futures_daily/2023/2023-02-27.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-02-27 | ES | Futures | 4396.86 | 4450.22 | 4392.99 | 4409.58 | 1621961.0 |
| 2023-02-27 | NQ | Futures | 13471.27 | 13680.58 | 13456.68 | 13561.33 | 578952.0 |
| 2023-02-27 | YM | Futures | 35464.3 | 35891.2 | 35428.6 | 35564.8 | 156501.0 |
| 2023-02-27 | CL | Futures | 66.45 | 66.8 | 65.21 | 65.81 | 266091.0 |
| 2023-02-27 | GC | Futures | 2034.0 | 2044.4 | 2027.3 | 2041.7 | 130427.0 |
| 2023-02-27 | ZN | Futures | 113.942295 | 114.391835 | 113.76569 | 114.199175 | 814223.0 |
| 2023-02-27 | A6 | Futures | 0.68657 | 0.68836 | 0.68361 | 0.68739 | 70606.0 |
| 2023-02-27 | AD | Futures | 0.7455 | 0.74966 | 0.74469 | 0.74713 | 62285.0 |
| 2023-02-27 | ALI | Futures | 2570.14 | 2605.82 | 2570.14 | 2593.47 | 830.0 |
| 2023-02-27 | B | Futures | 72.52 | 72.87 | 71.25 | 71.81 | 235519.0 |
| 2023-02-27 | B6 | Futures | 1.2046 | 1.2166 | 1.2021 | 1.2158 | 91343.0 |
| 2023-02-27 | BFX | Futures | 4229.0 | 4229.0 | 4229.0 | 4229.0 | 0.0 |
| 2023-02-27 | BR | Futures | 0.17067 | 0.17113 | 0.17067 | 0.17113 | 2.0 |
| 2023-02-27 | BTC | Futures | 32029.0 | 32701.8 | 31580.5 | 31865.9 | 6664.0 |
| 2023-02-27 | BZ | Futures | 72.19 | 72.66 | 71.03 | 71.58 | 19259.0 |
| 2023-02-27 | C | Futures | 1637.0 | 1661.0 | 1628.0 | 1640.0 | 8213.0 |
| 2023-02-27 | CB | Futures | 245.484 | 245.484 | 245.484 | 245.484 | 10.0 |
| 2023-02-27 | CC | Futures | 1575.0 | 1603.0 | 1570.0 | 1582.0 | 22647.0 |
| 2023-02-27 | CNH | Futures | 6.6204 | 6.6299 | 6.6003 | 6.6033 | 1395.0 |
| 2023-02-27 | CSC | Futures | 2.274 | 2.278 | 2.272 | 2.278 | 55.0 |
| 2023-02-27 | CT | Futures | 110.27 | 110.4 | 108.19 | 110.14 | 13870.0 |
| 2023-02-27 | DC | Futures | 21.89 | 21.89 | 21.63 | 21.87 | 108.0 |
| 2023-02-27 | DX | Futures | 102.287 | 102.394 | 101.587 | 101.718 | 17992.0 |
| 2023-02-27 | E1 | Futures | 1.15677 | 1.16476 | 1.15422 | 1.16285 | 18177.0 |
| 2023-02-27 | E6 | Futures | 1.09236 | 1.10022 | 1.09117 | 1.09903 | 177211.0 |
| 2023-02-27 | E7 | Futures | 1.0918 | 1.0994 | 1.0904 | 1.0983 | 4366.0 |
| 2023-02-27 | EBM | Futures | 410.29 | 413.99 | 409.18 | 410.29 | 7196.0 |
| 2023-02-27 | ED | Futures | 94.4346 | 94.4421 | 94.4246 | 94.4371 | 50608.0 |
| 2023-02-27 | ER | Futures | 97.731 | 97.746 | 97.721 | 97.746 | 85530.0 |
| 2023-02-27 | ESG | Futures | 376.5 | 379.09 | 375.35 | 376.04 | 319.0 |
| 2023-02-27 | EW | Futures | 2795.0 | 2834.2 | 2792.4 | 2802.7 | 10059.0 |
| 2023-02-27 | FBON | Futures | 120.32 | 120.66 | 119.89 | 120.13 | 101.0 |
| 2023-02-27 | FBTP | Futures | 110.12 | 110.61 | 109.9 | 110.3 | 140902.0 |
| 2023-02-27 | FBTS | Futures | 105.57 | 105.73 | 105.57 | 105.72 | 137663.0 |
| 2023-02-27 | FCE | Futures | 7844.4 | 7958.3 | 7844.4 | 7926.8 | 58043.0 |
| 2023-02-27 | FDAX | Futures | 16490.8 | 16756.7 | 16485.4 | 16670.2 | 77255.0 |
| 2023-02-27 | FDIV | Futures | 181.81 | 181.81 | 181.56 | 181.81 | 12.0 |
| 2023-02-27 | FDXM | Futures | 16394.6 | 16655.7 | 16391.4 | 16569.8 | 45509.0 |
| 2023-02-27 | FDXS | Futures | 16270.4 | 16553.4 | 16270.4 | 16469.0 | 23650.0 |
| 2023-02-27 | FESX | Futures | 4174.3 | 4244.9 | 4171.4 | 4228.0 | 970343.0 |
| 2023-02-27 | FEU3 | Futures | 97.812 | 97.812 | 97.812 | 97.812 | 0.0 |
| 2023-02-27 | FGBL | Futures | 134.46 | 134.63 | 133.67 | 133.9 | 705908.0 |
| 2023-02-27 | FGBM | Futures | 118.45 | 118.56 | 118.09 | 118.23 | 602523.0 |
| 2023-02-27 | FGBS | Futures | 107.682 | 107.708 | 107.554 | 107.6 | 669887.0 |
| 2023-02-27 | FGBX | Futures | 141.18 | 141.63 | 138.67 | 139.08 | 80510.0 |
| 2023-02-27 | FMWO | Futures | 9574.3 | 9671.6 | 9574.3 | 9614.4 | 2135.0 |
| 2023-02-27 | FOAT | Futures | 125.67 | 125.86 | 125.02 | 125.21 | 143252.0 |
| 2023-02-27 | FSMX | Futures | 30412.7 | 30574.0 | 30382.0 | 30441.4 | 150.0 |
| 2023-02-27 | FTDX | Futures | 3455.2 | 3455.2 | 3454.1 | 3454.1 | 1.0 |
| 2023-02-27 | FTI | Futures | 782.13 | 793.55 | 782.08 | 790.15 | 18268.0 |
> showing 50 of 131 rows — these rows as CSV