PREVIEW / futures_daily / 2014-02-19
file: by_date/futures_daily/2014/2014-02-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 |
|---|---|---|---|---|---|---|---|
| 2014-02-19 | ES | Futures | 1893.94 | 1901.41 | 1879.51 | 1881.83 | 1771087.0 |
| 2014-02-19 | NQ | Futures | 4225.96 | 4229.98 | 4190.61 | 4201.24 | 277354.0 |
| 2014-02-19 | YM | Futures | 16081.6 | 16175.4 | 15978.7 | 15990.7 | 187532.0 |
| 2014-02-19 | CL | Futures | 182.52 | 183.8 | 181.43 | 183.0 | 246417.0 |
| 2014-02-19 | GC | Futures | 1742.7 | 1744.0 | 1725.4 | 1740.5 | 112256.0 |
| 2014-02-19 | ZN | Futures | 115.321234 | 115.636006 | 115.063693 | 115.135232 | 1042209.0 |
| 2014-02-19 | A6 | Futures | 0.85816 | 0.86044 | 0.8552 | 0.85654 | 73283.0 |
| 2014-02-19 | AD | Futures | 0.92392 | 0.92757 | 0.91278 | 0.91349 | 74809.0 |
| 2014-02-19 | B | Futures | 113.51 | 113.79 | 112.97 | 113.43 | 163342.0 |
| 2014-02-19 | B6 | Futures | 1.7522 | 1.7576 | 1.7474 | 1.7537 | 126770.0 |
| 2014-02-19 | BFX | Futures | 3620.7 | 3640.0 | 3620.6 | 3633.1 | 248.0 |
| 2014-02-19 | BR | Futures | 0.21505 | 0.21655 | 0.21425 | 0.2165 | 658.0 |
| 2014-02-19 | BZ | Futures | 115.56 | 116.1 | 115.27 | 115.73 | 4749.0 |
| 2014-02-19 | C | Futures | 1958.0 | 1960.0 | 1929.0 | 1941.0 | 7197.0 |
| 2014-02-19 | CB | Futures | 87.831 | 87.831 | 87.323 | 87.831 | 11.0 |
| 2014-02-19 | CC | Futures | 2186.0 | 2188.0 | 2154.0 | 2178.0 | 10963.0 |
| 2014-02-19 | CSC | Futures | 4.28 | 4.29 | 4.28 | 4.29 | 4.0 |
| 2014-02-19 | CT | Futures | 100.24 | 100.4 | 98.98 | 99.16 | 8588.0 |
| 2014-02-19 | DC | Futures | 33.2 | 33.4 | 33.08 | 33.39 | 302.0 |
| 2014-02-19 | DX | Futures | 76.086 | 76.343 | 76.029 | 76.253 | 17966.0 |
| 2014-02-19 | E1 | Futures | 1.44623 | 1.44982 | 1.44341 | 1.44585 | 25354.0 |
| 2014-02-19 | E6 | Futures | 1.62419 | 1.62584 | 1.62018 | 1.62242 | 129996.0 |
| 2014-02-19 | E7 | Futures | 1.6136 | 1.6151 | 1.6096 | 1.6118 | 2458.0 |
| 2014-02-19 | EBM | Futures | 277.39 | 277.74 | 276.35 | 277.04 | 9250.0 |
| 2014-02-19 | ED | Futures | 95.3829 | 95.3877 | 95.3829 | 95.3853 | 112845.0 |
| 2014-02-19 | ER | Futures | 97.881 | 97.891 | 97.876 | 97.886 | 33840.0 |
| 2014-02-19 | EW | Futures | 1381.4 | 1387.2 | 1371.6 | 1372.4 | 17277.0 |
| 2014-02-19 | FBTP | Futures | 85.66 | 85.67 | 85.25 | 85.34 | 47911.0 |
| 2014-02-19 | FBTS | Futures | 96.713 | 96.713 | 96.582 | 96.643 | 9613.0 |
| 2014-02-19 | FCE | Futures | 3352.1 | 3373.0 | 3341.3 | 3363.0 | 211539.0 |
| 2014-02-19 | FDAX | Futures | 10695.3 | 10758.5 | 10625.4 | 10709.1 | 108812.0 |
| 2014-02-19 | FESX | Futures | 2188.6 | 2204.8 | 2178.1 | 2195.0 | 844774.0 |
| 2014-02-19 | FGBL | Futures | 122.38 | 122.79 | 122.3 | 122.46 | 781135.0 |
| 2014-02-19 | FGBM | Futures | 119.33 | 119.54 | 119.3 | 119.38 | 387122.0 |
| 2014-02-19 | FGBS | Futures | 110.633 | 110.668 | 110.618 | 110.638 | 223653.0 |
| 2014-02-19 | FGBX | Futures | 123.73 | 124.62 | 123.61 | 124.04 | 19135.0 |
| 2014-02-19 | FMWO | Futures | 5467.3 | 5467.3 | 5467.3 | 5467.3 | 0.0 |
| 2014-02-19 | FOAT | Futures | 110.79 | 111.11 | 110.75 | 110.81 | 54040.0 |
| 2014-02-19 | FTDX | Futures | 1191.5 | 1196.2 | 1185.0 | 1191.1 | 251.0 |
| 2014-02-19 | FTI | Futures | 342.58 | 343.82 | 340.91 | 343.0 | 60327.0 |
| 2014-02-19 | FTUK | Futures | 5113.4 | 5135.4 | 5090.0 | 5123.7 | 116682.0 |
| 2014-02-19 | FVSA | Futures | 1796.75 | 1816.66 | 1766.89 | 1786.8 | 22554.0 |
| 2014-02-19 | FXXP | Futures | 245.2 | 246.0 | 244.0 | 245.6 | 3791.0 |
| 2014-02-19 | G | Futures | 93.19 | 93.61 | 93.09 | 93.34 | 159369.0 |
| 2014-02-19 | GF | Futures | 276.746 | 277.471 | 275.698 | 275.98 | 2355.0 |
| 2014-02-19 | GSCI | Futures | 1068.13 | 1074.12 | 1068.05 | 1072.65 | 239.0 |
| 2014-02-19 | HE | Futures | 117.451 | 118.266 | 117.33 | 117.39 | 16758.0 |
| 2014-02-19 | HG | Futures | 4.151 | 4.1688 | 4.1314 | 4.1459 | 19862.0 |
| 2014-02-19 | HH | Futures | 60.614 | 66.489 | 60.614 | 65.331 | 6804.0 |
| 2014-02-19 | HO | Futures | 2.4047 | 2.4203 | 2.3992 | 2.4138 | 20824.0 |
> showing 50 of 104 rows — these rows as CSV