PREVIEW / futures_daily / 2015-08-13
file: by_date/futures_daily/2015/2015-08-13.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-08-13 | ES | Futures | 2207.33 | 2218.2 | 2197.27 | 2204.95 | 1496065.0 |
| 2015-08-13 | NQ | Futures | 5288.57 | 5320.38 | 5264.05 | 5273.98 | 234832.0 |
| 2015-08-13 | YM | Futures | 17820.9 | 17907.1 | 17758.2 | 17838.3 | 148301.0 |
| 2015-08-13 | CL | Futures | 71.96 | 72.59 | 69.59 | 70.12 | 420146.0 |
| 2015-08-13 | GC | Futures | 1452.5 | 1453.9 | 1436.5 | 1440.1 | 129211.0 |
| 2015-08-13 | ZN | Futures | 121.957095 | 122.299881 | 121.524887 | 121.599406 | 1288228.0 |
| 2015-08-13 | A6 | Futures | 0.72989 | 0.73277 | 0.72415 | 0.72801 | 87474.0 |
| 2015-08-13 | AD | Futures | 0.78784 | 0.78876 | 0.78089 | 0.78211 | 55096.0 |
| 2015-08-13 | ALI | Futures | 2148.2 | 2148.2 | 2148.2 | 2148.2 | 0.0 |
| 2015-08-13 | B | Futures | 46.63 | 47.05 | 45.59 | 45.94 | 309380.0 |
| 2015-08-13 | B6 | Futures | 1.6431 | 1.6455 | 1.6387 | 1.6431 | 59731.0 |
| 2015-08-13 | BR | Futures | 0.17077 | 0.17077 | 0.1688 | 0.16964 | 2806.0 |
| 2015-08-13 | BZ | Futures | 46.57 | 47.01 | 45.54 | 45.89 | 32657.0 |
| 2015-08-13 | C | Futures | 2154.0 | 2181.0 | 2137.0 | 2169.0 | 6220.0 |
| 2015-08-13 | CB | Futures | 170.179 | 170.219 | 167.808 | 170.219 | 31.0 |
| 2015-08-13 | CC | Futures | 2225.0 | 2259.0 | 2214.0 | 2245.0 | 27441.0 |
| 2015-08-13 | CNH | Futures | 7.2803 | 7.287 | 7.2667 | 7.2809 | 10.0 |
| 2015-08-13 | CSC | Futures | 4.47 | 4.47 | 4.437 | 4.437 | 30.0 |
| 2015-08-13 | CT | Futures | 80.58 | 83.09 | 80.41 | 82.17 | 86.0 |
| 2015-08-13 | DC | Futures | 35.69 | 35.82 | 35.45 | 35.58 | 158.0 |
| 2015-08-13 | DX | Futures | 90.211 | 90.651 | 89.991 | 90.296 | 36250.0 |
| 2015-08-13 | E1 | Futures | 1.3037 | 1.30612 | 1.29761 | 1.30091 | 15440.0 |
| 2015-08-13 | E6 | Futures | 1.31165 | 1.31493 | 1.30213 | 1.30941 | 198156.0 |
| 2015-08-13 | E7 | Futures | 1.3042 | 1.3074 | 1.2951 | 1.3022 | 3577.0 |
| 2015-08-13 | EBM | Futures | 291.43 | 292.25 | 288.97 | 291.02 | 7937.0 |
| 2015-08-13 | ED | Futures | 95.6318 | 95.6366 | 95.6175 | 95.6222 | 161501.0 |
| 2015-08-13 | ER | Futures | 98.117 | 98.122 | 98.117 | 98.117 | 13192.0 |
| 2015-08-13 | EW | Futures | 1559.9 | 1568.5 | 1554.8 | 1560.3 | 13481.0 |
| 2015-08-13 | FBTP | Futures | 101.44 | 101.56 | 101.15 | 101.47 | 49556.0 |
| 2015-08-13 | FBTS | Futures | 100.186 | 100.204 | 100.151 | 100.159 | 15848.0 |
| 2015-08-13 | FCE | Futures | 4184.2 | 4207.3 | 4166.2 | 4176.3 | 1140.0 |
| 2015-08-13 | FDAX | Futures | 12249.0 | 12333.6 | 12135.7 | 12162.8 | 111738.0 |
| 2015-08-13 | FDIV | Futures | 150.84 | 150.84 | 149.73 | 149.73 | 15.0 |
| 2015-08-13 | FESX | Futures | 2620.6 | 2634.7 | 2595.4 | 2599.9 | 1071218.0 |
| 2015-08-13 | FEU3 | Futures | 98.764 | 98.764 | 98.764 | 98.764 | 45.0 |
| 2015-08-13 | FGBL | Futures | 138.09 | 138.41 | 137.88 | 138.22 | 463769.0 |
| 2015-08-13 | FGBM | Futures | 125.0 | 125.06 | 124.9 | 125.0 | 293448.0 |
| 2015-08-13 | FGBS | Futures | 111.318 | 111.323 | 111.303 | 111.318 | 135299.0 |
| 2015-08-13 | FGBX | Futures | 158.1 | 158.85 | 157.37 | 158.5 | 21875.0 |
| 2015-08-13 | FMWO | Futures | 5800.3 | 5800.3 | 5764.6 | 5772.0 | 710.0 |
| 2015-08-13 | FOAT | Futures | 126.18 | 126.43 | 125.99 | 126.25 | 63831.0 |
| 2015-08-13 | FTDX | Futures | 1643.7 | 1672.5 | 1643.7 | 1654.6 | 888.0 |
| 2015-08-13 | FTI | Futures | 415.37 | 417.65 | 409.35 | 410.16 | 201.0 |
| 2015-08-13 | FTUK | Futures | 5242.8 | 5267.4 | 5201.1 | 5211.8 | 92513.0 |
| 2015-08-13 | FVSA | Futures | 1763.08 | 1818.57 | 1758.81 | 1797.23 | 6797.0 |
| 2015-08-13 | FXXP | Futures | 298.1 | 299.8 | 296.4 | 296.7 | 25979.0 |
| 2015-08-13 | G | Futures | 103.28 | 103.28 | 102.78 | 103.15 | 143217.0 |
| 2015-08-13 | GF | Futures | 362.976 | 363.235 | 359.14 | 362.631 | 2165.0 |
| 2015-08-13 | GSCI | Futures | 609.09 | 614.37 | 601.67 | 604.06 | 940.0 |
| 2015-08-13 | HE | Futures | 87.448 | 89.738 | 87.037 | 88.952 | 19602.0 |
> showing 50 of 107 rows — these rows as CSV