PREVIEW / etf_daily / 2015-08-19
file: by_date/etf_daily/2015/2015-08-19.parquet size: 48 KB rows: 1,200
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-19 | SPY | ETF | 209.09 | 210.01 | 207.35 | 208.32 | 172946000.0 |
| 2015-08-19 | QQQ | ETF | 110.52 | 111.105 | 109.49 | 110.13 | 42511384.0 |
| 2015-08-19 | IWM | ETF | 119.9 | 120.5 | 118.74 | 119.41 | 45178900.0 |
| 2015-08-19 | DIA | ETF | 174.33 | 175.49 | 173.12 | 173.74 | 10988700.0 |
| 2015-08-19 | GLD | ETF | 107.63 | 108.67 | 107.63 | 108.55 | 7035100.0 |
| 2015-08-19 | TLT | ETF | 123.06 | 124.93 | 122.99 | 124.76 | 10736000.0 |
| 2015-08-19 | AADR | ETF | 38.74 | 38.74 | 37.85 | 38.02 | 6900.0 |
| 2015-08-19 | AAXJ | ETF | 55.38 | 55.46 | 54.61 | 54.99 | 1606100.0 |
| 2015-08-19 | ACTX | ETF | 1.18 | 1.77 | 1.18 | 1.18 | 5609.0 |
| 2015-08-19 | ACWI | ETF | 58.71 | 58.88 | 58.17 | 58.48 | 698900.0 |
| 2015-08-19 | ACWV | ETF | 70.91 | 71.38 | 70.57 | 70.93 | 90400.0 |
| 2015-08-19 | ACWX | ETF | 42.54 | 42.7 | 42.2 | 42.46 | 353420.0 |
| 2015-08-19 | ADRE | ETF | 31.0 | 31.028 | 30.69 | 30.78 | 57406.0 |
| 2015-08-19 | AFK | ETF | 20.98 | 21.0 | 20.58 | 20.75 | 70159.0 |
| 2015-08-19 | AFTY | ETF | 17.13 | 17.15 | 16.83 | 16.83 | 36000.0 |
| 2015-08-19 | AGG | ETF | 109.04 | 109.48 | 108.96 | 109.4 | 2184900.0 |
| 2015-08-19 | AGQ | ETF | 33.41 | 34.4 | 33.27 | 34.1 | 202400.0 |
| 2015-08-19 | AGZ | ETF | 113.2 | 113.64 | 113.0801 | 113.6309 | 13640.0 |
| 2015-08-19 | AGZD | ETF | 24.17 | 24.25 | 24.12 | 24.12 | 12200.0 |
| 2015-08-19 | AIA | ETF | 43.93 | 43.93 | 43.3796 | 43.66 | 31385.0 |
| 2015-08-19 | AIQ | ETF | 14.69 | 14.96 | 14.69 | 14.72 | 16091.0 |
| 2015-08-19 | AIRR | ETF | 16.84 | 16.873 | 16.725 | 16.8 | 4800.0 |
| 2015-08-19 | AIVI | ETF | 41.99 | 42.09 | 41.67 | 41.98 | 26800.0 |
| 2015-08-19 | AMJ | ETF | 36.68 | 37.2299 | 36.2 | 36.36 | 4584221.0 |
| 2015-08-19 | AMLP | ETF | 73.4 | 73.6 | 72.25 | 72.55 | 1086320.0 |
| 2015-08-19 | AMZA | ETF | 171.69 | 171.69 | 165.94 | 167.3 | 2050.0 |
| 2015-08-19 | ANGL | ETF | 26.55 | 26.55 | 26.41 | 26.48 | 39000.0 |
| 2015-08-19 | AOA | ETF | 46.77 | 46.77 | 46.35 | 46.59 | 61700.0 |
| 2015-08-19 | AOK | ETF | 32.27 | 32.3788 | 32.19 | 32.3788 | 11917.0 |
| 2015-08-19 | AOM | ETF | 34.96 | 35.04 | 34.8111 | 34.98 | 32763.0 |
| 2015-08-19 | AOR | ETF | 40.0 | 40.18 | 39.89 | 40.07 | 43537.0 |
| 2015-08-19 | ARGT | ETF | 18.7 | 18.71 | 18.13 | 18.37 | 15900.0 |
| 2015-08-19 | ARKG | ETF | 21.49 | 21.62 | 21.49 | 21.49 | 700.0 |
| 2015-08-19 | ARKK | ETF | 20.8 | 20.8 | 20.75 | 20.75 | 900.0 |
| 2015-08-19 | ARKQ | ETF | 18.93 | 18.93 | 18.93 | 18.93 | 100.0 |
| 2015-08-19 | ARKW | ETF | 23.28 | 23.36 | 23.2 | 23.25 | 2200.0 |
| 2015-08-19 | ASEA | ETF | 13.06 | 13.1 | 12.95 | 13.06 | 8000.0 |
| 2015-08-19 | ASHR | ETF | 38.12 | 38.25 | 37.71 | 37.77 | 1687600.0 |
| 2015-08-19 | ASHS | ETF | 49.65 | 49.94 | 49.12 | 49.19 | 39000.0 |
| 2015-08-19 | ATMP | ETF | 25.26 | 25.26 | 24.55 | 24.77 | 154100.0 |
| 2015-08-19 | AWAY | ETF | 31.03 | 31.64 | 30.8 | 31.36 | 1494414.0 |
| 2015-08-19 | BAB | ETF | 28.94 | 29.25 | 28.94 | 29.15 | 92173.0 |
| 2015-08-19 | BAL | ETF | 44.62 | 44.72 | 44.3 | 44.51 | 2715.0 |
| 2015-08-19 | BBC | ETF | 32.72 | 32.95 | 31.68 | 32.12 | 15165.0 |
| 2015-08-19 | BBH | ETF | 135.75 | 136.49 | 134.33 | 135.62 | 158500.0 |
| 2015-08-19 | BBP | ETF | 34.23 | 34.31 | 33.56 | 34.08 | 32700.0 |
| 2015-08-19 | BCM | ETF | 26.9406 | 26.9406 | 26.64 | 26.7 | 27683.0 |
| 2015-08-19 | BFOR | ETF | 8.14 | 8.14 | 8.06 | 8.1025 | 144400.0 |
| 2015-08-19 | BIB | ETF | 88.0 | 89.3711 | 85.98 | 87.86 | 897132.0 |
| 2015-08-19 | BICK | ETF | 20.23 | 20.426 | 20.23 | 20.4 | 2552.0 |
> showing 50 of 1,200 rows — these rows as CSV