PREVIEW / futures_daily / 2020-06-19
file: by_date/futures_daily/2020/2020-06-19.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-06-19 | ES | Futures | 3485.66 | 3539.69 | 3440.64 | 3443.73 | 1952273.0 |
| 2020-06-19 | NQ | Futures | 11588.99 | 11736.97 | 11508.9 | 11517.61 | 518436.0 |
| 2020-06-19 | YM | Futures | 27758.9 | 28206.9 | 27337.8 | 27359.2 | 258223.0 |
| 2020-06-19 | CL | Futures | 28.29 | 29.43 | 27.92 | 28.87 | 497181.0 |
| 2020-06-19 | GC | Futures | 2076.8 | 2114.2 | 2075.0 | 2104.7 | 181151.0 |
| 2020-06-19 | ZN | Futures | 137.428279 | 137.629583 | 137.180521 | 137.536674 | 862061.0 |
| 2020-06-19 | A6 | Futures | 0.70434 | 0.71113 | 0.70249 | 0.70465 | 81927.0 |
| 2020-06-19 | AD | Futures | 0.74632 | 0.74946 | 0.74556 | 0.74627 | 54511.0 |
| 2020-06-19 | ALI | Futures | 1977.04 | 1983.09 | 1951.04 | 1951.04 | 109.0 |
| 2020-06-19 | B | Futures | 27.31 | 28.09 | 26.86 | 27.62 | 217494.0 |
| 2020-06-19 | B6 | Futures | 1.2616 | 1.2654 | 1.254 | 1.2551 | 95607.0 |
| 2020-06-19 | BR | Futures | 0.14718 | 0.1492 | 0.14718 | 0.1492 | 6.0 |
| 2020-06-19 | BTC | Futures | 13052.9 | 13164.2 | 12858.2 | 12955.6 | 3481.0 |
| 2020-06-19 | BZ | Futures | 26.48 | 27.45 | 26.22 | 26.97 | 34079.0 |
| 2020-06-19 | C | Futures | 1767.0 | 1772.0 | 1725.0 | 1726.0 | 3240.0 |
| 2020-06-19 | CB | Futures | 210.767 | 210.767 | 209.671 | 209.671 | 8.0 |
| 2020-06-19 | CC | Futures | 1484.0 | 1501.0 | 1471.0 | 1477.0 | 10268.0 |
| 2020-06-19 | CNH | Futures | 7.0057 | 7.0081 | 6.9908 | 7.0002 | 222.0 |
| 2020-06-19 | CSC | Futures | 3.683 | 3.741 | 3.681 | 3.741 | 69.0 |
| 2020-06-19 | CT | Futures | 59.49 | 60.44 | 59.49 | 60.01 | 2857.0 |
| 2020-06-19 | DC | Futures | 30.68 | 31.13 | 30.46 | 31.04 | 331.0 |
| 2020-06-19 | DX | Futures | 94.082 | 94.372 | 93.807 | 94.253 | 18095.0 |
| 2020-06-19 | E1 | Futures | 1.19661 | 1.20002 | 1.19468 | 1.19627 | 15435.0 |
| 2020-06-19 | E6 | Futures | 1.20452 | 1.21004 | 1.20065 | 1.20258 | 170181.0 |
| 2020-06-19 | E7 | Futures | 1.1986 | 1.2039 | 1.1947 | 1.1966 | 6838.0 |
| 2020-06-19 | EBM | Futures | 215.86 | 216.76 | 214.36 | 216.16 | 12305.0 |
| 2020-06-19 | ED | Futures | 96.3798 | 96.3847 | 96.375 | 96.3847 | 76563.0 |
| 2020-06-19 | ER | Futures | 98.357 | 98.372 | 98.357 | 98.367 | 59387.0 |
| 2020-06-19 | ESG | Futures | 282.75 | 282.75 | 278.22 | 279.39 | 165.0 |
| 2020-06-19 | EW | Futures | 1897.8 | 1935.4 | 1872.9 | 1892.6 | 13723.0 |
| 2020-06-19 | FBON | Futures | 144.09 | 144.49 | 144.08 | 144.42 | 132.0 |
| 2020-06-19 | FBTP | Futures | 128.76 | 129.13 | 128.68 | 129.05 | 51113.0 |
| 2020-06-19 | FBTS | Futures | 108.26 | 108.328 | 108.231 | 108.308 | 46024.0 |
| 2020-06-19 | FCE | Futures | 4829.6 | 4903.6 | 4784.0 | 4842.8 | 84198.0 |
| 2020-06-19 | FDAX | Futures | 13047.2 | 13192.7 | 12914.4 | 13089.6 | 102639.0 |
| 2020-06-19 | FDIV | Futures | 143.6 | 143.6 | 142.7 | 142.7 | 193.0 |
| 2020-06-19 | FDXM | Futures | 12999.0 | 13145.1 | 12866.7 | 13042.4 | 51869.0 |
| 2020-06-19 | FESX | Futures | 2978.9 | 3024.1 | 2955.8 | 2997.3 | 1309881.0 |
| 2020-06-19 | FGBL | Futures | 167.79 | 167.96 | 167.49 | 167.85 | 383643.0 |
| 2020-06-19 | FGBM | Futures | 134.53 | 134.66 | 134.46 | 134.62 | 296414.0 |
| 2020-06-19 | FGBS | Futures | 112.714 | 112.774 | 112.709 | 112.764 | 221458.0 |
| 2020-06-19 | FGBX | Futures | 226.02 | 226.04 | 223.82 | 225.24 | 42588.0 |
| 2020-06-19 | FMWO | Futures | 7797.9 | 7854.8 | 7700.7 | 7807.4 | 3055.0 |
| 2020-06-19 | FOAT | Futures | 154.86 | 155.09 | 154.59 | 155.02 | 108753.0 |
| 2020-06-19 | FTDX | Futures | 3065.4 | 3085.8 | 3027.6 | 3063.4 | 354.0 |
| 2020-06-19 | FTI | Futures | 522.32 | 528.16 | 519.03 | 525.61 | 30011.0 |
| 2020-06-19 | FTUK | Futures | 5859.8 | 5935.0 | 5832.4 | 5908.0 | 120190.0 |
| 2020-06-19 | FVSA | Futures | 290.62 | 302.28 | 275.37 | 280.3 | 15183.0 |
| 2020-06-19 | FXXP | Futures | 334.3 | 337.3 | 331.4 | 335.5 | 63973.0 |
| 2020-06-19 | G | Futures | 126.47 | 126.59 | 126.17 | 126.48 | 166468.0 |
> showing 50 of 119 rows — these rows as CSV