PREVIEW / futures_daily / 2021-08-18
file: by_date/futures_daily/2021/2021-08-18.parquet size: 10 KB rows: 125
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-08-18 | ES | Futures | 4987.23 | 5001.85 | 4925.13 | 4939.74 | 1546011.0 |
| 2021-08-18 | NQ | Futures | 17270.98 | 17348.28 | 17082.07 | 17131.39 | 568846.0 |
| 2021-08-18 | YM | Futures | 38181.1 | 38261.3 | 37723.5 | 37828.7 | 166031.0 |
| 2021-08-18 | CL | Futures | 48.59 | 49.24 | 47.0 | 47.76 | 386357.0 |
| 2021-08-18 | GC | Futures | 2085.7 | 2095.0 | 2075.2 | 2081.8 | 132725.0 |
| 2021-08-18 | ZN | Futures | 135.84428 | 135.939166 | 135.527995 | 135.765209 | 1371502.0 |
| 2021-08-18 | A6 | Futures | 0.74423 | 0.74557 | 0.74147 | 0.743 | 90376.0 |
| 2021-08-18 | AD | Futures | 0.80293 | 0.8047 | 0.80049 | 0.80257 | 67743.0 |
| 2021-08-18 | ALI | Futures | 2982.74 | 2994.43 | 2932.29 | 2940.27 | 993.0 |
| 2021-08-18 | B | Futures | 45.93 | 46.65 | 44.77 | 45.44 | 316976.0 |
| 2021-08-18 | B6 | Futures | 1.3956 | 1.3999 | 1.3943 | 1.3974 | 78942.0 |
| 2021-08-18 | BFX | Futures | 4414.7 | 4431.7 | 4414.7 | 4431.7 | 23.0 |
| 2021-08-18 | BR | Futures | 0.1511 | 0.15178 | 0.14798 | 0.14914 | 11469.0 |
| 2021-08-18 | BTC | Futures | 60064.9 | 61821.4 | 59206.7 | 60145.3 | 5149.0 |
| 2021-08-18 | BZ | Futures | 44.86 | 45.53 | 43.7 | 44.35 | 34264.0 |
| 2021-08-18 | C | Futures | 1526.0 | 1534.0 | 1521.0 | 1522.0 | 2959.0 |
| 2021-08-18 | CB | Futures | 138.82 | 138.82 | 136.393 | 136.995 | 57.0 |
| 2021-08-18 | CC | Futures | 1705.0 | 1722.0 | 1702.0 | 1716.0 | 25013.0 |
| 2021-08-18 | CNH | Futures | 6.2748 | 6.2748 | 6.2637 | 6.2643 | 469.0 |
| 2021-08-18 | CSC | Futures | 2.48 | 2.492 | 2.463 | 2.479 | 133.0 |
| 2021-08-18 | CT | Futures | 88.27 | 89.08 | 87.29 | 88.34 | 41.0 |
| 2021-08-18 | DC | Futures | 22.39 | 22.54 | 22.21 | 22.34 | 413.0 |
| 2021-08-18 | DX | Futures | 90.042 | 90.158 | 89.839 | 90.032 | 21782.0 |
| 2021-08-18 | E1 | Futures | 1.22875 | 1.23122 | 1.2219 | 1.22594 | 25093.0 |
| 2021-08-18 | E6 | Futures | 1.24637 | 1.24972 | 1.2444 | 1.24642 | 135019.0 |
| 2021-08-18 | E7 | Futures | 1.24 | 1.2434 | 1.2383 | 1.2402 | 3452.0 |
| 2021-08-18 | EBM | Futures | 359.68 | 378.07 | 356.37 | 374.03 | 7619.0 |
| 2021-08-18 | ED | Futures | 96.5418 | 96.5418 | 96.5369 | 96.5418 | 91699.0 |
| 2021-08-18 | ER | Futures | 98.465 | 98.47 | 98.465 | 98.47 | 10550.0 |
| 2021-08-18 | ESG | Futures | 412.66 | 413.47 | 408.12 | 408.29 | 310.0 |
| 2021-08-18 | EW | Futures | 2883.5 | 2900.6 | 2849.7 | 2860.5 | 9005.0 |
| 2021-08-18 | FBON | Futures | 151.6 | 151.78 | 151.6 | 151.7 | 146.0 |
| 2021-08-18 | FBTP | Futures | 141.62 | 141.94 | 141.57 | 141.86 | 86370.0 |
| 2021-08-18 | FBTS | Futures | 110.487 | 110.516 | 110.477 | 110.507 | 19202.0 |
| 2021-08-18 | FCE | Futures | 6824.0 | 6832.5 | 6724.1 | 6757.1 | 60534.0 |
| 2021-08-18 | FDAX | Futures | 17012.3 | 17107.6 | 16993.0 | 17092.6 | 55505.0 |
| 2021-08-18 | FDIV | Futures | 189.76 | 189.85 | 189.76 | 189.85 | 15.0 |
| 2021-08-18 | FDXM | Futures | 16927.9 | 17028.1 | 16908.7 | 17007.8 | 36180.0 |
| 2021-08-18 | FDXS | Futures | 16824.6 | 16914.6 | 16801.3 | 16899.8 | 7565.0 |
| 2021-08-18 | FESX | Futures | 3967.4 | 3986.8 | 3948.9 | 3968.3 | 492872.0 |
| 2021-08-18 | FGBL | Futures | 171.27 | 171.54 | 171.18 | 171.38 | 430263.0 |
| 2021-08-18 | FGBM | Futures | 135.78 | 135.84 | 135.74 | 135.8 | 230395.0 |
| 2021-08-18 | FGBS | Futures | 112.739 | 112.759 | 112.734 | 112.754 | 215487.0 |
| 2021-08-18 | FGBX | Futures | 232.13 | 233.0 | 231.76 | 232.47 | 78512.0 |
| 2021-08-18 | FMWO | Futures | 10961.9 | 10961.9 | 10857.3 | 10937.2 | 2689.0 |
| 2021-08-18 | FOAT | Futures | 158.27 | 158.53 | 158.2 | 158.39 | 112427.0 |
| 2021-08-18 | FTDX | Futures | 3966.2 | 3982.1 | 3964.2 | 3980.1 | 91.0 |
| 2021-08-18 | FTI | Futures | 736.32 | 738.28 | 732.64 | 736.87 | 19659.0 |
| 2021-08-18 | FTUK | Futures | 7024.2 | 7061.6 | 6981.4 | 7019.3 | 67096.0 |
| 2021-08-18 | FVSA | Futures | 77.89 | 81.58 | 76.92 | 77.7 | 18006.0 |
> showing 50 of 125 rows — these rows as CSV