PREVIEW / futures_daily / 2013-06-24
file: by_date/futures_daily/2013/2013-06-24.parquet size: 9 KB rows: 105
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-24 | ES | Futures | 1631.2 | 1633.78 | 1599.79 | 1613.18 | 2848089.0 |
| 2013-06-24 | NQ | Futures | 3315.82 | 3320.74 | 3259.43 | 3289.8 | 358805.0 |
| 2013-06-24 | YM | Futures | 14584.9 | 14600.7 | 14346.0 | 14459.0 | 295051.0 |
| 2013-06-24 | CL | Futures | 163.48 | 166.51 | 161.42 | 165.79 | 315821.0 |
| 2013-06-24 | GC | Futures | 1720.9 | 1726.7 | 1692.7 | 1695.4 | 160333.0 |
| 2013-06-24 | ZN | Futures | 113.391113 | 113.419187 | 112.310262 | 113.152484 | 1973159.0 |
| 2013-06-24 | A6 | Futures | 0.86113 | 0.86714 | 0.85306 | 0.8647 | 148883.0 |
| 2013-06-24 | AD | Futures | 0.95978 | 0.96049 | 0.95243 | 0.95827 | 115120.0 |
| 2013-06-24 | B | Futures | 97.29 | 98.28 | 96.38 | 97.82 | 254191.0 |
| 2013-06-24 | B6 | Futures | 1.6135 | 1.6206 | 1.6078 | 1.6183 | 140934.0 |
| 2013-06-24 | BFX | Futures | 2959.6 | 2960.8 | 2934.9 | 2947.2 | 45.0 |
| 2013-06-24 | BR | Futures | 0.21578 | 0.21989 | 0.21578 | 0.21955 | 226.0 |
| 2013-06-24 | BZ | Futures | 97.74 | 98.76 | 96.9 | 98.31 | 8744.0 |
| 2013-06-24 | C | Futures | 1524.0 | 1529.0 | 1506.0 | 1516.0 | 3003.0 |
| 2013-06-24 | CB | Futures | 76.422 | 76.78 | 75.106 | 76.182 | 19.0 |
| 2013-06-24 | CC | Futures | 1607.0 | 1614.0 | 1595.0 | 1606.0 | 18749.0 |
| 2013-06-24 | CNH | Futures | 7.1725 | 7.1746 | 7.1683 | 7.1683 | 24.0 |
| 2013-06-24 | CSC | Futures | 3.509 | 3.509 | 3.475 | 3.49 | 84.0 |
| 2013-06-24 | CT | Futures | 102.05 | 103.46 | 100.0 | 100.06 | 88.0 |
| 2013-06-24 | DC | Futures | 26.83 | 26.86 | 26.49 | 26.54 | 483.0 |
| 2013-06-24 | DX | Futures | 79.046 | 79.371 | 78.869 | 78.972 | 42419.0 |
| 2013-06-24 | E1 | Futures | 1.37427 | 1.38147 | 1.37131 | 1.37902 | 37477.0 |
| 2013-06-24 | E6 | Futures | 1.54748 | 1.55185 | 1.54182 | 1.54949 | 278469.0 |
| 2013-06-24 | E7 | Futures | 1.5368 | 1.5417 | 1.5319 | 1.5394 | 4117.0 |
| 2013-06-24 | ED | Futures | 95.2534 | 95.2534 | 95.1722 | 95.2343 | 451821.0 |
| 2013-06-24 | ER | Futures | 97.759 | 97.768 | 97.656 | 97.7 | 264619.0 |
| 2013-06-24 | EW | Futures | 1153.2 | 1153.2 | 1130.9 | 1143.2 | 37170.0 |
| 2013-06-24 | FBTP | Futures | 75.94 | 75.99 | 74.52 | 74.99 | 57357.0 |
| 2013-06-24 | FBTS | Futures | 91.914 | 92.025 | 91.578 | 91.716 | 10778.0 |
| 2013-06-24 | FCE | Futures | 2830.2 | 2845.7 | 2771.6 | 2790.6 | 187597.0 |
| 2013-06-24 | FDAX | Futures | 8607.5 | 8691.9 | 8502.1 | 8551.5 | 163721.0 |
| 2013-06-24 | FDIV | Futures | 115.12 | 115.72 | 114.93 | 115.27 | 66.0 |
| 2013-06-24 | FESX | Futures | 1777.3 | 1791.3 | 1745.7 | 1761.1 | 1636151.0 |
| 2013-06-24 | FEU3 | Futures | 98.29 | 98.315 | 98.29 | 98.31 | 17.0 |
| 2013-06-24 | FGBL | Futures | 117.94 | 118.07 | 117.14 | 117.48 | 1135029.0 |
| 2013-06-24 | FGBM | Futures | 116.03 | 116.06 | 115.4 | 115.72 | 804621.0 |
| 2013-06-24 | FGBS | Futures | 110.003 | 110.083 | 109.908 | 110.018 | 839997.0 |
| 2013-06-24 | FGBX | Futures | 121.87 | 122.79 | 121.37 | 122.16 | 23014.0 |
| 2013-06-24 | FMWO | Futures | 4552.0 | 4552.0 | 4550.7 | 4550.7 | 20.0 |
| 2013-06-24 | FOAT | Futures | 103.64 | 105.23 | 103.64 | 104.38 | 72607.0 |
| 2013-06-24 | FTDX | Futures | 862.3 | 863.7 | 838.2 | 846.7 | 87.0 |
| 2013-06-24 | FTI | Futures | 293.85 | 294.94 | 288.36 | 289.58 | 47212.0 |
| 2013-06-24 | FTUK | Futures | 4566.8 | 4566.8 | 4480.5 | 4484.6 | 122506.0 |
| 2013-06-24 | FVSA | Futures | 3528.58 | 3720.92 | 3513.79 | 3661.74 | 6428.0 |
| 2013-06-24 | FXXP | Futures | 204.9 | 205.7 | 201.5 | 202.0 | 10406.0 |
| 2013-06-24 | G | Futures | 93.93 | 94.23 | 92.99 | 93.25 | 236166.0 |
| 2013-06-24 | GF | Futures | 247.679 | 250.122 | 247.594 | 248.816 | 3393.0 |
| 2013-06-24 | GSCI | Futures | 999.53 | 1008.41 | 995.91 | 1006.19 | 438.0 |
| 2013-06-24 | HE | Futures | 99.409 | 101.401 | 99.259 | 100.554 | 7499.0 |
| 2013-06-24 | HG | Futures | 3.9188 | 3.9334 | 3.7983 | 3.8427 | 29105.0 |
> showing 50 of 105 rows — these rows as CSV