PREVIEW / etf_daily / 2009-04-22
file: by_date/etf_daily/2009/2009-04-22.parquet size: 29 KB rows: 648
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-04-22 | SPY | ETF | 84.29 | 86.34 | 84.07 | 84.54 | 340395200.0 |
| 2009-04-22 | QQQ | ETF | 32.5 | 33.53 | 32.39 | 32.79 | 165040476.0 |
| 2009-04-22 | IWM | ETF | 46.19 | 48.16 | 46.03 | 46.86 | 72784100.0 |
| 2009-04-22 | DIA | ETF | 79.03 | 80.45 | 78.66 | 78.81 | 20467800.0 |
| 2009-04-22 | GLD | ETF | 87.03 | 87.82 | 86.8 | 87.38 | 10085900.0 |
| 2009-04-22 | TLT | ETF | 102.45 | 102.56 | 101.11 | 101.6 | 2278100.0 |
| 2009-04-22 | AAXJ | ETF | 36.46 | 37.32 | 36.26 | 36.51 | 102200.0 |
| 2009-04-22 | ACWI | ETF | 30.23 | 31.03 | 30.23 | 30.42 | 325700.0 |
| 2009-04-22 | ACWX | ETF | 28.39 | 29.07 | 28.36 | 28.54 | 52501.0 |
| 2009-04-22 | ADRE | ETF | 29.36 | 29.85 | 29.16 | 29.3 | 223875.0 |
| 2009-04-22 | AFK | ETF | 20.54 | 20.86 | 20.54 | 20.8 | 2164.0 |
| 2009-04-22 | AGG | ETF | 101.02 | 101.26 | 100.85 | 101.2 | 448500.0 |
| 2009-04-22 | AGQ | ETF | 67.74 | 69.98 | 67.48 | 69.32 | 94200.0 |
| 2009-04-22 | AGZ | ETF | 108.122 | 108.122 | 107.5 | 107.8277 | 2754.0 |
| 2009-04-22 | AIA | ETF | 27.61 | 28.12 | 27.5 | 27.65 | 6986.0 |
| 2009-04-22 | AIQ | ETF | 41.45 | 42.05 | 40.8 | 41.3 | 23027.0 |
| 2009-04-22 | AIS | ETF | 0.4 | 0.43 | 0.4 | 0.411 | 7386.0 |
| 2009-04-22 | AIVI | ETF | 30.1 | 30.85 | 30.1 | 30.53 | 9100.0 |
| 2009-04-22 | AMJ | ETF | 20.25 | 20.28 | 20.0 | 20.2 | 184106.0 |
| 2009-04-22 | AOA | ETF | 23.58 | 23.58 | 23.01 | 23.41 | 1100.0 |
| 2009-04-22 | AOK | ETF | 25.21 | 25.21 | 25.1268 | 25.14 | 1048.0 |
| 2009-04-22 | AOM | ETF | 24.45 | 24.8261 | 24.45 | 24.5 | 2100.0 |
| 2009-04-22 | AOR | ETF | 23.7401 | 24.15 | 23.26 | 24.14 | 2938.0 |
| 2009-04-22 | ARB | ETF | 19.65 | 21.1 | 19.53 | 20.8 | 761918.0 |
| 2009-04-22 | BAL | ETF | 28.65 | 28.8099 | 28.4301 | 28.4301 | 6200.0 |
| 2009-04-22 | BBH | ETF | 28.6567 | 29.17 | 28.4167 | 28.5133 | 763800.0 |
| 2009-04-22 | BIL | ETF | 91.72 | 91.74 | 91.7 | 91.74 | 95150.0 |
| 2009-04-22 | BITS | ETF | 17.64 | 17.72 | 16.68 | 17.64 | 1019.0 |
| 2009-04-22 | BIV | ETF | 76.69 | 76.7 | 76.37 | 76.69 | 57800.0 |
| 2009-04-22 | BJK | ETF | 17.04 | 18.86 | 17.04 | 18.1 | 4600.0 |
| 2009-04-22 | BKF | ETF | 28.95 | 30.46 | 27.4 | 27.78 | 57862.0 |
| 2009-04-22 | BLV | ETF | 73.45 | 73.46 | 71.75 | 72.75 | 81500.0 |
| 2009-04-22 | BMVP | ETF | 10.327 | 10.586 | 10.29 | 10.36 | 25465.0 |
| 2009-04-22 | BND | ETF | 77.18 | 77.22 | 76.94 | 77.21 | 379400.0 |
| 2009-04-22 | BNE | ETF | 4.71 | 5.35 | 4.51 | 5.34 | 510239.0 |
| 2009-04-22 | BOSS | ETF | 14.0 | 14.64 | 14.0 | 14.64 | 100.0 |
| 2009-04-22 | BSV | ETF | 78.8 | 78.82 | 78.56 | 78.58 | 222900.0 |
| 2009-04-22 | BTF | ETF | 45.14999999999999 | 45.49999999999999 | 45.05 | 45.14999999999999 | 2830.0 |
| 2009-04-22 | BWX | ETF | 25.425 | 25.495 | 25.35 | 25.365 | 138686.0 |
| 2009-04-22 | BWZ | ETF | 32.74 | 32.7702 | 32.74 | 32.7702 | 265.0 |
| 2009-04-22 | CBON | ETF | 2.81 | 2.81 | 2.49 | 2.49 | 32392.0 |
| 2009-04-22 | CEF | ETF | 10.88 | 11.06 | 10.84 | 11.05 | 823500.0 |
| 2009-04-22 | CGO | ETF | 9.31 | 9.56 | 9.31 | 9.5 | 11450.0 |
| 2009-04-22 | CGW | ETF | 13.12 | 13.324 | 12.8836 | 13.0 | 40144.0 |
| 2009-04-22 | CHB | ETF | 0.61 | 0.63 | 0.55 | 0.56 | 400703.0 |
| 2009-04-22 | CHI | ETF | 9.03 | 9.29 | 9.01 | 9.19 | 136819.0 |
| 2009-04-22 | CHIC | ETF | 12.35 | 12.72 | 12.18 | 12.38 | 741520.0 |
| 2009-04-22 | CHW | ETF | 6.0 | 6.23 | 5.8 | 6.0 | 279307.0 |
| 2009-04-22 | CHY | ETF | 8.83 | 9.09 | 8.82 | 9.0 | 221503.0 |
| 2009-04-22 | CMF | ETF | 52.19 | 52.21 | 52.125 | 52.21 | 4516.0 |
> showing 50 of 648 rows — these rows as CSV