PREVIEW / futures_daily / 2014-07-15
file: by_date/futures_daily/2014/2014-07-15.parquet size: 9 KB rows: 104
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 |
|---|---|---|---|---|---|---|---|
| 2014-07-15 | ES | Futures | 2047.73 | 2052.92 | 2034.74 | 2044.35 | 1905617.0 |
| 2014-07-15 | NQ | Futures | 4525.7 | 4538.39 | 4476.66 | 4514.16 | 332223.0 |
| 2014-07-15 | YM | Futures | 17133.6 | 17198.1 | 17084.1 | 17140.6 | 155706.0 |
| 2014-07-15 | CL | Futures | 185.09 | 185.25 | 181.66 | 183.23 | 203969.0 |
| 2014-07-15 | GC | Futures | 1724.9 | 1731.8 | 1703.1 | 1709.0 | 175878.0 |
| 2014-07-15 | ZN | Futures | 116.696214 | 116.944225 | 116.477382 | 116.62327 | 1330613.0 |
| 2014-07-15 | A6 | Futures | 0.90388 | 0.90485 | 0.89963 | 0.90204 | 82144.0 |
| 2014-07-15 | AD | Futures | 0.94678 | 0.94688 | 0.9416 | 0.94231 | 54245.0 |
| 2014-07-15 | ALI | Futures | 2862.48 | 2862.48 | 2862.48 | 2862.48 | 0.0 |
| 2014-07-15 | B | Futures | 113.08 | 113.27 | 111.06 | 112.42 | 385016.0 |
| 2014-07-15 | B6 | Futures | 1.7953 | 1.8065 | 1.7924 | 1.8017 | 127097.0 |
| 2014-07-15 | BFX | Futures | 3788.6 | 3788.6 | 3770.3 | 3773.5 | 77.0 |
| 2014-07-15 | BR | Futures | 0.235 | 0.23537 | 0.23384 | 0.2345 | 300.0 |
| 2014-07-15 | BZ | Futures | 113.92 | 113.97 | 111.78 | 113.13 | 16986.0 |
| 2014-07-15 | C | Futures | 2019.0 | 2049.0 | 2016.0 | 2030.0 | 9648.0 |
| 2014-07-15 | CB | Futures | 121.851 | 124.143 | 121.851 | 124.143 | 32.0 |
| 2014-07-15 | CC | Futures | 2265.0 | 2299.0 | 2265.0 | 2282.0 | 15209.0 |
| 2014-07-15 | CNH | Futures | 7.1504 | 7.1517 | 7.1486 | 7.1517 | 3.0 |
| 2014-07-15 | CSC | Futures | 4.308 | 4.328 | 4.287 | 4.287 | 46.0 |
| 2014-07-15 | CT | Futures | 86.54 | 86.69 | 85.58 | 86.1 | 30.0 |
| 2014-07-15 | DC | Futures | 34.82 | 34.99 | 34.58 | 34.82 | 230.0 |
| 2014-07-15 | DX | Futures | 76.138 | 76.384 | 76.104 | 76.362 | 26234.0 |
| 2014-07-15 | E1 | Futures | 1.43827 | 1.43917 | 1.43083 | 1.4316 | 46508.0 |
| 2014-07-15 | E6 | Futures | 1.60742 | 1.60837 | 1.60046 | 1.60129 | 210434.0 |
| 2014-07-15 | E7 | Futures | 1.5968 | 1.5979 | 1.5901 | 1.5908 | 2712.0 |
| 2014-07-15 | ED | Futures | 95.4162 | 95.4162 | 95.4115 | 95.4162 | 73437.0 |
| 2014-07-15 | ER | Futures | 97.901 | 97.906 | 97.896 | 97.901 | 41457.0 |
| 2014-07-15 | EW | Futures | 1467.4 | 1474.1 | 1455.4 | 1465.1 | 15469.0 |
| 2014-07-15 | FBTP | Futures | 91.39 | 91.67 | 91.34 | 91.51 | 54799.0 |
| 2014-07-15 | FBTS | Futures | 98.232 | 98.285 | 98.214 | 98.241 | 8550.0 |
| 2014-07-15 | FCE | Futures | 3454.7 | 3461.8 | 3413.7 | 3424.0 | 117620.0 |
| 2014-07-15 | FDAX | Futures | 10759.2 | 10785.1 | 10671.7 | 10733.3 | 99481.0 |
| 2014-07-15 | FESX | Futures | 2286.5 | 2290.1 | 2258.4 | 2271.4 | 950953.0 |
| 2014-07-15 | FGBL | Futures | 128.36 | 128.61 | 128.2 | 128.26 | 673428.0 |
| 2014-07-15 | FGBM | Futures | 121.69 | 121.78 | 121.6 | 121.63 | 411255.0 |
| 2014-07-15 | FGBS | Futures | 110.778 | 110.793 | 110.763 | 110.778 | 162411.0 |
| 2014-07-15 | FGBX | Futures | 134.12 | 134.81 | 134.08 | 134.17 | 16827.0 |
| 2014-07-15 | FMWO | Futures | 5785.2 | 5785.2 | 5785.2 | 5785.2 | 0.0 |
| 2014-07-15 | FOAT | Futures | 118.06 | 118.33 | 118.0 | 118.05 | 49112.0 |
| 2014-07-15 | FTDX | Futures | 1193.1 | 1193.1 | 1178.1 | 1182.3 | 277.0 |
| 2014-07-15 | FTI | Futures | 350.52 | 351.04 | 348.22 | 348.74 | 27431.0 |
| 2014-07-15 | FTUK | Futures | 5150.0 | 5164.2 | 5112.7 | 5131.5 | 82548.0 |
| 2014-07-15 | FVSA | Futures | 1345.71 | 1388.16 | 1341.46 | 1375.42 | 8454.0 |
| 2014-07-15 | FXXP | Futures | 255.3 | 255.8 | 253.8 | 254.9 | 2925.0 |
| 2014-07-15 | G | Futures | 94.55 | 94.59 | 93.94 | 94.06 | 180305.0 |
| 2014-07-15 | GF | Futures | 323.607 | 326.404 | 322.956 | 324.182 | 3486.0 |
| 2014-07-15 | GSCI | Futures | 1053.86 | 1054.28 | 1044.49 | 1049.18 | 1329.0 |
| 2014-07-15 | HE | Futures | 137.001 | 137.499 | 136.109 | 137.185 | 13734.0 |
| 2014-07-15 | HG | Futures | 4.1586 | 4.1682 | 4.1203 | 4.1535 | 44625.0 |
| 2014-07-15 | HH | Futures | 52.148 | 52.388 | 51.718 | 51.807 | 1139.0 |
> showing 50 of 104 rows — these rows as CSV