PREVIEW / futures_daily / 2014-12-24
file: by_date/futures_daily/2014/2014-12-24.parquet size: 9 KB rows: 89
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-24 | ES | Futures | 2178.8 | 2183.78 | 2176.96 | 2178.8 | 235054.0 |
| 2014-12-24 | NQ | Futures | 4963.73 | 4987.51 | 4961.99 | 4968.95 | 46180.0 |
| 2014-12-24 | YM | Futures | 18306.1 | 18364.1 | 18296.9 | 18320.4 | 20264.0 |
| 2014-12-24 | CL | Futures | 111.25 | 111.93 | 107.86 | 109.37 | 174969.0 |
| 2014-12-24 | GC | Futures | 1540.3 | 1546.1 | 1535.0 | 1536.0 | 43632.0 |
| 2014-12-24 | ZN | Futures | 118.701168 | 118.89255 | 118.392012 | 118.671724 | 341493.0 |
| 2014-12-24 | A6 | Futures | 0.78945 | 0.79131 | 0.78925 | 0.78984 | 18488.0 |
| 2014-12-24 | AD | Futures | 0.87473 | 0.87727 | 0.8734 | 0.87483 | 15592.0 |
| 2014-12-24 | ALI | Futures | 2835.4 | 2835.4 | 2835.4 | 2835.4 | 0.0 |
| 2014-12-24 | B | Futures | 63.68 | 63.76 | 61.34 | 62.24 | 108671.0 |
| 2014-12-24 | B6 | Futures | 1.6308 | 1.6348 | 1.6293 | 1.6344 | 26151.0 |
| 2014-12-24 | BFX | Futures | 4005.5 | 4010.3 | 4005.5 | 4006.7 | 2.0 |
| 2014-12-24 | BZ | Futures | 64.3 | 64.3 | 61.91 | 62.8 | 6504.0 |
| 2014-12-24 | C | Futures | 2173.0 | 2179.0 | 2169.0 | 2171.0 | 921.0 |
| 2014-12-24 | CB | Futures | 135.138 | 135.138 | 134.316 | 134.316 | 7.0 |
| 2014-12-24 | CC | Futures | 2196.0 | 2212.0 | 2181.0 | 2187.0 | 4002.0 |
| 2014-12-24 | CSC | Futures | 4.506 | 4.506 | 4.447 | 4.447 | 32.0 |
| 2014-12-24 | CT | Futures | 78.75 | 79.38 | 78.59 | 78.9 | 3926.0 |
| 2014-12-24 | DC | Futures | 35.2 | 35.46 | 34.97 | 34.97 | 79.0 |
| 2014-12-24 | DX | Futures | 85.423 | 85.49 | 85.267 | 85.403 | 13080.0 |
| 2014-12-24 | E1 | Futures | 1.29467 | 1.29978 | 1.29428 | 1.29646 | 9124.0 |
| 2014-12-24 | E6 | Futures | 1.43279 | 1.43844 | 1.43244 | 1.43491 | 106871.0 |
| 2014-12-24 | E7 | Futures | 1.4244 | 1.4297 | 1.4239 | 1.4263 | 994.0 |
| 2014-12-24 | EBM | Futures | 329.28 | 330.5 | 326.03 | 328.06 | 6644.0 |
| 2014-12-24 | ED | Futures | 95.4402 | 95.445 | 95.4306 | 95.4354 | 36311.0 |
| 2014-12-24 | ER | Futures | 98.009 | 98.014 | 98.004 | 98.014 | 8817.0 |
| 2014-12-24 | EW | Futures | 1524.6 | 1530.0 | 1520.8 | 1528.7 | 6273.0 |
| 2014-12-24 | FCE | Futures | 3529.6 | 3537.0 | 3510.9 | 3514.5 | 71908.0 |
| 2014-12-24 | FTI | Futures | 370.39 | 370.82 | 368.4 | 368.83 | 25126.0 |
| 2014-12-24 | FTUK | Futures | 5117.9 | 5133.5 | 5108.5 | 5123.3 | 10147.0 |
| 2014-12-24 | G | Futures | 102.12 | 102.13 | 101.79 | 101.93 | 9597.0 |
| 2014-12-24 | GF | Futures | 348.936 | 348.936 | 344.323 | 344.564 | 1524.0 |
| 2014-12-24 | GSCI | Futures | 735.53 | 735.78 | 734.25 | 734.93 | 6.0 |
| 2014-12-24 | HE | Futures | 109.438 | 109.673 | 108.499 | 109.069 | 6392.0 |
| 2014-12-24 | HG | Futures | 3.6413 | 3.6508 | 3.6127 | 3.6248 | 15216.0 |
| 2014-12-24 | HH | Futures | 37.956 | 37.956 | 36.118 | 36.394 | 3215.0 |
| 2014-12-24 | HO | Futures | 1.5569 | 1.5638 | 1.507 | 1.5154 | 8747.0 |
| 2014-12-24 | HRC | Futures | 2368.7 | 2368.7 | 2368.7 | 2368.7 | 0.0 |
| 2014-12-24 | J1 | Futures | 0.0103781 | 0.0104181 | 0.0103768 | 0.0104019 | 37848.0 |
| 2014-12-24 | J7 | Futures | 0.010366 | 0.010406 | 0.010366 | 0.010389 | 322.0 |
| 2014-12-24 | JB | Futures | 133.57 | 133.66 | 133.51 | 133.65 | 2247.0 |
| 2014-12-24 | KC | Futures | 292.54 | 294.34 | 290.75 | 291.43 | 3502.0 |
| 2014-12-24 | KE | Futures | 2138.72 | 2144.34 | 2048.81 | 2068.07 | 6513.0 |
| 2014-12-24 | L | Futures | 99.025 | 99.025 | 99.016 | 99.025 | 2767.0 |
| 2014-12-24 | LBS | Futures | 534.0 | 536.2 | 532.9 | 535.9 | 84.0 |
| 2014-12-24 | LE | Futures | 188.427 | 189.425 | 187.371 | 188.457 | 11866.0 |
| 2014-12-24 | MFC | Futures | 4238.0 | 4240.5 | 4234.1 | 4234.1 | 33.0 |
| 2014-12-24 | MFS | Futures | 1721.9 | 1730.3 | 1718.0 | 1726.2 | 5328.0 |
| 2014-12-24 | MGC | Futures | 1509.3 | 1514.3 | 1503.9 | 1504.8 | 286.0 |
| 2014-12-24 | MME | Futures | 918.7 | 926.2 | 916.2 | 919.0 | 7776.0 |
> showing 50 of 89 rows — these rows as CSV