PREVIEW / futures_daily / 2020-07-14
file: by_date/futures_daily/2020/2020-07-14.parquet size: 10 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2020-07-14 | ES | Futures | 3545.32 | 3593.16 | 3510.71 | 3583.31 | 2256766.0 |
| 2020-07-14 | NQ | Futures | 12305.1 | 12410.72 | 12022.77 | 12356.46 | 915009.0 |
| 2020-07-14 | YM | Futures | 27849.0 | 28480.2 | 27728.9 | 28390.2 | 296495.0 |
| 2020-07-14 | CL | Futures | 29.07 | 29.77 | 28.68 | 29.59 | 238302.0 |
| 2020-07-14 | GC | Futures | 2167.4 | 2179.1 | 2150.4 | 2177.2 | 253207.0 |
| 2020-07-14 | ZN | Futures | 138.094129 | 138.264463 | 137.985735 | 138.171553 | 902282.0 |
| 2020-07-14 | A6 | Futures | 0.71421 | 0.71802 | 0.71205 | 0.71699 | 119342.0 |
| 2020-07-14 | AD | Futures | 0.74627 | 0.74667 | 0.74403 | 0.7453 | 71035.0 |
| 2020-07-14 | ALI | Futures | 2029.94 | 2029.94 | 2019.36 | 2021.18 | 144.0 |
| 2020-07-14 | B | Futures | 27.52 | 28.16 | 27.23 | 27.95 | 221116.0 |
| 2020-07-14 | B6 | Futures | 1.2756 | 1.2763 | 1.2676 | 1.2754 | 86534.0 |
| 2020-07-14 | BR | Futures | 0.14635 | 0.14833 | 0.14516 | 0.14833 | 146.0 |
| 2020-07-14 | BTC | Futures | 12774.3 | 12836.3 | 12581.5 | 12822.5 | 2869.0 |
| 2020-07-14 | BZ | Futures | 26.96 | 27.52 | 26.62 | 27.32 | 21724.0 |
| 2020-07-14 | C | Futures | 1427.0 | 1427.0 | 1407.0 | 1417.0 | 5484.0 |
| 2020-07-14 | CB | Futures | 195.254 | 195.789 | 193.676 | 195.789 | 19.0 |
| 2020-07-14 | CC | Futures | 1428.0 | 1428.0 | 1402.0 | 1413.0 | 11455.0 |
| 2020-07-14 | CNH | Futures | 6.9249 | 6.9417 | 6.9244 | 6.9261 | 101.0 |
| 2020-07-14 | CSC | Futures | 4.312 | 4.314 | 4.186 | 4.213 | 83.0 |
| 2020-07-14 | CT | Futures | 63.78 | 63.78 | 63.4 | 63.4 | 11.0 |
| 2020-07-14 | DC | Futures | 35.15 | 35.44 | 34.25 | 34.5 | 432.0 |
| 2020-07-14 | DX | Futures | 93.232 | 93.377 | 92.85 | 92.929 | 12966.0 |
| 2020-07-14 | E1 | Futures | 1.20865 | 1.21308 | 1.2074 | 1.21149 | 20418.0 |
| 2020-07-14 | E6 | Futures | 1.21965 | 1.22587 | 1.21686 | 1.22431 | 193601.0 |
| 2020-07-14 | E7 | Futures | 1.2134 | 1.2197 | 1.2108 | 1.2182 | 7684.0 |
| 2020-07-14 | EBM | Futures | 222.15 | 223.65 | 221.85 | 222.15 | 5571.0 |
| 2020-07-14 | ED | Futures | 96.4088 | 96.4185 | 96.4088 | 96.4185 | 122575.0 |
| 2020-07-14 | ER | Futures | 98.362 | 98.367 | 98.352 | 98.362 | 71016.0 |
| 2020-07-14 | ESG | Futures | 285.23 | 290.39 | 284.78 | 290.33 | 273.0 |
| 2020-07-14 | EW | Futures | 1873.2 | 1892.3 | 1847.6 | 1891.6 | 16051.0 |
| 2020-07-14 | FBON | Futures | 145.35 | 145.76 | 145.32 | 145.72 | 355.0 |
| 2020-07-14 | FBTP | Futures | 130.27 | 130.63 | 130.1 | 130.62 | 84806.0 |
| 2020-07-14 | FBTS | Futures | 108.434 | 108.493 | 108.405 | 108.493 | 66784.0 |
| 2020-07-14 | FCE | Futures | 4802.3 | 4864.9 | 4770.2 | 4835.4 | 49302.0 |
| 2020-07-14 | FDAX | Futures | 13377.6 | 13579.4 | 13295.8 | 13448.7 | 89483.0 |
| 2020-07-14 | FDIV | Futures | 145.64 | 145.64 | 145.59 | 145.59 | 54.0 |
| 2020-07-14 | FDXM | Futures | 13321.9 | 13529.4 | 13247.8 | 13400.2 | 62281.0 |
| 2020-07-14 | FESX | Futures | 3042.6 | 3078.6 | 3016.7 | 3050.9 | 895937.0 |
| 2020-07-14 | FGBL | Futures | 168.14 | 168.4 | 167.91 | 168.35 | 476670.0 |
| 2020-07-14 | FGBM | Futures | 134.63 | 134.72 | 134.53 | 134.67 | 317813.0 |
| 2020-07-14 | FGBS | Futures | 112.724 | 112.734 | 112.694 | 112.714 | 206011.0 |
| 2020-07-14 | FGBX | Futures | 226.4 | 227.9 | 225.96 | 227.59 | 36184.0 |
| 2020-07-14 | FMWO | Futures | 7880.9 | 7985.2 | 7828.7 | 7902.2 | 4246.0 |
| 2020-07-14 | FOAT | Futures | 155.55 | 155.7 | 155.3 | 155.69 | 114823.0 |
| 2020-07-14 | FTDX | Futures | 3090.4 | 3101.2 | 3063.9 | 3081.8 | 46.0 |
| 2020-07-14 | FTI | Futures | 533.06 | 536.61 | 526.89 | 532.61 | 12644.0 |
| 2020-07-14 | FTUK | Futures | 5750.7 | 5840.0 | 5722.8 | 5801.2 | 86160.0 |
| 2020-07-14 | FVSA | Futures | 272.83 | 279.62 | 261.07 | 266.04 | 21539.0 |
| 2020-07-14 | FXXP | Futures | 336.3 | 340.3 | 334.4 | 337.7 | 47661.0 |
| 2020-07-14 | G | Futures | 127.29 | 127.59 | 127.2 | 127.47 | 221872.0 |
> showing 50 of 119 rows — these rows as CSV