PREVIEW / futures_daily / 2021-07-26
file: by_date/futures_daily/2021/2021-07-26.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-07-26 | ES | Futures | 4946.49 | 4964.75 | 4918.38 | 4961.94 | 938628.0 |
| 2021-07-26 | NQ | Futures | 17418.37 | 17459.9 | 17350.01 | 17441.15 | 391517.0 |
| 2021-07-26 | YM | Futures | 37890.5 | 38029.2 | 37573.8 | 37988.0 | 125683.0 |
| 2021-07-26 | CL | Futures | 52.24 | 52.42 | 51.07 | 52.05 | 395743.0 |
| 2021-07-26 | GC | Futures | 2107.4 | 2118.8 | 2100.2 | 2103.9 | 84263.0 |
| 2021-07-26 | ZN | Futures | 135.812652 | 136.223822 | 135.686138 | 135.828466 | 1068621.0 |
| 2021-07-26 | A6 | Futures | 0.75567 | 0.75808 | 0.75198 | 0.75685 | 63942.0 |
| 2021-07-26 | AD | Futures | 0.80683 | 0.80926 | 0.80521 | 0.808 | 52782.0 |
| 2021-07-26 | ALI | Futures | 2894.75 | 2917.03 | 2879.04 | 2909.6 | 343.0 |
| 2021-07-26 | B | Futures | 48.92 | 49.27 | 48.0 | 49.08 | 214523.0 |
| 2021-07-26 | B6 | Futures | 1.3962 | 1.4049 | 1.395 | 1.4028 | 81754.0 |
| 2021-07-26 | BFX | Futures | 4297.4 | 4325.5 | 4297.4 | 4325.5 | 23.0 |
| 2021-07-26 | BR | Futures | 0.15326 | 0.15463 | 0.15234 | 0.1539 | 6044.0 |
| 2021-07-26 | BTC | Futures | 45972.2 | 54419.7 | 45972.2 | 52911.2 | 4272.0 |
| 2021-07-26 | BZ | Futures | 47.82 | 48.08 | 46.85 | 47.91 | 28971.0 |
| 2021-07-26 | C | Futures | 1400.0 | 1444.0 | 1395.0 | 1438.0 | 9471.0 |
| 2021-07-26 | CB | Futures | 134.387 | 134.387 | 132.783 | 133.986 | 24.0 |
| 2021-07-26 | CC | Futures | 1526.0 | 1585.0 | 1526.0 | 1569.0 | 33453.0 |
| 2021-07-26 | CNH | Futures | 6.2708 | 6.287 | 6.2708 | 6.2788 | 799.0 |
| 2021-07-26 | CSC | Futures | 2.459 | 2.459 | 2.443 | 2.446 | 79.0 |
| 2021-07-26 | CT | Futures | 82.84 | 83.59 | 81.99 | 83.5 | 17.0 |
| 2021-07-26 | DC | Futures | 22.11 | 22.11 | 21.86 | 21.89 | 181.0 |
| 2021-07-26 | DX | Futures | 89.81 | 89.868 | 89.448 | 89.555 | 17463.0 |
| 2021-07-26 | E1 | Futures | 1.22179 | 1.22897 | 1.22179 | 1.2274 | 19274.0 |
| 2021-07-26 | E6 | Futures | 1.25334 | 1.25818 | 1.25238 | 1.25648 | 131803.0 |
| 2021-07-26 | E7 | Futures | 1.2471 | 1.2518 | 1.2461 | 1.2502 | 3632.0 |
| 2021-07-26 | EBM | Futures | 308.19 | 313.34 | 307.46 | 313.34 | 13993.0 |
| 2021-07-26 | ED | Futures | 96.5393 | 96.5393 | 96.5345 | 96.5345 | 30370.0 |
| 2021-07-26 | ER | Futures | 98.46 | 98.465 | 98.46 | 98.465 | 21094.0 |
| 2021-07-26 | ESG | Futures | 407.62 | 410.55 | 407.56 | 410.55 | 334.0 |
| 2021-07-26 | EW | Futures | 2826.7 | 2886.5 | 2818.3 | 2869.6 | 7576.0 |
| 2021-07-26 | FBON | Futures | 151.01 | 151.01 | 150.69 | 150.8 | 117.0 |
| 2021-07-26 | FBTP | Futures | 140.95 | 141.15 | 140.77 | 140.83 | 77890.0 |
| 2021-07-26 | FBTS | Futures | 110.38 | 110.38 | 110.331 | 110.351 | 47553.0 |
| 2021-07-26 | FCE | Futures | 6516.8 | 6573.2 | 6500.3 | 6562.2 | 46345.0 |
| 2021-07-26 | FDAX | Futures | 16765.9 | 16765.9 | 16637.3 | 16710.2 | 55707.0 |
| 2021-07-26 | FDIV | Futures | 186.13 | 187.65 | 186.13 | 187.65 | 42.0 |
| 2021-07-26 | FDXM | Futures | 16676.3 | 16676.3 | 16554.8 | 16627.3 | 38025.0 |
| 2021-07-26 | FDXS | Futures | 16550.3 | 16553.4 | 16449.6 | 16521.7 | 7729.0 |
| 2021-07-26 | FESX | Futures | 3883.0 | 3887.3 | 3854.1 | 3880.7 | 506472.0 |
| 2021-07-26 | FGBL | Futures | 170.49 | 170.9 | 170.12 | 170.32 | 541843.0 |
| 2021-07-26 | FGBM | Futures | 135.6 | 135.74 | 135.5 | 135.56 | 287517.0 |
| 2021-07-26 | FGBS | Futures | 112.714 | 112.749 | 112.709 | 112.719 | 187109.0 |
| 2021-07-26 | FGBX | Futures | 228.09 | 229.46 | 226.89 | 227.58 | 59170.0 |
| 2021-07-26 | FMWO | Futures | 10820.9 | 10873.8 | 10779.8 | 10860.9 | 2434.0 |
| 2021-07-26 | FOAT | Futures | 157.89 | 158.16 | 157.49 | 157.64 | 136041.0 |
| 2021-07-26 | FTDX | Futures | 3749.2 | 3764.6 | 3729.7 | 3732.7 | 28.0 |
| 2021-07-26 | FTI | Futures | 710.32 | 711.76 | 707.69 | 710.3 | 15941.0 |
| 2021-07-26 | FTUK | Futures | 6854.8 | 6861.7 | 6803.1 | 6845.0 | 66164.0 |
| 2021-07-26 | FVSA | Futures | 86.83 | 91.48 | 86.41 | 87.47 | 22892.0 |
> showing 50 of 123 rows — these rows as CSV