PREVIEW / futures_daily / 2021-12-29
file: by_date/futures_daily/2021/2021-12-29.parquet size: 10 KB rows: 127
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-12-29 | ES | Futures | 5384.74 | 5401.63 | 5372.35 | 5388.68 | 876030.0 |
| 2021-12-29 | NQ | Futures | 19035.37 | 19093.87 | 18890.12 | 19008.85 | 354985.0 |
| 2021-12-29 | YM | Futures | 39575.7 | 39777.5 | 39545.1 | 39688.1 | 94675.0 |
| 2021-12-29 | CL | Futures | 57.5 | 58.5 | 56.98 | 57.89 | 283557.0 |
| 2021-12-29 | GC | Futures | 2107.7 | 2109.3 | 2087.3 | 2106.7 | 138685.0 |
| 2021-12-29 | ZN | Futures | 133.528566 | 133.640373 | 132.985508 | 133.113286 | 971676.0 |
| 2021-12-29 | A6 | Futures | 0.74034 | 0.74526 | 0.73921 | 0.74321 | 52794.0 |
| 2021-12-29 | AD | Futures | 0.79126 | 0.79314 | 0.7903 | 0.79278 | 42334.0 |
| 2021-12-29 | ALI | Futures | 3116.38 | 3116.38 | 3116.38 | 3116.38 | 5.0 |
| 2021-12-29 | B | Futures | 54.8 | 55.56 | 54.22 | 54.99 | 255372.0 |
| 2021-12-29 | B6 | Futures | 1.3618 | 1.3685 | 1.3593 | 1.3673 | 75955.0 |
| 2021-12-29 | BR | Futures | 0.14459 | 0.14509 | 0.1431 | 0.14335 | 135.0 |
| 2021-12-29 | BTC | Futures | 62559.9 | 63293.7 | 61216.7 | 62193.0 | 5210.0 |
| 2021-12-29 | BZ | Futures | 53.24 | 53.97 | 52.66 | 53.41 | 25066.0 |
| 2021-12-29 | C | Futures | 1347.0 | 1358.0 | 1342.0 | 1358.0 | 3361.0 |
| 2021-12-29 | CB | Futures | 177.89 | 179.47 | 177.89 | 178.514 | 81.0 |
| 2021-12-29 | CC | Futures | 1562.0 | 1585.0 | 1550.0 | 1582.0 | 11564.0 |
| 2021-12-29 | CNH | Futures | 6.0882 | 6.0883 | 6.0805 | 6.0845 | 163.0 |
| 2021-12-29 | CSC | Futures | 2.654 | 2.661 | 2.654 | 2.661 | 3.0 |
| 2021-12-29 | CT | Futures | 106.89 | 110.68 | 106.84 | 109.74 | 12202.0 |
| 2021-12-29 | DC | Futures | 25.4 | 25.59 | 25.32 | 25.57 | 74.0 |
| 2021-12-29 | DX | Futures | 92.904 | 93.155 | 92.517 | 92.702 | 16539.0 |
| 2021-12-29 | E1 | Futures | 1.21942 | 1.22555 | 1.21529 | 1.22288 | 23033.0 |
| 2021-12-29 | E6 | Futures | 1.20038 | 1.20695 | 1.19651 | 1.20403 | 186225.0 |
| 2021-12-29 | E7 | Futures | 1.1937 | 1.2002 | 1.1898 | 1.1973 | 4702.0 |
| 2021-12-29 | EBM | Futures | 401.93 | 404.8 | 399.43 | 404.08 | 16194.0 |
| 2021-12-29 | ED | Futures | 96.4768 | 96.4817 | 96.472 | 96.4768 | 71857.0 |
| 2021-12-29 | ER | Futures | 98.529 | 98.529 | 98.519 | 98.524 | 46437.0 |
| 2021-12-29 | ESG | Futures | 449.69 | 449.95 | 447.99 | 449.19 | 200.0 |
| 2021-12-29 | EW | Futures | 3056.2 | 3070.8 | 3045.7 | 3066.7 | 10035.0 |
| 2021-12-29 | FBON | Futures | 148.53 | 148.53 | 147.88 | 148.0 | 209.0 |
| 2021-12-29 | FBTP | Futures | 136.28 | 136.35 | 135.46 | 135.63 | 49566.0 |
| 2021-12-29 | FBTS | Futures | 109.962 | 109.982 | 109.865 | 109.904 | 32301.0 |
| 2021-12-29 | FCE | Futures | 7223.9 | 7257.2 | 7189.6 | 7214.8 | 30621.0 |
| 2021-12-29 | FDAX | Futures | 17125.6 | 17125.6 | 16939.9 | 16989.3 | 41988.0 |
| 2021-12-29 | FDIV | Futures | 188.14 | 188.14 | 187.44 | 187.44 | 10.0 |
| 2021-12-29 | FDXM | Futures | 17190.0 | 17211.6 | 17014.4 | 17063.9 | 22247.0 |
| 2021-12-29 | FDXS | Futures | 17016.6 | 17044.4 | 16859.6 | 16908.8 | 9836.0 |
| 2021-12-29 | FESX | Futures | 4135.0 | 4138.4 | 4089.8 | 4101.8 | 342167.0 |
| 2021-12-29 | FGBL | Futures | 167.89 | 168.0 | 166.91 | 167.11 | 325490.0 |
| 2021-12-29 | FGBM | Futures | 134.35 | 134.43 | 134.15 | 134.18 | 188024.0 |
| 2021-12-29 | FGBS | Futures | 112.664 | 112.694 | 112.634 | 112.639 | 142111.0 |
| 2021-12-29 | FGBX | Futures | 227.25 | 227.62 | 224.11 | 224.47 | 39447.0 |
| 2021-12-29 | FMWO | Futures | 11597.8 | 11614.3 | 11555.2 | 11578.9 | 2167.0 |
| 2021-12-29 | FOAT | Futures | 155.39 | 155.46 | 154.31 | 154.51 | 82844.0 |
| 2021-12-29 | FSMX | Futures | 36919.6 | 36998.3 | 36709.8 | 36787.5 | 545.0 |
| 2021-12-29 | FTDX | Futures | 4037.5 | 4043.7 | 4006.5 | 4038.5 | 52.0 |
| 2021-12-29 | FTI | Futures | 767.21 | 769.66 | 761.12 | 763.63 | 11379.0 |
| 2021-12-29 | FTUK | Futures | 7366.8 | 7366.8 | 7310.6 | 7330.0 | 76200.0 |
| 2021-12-29 | FVSA | Futures | 66.87 | 67.96 | 65.31 | 66.71 | 17757.0 |
> showing 50 of 127 rows — these rows as CSV