PREVIEW / futures_daily / 2013-06-13
file: by_date/futures_daily/2013/2013-06-13.parquet size: 9 KB rows: 101
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-06-13 | ES | Futures | 1653.69 | 1683.21 | 1640.09 | 1680.39 | 2359119.0 |
| 2013-06-13 | NQ | Futures | 3376.04 | 3430.04 | 3347.16 | 3421.66 | 284586.0 |
| 2013-06-13 | YM | Futures | 14773.2 | 15003.2 | 14674.1 | 14983.3 | 30990.0 |
| 2013-06-13 | CL | Futures | 167.2 | 169.21 | 165.9 | 168.82 | 113128.0 |
| 2013-06-13 | GC | Futures | 1841.8 | 1851.1 | 1822.7 | 1829.1 | 127783.0 |
| 2013-06-13 | ZN | Futures | 115.552816 | 116.296778 | 115.496668 | 115.903741 | 1655883.0 |
| 2013-06-13 | A6 | Futures | 0.88318 | 0.90007 | 0.87877 | 0.89519 | 121619.0 |
| 2013-06-13 | AD | Futures | 0.98467 | 0.99081 | 0.98306 | 0.98719 | 48281.0 |
| 2013-06-13 | B | Futures | 100.05 | 101.66 | 99.39 | 101.49 | 216422.0 |
| 2013-06-13 | B6 | Futures | 1.6431 | 1.6491 | 1.6395 | 1.6448 | 88538.0 |
| 2013-06-13 | BR | Futures | 0.22673 | 0.22975 | 0.22673 | 0.2274 | 49.0 |
| 2013-06-13 | BZ | Futures | 100.38 | 102.15 | 99.91 | 102.0 | 5826.0 |
| 2013-06-13 | C | Futures | 1649.0 | 1649.0 | 1612.0 | 1616.0 | 8619.0 |
| 2013-06-13 | CB | Futures | 78.933 | 78.933 | 78.694 | 78.802 | 66.0 |
| 2013-06-13 | CC | Futures | 1771.0 | 1775.0 | 1721.0 | 1726.0 | 26307.0 |
| 2013-06-13 | CNH | Futures | 7.1622 | 7.1622 | 7.1568 | 7.1568 | 40.0 |
| 2013-06-13 | CSC | Futures | 3.549 | 3.549 | 3.541 | 3.543 | 14.0 |
| 2013-06-13 | CT | Futures | 107.86 | 110.04 | 105.98 | 109.92 | 29188.0 |
| 2013-06-13 | DC | Futures | 27.22 | 27.26 | 27.06 | 27.1 | 319.0 |
| 2013-06-13 | DX | Futures | 77.459 | 77.612 | 77.134 | 77.375 | 39296.0 |
| 2013-06-13 | E1 | Futures | 1.39766 | 1.40897 | 1.38969 | 1.39573 | 21170.0 |
| 2013-06-13 | E6 | Futures | 1.5751 | 1.58111 | 1.56778 | 1.57569 | 148303.0 |
| 2013-06-13 | E7 | Futures | 1.5675 | 1.5706 | 1.5578 | 1.5654 | 2222.0 |
| 2013-06-13 | ED | Futures | 95.2725 | 95.2869 | 95.263 | 95.2773 | 298538.0 |
| 2013-06-13 | ER | Futures | 97.817 | 97.827 | 97.813 | 97.817 | 124266.0 |
| 2013-06-13 | EW | Futures | 1169.5 | 1198.0 | 1162.1 | 1196.1 | 26680.0 |
| 2013-06-13 | FBTP | Futures | 77.42 | 77.95 | 77.11 | 77.7 | 52308.0 |
| 2013-06-13 | FBTS | Futures | 92.447 | 92.541 | 92.335 | 92.421 | 15744.0 |
| 2013-06-13 | FCE | Futures | 2907.4 | 2962.1 | 2890.0 | 2940.0 | 66527.0 |
| 2013-06-13 | FDAX | Futures | 8928.1 | 9083.2 | 8856.4 | 9009.3 | 160930.0 |
| 2013-06-13 | FESX | Futures | 1841.1 | 1879.7 | 1829.9 | 1865.7 | 352489.0 |
| 2013-06-13 | FEU3 | Futures | 98.433 | 98.433 | 98.423 | 98.428 | 195.0 |
| 2013-06-13 | FGBL | Futures | 119.74 | 120.1 | 119.66 | 119.89 | 818015.0 |
| 2013-06-13 | FGBM | Futures | 117.05 | 117.36 | 117.03 | 117.28 | 571832.0 |
| 2013-06-13 | FGBS | Futures | 110.208 | 110.293 | 110.208 | 110.283 | 497974.0 |
| 2013-06-13 | FGBX | Futures | 125.2 | 125.84 | 125.05 | 125.38 | 14100.0 |
| 2013-06-13 | FMWO | Futures | 4774.8 | 4774.8 | 4774.8 | 4774.8 | 0.0 |
| 2013-06-13 | FOAT | Futures | 106.83 | 107.11 | 106.76 | 107.0 | 40017.0 |
| 2013-06-13 | FTDX | Futures | 888.2 | 889.6 | 878.3 | 889.6 | 6.0 |
| 2013-06-13 | FTI | Futures | 299.69 | 304.92 | 298.34 | 302.82 | 2790.0 |
| 2013-06-13 | FTUK | Futures | 4651.1 | 4726.5 | 4620.4 | 4698.0 | 33148.0 |
| 2013-06-13 | FVSA | Futures | 3299.26 | 3432.42 | 3269.67 | 3299.26 | 4728.0 |
| 2013-06-13 | FXXP | Futures | 210.0 | 213.5 | 209.8 | 213.5 | 5039.0 |
| 2013-06-13 | G | Futures | 96.72 | 96.88 | 96.43 | 96.77 | 181770.0 |
| 2013-06-13 | GF | Futures | 245.32 | 246.204 | 244.014 | 245.109 | 1490.0 |
| 2013-06-13 | GSCI | Futures | 1020.75 | 1032.93 | 1019.85 | 1032.93 | 2942.0 |
| 2013-06-13 | HE | Futures | 99.359 | 99.384 | 98.164 | 98.263 | 21344.0 |
| 2013-06-13 | HG | Futures | 4.1029 | 4.1322 | 4.0265 | 4.0577 | 76425.0 |
| 2013-06-13 | HH | Futures | 41.901 | 43.204 | 41.901 | 42.856 | 2247.0 |
| 2013-06-13 | HO | Futures | 2.3261 | 2.3716 | 2.3133 | 2.3642 | 22723.0 |
> showing 50 of 101 rows — these rows as CSV