PREVIEW / futures_daily / 2015-10-22
file: by_date/futures_daily/2015/2015-10-22.parquet size: 9 KB rows: 106
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-22 | ES | Futures | 2138.67 | 2187.07 | 2136.55 | 2183.88 | 2099217.0 |
| 2015-10-22 | NQ | Futures | 5152.41 | 5338.02 | 5146.86 | 5323.11 | 348494.0 |
| 2015-10-22 | YM | Futures | 17598.0 | 17989.0 | 17583.5 | 17961.2 | 177471.0 |
| 2015-10-22 | CL | Futures | 71.88 | 73.2 | 71.29 | 72.05 | 322742.0 |
| 2015-10-22 | GC | Futures | 1506.2 | 1512.7 | 1499.2 | 1505.3 | 117317.0 |
| 2015-10-22 | ZN | Futures | 123.496963 | 123.661605 | 123.257483 | 123.51193 | 1107265.0 |
| 2015-10-22 | A6 | Futures | 0.71943 | 0.72213 | 0.71643 | 0.71923 | 81398.0 |
| 2015-10-22 | AD | Futures | 0.77957 | 0.78254 | 0.77803 | 0.78162 | 56841.0 |
| 2015-10-22 | ALI | Futures | 2048.7 | 2048.7 | 2048.7 | 2048.7 | 0.0 |
| 2015-10-22 | B | Futures | 42.93 | 43.62 | 42.65 | 43.04 | 201591.0 |
| 2015-10-22 | B6 | Futures | 1.6229 | 1.6338 | 1.6181 | 1.62 | 103241.0 |
| 2015-10-22 | BR | Futures | 0.15352 | 0.15567 | 0.15352 | 0.15475 | 414.0 |
| 2015-10-22 | BZ | Futures | 42.75 | 43.38 | 42.41 | 42.8 | 18472.0 |
| 2015-10-22 | C | Futures | 2282.0 | 2310.0 | 2269.0 | 2282.0 | 5365.0 |
| 2015-10-22 | CB | Futures | 190.451 | 195.839 | 190.451 | 195.839 | 15.0 |
| 2015-10-22 | CC | Futures | 2302.0 | 2335.0 | 2286.0 | 2302.0 | 17014.0 |
| 2015-10-22 | CNH | Futures | 7.1027 | 7.122 | 7.1026 | 7.1168 | 78.0 |
| 2015-10-22 | CSC | Futures | 4.35 | 4.373 | 4.325 | 4.337 | 15.0 |
| 2015-10-22 | CT | Futures | 77.05 | 77.6 | 74.82 | 75.0 | 22549.0 |
| 2015-10-22 | DC | Futures | 34.63 | 35.08 | 34.43 | 34.79 | 114.0 |
| 2015-10-22 | DX | Futures | 88.897 | 90.253 | 88.836 | 90.21 | 52438.0 |
| 2015-10-22 | E1 | Futures | 1.32476 | 1.32615 | 1.30421 | 1.30446 | 28562.0 |
| 2015-10-22 | E6 | Futures | 1.32923 | 1.33075 | 1.30135 | 1.30228 | 392112.0 |
| 2015-10-22 | E7 | Futures | 1.322 | 1.3233 | 1.2943 | 1.2951 | 7155.0 |
| 2015-10-22 | EBM | Futures | 257.96 | 261.61 | 257.96 | 259.78 | 16506.0 |
| 2015-10-22 | ED | Futures | 95.7496 | 95.7592 | 95.7448 | 95.7496 | 200223.0 |
| 2015-10-22 | ER | Futures | 98.156 | 98.2 | 98.151 | 98.19 | 197115.0 |
| 2015-10-22 | EW | Futures | 1496.4 | 1513.3 | 1496.4 | 1509.5 | 21331.0 |
| 2015-10-22 | FBTP | Futures | 103.56 | 104.93 | 103.43 | 104.57 | 117253.0 |
| 2015-10-22 | FBTS | Futures | 100.373 | 100.65 | 100.338 | 100.588 | 35583.0 |
| 2015-10-22 | FCE | Futures | 3899.0 | 4035.4 | 3891.1 | 4003.7 | 114137.0 |
| 2015-10-22 | FDAX | Futures | 11240.6 | 11660.2 | 11221.3 | 11566.6 | 134854.0 |
| 2015-10-22 | FESX | Futures | 2439.5 | 2532.4 | 2435.0 | 2513.0 | 1522948.0 |
| 2015-10-22 | FEU3 | Futures | 98.803 | 98.838 | 98.803 | 98.838 | 49.0 |
| 2015-10-22 | FGBL | Futures | 139.38 | 140.34 | 139.19 | 140.12 | 676006.0 |
| 2015-10-22 | FGBM | Futures | 125.37 | 125.77 | 125.32 | 125.7 | 534363.0 |
| 2015-10-22 | FGBS | Futures | 111.303 | 111.448 | 111.303 | 111.418 | 409894.0 |
| 2015-10-22 | FGBX | Futures | 158.85 | 161.16 | 158.51 | 160.36 | 38846.0 |
| 2015-10-22 | FMWO | Futures | 5589.0 | 5644.7 | 5582.8 | 5640.9 | 921.0 |
| 2015-10-22 | FOAT | Futures | 127.71 | 128.79 | 127.56 | 128.54 | 91656.0 |
| 2015-10-22 | FTDX | Futures | 1678.9 | 1700.7 | 1675.1 | 1695.5 | 173.0 |
| 2015-10-22 | FTI | Futures | 388.95 | 400.45 | 388.38 | 397.71 | 40348.0 |
| 2015-10-22 | FTUK | Futures | 5056.2 | 5135.8 | 5051.3 | 5112.0 | 105275.0 |
| 2015-10-22 | FVSA | Futures | 2122.95 | 2168.9 | 2008.07 | 2049.43 | 16481.0 |
| 2015-10-22 | FXXP | Futures | 281.4 | 289.9 | 281.1 | 288.3 | 31440.0 |
| 2015-10-22 | G | Futures | 105.1 | 105.34 | 104.89 | 105.19 | 148513.0 |
| 2015-10-22 | GF | Futures | 345.652 | 352.698 | 345.11 | 350.982 | 3942.0 |
| 2015-10-22 | GSCI | Futures | 584.6 | 584.6 | 578.87 | 581.13 | 226.0 |
| 2015-10-22 | HE | Futures | 101.442 | 101.741 | 98.712 | 99.385 | 12459.0 |
| 2015-10-22 | HG | Futures | 2.9543 | 3.0106 | 2.948 | 2.9837 | 52301.0 |
> showing 50 of 106 rows — these rows as CSV