PREVIEW / futures_daily / 2021-09-03
file: by_date/futures_daily/2021/2021-09-03.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-09-03 | ES | Futures | 5099.64 | 5113.97 | 5079.97 | 5097.11 | 1156146.0 |
| 2021-09-03 | NQ | Futures | 17998.67 | 18086.93 | 17942.43 | 18056.93 | 462870.0 |
| 2021-09-03 | YM | Futures | 38412.0 | 38497.7 | 38220.1 | 38333.9 | 144762.0 |
| 2021-09-03 | CL | Futures | 51.1 | 51.66 | 50.58 | 50.75 | 313086.0 |
| 2021-09-03 | GC | Futures | 2113.4 | 2143.0 | 2112.7 | 2139.3 | 184984.0 |
| 2021-09-03 | ZN | Futures | 135.812652 | 136.113122 | 135.496367 | 135.622881 | 26714.0 |
| 2021-09-03 | A6 | Futures | 0.759 | 0.76695 | 0.75849 | 0.76495 | 101101.0 |
| 2021-09-03 | AD | Futures | 0.80759 | 0.81144 | 0.80724 | 0.81018 | 78586.0 |
| 2021-09-03 | ALI | Futures | 3109.87 | 3139.52 | 3083.36 | 3137.52 | 1194.0 |
| 2021-09-03 | B | Futures | 49.06 | 49.61 | 48.75 | 48.89 | 211423.0 |
| 2021-09-03 | B6 | Futures | 1.4049 | 1.4106 | 1.403 | 1.4093 | 75059.0 |
| 2021-09-03 | BFX | Futures | 4398.0 | 4398.0 | 4394.9 | 4394.9 | 2.0 |
| 2021-09-03 | BR | Futures | 0.15559 | 0.15563 | 0.15446 | 0.15458 | 2283.0 |
| 2021-09-03 | BTC | Futures | 66444.9 | 68255.8 | 64507.5 | 67523.5 | 5123.0 |
| 2021-09-03 | BZ | Futures | 47.77 | 48.35 | 47.5 | 47.63 | 27095.0 |
| 2021-09-03 | C | Futures | 1573.0 | 1582.0 | 1554.0 | 1555.0 | 1084.0 |
| 2021-09-03 | CB | Futures | 141.051 | 141.445 | 141.051 | 141.051 | 47.0 |
| 2021-09-03 | CC | Futures | 1683.0 | 1712.0 | 1682.0 | 1704.0 | 23777.0 |
| 2021-09-03 | CNH | Futures | 6.2226 | 6.2297 | 6.2017 | 6.2122 | 295.0 |
| 2021-09-03 | CSC | Futures | 2.473 | 2.477 | 2.473 | 2.477 | 38.0 |
| 2021-09-03 | CT | Futures | 88.32 | 88.43 | 88.21 | 88.43 | 7.0 |
| 2021-09-03 | DC | Futures | 22.5 | 22.5 | 22.4 | 22.46 | 38.0 |
| 2021-09-03 | DX | Futures | 89.158 | 89.182 | 88.733 | 88.958 | 32687.0 |
| 2021-09-03 | E1 | Futures | 1.22841 | 1.23212 | 1.22628 | 1.22976 | 25021.0 |
| 2021-09-03 | E6 | Futures | 1.26323 | 1.26701 | 1.26238 | 1.26499 | 178516.0 |
| 2021-09-03 | E7 | Futures | 1.257 | 1.2606 | 1.2561 | 1.2587 | 3891.0 |
| 2021-09-03 | EBM | Futures | 366.3 | 366.3 | 358.21 | 358.58 | 1625.0 |
| 2021-09-03 | ED | Futures | 96.549 | 96.5514 | 96.5466 | 96.5514 | 90400.0 |
| 2021-09-03 | ER | Futures | 98.47 | 98.475 | 98.47 | 98.475 | 21025.0 |
| 2021-09-03 | ESG | Futures | 420.53 | 421.5 | 420.53 | 421.37 | 522.0 |
| 2021-09-03 | EW | Futures | 2978.5 | 2988.3 | 2955.8 | 2962.7 | 8086.0 |
| 2021-09-03 | FBON | Futures | 150.53 | 150.59 | 150.06 | 150.31 | 1552.0 |
| 2021-09-03 | FBTP | Futures | 140.58 | 140.58 | 139.98 | 140.26 | 230729.0 |
| 2021-09-03 | FBTS | Futures | 110.536 | 110.545 | 110.477 | 110.497 | 125222.0 |
| 2021-09-03 | FCE | Futures | 6755.1 | 6758.1 | 6653.7 | 6677.7 | 53273.0 |
| 2021-09-03 | FDAX | Futures | 16945.8 | 16998.3 | 16799.1 | 16901.9 | 72117.0 |
| 2021-09-03 | FDIV | Futures | 186.18 | 186.18 | 185.29 | 185.29 | 61.0 |
| 2021-09-03 | FDXM | Futures | 16865.0 | 16912.9 | 16716.8 | 16818.1 | 49556.0 |
| 2021-09-03 | FDXS | Futures | 16745.1 | 16805.5 | 16611.7 | 16711.2 | 8477.0 |
| 2021-09-03 | FESX | Futures | 4006.7 | 4016.2 | 3962.7 | 3980.7 | 652716.0 |
| 2021-09-03 | FEU3 | Futures | 99.223 | 99.223 | 99.218 | 99.218 | 297.0 |
| 2021-09-03 | FGBL | Futures | 169.93 | 170.14 | 169.42 | 169.69 | 1168791.0 |
| 2021-09-03 | FGBM | Futures | 135.51 | 135.57 | 135.35 | 135.4 | 784591.0 |
| 2021-09-03 | FGBS | Futures | 112.709 | 112.714 | 112.674 | 112.689 | 433031.0 |
| 2021-09-03 | FGBX | Futures | 225.99 | 226.66 | 224.28 | 225.27 | 188529.0 |
| 2021-09-03 | FMWO | Futures | 11195.7 | 11208.6 | 11152.2 | 11184.0 | 1829.0 |
| 2021-09-03 | FOAT | Futures | 157.38 | 157.52 | 156.98 | 157.21 | 409385.0 |
| 2021-09-03 | FTDX | Futures | 4056.5 | 4056.5 | 3998.6 | 4036.5 | 142.0 |
| 2021-09-03 | FTI | Futures | 758.55 | 758.93 | 749.85 | 754.56 | 17664.0 |
| 2021-09-03 | FTUK | Futures | 7037.0 | 7070.0 | 7010.4 | 7029.1 | 74467.0 |
> showing 50 of 124 rows — these rows as CSV