PREVIEW / futures_daily / 2015-08-05
file: by_date/futures_daily/2015/2015-08-05.parquet size: 9 KB rows: 107
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-05 | ES | Futures | 2207.07 | 2233.04 | 2206.8 | 2218.99 | 1384241.0 |
| 2015-08-05 | NQ | Futures | 5313.96 | 5404.45 | 5313.38 | 5363.0 | 247802.0 |
| 2015-08-05 | YM | Futures | 17866.1 | 18070.4 | 17866.1 | 17947.2 | 129595.0 |
| 2015-08-05 | CL | Futures | 76.31 | 77.54 | 74.43 | 74.96 | 367326.0 |
| 2015-08-05 | GC | Futures | 1403.6 | 1409.3 | 1396.7 | 1401.4 | 116045.0 |
| 2015-08-05 | ZN | Futures | 121.241717 | 121.360947 | 120.705183 | 120.898931 | 1288439.0 |
| 2015-08-05 | A6 | Futures | 0.7296 | 0.73098 | 0.72484 | 0.72613 | 81316.0 |
| 2015-08-05 | AD | Futures | 0.77516 | 0.77966 | 0.77363 | 0.77506 | 61844.0 |
| 2015-08-05 | ALI | Futures | 2175.45 | 2175.45 | 2175.45 | 2175.45 | 0.0 |
| 2015-08-05 | B | Futures | 47.0 | 47.7 | 45.89 | 46.42 | 181691.0 |
| 2015-08-05 | B6 | Futures | 1.6379 | 1.6475 | 1.6335 | 1.6412 | 100815.0 |
| 2015-08-05 | BFX | Futures | 4638.6 | 6953.7 | 4638.6 | 6953.7 | 1.0 |
| 2015-08-05 | BR | Futures | 0.1714 | 0.17185 | 0.16973 | 0.16993 | 698.0 |
| 2015-08-05 | BZ | Futures | 47.11 | 47.64 | 45.85 | 46.37 | 24546.0 |
| 2015-08-05 | C | Futures | 2253.0 | 2258.0 | 2205.0 | 2216.0 | 13600.0 |
| 2015-08-05 | CB | Futures | 158.042 | 159.258 | 158.042 | 159.258 | 28.0 |
| 2015-08-05 | CC | Futures | 2327.0 | 2338.0 | 2278.0 | 2295.0 | 21234.0 |
| 2015-08-05 | CNH | Futures | 7.0076 | 7.0077 | 7.0039 | 7.0039 | 28.0 |
| 2015-08-05 | CSC | Futures | 4.508 | 4.526 | 4.475 | 4.478 | 28.0 |
| 2015-08-05 | CT | Futures | 79.57 | 79.57 | 79.24 | 79.24 | 6.0 |
| 2015-08-05 | DC | Futures | 36.01 | 36.22 | 35.86 | 35.94 | 79.0 |
| 2015-08-05 | DX | Futures | 91.807 | 92.05 | 91.414 | 91.769 | 47147.0 |
| 2015-08-05 | E1 | Futures | 1.29989 | 1.30269 | 1.29431 | 1.29761 | 19571.0 |
| 2015-08-05 | E6 | Futures | 1.28004 | 1.28615 | 1.27487 | 1.28063 | 235601.0 |
| 2015-08-05 | E7 | Futures | 1.2727 | 1.2794 | 1.2681 | 1.2736 | 5289.0 |
| 2015-08-05 | EBM | Futures | 291.84 | 293.89 | 289.79 | 293.07 | 15993.0 |
| 2015-08-05 | ED | Futures | 95.6079 | 95.6222 | 95.5983 | 95.6031 | 244379.0 |
| 2015-08-05 | ER | Futures | 98.122 | 98.122 | 98.117 | 98.122 | 12901.0 |
| 2015-08-05 | EW | Futures | 1561.8 | 1585.4 | 1561.8 | 1574.1 | 13941.0 |
| 2015-08-05 | FBTP | Futures | 101.21 | 101.42 | 100.18 | 100.5 | 80337.0 |
| 2015-08-05 | FBTS | Futures | 100.115 | 100.151 | 100.079 | 100.115 | 14421.0 |
| 2015-08-05 | FCE | Futures | 4270.8 | 4340.5 | 4268.8 | 4333.4 | 72265.0 |
| 2015-08-05 | FDAX | Futures | 12691.2 | 12889.1 | 12687.4 | 12879.2 | 91350.0 |
| 2015-08-05 | FESX | Futures | 2683.5 | 2726.4 | 2682.8 | 2723.5 | 857472.0 |
| 2015-08-05 | FEU3 | Futures | 98.764 | 98.764 | 98.764 | 98.764 | 331.0 |
| 2015-08-05 | FGBL | Futures | 137.58 | 137.73 | 136.42 | 136.81 | 656741.0 |
| 2015-08-05 | FGBM | Futures | 124.73 | 124.79 | 124.48 | 124.59 | 435272.0 |
| 2015-08-05 | FGBS | Futures | 111.248 | 111.263 | 111.233 | 111.243 | 187628.0 |
| 2015-08-05 | FGBX | Futures | 157.06 | 157.43 | 153.69 | 154.3 | 32876.0 |
| 2015-08-05 | FMWO | Futures | 5818.7 | 5863.0 | 5818.7 | 5863.0 | 213.0 |
| 2015-08-05 | FOAT | Futures | 125.81 | 125.96 | 124.88 | 125.1 | 65821.0 |
| 2015-08-05 | FTDX | Futures | 1702.2 | 1713.5 | 1702.2 | 1712.5 | 70.0 |
| 2015-08-05 | FTI | Futures | 430.74 | 432.9 | 429.27 | 432.38 | 24968.0 |
| 2015-08-05 | FTUK | Futures | 5271.4 | 5335.8 | 5271.4 | 5321.5 | 82852.0 |
| 2015-08-05 | FVSA | Futures | 1671.2 | 1671.2 | 1601.02 | 1627.33 | 11515.0 |
| 2015-08-05 | FXXP | Futures | 307.5 | 310.3 | 307.2 | 310.0 | 15149.0 |
| 2015-08-05 | G | Futures | 102.44 | 102.57 | 101.78 | 102.04 | 182293.0 |
| 2015-08-05 | GF | Futures | 363.416 | 364.649 | 362.396 | 364.054 | 2088.0 |
| 2015-08-05 | GSCI | Futures | 622.42 | 623.51 | 614.26 | 614.43 | 465.0 |
| 2015-08-05 | HE | Futures | 92.097 | 92.302 | 89.875 | 91.311 | 15013.0 |
> showing 50 of 107 rows — these rows as CSV