PREVIEW / etf_daily / 2009-05-28
file: by_date/etf_daily/2009/2009-05-28.parquet size: 29 KB rows: 655
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-05-28 | SPY | ETF | 90.46 | 91.34 | 89.1 | 90.92 | 289095000.0 |
| 2009-05-28 | QQQ | ETF | 34.77 | 35.07 | 34.21 | 34.95 | 118931250.0 |
| 2009-05-28 | IWM | ETF | 49.56 | 49.75 | 48.1 | 49.16 | 58832400.0 |
| 2009-05-28 | DIA | ETF | 83.79 | 84.45 | 82.53 | 84.02 | 17780200.0 |
| 2009-05-28 | GLD | ETF | 94.14 | 94.83 | 93.8 | 94.24 | 14973200.0 |
| 2009-05-28 | TLT | ETF | 91.77 | 91.98 | 90.23 | 91.8 | 9824300.0 |
| 2009-05-28 | AAXJ | ETF | 43.63 | 44.18 | 43.11 | 44.17 | 91100.0 |
| 2009-05-28 | ACWI | ETF | 34.4 | 34.75 | 34.08 | 34.62 | 177400.0 |
| 2009-05-28 | ACWX | ETF | 33.54 | 33.9 | 33.27 | 33.85 | 110433.0 |
| 2009-05-28 | ADRE | ETF | 35.07 | 35.6 | 34.76 | 35.59 | 200645.0 |
| 2009-05-28 | AFK | ETF | 27.73 | 27.82 | 26.8001 | 27.65 | 10665.0 |
| 2009-05-28 | AGG | ETF | 100.84 | 101.07 | 100.42 | 100.95 | 634200.0 |
| 2009-05-28 | AGQ | ETF | 103.04 | 104.48 | 101.66 | 102.66 | 108150.0 |
| 2009-05-28 | AGZ | ETF | 106.89 | 107.51 | 106.642 | 107.51 | 86273.0 |
| 2009-05-28 | AIA | ETF | 32.19 | 32.77 | 32.05 | 32.7149 | 20739.0 |
| 2009-05-28 | AIQ | ETF | 34.35 | 34.45 | 33.15 | 33.75 | 48996.0 |
| 2009-05-28 | AIS | ETF | 0.5184 | 0.55 | 0.491 | 0.53 | 81562.0 |
| 2009-05-28 | AIVI | ETF | 35.74 | 35.97 | 35.45 | 35.89 | 3500.0 |
| 2009-05-28 | AMJ | ETF | 22.17 | 22.31 | 21.89 | 22.22 | 109140.0 |
| 2009-05-28 | AOA | ETF | 24.81 | 24.9 | 24.73 | 24.73 | 3100.0 |
| 2009-05-28 | AOK | ETF | 25.48 | 25.57 | 25.48 | 25.5482 | 800.0 |
| 2009-05-28 | AOM | ETF | 25.99 | 25.99 | 25.28 | 25.501 | 1095.0 |
| 2009-05-28 | AOR | ETF | 25.27 | 25.36 | 25.0 | 25.36 | 20308.0 |
| 2009-05-28 | ARB | ETF | 20.6 | 20.71 | 19.41 | 19.94 | 222125.0 |
| 2009-05-28 | BAL | ETF | 30.93 | 30.984 | 29.88 | 30.94 | 4248.0 |
| 2009-05-28 | BBH | ETF | 29.6767 | 29.9533 | 29.4033 | 29.8067 | 450000.0 |
| 2009-05-28 | BIL | ETF | 91.76 | 91.78 | 91.72 | 91.74 | 85350.0 |
| 2009-05-28 | BITS | ETF | 19.0 | 19.0 | 18.6 | 18.72 | 2875.0 |
| 2009-05-28 | BIV | ETF | 76.09 | 76.1 | 75.31 | 75.95 | 72600.0 |
| 2009-05-28 | BJK | ETF | 21.63 | 21.82 | 20.82 | 21.47 | 9400.0 |
| 2009-05-28 | BKF | ETF | 35.15 | 35.65 | 34.67 | 35.64 | 179118.0 |
| 2009-05-28 | BLV | ETF | 71.41 | 71.67 | 70.83 | 71.62 | 17000.0 |
| 2009-05-28 | BMVP | ETF | 10.7 | 10.785 | 10.563 | 10.757 | 51683.0 |
| 2009-05-28 | BND | ETF | 76.77 | 76.97 | 76.53 | 76.93 | 328800.0 |
| 2009-05-28 | BNE | ETF | 5.64 | 5.9 | 5.25 | 5.81 | 196716.0 |
| 2009-05-28 | BOSS | ETF | 15.13 | 15.2 | 15.13 | 15.2 | 300.0 |
| 2009-05-28 | BRF | ETF | 27.3 | 27.35 | 26.756 | 27.31 | 107711.0 |
| 2009-05-28 | BSV | ETF | 78.98 | 79.1 | 78.91 | 79.03 | 134300.0 |
| 2009-05-28 | BTF | ETF | 47.15 | 47.5 | 46.699999999999996 | 47.5 | 4987.0 |
| 2009-05-28 | BWX | ETF | 26.765 | 26.83 | 26.7 | 26.77 | 248530.0 |
| 2009-05-28 | BWZ | ETF | 34.88 | 34.9099 | 34.8 | 34.8 | 7484.0 |
| 2009-05-28 | CBON | ETF | 1.29 | 1.3 | 1.1 | 1.1601 | 59263.0 |
| 2009-05-28 | CEF | ETF | 12.21 | 12.47 | 12.21 | 12.29 | 1261500.0 |
| 2009-05-28 | CEW | ETF | 20.8 | 20.8 | 20.5 | 20.62 | 50826.0 |
| 2009-05-28 | CGO | ETF | 11.3 | 11.31 | 10.85 | 11.1099 | 65205.0 |
| 2009-05-28 | CGW | ETF | 14.79 | 15.02 | 14.6954 | 14.98 | 31743.0 |
| 2009-05-28 | CHB | ETF | 0.45 | 0.46 | 0.4 | 0.41 | 704298.0 |
| 2009-05-28 | CHI | ETF | 10.26 | 10.45 | 10.26 | 10.4 | 209253.0 |
| 2009-05-28 | CHIC | ETF | 10.15 | 10.4 | 9.58 | 9.75 | 233643.0 |
| 2009-05-28 | CHW | ETF | 6.94 | 7.1 | 6.69 | 7.0532 | 277247.0 |
> showing 50 of 655 rows — these rows as CSV