PREVIEW / futures_daily / 2015-01-06
file: by_date/futures_daily/2015/2015-01-06.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-01-06 | ES | Futures | 2116.17 | 2120.89 | 2079.75 | 2090.49 | 2345361.0 |
| 2015-01-06 | NQ | Futures | 4834.35 | 4841.32 | 4736.31 | 4759.81 | 426154.0 |
| 2015-01-06 | YM | Futures | 17792.8 | 17825.4 | 17493.3 | 17609.5 | 257163.0 |
| 2015-01-06 | CL | Futures | 97.93 | 98.65 | 93.13 | 93.87 | 451642.0 |
| 2015-01-06 | GC | Futures | 1575.9 | 1601.2 | 1572.8 | 1596.1 | 190357.0 |
| 2015-01-06 | ZN | Futures | 120.364721 | 121.64551 | 120.35 | 120.938868 | 1739806.0 |
| 2015-01-06 | A6 | Futures | 0.78827 | 0.79513 | 0.78788 | 0.79023 | 90176.0 |
| 2015-01-06 | AD | Futures | 0.86454 | 0.86688 | 0.85894 | 0.86057 | 58986.0 |
| 2015-01-06 | ALI | Futures | 2745.26 | 2745.26 | 2745.26 | 2745.26 | 6.0 |
| 2015-01-06 | B | Futures | 55.38 | 55.81 | 52.64 | 53.24 | 244287.0 |
| 2015-01-06 | B6 | Futures | 1.6026 | 1.6051 | 1.5912 | 1.5934 | 100904.0 |
| 2015-01-06 | BFX | Futures | 3895.8 | 3895.8 | 3865.6 | 3865.6 | 27.0 |
| 2015-01-06 | BR | Futures | 0.20163 | 0.20212 | 0.20157 | 0.20171 | 71.0 |
| 2015-01-06 | BZ | Futures | 55.48 | 56.08 | 52.94 | 53.53 | 34808.0 |
| 2015-01-06 | C | Futures | 2201.0 | 2203.0 | 2173.0 | 2183.0 | 5688.0 |
| 2015-01-06 | CB | Futures | 131.01 | 131.441 | 131.01 | 131.03 | 19.0 |
| 2015-01-06 | CC | Futures | 2162.0 | 2171.0 | 2131.0 | 2142.0 | 11598.0 |
| 2015-01-06 | CNH | Futures | 7.1155 | 7.1161 | 7.1055 | 7.1055 | 37.0 |
| 2015-01-06 | CSC | Futures | 4.435 | 4.444 | 4.322 | 4.342 | 109.0 |
| 2015-01-06 | CT | Futures | 77.33 | 78.23 | 76.76 | 76.89 | 12353.0 |
| 2015-01-06 | DC | Futures | 34.62 | 34.85 | 33.87 | 34.22 | 230.0 |
| 2015-01-06 | DX | Futures | 86.678 | 87.018 | 86.531 | 86.837 | 44993.0 |
| 2015-01-06 | E1 | Futures | 1.26951 | 1.27309 | 1.26466 | 1.26798 | 45397.0 |
| 2015-01-06 | E6 | Futures | 1.40468 | 1.4088 | 1.3988 | 1.40221 | 237144.0 |
| 2015-01-06 | E7 | Futures | 1.3964 | 1.4003 | 1.3905 | 1.3938 | 6002.0 |
| 2015-01-06 | EBM | Futures | 328.87 | 330.09 | 327.66 | 328.87 | 18729.0 |
| 2015-01-06 | ED | Futures | 95.445 | 95.4498 | 95.4402 | 95.445 | 176223.0 |
| 2015-01-06 | ER | Futures | 98.028 | 98.033 | 98.023 | 98.033 | 42854.0 |
| 2015-01-06 | EW | Futures | 1493.3 | 1495.8 | 1464.6 | 1470.8 | 24339.0 |
| 2015-01-06 | FBTP | Futures | 99.19 | 99.66 | 98.82 | 99.11 | 65078.0 |
| 2015-01-06 | FBTS | Futures | 98.774 | 98.89 | 98.695 | 98.757 | 13383.0 |
| 2015-01-06 | FCE | Futures | 3363.5 | 3388.8 | 3315.8 | 3333.3 | 148608.0 |
| 2015-01-06 | FDAX | Futures | 10519.1 | 10692.8 | 10417.5 | 10537.4 | 149313.0 |
| 2015-01-06 | FDIV | Futures | 135.07 | 135.07 | 134.83 | 134.83 | 10.0 |
| 2015-01-06 | FESX | Futures | 2177.3 | 2202.6 | 2148.5 | 2164.4 | 1526548.0 |
| 2015-01-06 | FEU3 | Futures | 98.65 | 98.65 | 98.65 | 98.65 | 2.0 |
| 2015-01-06 | FGBL | Futures | 136.94 | 137.64 | 136.84 | 137.39 | 735017.0 |
| 2015-01-06 | FGBM | Futures | 123.86 | 123.95 | 123.84 | 123.91 | 338609.0 |
| 2015-01-06 | FGBS | Futures | 110.993 | 111.008 | 110.983 | 110.993 | 176688.0 |
| 2015-01-06 | FGBX | Futures | 157.74 | 161.69 | 157.64 | 160.99 | 47714.0 |
| 2015-01-06 | FMWO | Futures | 5483.8 | 5483.8 | 5443.0 | 5443.0 | 327.0 |
| 2015-01-06 | FOAT | Futures | 126.16 | 126.75 | 126.0 | 126.49 | 79016.0 |
| 2015-01-06 | FTDX | Futures | 1276.4 | 1293.3 | 1248.7 | 1279.7 | 190.0 |
| 2015-01-06 | FTI | Futures | 355.93 | 359.01 | 351.61 | 353.47 | 47721.0 |
| 2015-01-06 | FTUK | Futures | 4954.2 | 4981.8 | 4884.0 | 4916.0 | 145422.0 |
| 2015-01-06 | FVSA | Futures | 2157.0 | 2195.79 | 2060.01 | 2191.91 | 12378.0 |
| 2015-01-06 | FXXP | Futures | 251.3 | 252.3 | 247.9 | 248.6 | 17576.0 |
| 2015-01-06 | G | Futures | 103.85 | 104.92 | 103.85 | 104.47 | 208429.0 |
| 2015-01-06 | GF | Futures | 363.256 | 365.021 | 354.913 | 360.528 | 3394.0 |
| 2015-01-06 | GSCI | Futures | 681.91 | 689.41 | 675.09 | 678.5 | 262.0 |
> showing 50 of 108 rows — these rows as CSV