PREVIEW / futures_daily / 2019-11-11
file: by_date/futures_daily/2019/2019-11-11.parquet size: 10 KB rows: 118
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-11-11 | ES | Futures | 3345.67 | 3347.57 | 3328.35 | 3342.43 | 844597.0 |
| 2019-11-11 | NQ | Futures | 9515.83 | 9521.01 | 9457.34 | 9507.18 | 229844.0 |
| 2019-11-11 | YM | Futures | 29021.5 | 29050.9 | 28837.8 | 29035.1 | 123436.0 |
| 2019-11-11 | CL | Futures | 58.64 | 58.64 | 57.47 | 58.09 | 498981.0 |
| 2019-11-11 | GC | Futures | 1801.0 | 1810.1 | 1787.3 | 1797.4 | 310155.0 |
| 2019-11-11 | ZN | Futures | 127.096054 | 127.421227 | 127.065085 | 127.235414 | 344598.0 |
| 2019-11-11 | A6 | Futures | 0.7043 | 0.70502 | 0.70317 | 0.70379 | 57183.0 |
| 2019-11-11 | AD | Futures | 0.76151 | 0.76247 | 0.76116 | 0.76186 | 41796.0 |
| 2019-11-11 | ALI | Futures | 2203.7 | 2215.54 | 2190.95 | 2190.95 | 207.0 |
| 2019-11-11 | B | Futures | 49.93 | 50.06 | 49.11 | 49.6 | 213342.0 |
| 2019-11-11 | B6 | Futures | 1.3015 | 1.3129 | 1.3013 | 1.3083 | 89753.0 |
| 2019-11-11 | BR | Futures | 0.19425 | 0.19509 | 0.19235 | 0.19493 | 6429.0 |
| 2019-11-11 | BTC | Futures | 13141.0 | 13191.5 | 12397.3 | 12635.5 | 3623.0 |
| 2019-11-11 | BZ | Futures | 49.18 | 49.37 | 48.45 | 48.92 | 23316.0 |
| 2019-11-11 | C | Futures | 1691.0 | 1715.0 | 1685.0 | 1713.0 | 6196.0 |
| 2019-11-11 | CB | Futures | 247.393 | 248.84 | 247.393 | 248.81 | 20.0 |
| 2019-11-11 | CC | Futures | 1631.0 | 1647.0 | 1620.0 | 1645.0 | 26015.0 |
| 2019-11-11 | CNH | Futures | 6.9811 | 7.0068 | 6.9811 | 7.0009 | 975.0 |
| 2019-11-11 | CSC | Futures | 3.451 | 3.464 | 3.444 | 3.461 | 28.0 |
| 2019-11-11 | CT | Futures | 62.85 | 63.12 | 62.03 | 62.58 | 33881.0 |
| 2019-11-11 | DC | Futures | 28.74 | 28.94 | 28.62 | 28.8 | 332.0 |
| 2019-11-11 | DX | Futures | 94.942 | 94.947 | 94.691 | 94.752 | 8460.0 |
| 2019-11-11 | E1 | Futures | 1.15599 | 1.16151 | 1.15588 | 1.16094 | 19821.0 |
| 2019-11-11 | E6 | Futures | 1.19702 | 1.19952 | 1.19664 | 1.19854 | 103459.0 |
| 2019-11-11 | E7 | Futures | 1.1909 | 1.1934 | 1.1905 | 1.1923 | 1373.0 |
| 2019-11-11 | EBM | Futures | 194.27 | 194.82 | 193.72 | 194.0 | 10655.0 |
| 2019-11-11 | ED | Futures | 95.318 | 95.3277 | 95.318 | 95.3229 | 173167.0 |
| 2019-11-11 | ER | Futures | 98.386 | 98.391 | 98.382 | 98.386 | 36771.0 |
| 2019-11-11 | EW | Futures | 2099.7 | 2100.2 | 2084.9 | 2095.3 | 7346.0 |
| 2019-11-11 | FBON | Futures | 142.66 | 144.1 | 142.66 | 143.17 | 293.0 |
| 2019-11-11 | FBTP | Futures | 128.75 | 129.05 | 128.2 | 128.36 | 87577.0 |
| 2019-11-11 | FBTS | Futures | 108.124 | 108.288 | 108.009 | 108.047 | 43002.0 |
| 2019-11-11 | FCE | Futures | 5324.8 | 5362.0 | 5322.5 | 5350.7 | 93165.0 |
| 2019-11-11 | FDAX | Futures | 13971.3 | 13971.3 | 13857.9 | 13931.2 | 74689.0 |
| 2019-11-11 | FDIV | Futures | 161.96 | 162.14 | 161.4 | 162.1 | 70.0 |
| 2019-11-11 | FDXM | Futures | 13795.1 | 13795.1 | 13679.6 | 13749.3 | 28516.0 |
| 2019-11-11 | FESX | Futures | 3243.9 | 3243.9 | 3224.6 | 3239.5 | 560662.0 |
| 2019-11-11 | FGBL | Futures | 163.87 | 164.21 | 163.7 | 163.8 | 350461.0 |
| 2019-11-11 | FGBM | Futures | 133.57 | 133.64 | 133.52 | 133.53 | 184085.0 |
| 2019-11-11 | FGBS | Futures | 112.664 | 112.679 | 112.654 | 112.659 | 130431.0 |
| 2019-11-11 | FGBX | Futures | 210.54 | 211.85 | 210.0 | 210.4 | 25719.0 |
| 2019-11-11 | FMWO | Futures | 7529.1 | 7555.3 | 7524.6 | 7545.1 | 1534.0 |
| 2019-11-11 | FOAT | Futures | 151.78 | 151.85 | 151.32 | 151.39 | 92268.0 |
| 2019-11-11 | FTDX | Futures | 2879.4 | 2893.2 | 2879.4 | 2889.8 | 56.0 |
| 2019-11-11 | FTI | Futures | 568.17 | 570.9 | 568.13 | 569.82 | 18021.0 |
| 2019-11-11 | FTUK | Futures | 6811.1 | 6814.8 | 6707.3 | 6769.0 | 109452.0 |
| 2019-11-11 | FVSA | Futures | 148.66 | 149.19 | 142.82 | 144.94 | 12901.0 |
| 2019-11-11 | FXXP | Futures | 365.1 | 366.7 | 364.0 | 366.2 | 26826.0 |
| 2019-11-11 | G | Futures | 120.07 | 120.25 | 119.81 | 119.93 | 99944.0 |
| 2019-11-11 | GF | Futures | 307.757 | 310.601 | 307.125 | 309.917 | 4736.0 |
> showing 50 of 118 rows — these rows as CSV