PREVIEW / futures_daily / 2019-01-24
file: by_date/futures_daily/2019/2019-01-24.parquet size: 10 KB rows: 115
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-01-24 | ES | Futures | 2852.83 | 2866.37 | 2843.09 | 2851.75 | 1266714.0 |
| 2019-01-24 | NQ | Futures | 7714.11 | 7778.37 | 7702.53 | 7728.0 | 449017.0 |
| 2019-01-24 | YM | Futures | 25854.5 | 25955.8 | 25721.6 | 25797.6 | 209709.0 |
| 2019-01-24 | CL | Futures | 54.55 | 55.61 | 54.15 | 55.25 | 714415.0 |
| 2019-01-24 | GC | Futures | 1615.7 | 1617.7 | 1606.9 | 1612.6 | 225765.0 |
| 2019-01-24 | ZN | Futures | 120.989084 | 121.346994 | 120.911277 | 121.253626 | 1356409.0 |
| 2019-01-24 | A6 | Futures | 0.73631 | 0.73889 | 0.73003 | 0.73085 | 103250.0 |
| 2019-01-24 | AD | Futures | 0.75959 | 0.76045 | 0.75782 | 0.75914 | 54800.0 |
| 2019-01-24 | B | Futures | 44.1 | 44.58 | 43.74 | 44.34 | 214034.0 |
| 2019-01-24 | B6 | Futures | 1.3461 | 1.3479 | 1.3395 | 1.3437 | 97866.0 |
| 2019-01-24 | BFX | Futures | 4039.7 | 4048.4 | 4039.7 | 4048.4 | 5.0 |
| 2019-01-24 | BR | Futures | 0.21213 | 0.21253 | 0.20998 | 0.21102 | 689.0 |
| 2019-01-24 | BTC | Futures | 5168.0 | 5227.0 | 5160.6 | 5190.1 | 884.0 |
| 2019-01-24 | BZ | Futures | 43.68 | 44.11 | 43.27 | 43.88 | 16084.0 |
| 2019-01-24 | C | Futures | 1420.0 | 1444.0 | 1417.0 | 1430.0 | 7154.0 |
| 2019-01-24 | CB | Futures | 276.358 | 276.358 | 272.744 | 273.23 | 10.0 |
| 2019-01-24 | CC | Futures | 1546.0 | 1569.0 | 1541.0 | 1554.0 | 17278.0 |
| 2019-01-24 | CNH | Futures | 6.8062 | 6.8204 | 6.7934 | 6.8083 | 531.0 |
| 2019-01-24 | CSC | Futures | 2.674 | 2.684 | 2.663 | 2.667 | 43.0 |
| 2019-01-24 | CT | Futures | 80.08 | 80.51 | 79.55 | 79.67 | 10129.0 |
| 2019-01-24 | DC | Futures | 22.88 | 22.88 | 22.58 | 22.64 | 357.0 |
| 2019-01-24 | DX | Futures | 91.307 | 91.913 | 91.283 | 91.838 | 33919.0 |
| 2019-01-24 | E1 | Futures | 1.18759 | 1.189 | 1.18395 | 1.18501 | 21203.0 |
| 2019-01-24 | E6 | Futures | 1.26304 | 1.26409 | 1.25271 | 1.25387 | 287586.0 |
| 2019-01-24 | E7 | Futures | 1.257 | 1.2579 | 1.2466 | 1.2477 | 7413.0 |
| 2019-01-24 | EBM | Futures | 212.31 | 212.83 | 211.54 | 212.31 | 21422.0 |
| 2019-01-24 | ED | Futures | 95.0135 | 95.0281 | 95.0135 | 95.0232 | 140664.0 |
| 2019-01-24 | ER | Futures | 98.396 | 98.401 | 98.396 | 98.401 | 22630.0 |
| 2019-01-24 | EW | Futures | 1901.1 | 1921.5 | 1897.3 | 1916.8 | 11041.0 |
| 2019-01-24 | FBON | Futures | 130.88 | 131.63 | 130.88 | 131.62 | 536.0 |
| 2019-01-24 | FBTP | Futures | 111.87 | 112.71 | 111.82 | 112.61 | 107509.0 |
| 2019-01-24 | FBTS | Futures | 105.275 | 105.465 | 105.256 | 105.446 | 58051.0 |
| 2019-01-24 | FCE | Futures | 4341.6 | 4373.4 | 4325.0 | 4361.7 | 70867.0 |
| 2019-01-24 | FDAX | Futures | 11602.5 | 11725.4 | 11586.7 | 11686.5 | 109744.0 |
| 2019-01-24 | FDXM | Futures | 11574.2 | 11696.9 | 11558.5 | 11658.1 | 51428.0 |
| 2019-01-24 | FESX | Futures | 2649.2 | 2673.1 | 2647.5 | 2664.6 | 1032916.0 |
| 2019-01-24 | FGBL | Futures | 156.62 | 157.4 | 156.49 | 157.19 | 890974.0 |
| 2019-01-24 | FGBM | Futures | 132.22 | 132.42 | 132.17 | 132.39 | 611761.0 |
| 2019-01-24 | FGBS | Futures | 112.703 | 112.718 | 112.683 | 112.708 | 480325.0 |
| 2019-01-24 | FGBX | Futures | 185.62 | 188.1 | 185.46 | 187.43 | 42869.0 |
| 2019-01-24 | FMWO | Futures | 6657.8 | 6672.9 | 6642.6 | 6656.6 | 1724.0 |
| 2019-01-24 | FOAT | Futures | 142.31 | 143.05 | 142.31 | 142.93 | 159367.0 |
| 2019-01-24 | FTDX | Futures | 2590.0 | 2615.4 | 2583.6 | 2605.9 | 457.0 |
| 2019-01-24 | FTI | Futures | 478.73 | 482.14 | 477.6 | 480.63 | 23467.0 |
| 2019-01-24 | FTUK | Futures | 6179.3 | 6189.3 | 6139.6 | 6163.8 | 98050.0 |
| 2019-01-24 | FVSA | Futures | 322.63 | 326.38 | 312.32 | 317.0 | 19448.0 |
| 2019-01-24 | FXXP | Futures | 310.6 | 312.1 | 309.3 | 311.2 | 62602.0 |
| 2019-01-24 | G | Futures | 116.47 | 116.94 | 116.27 | 116.78 | 205057.0 |
| 2019-01-24 | GF | Futures | 314.142 | 316.274 | 313.923 | 315.618 | 4903.0 |
| 2019-01-24 | GSCI | Futures | 463.25 | 465.76 | 463.25 | 464.96 | 12.0 |
> showing 50 of 115 rows — these rows as CSV