PREVIEW / futures_daily / 2022-09-29
file: by_date/futures_daily/2022/2022-09-29.parquet size: 10 KB rows: 128
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 |
|---|---|---|---|---|---|---|---|
| 2022-09-29 | ES | Futures | 4157.65 | 4164.06 | 4037.0 | 4072.95 | 2860631.0 |
| 2022-09-29 | NQ | Futures | 13082.24 | 13108.58 | 12569.44 | 12724.41 | 891823.0 |
| 2022-09-29 | YM | Futures | 32376.9 | 32408.5 | 31607.6 | 31866.6 | 191743.0 |
| 2022-09-29 | CL | Futures | 70.01 | 70.9 | 68.67 | 69.43 | 286126.0 |
| 2022-09-29 | GC | Futures | 1910.0 | 1914.7 | 1887.5 | 1909.6 | 201961.0 |
| 2022-09-29 | ZN | Futures | 115.866083 | 115.898233 | 114.85338 | 115.689262 | 1953819.0 |
| 2022-09-29 | A6 | Futures | 0.66747 | 0.66793 | 0.65898 | 0.66302 | 105723.0 |
| 2022-09-29 | AD | Futures | 0.7456 | 0.7456 | 0.73744 | 0.73972 | 120765.0 |
| 2022-09-29 | ALI | Futures | 2398.13 | 2580.95 | 2385.85 | 2475.17 | 651.0 |
| 2022-09-29 | B | Futures | 75.14 | 76.1 | 73.88 | 74.76 | 284217.0 |
| 2022-09-29 | B6 | Futures | 1.0995 | 1.1237 | 1.0867 | 1.1169 | 237093.0 |
| 2022-09-29 | BR | Futures | 0.16037 | 0.16063 | 0.16037 | 0.16063 | 220.0 |
| 2022-09-29 | BTC | Futures | 27275.5 | 27331.1 | 26078.4 | 26962.3 | 8360.0 |
| 2022-09-29 | BZ | Futures | 73.83 | 74.55 | 72.4 | 73.24 | 38007.0 |
| 2022-09-29 | C | Futures | 1392.0 | 1415.0 | 1388.0 | 1392.0 | 17034.0 |
| 2022-09-29 | CB | Futures | 243.867 | 244.072 | 242.703 | 242.703 | 27.0 |
| 2022-09-29 | CC | Futures | 1347.0 | 1366.0 | 1346.0 | 1363.0 | 24438.0 |
| 2022-09-29 | CNH | Futures | 6.7631 | 6.8474 | 6.6873 | 6.6932 | 2407.0 |
| 2022-09-29 | CSC | Futures | 2.553 | 2.553 | 2.541 | 2.541 | 21.0 |
| 2022-09-29 | CT | Futures | 114.61 | 115.17 | 110.08 | 110.29 | 20614.0 |
| 2022-09-29 | DC | Futures | 25.21 | 25.32 | 24.79 | 24.79 | 94.0 |
| 2022-09-29 | DX | Futures | 109.603 | 110.341 | 108.623 | 108.868 | 56441.0 |
| 2022-09-29 | E1 | Futures | 1.13179 | 1.13217 | 1.12017 | 1.12888 | 28139.0 |
| 2022-09-29 | E6 | Futures | 1.01901 | 1.02723 | 1.00839 | 1.02468 | 295624.0 |
| 2022-09-29 | E7 | Futures | 1.0173 | 1.0254 | 1.0067 | 1.023 | 10691.0 |
| 2022-09-29 | EBM | Futures | 500.75 | 505.72 | 495.43 | 499.69 | 26042.0 |
| 2022-09-29 | ED | Futures | 94.4438 | 94.4587 | 94.3546 | 94.4438 | 152856.0 |
| 2022-09-29 | ER | Futures | 97.646 | 97.711 | 97.591 | 97.686 | 180771.0 |
| 2022-09-29 | ESG | Futures | 350.65 | 353.01 | 345.38 | 348.32 | 1593.0 |
| 2022-09-29 | EW | Futures | 2457.9 | 2459.8 | 2380.1 | 2407.3 | 19566.0 |
| 2022-09-29 | FBON | Futures | 120.69 | 121.04 | 120.06 | 120.62 | 114.0 |
| 2022-09-29 | FBTP | Futures | 105.01 | 105.21 | 103.91 | 104.67 | 202872.0 |
| 2022-09-29 | FBTS | Futures | 104.581 | 104.871 | 104.391 | 104.741 | 140674.0 |
| 2022-09-29 | FCE | Futures | 6293.8 | 6301.5 | 6142.1 | 6196.2 | 85016.0 |
| 2022-09-29 | FDAX | Futures | 13432.5 | 13444.6 | 12970.8 | 13073.4 | 97281.0 |
| 2022-09-29 | FDIV | Futures | 143.33 | 143.33 | 141.64 | 141.64 | 18.0 |
| 2022-09-29 | FDXM | Futures | 13244.7 | 13246.8 | 12780.1 | 12879.1 | 65674.0 |
| 2022-09-29 | FDXS | Futures | 13156.4 | 13176.7 | 12716.6 | 12815.0 | 46307.0 |
| 2022-09-29 | FESX | Futures | 3320.2 | 3323.1 | 3209.3 | 3234.1 | 1297677.0 |
| 2022-09-29 | FGBL | Futures | 138.12 | 138.28 | 136.01 | 137.29 | 989178.0 |
| 2022-09-29 | FGBM | Futures | 121.13 | 121.17 | 120.2 | 120.94 | 666629.0 |
| 2022-09-29 | FGBS | Futures | 109.223 | 109.335 | 108.942 | 109.259 | 642103.0 |
| 2022-09-29 | FGBX | Futures | 153.3 | 153.37 | 147.58 | 148.79 | 91046.0 |
| 2022-09-29 | FMWO | Futures | 8755.4 | 8756.6 | 8525.4 | 8578.9 | 6234.0 |
| 2022-09-29 | FOAT | Futures | 127.62 | 127.68 | 125.42 | 126.51 | 209043.0 |
| 2022-09-29 | FSMX | Futures | 23543.0 | 23543.0 | 22875.9 | 23050.3 | 352.0 |
| 2022-09-29 | FTDX | Futures | 2814.4 | 2821.9 | 2768.6 | 2776.6 | 297.0 |
| 2022-09-29 | FTI | Futures | 647.5 | 648.76 | 635.67 | 640.52 | 31280.0 |
| 2022-09-29 | FTUK | Futures | 7102.4 | 7113.5 | 6901.1 | 6936.9 | 165088.0 |
| 2022-09-29 | FVSA | Futures | 72.46 | 77.98 | 72.46 | 77.04 | 23063.0 |
> showing 50 of 128 rows — these rows as CSV