PREVIEW / futures_daily / 2016-08-11
file: by_date/futures_daily/2016/2016-08-11.parquet size: 9 KB rows: 107
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-08-11 | ES | Futures | 2345.63 | 2359.39 | 2342.93 | 2355.62 | 1326004.0 |
| 2016-08-11 | NQ | Futures | 5637.01 | 5670.9 | 5629.35 | 5657.93 | 147601.0 |
| 2016-08-11 | YM | Futures | 19271.4 | 19421.8 | 19253.6 | 19391.5 | 111156.0 |
| 2016-08-11 | CL | Futures | 47.02 | 49.71 | 46.59 | 49.3 | 682235.0 |
| 2016-08-11 | GC | Futures | 1736.2 | 1744.1 | 1721.0 | 1732.1 | 155585.0 |
| 2016-08-11 | ZN | Futures | 128.165656 | 128.241109 | 127.486572 | 127.531844 | 1001879.0 |
| 2016-08-11 | A6 | Futures | 0.78362 | 0.78515 | 0.78169 | 0.78311 | 70819.0 |
| 2016-08-11 | AD | Futures | 0.78462 | 0.78999 | 0.78262 | 0.78922 | 63814.0 |
| 2016-08-11 | ALI | Futures | 2164.25 | 2165.52 | 2162.02 | 2163.93 | 18.0 |
| 2016-08-11 | B | Futures | 34.6 | 36.6 | 34.35 | 36.39 | 335527.0 |
| 2016-08-11 | B6 | Futures | 1.3724 | 1.3743 | 1.3645 | 1.368 | 65310.0 |
| 2016-08-11 | BR | Futures | 0.21128 | 0.21128 | 0.20975 | 0.21105 | 458.0 |
| 2016-08-11 | BZ | Futures | 34.48 | 36.42 | 34.18 | 36.21 | 29698.0 |
| 2016-08-11 | C | Futures | 2584.0 | 2584.0 | 2555.0 | 2569.0 | 5407.0 |
| 2016-08-11 | CB | Futures | 266.091 | 268.435 | 266.091 | 268.435 | 8.0 |
| 2016-08-11 | CC | Futures | 2215.0 | 2223.0 | 2200.0 | 2214.0 | 15519.0 |
| 2016-08-11 | CNH | Futures | 7.1886 | 7.1928 | 7.1886 | 7.1928 | 2.0 |
| 2016-08-11 | CSC | Futures | 3.866 | 3.866 | 3.826 | 3.832 | 5.0 |
| 2016-08-11 | CT | Futures | 80.61 | 81.3 | 80.14 | 80.73 | 56.0 |
| 2016-08-11 | DC | Futures | 30.96 | 31.08 | 30.6 | 30.76 | 197.0 |
| 2016-08-11 | DX | Futures | 88.848 | 89.202 | 88.783 | 89.135 | 9065.0 |
| 2016-08-11 | E1 | Futures | 1.28719 | 1.29182 | 1.28456 | 1.28731 | 10234.0 |
| 2016-08-11 | E6 | Futures | 1.30371 | 1.30488 | 1.29818 | 1.29912 | 103011.0 |
| 2016-08-11 | E7 | Futures | 1.2969 | 1.298 | 1.2914 | 1.2922 | 1453.0 |
| 2016-08-11 | EBM | Futures | 199.68 | 202.08 | 198.78 | 201.78 | 8980.0 |
| 2016-08-11 | ED | Futures | 95.6316 | 95.6557 | 95.6219 | 95.6219 | 324701.0 |
| 2016-08-11 | ER | Futures | 98.313 | 98.313 | 98.308 | 98.313 | 31074.0 |
| 2016-08-11 | EW | Futures | 1647.2 | 1655.5 | 1644.0 | 1651.6 | 14390.0 |
| 2016-08-11 | FBON | Futures | 124.69 | 124.98 | 124.69 | 124.91 | 24.0 |
| 2016-08-11 | FBTP | Futures | 111.02 | 111.26 | 110.87 | 111.17 | 61500.0 |
| 2016-08-11 | FBTS | Futures | 101.365 | 101.365 | 101.338 | 101.365 | 12974.0 |
| 2016-08-11 | FCE | Futures | 3890.4 | 3934.9 | 3880.8 | 3931.4 | 70296.0 |
| 2016-08-11 | FDAX | Futures | 11360.7 | 11433.1 | 11310.7 | 11408.1 | 85880.0 |
| 2016-08-11 | FDXM | Futures | 11073.7 | 11141.1 | 11026.0 | 11119.8 | 25020.0 |
| 2016-08-11 | FESX | Futures | 2368.2 | 2388.6 | 2359.6 | 2383.9 | 816427.0 |
| 2016-08-11 | FGBL | Futures | 151.05 | 151.19 | 150.55 | 150.86 | 381893.0 |
| 2016-08-11 | FGBM | Futures | 129.1 | 129.15 | 128.89 | 129.02 | 266363.0 |
| 2016-08-11 | FGBS | Futures | 111.917 | 111.927 | 111.872 | 111.897 | 113913.0 |
| 2016-08-11 | FGBX | Futures | 190.6 | 190.79 | 188.61 | 189.45 | 19509.0 |
| 2016-08-11 | FMWO | Futures | 5774.4 | 5807.2 | 5774.4 | 5804.8 | 64.0 |
| 2016-08-11 | FOAT | Futures | 139.1 | 139.15 | 138.74 | 138.85 | 58113.0 |
| 2016-08-11 | FTDX | Futures | 1676.6 | 1680.9 | 1669.8 | 1679.9 | 248.0 |
| 2016-08-11 | FTI | Futures | 406.63 | 410.38 | 405.28 | 410.33 | 123.0 |
| 2016-08-11 | FTUK | Futures | 5679.5 | 5763.8 | 5672.8 | 5747.5 | 102362.0 |
| 2016-08-11 | FVSA | Futures | 1932.65 | 1971.69 | 1898.48 | 1908.24 | 17264.0 |
| 2016-08-11 | FXXP | Futures | 278.1 | 280.6 | 277.3 | 279.8 | 15945.0 |
| 2016-08-11 | G | Futures | 117.47 | 117.58 | 117.15 | 117.37 | 152530.0 |
| 2016-08-11 | GF | Futures | 298.717 | 299.774 | 292.077 | 295.749 | 5119.0 |
| 2016-08-11 | GSCI | Futures | 491.64 | 494.91 | 491.64 | 494.91 | 2190.0 |
| 2016-08-11 | HE | Futures | 82.183 | 85.02 | 80.627 | 80.834 | 24925.0 |
> showing 50 of 107 rows — these rows as CSV