PREVIEW / futures_daily / 2015-10-05
file: by_date/futures_daily/2015/2015-10-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-10-05 | ES | Futures | 2064.74 | 2106.23 | 2060.75 | 2100.64 | 1675519.0 |
| 2015-10-05 | NQ | Futures | 4978.2 | 5062.38 | 4969.72 | 5040.75 | 242309.0 |
| 2015-10-05 | YM | Futures | 16873.7 | 17224.5 | 16846.9 | 17188.4 | 152349.0 |
| 2015-10-05 | CL | Futures | 73.32 | 75.39 | 72.61 | 74.3 | 323061.0 |
| 2015-10-05 | GC | Futures | 1467.7 | 1473.7 | 1458.2 | 1468.5 | 119484.0 |
| 2015-10-05 | ZN | Futures | 123.856183 | 124.020826 | 123.362255 | 123.407158 | 898156.0 |
| 2015-10-05 | A6 | Futures | 0.70303 | 0.70863 | 0.70183 | 0.70653 | 59059.0 |
| 2015-10-05 | AD | Futures | 0.77865 | 0.78377 | 0.77711 | 0.78295 | 51370.0 |
| 2015-10-05 | ALI | Futures | 2097.77 | 2097.77 | 2097.77 | 2097.77 | 0.0 |
| 2015-10-05 | B | Futures | 43.68 | 45.18 | 43.42 | 44.64 | 190591.0 |
| 2015-10-05 | B6 | Futures | 1.5978 | 1.6049 | 1.5934 | 1.5953 | 79154.0 |
| 2015-10-05 | BFX | Futures | 4147.5 | 4149.4 | 4145.7 | 4145.7 | 6.0 |
| 2015-10-05 | BR | Futures | 0.15358 | 0.15484 | 0.1521 | 0.15453 | 916.0 |
| 2015-10-05 | BZ | Futures | 43.64 | 44.93 | 43.56 | 44.39 | 21339.0 |
| 2015-10-05 | C | Futures | 2266.0 | 2272.0 | 2251.0 | 2266.0 | 7874.0 |
| 2015-10-05 | CB | Futures | 186.982 | 186.982 | 186.686 | 186.686 | 7.0 |
| 2015-10-05 | CC | Futures | 2269.0 | 2277.0 | 2250.0 | 2267.0 | 19003.0 |
| 2015-10-05 | CNH | Futures | 7.1076 | 7.1076 | 7.0988 | 7.0988 | 23.0 |
| 2015-10-05 | CSC | Futures | 4.327 | 4.381 | 4.325 | 4.376 | 57.0 |
| 2015-10-05 | CT | Futures | 72.22 | 74.65 | 72.22 | 74.22 | 21716.0 |
| 2015-10-05 | DC | Futures | 34.94 | 35.39 | 34.83 | 35.3 | 132.0 |
| 2015-10-05 | DX | Futures | 89.78 | 90.061 | 89.364 | 90.009 | 23984.0 |
| 2015-10-05 | E1 | Futures | 1.30852 | 1.31271 | 1.30167 | 1.30281 | 10906.0 |
| 2015-10-05 | E6 | Futures | 1.31529 | 1.32384 | 1.31025 | 1.31107 | 167714.0 |
| 2015-10-05 | E7 | Futures | 1.3081 | 1.3165 | 1.303 | 1.3038 | 3635.0 |
| 2015-10-05 | EBM | Futures | 256.49 | 258.32 | 255.03 | 257.59 | 18962.0 |
| 2015-10-05 | ED | Futures | 95.7448 | 95.7496 | 95.7304 | 95.7352 | 117122.0 |
| 2015-10-05 | ER | Futures | 98.146 | 98.151 | 98.141 | 98.146 | 16710.0 |
| 2015-10-05 | EW | Futures | 1457.0 | 1486.1 | 1454.4 | 1483.2 | 18928.0 |
| 2015-10-05 | FBTP | Futures | 103.44 | 103.59 | 103.01 | 103.06 | 79671.0 |
| 2015-10-05 | FBTS | Futures | 100.418 | 100.436 | 100.409 | 100.436 | 10297.0 |
| 2015-10-05 | FCE | Futures | 3790.3 | 3872.8 | 3767.8 | 3840.7 | 107060.0 |
| 2015-10-05 | FDAX | Futures | 10726.2 | 10895.3 | 10625.4 | 10792.3 | 114843.0 |
| 2015-10-05 | FDIV | Futures | 127.52 | 128.96 | 127.52 | 128.96 | 4.0 |
| 2015-10-05 | FESX | Futures | 2360.8 | 2406.5 | 2339.1 | 2380.3 | 1215988.0 |
| 2015-10-05 | FEU3 | Futures | 98.798 | 98.798 | 98.798 | 98.798 | 5.0 |
| 2015-10-05 | FGBL | Futures | 139.82 | 139.91 | 139.21 | 139.27 | 503816.0 |
| 2015-10-05 | FGBM | Futures | 125.45 | 125.49 | 125.34 | 125.36 | 329531.0 |
| 2015-10-05 | FGBS | Futures | 111.318 | 111.328 | 111.298 | 111.303 | 195500.0 |
| 2015-10-05 | FGBX | Futures | 160.95 | 160.97 | 158.53 | 158.79 | 22813.0 |
| 2015-10-05 | FMWO | Futures | 5451.8 | 5458.0 | 5449.3 | 5451.8 | 250.0 |
| 2015-10-05 | FOAT | Futures | 127.9 | 128.09 | 127.37 | 127.46 | 68943.0 |
| 2015-10-05 | FTDX | Futures | 1678.0 | 1702.6 | 1669.9 | 1687.9 | 219.0 |
| 2015-10-05 | FTI | Futures | 373.21 | 382.41 | 372.38 | 379.16 | 34528.0 |
| 2015-10-05 | FTUK | Futures | 4987.8 | 5077.1 | 4970.1 | 5032.0 | 119738.0 |
| 2015-10-05 | FVSA | Futures | 2579.88 | 2584.5 | 2459.67 | 2538.27 | 12180.0 |
| 2015-10-05 | FXXP | Futures | 276.0 | 280.4 | 274.4 | 278.2 | 27451.0 |
| 2015-10-05 | G | Futures | 105.75 | 105.81 | 105.13 | 105.17 | 151119.0 |
| 2015-10-05 | GF | Futures | 318.71 | 321.373 | 313.472 | 316.269 | 1494.0 |
| 2015-10-05 | GSCI | Futures | 594.46 | 596.34 | 592.83 | 593.4 | 158.0 |
> showing 50 of 107 rows — these rows as CSV