PREVIEW / etf_daily / 2009-04-28
file: by_date/etf_daily/2009/2009-04-28.parquet size: 28 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-28 | SPY | ETF | 84.97 | 86.59 | 84.76 | 85.57 | 247926300.0 |
| 2009-04-28 | QQQ | ETF | 33.52 | 33.91 | 33.36 | 33.48 | 108967966.0 |
| 2009-04-28 | IWM | ETF | 46.54 | 47.99 | 46.38 | 47.18 | 51197500.0 |
| 2009-04-28 | DIA | ETF | 79.47 | 80.95 | 79.37 | 80.12 | 16457900.0 |
| 2009-04-28 | GLD | ETF | 87.33 | 87.95 | 87.11 | 87.75 | 8570100.0 |
| 2009-04-28 | TLT | ETF | 101.5 | 101.58 | 99.09 | 99.35 | 2332500.0 |
| 2009-04-28 | AAXJ | ETF | 35.79 | 36.33 | 35.51 | 36.07 | 157000.0 |
| 2009-04-28 | ACWI | ETF | 30.6 | 31.25 | 30.56 | 30.98 | 139200.0 |
| 2009-04-28 | ACWX | ETF | 28.78 | 29.29 | 28.63 | 29.16 | 326466.0 |
| 2009-04-28 | ADRE | ETF | 29.2 | 29.68 | 28.96 | 29.41 | 190956.0 |
| 2009-04-28 | AFK | ETF | 21.3 | 21.3 | 21.08 | 21.112 | 4000.0 |
| 2009-04-28 | AGG | ETF | 101.91 | 101.91 | 101.41 | 101.57 | 397800.0 |
| 2009-04-28 | AGQ | ETF | 70.94 | 71.42 | 70.0 | 70.9 | 66050.0 |
| 2009-04-28 | AGZ | ETF | 108.29 | 108.43 | 107.535 | 108.0 | 11464.0 |
| 2009-04-28 | AIA | ETF | 27.0 | 27.33 | 27.0 | 27.24 | 16698.0 |
| 2009-04-28 | AIQ | ETF | 39.0 | 41.65 | 39.0 | 40.65 | 69537.0 |
| 2009-04-28 | AIS | ETF | 0.41 | 0.42 | 0.39 | 0.4 | 58824.0 |
| 2009-04-28 | AIVI | ETF | 30.74 | 31.09 | 30.64 | 30.94 | 10900.0 |
| 2009-04-28 | AMJ | ETF | 21.0 | 21.32 | 20.9999 | 21.28 | 16707.0 |
| 2009-04-28 | AOA | ETF | 23.32 | 23.63 | 23.32 | 23.63 | 3200.0 |
| 2009-04-28 | AOK | ETF | 25.2968 | 25.32 | 25.26 | 25.27 | 3214.0 |
| 2009-04-28 | AOM | ETF | 24.69 | 24.99 | 24.64 | 24.64 | 6306.0 |
| 2009-04-28 | AOR | ETF | 24.07 | 24.18 | 24.0 | 24.16 | 5596.0 |
| 2009-04-28 | ARB | ETF | 21.83 | 21.83 | 21.03 | 21.73 | 620774.0 |
| 2009-04-28 | BAL | ETF | 29.92 | 29.92 | 29.49 | 29.55 | 2650.0 |
| 2009-04-28 | BBH | ETF | 30.02 | 30.51 | 29.92 | 30.18 | 640800.0 |
| 2009-04-28 | BIL | ETF | 91.72 | 91.78 | 91.72 | 91.78 | 300600.0 |
| 2009-04-28 | BITS | ETF | 17.72 | 17.72 | 17.6 | 17.6 | 50.0 |
| 2009-04-28 | BIV | ETF | 76.89 | 76.89 | 76.24 | 76.45 | 101400.0 |
| 2009-04-28 | BJK | ETF | 19.04 | 19.04 | 18.43 | 18.9 | 3600.0 |
| 2009-04-28 | BKF | ETF | 27.68 | 28.18 | 27.68 | 28.09 | 235844.0 |
| 2009-04-28 | BLV | ETF | 72.78 | 73.35 | 72.1 | 72.16 | 12400.0 |
| 2009-04-28 | BMVP | ETF | 10.2958 | 10.4555 | 10.2958 | 10.356 | 24658.0 |
| 2009-04-28 | BND | ETF | 77.43 | 77.43 | 76.97 | 77.12 | 431400.0 |
| 2009-04-28 | BNE | ETF | 4.92 | 5.43 | 4.8 | 5.24 | 220533.0 |
| 2009-04-28 | BSV | ETF | 79.1 | 79.1 | 78.82 | 78.98 | 215100.0 |
| 2009-04-28 | BTF | ETF | 45.05 | 45.65 | 45.05 | 45.49999999999999 | 11388.0 |
| 2009-04-28 | BWX | ETF | 25.645 | 25.875 | 25.645 | 25.875 | 138732.0 |
| 2009-04-28 | BWZ | ETF | 33.3 | 33.3 | 33.3 | 33.3 | 140.0 |
| 2009-04-28 | CBON | ETF | 2.34 | 2.43 | 2.3 | 2.3 | 6110.0 |
| 2009-04-28 | CEF | ETF | 11.11 | 11.25 | 11.11 | 11.25 | 591800.0 |
| 2009-04-28 | CGO | ETF | 9.52 | 9.7 | 9.2 | 9.66 | 11170.0 |
| 2009-04-28 | CGW | ETF | 13.18 | 13.5 | 13.18 | 13.42 | 51491.0 |
| 2009-04-28 | CHB | ETF | 0.58 | 0.61 | 0.57 | 0.6 | 510294.0 |
| 2009-04-28 | CHI | ETF | 9.38 | 9.44 | 9.27 | 9.33 | 155904.0 |
| 2009-04-28 | CHIC | ETF | 11.87 | 12.67 | 11.87 | 12.22 | 434263.0 |
| 2009-04-28 | CHW | ETF | 6.25 | 6.36 | 6.2 | 6.35 | 135307.0 |
| 2009-04-28 | CHY | ETF | 9.04 | 9.2 | 8.94 | 9.09 | 234014.0 |
| 2009-04-28 | CMF | ETF | 52.77 | 52.77 | 52.475 | 52.595 | 18774.0 |
| 2009-04-28 | CNXT | ETF | 1.2 | 1.29 | 1.11 | 1.25 | 544037.0 |
> showing 50 of 648 rows — these rows as CSV