PREVIEW / futures_daily / 2016-03-28
file: by_date/futures_daily/2016/2016-03-28.parquet size: 8 KB rows: 83
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-28 | ES | Futures | 2179.92 | 2190.12 | 2171.06 | 2177.5 | 907834.0 |
| 2016-03-28 | NQ | Futures | 5171.79 | 5200.29 | 5148.29 | 5157.69 | 133720.0 |
| 2016-03-28 | YM | Futures | 18158.2 | 18222.7 | 18083.4 | 18141.6 | 82564.0 |
| 2016-03-28 | CL | Futures | 48.01 | 48.72 | 47.17 | 47.81 | 299775.0 |
| 2016-03-28 | GC | Futures | 1569.7 | 1579.1 | 1556.6 | 1575.1 | 88834.0 |
| 2016-03-28 | ZN | Futures | 124.710287 | 125.012029 | 124.529241 | 124.951681 | 427322.0 |
| 2016-03-28 | A6 | Futures | 0.75796 | 0.76231 | 0.75563 | 0.76069 | 37060.0 |
| 2016-03-28 | AD | Futures | 0.77042 | 0.77656 | 0.76971 | 0.77574 | 29925.0 |
| 2016-03-28 | ALI | Futures | 2055.59 | 2055.59 | 2055.59 | 2055.59 | 0.0 |
| 2016-03-28 | B | Futures | 34.28 | 34.66 | 33.5 | 34.04 | 76779.0 |
| 2016-03-28 | B6 | Futures | 1.4889 | 1.5044 | 1.4872 | 1.5009 | 49592.0 |
| 2016-03-28 | BR | Futures | 0.17365 | 0.17677 | 0.17365 | 0.17648 | 731.0 |
| 2016-03-28 | BZ | Futures | 33.74 | 34.26 | 33.18 | 33.69 | 8403.0 |
| 2016-03-28 | CB | Futures | 245.415 | 245.415 | 245.415 | 245.415 | 1.0 |
| 2016-03-28 | CC | Futures | 2157.0 | 2197.0 | 2157.0 | 2175.0 | 7334.0 |
| 2016-03-28 | CNH | Futures | 7.1192 | 7.1199 | 7.1073 | 7.1073 | 28.0 |
| 2016-03-28 | CSC | Futures | 3.603 | 3.639 | 3.601 | 3.623 | 29.0 |
| 2016-03-28 | CT | Futures | 66.2 | 66.6 | 65.69 | 66.38 | 9219.0 |
| 2016-03-28 | DC | Futures | 28.51 | 28.73 | 28.36 | 28.46 | 126.0 |
| 2016-03-28 | DX | Futures | 89.754 | 89.894 | 89.353 | 89.446 | 10596.0 |
| 2016-03-28 | E1 | Futures | 1.29002 | 1.29655 | 1.28562 | 1.29466 | 7655.0 |
| 2016-03-28 | E6 | Futures | 1.30456 | 1.31155 | 1.30368 | 1.3094 | 72723.0 |
| 2016-03-28 | E7 | Futures | 1.2974 | 1.3044 | 1.2968 | 1.3023 | 1407.0 |
| 2016-03-28 | ED | Futures | 95.6485 | 95.663 | 95.6485 | 95.663 | 60396.0 |
| 2016-03-28 | ER | Futures | 98.254 | 98.254 | 98.254 | 98.254 | 0.0 |
| 2016-03-28 | EW | Futures | 1492.7 | 1498.6 | 1484.5 | 1493.1 | 10218.0 |
| 2016-03-28 | GF | Futures | 306.704 | 307.538 | 304.397 | 305.428 | 2219.0 |
| 2016-03-28 | GSCI | Futures | 493.31 | 493.31 | 492.78 | 492.78 | 1.0 |
| 2016-03-28 | HE | Futures | 98.57 | 102.262 | 98.57 | 100.528 | 175.0 |
| 2016-03-28 | HG | Futures | 2.7969 | 2.8206 | 2.7781 | 2.8087 | 26258.0 |
| 2016-03-28 | HH | Futures | 19.602 | 20.523 | 19.56 | 20.48 | 1879.0 |
| 2016-03-28 | HO | Futures | 0.8893 | 0.9081 | 0.8772 | 0.8867 | 13754.0 |
| 2016-03-28 | HRC | Futures | 1442.7 | 1442.7 | 1442.7 | 1442.7 | 0.0 |
| 2016-03-28 | J1 | Futures | 0.010994 | 0.0110033 | 0.0109512 | 0.0109928 | 48438.0 |
| 2016-03-28 | J7 | Futures | 0.010981 | 0.01099 | 0.010939 | 0.010978 | 649.0 |
| 2016-03-28 | JB | Futures | 138.59 | 138.71 | 138.52 | 138.6 | 659.0 |
| 2016-03-28 | KC | Futures | 188.57 | 191.67 | 187.16 | 190.2 | 17887.0 |
| 2016-03-28 | KE | Futures | 1319.37 | 1356.42 | 1317.27 | 1334.05 | 15609.0 |
| 2016-03-28 | LBS | Futures | 445.9 | 463.8 | 445.5 | 463.8 | 458.0 |
| 2016-03-28 | LE | Futures | 167.687 | 168.49 | 167.219 | 167.988 | 22525.0 |
| 2016-03-28 | MFS | Futures | 1605.3 | 1611.2 | 1603.5 | 1608.0 | 10751.0 |
| 2016-03-28 | MGC | Futures | 1568.5 | 1575.8 | 1550.2 | 1572.1 | 2388.0 |
| 2016-03-28 | MME | Futures | 811.9 | 814.6 | 810.2 | 813.3 | 29183.0 |
| 2016-03-28 | MP | Futures | 0.03587 | 0.03629 | 0.03582 | 0.03628 | 19274.0 |
| 2016-03-28 | N6 | Futures | 0.64187 | 0.64659 | 0.64023 | 0.64592 | 6262.0 |
| 2016-03-28 | NG | Futures | 25.86 | 26.956 | 25.499 | 26.873 | 125420.0 |
| 2016-03-28 | NIY | Futures | 14334.5 | 14478.9 | 14292.0 | 14398.2 | 24724.0 |
| 2016-03-28 | NKD | Futures | 15415.4 | 15602.5 | 15410.8 | 15520.3 | 6333.0 |
| 2016-03-28 | NOK | Futures | 0.123906 | 0.124641 | 0.123906 | 0.124588 | 9.0 |
| 2016-03-28 | OJ | Futures | 114.23 | 114.44 | 111.54 | 113.64 | 552.0 |
> showing 50 of 83 rows — these rows as CSV