PREVIEW / futures_daily / 2021-06-17
file: by_date/futures_daily/2021/2021-06-17.parquet size: 10 KB rows: 122
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-17 | ES | Futures | 4725.89 | 4746.68 | 4702.0 | 4734.88 | 1746318.0 |
| 2021-06-17 | NQ | Futures | 16083.55 | 16381.2 | 15969.05 | 16331.88 | 657540.0 |
| 2021-06-17 | YM | Futures | 36687.9 | 36834.3 | 36322.5 | 36534.0 | 202098.0 |
| 2021-06-17 | CL | Futures | 51.28 | 51.72 | 49.88 | 50.77 | 343666.0 |
| 2021-06-17 | GC | Futures | 2119.7 | 2136.2 | 2067.8 | 2075.9 | 385888.0 |
| 2021-06-17 | ZN | Futures | 133.219117 | 133.756801 | 133.029346 | 133.614473 | 2649597.0 |
| 2021-06-17 | A6 | Futures | 0.78054 | 0.7851 | 0.77346 | 0.77474 | 129392.0 |
| 2021-06-17 | AD | Futures | 0.82589 | 0.82675 | 0.81905 | 0.82077 | 95611.0 |
| 2021-06-17 | ALI | Futures | 2845.63 | 2845.63 | 2753.81 | 2781.93 | 487.0 |
| 2021-06-17 | B | Futures | 48.25 | 48.71 | 47.08 | 47.78 | 336640.0 |
| 2021-06-17 | B6 | Futures | 1.4201 | 1.4227 | 1.4111 | 1.4139 | 145428.0 |
| 2021-06-17 | BFX | Futures | 4291.4 | 4294.5 | 4291.4 | 4294.5 | 24.0 |
| 2021-06-17 | BR | Futures | 0.15691 | 0.15827 | 0.15691 | 0.15787 | 198.0 |
| 2021-06-17 | BTC | Futures | 55853.5 | 57280.6 | 54064.2 | 54571.3 | 5646.0 |
| 2021-06-17 | BZ | Futures | 47.23 | 47.55 | 45.96 | 46.65 | 42085.0 |
| 2021-06-17 | C | Futures | 1445.0 | 1463.0 | 1445.0 | 1454.0 | 2079.0 |
| 2021-06-17 | CB | Futures | 149.23 | 149.23 | 148.428 | 148.428 | 33.0 |
| 2021-06-17 | CC | Futures | 1581.0 | 1582.0 | 1554.0 | 1561.0 | 21549.0 |
| 2021-06-17 | CNH | Futures | 6.2482 | 6.2722 | 6.2295 | 6.2629 | 533.0 |
| 2021-06-17 | CSC | Futures | 2.587 | 2.589 | 2.573 | 2.573 | 44.0 |
| 2021-06-17 | CT | Futures | 79.4 | 79.7 | 78.0 | 78.48 | 6063.0 |
| 2021-06-17 | DC | Futures | 23.8 | 23.8 | 23.48 | 23.59 | 109.0 |
| 2021-06-17 | DX | Futures | 88.322 | 88.921 | 88.235 | 88.803 | 48176.0 |
| 2021-06-17 | E1 | Futures | 1.23886 | 1.24009 | 1.22493 | 1.22684 | 40128.0 |
| 2021-06-17 | E6 | Futures | 1.27796 | 1.27924 | 1.26701 | 1.26908 | 306550.0 |
| 2021-06-17 | E7 | Futures | 1.2717 | 1.2728 | 1.2607 | 1.2627 | 10186.0 |
| 2021-06-17 | EBM | Futures | 302.31 | 303.05 | 300.47 | 300.84 | 18963.0 |
| 2021-06-17 | ED | Futures | 96.5297 | 96.5393 | 96.5248 | 96.5345 | 195826.0 |
| 2021-06-17 | ER | Futures | 98.465 | 98.465 | 98.455 | 98.46 | 67986.0 |
| 2021-06-17 | ESG | Futures | 389.02 | 391.52 | 388.35 | 390.81 | 1286.0 |
| 2021-06-17 | EW | Futures | 2893.7 | 2901.3 | 2829.8 | 2853.4 | 13540.0 |
| 2021-06-17 | FBON | Futures | 147.66 | 148.19 | 147.58 | 147.96 | 456.0 |
| 2021-06-17 | FBTP | Futures | 138.22 | 138.65 | 137.96 | 138.38 | 153685.0 |
| 2021-06-17 | FBTS | Futures | 110.205 | 110.253 | 110.185 | 110.214 | 84784.0 |
| 2021-06-17 | FCE | Futures | 6597.2 | 6645.5 | 6580.7 | 6628.1 | 48532.0 |
| 2021-06-17 | FDAX | Futures | 16754.1 | 16860.2 | 16705.9 | 16821.6 | 40246.0 |
| 2021-06-17 | FDXM | Futures | 16677.4 | 16776.5 | 16623.0 | 16738.1 | 6412.0 |
| 2021-06-17 | FDXS | Futures | 16596.9 | 16675.2 | 16536.5 | 16631.8 | 435.0 |
| 2021-06-17 | FESX | Futures | 3903.9 | 3937.1 | 3891.6 | 3925.7 | 747531.0 |
| 2021-06-17 | FGBL | Futures | 166.59 | 167.29 | 166.42 | 167.04 | 802655.0 |
| 2021-06-17 | FGBM | Futures | 134.55 | 134.72 | 134.52 | 134.67 | 553665.0 |
| 2021-06-17 | FGBS | Futures | 112.579 | 112.599 | 112.574 | 112.589 | 320555.0 |
| 2021-06-17 | FGBX | Futures | 215.59 | 218.51 | 214.71 | 217.0 | 103605.0 |
| 2021-06-17 | FMWO | Futures | 10519.0 | 10576.5 | 10501.4 | 10558.9 | 6547.0 |
| 2021-06-17 | FOAT | Futures | 154.4 | 154.88 | 154.16 | 154.7 | 221299.0 |
| 2021-06-17 | FTDX | Futures | 3574.7 | 3589.6 | 3556.7 | 3589.6 | 794.0 |
| 2021-06-17 | FTI | Futures | 696.52 | 700.9 | 694.38 | 699.39 | 10763.0 |
| 2021-06-17 | FTUK | Futures | 6969.5 | 6988.2 | 6944.4 | 6968.1 | 92439.0 |
| 2021-06-17 | FVSA | Futures | 88.71 | 90.31 | 83.21 | 84.58 | 17790.0 |
| 2021-06-17 | FXXP | Futures | 435.7 | 436.7 | 433.4 | 435.1 | 70864.0 |
> showing 50 of 122 rows — these rows as CSV