PREVIEW / futures_daily / 2021-08-16
file: by_date/futures_daily/2021/2021-08-16.parquet size: 10 KB rows: 123
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-16 | ES | Futures | 5009.15 | 5031.92 | 4982.46 | 5029.11 | 1239520.0 |
| 2021-08-16 | NQ | Futures | 17442.88 | 17465.67 | 17209.84 | 17459.9 | 590789.0 |
| 2021-08-16 | YM | Futures | 38366.5 | 38544.3 | 38109.5 | 38530.2 | 151693.0 |
| 2021-08-16 | CL | Futures | 49.54 | 49.83 | 47.98 | 49.11 | 205578.0 |
| 2021-08-16 | GC | Futures | 2077.7 | 2089.8 | 2067.3 | 2088.1 | 137698.0 |
| 2021-08-16 | ZN | Futures | 135.749395 | 136.192193 | 135.686138 | 135.95498 | 1375814.0 |
| 2021-08-16 | A6 | Futures | 0.75587 | 0.75623 | 0.75064 | 0.75239 | 64949.0 |
| 2021-08-16 | AD | Futures | 0.81008 | 0.81033 | 0.80561 | 0.80648 | 64337.0 |
| 2021-08-16 | ALI | Futures | 2993.29 | 3018.09 | 2980.18 | 2990.15 | 151.0 |
| 2021-08-16 | B | Futures | 46.65 | 46.92 | 45.38 | 46.29 | 294024.0 |
| 2021-08-16 | B6 | Futures | 1.408 | 1.4093 | 1.404 | 1.4051 | 65501.0 |
| 2021-08-16 | BR | Futures | 0.15206 | 0.1527 | 0.15066 | 0.1515 | 6139.0 |
| 2021-08-16 | BTC | Futures | 62894.1 | 64496.5 | 61238.1 | 61808.0 | 4125.0 |
| 2021-08-16 | BZ | Futures | 45.54 | 45.8 | 44.29 | 45.18 | 33537.0 |
| 2021-08-16 | C | Futures | 1498.0 | 1511.0 | 1498.0 | 1506.0 | 5132.0 |
| 2021-08-16 | CB | Futures | 137.797 | 138.84 | 137.677 | 138.84 | 47.0 |
| 2021-08-16 | CC | Futures | 1677.0 | 1696.0 | 1670.0 | 1674.0 | 33618.0 |
| 2021-08-16 | CNH | Futures | 6.2647 | 6.265 | 6.2592 | 6.2595 | 143.0 |
| 2021-08-16 | CSC | Futures | 2.565 | 2.599 | 2.515 | 2.545 | 174.0 |
| 2021-08-16 | CT | Futures | 87.84 | 87.86 | 87.47 | 87.72 | 13.0 |
| 2021-08-16 | DC | Futures | 23.03 | 23.41 | 22.54 | 22.96 | 847.0 |
| 2021-08-16 | DX | Futures | 89.453 | 89.569 | 89.385 | 89.524 | 14708.0 |
| 2021-08-16 | E1 | Futures | 1.2274 | 1.23369 | 1.22628 | 1.23178 | 19373.0 |
| 2021-08-16 | E6 | Futures | 1.25547 | 1.25594 | 1.25238 | 1.25318 | 100012.0 |
| 2021-08-16 | E7 | Futures | 1.2495 | 1.2496 | 1.2461 | 1.2469 | 2737.0 |
| 2021-08-16 | EBM | Futures | 375.5 | 381.01 | 367.41 | 371.45 | 16234.0 |
| 2021-08-16 | ED | Futures | 96.5418 | 96.5442 | 96.5418 | 96.5442 | 72268.0 |
| 2021-08-16 | ER | Futures | 98.47 | 98.47 | 98.465 | 98.47 | 12274.0 |
| 2021-08-16 | ESG | Futures | 413.77 | 415.88 | 411.6 | 415.79 | 77.0 |
| 2021-08-16 | EW | Futures | 2927.8 | 2930.3 | 2898.0 | 2923.7 | 8060.0 |
| 2021-08-16 | FBON | Futures | 151.94 | 151.94 | 151.49 | 151.67 | 227.0 |
| 2021-08-16 | FBTP | Futures | 141.98 | 141.99 | 141.47 | 141.75 | 76440.0 |
| 2021-08-16 | FBTS | Futures | 110.516 | 110.516 | 110.458 | 110.497 | 39162.0 |
| 2021-08-16 | FCE | Futures | 6848.9 | 6851.9 | 6802.5 | 6825.5 | 30025.0 |
| 2021-08-16 | FDAX | Futures | 17062.6 | 17093.7 | 16969.4 | 17021.9 | 59897.0 |
| 2021-08-16 | FDIV | Futures | 188.82 | 188.87 | 188.68 | 188.68 | 30.0 |
| 2021-08-16 | FDXM | Futures | 16996.1 | 17009.9 | 16885.2 | 16937.5 | 36324.0 |
| 2021-08-16 | FDXS | Futures | 16895.5 | 16900.8 | 16779.0 | 16829.9 | 8295.0 |
| 2021-08-16 | FESX | Futures | 3996.3 | 3996.8 | 3967.4 | 3976.4 | 624552.0 |
| 2021-08-16 | FGBL | Futures | 171.32 | 171.53 | 170.95 | 171.26 | 468506.0 |
| 2021-08-16 | FGBM | Futures | 135.75 | 135.82 | 135.66 | 135.75 | 242034.0 |
| 2021-08-16 | FGBS | Futures | 112.734 | 112.749 | 112.719 | 112.734 | 145560.0 |
| 2021-08-16 | FGBX | Futures | 232.85 | 233.43 | 231.21 | 232.17 | 63414.0 |
| 2021-08-16 | FMWO | Futures | 10979.5 | 11030.0 | 10943.1 | 10963.1 | 2624.0 |
| 2021-08-16 | FOAT | Futures | 158.4 | 158.53 | 158.1 | 158.31 | 127222.0 |
| 2021-08-16 | FTDX | Futures | 3923.6 | 3927.2 | 3907.2 | 3913.4 | 22.0 |
| 2021-08-16 | FTI | Futures | 736.92 | 737.8 | 732.93 | 735.21 | 2896.0 |
| 2021-08-16 | FTUK | Futures | 7063.1 | 7063.1 | 6971.0 | 7003.0 | 91533.0 |
| 2021-08-16 | FVSA | Futures | 74.01 | 77.12 | 73.81 | 75.76 | 49723.0 |
| 2021-08-16 | FXXP | Futures | 450.1 | 451.3 | 448.4 | 449.7 | 37620.0 |
> showing 50 of 123 rows — these rows as CSV