PREVIEW / etf_daily / 2008-10-15
file: by_date/etf_daily/2008/2008-10-15.parquet size: 27 KB rows: 609
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-15 | SPY | ETF | 97.46 | 97.8 | 89.71 | 90.02 | 484627500.0 |
| 2008-10-15 | QQQ | ETF | 33.23 | 33.35 | 30.54 | 30.6 | 312088417.0 |
| 2008-10-15 | IWM | ETF | 54.45 | 54.85 | 50.05 | 50.41 | 109147700.0 |
| 2008-10-15 | DIA | ETF | 91.84 | 92.06 | 84.76 | 84.87 | 36270200.0 |
| 2008-10-15 | GLD | ETF | 82.2 | 84.39 | 82.08 | 83.31 | 16906100.0 |
| 2008-10-15 | TLT | ETF | 94.12 | 95.04 | 93.42 | 95.01 | 1449500.0 |
| 2008-10-15 | AAXJ | ETF | 37.45 | 37.45 | 33.11 | 33.11 | 41100.0 |
| 2008-10-15 | ACWI | ETF | 35.03 | 35.2 | 32.0 | 32.07 | 72100.0 |
| 2008-10-15 | ACWX | ETF | 32.71 | 32.71 | 29.91 | 29.91 | 108276.0 |
| 2008-10-15 | ADRE | ETF | 29.92 | 29.92 | 26.24 | 26.24 | 325928.0 |
| 2008-10-15 | AFK | ETF | 26.3 | 26.3 | 26.2999 | 26.2999 | 500.0 |
| 2008-10-15 | AGG | ETF | 94.42 | 95.8 | 92.79 | 95.25 | 678200.0 |
| 2008-10-15 | AIA | ETF | 29.49 | 29.49 | 26.95 | 26.95 | 17348.0 |
| 2008-10-15 | AIQ | ETF | 42.6 | 43.0 | 39.55 | 39.7 | 36287.0 |
| 2008-10-15 | AIS | ETF | 0.52 | 0.52 | 0.44 | 0.5 | 18725.0 |
| 2008-10-15 | AIVI | ETF | 41.89 | 42.28 | 37.91 | 38.52 | 33100.0 |
| 2008-10-15 | ARB | ETF | 38.45 | 38.45 | 34.7 | 34.7 | 291249.0 |
| 2008-10-15 | BAL | ETF | 31.04 | 31.0401 | 29.96 | 29.96 | 900.0 |
| 2008-10-15 | BBH | ETF | 53.56 | 55.2433 | 52.2333 | 52.2333 | 1349100.0 |
| 2008-10-15 | BIL | ETF | 91.8 | 91.94 | 91.7 | 91.88 | 204950.0 |
| 2008-10-15 | BITS | ETF | 16.0 | 16.04 | 14.36 | 14.68 | 1138.0 |
| 2008-10-15 | BIV | ETF | 70.7 | 70.87 | 70.17 | 70.72 | 40500.0 |
| 2008-10-15 | BJK | ETF | 18.5 | 18.5 | 17.5 | 17.5 | 800.0 |
| 2008-10-15 | BKF | ETF | 28.04 | 28.04 | 24.273 | 24.62 | 89083.0 |
| 2008-10-15 | BLV | ETF | 67.92 | 68.01 | 67.18 | 67.96 | 10800.0 |
| 2008-10-15 | BMVP | ETF | 11.42 | 11.42 | 10.31 | 10.31 | 65682.0 |
| 2008-10-15 | BND | ETF | 73.06 | 73.42 | 72.19 | 73.35 | 229700.0 |
| 2008-10-15 | BNE | ETF | 6.54 | 6.54 | 5.86 | 5.89 | 116423.0 |
| 2008-10-15 | BRF | ETF | 14.65 | 14.72 | 14.61 | 14.668 | 11137.0 |
| 2008-10-15 | BSV | ETF | 73.48 | 75.71 | 71.7 | 74.43 | 161300.0 |
| 2008-10-15 | BTF | ETF | 61.9 | 61.9 | 58.935 | 59.5 | 4458.0 |
| 2008-10-15 | BWX | ETF | 25.245 | 25.3 | 24.635 | 25.235 | 187152.0 |
| 2008-10-15 | CBON | ETF | 4.25 | 4.25 | 3.87 | 3.9 | 60510.0 |
| 2008-10-15 | CDL | ETF | 0.3102 | 0.46 | 0.26 | 0.26 | 1180686.0 |
| 2008-10-15 | CEF | ETF | 10.98 | 10.98 | 10.15 | 10.4 | 912100.0 |
| 2008-10-15 | CGO | ETF | 9.71 | 9.8 | 9.2832 | 9.62 | 31247.0 |
| 2008-10-15 | CGW | ETF | 16.91 | 17.45 | 15.81 | 15.81 | 69118.0 |
| 2008-10-15 | CHB | ETF | 3.91 | 3.94 | 3.0 | 3.27 | 2350676.0 |
| 2008-10-15 | CHI | ETF | 8.55 | 8.76 | 8.06 | 8.53 | 226287.0 |
| 2008-10-15 | CHIC | ETF | 9.01 | 9.29 | 8.58 | 8.58 | 423097.0 |
| 2008-10-15 | CHW | ETF | 6.09 | 6.35 | 5.91 | 6.08 | 219244.0 |
| 2008-10-15 | CHY | ETF | 7.46 | 7.49 | 7.17 | 7.4 | 383447.0 |
| 2008-10-15 | CMF | ETF | 46.015 | 46.02 | 45.5 | 45.5 | 5594.0 |
| 2008-10-15 | CNXT | ETF | 2.54 | 2.57 | 2.34 | 2.47 | 358866.0 |
| 2008-10-15 | COW | ETF | 36.85 | 36.898 | 35.82 | 35.82 | 16815.0 |
| 2008-10-15 | CPI | ETF | 22.0 | 22.0 | 22.0 | 22.0 | 100.0 |
| 2008-10-15 | CPST | ETF | 1.42 | 1.44 | 1.25 | 1.25 | 2376466.0 |
| 2008-10-15 | CSA | ETF | 13.68 | 13.7 | 12.42 | 12.44 | 156586.0 |
| 2008-10-15 | CSB | ETF | 14.99 | 15.0 | 14.0 | 14.15 | 64143.0 |
| 2008-10-15 | CSD | ETF | 14.27 | 14.27 | 13.72 | 13.74 | 2900.0 |
> showing 50 of 609 rows — these rows as CSV