PREVIEW / futures_daily / 2015-08-31
file: by_date/futures_daily/2015/2015-08-31.parquet size: 9 KB rows: 102
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 |
|---|---|---|---|---|---|---|---|
| 2015-08-31 | ES | Futures | 2105.06 | 2106.65 | 2076.45 | 2087.05 | 1876279.0 |
| 2015-08-31 | NQ | Futures | 5048.35 | 5055.65 | 4971.88 | 4987.35 | 303204.0 |
| 2015-08-31 | YM | Futures | 17084.5 | 17084.5 | 16861.6 | 16954.1 | 186864.0 |
| 2015-08-31 | CL | Futures | 73.4 | 80.46 | 71.11 | 80.25 | 757503.0 |
| 2015-08-31 | GC | Futures | 1462.2 | 1466.8 | 1452.2 | 1461.9 | 98950.0 |
| 2015-08-31 | ZN | Futures | 121.629213 | 122.255169 | 121.524887 | 121.748443 | 262060.0 |
| 2015-08-31 | A6 | Futures | 0.70909 | 0.70919 | 0.70087 | 0.70503 | 61664.0 |
| 2015-08-31 | AD | Futures | 0.77383 | 0.77946 | 0.76719 | 0.77588 | 71451.0 |
| 2015-08-31 | ALI | Futures | 2187.1 | 2187.1 | 2187.1 | 2187.1 | 0.0 |
| 2015-08-31 | B | Futures | 45.99 | 49.97 | 44.45 | 49.84 | 111470.0 |
| 2015-08-31 | B6 | Futures | 1.6212 | 1.6246 | 1.6144 | 1.6154 | 63877.0 |
| 2015-08-31 | BFX | Futures | 4162.1 | 4186.9 | 4162.1 | 4186.9 | 3.0 |
| 2015-08-31 | BR | Futures | 0.16488 | 0.16488 | 0.16223 | 0.16463 | 409.0 |
| 2015-08-31 | BZ | Futures | 45.4 | 49.89 | 44.44 | 49.83 | 21614.0 |
| 2015-08-31 | CB | Futures | 182.061 | 184.989 | 182.061 | 184.029 | 22.0 |
| 2015-08-31 | CC | Futures | 2253.0 | 2281.0 | 2247.0 | 2272.0 | 11447.0 |
| 2015-08-31 | CNH | Futures | 7.25 | 7.2537 | 7.248 | 7.248 | 40.0 |
| 2015-08-31 | CSC | Futures | 4.414 | 4.458 | 4.414 | 4.452 | 22.0 |
| 2015-08-31 | CT | Futures | 78.44 | 78.44 | 78.0 | 78.0 | 1.0 |
| 2015-08-31 | DC | Futures | 35.34 | 35.61 | 35.1 | 35.61 | 61.0 |
| 2015-08-31 | DX | Futures | 90.042 | 90.108 | 89.527 | 89.728 | 36265.0 |
| 2015-08-31 | E1 | Futures | 1.31932 | 1.32504 | 1.31094 | 1.31513 | 14139.0 |
| 2015-08-31 | E6 | Futures | 1.31353 | 1.32339 | 1.31317 | 1.32034 | 175893.0 |
| 2015-08-31 | E7 | Futures | 1.3062 | 1.3159 | 1.3058 | 1.3131 | 4048.0 |
| 2015-08-31 | EBM | Futures | 263.97 | 264.79 | 260.28 | 262.74 | 2682.0 |
| 2015-08-31 | ED | Futures | 95.639 | 95.6438 | 95.6294 | 95.6318 | 100156.0 |
| 2015-08-31 | ER | Futures | 98.122 | 98.126 | 98.122 | 98.126 | 8753.0 |
| 2015-08-31 | EW | Futures | 1495.1 | 1496.7 | 1480.1 | 1482.7 | 21781.0 |
| 2015-08-31 | FBTP | Futures | 100.53 | 100.68 | 100.16 | 100.36 | 43771.0 |
| 2015-08-31 | FBTS | Futures | 100.008 | 100.044 | 99.973 | 100.035 | 7803.0 |
| 2015-08-31 | FCE | Futures | 3874.0 | 3911.7 | 3858.5 | 3895.7 | 70765.0 |
| 2015-08-31 | FDAX | Futures | 11266.8 | 11396.7 | 11198.3 | 11328.2 | 76775.0 |
| 2015-08-31 | FESX | Futures | 2406.0 | 2432.6 | 2395.6 | 2419.3 | 830499.0 |
| 2015-08-31 | FEU3 | Futures | 98.769 | 98.774 | 98.769 | 98.769 | 14.0 |
| 2015-08-31 | FGBL | Futures | 137.18 | 137.4 | 136.2 | 136.59 | 401970.0 |
| 2015-08-31 | FGBM | Futures | 124.6 | 124.66 | 124.32 | 124.44 | 356365.0 |
| 2015-08-31 | FGBS | Futures | 111.188 | 111.203 | 111.153 | 111.183 | 296021.0 |
| 2015-08-31 | FGBX | Futures | 155.93 | 156.56 | 152.68 | 153.82 | 18265.0 |
| 2015-08-31 | FMWO | Futures | 5461.8 | 5461.8 | 5443.4 | 5458.1 | 244.0 |
| 2015-08-31 | FOAT | Futures | 125.02 | 125.12 | 124.28 | 124.51 | 47862.0 |
| 2015-08-31 | FTDX | Futures | 1596.7 | 1609.4 | 1582.5 | 1605.1 | 653.0 |
| 2015-08-31 | FTI | Futures | 379.92 | 384.61 | 378.67 | 382.71 | 22085.0 |
| 2015-08-31 | FVSA | Futures | 2394.88 | 2493.07 | 2386.34 | 2463.18 | 4563.0 |
| 2015-08-31 | FXXP | Futures | 276.7 | 279.7 | 276.3 | 278.6 | 12644.0 |
| 2015-08-31 | GF | Futures | 348.752 | 352.976 | 347.502 | 347.976 | 1685.0 |
| 2015-08-31 | GSCI | Futures | 603.65 | 629.05 | 591.19 | 628.88 | 345.0 |
| 2015-08-31 | HE | Futures | 91.174 | 93.772 | 90.798 | 93.02 | 14912.0 |
| 2015-08-31 | HG | Futures | 2.9305 | 2.9368 | 2.8711 | 2.9261 | 35478.0 |
| 2015-08-31 | HH | Futures | 32.417 | 32.82 | 32.331 | 32.82 | 923.0 |
| 2015-08-31 | HO | Futures | 1.2709 | 1.3662 | 1.24 | 1.3637 | 22765.0 |
> showing 50 of 102 rows — these rows as CSV