PREVIEW / futures_daily / 2021-06-07
file: by_date/futures_daily/2021/2021-06-07.parquet size: 10 KB rows: 121
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-06-07 | ES | Futures | 4749.24 | 4749.52 | 4728.76 | 4741.66 | 934681.0 |
| 2021-06-07 | NQ | Futures | 15886.33 | 15944.87 | 15792.04 | 15922.09 | 397545.0 |
| 2021-06-07 | YM | Futures | 37622.0 | 37692.3 | 37403.4 | 37466.1 | 117598.0 |
| 2021-06-07 | CL | Futures | 49.48 | 49.82 | 49.06 | 49.28 | 365621.0 |
| 2021-06-07 | GC | Futures | 2215.6 | 2225.7 | 2203.2 | 2220.9 | 146018.0 |
| 2021-06-07 | ZN | Futures | 133.772177 | 133.772177 | 133.630835 | 133.709358 | 4593.0 |
| 2021-06-07 | A6 | Futures | 0.79361 | 0.79623 | 0.79228 | 0.79567 | 75772.0 |
| 2021-06-07 | AD | Futures | 0.83907 | 0.84029 | 0.83689 | 0.83932 | 49942.0 |
| 2021-06-07 | ALI | Futures | 2759.29 | 2775.92 | 2759.29 | 2766.33 | 85.0 |
| 2021-06-07 | B | Futures | 46.96 | 47.25 | 46.49 | 46.74 | 224334.0 |
| 2021-06-07 | B6 | Futures | 1.4379 | 1.4411 | 1.433 | 1.4403 | 76624.0 |
| 2021-06-07 | BFX | Futures | 4185.7 | 4199.0 | 4185.7 | 4199.0 | 2.0 |
| 2021-06-07 | BR | Futures | 0.15731 | 0.15803 | 0.15687 | 0.15767 | 390.0 |
| 2021-06-07 | BTC | Futures | 52455.9 | 53629.5 | 49261.2 | 51644.6 | 6680.0 |
| 2021-06-07 | BZ | Futures | 45.77 | 46.13 | 45.39 | 45.64 | 21019.0 |
| 2021-06-07 | C | Futures | 1465.0 | 1470.0 | 1442.0 | 1443.0 | 4479.0 |
| 2021-06-07 | CB | Futures | 149.13 | 149.13 | 148.428 | 148.628 | 44.0 |
| 2021-06-07 | CC | Futures | 1606.0 | 1607.0 | 1575.0 | 1577.0 | 28676.0 |
| 2021-06-07 | CNH | Futures | 6.1946 | 6.2055 | 6.1898 | 6.1898 | 1330.0 |
| 2021-06-07 | CSC | Futures | 2.68 | 2.687 | 2.661 | 2.664 | 70.0 |
| 2021-06-07 | CT | Futures | 80.03 | 80.65 | 78.42 | 78.66 | 15772.0 |
| 2021-06-07 | DC | Futures | 24.52 | 24.65 | 24.4 | 24.46 | 50.0 |
| 2021-06-07 | DX | Futures | 87.117 | 87.262 | 86.881 | 86.92 | 31855.0 |
| 2021-06-07 | E1 | Futures | 1.25176 | 1.25525 | 1.24917 | 1.2548 | 17239.0 |
| 2021-06-07 | E6 | Futures | 1.29652 | 1.30041 | 1.29428 | 1.29961 | 151318.0 |
| 2021-06-07 | E7 | Futures | 1.29 | 1.2937 | 1.2878 | 1.2931 | 4832.0 |
| 2021-06-07 | EBM | Futures | 319.6 | 323.27 | 317.02 | 318.49 | 15366.0 |
| 2021-06-07 | ED | Futures | 96.556 | 96.556 | 96.5512 | 96.5536 | 75692.0 |
| 2021-06-07 | ER | Futures | 98.465 | 98.465 | 98.46 | 98.46 | 20208.0 |
| 2021-06-07 | ESG | Futures | 391.46 | 392.81 | 391.22 | 392.18 | 205.0 |
| 2021-06-07 | EW | Futures | 2919.4 | 2929.1 | 2904.7 | 2915.1 | 9200.0 |
| 2021-06-07 | FBON | Futures | 147.61 | 147.61 | 147.19 | 147.24 | 683.0 |
| 2021-06-07 | FBTP | Futures | 137.85 | 137.85 | 137.24 | 137.33 | 163141.0 |
| 2021-06-07 | FBTS | Futures | 110.195 | 110.205 | 110.137 | 110.146 | 89020.0 |
| 2021-06-07 | FCE | Futures | 6482.2 | 6538.0 | 6461.7 | 6520.6 | 46495.0 |
| 2021-06-07 | FDAX | Futures | 16726.4 | 16769.0 | 16639.0 | 16725.3 | 45599.0 |
| 2021-06-07 | FDXM | Futures | 16712.4 | 16748.6 | 16616.6 | 16705.0 | 38594.0 |
| 2021-06-07 | FDXS | Futures | 16655.1 | 16658.3 | 16530.1 | 16615.9 | 2151.0 |
| 2021-06-07 | FESX | Futures | 3866.0 | 3881.1 | 3845.2 | 3874.5 | 605484.0 |
| 2021-06-07 | FGBL | Futures | 166.54 | 166.64 | 166.28 | 166.37 | 564894.0 |
| 2021-06-07 | FGBM | Futures | 134.68 | 134.68 | 134.56 | 134.59 | 393806.0 |
| 2021-06-07 | FGBS | Futures | 112.599 | 112.599 | 112.574 | 112.579 | 233947.0 |
| 2021-06-07 | FGBX | Futures | 214.77 | 214.82 | 213.62 | 214.35 | 104051.0 |
| 2021-06-07 | FMWO | Futures | 10540.1 | 10640.0 | 10524.8 | 10557.7 | 3656.0 |
| 2021-06-07 | FOAT | Futures | 154.65 | 154.7 | 154.35 | 154.42 | 144888.0 |
| 2021-06-07 | FTDX | Futures | 3430.4 | 3509.0 | 3430.4 | 3491.0 | 25.0 |
| 2021-06-07 | FTI | Futures | 685.89 | 686.79 | 681.6 | 684.2 | 15504.0 |
| 2021-06-07 | FTUK | Futures | 6893.3 | 6913.2 | 6854.8 | 6898.1 | 53610.0 |
| 2021-06-07 | FVSA | Futures | 94.27 | 97.13 | 92.97 | 95.31 | 16468.0 |
| 2021-06-07 | FXXP | Futures | 428.8 | 430.9 | 427.4 | 430.4 | 54572.0 |
> showing 50 of 121 rows — these rows as CSV