PREVIEW / futures_daily / 2015-10-12
file: by_date/futures_daily/2015/2015-10-12.parquet size: 9 KB rows: 104
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-10-12 | ES | Futures | 2133.09 | 2142.4 | 2129.37 | 2139.2 | 804576.0 |
| 2015-10-12 | NQ | Futures | 5091.9 | 5122.89 | 5081.67 | 5115.29 | 132675.0 |
| 2015-10-12 | YM | Futures | 17511.3 | 17642.4 | 17481.4 | 17581.5 | 67274.0 |
| 2015-10-12 | CL | Futures | 79.52 | 80.52 | 75.55 | 75.65 | 408663.0 |
| 2015-10-12 | GC | Futures | 1491.0 | 1508.5 | 1490.1 | 1503.2 | 111800.0 |
| 2015-10-12 | ZN | Futures | 123.15271 | 123.39219 | 123.03297 | 123.347288 | 154259.0 |
| 2015-10-12 | A6 | Futures | 0.73013 | 0.73594 | 0.72823 | 0.73514 | 62561.0 |
| 2015-10-12 | AD | Futures | 0.79053 | 0.7936 | 0.78695 | 0.78971 | 38580.0 |
| 2015-10-12 | ALI | Futures | 2167.75 | 2167.75 | 2167.75 | 2167.75 | 40.0 |
| 2015-10-12 | B | Futures | 47.48 | 48.0 | 44.9 | 44.98 | 282586.0 |
| 2015-10-12 | B6 | Futures | 1.6126 | 1.6185 | 1.6122 | 1.617 | 40782.0 |
| 2015-10-12 | BFX | Futures | 4143.3 | 4143.3 | 4139.7 | 4139.7 | 1.0 |
| 2015-10-12 | BR | Futures | 0.16217 | 0.16592 | 0.16217 | 0.16509 | 446.0 |
| 2015-10-12 | BZ | Futures | 47.07 | 47.72 | 44.68 | 44.73 | 30736.0 |
| 2015-10-12 | C | Futures | 2223.0 | 2243.0 | 2202.0 | 2229.0 | 8745.0 |
| 2015-10-12 | CB | Futures | 184.964 | 184.964 | 184.964 | 184.964 | 1.0 |
| 2015-10-12 | CC | Futures | 2243.0 | 2272.0 | 2219.0 | 2254.0 | 18843.0 |
| 2015-10-12 | CNH | Futures | 7.0867 | 7.0867 | 7.057 | 7.057 | 89.0 |
| 2015-10-12 | CSC | Futures | 4.365 | 4.365 | 4.365 | 4.365 | 2.0 |
| 2015-10-12 | CT | Futures | 74.16 | 74.6 | 73.79 | 74.0 | 10688.0 |
| 2015-10-12 | DC | Futures | 35.28 | 35.52 | 35.28 | 35.5 | 54.0 |
| 2015-10-12 | DX | Futures | 88.794 | 88.794 | 88.536 | 88.63 | 15582.0 |
| 2015-10-12 | E1 | Futures | 1.32209 | 1.3245 | 1.31968 | 1.32298 | 9054.0 |
| 2015-10-12 | E6 | Futures | 1.33227 | 1.33637 | 1.33134 | 1.33403 | 77440.0 |
| 2015-10-12 | E7 | Futures | 1.3252 | 1.3289 | 1.3243 | 1.3267 | 1916.0 |
| 2015-10-12 | EBM | Futures | 260.88 | 263.07 | 259.78 | 262.71 | 18245.0 |
| 2015-10-12 | ED | Futures | 95.7352 | 95.7352 | 95.7256 | 95.7304 | 32173.0 |
| 2015-10-12 | ER | Futures | 98.141 | 98.146 | 98.141 | 98.141 | 8156.0 |
| 2015-10-12 | EW | Futures | 1515.2 | 1520.9 | 1512.0 | 1516.5 | 8375.0 |
| 2015-10-12 | FBTP | Futures | 102.82 | 103.01 | 102.64 | 102.95 | 49790.0 |
| 2015-10-12 | FBTS | Futures | 100.382 | 100.409 | 100.373 | 100.382 | 10950.0 |
| 2015-10-12 | FCE | Futures | 3912.8 | 3926.1 | 3886.1 | 3907.4 | 28432.0 |
| 2015-10-12 | FDAX | Futures | 11146.4 | 11220.7 | 11072.0 | 11159.1 | 67167.0 |
| 2015-10-12 | FESX | Futures | 2434.3 | 2441.8 | 2414.0 | 2430.5 | 614908.0 |
| 2015-10-12 | FGBL | Futures | 138.84 | 139.23 | 138.66 | 139.19 | 272324.0 |
| 2015-10-12 | FGBM | Futures | 125.2 | 125.34 | 125.16 | 125.31 | 203743.0 |
| 2015-10-12 | FGBS | Futures | 111.283 | 111.308 | 111.273 | 111.293 | 122195.0 |
| 2015-10-12 | FGBX | Futures | 157.73 | 158.92 | 157.2 | 158.67 | 15109.0 |
| 2015-10-12 | FMWO | Futures | 5585.3 | 5585.3 | 5574.2 | 5580.4 | 162.0 |
| 2015-10-12 | FOAT | Futures | 127.09 | 127.46 | 126.98 | 127.43 | 45243.0 |
| 2015-10-12 | FTDX | Futures | 1674.2 | 1678.0 | 1656.6 | 1665.2 | 163.0 |
| 2015-10-12 | FTI | Futures | 383.5 | 384.89 | 380.93 | 382.06 | 6760.0 |
| 2015-10-12 | FTUK | Futures | 5118.9 | 5134.6 | 5084.3 | 5101.2 | 67937.0 |
| 2015-10-12 | FVSA | Futures | 2251.61 | 2251.61 | 2182.69 | 2214.85 | 5687.0 |
| 2015-10-12 | FXXP | Futures | 282.0 | 283.1 | 280.3 | 281.4 | 20848.0 |
| 2015-10-12 | G | Futures | 104.61 | 104.95 | 104.52 | 104.87 | 57993.0 |
| 2015-10-12 | GF | Futures | 335.533 | 339.779 | 335.307 | 337.159 | 5317.0 |
| 2015-10-12 | GSCI | Futures | 617.39 | 617.39 | 598.49 | 598.9 | 2642.0 |
| 2015-10-12 | HE | Futures | 99.198 | 100.395 | 99.198 | 99.46 | 8734.0 |
| 2015-10-12 | HG | Futures | 3.0275 | 3.0507 | 3.0094 | 3.0238 | 36225.0 |
> showing 50 of 104 rows — these rows as CSV