PREVIEW / futures_daily / 2015-08-25
file: by_date/futures_daily/2015/2015-08-25.parquet size: 9 KB rows: 108
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-25 | ES | Futures | 1984.77 | 2065.05 | 1971.26 | 1984.77 | 3658827.0 |
| 2015-08-25 | NQ | Futures | 4667.74 | 4908.54 | 4667.45 | 4703.35 | 630057.0 |
| 2015-08-25 | YM | Futures | 16157.1 | 16782.6 | 16034.9 | 16143.7 | 425744.0 |
| 2015-08-25 | CL | Futures | 62.27 | 65.06 | 62.24 | 64.11 | 375650.0 |
| 2015-08-25 | GC | Futures | 1491.9 | 1492.7 | 1463.9 | 1469.4 | 199685.0 |
| 2015-08-25 | ZN | Futures | 123.05997 | 123.164296 | 122.106132 | 122.150843 | 2400441.0 |
| 2015-08-25 | A6 | Futures | 0.70672 | 0.71741 | 0.70474 | 0.7082 | 130671.0 |
| 2015-08-25 | AD | Futures | 0.76974 | 0.77792 | 0.76565 | 0.76759 | 85441.0 |
| 2015-08-25 | ALI | Futures | 2117.61 | 2117.61 | 2117.61 | 2117.61 | 0.0 |
| 2015-08-25 | B | Futures | 39.51 | 41.06 | 39.4 | 39.93 | 137196.0 |
| 2015-08-25 | B6 | Futures | 1.6587 | 1.6648 | 1.6501 | 1.6507 | 102323.0 |
| 2015-08-25 | BFX | Futures | 3989.1 | 4119.7 | 3989.1 | 4101.0 | 20.0 |
| 2015-08-25 | BR | Futures | 0.16802 | 0.16802 | 0.16568 | 0.16645 | 360.0 |
| 2015-08-25 | BZ | Futures | 39.48 | 41.05 | 39.48 | 39.93 | 19523.0 |
| 2015-08-25 | C | Futures | 2188.0 | 2218.0 | 2184.0 | 2197.0 | 1319.0 |
| 2015-08-25 | CB | Futures | 185.85 | 185.997 | 185.85 | 185.997 | 10.0 |
| 2015-08-25 | CC | Futures | 2271.0 | 2308.0 | 2260.0 | 2279.0 | 18413.0 |
| 2015-08-25 | CNH | Futures | 7.3301 | 7.3548 | 7.2872 | 7.3368 | 68.0 |
| 2015-08-25 | CSC | Futures | 4.424 | 4.424 | 4.424 | 4.424 | 1.0 |
| 2015-08-25 | CT | Futures | 78.87 | 79.1 | 77.35 | 78.02 | 11.0 |
| 2015-08-25 | DC | Futures | 35.3 | 35.57 | 35.21 | 35.57 | 23.0 |
| 2015-08-25 | DX | Futures | 87.543 | 88.671 | 87.524 | 88.502 | 82427.0 |
| 2015-08-25 | E1 | Futures | 1.36351 | 1.36491 | 1.33672 | 1.34675 | 32334.0 |
| 2015-08-25 | E6 | Futures | 1.36099 | 1.36381 | 1.33902 | 1.34266 | 391253.0 |
| 2015-08-25 | E7 | Futures | 1.3536 | 1.3563 | 1.3317 | 1.3352 | 8282.0 |
| 2015-08-25 | EBM | Futures | 268.07 | 275.04 | 267.66 | 271.35 | 7149.0 |
| 2015-08-25 | ED | Futures | 95.675 | 95.6774 | 95.6558 | 95.6606 | 217670.0 |
| 2015-08-25 | ER | Futures | 98.126 | 98.126 | 98.117 | 98.122 | 18961.0 |
| 2015-08-25 | EW | Futures | 1412.0 | 1476.6 | 1411.5 | 1423.9 | 47297.0 |
| 2015-08-25 | FBTP | Futures | 100.55 | 100.71 | 99.82 | 99.95 | 79027.0 |
| 2015-08-25 | FBTS | Futures | 99.999 | 100.017 | 99.955 | 99.99 | 20110.0 |
| 2015-08-25 | FCE | Futures | 3680.5 | 3849.3 | 3680.5 | 3820.8 | 223897.0 |
| 2015-08-25 | FDAX | Futures | 10725.1 | 11262.4 | 10725.1 | 11234.7 | 191985.0 |
| 2015-08-25 | FDIV | Futures | 136.13 | 136.96 | 136.13 | 136.96 | 2.0 |
| 2015-08-25 | FESX | Futures | 2285.3 | 2397.1 | 2285.3 | 2389.0 | 2600341.0 |
| 2015-08-25 | FEU3 | Futures | 98.769 | 98.769 | 98.769 | 98.769 | 80.0 |
| 2015-08-25 | FGBL | Futures | 138.61 | 138.69 | 136.84 | 137.02 | 1026063.0 |
| 2015-08-25 | FGBM | Futures | 124.95 | 125.03 | 124.53 | 124.58 | 661390.0 |
| 2015-08-25 | FGBS | Futures | 111.283 | 111.298 | 111.233 | 111.238 | 345677.0 |
| 2015-08-25 | FGBX | Futures | 161.35 | 161.51 | 155.78 | 156.33 | 43801.0 |
| 2015-08-25 | FMWO | Futures | 5353.5 | 5418.8 | 5353.5 | 5390.5 | 1765.0 |
| 2015-08-25 | FOAT | Futures | 125.92 | 126.09 | 124.4 | 124.57 | 98751.0 |
| 2015-08-25 | FTDX | Futures | 1510.9 | 1570.3 | 1507.2 | 1569.3 | 1003.0 |
| 2015-08-25 | FTI | Futures | 361.59 | 379.14 | 361.59 | 375.49 | 73736.0 |
| 2015-08-25 | FTUK | Futures | 4712.6 | 4856.5 | 4702.7 | 4838.6 | 241971.0 |
| 2015-08-25 | FVSA | Futures | 2271.08 | 2454.65 | 2164.36 | 2241.2 | 17644.0 |
| 2015-08-25 | FXXP | Futures | 264.9 | 275.2 | 264.9 | 274.3 | 44091.0 |
| 2015-08-25 | G | Futures | 104.59 | 104.8 | 103.85 | 104.02 | 357455.0 |
| 2015-08-25 | GF | Futures | 343.967 | 347.416 | 341.209 | 343.795 | 2073.0 |
| 2015-08-25 | GSCI | Futures | 567.36 | 567.36 | 557.3 | 560.6 | 131.0 |
> showing 50 of 108 rows — these rows as CSV