PREVIEW / futures_daily / 2021-02-05
file: by_date/futures_daily/2021/2021-02-05.parquet size: 10 KB rows: 121
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-02-05 | ES | Futures | 4331.06 | 4357.96 | 4326.3 | 4348.99 | 1138874.0 |
| 2021-02-05 | NQ | Futures | 15640.36 | 15730.91 | 15593.65 | 15684.19 | 431935.0 |
| 2021-02-05 | YM | Futures | 33443.0 | 33638.4 | 33395.4 | 33522.9 | 120889.0 |
| 2021-02-05 | CL | Futures | 39.87 | 40.46 | 39.85 | 40.15 | 400833.0 |
| 2021-02-05 | GC | Futures | 2106.5 | 2131.9 | 2104.0 | 2128.4 | 205758.0 |
| 2021-02-05 | ZN | Futures | 136.030362 | 136.185772 | 135.766165 | 135.952657 | 2306009.0 |
| 2021-02-05 | A6 | Futures | 0.77982 | 0.78802 | 0.77797 | 0.78674 | 91773.0 |
| 2021-02-05 | AD | Futures | 0.78998 | 0.79399 | 0.78928 | 0.79333 | 73629.0 |
| 2021-02-05 | ALI | Futures | 2359.88 | 2372.41 | 2359.88 | 2369.49 | 90.0 |
| 2021-02-05 | B | Futures | 37.57 | 37.97 | 37.52 | 37.68 | 229424.0 |
| 2021-02-05 | B6 | Futures | 1.3882 | 1.3956 | 1.388 | 1.3943 | 81209.0 |
| 2021-02-05 | BFX | Futures | 3866.3 | 3878.4 | 3856.2 | 3862.3 | 15.0 |
| 2021-02-05 | BR | Futures | 0.14337 | 0.14591 | 0.1429 | 0.14513 | 5807.0 |
| 2021-02-05 | BTC | Futures | 50566.0 | 51981.1 | 49486.3 | 50988.5 | 4767.0 |
| 2021-02-05 | BZ | Futures | 36.78 | 37.21 | 36.77 | 36.93 | 23510.0 |
| 2021-02-05 | C | Futures | 1478.0 | 1490.0 | 1467.0 | 1486.0 | 4975.0 |
| 2021-02-05 | CB | Futures | 138.772 | 138.818 | 138.472 | 138.818 | 11.0 |
| 2021-02-05 | CC | Futures | 1652.0 | 1679.0 | 1643.0 | 1666.0 | 30956.0 |
| 2021-02-05 | CNH | Futures | 6.3308 | 6.3468 | 6.3187 | 6.3187 | 446.0 |
| 2021-02-05 | CSC | Futures | 2.88 | 2.958 | 2.88 | 2.923 | 150.0 |
| 2021-02-05 | CT | Futures | 81.4 | 82.02 | 79.8 | 79.94 | 33611.0 |
| 2021-02-05 | DC | Futures | 24.56 | 25.44 | 24.52 | 25.34 | 488.0 |
| 2021-02-05 | DX | Futures | 88.466 | 88.568 | 87.944 | 88.014 | 26219.0 |
| 2021-02-05 | E1 | Futures | 1.24904 | 1.25683 | 1.24859 | 1.25558 | 22917.0 |
| 2021-02-05 | E6 | Futures | 1.27837 | 1.28766 | 1.27703 | 1.28686 | 192834.0 |
| 2021-02-05 | E7 | Futures | 1.2719 | 1.2813 | 1.2708 | 1.2805 | 8440.0 |
| 2021-02-05 | EBM | Futures | 277.33 | 279.49 | 275.48 | 276.71 | 16300.0 |
| 2021-02-05 | ED | Futures | 96.5325 | 96.5373 | 96.5276 | 96.5373 | 210074.0 |
| 2021-02-05 | ER | Futures | 98.465 | 98.47 | 98.455 | 98.46 | 63303.0 |
| 2021-02-05 | ESG | Futures | 358.87 | 361.85 | 358.59 | 359.46 | 131.0 |
| 2021-02-05 | EW | Futures | 2621.8 | 2651.5 | 2617.4 | 2647.5 | 10203.0 |
| 2021-02-05 | FBON | Futures | 149.89 | 149.93 | 149.35 | 149.74 | 656.0 |
| 2021-02-05 | FBTP | Futures | 139.4 | 139.81 | 139.15 | 139.49 | 170240.0 |
| 2021-02-05 | FBTS | Futures | 110.049 | 110.078 | 109.99 | 110.049 | 104201.0 |
| 2021-02-05 | FCE | Futures | 5463.7 | 5505.4 | 5457.9 | 5490.9 | 44148.0 |
| 2021-02-05 | FDAX | Futures | 14977.0 | 15036.7 | 14925.8 | 14968.5 | 44409.0 |
| 2021-02-05 | FDIV | Futures | 170.22 | 170.41 | 170.22 | 170.41 | 100.0 |
| 2021-02-05 | FDXM | Futures | 14937.1 | 14994.5 | 14883.9 | 14926.5 | 43569.0 |
| 2021-02-05 | FESX | Futures | 3381.6 | 3405.7 | 3379.7 | 3390.9 | 730129.0 |
| 2021-02-05 | FGBL | Futures | 168.89 | 169.08 | 168.27 | 168.79 | 981783.0 |
| 2021-02-05 | FGBM | Futures | 134.93 | 134.99 | 134.77 | 134.92 | 495961.0 |
| 2021-02-05 | FGBS | Futures | 112.679 | 112.694 | 112.659 | 112.674 | 376495.0 |
| 2021-02-05 | FGBX | Futures | 227.86 | 228.66 | 225.56 | 227.36 | 134278.0 |
| 2021-02-05 | FMWO | Futures | 9731.3 | 9801.2 | 9731.3 | 9785.8 | 1840.0 |
| 2021-02-05 | FOAT | Futures | 157.57 | 157.7 | 156.97 | 157.41 | 232688.0 |
| 2021-02-05 | FTDX | Futures | 3618.6 | 3630.4 | 3608.8 | 3610.3 | 63.0 |
| 2021-02-05 | FTI | Futures | 616.5 | 617.34 | 610.78 | 611.75 | 14647.0 |
| 2021-02-05 | FTUK | Futures | 6207.7 | 6229.3 | 6169.6 | 6204.8 | 95759.0 |
| 2021-02-05 | FVSA | Futures | 157.01 | 158.43 | 153.11 | 153.82 | 21143.0 |
| 2021-02-05 | FXXP | Futures | 381.9 | 382.0 | 379.0 | 380.1 | 50455.0 |
> showing 50 of 121 rows — these rows as CSV