PREVIEW / futures_daily / 2014-04-16
file: by_date/futures_daily/2014/2014-04-16.parquet size: 9 KB rows: 104
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-04-16 | ES | Futures | 1906.58 | 1921.32 | 1904.25 | 1916.92 | 1255343.0 |
| 2014-04-16 | NQ | Futures | 4026.28 | 4057.07 | 4005.27 | 4030.59 | 269150.0 |
| 2014-04-16 | YM | Futures | 16311.6 | 16433.1 | 16288.5 | 16398.0 | 125082.0 |
| 2014-04-16 | CL | Futures | 186.62 | 188.55 | 185.53 | 186.62 | 181528.0 |
| 2014-04-16 | GC | Futures | 1717.1 | 1722.2 | 1704.3 | 1717.5 | 95708.0 |
| 2014-04-16 | ZN | Futures | 115.489723 | 115.562157 | 115.243445 | 115.31588 | 1141002.0 |
| 2014-04-16 | A6 | Futures | 0.89539 | 0.89846 | 0.89308 | 0.89798 | 54578.0 |
| 2014-04-16 | AD | Futures | 0.92191 | 0.92404 | 0.91755 | 0.91937 | 31657.0 |
| 2014-04-16 | B | Futures | 113.01 | 113.97 | 112.57 | 113.19 | 229357.0 |
| 2014-04-16 | B6 | Futures | 1.7573 | 1.7674 | 1.7565 | 1.7647 | 53303.0 |
| 2014-04-16 | BFX | Futures | 3652.2 | 3683.4 | 3652.2 | 3683.4 | 55.0 |
| 2014-04-16 | BR | Futures | 0.23376 | 0.23376 | 0.23205 | 0.23241 | 565.0 |
| 2014-04-16 | BZ | Futures | 114.91 | 116.14 | 114.75 | 115.36 | 6094.0 |
| 2014-04-16 | C | Futures | 1948.0 | 1950.0 | 1935.0 | 1939.0 | 4418.0 |
| 2014-04-16 | CB | Futures | 92.908 | 92.908 | 92.895 | 92.908 | 48.0 |
| 2014-04-16 | CC | Futures | 2192.0 | 2206.0 | 2184.0 | 2193.0 | 8785.0 |
| 2014-04-16 | CNH | Futures | 7.1466 | 7.1488 | 7.1466 | 7.1467 | 20.0 |
| 2014-04-16 | CSC | Futures | 4.421 | 4.466 | 4.417 | 4.424 | 88.0 |
| 2014-04-16 | CT | Futures | 101.61 | 102.54 | 101.22 | 102.33 | 6571.0 |
| 2014-04-16 | DC | Futures | 35.15 | 35.79 | 35.04 | 35.3 | 199.0 |
| 2014-04-16 | DX | Futures | 75.902 | 75.959 | 75.731 | 75.891 | 10726.0 |
| 2014-04-16 | E1 | Futures | 1.45843 | 1.46228 | 1.45355 | 1.45676 | 20172.0 |
| 2014-04-16 | E6 | Futures | 1.63045 | 1.63493 | 1.62938 | 1.63139 | 109562.0 |
| 2014-04-16 | E7 | Futures | 1.6198 | 1.624 | 1.6186 | 1.6205 | 2077.0 |
| 2014-04-16 | EBM | Futures | 310.37 | 311.78 | 306.85 | 307.91 | 30335.0 |
| 2014-04-16 | ED | Futures | 95.4091 | 95.4138 | 95.4091 | 95.4091 | 89262.0 |
| 2014-04-16 | ER | Futures | 97.852 | 97.852 | 97.842 | 97.842 | 43486.0 |
| 2014-04-16 | EW | Futures | 1378.3 | 1388.5 | 1375.9 | 1385.7 | 14021.0 |
| 2014-04-16 | FBTP | Futures | 88.61 | 88.75 | 88.51 | 88.7 | 33788.0 |
| 2014-04-16 | FBTS | Futures | 97.566 | 97.575 | 97.539 | 97.557 | 7790.0 |
| 2014-04-16 | FCE | Futures | 3439.3 | 3461.9 | 3424.2 | 3447.2 | 103278.0 |
| 2014-04-16 | FDAX | Futures | 10239.2 | 10348.5 | 10200.0 | 10305.4 | 111141.0 |
| 2014-04-16 | FESX | Futures | 2203.9 | 2221.9 | 2193.9 | 2211.1 | 1073396.0 |
| 2014-04-16 | FGBL | Futures | 124.59 | 124.68 | 124.45 | 124.57 | 527872.0 |
| 2014-04-16 | FGBM | Futures | 120.03 | 120.09 | 119.96 | 120.02 | 323704.0 |
| 2014-04-16 | FGBS | Futures | 110.593 | 110.608 | 110.573 | 110.588 | 188554.0 |
| 2014-04-16 | FGBX | Futures | 128.41 | 128.57 | 128.15 | 128.41 | 14746.0 |
| 2014-04-16 | FMWO | Futures | 5488.8 | 5496.4 | 5488.8 | 5496.4 | 238.0 |
| 2014-04-16 | FOAT | Futures | 113.84 | 113.98 | 113.79 | 113.9 | 40879.0 |
| 2014-04-16 | FTDX | Futures | 1095.5 | 1113.7 | 1095.5 | 1112.3 | 296.0 |
| 2014-04-16 | FTI | Futures | 337.5 | 338.58 | 334.99 | 337.37 | 18278.0 |
| 2014-04-16 | FTUK | Futures | 4963.6 | 4999.0 | 4956.3 | 4984.5 | 95755.0 |
| 2014-04-16 | FVSA | Futures | 1875.52 | 1875.52 | 1808.88 | 1813.64 | 8216.0 |
| 2014-04-16 | FXXP | Futures | 244.3 | 245.7 | 243.4 | 245.1 | 5410.0 |
| 2014-04-16 | G | Futures | 94.46 | 94.46 | 94.11 | 94.25 | 122707.0 |
| 2014-04-16 | GF | Futures | 285.882 | 286.638 | 285.444 | 286.32 | 3462.0 |
| 2014-04-16 | GSCI | Futures | 1092.1 | 1098.89 | 1092.1 | 1093.51 | 95.0 |
| 2014-04-16 | HE | Futures | 140.097 | 143.334 | 140.097 | 143.334 | 443.0 |
| 2014-04-16 | HG | Futures | 3.793 | 3.8804 | 3.7784 | 3.8342 | 29221.0 |
| 2014-04-16 | HH | Futures | 57.858 | 57.858 | 57.263 | 57.339 | 572.0 |
> showing 50 of 104 rows — these rows as CSV