PREVIEW / futures_daily / 2020-05-13
file: by_date/futures_daily/2020/2020-05-13.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-05-13 | ES | Futures | 3142.14 | 3183.08 | 3082.67 | 3112.54 | 2591379.0 |
| 2020-05-13 | NQ | Futures | 10370.41 | 10550.4 | 10178.38 | 10309.07 | 703290.0 |
| 2020-05-13 | YM | Futures | 25069.3 | 25374.5 | 24520.9 | 24719.3 | 308738.0 |
| 2020-05-13 | CL | Futures | 18.83 | 19.69 | 18.45 | 18.83 | 150864.0 |
| 2020-05-13 | GC | Futures | 2067.7 | 2093.8 | 2063.6 | 2081.5 | 211614.0 |
| 2020-05-13 | ZN | Futures | 137.392483 | 137.624017 | 137.346176 | 137.531403 | 1203530.0 |
| 2020-05-13 | A6 | Futures | 0.66531 | 0.67035 | 0.66141 | 0.66162 | 92392.0 |
| 2020-05-13 | AD | Futures | 0.72004 | 0.72348 | 0.71791 | 0.71837 | 55603.0 |
| 2020-05-13 | ALI | Futures | 1775.21 | 1783.88 | 1768.04 | 1782.39 | 108.0 |
| 2020-05-13 | B | Futures | 19.38 | 20.17 | 19.06 | 19.28 | 221112.0 |
| 2020-05-13 | B6 | Futures | 1.2455 | 1.2528 | 1.2395 | 1.2405 | 94114.0 |
| 2020-05-13 | BR | Futures | 0.13907 | 0.14063 | 0.13768 | 0.13804 | 5962.0 |
| 2020-05-13 | BTC | Futures | 12301.9 | 13115.5 | 12281.0 | 12893.0 | 5001.0 |
| 2020-05-13 | BZ | Futures | 18.84 | 19.52 | 18.46 | 18.66 | 25072.0 |
| 2020-05-13 | C | Futures | 1842.0 | 1892.0 | 1817.0 | 1885.0 | 8244.0 |
| 2020-05-13 | CB | Futures | 169.808 | 169.808 | 169.808 | 169.808 | 41.0 |
| 2020-05-13 | CC | Futures | 1568.0 | 1611.0 | 1554.0 | 1605.0 | 17534.0 |
| 2020-05-13 | CNH | Futures | 7.0516 | 7.058 | 7.0377 | 7.0554 | 371.0 |
| 2020-05-13 | CSC | Futures | 2.879 | 2.981 | 2.879 | 2.981 | 69.0 |
| 2020-05-13 | CT | Futures | 56.83 | 56.96 | 55.52 | 56.01 | 18961.0 |
| 2020-05-13 | DC | Futures | 23.59 | 24.41 | 23.33 | 24.41 | 660.0 |
| 2020-05-13 | DX | Futures | 96.751 | 97.012 | 96.296 | 96.979 | 14300.0 |
| 2020-05-13 | E1 | Futures | 1.17542 | 1.1793 | 1.17189 | 1.17235 | 16744.0 |
| 2020-05-13 | E6 | Futures | 1.16661 | 1.17198 | 1.16268 | 1.16311 | 147605.0 |
| 2020-05-13 | E7 | Futures | 1.1608 | 1.1658 | 1.1566 | 1.157 | 7414.0 |
| 2020-05-13 | EBM | Futures | 222.75 | 223.05 | 220.35 | 220.35 | 19024.0 |
| 2020-05-13 | ED | Futures | 96.3339 | 96.3629 | 96.3194 | 96.3533 | 287230.0 |
| 2020-05-13 | ER | Futures | 98.254 | 98.269 | 98.24 | 98.264 | 66074.0 |
| 2020-05-13 | ESG | Futures | 258.78 | 259.48 | 253.13 | 255.1 | 40.0 |
| 2020-05-13 | EW | Futures | 1675.2 | 1702.8 | 1621.9 | 1640.5 | 12656.0 |
| 2020-05-13 | FBON | Futures | 139.78 | 140.61 | 139.68 | 140.37 | 188.0 |
| 2020-05-13 | FBTP | Futures | 122.62 | 123.68 | 122.29 | 123.63 | 104174.0 |
| 2020-05-13 | FBTS | Futures | 106.96 | 107.124 | 106.854 | 107.095 | 76984.0 |
| 2020-05-13 | FCE | Futures | 4282.5 | 4292.7 | 4158.6 | 4210.6 | 47248.0 |
| 2020-05-13 | FDAX | Futures | 11181.9 | 11320.5 | 11032.3 | 11147.6 | 97779.0 |
| 2020-05-13 | FDIV | Futures | 119.23 | 119.46 | 117.61 | 117.61 | 300.0 |
| 2020-05-13 | FDXM | Futures | 11256.1 | 11373.0 | 11086.0 | 11200.8 | 82262.0 |
| 2020-05-13 | FESX | Futures | 2574.5 | 2604.8 | 2534.1 | 2561.7 | 1241170.0 |
| 2020-05-13 | FGBL | Futures | 168.7 | 169.06 | 168.56 | 168.78 | 551664.0 |
| 2020-05-13 | FGBM | Futures | 135.07 | 135.19 | 134.98 | 135.07 | 310716.0 |
| 2020-05-13 | FGBS | Futures | 112.91 | 112.956 | 112.905 | 112.93 | 193616.0 |
| 2020-05-13 | FGBX | Futures | 227.86 | 229.58 | 227.37 | 228.6 | 52411.0 |
| 2020-05-13 | FMWO | Futures | 7005.7 | 7064.5 | 6897.4 | 6976.2 | 4414.0 |
| 2020-05-13 | FOAT | Futures | 152.97 | 153.4 | 152.91 | 153.16 | 121431.0 |
| 2020-05-13 | FTDX | Futures | 2999.2 | 3034.6 | 2999.2 | 3017.9 | 57.0 |
| 2020-05-13 | FTI | Futures | 480.65 | 481.25 | 470.4 | 475.69 | 12336.0 |
| 2020-05-13 | FTUK | Futures | 5522.5 | 5598.9 | 5487.1 | 5548.4 | 105292.0 |
| 2020-05-13 | FVSA | Futures | 277.77 | 307.63 | 267.82 | 291.35 | 22697.0 |
| 2020-05-13 | FXXP | Futures | 310.2 | 311.0 | 304.7 | 307.6 | 93701.0 |
| 2020-05-13 | G | Futures | 126.23 | 126.48 | 126.13 | 126.31 | 246153.0 |
> showing 50 of 119 rows — these rows as CSV