PREVIEW / futures_daily / 2014-08-01
file: by_date/futures_daily/2014/2014-08-01.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 |
|---|---|---|---|---|---|---|---|
| 2014-08-01 | ES | Futures | 2000.72 | 2007.21 | 1984.36 | 1992.93 | 2886317.0 |
| 2014-08-01 | NQ | Futures | 4488.78 | 4501.18 | 4439.16 | 4468.87 | 462507.0 |
| 2014-08-01 | YM | Futures | 16657.3 | 16697.7 | 16517.1 | 16563.5 | 264173.0 |
| 2014-08-01 | CL | Futures | 179.86 | 180.59 | 178.73 | 180.19 | 274992.0 |
| 2014-08-01 | GC | Futures | 1684.4 | 1703.1 | 1680.2 | 1698.3 | 144988.0 |
| 2014-08-01 | ZN | Futures | 116.37526 | 117.075524 | 116.156427 | 116.944225 | 2342641.0 |
| 2014-08-01 | A6 | Futures | 0.89557 | 0.89972 | 0.89383 | 0.8974 | 127705.0 |
| 2014-08-01 | AD | Futures | 0.93043 | 0.93216 | 0.92708 | 0.92921 | 64481.0 |
| 2014-08-01 | ALI | Futures | 2905.32 | 2905.32 | 2905.32 | 2905.32 | 20.0 |
| 2014-08-01 | B | Futures | 111.44 | 111.96 | 110.34 | 110.81 | 147257.0 |
| 2014-08-01 | B6 | Futures | 1.7745 | 1.7752 | 1.7667 | 1.7688 | 133168.0 |
| 2014-08-01 | BFX | Futures | 3700.2 | 3706.4 | 3700.2 | 3706.4 | 7.0 |
| 2014-08-01 | BR | Futures | 0.22936 | 0.23226 | 0.2292 | 0.23134 | 967.0 |
| 2014-08-01 | BZ | Futures | 112.54 | 112.83 | 111.23 | 111.68 | 14320.0 |
| 2014-08-01 | C | Futures | 2121.0 | 2133.0 | 2085.0 | 2118.0 | 8848.0 |
| 2014-08-01 | CB | Futures | 129.118 | 129.118 | 129.034 | 129.118 | 3.0 |
| 2014-08-01 | CC | Futures | 2364.0 | 2368.0 | 2317.0 | 2356.0 | 20067.0 |
| 2014-08-01 | CNH | Futures | 7.1058 | 7.1073 | 7.1032 | 7.1049 | 7.0 |
| 2014-08-01 | CSC | Futures | 4.546 | 4.578 | 4.544 | 4.578 | 10.0 |
| 2014-08-01 | CT | Futures | 78.63 | 79.44 | 77.38 | 78.83 | 24.0 |
| 2014-08-01 | DC | Futures | 36.98 | 37.45 | 36.81 | 37.37 | 277.0 |
| 2014-08-01 | DX | Futures | 77.39 | 77.471 | 77.139 | 77.245 | 33875.0 |
| 2014-08-01 | E1 | Futures | 1.41084 | 1.41827 | 1.40955 | 1.41558 | 52211.0 |
| 2014-08-01 | E6 | Futures | 1.57993 | 1.58666 | 1.57875 | 1.58465 | 217944.0 |
| 2014-08-01 | E7 | Futures | 1.5695 | 1.5763 | 1.5686 | 1.5743 | 2463.0 |
| 2014-08-01 | ED | Futures | 95.4115 | 95.4162 | 95.4067 | 95.4115 | 146483.0 |
| 2014-08-01 | ER | Futures | 97.886 | 97.891 | 97.881 | 97.886 | 24872.0 |
| 2014-08-01 | EW | Futures | 1421.3 | 1426.1 | 1404.9 | 1417.4 | 30894.0 |
| 2014-08-01 | FBTP | Futures | 92.62 | 92.63 | 91.88 | 92.23 | 94465.0 |
| 2014-08-01 | FBTS | Futures | 98.41 | 98.436 | 98.303 | 98.401 | 11379.0 |
| 2014-08-01 | FCE | Futures | 3373.9 | 3379.9 | 3325.4 | 3342.5 | 149331.0 |
| 2014-08-01 | FDAX | Futures | 10347.9 | 10362.8 | 10079.7 | 10145.8 | 167750.0 |
| 2014-08-01 | FESX | Futures | 2238.3 | 2244.8 | 2196.6 | 2210.2 | 1624858.0 |
| 2014-08-01 | FGBL | Futures | 128.68 | 129.23 | 128.47 | 129.06 | 813259.0 |
| 2014-08-01 | FGBM | Futures | 121.7 | 121.87 | 121.61 | 121.8 | 486888.0 |
| 2014-08-01 | FGBS | Futures | 110.763 | 110.783 | 110.753 | 110.773 | 217243.0 |
| 2014-08-01 | FGBX | Futures | 135.68 | 136.71 | 135.1 | 136.35 | 28602.0 |
| 2014-08-01 | FMWO | Futures | 5665.7 | 5665.7 | 5658.1 | 5658.1 | 83.0 |
| 2014-08-01 | FOAT | Futures | 118.92 | 119.3 | 118.61 | 119.16 | 92489.0 |
| 2014-08-01 | FTDX | Futures | 1128.5 | 1128.5 | 1091.5 | 1112.6 | 1270.0 |
| 2014-08-01 | FTI | Futures | 348.92 | 349.39 | 342.9 | 344.28 | 48042.0 |
| 2014-08-01 | FTUK | Futures | 5116.2 | 5133.9 | 5057.7 | 5096.2 | 129645.0 |
| 2014-08-01 | FVSA | Futures | 1511.27 | 1591.92 | 1490.04 | 1574.94 | 12746.0 |
| 2014-08-01 | FXXP | Futures | 252.2 | 252.5 | 247.9 | 249.0 | 10711.0 |
| 2014-08-01 | G | Futures | 94.5 | 95.09 | 94.34 | 94.94 | 186821.0 |
| 2014-08-01 | GF | Futures | 338.435 | 338.435 | 334.029 | 337.592 | 4066.0 |
| 2014-08-01 | GSCI | Futures | 1036.55 | 1037.64 | 1030.53 | 1031.28 | 179.0 |
| 2014-08-01 | HE | Futures | 123.857 | 125.791 | 123.766 | 124.31 | 13608.0 |
| 2014-08-01 | HG | Futures | 4.1292 | 4.1612 | 4.103 | 4.1088 | 44131.0 |
| 2014-08-01 | HH | Futures | 48.874 | 49.128 | 48.214 | 48.214 | 575.0 |
> showing 50 of 105 rows — these rows as CSV