PREVIEW / etf_daily / 2009-06-16
file: by_date/etf_daily/2009/2009-06-16.parquet size: 29 KB rows: 661
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-16 | SPY | ETF | 93.23 | 93.29 | 91.58 | 91.64 | 227319000.0 |
| 2009-06-16 | QQQ | ETF | 36.06 | 36.19 | 35.52 | 35.55 | 110550209.0 |
| 2009-06-16 | IWM | ETF | 51.75 | 51.84 | 50.32 | 50.5 | 53065700.0 |
| 2009-06-16 | DIA | ETF | 86.69 | 86.76 | 85.22 | 85.26 | 12830900.0 |
| 2009-06-16 | GLD | ETF | 91.87 | 92.12 | 91.35 | 91.93 | 9834200.0 |
| 2009-06-16 | TLT | ETF | 90.96 | 92.43 | 90.8 | 92.36 | 5376000.0 |
| 2009-06-16 | AAXJ | ETF | 44.2 | 44.22 | 43.08 | 43.31 | 229600.0 |
| 2009-06-16 | ACWI | ETF | 35.09 | 35.22 | 34.53 | 34.62 | 124300.0 |
| 2009-06-16 | ACWX | ETF | 34.01 | 34.12 | 33.45 | 33.6 | 114875.0 |
| 2009-06-16 | ADRE | ETF | 35.7 | 35.71 | 34.61 | 34.69 | 843545.0 |
| 2009-06-16 | AFK | ETF | 28.0 | 28.0 | 27.01 | 27.05 | 47398.0 |
| 2009-06-16 | AGG | ETF | 101.13 | 101.43 | 100.95 | 101.33 | 430900.0 |
| 2009-06-16 | AGQ | ETF | 89.3 | 90.36 | 87.66 | 89.1 | 102100.0 |
| 2009-06-16 | AGZ | ETF | 106.95 | 107.05 | 106.614 | 107.05 | 15081.0 |
| 2009-06-16 | AIA | ETF | 31.89 | 32.04 | 31.296 | 31.334 | 29104.0 |
| 2009-06-16 | AIQ | ETF | 34.6 | 34.8 | 33.25 | 33.8 | 62987.0 |
| 2009-06-16 | AIS | ETF | 0.71 | 0.74 | 0.67 | 0.7 | 94498.0 |
| 2009-06-16 | AIVI | ETF | 35.99 | 36.05 | 35.21 | 35.53 | 3200.0 |
| 2009-06-16 | AMJ | ETF | 22.86 | 22.86 | 22.147 | 22.29 | 67447.0 |
| 2009-06-16 | AOA | ETF | 25.5 | 25.5 | 25.08 | 25.09 | 4600.0 |
| 2009-06-16 | AOK | ETF | 25.66 | 25.978 | 25.51 | 25.66 | 11320.0 |
| 2009-06-16 | AOM | ETF | 25.78 | 25.79 | 25.56 | 25.61 | 7656.0 |
| 2009-06-16 | AOR | ETF | 25.43 | 25.4401 | 25.4099 | 25.41 | 1750.0 |
| 2009-06-16 | ARB | ETF | 19.09 | 19.26 | 18.41 | 18.5 | 136286.0 |
| 2009-06-16 | BAL | ETF | 30.4 | 30.57 | 29.51 | 29.71 | 27702.0 |
| 2009-06-16 | BBH | ETF | 29.9633 | 30.4333 | 29.8333 | 30.2633 | 402000.0 |
| 2009-06-16 | BIL | ETF | 91.74 | 91.76 | 91.7 | 91.76 | 711450.0 |
| 2009-06-16 | BITS | ETF | 19.28 | 19.32 | 18.7 | 18.7 | 262.0 |
| 2009-06-16 | BIV | ETF | 75.95 | 76.39 | 75.95 | 76.39 | 62100.0 |
| 2009-06-16 | BJK | ETF | 21.05 | 21.54 | 20.89 | 21.2 | 26700.0 |
| 2009-06-16 | BKF | ETF | 36.5 | 36.63 | 35.37 | 35.58 | 272489.0 |
| 2009-06-16 | BLV | ETF | 72.92 | 72.96 | 72.46 | 72.96 | 15200.0 |
| 2009-06-16 | BMVP | ETF | 10.95 | 10.95 | 10.78 | 10.78 | 13306.0 |
| 2009-06-16 | BND | ETF | 76.87 | 77.19 | 76.82 | 77.18 | 381900.0 |
| 2009-06-16 | BNE | ETF | 6.91 | 6.91 | 6.61 | 6.7 | 76575.0 |
| 2009-06-16 | BOSS | ETF | 16.03 | 16.03 | 15.86 | 16.03 | 300.0 |
| 2009-06-16 | BRF | ETF | 28.02 | 28.02 | 27.0 | 27.12 | 111393.0 |
| 2009-06-16 | BSV | ETF | 78.74 | 78.81 | 78.61 | 78.65 | 473600.0 |
| 2009-06-16 | BTF | ETF | 48.099999999999994 | 48.65 | 47.599999999999994 | 47.9 | 8418.6 |
| 2009-06-16 | BWX | ETF | 26.805 | 26.88 | 26.715 | 26.715 | 133508.0 |
| 2009-06-16 | BWZ | ETF | 34.84 | 34.84 | 34.84 | 34.84 | 500.0 |
| 2009-06-16 | CBON | ETF | 1.453 | 1.47 | 1.4 | 1.45 | 13400.0 |
| 2009-06-16 | CEF | ETF | 12.28 | 12.28 | 11.95 | 12.02 | 683000.0 |
| 2009-06-16 | CEW | ETF | 20.84 | 21.19 | 20.6 | 20.63 | 25373.0 |
| 2009-06-16 | CGO | ETF | 11.56 | 11.65 | 11.12 | 11.26 | 37724.0 |
| 2009-06-16 | CGW | ETF | 15.53 | 15.53 | 15.09 | 15.12 | 40694.0 |
| 2009-06-16 | CHB | ETF | 0.441 | 0.46 | 0.441 | 0.45 | 189473.0 |
| 2009-06-16 | CHI | ETF | 10.34 | 10.62 | 10.332 | 10.58 | 187380.0 |
| 2009-06-16 | CHIC | ETF | 11.87 | 11.87 | 11.54 | 11.7 | 207948.0 |
| 2009-06-16 | CHW | ETF | 6.84 | 6.9 | 6.8 | 6.87 | 336019.0 |
> showing 50 of 661 rows — these rows as CSV