PREVIEW / futures_daily / 2014-01-09
file: by_date/futures_daily/2014/2014-01-09.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-09 | ES | Futures | 1888.27 | 1895.74 | 1880.54 | 1889.56 | 1324605.0 |
| 2014-01-09 | NQ | Futures | 4095.76 | 4112.15 | 4064.44 | 4078.52 | 214724.0 |
| 2014-01-09 | YM | Futures | 16381.1 | 16444.0 | 16287.3 | 16365.1 | 132741.0 |
| 2014-01-09 | CL | Futures | 163.44 | 164.06 | 161.07 | 161.81 | 255784.0 |
| 2014-01-09 | GC | Futures | 1621.8 | 1629.8 | 1619.0 | 1627.8 | 123280.0 |
| 2014-01-09 | ZN | Futures | 112.745822 | 112.960439 | 112.645667 | 112.931824 | 1051953.0 |
| 2014-01-09 | A6 | Futures | 0.84339 | 0.84577 | 0.84119 | 0.84348 | 72467.0 |
| 2014-01-09 | AD | Futures | 0.93364 | 0.93455 | 0.92959 | 0.9304 | 63794.0 |
| 2014-01-09 | B | Futures | 108.78 | 109.68 | 107.63 | 107.9 | 180459.0 |
| 2014-01-09 | B6 | Futures | 1.7264 | 1.7323 | 1.7262 | 1.7295 | 82105.0 |
| 2014-01-09 | BFX | Futures | 3549.9 | 3549.9 | 3540.4 | 3540.4 | 31.0 |
| 2014-01-09 | BR | Futures | 0.21287 | 0.21381 | 0.21282 | 0.21334 | 148.0 |
| 2014-01-09 | BZ | Futures | 111.18 | 111.86 | 109.78 | 110.05 | 5041.0 |
| 2014-01-09 | C | Futures | 1822.0 | 1832.0 | 1810.0 | 1811.0 | 10034.0 |
| 2014-01-09 | CB | Futures | 82.924 | 83.685 | 82.924 | 83.586 | 6.0 |
| 2014-01-09 | CC | Futures | 2005.0 | 2019.0 | 1988.0 | 1992.0 | 11536.0 |
| 2014-01-09 | CNH | Futures | 6.9625 | 6.9645 | 6.9609 | 6.9645 | 10.0 |
| 2014-01-09 | CSC | Futures | 3.942 | 3.942 | 3.874 | 3.884 | 68.0 |
| 2014-01-09 | CT | Futures | 94.9 | 96.5 | 94.33 | 94.42 | 17594.0 |
| 2014-01-09 | DC | Futures | 30.37 | 30.37 | 29.84 | 29.93 | 404.0 |
| 2014-01-09 | DX | Futures | 77.232 | 77.341 | 77.013 | 77.156 | 28074.0 |
| 2014-01-09 | E1 | Futures | 1.40913 | 1.41722 | 1.40746 | 1.41375 | 36874.0 |
| 2014-01-09 | E6 | Futures | 1.60259 | 1.60932 | 1.59916 | 1.60424 | 242975.0 |
| 2014-01-09 | E7 | Futures | 1.5918 | 1.5988 | 1.5887 | 1.5938 | 6959.0 |
| 2014-01-09 | EBM | Futures | 276.7 | 277.39 | 273.22 | 273.91 | 36118.0 |
| 2014-01-09 | ED | Futures | 95.3566 | 95.3614 | 95.3566 | 95.3566 | 74545.0 |
| 2014-01-09 | ER | Futures | 97.837 | 97.857 | 97.832 | 97.847 | 99645.0 |
| 2014-01-09 | EW | Futures | 1365.3 | 1371.4 | 1358.4 | 1365.8 | 14141.0 |
| 2014-01-09 | FBTP | Futures | 83.32 | 83.71 | 83.0 | 83.25 | 56647.0 |
| 2014-01-09 | FBTS | Futures | 96.065 | 96.152 | 96.012 | 96.065 | 6.0 |
| 2014-01-09 | FCE | Futures | 3317.6 | 3335.1 | 3285.3 | 3295.4 | 115034.0 |
| 2014-01-09 | FDAX | Futures | 10526.7 | 10599.3 | 10435.8 | 10453.0 | 105481.0 |
| 2014-01-09 | FDIV | Futures | 143.85 | 144.83 | 142.92 | 142.92 | 25.0 |
| 2014-01-09 | FESX | Futures | 2181.6 | 2199.9 | 2163.3 | 2168.9 | 941093.0 |
| 2014-01-09 | FGBL | Futures | 118.75 | 118.99 | 118.5 | 118.76 | 749835.0 |
| 2014-01-09 | FGBM | Futures | 117.3 | 117.52 | 117.17 | 117.35 | 541469.0 |
| 2014-01-09 | FGBS | Futures | 110.313 | 110.378 | 110.298 | 110.353 | 384360.0 |
| 2014-01-09 | FGBX | Futures | 118.93 | 119.26 | 118.23 | 118.73 | 21181.0 |
| 2014-01-09 | FMWO | Futures | 5385.5 | 5394.4 | 5385.5 | 5394.4 | 50.0 |
| 2014-01-09 | FOAT | Futures | 107.95 | 107.98 | 107.51 | 107.65 | 91890.0 |
| 2014-01-09 | FTDX | Futures | 1123.0 | 1133.3 | 1123.0 | 1124.4 | 139.0 |
| 2014-01-09 | FTI | Futures | 346.64 | 347.97 | 344.53 | 345.43 | 25512.0 |
| 2014-01-09 | FTUK | Futures | 5048.0 | 5066.9 | 5013.5 | 5023.0 | 89625.0 |
| 2014-01-09 | FVSA | Futures | 1864.55 | 1896.79 | 1821.56 | 1891.42 | 4980.0 |
| 2014-01-09 | FXXP | Futures | 241.3 | 242.3 | 239.9 | 240.4 | 9864.0 |
| 2014-01-09 | G | Futures | 90.57 | 90.86 | 90.45 | 90.7 | 132959.0 |
| 2014-01-09 | GF | Futures | 272.03 | 272.715 | 271.266 | 272.312 | 1427.0 |
| 2014-01-09 | GSCI | Futures | 1012.94 | 1013.36 | 997.9 | 1001.62 | 2035.0 |
| 2014-01-09 | HE | Futures | 103.199 | 103.562 | 102.052 | 102.958 | 31267.0 |
| 2014-01-09 | HG | Futures | 4.2216 | 4.2393 | 4.1534 | 4.1667 | 56655.0 |
> showing 50 of 106 rows — these rows as CSV