PREVIEW / futures_daily / 2013-12-24
file: by_date/futures_daily/2013/2013-12-24.parquet size: 9 KB rows: 88
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-24 | ES | Futures | 1878.99 | 1885.95 | 1876.67 | 1885.44 | 314408.0 |
| 2013-12-24 | NQ | Futures | 4098.64 | 4107.26 | 4093.75 | 4103.81 | 47467.0 |
| 2013-12-24 | YM | Futures | 16217.4 | 16279.3 | 16197.4 | 16277.3 | 19940.0 |
| 2013-12-24 | CL | Futures | 174.1 | 175.3 | 173.94 | 175.16 | 51877.0 |
| 2013-12-24 | GC | Futures | 1585.9 | 1595.6 | 1582.9 | 1593.2 | 43489.0 |
| 2013-12-24 | ZN | Futures | 113.031979 | 113.132133 | 112.631359 | 112.674282 | 202004.0 |
| 2013-12-24 | A6 | Futures | 0.84615 | 0.8471 | 0.84443 | 0.84605 | 20528.0 |
| 2013-12-24 | AD | Futures | 0.95207 | 0.95288 | 0.95035 | 0.95217 | 18241.0 |
| 2013-12-24 | B | Futures | 113.41 | 113.86 | 113.21 | 113.7 | 52160.0 |
| 2013-12-24 | B6 | Futures | 1.7163 | 1.7202 | 1.7138 | 1.7193 | 23822.0 |
| 2013-12-24 | BR | Futures | 0.21624 | 0.21624 | 0.21624 | 0.21624 | 6.0 |
| 2013-12-24 | BZ | Futures | 115.36 | 115.84 | 115.2 | 115.68 | 2113.0 |
| 2013-12-24 | C | Futures | 1898.0 | 1909.0 | 1892.0 | 1909.0 | 2557.0 |
| 2013-12-24 | CB | Futures | 80.839 | 80.839 | 80.471 | 80.471 | 6.0 |
| 2013-12-24 | CC | Futures | 2080.0 | 2104.0 | 2080.0 | 2093.0 | 3991.0 |
| 2013-12-24 | CNH | Futures | 6.9999 | 7.0021 | 6.9999 | 7.0021 | 10.0 |
| 2013-12-24 | CT | Futures | 93.77 | 95.09 | 93.38 | 94.84 | 6296.0 |
| 2013-12-24 | DC | Futures | 29.48 | 29.48 | 29.32 | 29.4 | 20.0 |
| 2013-12-24 | DX | Futures | 76.699 | 76.818 | 76.676 | 76.717 | 5614.0 |
| 2013-12-24 | E1 | Futures | 1.43724 | 1.43763 | 1.4316 | 1.43378 | 7561.0 |
| 2013-12-24 | E6 | Futures | 1.61675 | 1.61711 | 1.61179 | 1.61475 | 34364.0 |
| 2013-12-24 | E7 | Futures | 1.6061 | 1.6064 | 1.6014 | 1.6042 | 1226.0 |
| 2013-12-24 | EBM | Futures | 287.14 | 287.49 | 286.44 | 287.14 | 1529.0 |
| 2013-12-24 | ED | Futures | 95.3375 | 95.3423 | 95.3327 | 95.3375 | 24626.0 |
| 2013-12-24 | ER | Futures | 97.847 | 97.862 | 97.847 | 97.862 | 21346.0 |
| 2013-12-24 | EW | Futures | 1355.0 | 1364.0 | 1353.6 | 1363.7 | 5751.0 |
| 2013-12-24 | FCE | Futures | 3286.8 | 3300.5 | 3283.3 | 3290.7 | 15216.0 |
| 2013-12-24 | FTI | Futures | 339.68 | 341.66 | 339.42 | 340.75 | 5039.0 |
| 2013-12-24 | FTUK | Futures | 5013.9 | 5043.8 | 5007.1 | 5027.9 | 13958.0 |
| 2013-12-24 | G | Futures | 90.47 | 90.58 | 90.34 | 90.5 | 45865.0 |
| 2013-12-24 | GF | Futures | 268.167 | 268.529 | 267.241 | 267.643 | 1036.0 |
| 2013-12-24 | GSCI | Futures | 1052.52 | 1054.17 | 1051.28 | 1053.84 | 93.0 |
| 2013-12-24 | HE | Futures | 104.196 | 104.286 | 103.109 | 103.713 | 8152.0 |
| 2013-12-24 | HG | Futures | 4.1787 | 4.3195 | 4.1736 | 4.2614 | 31209.0 |
| 2013-12-24 | HH | Futures | 44.519 | 44.519 | 43.928 | 44.238 | 5639.0 |
| 2013-12-24 | HO | Futures | 2.4386 | 2.4546 | 2.4348 | 2.4462 | 5173.0 |
| 2013-12-24 | HRC | Futures | 2403.0 | 2403.0 | 2403.0 | 2403.0 | 0.0 |
| 2013-12-24 | J1 | Futures | 0.0120833 | 0.0120896 | 0.0120569 | 0.0120733 | 32616.0 |
| 2013-12-24 | J7 | Futures | 0.012077 | 0.012079 | 0.01205 | 0.012065 | 123.0 |
| 2013-12-24 | JB | Futures | 128.98 | 129.03 | 128.88 | 128.99 | 1138.0 |
| 2013-12-24 | KC | Futures | 216.1 | 217.87 | 212.74 | 214.05 | 2797.0 |
| 2013-12-24 | KE | Futures | 2095.9 | 2102.36 | 2083.78 | 2089.43 | 3387.0 |
| 2013-12-24 | L | Futures | 98.841 | 98.841 | 98.821 | 98.831 | 16528.0 |
| 2013-12-24 | LBS | Futures | 611.1 | 614.2 | 609.5 | 611.3 | 165.0 |
| 2013-12-24 | LE | Futures | 158.794 | 159.031 | 158.113 | 158.468 | 10983.0 |
| 2013-12-24 | MFS | Futures | 1745.7 | 1753.0 | 1742.8 | 1752.4 | 2040.0 |
| 2013-12-24 | MGC | Futures | 1552.0 | 1563.4 | 1550.7 | 1561.2 | 319.0 |
| 2013-12-24 | MME | Futures | 927.4 | 932.7 | 927.4 | 931.5 | 3202.0 |
| 2013-12-24 | MP | Futures | 0.0459 | 0.04599 | 0.04578 | 0.04584 | 5925.0 |
| 2013-12-24 | N6 | Futures | 0.71903 | 0.7193 | 0.71683 | 0.7178 | 3241.0 |
> showing 50 of 88 rows — these rows as CSV