PREVIEW / futures_daily / 2021-06-28
file: by_date/futures_daily/2021/2021-06-28.parquet size: 10 KB rows: 124
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 |
|---|---|---|---|---|---|---|---|
| 2021-06-28 | ES | Futures | 4805.42 | 4813.28 | 4793.33 | 4811.6 | 823723.0 |
| 2021-06-28 | NQ | Futures | 16555.41 | 16751.25 | 16536.08 | 16742.88 | 376860.0 |
| 2021-06-28 | YM | Futures | 37298.4 | 37312.5 | 36939.5 | 37044.7 | 120048.0 |
| 2021-06-28 | CL | Futures | 53.08 | 53.41 | 52.09 | 52.3 | 354701.0 |
| 2021-06-28 | GC | Futures | 2084.3 | 2089.1 | 2070.7 | 2082.8 | 160788.0 |
| 2021-06-28 | ZN | Futures | 133.519588 | 133.930758 | 133.487959 | 133.867501 | 966673.0 |
| 2021-06-28 | A6 | Futures | 0.77833 | 0.77982 | 0.775 | 0.77613 | 56540.0 |
| 2021-06-28 | AD | Futures | 0.82467 | 0.82513 | 0.82108 | 0.82143 | 54809.0 |
| 2021-06-28 | ALI | Futures | 2873.75 | 2905.6 | 2868.3 | 2886.95 | 91.0 |
| 2021-06-28 | B | Futures | 49.79 | 50.03 | 48.81 | 48.95 | 343278.0 |
| 2021-06-28 | B6 | Futures | 1.4103 | 1.4157 | 1.4085 | 1.4094 | 74197.0 |
| 2021-06-28 | BFX | Futures | 4251.1 | 4254.1 | 4243.9 | 4243.9 | 3.0 |
| 2021-06-28 | BR | Futures | 0.16011 | 0.16135 | 0.16011 | 0.16123 | 356.0 |
| 2021-06-28 | BTC | Futures | 46691.6 | 50324.4 | 46656.0 | 49184.7 | 5519.0 |
| 2021-06-28 | BZ | Futures | 48.63 | 48.9 | 47.72 | 47.85 | 28541.0 |
| 2021-06-28 | C | Futures | 1443.0 | 1446.0 | 1433.0 | 1441.0 | 1480.0 |
| 2021-06-28 | CB | Futures | 142.009 | 142.992 | 141.608 | 142.992 | 14.0 |
| 2021-06-28 | CC | Futures | 1560.0 | 1567.0 | 1542.0 | 1561.0 | 14134.0 |
| 2021-06-28 | CNH | Futures | 6.2647 | 6.2693 | 6.2602 | 6.2651 | 283.0 |
| 2021-06-28 | CSC | Futures | 2.492 | 2.5 | 2.482 | 2.485 | 45.0 |
| 2021-06-28 | CT | Futures | 81.63 | 82.03 | 81.49 | 81.63 | 11.0 |
| 2021-06-28 | DC | Futures | 22.56 | 22.73 | 22.37 | 22.56 | 341.0 |
| 2021-06-28 | DX | Futures | 88.752 | 88.936 | 88.621 | 88.806 | 14035.0 |
| 2021-06-28 | E1 | Futures | 1.22729 | 1.22751 | 1.22123 | 1.22347 | 19599.0 |
| 2021-06-28 | E6 | Futures | 1.27174 | 1.27254 | 1.26802 | 1.27025 | 144136.0 |
| 2021-06-28 | E7 | Futures | 1.2654 | 1.2661 | 1.2618 | 1.2639 | 4116.0 |
| 2021-06-28 | EBM | Futures | 297.53 | 300.47 | 297.16 | 298.63 | 13758.0 |
| 2021-06-28 | ED | Futures | 96.5248 | 96.5297 | 96.52 | 96.5248 | 98859.0 |
| 2021-06-28 | ER | Futures | 98.46 | 98.46 | 98.455 | 98.46 | 39710.0 |
| 2021-06-28 | ESG | Futures | 396.45 | 396.95 | 395.65 | 396.89 | 171.0 |
| 2021-06-28 | EW | Futures | 2932.2 | 2932.7 | 2877.8 | 2892.4 | 11428.0 |
| 2021-06-28 | FBON | Futures | 147.13 | 147.77 | 147.13 | 147.62 | 168.0 |
| 2021-06-28 | FBTP | Futures | 137.12 | 137.81 | 137.12 | 137.73 | 85336.0 |
| 2021-06-28 | FBTS | Futures | 109.971 | 110.107 | 109.971 | 110.107 | 51895.0 |
| 2021-06-28 | FCE | Futures | 6600.7 | 6605.6 | 6522.5 | 6529.9 | 51010.0 |
| 2021-06-28 | FDAX | Futures | 16710.2 | 16767.0 | 16627.7 | 16639.5 | 52061.0 |
| 2021-06-28 | FDIV | Futures | 187.55 | 187.7 | 187.55 | 187.7 | 10.0 |
| 2021-06-28 | FDXM | Futures | 16632.6 | 16683.8 | 16545.2 | 16556.9 | 32427.0 |
| 2021-06-28 | FDXS | Futures | 16515.3 | 16578.8 | 16440.1 | 16451.8 | 4153.0 |
| 2021-06-28 | FESX | Futures | 3897.7 | 3899.6 | 3861.7 | 3864.1 | 516701.0 |
| 2021-06-28 | FGBL | Futures | 166.41 | 166.94 | 166.33 | 166.87 | 496909.0 |
| 2021-06-28 | FGBM | Futures | 134.37 | 134.53 | 134.36 | 134.51 | 217568.0 |
| 2021-06-28 | FGBS | Futures | 112.539 | 112.554 | 112.534 | 112.554 | 134792.0 |
| 2021-06-28 | FGBX | Futures | 214.9 | 216.38 | 214.75 | 216.08 | 57288.0 |
| 2021-06-28 | FMWO | Futures | 10668.2 | 10674.1 | 10631.8 | 10638.8 | 5554.0 |
| 2021-06-28 | FOAT | Futures | 154.19 | 154.73 | 154.12 | 154.68 | 160943.0 |
| 2021-06-28 | FTDX | Futures | 3641.4 | 3677.3 | 3641.4 | 3660.4 | 35.0 |
| 2021-06-28 | FTI | Futures | 697.76 | 699.33 | 693.76 | 695.63 | 15934.0 |
| 2021-06-28 | FTUK | Futures | 6975.9 | 6978.9 | 6892.2 | 6896.2 | 71208.0 |
| 2021-06-28 | FVSA | Futures | 81.83 | 82.98 | 79.54 | 81.83 | 18901.0 |
> showing 50 of 124 rows — these rows as CSV