PREVIEW / futures_daily / 2016-01-28
file: by_date/futures_daily/2016/2016-01-28.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 |
|---|---|---|---|---|---|---|---|
| 2016-01-28 | ES | Futures | 2008.1 | 2032.13 | 1992.88 | 2008.9 | 2254109.0 |
| 2016-01-28 | NQ | Futures | 4865.37 | 4922.52 | 4814.37 | 4869.47 | 414082.0 |
| 2016-01-28 | YM | Futures | 16413.0 | 16613.7 | 16316.7 | 16527.8 | 268654.0 |
| 2016-01-28 | CL | Futures | 46.37 | 50.16 | 45.72 | 47.85 | 833378.0 |
| 2016-01-28 | GC | Futures | 1447.1 | 1447.3 | 1426.5 | 1434.1 | 151218.0 |
| 2016-01-28 | ZN | Futures | 124.062907 | 124.273489 | 123.731992 | 124.213322 | 1641268.0 |
| 2016-01-28 | A6 | Futures | 0.7026 | 0.71292 | 0.70079 | 0.70771 | 102034.0 |
| 2016-01-28 | AD | Futures | 0.72544 | 0.7331 | 0.724 | 0.72779 | 112720.0 |
| 2016-01-28 | ALI | Futures | 2107.79 | 2107.79 | 2107.79 | 2107.79 | 0.0 |
| 2016-01-28 | B | Futures | 28.23 | 30.9 | 28.06 | 29.24 | 533487.0 |
| 2016-01-28 | B6 | Futures | 1.4986 | 1.516 | 1.4982 | 1.5113 | 109197.0 |
| 2016-01-28 | BFX | Futures | 4107.7 | 4107.7 | 4098.7 | 4099.3 | 2.0 |
| 2016-01-28 | BR | Futures | 0.15274 | 0.15403 | 0.15026 | 0.15296 | 1336.0 |
| 2016-01-28 | BZ | Futures | 27.99 | 30.65 | 27.85 | 29.02 | 63830.0 |
| 2016-01-28 | C | Futures | 2104.0 | 2144.0 | 2076.0 | 2118.0 | 9310.0 |
| 2016-01-28 | CB | Futures | 281.439 | 281.439 | 277.697 | 277.697 | 8.0 |
| 2016-01-28 | CC | Futures | 2019.0 | 2081.0 | 2014.0 | 2058.0 | 23550.0 |
| 2016-01-28 | CNH | Futures | 7.2984 | 7.2984 | 7.2905 | 7.2905 | 11.0 |
| 2016-01-28 | CSC | Futures | 3.731 | 3.736 | 3.718 | 3.728 | 43.0 |
| 2016-01-28 | CT | Futures | 71.29 | 72.06 | 71.07 | 71.88 | 18582.0 |
| 2016-01-28 | DC | Futures | 29.59 | 29.7 | 29.51 | 29.57 | 78.0 |
| 2016-01-28 | DX | Futures | 92.485 | 92.621 | 91.967 | 92.05 | 34544.0 |
| 2016-01-28 | E1 | Futures | 1.2467 | 1.25466 | 1.24254 | 1.24796 | 22175.0 |
| 2016-01-28 | E6 | Futures | 1.27625 | 1.28391 | 1.27233 | 1.28239 | 193550.0 |
| 2016-01-28 | E7 | Futures | 1.2686 | 1.2766 | 1.2652 | 1.2752 | 5305.0 |
| 2016-01-28 | EBM | Futures | 232.36 | 234.12 | 231.65 | 232.36 | 20223.0 |
| 2016-01-28 | ED | Futures | 95.6313 | 95.6458 | 95.6265 | 95.6458 | 220935.0 |
| 2016-01-28 | ER | Futures | 98.283 | 98.288 | 98.269 | 98.274 | 96355.0 |
| 2016-01-28 | EW | Futures | 1345.0 | 1358.8 | 1335.5 | 1338.8 | 20531.0 |
| 2016-01-28 | FBON | Futures | 116.85 | 117.24 | 116.72 | 116.91 | 543.0 |
| 2016-01-28 | FBTP | Futures | 105.91 | 106.07 | 105.51 | 105.81 | 126623.0 |
| 2016-01-28 | FBTS | Futures | 100.926 | 100.953 | 100.882 | 100.891 | 26491.0 |
| 2016-01-28 | FCE | Futures | 3635.3 | 3694.1 | 3591.2 | 3624.8 | 134660.0 |
| 2016-01-28 | FDAX | Futures | 10614.9 | 10738.0 | 10394.8 | 10435.4 | 132775.0 |
| 2016-01-28 | FDXM | Futures | 10149.4 | 10274.9 | 9938.9 | 9977.3 | 27518.0 |
| 2016-01-28 | FESX | Futures | 2288.7 | 2321.3 | 2243.8 | 2261.3 | 1676375.0 |
| 2016-01-28 | FEU3 | Futures | 98.937 | 98.937 | 98.932 | 98.932 | 32.0 |
| 2016-01-28 | FGBL | Futures | 142.89 | 143.42 | 142.72 | 143.11 | 810748.0 |
| 2016-01-28 | FGBM | Futures | 126.78 | 126.9 | 126.72 | 126.82 | 432489.0 |
| 2016-01-28 | FGBS | Futures | 111.658 | 111.673 | 111.648 | 111.658 | 174937.0 |
| 2016-01-28 | FGBX | Futures | 164.4 | 165.73 | 163.86 | 164.97 | 38198.0 |
| 2016-01-28 | FMWO | Futures | 5173.3 | 5175.8 | 5155.9 | 5162.1 | 252.0 |
| 2016-01-28 | FOAT | Futures | 130.32 | 130.61 | 130.16 | 130.35 | 117405.0 |
| 2016-01-28 | FTDX | Futures | 1615.3 | 1625.9 | 1574.1 | 1576.5 | 276.0 |
| 2016-01-28 | FTI | Futures | 370.62 | 376.59 | 367.3 | 370.22 | 47726.0 |
| 2016-01-28 | FTUK | Futures | 4788.7 | 4868.7 | 4759.4 | 4794.9 | 159499.0 |
| 2016-01-28 | FVSA | Futures | 2793.13 | 2952.74 | 2748.24 | 2892.89 | 19023.0 |
| 2016-01-28 | FXXP | Futures | 264.5 | 267.8 | 260.9 | 262.3 | 42283.0 |
| 2016-01-28 | G | Futures | 106.33 | 106.6 | 106.02 | 106.33 | 223770.0 |
| 2016-01-28 | GF | Futures | 312.839 | 315.097 | 311.906 | 313.035 | 3496.0 |
> showing 50 of 110 rows — these rows as CSV