PREVIEW / futures_daily / 2013-11-11
file: by_date/futures_daily/2013/2013-11-11.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 |
|---|---|---|---|---|---|---|---|
| 2013-11-11 | ES | Futures | 1815.11 | 1818.45 | 1810.74 | 1815.62 | 960010.0 |
| 2013-11-11 | NQ | Futures | 3860.77 | 3865.37 | 3842.4 | 3852.45 | 164939.0 |
| 2013-11-11 | YM | Futures | 15629.4 | 15664.2 | 15598.5 | 15644.3 | 80938.0 |
| 2013-11-11 | CL | Futures | 168.05 | 169.71 | 167.45 | 169.28 | 206721.0 |
| 2013-11-11 | GC | Futures | 1703.8 | 1704.5 | 1690.3 | 1694.3 | 98952.0 |
| 2013-11-11 | ZN | Futures | 114.27209 | 114.442032 | 114.20128 | 114.229604 | 162444.0 |
| 2013-11-11 | A6 | Futures | 0.88415 | 0.88481 | 0.88056 | 0.88056 | 52885.0 |
| 2013-11-11 | AD | Futures | 0.96298 | 0.9647 | 0.96268 | 0.96338 | 26870.0 |
| 2013-11-11 | B | Futures | 105.03 | 106.3 | 104.99 | 106.14 | 193469.0 |
| 2013-11-11 | B6 | Futures | 1.6801 | 1.6814 | 1.6754 | 1.6768 | 53611.0 |
| 2013-11-11 | BR | Futures | 0.2185 | 0.21973 | 0.21624 | 0.2169 | 474.0 |
| 2013-11-11 | BZ | Futures | 106.11 | 106.96 | 105.78 | 106.85 | 6425.0 |
| 2013-11-11 | C | Futures | 1806.0 | 1808.0 | 1760.0 | 1773.0 | 6790.0 |
| 2013-11-11 | CB | Futures | 72.056 | 72.056 | 72.056 | 72.056 | 3.0 |
| 2013-11-11 | CC | Futures | 1971.0 | 1980.0 | 1916.0 | 1930.0 | 27566.0 |
| 2013-11-11 | CNH | Futures | 7.0139 | 7.0139 | 7.0123 | 7.0135 | 1.0 |
| 2013-11-11 | CSC | Futures | 3.429 | 3.456 | 3.429 | 3.449 | 5.0 |
| 2013-11-11 | CT | Futures | 90.19 | 91.08 | 89.71 | 90.29 | 18931.0 |
| 2013-11-11 | DC | Futures | 26.14 | 26.42 | 26.14 | 26.34 | 209.0 |
| 2013-11-11 | DX | Futures | 77.539 | 77.577 | 77.3 | 77.367 | 15260.0 |
| 2013-11-11 | E1 | Futures | 1.39354 | 1.39881 | 1.39226 | 1.39701 | 21586.0 |
| 2013-11-11 | E6 | Futures | 1.57639 | 1.58347 | 1.57498 | 1.58182 | 113866.0 |
| 2013-11-11 | E7 | Futures | 1.5661 | 1.5734 | 1.5648 | 1.5716 | 2140.0 |
| 2013-11-11 | ED | Futures | 95.359 | 95.3638 | 95.359 | 95.3638 | 93969.0 |
| 2013-11-11 | ER | Futures | 97.896 | 97.901 | 97.886 | 97.891 | 50798.0 |
| 2013-11-11 | EW | Futures | 1309.9 | 1315.6 | 1305.4 | 1314.7 | 11827.0 |
| 2013-11-11 | FBTP | Futures | 81.25 | 81.45 | 81.18 | 81.29 | 16356.0 |
| 2013-11-11 | FBTS | Futures | 95.235 | 95.33 | 95.191 | 95.252 | 5012.0 |
| 2013-11-11 | FCE | Futures | 3309.0 | 3327.2 | 3293.1 | 3322.2 | 98013.0 |
| 2013-11-11 | FDAX | Futures | 10083.6 | 10126.3 | 10060.3 | 10117.5 | 66393.0 |
| 2013-11-11 | FESX | Futures | 2128.7 | 2141.4 | 2119.6 | 2138.6 | 574920.0 |
| 2013-11-11 | FEU3 | Futures | 98.517 | 98.517 | 98.512 | 98.512 | 16.0 |
| 2013-11-11 | FGBL | Futures | 120.13 | 120.28 | 120.0 | 120.07 | 259319.0 |
| 2013-11-11 | FGBM | Futures | 118.37 | 118.47 | 118.33 | 118.36 | 184693.0 |
| 2013-11-11 | FGBS | Futures | 110.598 | 110.613 | 110.583 | 110.593 | 113757.0 |
| 2013-11-11 | FGBX | Futures | 120.41 | 120.82 | 120.04 | 120.37 | 6750.0 |
| 2013-11-11 | FMWO | Futures | 5269.9 | 5269.9 | 5269.9 | 5269.9 | 0.0 |
| 2013-11-11 | FOAT | Futures | 108.16 | 108.44 | 108.1 | 108.19 | 16864.0 |
| 2013-11-11 | FTDX | Futures | 1069.9 | 1076.5 | 1069.9 | 1075.6 | 40.0 |
| 2013-11-11 | FTI | Futures | 339.66 | 340.83 | 339.23 | 340.57 | 4607.0 |
| 2013-11-11 | FTUK | Futures | 5038.2 | 5046.4 | 5013.1 | 5035.2 | 64115.0 |
| 2013-11-11 | FVSA | Futures | 2117.94 | 2130.11 | 2081.43 | 2105.77 | 2015.0 |
| 2013-11-11 | FXXP | Futures | 236.2 | 236.2 | 235.0 | 235.8 | 2308.0 |
| 2013-11-11 | G | Futures | 92.15 | 92.16 | 91.66 | 91.79 | 72329.0 |
| 2013-11-11 | GF | Futures | 265.229 | 265.631 | 264.303 | 264.303 | 3056.0 |
| 2013-11-11 | GSCI | Futures | 1013.94 | 1020.32 | 1013.94 | 1018.66 | 1585.0 |
| 2013-11-11 | HE | Futures | 111.573 | 111.952 | 111.161 | 111.446 | 24939.0 |
| 2013-11-11 | HG | Futures | 4.131 | 4.1481 | 4.1069 | 4.1272 | 39601.0 |
| 2013-11-11 | HH | Futures | 36.668 | 36.802 | 36.36 | 36.668 | 272.0 |
| 2013-11-11 | HO | Futures | 2.2959 | 2.3245 | 2.2959 | 2.3158 | 49559.0 |
> showing 50 of 103 rows — these rows as CSV