PREVIEW / futures_daily / 2012-12-26
file: by_date/futures_daily/2012/2012-12-26.parquet size: 8 KB rows: 74
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-26 | ES | Futures | 1457.03 | 1458.57 | 1443.47 | 1446.29 | 578176.0 |
| 2012-12-26 | NQ | Futures | 3060.65 | 3066.71 | 3024.32 | 3031.81 | 82841.0 |
| 2012-12-26 | YM | Futures | 12839.9 | 12856.6 | 12758.5 | 12794.8 | 37860.0 |
| 2012-12-26 | CL | Futures | 157.29 | 162.04 | 157.23 | 161.48 | 141598.0 |
| 2012-12-26 | GC | Futures | 2208.7 | 2223.8 | 2199.6 | 2213.1 | 52722.0 |
| 2012-12-26 | ZN | Futures | 116.721249 | 116.955546 | 116.652338 | 116.872853 | 111844.0 |
| 2012-12-26 | A6 | Futures | 0.94255 | 0.94465 | 0.94081 | 0.9431 | 32513.0 |
| 2012-12-26 | AD | Futures | 1.00821 | 1.00941 | 1.0059 | 1.0066 | 17063.0 |
| 2012-12-26 | B | Futures | 101.45 | 103.71 | 101.4 | 103.29 | 31261.0 |
| 2012-12-26 | B6 | Futures | 1.6873 | 1.6896 | 1.683 | 1.6852 | 31069.0 |
| 2012-12-26 | BR | Futures | 0.23681 | 0.23681 | 0.23681 | 0.23681 | 42.0 |
| 2012-12-26 | BZ | Futures | 104.52 | 105.86 | 104.52 | 105.59 | 173.0 |
| 2012-12-26 | CB | Futures | 85.879 | 85.879 | 85.749 | 85.879 | 17.0 |
| 2012-12-26 | CC | Futures | 1715.0 | 1720.0 | 1706.0 | 1707.0 | 4244.0 |
| 2012-12-26 | CSC | Futures | 3.903 | 3.903 | 3.873 | 3.884 | 41.0 |
| 2012-12-26 | CT | Futures | 96.29 | 96.99 | 96.15 | 96.98 | 8017.0 |
| 2012-12-26 | DC | Futures | 29.13 | 29.13 | 28.91 | 29.01 | 81.0 |
| 2012-12-26 | DX | Futures | 76.899 | 76.972 | 76.644 | 76.87 | 9970.0 |
| 2012-12-26 | E1 | Futures | 1.41019 | 1.41547 | 1.40865 | 1.412 | 6223.0 |
| 2012-12-26 | E6 | Futures | 1.55917 | 1.56472 | 1.5567 | 1.56059 | 53665.0 |
| 2012-12-26 | E7 | Futures | 1.5485 | 1.5541 | 1.5462 | 1.5499 | 1146.0 |
| 2012-12-26 | ED | Futures | 95.2103 | 95.2103 | 95.2056 | 95.2103 | 33204.0 |
| 2012-12-26 | EW | Futures | 1038.4 | 1041.0 | 1027.2 | 1027.4 | 8968.0 |
| 2012-12-26 | GF | Futures | 288.569 | 290.466 | 287.715 | 288.569 | 1735.0 |
| 2012-12-26 | GSCI | Futures | 1042.99 | 1046.37 | 1039.77 | 1040.25 | 108.0 |
| 2012-12-26 | HE | Futures | 100.618 | 100.761 | 99.929 | 100.359 | 7352.0 |
| 2012-12-26 | HG | Futures | 4.5832 | 4.6397 | 4.5716 | 4.6198 | 19266.0 |
| 2012-12-26 | HH | Futures | 40.21 | 40.21 | 40.21 | 40.21 | 145.0 |
| 2012-12-26 | HO | Futures | 2.4057 | 2.4456 | 2.4004 | 2.4332 | 9301.0 |
| 2012-12-26 | HRC | Futures | 2409.5 | 2409.5 | 2409.5 | 2409.5 | 0.0 |
| 2012-12-26 | J1 | Futures | 0.0146983 | 0.0147095 | 0.0146268 | 0.0146456 | 64197.0 |
| 2012-12-26 | J7 | Futures | 0.014646 | 0.014646 | 0.014555 | 0.014573 | 842.0 |
| 2012-12-26 | JB | Futures | 126.99 | 127.01 | 126.72 | 126.77 | 1906.0 |
| 2012-12-26 | KC | Futures | 308.57 | 312.56 | 306.05 | 311.19 | 4857.0 |
| 2012-12-26 | KE | Futures | 2783.15 | 2783.15 | 2713.98 | 2715.63 | 4635.0 |
| 2012-12-26 | LBS | Futures | 682.7 | 706.8 | 682.5 | 697.9 | 974.0 |
| 2012-12-26 | LE | Futures | 169.466 | 170.134 | 169.212 | 169.975 | 12858.0 |
| 2012-12-26 | MFS | Futures | 1467.0 | 1470.8 | 1459.7 | 1465.5 | 1816.0 |
| 2012-12-26 | MGC | Futures | 2180.9 | 2193.7 | 2169.0 | 2183.1 | 310.0 |
| 2012-12-26 | MME | Futures | 962.5 | 972.1 | 962.5 | 965.5 | 1765.0 |
| 2012-12-26 | MP | Futures | 0.04468 | 0.04473 | 0.04444 | 0.04454 | 30658.0 |
| 2012-12-26 | N6 | Futures | 0.69814 | 0.69814 | 0.69242 | 0.69481 | 5791.0 |
| 2012-12-26 | NG | Futures | 52.662 | 53.836 | 52.067 | 53.617 | 57139.0 |
| 2012-12-26 | NIY | Futures | 8490.2 | 8539.6 | 8486.1 | 8506.7 | 6953.0 |
| 2012-12-26 | NKD | Futures | 9766.3 | 9818.2 | 9752.1 | 9785.2 | 2841.0 |
| 2012-12-26 | NOK | Futures | 0.18441 | 0.18441 | 0.18441 | 0.18441 | 0.0 |
| 2012-12-26 | OJ | Futures | 116.02 | 117.23 | 114.54 | 114.62 | 931.0 |
| 2012-12-26 | PA | Futures | 749.35 | 758.43 | 749.29 | 757.88 | 839.0 |
| 2012-12-26 | PJY | Futures | 115.75 | 115.75 | 115.75 | 115.75 | 316.0 |
| 2012-12-26 | PL | Futures | 1721.4 | 1735.8 | 1716.2 | 1718.0 | 6422.0 |
> showing 50 of 74 rows — these rows as CSV