PREVIEW / futures_daily / 2014-12-26
file: by_date/futures_daily/2014/2014-12-26.parquet size: 8 KB rows: 79
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-12-26 | ES | Futures | 2178.8 | 2189.28 | 2178.53 | 2184.56 | 309281.0 |
| 2014-12-26 | NQ | Futures | 4968.37 | 5014.78 | 4968.37 | 5001.15 | 61111.0 |
| 2014-12-26 | YM | Futures | 18320.4 | 18384.5 | 18320.4 | 18344.8 | 23865.0 |
| 2014-12-26 | CL | Futures | 109.4 | 110.83 | 106.76 | 107.19 | 127202.0 |
| 2014-12-26 | GC | Futures | 1538.2 | 1569.5 | 1538.2 | 1564.5 | 67183.0 |
| 2014-12-26 | ZN | Futures | 118.701168 | 118.818942 | 118.642281 | 118.730611 | 165055.0 |
| 2014-12-26 | A6 | Futures | 0.79053 | 0.79209 | 0.78945 | 0.79053 | 17743.0 |
| 2014-12-26 | AD | Futures | 0.87544 | 0.87625 | 0.87412 | 0.87473 | 6776.0 |
| 2014-12-26 | ALI | Futures | 2839.56 | 2839.56 | 2839.56 | 2839.56 | 0.0 |
| 2014-12-26 | B | Futures | 62.24 | 62.99 | 61.27 | 61.5 | 13431.0 |
| 2014-12-26 | B6 | Futures | 1.6351 | 1.6361 | 1.6327 | 1.6351 | 10931.0 |
| 2014-12-26 | BR | Futures | 0.20281 | 0.20306 | 0.20276 | 0.20276 | 18.0 |
| 2014-12-26 | BZ | Futures | 62.8 | 63.29 | 61.64 | 61.83 | 2073.0 |
| 2014-12-26 | CB | Futures | 134.316 | 134.316 | 132.673 | 132.673 | 13.0 |
| 2014-12-26 | CC | Futures | 2187.0 | 2187.0 | 2166.0 | 2170.0 | 2906.0 |
| 2014-12-26 | CSC | Futures | 4.447 | 4.447 | 4.438 | 4.438 | 22.0 |
| 2014-12-26 | CT | Futures | 78.9 | 79.12 | 78.64 | 78.71 | 3323.0 |
| 2014-12-26 | DC | Futures | 35.06 | 35.3 | 34.76 | 34.92 | 82.0 |
| 2014-12-26 | DX | Futures | 85.305 | 85.542 | 85.258 | 85.485 | 6651.0 |
| 2014-12-26 | E1 | Futures | 1.29939 | 1.30092 | 1.29403 | 1.29492 | 6358.0 |
| 2014-12-26 | E6 | Futures | 1.43844 | 1.43938 | 1.43221 | 1.43326 | 43012.0 |
| 2014-12-26 | E7 | Futures | 1.4301 | 1.4308 | 1.4237 | 1.4247 | 893.0 |
| 2014-12-26 | ED | Futures | 95.4354 | 95.4402 | 95.4306 | 95.4354 | 18189.0 |
| 2014-12-26 | ER | Futures | 98.014 | 98.014 | 98.014 | 98.014 | 0.0 |
| 2014-12-26 | EW | Futures | 1528.9 | 1536.6 | 1528.2 | 1532.4 | 4801.0 |
| 2014-12-26 | GF | Futures | 345.366 | 347.692 | 337.344 | 342.919 | 3040.0 |
| 2014-12-26 | GSCI | Futures | 741.92 | 741.92 | 728.11 | 729.64 | 16.0 |
| 2014-12-26 | HE | Futures | 109.371 | 109.84 | 107.727 | 109.404 | 8655.0 |
| 2014-12-26 | HG | Futures | 3.6235 | 3.6362 | 3.5619 | 3.5746 | 16721.0 |
| 2014-12-26 | HH | Futures | 36.37 | 36.575 | 36.346 | 36.43 | 97.0 |
| 2014-12-26 | HO | Futures | 1.5179 | 1.5308 | 1.5043 | 1.514 | 5702.0 |
| 2014-12-26 | HRC | Futures | 2368.7 | 2368.7 | 2368.7 | 2368.7 | 0.0 |
| 2014-12-26 | J1 | Futures | 0.0104181 | 0.0104269 | 0.0104006 | 0.0104081 | 21833.0 |
| 2014-12-26 | J7 | Futures | 0.010404 | 0.010414 | 0.010389 | 0.010396 | 160.0 |
| 2014-12-26 | JB | Futures | 133.74 | 133.81 | 133.55 | 133.57 | 612.0 |
| 2014-12-26 | KC | Futures | 293.14 | 296.31 | 287.32 | 288.78 | 4266.0 |
| 2014-12-26 | KE | Futures | 2074.5 | 2084.93 | 2062.46 | 2068.88 | 2325.0 |
| 2014-12-26 | LBS | Futures | 535.9 | 537.0 | 532.9 | 536.4 | 42.0 |
| 2014-12-26 | LE | Futures | 188.956 | 191.303 | 187.929 | 190.687 | 13155.0 |
| 2014-12-26 | MFS | Futures | 1733.3 | 1736.3 | 1731.2 | 1734.9 | 3353.0 |
| 2014-12-26 | MGC | Futures | 1509.3 | 1538.2 | 1508.4 | 1532.8 | 896.0 |
| 2014-12-26 | MME | Futures | 931.5 | 933.4 | 925.6 | 927.8 | 6801.0 |
| 2014-12-26 | MP | Futures | 0.04149 | 0.0417 | 0.04149 | 0.04166 | 7173.0 |
| 2014-12-26 | N6 | Futures | 0.69578 | 0.69904 | 0.69551 | 0.69832 | 3852.0 |
| 2014-12-26 | NG | Futures | 52.313 | 52.648 | 50.386 | 50.821 | 55298.0 |
| 2014-12-26 | NIY | Futures | 14885.4 | 15048.8 | 14864.4 | 15019.5 | 8168.0 |
| 2014-12-26 | NKD | Futures | 16391.7 | 16552.2 | 16345.8 | 16520.1 | 3824.0 |
| 2014-12-26 | NOK | Futures | 0.139379 | 0.139421 | 0.139285 | 0.139285 | 21.0 |
| 2014-12-26 | OJ | Futures | 118.32 | 118.32 | 115.83 | 116.46 | 288.0 |
| 2014-12-26 | PA | Futures | 868.4 | 882.89 | 868.4 | 882.25 | 1103.0 |
> showing 50 of 79 rows — these rows as CSV