PREVIEW / futures_daily / 2021-05-06
file: by_date/futures_daily/2021/2021-05-06.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-05-06 | ES | Futures | 4666.76 | 4709.96 | 4646.28 | 4706.6 | 1751616.0 |
| 2021-05-06 | NQ | Futures | 15552.7 | 15699.76 | 15442.84 | 15683.9 | 567452.0 |
| 2021-05-06 | YM | Futures | 36934.7 | 37295.1 | 36879.5 | 37277.8 | 171769.0 |
| 2021-05-06 | CL | Futures | 46.47 | 46.98 | 45.92 | 46.07 | 389214.0 |
| 2021-05-06 | GC | Futures | 2095.0 | 2132.0 | 2088.9 | 2128.6 | 287629.0 |
| 2021-05-06 | ZN | Futures | 133.301038 | 133.426675 | 133.191105 | 133.348151 | 1366666.0 |
| 2021-05-06 | A6 | Futures | 0.79449 | 0.79869 | 0.78977 | 0.79715 | 88294.0 |
| 2021-05-06 | AD | Futures | 0.82595 | 0.83451 | 0.82448 | 0.83167 | 76616.0 |
| 2021-05-06 | ALI | Futures | 2848.59 | 2872.29 | 2846.88 | 2868.3 | 1548.0 |
| 2021-05-06 | B | Futures | 44.78 | 45.37 | 44.43 | 44.53 | 273282.0 |
| 2021-05-06 | B6 | Futures | 1.4124 | 1.4157 | 1.4072 | 1.4101 | 118451.0 |
| 2021-05-06 | BFX | Futures | 4101.4 | 4103.9 | 4091.7 | 4091.7 | 5.0 |
| 2021-05-06 | BR | Futures | 0.14763 | 0.15017 | 0.14692 | 0.14957 | 15125.0 |
| 2021-05-06 | BTC | Futures | 78648.1 | 80926.8 | 76307.3 | 77584.8 | 5933.0 |
| 2021-05-06 | BZ | Futures | 43.77 | 44.28 | 43.36 | 43.46 | 25171.0 |
| 2021-05-06 | C | Futures | 1439.0 | 1459.0 | 1431.0 | 1458.0 | 1796.0 |
| 2021-05-06 | CB | Futures | 145.938 | 147.383 | 145.608 | 146.351 | 12.0 |
| 2021-05-06 | CC | Futures | 1597.0 | 1621.0 | 1587.0 | 1607.0 | 19512.0 |
| 2021-05-06 | CNH | Futures | 6.3038 | 6.3038 | 6.2798 | 6.2798 | 659.0 |
| 2021-05-06 | CSC | Futures | 3.014 | 3.014 | 2.896 | 2.896 | 50.0 |
| 2021-05-06 | CT | Futures | 81.89 | 84.75 | 81.55 | 84.46 | 15415.0 |
| 2021-05-06 | DC | Futures | 27.89 | 27.97 | 26.83 | 26.83 | 389.0 |
| 2021-05-06 | DX | Futures | 88.185 | 88.306 | 87.808 | 87.877 | 24523.0 |
| 2021-05-06 | E1 | Futures | 1.23364 | 1.24197 | 1.23173 | 1.23949 | 22171.0 |
| 2021-05-06 | E6 | Futures | 1.28027 | 1.2873 | 1.27883 | 1.28544 | 148610.0 |
| 2021-05-06 | E7 | Futures | 1.2738 | 1.2807 | 1.2724 | 1.279 | 4780.0 |
| 2021-05-06 | EBM | Futures | 336.88 | 340.19 | 330.26 | 338.72 | 32292.0 |
| 2021-05-06 | ED | Futures | 96.5028 | 96.5077 | 96.498 | 96.5077 | 145847.0 |
| 2021-05-06 | ER | Futures | 98.45 | 98.455 | 98.45 | 98.45 | 18779.0 |
| 2021-05-06 | ESG | Futures | 386.86 | 389.74 | 384.77 | 389.67 | 522.0 |
| 2021-05-06 | EW | Futures | 2916.7 | 2931.5 | 2884.3 | 2928.0 | 11090.0 |
| 2021-05-06 | FBON | Futures | 147.36 | 147.59 | 147.26 | 147.37 | 1231.0 |
| 2021-05-06 | FBTP | Futures | 137.36 | 137.43 | 136.81 | 137.06 | 178542.0 |
| 2021-05-06 | FBTS | Futures | 110.02 | 110.03 | 109.961 | 110.0 | 80413.0 |
| 2021-05-06 | FCE | Futures | 6238.7 | 6271.7 | 6206.1 | 6241.6 | 65872.0 |
| 2021-05-06 | FDAX | Futures | 16172.0 | 16294.6 | 16091.0 | 16174.2 | 71378.0 |
| 2021-05-06 | FDIV | Futures | 184.46 | 184.71 | 183.33 | 184.17 | 123.0 |
| 2021-05-06 | FDXM | Futures | 16154.5 | 16273.7 | 16071.4 | 16154.5 | 68659.0 |
| 2021-05-06 | FDXS | Futures | 16064.1 | 16189.1 | 15986.8 | 16068.4 | 3192.0 |
| 2021-05-06 | FESX | Futures | 3754.5 | 3780.0 | 3732.7 | 3751.6 | 809977.0 |
| 2021-05-06 | FGBL | Futures | 166.77 | 167.08 | 166.44 | 166.79 | 845569.0 |
| 2021-05-06 | FGBM | Futures | 134.71 | 134.78 | 134.6 | 134.68 | 465395.0 |
| 2021-05-06 | FGBS | Futures | 112.644 | 112.654 | 112.629 | 112.639 | 194938.0 |
| 2021-05-06 | FGBX | Futures | 215.58 | 216.47 | 214.26 | 215.56 | 84716.0 |
| 2021-05-06 | FMWO | Futures | 10325.2 | 10396.8 | 10277.0 | 10319.3 | 3996.0 |
| 2021-05-06 | FOAT | Futures | 154.72 | 155.06 | 154.49 | 154.79 | 293189.0 |
| 2021-05-06 | FTDX | Futures | 3526.0 | 3531.1 | 3467.4 | 3478.7 | 302.0 |
| 2021-05-06 | FTI | Futures | 675.87 | 676.43 | 668.32 | 673.03 | 21436.0 |
| 2021-05-06 | FTUK | Futures | 6828.5 | 6893.3 | 6818.8 | 6858.7 | 80994.0 |
| 2021-05-06 | FVSA | Futures | 105.89 | 112.48 | 103.52 | 109.05 | 28552.0 |
> showing 50 of 123 rows — these rows as CSV