PREVIEW / futures_daily / 2021-10-27
file: by_date/futures_daily/2021/2021-10-27.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-10-27 | ES | Futures | 5133.72 | 5148.35 | 5111.23 | 5112.07 | 1263181.0 |
| 2021-10-27 | NQ | Futures | 17910.94 | 18124.56 | 17882.11 | 17974.37 | 534474.0 |
| 2021-10-27 | YM | Futures | 38784.0 | 38859.1 | 38497.9 | 38504.4 | 185252.0 |
| 2021-10-27 | CL | Futures | 62.53 | 62.62 | 60.77 | 61.25 | 529952.0 |
| 2021-10-27 | GC | Futures | 2094.1 | 2101.1 | 2081.7 | 2098.6 | 182801.0 |
| 2021-10-27 | ZN | Futures | 132.859777 | 133.447722 | 132.653201 | 133.400051 | 2427913.0 |
| 2021-10-27 | A6 | Futures | 0.7692 | 0.77274 | 0.76766 | 0.77161 | 91408.0 |
| 2021-10-27 | AD | Futures | 0.81932 | 0.82537 | 0.81633 | 0.82237 | 123635.0 |
| 2021-10-27 | ALI | Futures | 3163.46 | 3163.46 | 2993.35 | 3019.47 | 1357.0 |
| 2021-10-27 | B | Futures | 58.32 | 58.49 | 56.98 | 57.33 | 400747.0 |
| 2021-10-27 | B6 | Futures | 1.3971 | 1.3989 | 1.3916 | 1.3953 | 103063.0 |
| 2021-10-27 | BR | Futures | 0.14492 | 0.14569 | 0.14386 | 0.14496 | 8953.0 |
| 2021-10-27 | BTC | Futures | 81536.6 | 81536.6 | 76814.0 | 78269.6 | 8286.0 |
| 2021-10-27 | BZ | Futures | 57.0 | 57.09 | 55.63 | 55.99 | 38947.0 |
| 2021-10-27 | C | Futures | 1512.0 | 1515.0 | 1490.0 | 1499.0 | 4558.0 |
| 2021-10-27 | CB | Futures | 148.931 | 150.507 | 148.931 | 149.719 | 14.0 |
| 2021-10-27 | CC | Futures | 1657.0 | 1679.0 | 1643.0 | 1671.0 | 17070.0 |
| 2021-10-27 | CNH | Futures | 6.1283 | 6.1433 | 6.1283 | 6.1403 | 318.0 |
| 2021-10-27 | CSC | Futures | 2.53 | 2.54 | 2.525 | 2.54 | 97.0 |
| 2021-10-27 | CT | Futures | 101.56 | 103.55 | 100.48 | 103.15 | 16856.0 |
| 2021-10-27 | DC | Futures | 24.0 | 24.29 | 23.88 | 24.13 | 274.0 |
| 2021-10-27 | DX | Futures | 90.781 | 90.83 | 90.511 | 90.63 | 35850.0 |
| 2021-10-27 | E1 | Futures | 1.219 | 1.22348 | 1.21832 | 1.22236 | 23405.0 |
| 2021-10-27 | E6 | Futures | 1.23305 | 1.2365 | 1.23194 | 1.23454 | 186296.0 |
| 2021-10-27 | E7 | Futures | 1.2264 | 1.2296 | 1.2252 | 1.2278 | 5074.0 |
| 2021-10-27 | EBM | Futures | 412.59 | 421.4 | 411.85 | 418.46 | 21513.0 |
| 2021-10-27 | ED | Futures | 96.5344 | 96.5392 | 96.5199 | 96.5247 | 289051.0 |
| 2021-10-27 | ER | Futures | 98.48 | 98.48 | 98.47 | 98.475 | 92250.0 |
| 2021-10-27 | ESG | Futures | 428.33 | 429.17 | 426.46 | 426.55 | 399.0 |
| 2021-10-27 | EW | Futures | 2999.5 | 3002.3 | 2951.8 | 2952.9 | 14081.0 |
| 2021-10-27 | FBON | Futures | 147.97 | 148.74 | 147.88 | 148.67 | 710.0 |
| 2021-10-27 | FBTP | Futures | 137.44 | 138.35 | 137.33 | 138.22 | 169922.0 |
| 2021-10-27 | FBTS | Futures | 110.177 | 110.264 | 110.138 | 110.206 | 79669.0 |
| 2021-10-27 | FCE | Futures | 6839.0 | 6845.0 | 6803.6 | 6826.3 | 39141.0 |
| 2021-10-27 | FDAX | Futures | 16823.6 | 16823.6 | 16731.7 | 16767.0 | 64391.0 |
| 2021-10-27 | FDIV | Futures | 185.39 | 185.59 | 185.39 | 185.59 | 24.0 |
| 2021-10-27 | FDXM | Futures | 16866.1 | 16870.4 | 16779.3 | 16814.7 | 42476.0 |
| 2021-10-27 | FDXS | Futures | 16709.5 | 16709.5 | 16622.5 | 16658.6 | 14243.0 |
| 2021-10-27 | FESX | Futures | 4032.1 | 4041.2 | 4015.4 | 4029.3 | 524793.0 |
| 2021-10-27 | FGBL | Futures | 166.29 | 167.32 | 166.02 | 167.04 | 958582.0 |
| 2021-10-27 | FGBM | Futures | 133.95 | 134.21 | 133.78 | 134.12 | 559895.0 |
| 2021-10-27 | FGBS | Futures | 112.554 | 112.579 | 112.503 | 112.534 | 387903.0 |
| 2021-10-27 | FGBX | Futures | 222.1 | 226.76 | 221.69 | 225.55 | 128274.0 |
| 2021-10-27 | FMWO | Futures | 11266.1 | 11269.7 | 11183.6 | 11233.1 | 2894.0 |
| 2021-10-27 | FOAT | Futures | 154.0 | 154.95 | 153.81 | 154.74 | 172057.0 |
| 2021-10-27 | FTDX | Futures | 3941.1 | 3944.2 | 3910.3 | 3910.3 | 38.0 |
| 2021-10-27 | FTI | Futures | 778.43 | 781.92 | 775.99 | 777.4 | 15631.0 |
| 2021-10-27 | FTUK | Futures | 7170.7 | 7171.2 | 7135.6 | 7140.1 | 74331.0 |
| 2021-10-27 | FVSA | Futures | 66.18 | 68.59 | 65.49 | 66.0 | 15713.0 |
| 2021-10-27 | FXXP | Futures | 452.0 | 452.4 | 450.0 | 450.9 | 72070.0 |
> showing 50 of 123 rows — these rows as CSV