PREVIEW / futures_daily / 2020-08-03
file: by_date/futures_daily/2020/2020-08-03.parquet size: 10 KB rows: 120
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 |
|---|---|---|---|---|---|---|---|
| 2020-08-03 | ES | Futures | 3682.92 | 3709.37 | 3663.5 | 3701.49 | 1250449.0 |
| 2020-08-03 | NQ | Futures | 12689.56 | 12851.76 | 12623.41 | 12818.39 | 389622.0 |
| 2020-08-03 | YM | Futures | 28292.7 | 28510.2 | 28075.1 | 28462.0 | 140685.0 |
| 2020-08-03 | CL | Futures | 29.47 | 30.09 | 28.88 | 29.92 | 338326.0 |
| 2020-08-03 | GC | Futures | 2359.0 | 2373.2 | 2332.7 | 2345.8 | 178754.0 |
| 2020-08-03 | ZN | Futures | 138.899343 | 138.914828 | 138.620615 | 138.682554 | 843977.0 |
| 2020-08-03 | A6 | Futures | 0.73407 | 0.73571 | 0.728 | 0.73242 | 66998.0 |
| 2020-08-03 | AD | Futures | 0.75723 | 0.75865 | 0.75469 | 0.75824 | 51972.0 |
| 2020-08-03 | ALI | Futures | 2084.05 | 2148.99 | 2084.05 | 2148.99 | 208.0 |
| 2020-08-03 | B | Futures | 28.06 | 28.66 | 27.65 | 28.46 | 198700.0 |
| 2020-08-03 | B6 | Futures | 1.3292 | 1.3319 | 1.3207 | 1.3279 | 95502.0 |
| 2020-08-03 | BR | Futures | 0.15182 | 0.15233 | 0.14833 | 0.14869 | 7063.0 |
| 2020-08-03 | BTC | Futures | 15527.6 | 16033.8 | 15295.0 | 15897.0 | 5333.0 |
| 2020-08-03 | BZ | Futures | 27.42 | 27.98 | 27.0 | 27.79 | 26883.0 |
| 2020-08-03 | C | Futures | 1480.0 | 1526.0 | 1474.0 | 1520.0 | 7972.0 |
| 2020-08-03 | CB | Futures | 181.613 | 181.613 | 178.671 | 179.821 | 41.0 |
| 2020-08-03 | CC | Futures | 1577.0 | 1627.0 | 1571.0 | 1619.0 | 27375.0 |
| 2020-08-03 | CNH | Futures | 6.9016 | 6.9055 | 6.8904 | 6.8958 | 368.0 |
| 2020-08-03 | CSC | Futures | 3.977 | 3.999 | 3.79 | 3.796 | 172.0 |
| 2020-08-03 | CT | Futures | 63.41 | 64.42 | 63.01 | 64.25 | 75.0 |
| 2020-08-03 | DC | Futures | 32.27 | 32.71 | 30.99 | 30.99 | 626.0 |
| 2020-08-03 | DX | Futures | 90.208 | 90.778 | 90.117 | 90.321 | 24987.0 |
| 2020-08-03 | E1 | Futures | 1.24556 | 1.24556 | 1.22989 | 1.23886 | 29312.0 |
| 2020-08-03 | E6 | Futures | 1.26509 | 1.26697 | 1.25613 | 1.263 | 212382.0 |
| 2020-08-03 | E7 | Futures | 1.2584 | 1.2605 | 1.2498 | 1.2567 | 6701.0 |
| 2020-08-03 | EBM | Futures | 217.66 | 217.96 | 215.86 | 215.86 | 11375.0 |
| 2020-08-03 | ED | Futures | 96.4572 | 96.462 | 96.4475 | 96.4523 | 86338.0 |
| 2020-08-03 | ER | Futures | 98.382 | 98.386 | 98.377 | 98.382 | 40022.0 |
| 2020-08-03 | ESG | Futures | 298.12 | 299.39 | 298.12 | 298.99 | 26.0 |
| 2020-08-03 | EW | Futures | 1980.2 | 2005.0 | 1970.8 | 2002.0 | 13553.0 |
| 2020-08-03 | FBON | Futures | 146.37 | 146.48 | 145.69 | 146.46 | 28.0 |
| 2020-08-03 | FBTP | Futures | 132.94 | 133.15 | 132.4 | 132.93 | 55494.0 |
| 2020-08-03 | FBTS | Futures | 108.812 | 108.841 | 108.745 | 108.822 | 65606.0 |
| 2020-08-03 | FCE | Futures | 4654.2 | 4733.9 | 4601.0 | 4710.7 | 67419.0 |
| 2020-08-03 | FDAX | Futures | 13064.2 | 13484.9 | 13032.3 | 13443.4 | 80196.0 |
| 2020-08-03 | FDIV | Futures | 142.84 | 143.93 | 142.84 | 143.93 | 140.0 |
| 2020-08-03 | FDXM | Futures | 13030.8 | 13435.2 | 12992.7 | 13394.9 | 42712.0 |
| 2020-08-03 | FESX | Futures | 2921.6 | 3008.4 | 2916.1 | 2999.2 | 801773.0 |
| 2020-08-03 | FEU3 | Futures | 99.134 | 99.134 | 99.134 | 99.134 | 100.0 |
| 2020-08-03 | FGBL | Futures | 169.54 | 169.57 | 169.14 | 169.41 | 380277.0 |
| 2020-08-03 | FGBM | Futures | 135.11 | 135.17 | 135.02 | 135.07 | 281888.0 |
| 2020-08-03 | FGBS | Futures | 112.8 | 112.83 | 112.78 | 112.79 | 276205.0 |
| 2020-08-03 | FGBX | Futures | 231.32 | 231.9 | 229.84 | 231.12 | 33735.0 |
| 2020-08-03 | FMWO | Futures | 8072.9 | 8180.7 | 8063.4 | 8162.9 | 4328.0 |
| 2020-08-03 | FOAT | Futures | 156.46 | 156.64 | 156.3 | 156.59 | 120870.0 |
| 2020-08-03 | FTDX | Futures | 3074.6 | 3126.7 | 3074.6 | 3120.1 | 78.0 |
| 2020-08-03 | FTI | Futures | 510.12 | 520.96 | 507.41 | 519.62 | 27679.0 |
| 2020-08-03 | FTUK | Futures | 5555.0 | 5675.1 | 5499.7 | 5671.3 | 105295.0 |
| 2020-08-03 | FVSA | Futures | 239.8 | 239.8 | 226.23 | 230.3 | 15194.0 |
| 2020-08-03 | FXXP | Futures | 330.0 | 335.7 | 326.9 | 335.0 | 48319.0 |
> showing 50 of 120 rows — these rows as CSV