PREVIEW / futures_daily / 2013-11-19
file: by_date/futures_daily/2013/2013-11-19.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 |
|---|---|---|---|---|---|---|---|
| 2013-11-19 | ES | Futures | 1838.22 | 1842.59 | 1830.52 | 1833.85 | 1587851.0 |
| 2013-11-19 | NQ | Futures | 3890.92 | 3905.57 | 3871.4 | 3876.85 | 258679.0 |
| 2013-11-19 | YM | Futures | 15870.2 | 15913.0 | 15829.4 | 15854.3 | 139072.0 |
| 2013-11-19 | CL | Futures | 165.67 | 166.54 | 164.93 | 166.11 | 263051.0 |
| 2013-11-19 | GC | Futures | 1686.2 | 1690.5 | 1677.0 | 1684.3 | 105146.0 |
| 2013-11-19 | ZN | Futures | 115.192611 | 115.26342 | 114.838564 | 114.866888 | 916513.0 |
| 2013-11-19 | A6 | Futures | 0.88367 | 0.89085 | 0.88178 | 0.88783 | 69799.0 |
| 2013-11-19 | AD | Futures | 0.96803 | 0.96945 | 0.96298 | 0.96389 | 44679.0 |
| 2013-11-19 | B | Futures | 108.26 | 108.59 | 106.77 | 106.88 | 224434.0 |
| 2013-11-19 | B6 | Futures | 1.6909 | 1.6931 | 1.6854 | 1.6915 | 74276.0 |
| 2013-11-19 | BFX | Futures | 3463.7 | 3463.7 | 3454.6 | 3454.6 | 20.0 |
| 2013-11-19 | BR | Futures | 0.22326 | 0.22527 | 0.22257 | 0.22369 | 2264.0 |
| 2013-11-19 | BZ | Futures | 108.82 | 109.29 | 107.49 | 107.59 | 5874.0 |
| 2013-11-19 | C | Futures | 1881.0 | 1908.0 | 1876.0 | 1897.0 | 4637.0 |
| 2013-11-19 | CB | Futures | 74.095 | 74.814 | 74.095 | 74.095 | 14.0 |
| 2013-11-19 | CC | Futures | 2063.0 | 2093.0 | 2055.0 | 2074.0 | 16568.0 |
| 2013-11-19 | CNH | Futures | 6.9979 | 6.9992 | 6.9926 | 6.9927 | 31.0 |
| 2013-11-19 | CSC | Futures | 3.424 | 3.427 | 3.408 | 3.408 | 32.0 |
| 2013-11-19 | CT | Futures | 89.46 | 89.86 | 88.8 | 89.02 | 6275.0 |
| 2013-11-19 | DC | Futures | 26.02 | 26.14 | 25.95 | 26.02 | 184.0 |
| 2013-11-19 | DX | Futures | 76.929 | 77.057 | 76.8 | 76.933 | 14416.0 |
| 2013-11-19 | E1 | Futures | 1.40768 | 1.41205 | 1.4055 | 1.41025 | 26897.0 |
| 2013-11-19 | E6 | Futures | 1.59351 | 1.59882 | 1.59174 | 1.59693 | 200654.0 |
| 2013-11-19 | E7 | Futures | 1.5832 | 1.5885 | 1.5815 | 1.5866 | 3510.0 |
| 2013-11-19 | ED | Futures | 95.3662 | 95.3686 | 95.3662 | 95.3686 | 59530.0 |
| 2013-11-19 | ER | Futures | 97.891 | 97.891 | 97.881 | 97.881 | 55563.0 |
| 2013-11-19 | EW | Futures | 1326.5 | 1327.8 | 1313.2 | 1317.0 | 20489.0 |
| 2013-11-19 | FBTP | Futures | 81.69 | 81.86 | 81.68 | 81.7 | 23437.0 |
| 2013-11-19 | FBTS | Futures | 95.425 | 95.468 | 95.399 | 95.399 | 5129.0 |
| 2013-11-19 | FCE | Futures | 3334.6 | 3336.2 | 3296.6 | 3309.8 | 94952.0 |
| 2013-11-19 | FDAX | Futures | 10210.7 | 10231.8 | 10167.4 | 10208.4 | 86641.0 |
| 2013-11-19 | FESX | Futures | 2147.7 | 2151.2 | 2125.9 | 2137.9 | 767917.0 |
| 2013-11-19 | FEU3 | Futures | 98.507 | 98.507 | 98.502 | 98.502 | 5944.0 |
| 2013-11-19 | FGBL | Futures | 120.79 | 120.84 | 120.34 | 120.41 | 554156.0 |
| 2013-11-19 | FGBM | Futures | 118.62 | 118.65 | 118.43 | 118.47 | 370514.0 |
| 2013-11-19 | FGBS | Futures | 110.608 | 110.618 | 110.583 | 110.588 | 153633.0 |
| 2013-11-19 | FGBX | Futures | 121.28 | 121.44 | 120.64 | 120.76 | 10603.0 |
| 2013-11-19 | FMWO | Futures | 5331.9 | 5331.9 | 5331.9 | 5331.9 | 0.0 |
| 2013-11-19 | FOAT | Futures | 108.69 | 108.77 | 108.43 | 108.46 | 27171.0 |
| 2013-11-19 | FTDX | Futures | 1086.9 | 1087.8 | 1070.4 | 1079.4 | 79.0 |
| 2013-11-19 | FTI | Futures | 341.26 | 342.25 | 339.92 | 341.17 | 16621.0 |
| 2013-11-19 | FTUK | Futures | 5017.9 | 5026.6 | 5001.4 | 5019.4 | 75655.0 |
| 2013-11-19 | FVSA | Futures | 2051.31 | 2051.31 | 2008.95 | 2033.16 | 6485.0 |
| 2013-11-19 | FXXP | Futures | 235.9 | 236.1 | 234.3 | 235.4 | 4347.0 |
| 2013-11-19 | G | Futures | 92.47 | 92.65 | 92.34 | 92.46 | 147349.0 |
| 2013-11-19 | GF | Futures | 264.504 | 264.585 | 260.52 | 261.445 | 5025.0 |
| 2013-11-19 | GSCI | Futures | 1015.84 | 1018.99 | 1012.36 | 1014.52 | 288.0 |
| 2013-11-19 | HE | Futures | 108.423 | 108.876 | 107.97 | 108.574 | 14803.0 |
| 2013-11-19 | HG | Futures | 4.0038 | 4.0202 | 3.9595 | 3.9987 | 24460.0 |
| 2013-11-19 | HH | Futures | 37.161 | 37.171 | 36.453 | 36.484 | 6098.0 |
> showing 50 of 104 rows — these rows as CSV