PREVIEW / etf_daily / 2015-08-13
file: by_date/etf_daily/2015/2015-08-13.parquet size: 48 KB rows: 1,189
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 | SPY | ETF | 208.73 | 209.55 | 208.01 | 208.66 | 89383300.0 |
| 2015-08-13 | QQQ | ETF | 110.63 | 111.16 | 110.1 | 110.34 | 22510520.0 |
| 2015-08-13 | IWM | ETF | 120.1 | 120.59 | 119.39 | 119.59 | 35698300.0 |
| 2015-08-13 | DIA | ETF | 173.99 | 174.97 | 173.55 | 174.31 | 6562700.0 |
| 2015-08-13 | GLD | ETF | 106.95 | 107.18 | 106.71 | 106.86 | 4761700.0 |
| 2015-08-13 | TLT | ETF | 123.83 | 124.42 | 123.22 | 123.67 | 7691400.0 |
| 2015-08-13 | AADR | ETF | 39.14 | 39.14 | 38.65 | 38.65 | 1600.0 |
| 2015-08-13 | AAXJ | ETF | 56.96 | 57.13 | 56.74 | 56.84 | 1645100.0 |
| 2015-08-13 | ACTX | ETF | 1.77 | 2.065 | 1.77 | 1.77 | 729.0 |
| 2015-08-13 | ACWI | ETF | 59.24 | 59.36 | 59.01 | 59.15 | 567100.0 |
| 2015-08-13 | ACWV | ETF | 70.95 | 71.32 | 70.79 | 70.97 | 70300.0 |
| 2015-08-13 | ACWX | ETF | 43.3399 | 43.43 | 43.2 | 43.32 | 461523.0 |
| 2015-08-13 | ADRE | ETF | 31.59 | 31.68 | 31.49 | 31.4922 | 13574.0 |
| 2015-08-13 | AFK | ETF | 21.97 | 22.1 | 21.63 | 21.8 | 65604.0 |
| 2015-08-13 | AFTY | ETF | 18.19 | 18.256 | 18.17 | 18.243 | 18200.0 |
| 2015-08-13 | AGG | ETF | 109.36 | 109.37 | 109.11 | 109.12 | 1571700.0 |
| 2015-08-13 | AGQ | ETF | 34.84 | 35.14 | 34.48 | 34.77 | 88900.0 |
| 2015-08-13 | AGZ | ETF | 113.37 | 113.55 | 113.31 | 113.3899 | 6401.0 |
| 2015-08-13 | AGZD | ETF | 24.29 | 24.495 | 24.205 | 24.215 | 25600.0 |
| 2015-08-13 | AIA | ETF | 45.23 | 45.4865 | 45.18 | 45.23 | 61048.0 |
| 2015-08-13 | AIQ | ETF | 14.68 | 15.1 | 14.68 | 14.87 | 7755.0 |
| 2015-08-13 | AIRR | ETF | 16.99 | 17.081 | 16.99 | 17.06 | 5900.0 |
| 2015-08-13 | AIVI | ETF | 42.85 | 42.99 | 42.79 | 42.81 | 48200.0 |
| 2015-08-13 | ALTY | ETF | 14.91 | 14.91 | 14.905 | 14.905 | 600.0 |
| 2015-08-13 | AMJ | ETF | 36.76 | 36.92 | 36.254 | 36.39 | 1019051.0 |
| 2015-08-13 | AMLP | ETF | 73.35 | 74.1 | 72.45 | 72.55 | 1278460.0 |
| 2015-08-13 | AMZA | ETF | 171.7 | 171.7 | 165.0 | 167.6 | 1050.0 |
| 2015-08-13 | ANGL | ETF | 26.64 | 26.65 | 26.6 | 26.64 | 7600.0 |
| 2015-08-13 | AOA | ETF | 46.97 | 46.99 | 46.75 | 46.9 | 12900.0 |
| 2015-08-13 | AOK | ETF | 32.3 | 32.44 | 32.2501 | 32.32 | 31744.0 |
| 2015-08-13 | AOM | ETF | 35.14 | 35.14 | 34.94 | 35.07 | 50026.0 |
| 2015-08-13 | AOR | ETF | 40.23 | 40.35 | 40.17 | 40.28 | 675295.0 |
| 2015-08-13 | ARGT | ETF | 19.03 | 19.06 | 18.99 | 18.99 | 3000.0 |
| 2015-08-13 | ARKG | ETF | 21.8 | 21.801 | 21.75 | 21.75 | 1800.0 |
| 2015-08-13 | ARKK | ETF | 20.988 | 20.988 | 20.988 | 20.988 | 200.0 |
| 2015-08-13 | ARKQ | ETF | 19.167 | 19.167 | 19.15 | 19.15 | 400.0 |
| 2015-08-13 | ARKW | ETF | 23.37 | 23.6 | 23.37 | 23.6 | 1000.0 |
| 2015-08-13 | ASEA | ETF | 13.39 | 13.47 | 13.38 | 13.44 | 11600.0 |
| 2015-08-13 | ASHR | ETF | 40.9 | 40.95 | 40.7 | 40.76 | 2054000.0 |
| 2015-08-13 | ASHS | ETF | 50.65 | 51.61 | 50.65 | 51.36 | 51300.0 |
| 2015-08-13 | ATMP | ETF | 25.04 | 25.12 | 24.92 | 24.93 | 52200.0 |
| 2015-08-13 | AWAY | ETF | 30.64 | 30.88 | 30.26 | 30.5 | 1212086.0 |
| 2015-08-13 | BAB | ETF | 29.36 | 29.36 | 29.15 | 29.21 | 123205.0 |
| 2015-08-13 | BAL | ETF | 43.84 | 44.44 | 43.72 | 43.78 | 10528.0 |
| 2015-08-13 | BBC | ETF | 33.53 | 33.6053 | 32.5142 | 32.67 | 12137.0 |
| 2015-08-13 | BBH | ETF | 136.71 | 137.51 | 135.53 | 135.71 | 103400.0 |
| 2015-08-13 | BBP | ETF | 34.13 | 34.641 | 33.859 | 33.94 | 10700.0 |
| 2015-08-13 | BCM | ETF | 27.297 | 27.3 | 27.297 | 27.3 | 2230.0 |
| 2015-08-13 | BFOR | ETF | 8.135 | 8.18 | 8.1325 | 8.1425 | 35600.0 |
| 2015-08-13 | BIB | ETF | 90.61 | 91.1659 | 87.86 | 88.23 | 731337.0 |
> showing 50 of 1,189 rows — these rows as CSV