PREVIEW / futures_daily / 2013-12-26
file: by_date/futures_daily/2013/2013-12-26.parquet size: 8 KB rows: 76
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-12-26 | ES | Futures | 1886.47 | 1894.46 | 1886.21 | 1893.17 | 438937.0 |
| 2013-12-26 | NQ | Futures | 4107.26 | 4119.91 | 4102.09 | 4117.61 | 54009.0 |
| 2013-12-26 | YM | Futures | 16280.3 | 16402.1 | 16280.3 | 16396.1 | 37801.0 |
| 2013-12-26 | CL | Futures | 175.13 | 176.01 | 174.86 | 175.74 | 65666.0 |
| 2013-12-26 | GC | Futures | 1593.9 | 1609.2 | 1589.5 | 1605.1 | 54652.0 |
| 2013-12-26 | ZN | Futures | 112.68859 | 112.717206 | 112.545512 | 112.617051 | 133045.0 |
| 2013-12-26 | A6 | Futures | 0.84329 | 0.84415 | 0.84139 | 0.84301 | 12528.0 |
| 2013-12-26 | AD | Futures | 0.95025 | 0.95187 | 0.94883 | 0.94964 | 9631.0 |
| 2013-12-26 | B | Futures | 113.7 | 113.79 | 113.19 | 113.69 | 19039.0 |
| 2013-12-26 | B6 | Futures | 1.7197 | 1.7261 | 1.7194 | 1.7242 | 20919.0 |
| 2013-12-26 | BR | Futures | 0.21632 | 0.21673 | 0.21611 | 0.21622 | 1245.0 |
| 2013-12-26 | BZ | Futures | 115.68 | 116.04 | 115.46 | 115.96 | 1644.0 |
| 2013-12-26 | CC | Futures | 2089.0 | 2092.0 | 2056.0 | 2066.0 | 5057.0 |
| 2013-12-26 | CSC | Futures | 3.801 | 3.801 | 3.799 | 3.799 | 33.0 |
| 2013-12-26 | CT | Futures | 94.06 | 95.08 | 93.91 | 94.51 | 3378.0 |
| 2013-12-26 | DC | Futures | 29.4 | 29.51 | 29.27 | 29.32 | 97.0 |
| 2013-12-26 | DX | Futures | 76.718 | 76.752 | 76.642 | 76.698 | 7226.0 |
| 2013-12-26 | E1 | Futures | 1.43378 | 1.43532 | 1.43237 | 1.43314 | 4057.0 |
| 2013-12-26 | E6 | Futures | 1.61557 | 1.61711 | 1.61475 | 1.61616 | 26138.0 |
| 2013-12-26 | E7 | Futures | 1.6049 | 1.6066 | 1.6042 | 1.6056 | 764.0 |
| 2013-12-26 | ED | Futures | 95.3375 | 95.3423 | 95.3327 | 95.3375 | 14246.0 |
| 2013-12-26 | EW | Futures | 1363.2 | 1368.8 | 1360.9 | 1363.3 | 7845.0 |
| 2013-12-26 | GF | Futures | 268.086 | 268.69 | 267.845 | 268.207 | 715.0 |
| 2013-12-26 | GSCI | Futures | 1053.26 | 1055.57 | 1053.26 | 1055.08 | 15.0 |
| 2013-12-26 | HE | Futures | 103.471 | 103.743 | 102.928 | 103.018 | 7590.0 |
| 2013-12-26 | HG | Futures | 4.2703 | 4.2955 | 4.2538 | 4.2924 | 18554.0 |
| 2013-12-26 | HH | Futures | 44.599 | 45.11 | 44.238 | 44.84 | 27.0 |
| 2013-12-26 | HO | Futures | 2.4511 | 2.4654 | 2.4287 | 2.4502 | 10025.0 |
| 2013-12-26 | HRC | Futures | 2403.0 | 2403.0 | 2403.0 | 2403.0 | 0.0 |
| 2013-12-26 | J1 | Futures | 0.0120167 | 0.0120242 | 0.0120078 | 0.0120204 | 19556.0 |
| 2013-12-26 | J7 | Futures | 0.012028 | 0.012028 | 0.011999 | 0.012012 | 105.0 |
| 2013-12-26 | JB | Futures | 128.82 | 128.82 | 128.62 | 128.7 | 974.0 |
| 2013-12-26 | KC | Futures | 214.42 | 217.31 | 214.42 | 215.35 | 2739.0 |
| 2013-12-26 | KE | Futures | 2089.43 | 2090.24 | 2071.66 | 2082.97 | 3710.0 |
| 2013-12-26 | LBS | Futures | 609.0 | 614.0 | 608.9 | 613.1 | 117.0 |
| 2013-12-26 | LE | Futures | 158.676 | 159.12 | 158.616 | 158.972 | 8888.0 |
| 2013-12-26 | MFS | Futures | 1759.6 | 1763.2 | 1758.6 | 1762.8 | 1736.0 |
| 2013-12-26 | MGC | Futures | 1561.6 | 1576.9 | 1558.6 | 1572.9 | 641.0 |
| 2013-12-26 | MME | Futures | 929.1 | 929.6 | 923.5 | 924.2 | 2660.0 |
| 2013-12-26 | MP | Futures | 0.04583 | 0.04586 | 0.04557 | 0.04568 | 10275.0 |
| 2013-12-26 | N6 | Futures | 0.7163 | 0.71647 | 0.71497 | 0.71568 | 1834.0 |
| 2013-12-26 | NG | Futures | 61.688 | 61.894 | 60.51 | 61.318 | 55033.0 |
| 2013-12-26 | NIY | Futures | 13422.1 | 13446.9 | 13401.4 | 13438.6 | 11102.0 |
| 2013-12-26 | NKD | Futures | 15018.0 | 15054.9 | 14995.0 | 15041.1 | 5582.0 |
| 2013-12-26 | NOK | Futures | 0.166472 | 0.166595 | 0.166472 | 0.166534 | 8.0 |
| 2013-12-26 | OJ | Futures | 119.54 | 122.51 | 119.16 | 122.3 | 453.0 |
| 2013-12-26 | PA | Futures | 751.56 | 765.81 | 749.73 | 756.47 | 1299.0 |
| 2013-12-26 | PJY | Futures | 140.38 | 140.38 | 140.38 | 140.38 | 55.0 |
| 2013-12-26 | PL | Futures | 1480.0 | 1534.9 | 1479.9 | 1508.6 | 6159.0 |
| 2013-12-26 | QG | Futures | 61.819 | 62.163 | 60.923 | 61.681 | 670.0 |
> showing 50 of 76 rows — these rows as CSV