PREVIEW / futures_daily / 2016-06-08
file: by_date/futures_daily/2016/2016-06-08.parquet size: 9 KB rows: 111
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-06-08 | ES | Futures | 2265.81 | 2276.01 | 2261.79 | 2274.13 | 1308451.0 |
| 2016-06-08 | NQ | Futures | 5302.22 | 5323.08 | 5292.23 | 5309.86 | 172285.0 |
| 2016-06-08 | YM | Futures | 18648.0 | 18728.0 | 18614.7 | 18710.3 | 101974.0 |
| 2016-06-08 | CL | Futures | 59.09 | 60.51 | 58.99 | 60.05 | 656416.0 |
| 2016-06-08 | GC | Futures | 1604.3 | 1630.3 | 1602.4 | 1624.0 | 181727.0 |
| 2016-06-08 | ZN | Futures | 126.43022 | 126.596219 | 126.369857 | 126.43022 | 793256.0 |
| 2016-06-08 | A6 | Futures | 0.75452 | 0.75715 | 0.75189 | 0.75664 | 104025.0 |
| 2016-06-08 | AD | Futures | 0.80181 | 0.80795 | 0.8012 | 0.80509 | 77405.0 |
| 2016-06-08 | ALI | Futures | 2119.72 | 2143.53 | 2119.72 | 2141.92 | 25.0 |
| 2016-06-08 | B | Futures | 41.67 | 42.8 | 41.6 | 42.56 | 260745.0 |
| 2016-06-08 | B6 | Futures | 1.5316 | 1.5376 | 1.5268 | 1.5272 | 149155.0 |
| 2016-06-08 | BFX | Futures | 4157.0 | 4164.1 | 4150.0 | 4164.1 | 4.0 |
| 2016-06-08 | BR | Futures | 0.19058 | 0.19315 | 0.19058 | 0.19271 | 298.0 |
| 2016-06-08 | BZ | Futures | 41.56 | 42.69 | 41.49 | 42.46 | 22382.0 |
| 2016-06-08 | C | Futures | 2366.0 | 2366.0 | 2346.0 | 2357.0 | 5229.0 |
| 2016-06-08 | CB | Futures | 263.453 | 264.01 | 263.453 | 263.951 | 8.0 |
| 2016-06-08 | CC | Futures | 2252.0 | 2279.0 | 2250.0 | 2267.0 | 19423.0 |
| 2016-06-08 | CNH | Futures | 7.1401 | 7.145 | 7.1338 | 7.1359 | 12.0 |
| 2016-06-08 | CSC | Futures | 3.407 | 3.494 | 3.407 | 3.466 | 86.0 |
| 2016-06-08 | CT | Futures | 74.92 | 75.64 | 74.51 | 74.82 | 28016.0 |
| 2016-06-08 | DC | Futures | 27.14 | 27.88 | 27.12 | 27.66 | 154.0 |
| 2016-06-08 | DX | Futures | 87.516 | 87.516 | 87.087 | 87.246 | 35801.0 |
| 2016-06-08 | E1 | Futures | 1.30158 | 1.31163 | 1.30107 | 1.31025 | 33433.0 |
| 2016-06-08 | E6 | Futures | 1.32467 | 1.33103 | 1.32444 | 1.3294 | 233598.0 |
| 2016-06-08 | E7 | Futures | 1.3178 | 1.3237 | 1.3173 | 1.3222 | 3637.0 |
| 2016-06-08 | EBM | Futures | 203.89 | 208.7 | 203.29 | 206.6 | 17101.0 |
| 2016-06-08 | ED | Futures | 95.7497 | 95.7521 | 95.7449 | 95.7497 | 119283.0 |
| 2016-06-08 | ER | Futures | 98.269 | 98.269 | 98.264 | 98.269 | 26768.0 |
| 2016-06-08 | EW | Futures | 1604.4 | 1613.3 | 1600.7 | 1611.3 | 21823.0 |
| 2016-06-08 | FBON | Futures | 119.76 | 120.27 | 119.72 | 120.07 | 421.0 |
| 2016-06-08 | FBTP | Futures | 107.49 | 107.94 | 107.46 | 107.75 | 103357.0 |
| 2016-06-08 | FBTS | Futures | 101.185 | 101.203 | 101.167 | 101.176 | 29358.0 |
| 2016-06-08 | FCE | Futures | 3835.7 | 3847.4 | 3813.4 | 3825.4 | 61464.0 |
| 2016-06-08 | FDAX | Futures | 11013.8 | 11033.1 | 10930.5 | 10962.2 | 80280.0 |
| 2016-06-08 | FDIV | Futures | 133.35 | 133.35 | 132.84 | 132.84 | 15.0 |
| 2016-06-08 | FDXM | Futures | 10606.4 | 10625.1 | 10526.8 | 10555.8 | 14249.0 |
| 2016-06-08 | FESX | Futures | 2360.3 | 2366.5 | 2343.9 | 2350.9 | 1154364.0 |
| 2016-06-08 | FGBL | Futures | 147.88 | 148.19 | 147.7 | 147.89 | 582027.0 |
| 2016-06-08 | FGBM | Futures | 127.94 | 128.01 | 127.87 | 127.94 | 458980.0 |
| 2016-06-08 | FGBS | Futures | 111.708 | 111.728 | 111.693 | 111.703 | 328040.0 |
| 2016-06-08 | FGBX | Futures | 178.43 | 179.6 | 178.3 | 179.06 | 45074.0 |
| 2016-06-08 | FMWO | Futures | 5773.3 | 5798.2 | 5773.3 | 5783.3 | 2716.0 |
| 2016-06-08 | FOAT | Futures | 135.31 | 135.5 | 135.1 | 135.26 | 97310.0 |
| 2016-06-08 | FTDX | Futures | 1612.8 | 1625.2 | 1604.2 | 1616.1 | 511.0 |
| 2016-06-08 | FTI | Futures | 404.43 | 405.42 | 403.13 | 404.34 | 18486.0 |
| 2016-06-08 | FTUK | Futures | 5158.3 | 5198.4 | 5157.1 | 5193.0 | 99372.0 |
| 2016-06-08 | FVSA | Futures | 2396.99 | 2452.84 | 2369.06 | 2438.88 | 10659.0 |
| 2016-06-08 | FXXP | Futures | 277.0 | 277.5 | 275.6 | 276.2 | 32285.0 |
| 2016-06-08 | G | Futures | 110.19 | 110.42 | 110.1 | 110.39 | 145900.0 |
| 2016-06-08 | GF | Futures | 290.389 | 294.882 | 285.547 | 294.283 | 5521.0 |
> showing 50 of 111 rows — these rows as CSV