PREVIEW / futures_daily / 2022-06-27
file: by_date/futures_daily/2022/2022-06-27.parquet size: 10 KB rows: 114
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-06-27 | ES | Futures | 4391.88 | 4428.9 | 4366.64 | 4379.26 | 1497368.0 |
| 2022-06-27 | NQ | Futures | 13859.38 | 14001.54 | 13695.81 | 13748.62 | 565803.0 |
| 2022-06-27 | YM | Futures | 34403.8 | 34654.2 | 34256.2 | 34354.6 | 125464.0 |
| 2022-06-27 | CL | Futures | 88.87 | 91.62 | 87.52 | 90.81 | 282914.0 |
| 2022-06-27 | GC | Futures | 2125.8 | 2129.5 | 2105.2 | 2108.7 | 143820.0 |
| 2022-06-27 | ZN | Futures | 120.575351 | 120.719945 | 119.868446 | 120.109436 | 1191859.0 |
| 2022-06-27 | A6 | Futures | 0.71172 | 0.71331 | 0.70798 | 0.70967 | 80682.0 |
| 2022-06-27 | AD | Futures | 0.78684 | 0.78851 | 0.78531 | 0.78775 | 69286.0 |
| 2022-06-27 | ALI | Futures | 2759.57 | 2818.41 | 2759.57 | 2814.73 | 789.0 |
| 2022-06-27 | B | Futures | 87.67 | 89.99 | 86.18 | 89.26 | 239015.0 |
| 2022-06-27 | B6 | Futures | 1.2471 | 1.2534 | 1.2436 | 1.2476 | 72921.0 |
| 2022-06-27 | BR | Futures | 0.16322 | 0.16383 | 0.16309 | 0.1633 | 93.0 |
| 2022-06-27 | BTC | Futures | 29773.3 | 30010.3 | 28463.1 | 28992.8 | 5894.0 |
| 2022-06-27 | BZ | Futures | 85.73 | 87.87 | 84.14 | 87.16 | 18341.0 |
| 2022-06-27 | C | Futures | 1324.0 | 1337.0 | 1303.0 | 1308.0 | 2308.0 |
| 2022-06-27 | CB | Futures | 227.978 | 228.522 | 227.837 | 228.421 | 26.0 |
| 2022-06-27 | CC | Futures | 1464.0 | 1470.0 | 1432.0 | 1441.0 | 18031.0 |
| 2022-06-27 | CNH | Futures | 6.3095 | 6.3215 | 6.3095 | 6.3188 | 359.0 |
| 2022-06-27 | CSC | Futures | 3.162 | 3.182 | 3.148 | 3.155 | 100.0 |
| 2022-06-27 | CT | Futures | 134.28 | 134.6 | 130.77 | 130.77 | 83.0 |
| 2022-06-27 | DC | Futures | 30.15 | 30.28 | 30.06 | 30.17 | 108.0 |
| 2022-06-27 | DX | Futures | 100.194 | 100.32 | 99.765 | 100.014 | 21545.0 |
| 2022-06-27 | E1 | Futures | 1.15986 | 1.16534 | 1.15599 | 1.16285 | 19775.0 |
| 2022-06-27 | E6 | Futures | 1.11648 | 1.12321 | 1.11632 | 1.11984 | 138963.0 |
| 2022-06-27 | E7 | Futures | 1.1103 | 1.1164 | 1.1096 | 1.1132 | 4682.0 |
| 2022-06-27 | EBM | Futures | 500.21 | 505.12 | 489.69 | 490.75 | 18546.0 |
| 2022-06-27 | ED | Futures | 95.0791 | 95.0987 | 95.0299 | 95.0643 | 97454.0 |
| 2022-06-27 | ER | Futures | 98.371 | 98.376 | 98.327 | 98.356 | 102634.0 |
| 2022-06-27 | ESG | Futures | 381.15 | 381.15 | 377.46 | 378.41 | 274.0 |
| 2022-06-27 | EW | Futures | 2542.3 | 2566.7 | 2526.4 | 2549.4 | 13162.0 |
| 2022-06-27 | FBTP | Futures | 112.85 | 113.07 | 111.8 | 112.34 | 83547.0 |
| 2022-06-27 | FCE | Futures | 6642.8 | 6687.9 | 6536.7 | 6567.2 | 53687.0 |
| 2022-06-27 | FDAX | Futures | 14152.4 | 14382.7 | 14098.6 | 14199.7 | 57616.0 |
| 2022-06-27 | FESX | Futures | 3500.2 | 3555.7 | 3480.3 | 3507.1 | 856446.0 |
| 2022-06-27 | FGBL | Futures | 145.83 | 145.88 | 144.12 | 144.57 | 603121.0 |
| 2022-06-27 | FGBM | Futures | 125.23 | 125.27 | 124.38 | 124.54 | 494354.0 |
| 2022-06-27 | FGBS | Futures | 110.648 | 110.653 | 110.389 | 110.465 | 439132.0 |
| 2022-06-27 | FOAT | Futures | 134.48 | 134.64 | 132.97 | 133.39 | 163128.0 |
| 2022-06-27 | FTI | Futures | 659.56 | 672.85 | 658.76 | 667.41 | 22588.0 |
| 2022-06-27 | FTUK | Futures | 7264.8 | 7332.7 | 7254.1 | 7319.5 | 88096.0 |
| 2022-06-27 | G | Futures | 109.38 | 109.68 | 108.59 | 108.96 | 160539.0 |
| 2022-06-27 | GF | Futures | 225.131 | 227.559 | 223.577 | 225.455 | 6754.0 |
| 2022-06-27 | GSCI | Futures | 731.55 | 738.98 | 731.35 | 738.98 | 8.0 |
| 2022-06-27 | HE | Futures | 88.169 | 88.485 | 87.003 | 87.063 | 5851.0 |
| 2022-06-27 | HG | Futures | 4.1273 | 4.2054 | 4.1201 | 4.1476 | 47104.0 |
| 2022-06-27 | HH | Futures | 17.172 | 18.401 | 17.043 | 18.295 | 5285.0 |
| 2022-06-27 | HO | Futures | 2.6736 | 2.6869 | 2.6023 | 2.6077 | 22739.0 |
| 2022-06-27 | HRC | Futures | 1540.1 | 1548.4 | 1531.9 | 1548.4 | 69.0 |
| 2022-06-27 | J1 | Futures | 0.0084946 | 0.0085357 | 0.0084712 | 0.0084792 | 107110.0 |
| 2022-06-27 | J7 | Futures | 0.008502 | 0.008538 | 0.008477 | 0.008483 | 344.0 |
> showing 50 of 114 rows — these rows as CSV