PREVIEW / futures_daily / 2016-07-08
file: by_date/futures_daily/2016/2016-07-08.parquet size: 9 KB rows: 109
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-07-08 | ES | Futures | 2258.71 | 2294.88 | 2253.85 | 2289.48 | 1962358.0 |
| 2016-07-08 | NQ | Futures | 5247.44 | 5331.71 | 5233.29 | 5324.64 | 234625.0 |
| 2016-07-08 | YM | Futures | 18612.3 | 18883.8 | 18573.6 | 18841.0 | 166591.0 |
| 2016-07-08 | CL | Futures | 52.49 | 53.4 | 52.0 | 52.75 | 583078.0 |
| 2016-07-08 | GC | Futures | 1750.9 | 1764.8 | 1719.2 | 1747.6 | 301185.0 |
| 2016-07-08 | ZN | Futures | 129.116372 | 129.433278 | 128.497652 | 129.222007 | 1455703.0 |
| 2016-07-08 | A6 | Futures | 0.7592 | 0.76866 | 0.75819 | 0.76826 | 111712.0 |
| 2016-07-08 | AD | Futures | 0.78718 | 0.78789 | 0.78175 | 0.78452 | 64234.0 |
| 2016-07-08 | ALI | Futures | 2142.39 | 2163.02 | 2142.39 | 2163.02 | 9.0 |
| 2016-07-08 | B | Futures | 37.2 | 37.71 | 36.84 | 37.33 | 237284.0 |
| 2016-07-08 | B6 | Futures | 1.3624 | 1.3736 | 1.3591 | 1.3662 | 103414.0 |
| 2016-07-08 | BFX | Futures | 3825.0 | 3901.4 | 3825.0 | 3901.4 | 1.0 |
| 2016-07-08 | BR | Futures | 0.19677 | 0.19974 | 0.19637 | 0.1989 | 9.0 |
| 2016-07-08 | BZ | Futures | 37.06 | 37.57 | 36.71 | 37.19 | 24682.0 |
| 2016-07-08 | C | Futures | 2667.0 | 2677.0 | 2657.0 | 2663.0 | 2853.0 |
| 2016-07-08 | CB | Futures | 277.227 | 281.329 | 277.227 | 281.329 | 1.0 |
| 2016-07-08 | CC | Futures | 2285.0 | 2297.0 | 2266.0 | 2271.0 | 15343.0 |
| 2016-07-08 | CNH | Futures | 7.2635 | 7.2668 | 7.2635 | 7.2668 | 1.0 |
| 2016-07-08 | CSC | Futures | 3.646 | 3.65 | 3.574 | 3.585 | 35.0 |
| 2016-07-08 | CT | Futures | 73.46 | 75.56 | 73.46 | 74.67 | 19.0 |
| 2016-07-08 | DC | Futures | 29.41 | 29.41 | 28.73 | 28.89 | 135.0 |
| 2016-07-08 | DX | Futures | 89.583 | 89.96 | 89.081 | 89.59 | 29463.0 |
| 2016-07-08 | E1 | Futures | 1.28418 | 1.28781 | 1.27392 | 1.27867 | 20525.0 |
| 2016-07-08 | E6 | Futures | 1.29108 | 1.29801 | 1.28404 | 1.28963 | 174158.0 |
| 2016-07-08 | E7 | Futures | 1.2844 | 1.291 | 1.2772 | 1.2828 | 4361.0 |
| 2016-07-08 | EBM | Futures | 188.55 | 191.86 | 186.15 | 191.26 | 16323.0 |
| 2016-07-08 | ED | Futures | 95.81 | 95.8149 | 95.7907 | 95.8004 | 347099.0 |
| 2016-07-08 | ER | Futures | 98.337 | 98.337 | 98.328 | 98.332 | 27923.0 |
| 2016-07-08 | EW | Futures | 1579.3 | 1610.2 | 1577.2 | 1607.8 | 19449.0 |
| 2016-07-08 | FBON | Futures | 122.56 | 122.84 | 122.55 | 122.84 | 226.0 |
| 2016-07-08 | FBTP | Futures | 109.3 | 109.9 | 109.25 | 109.83 | 65604.0 |
| 2016-07-08 | FBTS | Futures | 101.275 | 101.293 | 101.257 | 101.293 | 12331.0 |
| 2016-07-08 | FCE | Futures | 3576.8 | 3668.3 | 3567.7 | 3651.3 | 91738.0 |
| 2016-07-08 | FDAX | Futures | 9984.3 | 10263.1 | 9956.6 | 10247.1 | 87904.0 |
| 2016-07-08 | FDXM | Futures | 9726.3 | 10003.2 | 9704.5 | 9988.2 | 22887.0 |
| 2016-07-08 | FESX | Futures | 2166.2 | 2230.4 | 2159.9 | 2217.8 | 1257081.0 |
| 2016-07-08 | FGBL | Futures | 150.92 | 151.22 | 150.59 | 150.98 | 485655.0 |
| 2016-07-08 | FGBM | Futures | 129.18 | 129.32 | 129.13 | 129.24 | 354330.0 |
| 2016-07-08 | FGBS | Futures | 111.987 | 112.027 | 111.977 | 112.007 | 134073.0 |
| 2016-07-08 | FGBX | Futures | 191.14 | 192.0 | 189.8 | 191.22 | 26195.0 |
| 2016-07-08 | FMWO | Futures | 5491.1 | 5550.7 | 5486.2 | 5547.0 | 510.0 |
| 2016-07-08 | FOAT | Futures | 138.7 | 139.03 | 138.56 | 138.89 | 92520.0 |
| 2016-07-08 | FTDX | Futures | 1531.5 | 1552.7 | 1531.5 | 1550.8 | 94.0 |
| 2016-07-08 | FTI | Futures | 382.39 | 391.25 | 381.4 | 390.35 | 27932.0 |
| 2016-07-08 | FTUK | Futures | 5406.7 | 5468.0 | 5390.0 | 5463.4 | 110777.0 |
| 2016-07-08 | FVSA | Futures | 2629.42 | 2644.59 | 2513.12 | 2538.4 | 11296.0 |
| 2016-07-08 | FXXP | Futures | 258.7 | 263.9 | 258.4 | 263.8 | 24008.0 |
| 2016-07-08 | G | Futures | 115.06 | 115.5 | 114.64 | 115.28 | 142433.0 |
| 2016-07-08 | GF | Futures | 285.697 | 288.542 | 283.65 | 286.445 | 4589.0 |
| 2016-07-08 | GSCI | Futures | 514.91 | 519.99 | 514.91 | 518.47 | 1605.0 |
> showing 50 of 109 rows — these rows as CSV