PREVIEW / etf_daily / 2008-12-17
file: by_date/etf_daily/2008/2008-12-17.parquet size: 28 KB rows: 635
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-12-17 | SPY | ETF | 90.84 | 92.43 | 90.06 | 90.99 | 281819800.0 |
| 2008-12-17 | QQQ | ETF | 30.23 | 30.6 | 29.82 | 30.19 | 159965350.0 |
| 2008-12-17 | IWM | ETF | 47.94 | 49.51 | 47.57 | 48.77 | 79576900.0 |
| 2008-12-17 | DIA | ETF | 88.46 | 89.8 | 87.95 | 88.35 | 22285800.0 |
| 2008-12-17 | GLD | ETF | 85.26 | 86.91 | 84.8 | 85.43 | 21988500.0 |
| 2008-12-17 | TLT | ETF | 120.77 | 121.13 | 119.26 | 119.62 | 6407500.0 |
| 2008-12-17 | AAXJ | ETF | 34.18 | 35.53 | 33.94 | 34.85 | 103100.0 |
| 2008-12-17 | ACWI | ETF | 32.62 | 33.09 | 32.37 | 32.75 | 388800.0 |
| 2008-12-17 | ACWX | ETF | 30.41 | 31.32 | 30.41 | 30.91 | 454740.0 |
| 2008-12-17 | ADRE | ETF | 28.54 | 28.97 | 28.42 | 28.68 | 274392.0 |
| 2008-12-17 | AFK | ETF | 22.63 | 22.63 | 21.48 | 22.01 | 2944.0 |
| 2008-12-17 | AGG | ETF | 101.76 | 102.09 | 101.01 | 101.67 | 934200.0 |
| 2008-12-17 | AGQ | ETF | 63.0 | 67.44 | 63.0 | 65.5 | 45750.0 |
| 2008-12-17 | AGZ | ETF | 109.32 | 109.32 | 108.73 | 108.73 | 2495.0 |
| 2008-12-17 | AIA | ETF | 27.73 | 27.73 | 26.86 | 27.116 | 10603.0 |
| 2008-12-17 | AIQ | ETF | 34.75 | 36.7 | 34.4 | 36.4 | 49558.0 |
| 2008-12-17 | AIS | ETF | 0.35 | 0.37 | 0.32 | 0.37 | 49478.0 |
| 2008-12-17 | AIVI | ETF | 37.01 | 37.97 | 36.75 | 37.45 | 50000.0 |
| 2008-12-17 | AOA | ETF | 25.99 | 25.99 | 24.0 | 24.8 | 73700.0 |
| 2008-12-17 | AOK | ETF | 25.85 | 25.88 | 25.85 | 25.88 | 2989.0 |
| 2008-12-17 | AOM | ETF | 25.44 | 25.6 | 25.44 | 25.6 | 6482.0 |
| 2008-12-17 | AOR | ETF | 24.964 | 25.23 | 24.964 | 25.0799 | 5519.0 |
| 2008-12-17 | ARB | ETF | 10.37 | 11.1 | 9.99 | 10.97 | 826106.0 |
| 2008-12-17 | BAL | ETF | 26.27 | 26.9 | 26.2399 | 26.9 | 2520.0 |
| 2008-12-17 | BBH | ETF | 55.2367 | 55.8067 | 55.0867 | 55.5433 | 264900.0 |
| 2008-12-17 | BIL | ETF | 91.72 | 91.8 | 91.72 | 91.72 | 156850.0 |
| 2008-12-17 | BITS | ETF | 16.52 | 18.0 | 16.32 | 18.0 | 5536.0 |
| 2008-12-17 | BIV | ETF | 78.16 | 78.7 | 77.73 | 78.69 | 119000.0 |
| 2008-12-17 | BJK | ETF | 17.48 | 18.26 | 16.1 | 17.66 | 3200.0 |
| 2008-12-17 | BKF | ETF | 25.81 | 26.72 | 25.78 | 25.78 | 43679.0 |
| 2008-12-17 | BLV | ETF | 79.44 | 79.51 | 78.69 | 78.93 | 22400.0 |
| 2008-12-17 | BMVP | ETF | 10.6233 | 10.8415 | 10.5 | 10.6833 | 50165.0 |
| 2008-12-17 | BND | ETF | 77.95 | 78.0 | 77.37 | 77.52 | 234900.0 |
| 2008-12-17 | BNE | ETF | 4.23 | 4.62 | 4.04 | 4.59 | 168471.0 |
| 2008-12-17 | BSV | ETF | 79.35 | 79.4 | 78.92 | 79.23 | 113400.0 |
| 2008-12-17 | BTF | ETF | 46.74999999999999 | 48.75 | 46.74999999999999 | 48.349999999999994 | 10378.2 |
| 2008-12-17 | BWX | ETF | 27.41 | 27.8 | 27.35 | 27.71 | 360080.0 |
| 2008-12-17 | CBON | ETF | 2.25 | 2.36 | 2.25 | 2.3 | 24158.0 |
| 2008-12-17 | CDL | ETF | 0.17 | 0.24 | 0.17 | 0.19 | 1168918.0 |
| 2008-12-17 | CEF | ETF | 10.8 | 11.04 | 10.65 | 10.98 | 1375500.0 |
| 2008-12-17 | CGO | ETF | 8.61 | 8.66 | 8.31 | 8.47 | 28032.0 |
| 2008-12-17 | CGW | ETF | 14.61 | 15.5 | 14.61 | 15.41 | 116868.0 |
| 2008-12-17 | CHB | ETF | 0.7905 | 1.12 | 0.7901 | 1.04 | 1533124.0 |
| 2008-12-17 | CHI | ETF | 7.42 | 7.9 | 7.42 | 7.8 | 400655.0 |
| 2008-12-17 | CHIC | ETF | 5.82 | 6.16 | 5.67 | 5.97 | 201017.0 |
| 2008-12-17 | CHW | ETF | 5.16 | 5.3 | 5.07 | 5.3 | 179659.0 |
| 2008-12-17 | CHY | ETF | 6.8 | 7.25 | 6.75 | 7.2 | 527652.0 |
| 2008-12-17 | CMF | ETF | 50.365 | 50.65 | 49.245 | 49.8075 | 37926.0 |
| 2008-12-17 | CNXT | ETF | 0.85 | 0.885 | 0.82 | 0.85 | 776742.0 |
| 2008-12-17 | COW | ETF | 34.01 | 34.28 | 33.9 | 34.13 | 9295.0 |
> showing 50 of 635 rows — these rows as CSV