PREVIEW / futures_daily / 2014-05-06
file: by_date/futures_daily/2014/2014-05-06.parquet size: 9 KB rows: 103
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-05-06 | ES | Futures | 1942.53 | 1946.67 | 1926.24 | 1928.82 | 1379161.0 |
| 2014-05-06 | NQ | Futures | 4138.22 | 4148.29 | 4082.68 | 4087.57 | 260995.0 |
| 2014-05-06 | YM | Futures | 16529.5 | 16556.6 | 16400.0 | 16427.1 | 129235.0 |
| 2014-05-06 | CL | Futures | 180.0 | 181.89 | 179.9 | 180.22 | 251208.0 |
| 2014-05-06 | GC | Futures | 1725.7 | 1731.7 | 1718.7 | 1724.2 | 103408.0 |
| 2014-05-06 | ZN | Futures | 115.50421 | 115.620105 | 115.373827 | 115.562157 | 966666.0 |
| 2014-05-06 | A6 | Futures | 0.88876 | 0.8976 | 0.88818 | 0.89645 | 84400.0 |
| 2014-05-06 | AD | Futures | 0.92465 | 0.93164 | 0.92414 | 0.93093 | 57188.0 |
| 2014-05-06 | ALI | Futures | 2477.91 | 2803.26 | 2332.08 | 2761.32 | 41.0 |
| 2014-05-06 | B | Futures | 110.67 | 111.37 | 110.14 | 110.24 | 131496.0 |
| 2014-05-06 | B6 | Futures | 1.7721 | 1.7859 | 1.7721 | 1.7846 | 97888.0 |
| 2014-05-06 | BR | Futures | 0.23313 | 0.23502 | 0.23313 | 0.23481 | 161.0 |
| 2014-05-06 | BZ | Futures | 113.01 | 113.56 | 112.35 | 112.43 | 9086.0 |
| 2014-05-06 | C | Futures | 1898.0 | 1898.0 | 1879.0 | 1889.0 | 7601.0 |
| 2014-05-06 | CB | Futures | 105.397 | 106.615 | 105.397 | 106.615 | 51.0 |
| 2014-05-06 | CC | Futures | 2161.0 | 2162.0 | 2149.0 | 2153.0 | 6858.0 |
| 2014-05-06 | CNH | Futures | 7.142 | 7.142 | 7.1387 | 7.1387 | 1.0 |
| 2014-05-06 | CSC | Futures | 4.596 | 4.596 | 4.522 | 4.522 | 33.0 |
| 2014-05-06 | CT | Futures | 106.68 | 106.68 | 105.59 | 105.82 | 7780.0 |
| 2014-05-06 | DC | Futures | 37.3 | 37.3 | 36.46 | 36.53 | 265.0 |
| 2014-05-06 | DX | Futures | 75.575 | 75.589 | 75.138 | 75.172 | 27535.0 |
| 2014-05-06 | E1 | Futures | 1.46279 | 1.47216 | 1.46215 | 1.46934 | 33275.0 |
| 2014-05-06 | E6 | Futures | 1.63788 | 1.64685 | 1.63753 | 1.64473 | 167873.0 |
| 2014-05-06 | E7 | Futures | 1.627 | 1.6359 | 1.6267 | 1.6338 | 3259.0 |
| 2014-05-06 | ED | Futures | 95.4138 | 95.4186 | 95.4138 | 95.4138 | 28974.0 |
| 2014-05-06 | ER | Futures | 97.842 | 97.847 | 97.837 | 97.842 | 66011.0 |
| 2014-05-06 | EW | Futures | 1400.8 | 1404.1 | 1389.6 | 1392.7 | 15452.0 |
| 2014-05-06 | FBTP | Futures | 89.16 | 89.48 | 89.12 | 89.38 | 49459.0 |
| 2014-05-06 | FBTS | Futures | 97.548 | 97.601 | 97.539 | 97.583 | 7188.0 |
| 2014-05-06 | FCE | Futures | 3524.2 | 3526.2 | 3473.0 | 3483.3 | 98214.0 |
| 2014-05-06 | FDAX | Futures | 10583.2 | 10595.9 | 10428.0 | 10463.9 | 99992.0 |
| 2014-05-06 | FESX | Futures | 2258.5 | 2261.4 | 2228.4 | 2234.8 | 747274.0 |
| 2014-05-06 | FGBL | Futures | 124.81 | 124.94 | 124.62 | 124.84 | 458221.0 |
| 2014-05-06 | FGBM | Futures | 120.12 | 120.19 | 120.03 | 120.07 | 321457.0 |
| 2014-05-06 | FGBS | Futures | 110.593 | 110.603 | 110.543 | 110.558 | 192245.0 |
| 2014-05-06 | FGBX | Futures | 129.16 | 129.45 | 128.82 | 129.31 | 15619.0 |
| 2014-05-06 | FMWO | Futures | 5607.4 | 5607.4 | 5584.7 | 5584.7 | 44.0 |
| 2014-05-06 | FOAT | Futures | 114.09 | 114.31 | 114.03 | 114.28 | 42789.0 |
| 2014-05-06 | FTDX | Futures | 1162.5 | 1164.4 | 1148.4 | 1156.9 | 106.0 |
| 2014-05-06 | FTI | Futures | 342.25 | 342.34 | 339.1 | 340.35 | 21659.0 |
| 2014-05-06 | FTUK | Futures | 5168.3 | 5180.9 | 5143.9 | 5154.6 | 78126.0 |
| 2014-05-06 | FVSA | Futures | 1761.27 | 1813.64 | 1732.71 | 1794.6 | 5507.0 |
| 2014-05-06 | FXXP | Futures | 252.0 | 252.0 | 249.5 | 249.8 | 6925.0 |
| 2014-05-06 | G | Futures | 94.29 | 94.35 | 93.97 | 94.24 | 134324.0 |
| 2014-05-06 | GF | Futures | 290.935 | 294.039 | 290.895 | 292.009 | 1897.0 |
| 2014-05-06 | GSCI | Futures | 1076.94 | 1079.42 | 1074.29 | 1075.28 | 245.0 |
| 2014-05-06 | HE | Futures | 136.933 | 139.165 | 136.822 | 137.519 | 20032.0 |
| 2014-05-06 | HG | Futures | 3.9011 | 3.9177 | 3.894 | 3.9062 | 25212.0 |
| 2014-05-06 | HH | Futures | 60.01 | 60.859 | 60.01 | 60.834 | 2048.0 |
| 2014-05-06 | HO | Futures | 2.3103 | 2.329 | 2.2996 | 2.3013 | 50891.0 |
> showing 50 of 103 rows — these rows as CSV