PREVIEW / etf_daily / 2015-07-06
file: by_date/etf_daily/2015/2015-07-06.parquet size: 48 KB rows: 1,193
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-07-06 | SPY | ETF | 205.77 | 207.65 | 205.53 | 206.72 | 117975400.0 |
| 2015-07-06 | QQQ | ETF | 107.27 | 108.32 | 107.04 | 107.7 | 24311020.0 |
| 2015-07-06 | IWM | ETF | 122.94 | 124.51 | 122.82 | 123.74 | 27852200.0 |
| 2015-07-06 | DIA | ETF | 175.59 | 177.14 | 175.34 | 176.68 | 3748700.0 |
| 2015-07-06 | GLD | ETF | 111.71 | 112.58 | 111.63 | 112.06 | 4259800.0 |
| 2015-07-06 | TLT | ETF | 118.05 | 118.65 | 117.06 | 118.15 | 10605800.0 |
| 2015-07-06 | AADR | ETF | 39.21 | 39.21 | 39.21 | 39.21 | 100.0 |
| 2015-07-06 | AAXJ | ETF | 61.54 | 62.15 | 61.47 | 61.65 | 1856000.0 |
| 2015-07-06 | ACTX | ETF | 2.36 | 2.36 | 1.652 | 1.77 | 834.0 |
| 2015-07-06 | ACWI | ETF | 58.98 | 59.51 | 58.85 | 59.14 | 1513900.0 |
| 2015-07-06 | ACWV | ETF | 69.83 | 70.19 | 69.77 | 69.94 | 55500.0 |
| 2015-07-06 | ACWX | ETF | 43.59 | 43.92 | 43.46 | 43.6 | 398391.0 |
| 2015-07-06 | ADRE | ETF | 34.53 | 34.53 | 34.1399 | 34.19 | 14636.0 |
| 2015-07-06 | AFK | ETF | 23.69 | 23.875 | 23.22 | 23.5299 | 43176.0 |
| 2015-07-06 | AFTY | ETF | 20.0 | 20.127 | 19.895 | 20.0 | 218700.0 |
| 2015-07-06 | AGG | ETF | 108.88 | 108.99 | 108.63 | 108.83 | 1108000.0 |
| 2015-07-06 | AGQ | ETF | 35.93 | 37.17 | 35.81 | 36.47 | 142300.0 |
| 2015-07-06 | AGZ | ETF | 113.15 | 113.2599 | 113.12 | 113.2301 | 7119.0 |
| 2015-07-06 | AGZD | ETF | 24.405 | 24.42 | 24.295 | 24.405 | 10200.0 |
| 2015-07-06 | AIA | ETF | 49.52 | 49.52 | 49.0 | 49.2 | 29208.0 |
| 2015-07-06 | AIQ | ETF | 17.98 | 18.0692 | 17.08 | 17.74 | 10182.0 |
| 2015-07-06 | AIRR | ETF | 18.04 | 18.15 | 18.02 | 18.105 | 8100.0 |
| 2015-07-06 | AIVI | ETF | 41.93 | 42.12 | 41.67 | 41.81 | 153100.0 |
| 2015-07-06 | ALTL | ETF | 36.2 | 36.21 | 36.2 | 36.21 | 1727.0 |
| 2015-07-06 | AMJ | ETF | 39.13 | 39.52 | 39.06 | 39.25 | 1772679.0 |
| 2015-07-06 | AMLP | ETF | 77.35 | 77.85 | 77.15 | 77.3 | 1127700.0 |
| 2015-07-06 | AMZA | ETF | 195.6 | 195.6 | 191.7 | 192.8 | 1270.0 |
| 2015-07-06 | ANGL | ETF | 27.6 | 27.6 | 27.04 | 27.1 | 16500.0 |
| 2015-07-06 | AOA | ETF | 47.24 | 47.24 | 46.59 | 46.77 | 32800.0 |
| 2015-07-06 | AOK | ETF | 32.23 | 32.36 | 32.23 | 32.32 | 20756.0 |
| 2015-07-06 | AOM | ETF | 35.04 | 35.06 | 34.825 | 34.96 | 60152.0 |
| 2015-07-06 | AOR | ETF | 40.4 | 40.4 | 40.0 | 40.15 | 90287.0 |
| 2015-07-06 | ARGT | ETF | 19.42 | 19.68 | 19.24 | 19.45 | 5900.0 |
| 2015-07-06 | ARKG | ETF | 22.87 | 22.87 | 22.65 | 22.82 | 1200.0 |
| 2015-07-06 | ARKK | ETF | 21.2 | 21.2 | 21.098 | 21.098 | 1600.0 |
| 2015-07-06 | ARKQ | ETF | 19.818 | 19.818 | 19.762 | 19.77 | 900.0 |
| 2015-07-06 | ARKW | ETF | 22.74 | 23.0 | 22.7 | 22.81 | 2700.0 |
| 2015-07-06 | ASEA | ETF | 14.88 | 15.03 | 14.86 | 15.02 | 6300.0 |
| 2015-07-06 | ASHR | ETF | 41.64 | 41.94 | 41.25 | 41.34 | 5039500.0 |
| 2015-07-06 | ASHS | ETF | 47.4 | 47.41 | 45.91 | 46.17 | 561100.0 |
| 2015-07-06 | ATMP | ETF | 26.86 | 27.06 | 26.75 | 26.85 | 449300.0 |
| 2015-07-06 | AWAY | ETF | 30.94 | 31.11 | 30.59 | 30.7 | 1302766.0 |
| 2015-07-06 | BAB | ETF | 28.85 | 28.9499 | 28.7501 | 28.85 | 58518.0 |
| 2015-07-06 | BAL | ETF | 45.03 | 45.14 | 44.46 | 44.84 | 10075.0 |
| 2015-07-06 | BALT | ETF | 1.6 | 1.6 | 1.57 | 1.59 | 217329.0 |
| 2015-07-06 | BBC | ETF | 34.96 | 36.52 | 34.96 | 36.49 | 44397.0 |
| 2015-07-06 | BBH | ETF | 133.85 | 137.05 | 133.68 | 135.77 | 145800.0 |
| 2015-07-06 | BBP | ETF | 34.14 | 35.01 | 34.09 | 34.65 | 41700.0 |
| 2015-07-06 | BCM | ETF | 30.168 | 30.185 | 30.168 | 30.185 | 4418.0 |
| 2015-07-06 | BFOR | ETF | 8.2325 | 8.3 | 8.205 | 8.2525 | 80400.0 |
> showing 50 of 1,193 rows — these rows as CSV