PREVIEW / futures_daily / 2021-05-28
file: by_date/futures_daily/2021/2021-05-28.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-05-28 | ES | Futures | 4725.67 | 4732.69 | 4714.17 | 4715.85 | 1110833.0 |
| 2021-05-28 | NQ | Futures | 15795.79 | 15875.08 | 15758.88 | 15786.27 | 366218.0 |
| 2021-05-28 | YM | Futures | 37401.2 | 37491.0 | 37335.2 | 37354.7 | 111041.0 |
| 2021-05-28 | CL | Futures | 47.65 | 48.06 | 47.1 | 47.2 | 390461.0 |
| 2021-05-28 | GC | Futures | 2222.1 | 2232.6 | 2203.9 | 2228.5 | 198141.0 |
| 2021-05-28 | ZN | Futures | 133.363856 | 133.64654 | 133.238219 | 133.536607 | 180702.0 |
| 2021-05-28 | A6 | Futures | 0.79377 | 0.79438 | 0.78721 | 0.79095 | 86030.0 |
| 2021-05-28 | AD | Futures | 0.83948 | 0.83988 | 0.83588 | 0.83831 | 65560.0 |
| 2021-05-28 | ALI | Futures | 2804.94 | 2841.58 | 2784.37 | 2841.58 | 42.0 |
| 2021-05-28 | B | Futures | 45.42 | 45.6 | 44.83 | 44.93 | 294069.0 |
| 2021-05-28 | B6 | Futures | 1.4422 | 1.4427 | 1.4354 | 1.4415 | 88501.0 |
| 2021-05-28 | BFX | Futures | 4164.7 | 4164.7 | 4163.7 | 4163.7 | 1.0 |
| 2021-05-28 | BR | Futures | 0.15162 | 0.15162 | 0.15162 | 0.15162 | 1.0 |
| 2021-05-28 | BTC | Futures | 56563.5 | 56795.3 | 50927.4 | 51905.4 | 8101.0 |
| 2021-05-28 | BZ | Futures | 44.21 | 44.52 | 43.78 | 43.87 | 31275.0 |
| 2021-05-28 | C | Futures | 1465.0 | 1472.0 | 1454.0 | 1465.0 | 4108.0 |
| 2021-05-28 | CB | Futures | 152.64 | 152.82 | 152.239 | 152.439 | 22.0 |
| 2021-05-28 | CC | Futures | 1620.0 | 1625.0 | 1603.0 | 1607.0 | 11526.0 |
| 2021-05-28 | CNH | Futures | 6.184 | 6.1899 | 6.1691 | 6.1705 | 624.0 |
| 2021-05-28 | CSC | Futures | 2.659 | 2.672 | 2.649 | 2.652 | 90.0 |
| 2021-05-28 | CT | Futures | 77.03 | 77.31 | 76.39 | 76.57 | 11371.0 |
| 2021-05-28 | DC | Futures | 24.69 | 24.77 | 24.59 | 24.64 | 80.0 |
| 2021-05-28 | DX | Futures | 86.968 | 87.388 | 86.944 | 86.966 | 33296.0 |
| 2021-05-28 | E1 | Futures | 1.25469 | 1.25536 | 1.2467 | 1.25153 | 22175.0 |
| 2021-05-28 | E6 | Futures | 1.29977 | 1.30089 | 1.29317 | 1.30046 | 181970.0 |
| 2021-05-28 | E7 | Futures | 1.2932 | 1.2943 | 1.2866 | 1.2939 | 5361.0 |
| 2021-05-28 | EBM | Futures | 312.61 | 312.98 | 307.46 | 310.77 | 15781.0 |
| 2021-05-28 | ED | Futures | 96.556 | 96.5584 | 96.5536 | 96.5536 | 122940.0 |
| 2021-05-28 | ER | Futures | 98.455 | 98.465 | 98.455 | 98.46 | 54111.0 |
| 2021-05-28 | ESG | Futures | 390.06 | 390.5 | 389.52 | 389.52 | 165.0 |
| 2021-05-28 | EW | Futures | 2922.8 | 2931.1 | 2902.2 | 2917.7 | 7584.0 |
| 2021-05-28 | FBON | Futures | 147.19 | 147.28 | 146.95 | 147.23 | 373.0 |
| 2021-05-28 | FBTP | Futures | 136.98 | 137.31 | 136.74 | 137.21 | 160253.0 |
| 2021-05-28 | FBTS | Futures | 110.059 | 110.098 | 110.02 | 110.088 | 75580.0 |
| 2021-05-28 | FCE | Futures | 6422.8 | 6466.2 | 6416.4 | 6455.3 | 46572.0 |
| 2021-05-28 | FDAX | Futures | 16504.6 | 16571.8 | 16446.0 | 16536.6 | 42151.0 |
| 2021-05-28 | FDIV | Futures | 187.3 | 187.3 | 187.21 | 187.21 | 17.0 |
| 2021-05-28 | FDXM | Futures | 16480.3 | 16550.6 | 16426.0 | 16516.5 | 34203.0 |
| 2021-05-28 | FDXS | Futures | 16371.3 | 16463.4 | 16337.4 | 16428.5 | 1838.0 |
| 2021-05-28 | FESX | Futures | 3830.1 | 3850.9 | 3823.5 | 3843.3 | 710983.0 |
| 2021-05-28 | FGBL | Futures | 166.03 | 166.29 | 165.76 | 166.16 | 731711.0 |
| 2021-05-28 | FGBM | Futures | 134.42 | 134.53 | 134.33 | 134.48 | 346757.0 |
| 2021-05-28 | FGBS | Futures | 112.584 | 112.599 | 112.569 | 112.589 | 375761.0 |
| 2021-05-28 | FGBX | Futures | 213.03 | 213.67 | 212.35 | 213.27 | 83603.0 |
| 2021-05-28 | FMWO | Futures | 10497.8 | 10527.2 | 10488.4 | 10510.7 | 3149.0 |
| 2021-05-28 | FOAT | Futures | 154.25 | 154.46 | 153.97 | 154.34 | 181957.0 |
| 2021-05-28 | FTDX | Futures | 3469.9 | 3531.6 | 3469.9 | 3517.2 | 73.0 |
| 2021-05-28 | FTI | Futures | 676.12 | 681.12 | 675.21 | 679.03 | 18153.0 |
| 2021-05-28 | FTUK | Futures | 6856.7 | 6867.5 | 6822.7 | 6841.6 | 97215.0 |
| 2021-05-28 | FVSA | Futures | 96.87 | 99.48 | 95.05 | 96.87 | 17543.0 |
> showing 50 of 124 rows — these rows as CSV