PREVIEW / futures_daily / 2021-08-17
file: by_date/futures_daily/2021/2021-08-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-08-17 | ES | Futures | 5026.86 | 5027.14 | 4959.13 | 4994.82 | 1789568.0 |
| 2021-08-17 | NQ | Futures | 17457.02 | 17459.61 | 17186.48 | 17302.42 | 687897.0 |
| 2021-08-17 | YM | Futures | 38502.0 | 38510.7 | 37988.0 | 38232.0 | 200917.0 |
| 2021-08-17 | CL | Futures | 49.2 | 49.41 | 48.41 | 48.59 | 232410.0 |
| 2021-08-17 | GC | Futures | 2087.3 | 2097.2 | 2079.1 | 2085.7 | 144815.0 |
| 2021-08-17 | ZN | Futures | 135.860094 | 136.239636 | 135.781023 | 135.891723 | 1409107.0 |
| 2021-08-17 | A6 | Futures | 0.75244 | 0.75295 | 0.7428 | 0.74377 | 118707.0 |
| 2021-08-17 | AD | Futures | 0.80632 | 0.80658 | 0.80151 | 0.80303 | 72817.0 |
| 2021-08-17 | ALI | Futures | 3007.54 | 3026.07 | 2959.37 | 2987.3 | 154.0 |
| 2021-08-17 | B | Futures | 46.47 | 46.62 | 45.83 | 45.97 | 239956.0 |
| 2021-08-17 | B6 | Futures | 1.4056 | 1.4058 | 1.3938 | 1.3948 | 88823.0 |
| 2021-08-17 | BR | Futures | 0.15202 | 0.1525 | 0.15058 | 0.15162 | 7119.0 |
| 2021-08-17 | BTC | Futures | 61680.6 | 63296.4 | 59763.2 | 61037.0 | 4393.0 |
| 2021-08-17 | BZ | Futures | 45.28 | 45.51 | 44.74 | 44.87 | 29163.0 |
| 2021-08-17 | C | Futures | 1502.0 | 1526.0 | 1502.0 | 1522.0 | 3536.0 |
| 2021-08-17 | CB | Futures | 138.038 | 138.038 | 137.436 | 137.436 | 44.0 |
| 2021-08-17 | CC | Futures | 1671.0 | 1707.0 | 1656.0 | 1700.0 | 32535.0 |
| 2021-08-17 | CNH | Futures | 6.2608 | 6.2794 | 6.2608 | 6.2748 | 666.0 |
| 2021-08-17 | CSC | Futures | 2.539 | 2.539 | 2.486 | 2.496 | 155.0 |
| 2021-08-17 | CT | Futures | 88.61 | 90.01 | 88.02 | 88.51 | 41.0 |
| 2021-08-17 | DC | Futures | 22.93 | 22.94 | 22.41 | 22.58 | 416.0 |
| 2021-08-17 | DX | Futures | 89.516 | 90.062 | 89.516 | 90.033 | 20510.0 |
| 2021-08-17 | E1 | Futures | 1.23144 | 1.23493 | 1.22785 | 1.22841 | 23029.0 |
| 2021-08-17 | E6 | Futures | 1.2535 | 1.25414 | 1.24595 | 1.24627 | 142598.0 |
| 2021-08-17 | E7 | Futures | 1.2472 | 1.2479 | 1.2396 | 1.2401 | 4163.0 |
| 2021-08-17 | EBM | Futures | 369.98 | 369.98 | 360.05 | 361.52 | 10190.0 |
| 2021-08-17 | ED | Futures | 96.5418 | 96.5442 | 96.5393 | 96.5393 | 69993.0 |
| 2021-08-17 | ER | Futures | 98.47 | 98.47 | 98.465 | 98.47 | 13412.0 |
| 2021-08-17 | ESG | Futures | 413.73 | 414.23 | 410.23 | 412.84 | 659.0 |
| 2021-08-17 | EW | Futures | 2920.2 | 2920.3 | 2858.0 | 2888.2 | 11719.0 |
| 2021-08-17 | FBON | Futures | 151.79 | 151.79 | 151.45 | 151.52 | 134.0 |
| 2021-08-17 | FBTP | Futures | 141.85 | 142.06 | 141.53 | 141.6 | 85766.0 |
| 2021-08-17 | FBTS | Futures | 110.507 | 110.526 | 110.477 | 110.477 | 42944.0 |
| 2021-08-17 | FCE | Futures | 6813.0 | 6815.5 | 6774.0 | 6807.0 | 74832.0 |
| 2021-08-17 | FDAX | Futures | 17071.2 | 17071.2 | 16925.5 | 17040.1 | 63710.0 |
| 2021-08-17 | FDIV | Futures | 188.38 | 188.97 | 188.38 | 188.82 | 20.0 |
| 2021-08-17 | FDXM | Futures | 16987.6 | 16987.6 | 16842.6 | 16955.6 | 39859.0 |
| 2021-08-17 | FDXS | Futures | 16878.6 | 16878.6 | 16734.5 | 16847.9 | 8606.0 |
| 2021-08-17 | FESX | Futures | 3990.2 | 3990.2 | 3950.8 | 3975.0 | 671402.0 |
| 2021-08-17 | FGBL | Futures | 171.22 | 171.69 | 171.15 | 171.26 | 510269.0 |
| 2021-08-17 | FGBM | Futures | 135.75 | 135.89 | 135.72 | 135.75 | 279508.0 |
| 2021-08-17 | FGBS | Futures | 112.739 | 112.759 | 112.729 | 112.739 | 286419.0 |
| 2021-08-17 | FGBX | Futures | 232.15 | 233.65 | 231.72 | 232.09 | 54479.0 |
| 2021-08-17 | FMWO | Futures | 10996.0 | 10996.0 | 10877.3 | 10943.1 | 3517.0 |
| 2021-08-17 | FOAT | Futures | 158.33 | 158.64 | 158.14 | 158.26 | 137465.0 |
| 2021-08-17 | FTDX | Futures | 3940.1 | 3951.9 | 3911.3 | 3949.8 | 37.0 |
| 2021-08-17 | FTI | Futures | 734.74 | 737.47 | 730.25 | 736.26 | 10269.0 |
| 2021-08-17 | FTUK | Futures | 7020.3 | 7043.4 | 6966.1 | 7028.1 | 92651.0 |
| 2021-08-17 | FVSA | Futures | 75.95 | 80.42 | 75.95 | 77.5 | 40408.0 |
| 2021-08-17 | FXXP | Futures | 449.0 | 450.9 | 447.3 | 450.2 | 48998.0 |
> showing 50 of 122 rows — these rows as CSV