PREVIEW / etf_daily / 2009-06-10
file: by_date/etf_daily/2009/2009-06-10.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-10 | SPY | ETF | 95.48 | 95.49 | 93.19 | 94.4 | 296100400.0 |
| 2009-06-10 | QQQ | ETF | 37.17 | 37.18 | 36.29 | 36.82 | 133404603.0 |
| 2009-06-10 | IWM | ETF | 53.38 | 53.41 | 51.61 | 52.6 | 65032200.0 |
| 2009-06-10 | DIA | ETF | 88.55 | 88.58 | 86.58 | 87.65 | 25155700.0 |
| 2009-06-10 | GLD | ETF | 94.5 | 94.53 | 92.9 | 93.86 | 14441800.0 |
| 2009-06-10 | TLT | ETF | 88.87 | 89.43 | 87.56 | 88.19 | 12142000.0 |
| 2009-06-10 | AAXJ | ETF | 46.18 | 46.18 | 45.15 | 45.73 | 795700.0 |
| 2009-06-10 | ACWI | ETF | 36.22 | 36.22 | 35.38 | 35.81 | 2074200.0 |
| 2009-06-10 | ACWX | ETF | 35.24 | 35.24 | 34.42 | 34.85 | 48033.0 |
| 2009-06-10 | ADRE | ETF | 36.93 | 36.93 | 35.95 | 36.52 | 127391.0 |
| 2009-06-10 | AFK | ETF | 28.27 | 28.8 | 27.6001 | 27.93 | 41192.0 |
| 2009-06-10 | AGG | ETF | 100.01 | 100.54 | 99.97 | 99.97 | 772600.0 |
| 2009-06-10 | AGQ | ETF | 105.2 | 105.28 | 100.18 | 102.58 | 117550.0 |
| 2009-06-10 | AGZ | ETF | 106.18 | 106.1946 | 105.628 | 105.972 | 6010.0 |
| 2009-06-10 | AIA | ETF | 33.58 | 33.58 | 32.78 | 32.98 | 24325.0 |
| 2009-06-10 | AIQ | ETF | 36.15 | 36.3 | 35.2 | 35.95 | 31227.0 |
| 2009-06-10 | AIS | ETF | 0.7 | 0.77 | 0.7 | 0.77 | 118365.0 |
| 2009-06-10 | AIVI | ETF | 36.97 | 36.97 | 35.9 | 36.23 | 28800.0 |
| 2009-06-10 | AMJ | ETF | 23.02 | 23.02 | 22.55 | 22.68 | 95106.0 |
| 2009-06-10 | AOA | ETF | 25.8 | 25.8 | 25.56 | 25.79 | 4800.0 |
| 2009-06-10 | AOK | ETF | 25.8295 | 25.8295 | 25.68 | 25.68 | 2555.0 |
| 2009-06-10 | AOM | ETF | 26.1 | 26.1 | 25.76 | 25.8764 | 3506.0 |
| 2009-06-10 | AOR | ETF | 26.0456 | 26.0456 | 25.7399 | 25.9 | 3360.0 |
| 2009-06-10 | ARB | ETF | 20.47 | 20.61 | 18.82 | 19.02 | 401172.0 |
| 2009-06-10 | BAL | ETF | 31.34 | 31.34 | 30.64 | 31.05 | 2802.0 |
| 2009-06-10 | BBH | ETF | 30.9133 | 31.1 | 30.16 | 30.49 | 411900.0 |
| 2009-06-10 | BIL | ETF | 91.72 | 91.74 | 91.68 | 91.72 | 124200.0 |
| 2009-06-10 | BITS | ETF | 20.0 | 20.0 | 19.12 | 19.12 | 2024.0 |
| 2009-06-10 | BIV | ETF | 75.21 | 75.25 | 74.64 | 74.87 | 101000.0 |
| 2009-06-10 | BJK | ETF | 21.97 | 22.6 | 21.53 | 22.04 | 19800.0 |
| 2009-06-10 | BKF | ETF | 37.88 | 38.04 | 36.91 | 37.25 | 411937.0 |
| 2009-06-10 | BLV | ETF | 71.57 | 72.11 | 71.31 | 71.57 | 24400.0 |
| 2009-06-10 | BMVP | ETF | 11.22 | 11.23 | 11.0 | 11.08 | 15488.0 |
| 2009-06-10 | BND | ETF | 76.28 | 76.39 | 76.0 | 76.1 | 379800.0 |
| 2009-06-10 | BNE | ETF | 6.75 | 6.89 | 6.42 | 6.83 | 146806.0 |
| 2009-06-10 | BOSS | ETF | 16.47 | 16.47 | 16.44 | 16.44 | 100.0 |
| 2009-06-10 | BRF | ETF | 28.74 | 28.74 | 27.5901 | 28.07 | 112334.0 |
| 2009-06-10 | BSV | ETF | 78.26 | 78.43 | 78.26 | 78.36 | 182700.0 |
| 2009-06-10 | BTF | ETF | 49.45 | 49.5 | 48.05 | 48.699999999999996 | 12682.6 |
| 2009-06-10 | BWX | ETF | 26.87 | 26.87 | 26.61 | 26.615 | 377872.0 |
| 2009-06-10 | BWZ | ETF | 34.99 | 34.99 | 34.745 | 34.745 | 3048.0 |
| 2009-06-10 | CBON | ETF | 1.7199 | 1.7199 | 1.45 | 1.45 | 22954.0 |
| 2009-06-10 | CEF | ETF | 12.43 | 12.69 | 12.38 | 12.66 | 3676500.0 |
| 2009-06-10 | CEW | ETF | 20.77 | 20.77 | 20.656 | 20.7 | 24122.0 |
| 2009-06-10 | CGO | ETF | 11.95 | 11.98 | 11.54 | 11.6681 | 39329.0 |
| 2009-06-10 | CGW | ETF | 15.9 | 15.96 | 15.44 | 15.6819 | 89051.0 |
| 2009-06-10 | CHB | ETF | 0.47 | 0.51 | 0.46 | 0.49 | 693241.0 |
| 2009-06-10 | CHI | ETF | 10.82 | 10.89 | 10.5904 | 10.66 | 136231.0 |
| 2009-06-10 | CHIC | ETF | 11.88 | 11.94 | 11.34 | 11.55 | 409145.0 |
| 2009-06-10 | CHW | ETF | 7.52 | 7.5701 | 6.85 | 7.07 | 670935.0 |
> showing 50 of 661 rows — these rows as CSV