PREVIEW / futures_daily / 2019-07-10
file: by_date/futures_daily/2019/2019-07-10.parquet size: 10 KB rows: 117
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 |
|---|---|---|---|---|---|---|---|
| 2019-07-10 | ES | Futures | 3218.02 | 3245.26 | 3206.15 | 3234.47 | 1422362.0 |
| 2019-07-10 | NQ | Futures | 9035.6 | 9152.46 | 8993.29 | 9128.57 | 442842.0 |
| 2019-07-10 | YM | Futures | 28121.8 | 28332.8 | 28023.1 | 28203.7 | 209429.0 |
| 2019-07-10 | CL | Futures | 59.74 | 61.92 | 59.69 | 61.82 | 690656.0 |
| 2019-07-10 | GC | Futures | 1742.5 | 1768.7 | 1732.3 | 1758.0 | 443496.0 |
| 2019-07-10 | ZN | Futures | 126.647152 | 126.989316 | 126.273883 | 126.84934 | 1896091.0 |
| 2019-07-10 | A6 | Futures | 0.71458 | 0.71849 | 0.71252 | 0.71746 | 101559.0 |
| 2019-07-10 | AD | Futures | 0.76887 | 0.77265 | 0.76771 | 0.77219 | 89954.0 |
| 2019-07-10 | ALI | Futures | 2273.97 | 2273.97 | 2273.97 | 2273.97 | 0.0 |
| 2019-07-10 | B | Futures | 48.7 | 50.46 | 48.59 | 50.38 | 349513.0 |
| 2019-07-10 | B6 | Futures | 1.2761 | 1.2821 | 1.2743 | 1.2804 | 89236.0 |
| 2019-07-10 | BR | Futures | 0.20958 | 0.2119 | 0.20954 | 0.2119 | 1101.0 |
| 2019-07-10 | BTC | Futures | 17953.6 | 18870.5 | 16462.7 | 17176.6 | 10622.0 |
| 2019-07-10 | BZ | Futures | 47.87 | 49.83 | 47.87 | 49.74 | 40838.0 |
| 2019-07-10 | C | Futures | 1786.0 | 1804.0 | 1756.0 | 1766.0 | 8157.0 |
| 2019-07-10 | CB | Futures | 284.277 | 284.306 | 283.518 | 284.306 | 3.0 |
| 2019-07-10 | CC | Futures | 1688.0 | 1705.0 | 1663.0 | 1671.0 | 14138.0 |
| 2019-07-10 | CNH | Futures | 6.8942 | 6.8959 | 6.87 | 6.8718 | 1259.0 |
| 2019-07-10 | CSC | Futures | 3.147 | 3.157 | 3.144 | 3.152 | 107.0 |
| 2019-07-10 | CT | Futures | 62.09 | 63.0 | 62.09 | 62.75 | 43.0 |
| 2019-07-10 | DC | Futures | 26.33 | 26.41 | 26.27 | 26.35 | 98.0 |
| 2019-07-10 | DX | Futures | 93.542 | 93.551 | 93.046 | 93.106 | 17931.0 |
| 2019-07-10 | E1 | Futures | 1.1742 | 1.18011 | 1.17374 | 1.1793 | 21642.0 |
| 2019-07-10 | E6 | Futures | 1.22936 | 1.23542 | 1.22865 | 1.23411 | 198215.0 |
| 2019-07-10 | E7 | Futures | 1.223 | 1.229 | 1.2222 | 1.2277 | 4730.0 |
| 2019-07-10 | EBM | Futures | 198.93 | 200.37 | 198.35 | 199.79 | 17451.0 |
| 2019-07-10 | ED | Futures | 95.2892 | 95.3817 | 95.2697 | 95.3574 | 605545.0 |
| 2019-07-10 | ER | Futures | 98.499 | 98.514 | 98.489 | 98.509 | 216340.0 |
| 2019-07-10 | EW | Futures | 2048.8 | 2061.3 | 2042.3 | 2046.5 | 13341.0 |
| 2019-07-10 | FBON | Futures | 142.89 | 143.02 | 142.47 | 143.0 | 536.0 |
| 2019-07-10 | FBTP | Futures | 123.56 | 123.8 | 123.09 | 123.76 | 114570.0 |
| 2019-07-10 | FBTS | Futures | 107.159 | 107.35 | 107.159 | 107.322 | 63072.0 |
| 2019-07-10 | FCE | Futures | 5093.4 | 5122.2 | 5077.4 | 5087.0 | 65205.0 |
| 2019-07-10 | FDAX | Futures | 13106.5 | 13124.4 | 12997.5 | 13014.4 | 105386.0 |
| 2019-07-10 | FDIV | Futures | 146.97 | 147.07 | 146.93 | 146.93 | 22.0 |
| 2019-07-10 | FDXM | Futures | 12943.0 | 12961.7 | 12837.9 | 12854.1 | 41628.0 |
| 2019-07-10 | FESX | Futures | 3061.4 | 3071.0 | 3047.5 | 3051.0 | 778655.0 |
| 2019-07-10 | FGBL | Futures | 164.55 | 164.57 | 163.57 | 164.03 | 1088823.0 |
| 2019-07-10 | FGBM | Futures | 134.43 | 134.43 | 134.12 | 134.34 | 604069.0 |
| 2019-07-10 | FGBS | Futures | 113.056 | 113.056 | 113.016 | 113.051 | 298969.0 |
| 2019-07-10 | FGBX | Futures | 209.51 | 209.51 | 206.02 | 207.78 | 75196.0 |
| 2019-07-10 | FMWO | Futures | 7384.5 | 7445.6 | 7369.5 | 7408.7 | 2664.0 |
| 2019-07-10 | FOAT | Futures | 151.75 | 151.77 | 150.92 | 151.55 | 183455.0 |
| 2019-07-10 | FTDX | Futures | 2843.9 | 2882.4 | 2843.9 | 2860.2 | 41.0 |
| 2019-07-10 | FTI | Futures | 533.07 | 535.54 | 533.07 | 533.38 | 33.0 |
| 2019-07-10 | FTUK | Futures | 6909.9 | 6921.4 | 6879.9 | 6897.0 | 88989.0 |
| 2019-07-10 | FVSA | Futures | 182.74 | 185.51 | 176.51 | 180.66 | 39146.0 |
| 2019-07-10 | FXXP | Futures | 346.5 | 347.7 | 345.3 | 345.7 | 43083.0 |
| 2019-07-10 | G | Futures | 120.67 | 120.93 | 120.36 | 120.76 | 215683.0 |
| 2019-07-10 | GF | Futures | 280.328 | 280.819 | 278.513 | 279.347 | 7863.0 |
> showing 50 of 117 rows — these rows as CSV