PREVIEW / futures_daily / 2019-08-13
file: by_date/futures_daily/2019/2019-08-13.parquet size: 10 KB rows: 122
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-08-13 | ES | Futures | 3110.11 | 3177.01 | 3093.39 | 3163.79 | 2184012.0 |
| 2019-08-13 | NQ | Futures | 8715.82 | 8968.24 | 8651.05 | 8920.46 | 674983.0 |
| 2019-08-13 | YM | Futures | 27166.3 | 27729.1 | 27038.2 | 27630.4 | 291674.0 |
| 2019-08-13 | CL | Futures | 55.85 | 58.64 | 55.32 | 58.26 | 783486.0 |
| 2019-08-13 | GC | Futures | 1877.8 | 1907.2 | 1836.6 | 1867.7 | 616740.0 |
| 2019-08-13 | ZN | Futures | 129.679965 | 129.928811 | 128.933427 | 129.228931 | 2232738.0 |
| 2019-08-13 | A6 | Futures | 0.69524 | 0.70224 | 0.69493 | 0.69966 | 104772.0 |
| 2019-08-13 | AD | Futures | 0.76186 | 0.76499 | 0.75869 | 0.76282 | 77766.0 |
| 2019-08-13 | ALI | Futures | 2183.87 | 2207.39 | 2169.52 | 2196.4 | 203.0 |
| 2019-08-13 | B | Futures | 44.11 | 46.39 | 43.75 | 46.24 | 338076.0 |
| 2019-08-13 | B6 | Futures | 1.235 | 1.2367 | 1.231 | 1.2323 | 85873.0 |
| 2019-08-13 | BFX | Futures | 4176.8 | 4243.2 | 4176.8 | 4243.2 | 10.0 |
| 2019-08-13 | BR | Futures | 0.2002 | 0.20203 | 0.1988 | 0.20139 | 11710.0 |
| 2019-08-13 | BTC | Futures | 15840.4 | 15929.9 | 14869.7 | 15069.4 | 4145.0 |
| 2019-08-13 | BZ | Futures | 43.49 | 45.8 | 43.17 | 45.65 | 45522.0 |
| 2019-08-13 | C | Futures | 1621.0 | 1624.0 | 1584.0 | 1585.0 | 8163.0 |
| 2019-08-13 | CB | Futures | 275.699 | 275.845 | 275.553 | 275.845 | 13.0 |
| 2019-08-13 | CC | Futures | 1477.0 | 1477.0 | 1444.0 | 1448.0 | 32962.0 |
| 2019-08-13 | CNH | Futures | 7.1043 | 7.1148 | 7.0065 | 7.0197 | 1394.0 |
| 2019-08-13 | CSC | Futures | 3.095 | 3.097 | 3.094 | 3.095 | 91.0 |
| 2019-08-13 | CT | Futures | 57.42 | 59.16 | 56.98 | 58.6 | 20.0 |
| 2019-08-13 | DC | Futures | 26.08 | 26.08 | 25.95 | 26.02 | 195.0 |
| 2019-08-13 | DX | Futures | 93.604 | 94.057 | 93.513 | 94.0 | 27580.0 |
| 2019-08-13 | E1 | Futures | 1.20087 | 1.20424 | 1.1909 | 1.19183 | 37630.0 |
| 2019-08-13 | E6 | Futures | 1.2268 | 1.22822 | 1.22173 | 1.22227 | 207706.0 |
| 2019-08-13 | E7 | Futures | 1.2203 | 1.2217 | 1.2154 | 1.2159 | 4187.0 |
| 2019-08-13 | EBM | Futures | 192.59 | 193.17 | 191.16 | 191.44 | 22893.0 |
| 2019-08-13 | ED | Futures | 95.4255 | 95.4401 | 95.3671 | 95.372 | 374485.0 |
| 2019-08-13 | ER | Futures | 98.548 | 98.548 | 98.538 | 98.543 | 32946.0 |
| 2019-08-13 | EW | Futures | 1967.0 | 2008.8 | 1956.5 | 1989.8 | 13896.0 |
| 2019-08-13 | FBON | Futures | 145.13 | 145.48 | 145.1 | 145.43 | 157.0 |
| 2019-08-13 | FBTP | Futures | 123.96 | 125.16 | 123.96 | 125.09 | 85008.0 |
| 2019-08-13 | FBTS | Futures | 106.957 | 107.264 | 106.957 | 107.254 | 63620.0 |
| 2019-08-13 | FCE | Futures | 4810.2 | 4895.0 | 4770.4 | 4856.5 | 125524.0 |
| 2019-08-13 | FDAX | Futures | 12257.3 | 12460.5 | 12139.9 | 12383.1 | 146011.0 |
| 2019-08-13 | FDIV | Futures | 139.32 | 141.96 | 139.27 | 141.68 | 268.0 |
| 2019-08-13 | FDXM | Futures | 12103.7 | 12306.5 | 11989.3 | 12230.6 | 84704.0 |
| 2019-08-13 | FESX | Futures | 2895.5 | 2952.3 | 2876.3 | 2933.1 | 1506383.0 |
| 2019-08-13 | FEU3 | Futures | 99.164 | 99.169 | 99.164 | 99.169 | 297.0 |
| 2019-08-13 | FGBL | Futures | 168.78 | 169.1 | 168.6 | 168.95 | 579108.0 |
| 2019-08-13 | FGBM | Futures | 135.76 | 135.81 | 135.66 | 135.77 | 334223.0 |
| 2019-08-13 | FGBS | Futures | 113.338 | 113.348 | 113.303 | 113.323 | 255612.0 |
| 2019-08-13 | FGBX | Futures | 225.77 | 227.46 | 225.6 | 227.03 | 61190.0 |
| 2019-08-13 | FMWO | Futures | 7115.6 | 7226.4 | 7069.5 | 7182.5 | 8416.0 |
| 2019-08-13 | FOAT | Futures | 154.9 | 155.24 | 154.82 | 155.17 | 114659.0 |
| 2019-08-13 | FTDX | Futures | 2712.6 | 2743.7 | 2688.9 | 2737.3 | 376.0 |
| 2019-08-13 | FTI | Futures | 511.56 | 518.8 | 506.59 | 514.61 | 34553.0 |
| 2019-08-13 | FTUK | Futures | 6632.0 | 6690.1 | 6582.1 | 6666.1 | 114945.0 |
| 2019-08-13 | FVSA | Futures | 231.39 | 234.53 | 216.97 | 221.99 | 28332.0 |
| 2019-08-13 | FXXP | Futures | 331.3 | 335.1 | 328.3 | 333.3 | 141581.0 |
> showing 50 of 122 rows — these rows as CSV