PREVIEW / futures_daily / 2016-10-14
file: by_date/futures_daily/2016/2016-10-14.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2016-10-14 | ES | Futures | 2299.74 | 2318.13 | 2295.42 | 2300.55 | 1841156.0 |
| 2016-10-14 | NQ | Futures | 5652.32 | 5705.35 | 5640.83 | 5662.04 | 237878.0 |
| 2016-10-14 | YM | Futures | 18918.7 | 19086.7 | 18888.2 | 18962.8 | 170631.0 |
| 2016-10-14 | CL | Futures | 55.62 | 56.21 | 54.89 | 55.38 | 353204.0 |
| 2016-10-14 | GC | Futures | 1616.0 | 1617.5 | 1599.8 | 1610.8 | 179881.0 |
| 2016-10-14 | ZN | Futures | 126.602877 | 126.678878 | 126.238071 | 126.329273 | 1219283.0 |
| 2016-10-14 | A6 | Futures | 0.77061 | 0.77918 | 0.76989 | 0.7754 | 116639.0 |
| 2016-10-14 | AD | Futures | 0.77668 | 0.78216 | 0.77509 | 0.78073 | 79851.0 |
| 2016-10-14 | ALI | Futures | 2235.08 | 2235.08 | 2205.2 | 2211.24 | 45.0 |
| 2016-10-14 | B | Futures | 40.29 | 40.67 | 39.86 | 40.2 | 248439.0 |
| 2016-10-14 | B6 | Futures | 1.2906 | 1.2925 | 1.2824 | 1.2841 | 125976.0 |
| 2016-10-14 | BR | Futures | 0.21239 | 0.21349 | 0.21174 | 0.21174 | 36.0 |
| 2016-10-14 | BZ | Futures | 40.09 | 40.44 | 39.63 | 39.97 | 22127.0 |
| 2016-10-14 | C | Futures | 2397.0 | 2433.0 | 2397.0 | 2419.0 | 19148.0 |
| 2016-10-14 | CB | Futures | 224.77 | 226.289 | 224.739 | 226.289 | 26.0 |
| 2016-10-14 | CC | Futures | 1997.0 | 2025.0 | 1992.0 | 2010.0 | 29797.0 |
| 2016-10-14 | CNH | Futures | 7.272 | 7.2727 | 7.2659 | 7.2684 | 16.0 |
| 2016-10-14 | CSC | Futures | 3.677 | 3.718 | 3.672 | 3.707 | 25.0 |
| 2016-10-14 | CT | Futures | 77.97 | 79.25 | 77.65 | 79.06 | 16462.0 |
| 2016-10-14 | DC | Futures | 28.9 | 29.15 | 28.63 | 28.94 | 147.0 |
| 2016-10-14 | DX | Futures | 90.866 | 91.304 | 90.764 | 91.208 | 26259.0 |
| 2016-10-14 | E1 | Futures | 1.26699 | 1.26811 | 1.26188 | 1.263 | 21411.0 |
| 2016-10-14 | E6 | Futures | 1.28466 | 1.28518 | 1.27492 | 1.27626 | 168037.0 |
| 2016-10-14 | E7 | Futures | 1.2776 | 1.278 | 1.2679 | 1.2694 | 2813.0 |
| 2016-10-14 | EBM | Futures | 190.64 | 193.0 | 190.64 | 192.7 | 32667.0 |
| 2016-10-14 | ED | Futures | 95.6297 | 95.649 | 95.6249 | 95.6393 | 259644.0 |
| 2016-10-14 | ER | Futures | 98.274 | 98.279 | 98.274 | 98.279 | 30361.0 |
| 2016-10-14 | EW | Futures | 1612.3 | 1628.2 | 1611.1 | 1613.6 | 14164.0 |
| 2016-10-14 | FBON | Futures | 124.01 | 124.18 | 123.96 | 124.09 | 403.0 |
| 2016-10-14 | FBTP | Futures | 108.42 | 108.58 | 108.32 | 108.48 | 75749.0 |
| 2016-10-14 | FBTS | Futures | 101.239 | 101.248 | 101.221 | 101.239 | 8175.0 |
| 2016-10-14 | FCE | Futures | 3944.0 | 4002.3 | 3931.5 | 3979.1 | 10036.0 |
| 2016-10-14 | FDAX | Futures | 11053.6 | 11212.1 | 11024.5 | 11177.2 | 101373.0 |
| 2016-10-14 | FDXM | Futures | 11024.4 | 11186.8 | 11001.2 | 11153.1 | 29773.0 |
| 2016-10-14 | FESX | Futures | 2390.1 | 2426.2 | 2381.3 | 2415.0 | 1067625.0 |
| 2016-10-14 | FEU3 | Futures | 98.956 | 98.956 | 98.956 | 98.956 | 5.0 |
| 2016-10-14 | FGBL | Futures | 149.37 | 149.46 | 149.01 | 149.25 | 619879.0 |
| 2016-10-14 | FGBM | Futures | 128.76 | 128.8 | 128.68 | 128.75 | 352320.0 |
| 2016-10-14 | FGBS | Futures | 111.922 | 111.932 | 111.902 | 111.922 | 137046.0 |
| 2016-10-14 | FGBX | Futures | 181.21 | 181.49 | 179.21 | 180.23 | 43970.0 |
| 2016-10-14 | FMWO | Futures | 5682.0 | 5689.2 | 5665.0 | 5665.0 | 31.0 |
| 2016-10-14 | FOAT | Futures | 137.07 | 137.21 | 136.95 | 137.08 | 103337.0 |
| 2016-10-14 | FTDX | Futures | 1733.2 | 1745.5 | 1730.8 | 1740.1 | 137.0 |
| 2016-10-14 | FTI | Futures | 409.57 | 415.04 | 409.25 | 412.47 | 73.0 |
| 2016-10-14 | FTUK | Futures | 5874.4 | 5925.5 | 5863.8 | 5888.7 | 99418.0 |
| 2016-10-14 | FVSA | Futures | 1480.99 | 1480.99 | 1443.89 | 1453.16 | 20975.0 |
| 2016-10-14 | FXXP | Futures | 277.4 | 280.8 | 276.9 | 279.5 | 22729.0 |
| 2016-10-14 | G | Futures | 113.44 | 113.47 | 112.41 | 112.87 | 317737.0 |
| 2016-10-14 | GF | Futures | 247.071 | 251.796 | 246.588 | 248.36 | 4621.0 |
| 2016-10-14 | GSCI | Futures | 522.16 | 522.51 | 519.95 | 520.85 | 570.0 |
> showing 50 of 108 rows — these rows as CSV