PREVIEW / futures_daily / 2019-01-07
file: by_date/futures_daily/2019/2019-01-07.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-07 | ES | Futures | 2747.0 | 2779.75 | 2731.85 | 2761.35 | 1632131.0 |
| 2019-01-07 | NQ | Futures | 7468.96 | 7566.79 | 7412.52 | 7521.35 | 516597.0 |
| 2019-01-07 | YM | Futures | 24755.5 | 24964.3 | 24554.0 | 24799.8 | 238574.0 |
| 2019-01-07 | CL | Futures | 50.66 | 52.22 | 50.46 | 50.89 | 819939.0 |
| 2019-01-07 | GC | Futures | 1621.6 | 1634.2 | 1618.0 | 1625.3 | 204679.0 |
| 2019-01-07 | ZN | Futures | 121.689342 | 121.969445 | 121.409239 | 121.54929 | 1335862.0 |
| 2019-01-07 | A6 | Futures | 0.73446 | 0.73744 | 0.73373 | 0.73662 | 89112.0 |
| 2019-01-07 | AD | Futures | 0.75767 | 0.76369 | 0.75762 | 0.76263 | 71448.0 |
| 2019-01-07 | B | Futures | 41.45 | 42.54 | 41.34 | 41.39 | 296583.0 |
| 2019-01-07 | B6 | Futures | 1.3122 | 1.3176 | 1.3106 | 1.3158 | 69943.0 |
| 2019-01-07 | BR | Futures | 0.21421 | 0.2148 | 0.21265 | 0.21325 | 108.0 |
| 2019-01-07 | BTC | Futures | 5833.2 | 5950.1 | 5767.4 | 5825.9 | 2757.0 |
| 2019-01-07 | BZ | Futures | 41.07 | 42.18 | 41.01 | 41.04 | 41677.0 |
| 2019-01-07 | C | Futures | 1510.0 | 1531.0 | 1504.0 | 1529.0 | 8861.0 |
| 2019-01-07 | CB | Futures | 275.387 | 275.69 | 273.048 | 273.352 | 56.0 |
| 2019-01-07 | CC | Futures | 1627.0 | 1662.0 | 1623.0 | 1660.0 | 16914.0 |
| 2019-01-07 | CNH | Futures | 6.8771 | 6.8791 | 6.8606 | 6.8606 | 697.0 |
| 2019-01-07 | CSC | Futures | 2.834 | 2.834 | 2.799 | 2.804 | 138.0 |
| 2019-01-07 | CT | Futures | 79.0 | 80.52 | 78.95 | 79.25 | 14287.0 |
| 2019-01-07 | DC | Futures | 24.21 | 24.31 | 23.99 | 24.02 | 229.0 |
| 2019-01-07 | DX | Futures | 91.274 | 91.298 | 90.787 | 90.819 | 23360.0 |
| 2019-01-07 | E1 | Futures | 1.19994 | 1.20923 | 1.19923 | 1.20829 | 31070.0 |
| 2019-01-07 | E6 | Futures | 1.2679 | 1.27624 | 1.26746 | 1.2758 | 186803.0 |
| 2019-01-07 | E7 | Futures | 1.2617 | 1.2701 | 1.2615 | 1.2696 | 2814.0 |
| 2019-01-07 | EBM | Futures | 212.57 | 212.83 | 210.77 | 211.03 | 14806.0 |
| 2019-01-07 | ED | Futures | 94.9939 | 95.0232 | 94.9939 | 95.0086 | 317885.0 |
| 2019-01-07 | ER | Futures | 98.396 | 98.401 | 98.396 | 98.396 | 31283.0 |
| 2019-01-07 | EW | Futures | 1799.5 | 1828.3 | 1788.0 | 1813.7 | 15709.0 |
| 2019-01-07 | FBON | Futures | 129.19 | 129.25 | 128.88 | 128.91 | 373.0 |
| 2019-01-07 | FBTP | Futures | 110.62 | 110.84 | 110.17 | 110.46 | 47866.0 |
| 2019-01-07 | FBTS | Futures | 104.717 | 104.793 | 104.566 | 104.66 | 40831.0 |
| 2019-01-07 | FCE | Futures | 4220.4 | 4227.1 | 4161.4 | 4188.0 | 76939.0 |
| 2019-01-07 | FDAX | Futures | 11399.1 | 11443.8 | 11215.8 | 11272.5 | 96908.0 |
| 2019-01-07 | FDIV | Futures | 131.63 | 132.17 | 131.63 | 132.17 | 1.0 |
| 2019-01-07 | FDXM | Futures | 11360.4 | 11415.9 | 11187.4 | 11245.0 | 41467.0 |
| 2019-01-07 | FESX | Futures | 2603.0 | 2614.1 | 2565.4 | 2578.2 | 923192.0 |
| 2019-01-07 | FGBL | Futures | 155.87 | 156.24 | 155.7 | 155.89 | 541453.0 |
| 2019-01-07 | FGBM | Futures | 132.01 | 132.18 | 131.97 | 132.03 | 353208.0 |
| 2019-01-07 | FGBS | Futures | 112.713 | 112.739 | 112.693 | 112.703 | 219149.0 |
| 2019-01-07 | FGBX | Futures | 183.84 | 184.71 | 183.72 | 184.1 | 31880.0 |
| 2019-01-07 | FMWO | Futures | 6441.0 | 6480.6 | 6396.7 | 6449.2 | 2318.0 |
| 2019-01-07 | FOAT | Futures | 141.52 | 141.58 | 141.19 | 141.25 | 109535.0 |
| 2019-01-07 | FTDX | Futures | 2472.8 | 2514.5 | 2465.8 | 2493.6 | 439.0 |
| 2019-01-07 | FTI | Futures | 461.96 | 463.22 | 457.37 | 460.04 | 22308.0 |
| 2019-01-07 | FTUK | Futures | 6185.6 | 6204.3 | 6115.0 | 6142.4 | 90794.0 |
| 2019-01-07 | FVSA | Futures | 413.35 | 429.6 | 404.21 | 409.29 | 20987.0 |
| 2019-01-07 | FXXP | Futures | 300.5 | 301.3 | 298.2 | 299.1 | 61430.0 |
| 2019-01-07 | G | Futures | 116.94 | 117.24 | 116.75 | 117.02 | 151225.0 |
| 2019-01-07 | GF | Futures | 311.266 | 314.979 | 310.405 | 314.28 | 2186.0 |
| 2019-01-07 | GSCI | Futures | 444.38 | 448.65 | 443.92 | 444.03 | 36.0 |
> showing 50 of 115 rows — these rows as CSV