PREVIEW / futures_daily / 2017-04-03
file: by_date/futures_daily/2017/2017-04-03.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-03 | ES | Futures | 2560.35 | 2566.59 | 2541.34 | 2558.72 | 1716027.0 |
| 2017-04-03 | NQ | Futures | 6403.35 | 6424.84 | 6363.89 | 6400.7 | 264740.0 |
| 2017-04-03 | YM | Futures | 21735.4 | 21787.1 | 21579.2 | 21725.9 | 151669.0 |
| 2017-04-03 | CL | Futures | 53.13 | 53.27 | 52.53 | 52.66 | 440724.0 |
| 2017-04-03 | GC | Futures | 1600.9 | 1606.1 | 1593.9 | 1603.6 | 142196.0 |
| 2017-04-03 | ZN | Futures | 122.507031 | 123.136927 | 122.414851 | 122.937204 | 1559814.0 |
| 2017-04-03 | A6 | Futures | 0.78266 | 0.78327 | 0.77814 | 0.77907 | 74045.0 |
| 2017-04-03 | AD | Futures | 0.76696 | 0.76706 | 0.76181 | 0.76263 | 66707.0 |
| 2017-04-03 | ALI | Futures | 2595.27 | 2595.27 | 2595.27 | 2595.27 | 0.0 |
| 2017-04-03 | B | Futures | 38.89 | 38.97 | 38.46 | 38.52 | 241746.0 |
| 2017-04-03 | B6 | Futures | 1.3167 | 1.3187 | 1.3092 | 1.3101 | 91611.0 |
| 2017-04-03 | BFX | Futures | 4623.1 | 4623.1 | 4603.7 | 4603.7 | 1.0 |
| 2017-04-03 | BR | Futures | 0.22843 | 0.23013 | 0.22843 | 0.22959 | 53.0 |
| 2017-04-03 | BZ | Futures | 38.79 | 38.85 | 38.36 | 38.42 | 18746.0 |
| 2017-04-03 | C | Futures | 1739.0 | 1755.0 | 1712.0 | 1752.0 | 6879.0 |
| 2017-04-03 | CB | Futures | 265.476 | 267.306 | 265.476 | 267.306 | 7.0 |
| 2017-04-03 | CC | Futures | 1597.0 | 1612.0 | 1573.0 | 1609.0 | 20917.0 |
| 2017-04-03 | CNH | Futures | 7.2055 | 7.2055 | 7.1998 | 7.2018 | 3.0 |
| 2017-04-03 | CSC | Futures | 3.625 | 3.647 | 3.601 | 3.632 | 97.0 |
| 2017-04-03 | CT | Futures | 86.17 | 87.02 | 84.09 | 84.12 | 33266.0 |
| 2017-04-03 | DC | Futures | 29.87 | 30.18 | 29.64 | 30.09 | 87.0 |
| 2017-04-03 | DX | Futures | 93.544 | 93.688 | 93.385 | 93.55 | 19237.0 |
| 2017-04-03 | E1 | Futures | 1.23773 | 1.24008 | 1.2365 | 1.23897 | 17593.0 |
| 2017-04-03 | E6 | Futures | 1.23232 | 1.23469 | 1.23019 | 1.23302 | 146787.0 |
| 2017-04-03 | E7 | Futures | 1.2259 | 1.2284 | 1.2241 | 1.2268 | 2003.0 |
| 2017-04-03 | EBM | Futures | 185.1 | 185.94 | 184.54 | 184.82 | 19746.0 |
| 2017-04-03 | ED | Futures | 95.5591 | 95.5688 | 95.5446 | 95.5591 | 239459.0 |
| 2017-04-03 | ER | Futures | 98.328 | 98.328 | 98.323 | 98.328 | 53471.0 |
| 2017-04-03 | EW | Futures | 1827.2 | 1832.2 | 1807.3 | 1816.2 | 19265.0 |
| 2017-04-03 | FBON | Futures | 122.02 | 122.12 | 121.68 | 121.98 | 572.0 |
| 2017-04-03 | FBTP | Futures | 105.0 | 105.0 | 104.44 | 104.67 | 82566.0 |
| 2017-04-03 | FBTS | Futures | 101.764 | 101.836 | 101.737 | 101.8 | 25627.0 |
| 2017-04-03 | FCE | Futures | 4514.9 | 4528.1 | 4464.1 | 4482.7 | 105424.0 |
| 2017-04-03 | FDAX | Futures | 13051.7 | 13102.9 | 12915.5 | 12982.0 | 86380.0 |
| 2017-04-03 | FDXM | Futures | 12933.9 | 12989.4 | 12802.1 | 12868.0 | 24442.0 |
| 2017-04-03 | FESX | Futures | 2801.4 | 2808.7 | 2765.5 | 2780.2 | 1087828.0 |
| 2017-04-03 | FEU3 | Futures | 99.001 | 99.001 | 99.001 | 99.001 | 4.0 |
| 2017-04-03 | FGBL | Futures | 148.33 | 149.05 | 148.28 | 148.97 | 620592.0 |
| 2017-04-03 | FGBM | Futures | 129.36 | 129.74 | 129.34 | 129.68 | 424266.0 |
| 2017-04-03 | FGBS | Futures | 112.327 | 112.472 | 112.322 | 112.457 | 376831.0 |
| 2017-04-03 | FGBX | Futures | 168.37 | 169.87 | 168.15 | 169.55 | 43107.0 |
| 2017-04-03 | FMWO | Futures | 6226.6 | 6226.6 | 6184.4 | 6190.5 | 1941.0 |
| 2017-04-03 | FOAT | Futures | 131.62 | 131.94 | 131.42 | 131.76 | 99022.0 |
| 2017-04-03 | FTDX | Futures | 2013.6 | 2016.1 | 1985.2 | 1996.0 | 105.0 |
| 2017-04-03 | FTI | Futures | 468.7 | 470.52 | 464.11 | 465.84 | 31684.0 |
| 2017-04-03 | FTUK | Futures | 6220.6 | 6231.7 | 6153.8 | 6181.2 | 90059.0 |
| 2017-04-03 | FVSA | Futures | 636.39 | 655.81 | 630.85 | 651.65 | 23862.0 |
| 2017-04-03 | FXXP | Futures | 317.6 | 318.4 | 313.9 | 315.4 | 39566.0 |
| 2017-04-03 | G | Futures | 115.07 | 115.8 | 114.9 | 115.74 | 177865.0 |
| 2017-04-03 | GF | Futures | 308.749 | 310.075 | 305.75 | 306.904 | 1362.0 |
> showing 50 of 110 rows — these rows as CSV