PREVIEW / futures_daily / 2021-05-05
file: by_date/futures_daily/2021/2021-05-05.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-05 | ES | Futures | 4666.2 | 4690.6 | 4660.31 | 4668.16 | 1418246.0 |
| 2021-05-05 | NQ | Futures | 15600.86 | 15762.05 | 15528.19 | 15560.78 | 520694.0 |
| 2021-05-05 | YM | Futures | 36816.7 | 37036.4 | 36719.3 | 36927.1 | 155840.0 |
| 2021-05-05 | CL | Futures | 47.31 | 47.53 | 46.22 | 46.73 | 460066.0 |
| 2021-05-05 | GC | Futures | 2084.9 | 2096.3 | 2074.2 | 2091.8 | 178811.0 |
| 2021-05-05 | ZN | Futures | 133.096877 | 133.348151 | 132.845603 | 133.222514 | 1454032.0 |
| 2021-05-05 | A6 | Futures | 0.79085 | 0.79526 | 0.79008 | 0.79423 | 68175.0 |
| 2021-05-05 | AD | Futures | 0.82352 | 0.82706 | 0.82321 | 0.82509 | 54979.0 |
| 2021-05-05 | ALI | Futures | 2807.47 | 2815.18 | 2801.19 | 2813.47 | 1662.0 |
| 2021-05-05 | B | Futures | 45.36 | 45.75 | 44.7 | 45.1 | 283725.0 |
| 2021-05-05 | B6 | Futures | 1.4101 | 1.4143 | 1.4091 | 1.4125 | 69099.0 |
| 2021-05-05 | BR | Futures | 0.14562 | 0.14755 | 0.14518 | 0.14728 | 8385.0 |
| 2021-05-05 | BTC | Futures | 75078.2 | 80250.1 | 72958.4 | 79124.6 | 6056.0 |
| 2021-05-05 | BZ | Futures | 44.36 | 44.65 | 43.62 | 44.02 | 32004.0 |
| 2021-05-05 | C | Futures | 1415.0 | 1437.0 | 1415.0 | 1433.0 | 2312.0 |
| 2021-05-05 | CB | Futures | 145.567 | 147.383 | 145.319 | 145.732 | 40.0 |
| 2021-05-05 | CC | Futures | 1556.0 | 1599.0 | 1555.0 | 1595.0 | 27788.0 |
| 2021-05-05 | CNH | Futures | 6.3012 | 6.3097 | 6.2967 | 6.3038 | 72.0 |
| 2021-05-05 | CSC | Futures | 3.002 | 3.024 | 3.0 | 3.016 | 86.0 |
| 2021-05-05 | CT | Futures | 81.26 | 82.0 | 80.93 | 81.43 | 9209.0 |
| 2021-05-05 | DC | Futures | 27.94 | 28.03 | 27.7 | 27.89 | 213.0 |
| 2021-05-05 | DX | Futures | 88.185 | 88.359 | 88.098 | 88.222 | 15390.0 |
| 2021-05-05 | E1 | Futures | 1.23297 | 1.23499 | 1.22925 | 1.23319 | 16342.0 |
| 2021-05-05 | E6 | Futures | 1.28075 | 1.28251 | 1.27814 | 1.27963 | 133771.0 |
| 2021-05-05 | E7 | Futures | 1.2746 | 1.2761 | 1.2717 | 1.2732 | 3696.0 |
| 2021-05-05 | EBM | Futures | 322.17 | 333.57 | 321.8 | 332.83 | 22065.0 |
| 2021-05-05 | ED | Futures | 96.4932 | 96.5028 | 96.4883 | 96.498 | 97664.0 |
| 2021-05-05 | ER | Futures | 98.455 | 98.455 | 98.45 | 98.45 | 23282.0 |
| 2021-05-05 | ESG | Futures | 386.88 | 388.58 | 386.29 | 386.69 | 581.0 |
| 2021-05-05 | EW | Futures | 2921.0 | 2934.9 | 2892.5 | 2912.9 | 9357.0 |
| 2021-05-05 | FBON | Futures | 147.55 | 147.56 | 147.19 | 147.3 | 1098.0 |
| 2021-05-05 | FBTP | Futures | 137.53 | 137.55 | 137.11 | 137.2 | 143843.0 |
| 2021-05-05 | FBTS | Futures | 110.039 | 110.049 | 109.991 | 110.0 | 68896.0 |
| 2021-05-05 | FCE | Futures | 6159.7 | 6233.7 | 6157.2 | 6224.3 | 62111.0 |
| 2021-05-05 | FDAX | Futures | 15909.8 | 16200.8 | 15909.8 | 16168.8 | 64552.0 |
| 2021-05-05 | FDIV | Futures | 181.72 | 183.33 | 181.72 | 183.33 | 172.0 |
| 2021-05-05 | FDXM | Futures | 15891.5 | 16181.1 | 15890.4 | 16149.2 | 54200.0 |
| 2021-05-05 | FDXS | Futures | 15817.4 | 16094.8 | 15816.3 | 16063.1 | 4029.0 |
| 2021-05-05 | FESX | Futures | 3693.0 | 3760.1 | 3693.0 | 3751.6 | 822239.0 |
| 2021-05-05 | FGBL | Futures | 166.82 | 166.84 | 166.41 | 166.67 | 705689.0 |
| 2021-05-05 | FGBM | Futures | 134.71 | 134.72 | 134.57 | 134.67 | 479674.0 |
| 2021-05-05 | FGBS | Futures | 112.649 | 112.654 | 112.629 | 112.639 | 237993.0 |
| 2021-05-05 | FGBX | Futures | 216.22 | 216.22 | 214.77 | 215.43 | 70784.0 |
| 2021-05-05 | FMWO | Futures | 10299.3 | 10358.0 | 10299.3 | 10341.6 | 1785.0 |
| 2021-05-05 | FOAT | Futures | 155.0 | 155.0 | 154.51 | 154.75 | 183450.0 |
| 2021-05-05 | FTDX | Futures | 3518.8 | 3541.4 | 3518.8 | 3530.6 | 119.0 |
| 2021-05-05 | FTI | Futures | 662.92 | 676.39 | 662.92 | 674.66 | 28006.0 |
| 2021-05-05 | FTUK | Futures | 6740.3 | 6843.1 | 6735.0 | 6834.3 | 86167.0 |
| 2021-05-05 | FVSA | Futures | 109.58 | 110.63 | 104.57 | 105.89 | 28314.0 |
| 2021-05-05 | FXXP | Futures | 411.7 | 417.4 | 411.3 | 416.4 | 73825.0 |
> showing 50 of 123 rows — these rows as CSV