PREVIEW / etf_daily / 2008-11-06
file: by_date/etf_daily/2008/2008-11-06.parquet size: 27 KB rows: 611
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-06 | SPY | ETF | 94.46 | 95.44 | 90.06 | 90.86 | 477721900.0 |
| 2008-11-06 | QQQ | ETF | 31.5 | 31.87 | 30.3999 | 30.56 | 220780463.0 |
| 2008-11-06 | IWM | ETF | 51.05 | 51.7 | 49.54 | 49.59 | 85233800.0 |
| 2008-11-06 | DIA | ETF | 90.79 | 91.66 | 86.48 | 87.13 | 43601900.0 |
| 2008-11-06 | GLD | ETF | 74.36 | 74.98 | 71.67 | 72.22 | 10687500.0 |
| 2008-11-06 | TLT | ETF | 94.6 | 95.05 | 93.81 | 94.88 | 919700.0 |
| 2008-11-06 | AAXJ | ETF | 31.83 | 31.83 | 29.23 | 29.23 | 118700.0 |
| 2008-11-06 | ACWI | ETF | 32.82 | 33.13 | 31.16 | 31.26 | 65000.0 |
| 2008-11-06 | ACWX | ETF | 30.4 | 31.75 | 29.27 | 29.33 | 1561634.0 |
| 2008-11-06 | ADRE | ETF | 26.5 | 26.58 | 24.86 | 25.04 | 1071428.0 |
| 2008-11-06 | AFK | ETF | 22.53 | 22.53 | 22.53 | 22.53 | 350.0 |
| 2008-11-06 | AGG | ETF | 97.49 | 97.49 | 96.31 | 96.6 | 516000.0 |
| 2008-11-06 | AIA | ETF | 24.72 | 24.72 | 23.934 | 24.062 | 16954.0 |
| 2008-11-06 | AIQ | ETF | 41.3 | 44.65 | 41.15 | 44.55 | 122811.0 |
| 2008-11-06 | AIS | ETF | 0.52 | 0.52 | 0.48 | 0.5 | 5100.0 |
| 2008-11-06 | AIVI | ETF | 38.72 | 38.79 | 36.5 | 36.5 | 22300.0 |
| 2008-11-06 | ARB | ETF | 31.28 | 31.67 | 30.06 | 30.23 | 158378.0 |
| 2008-11-06 | BBH | ETF | 57.23 | 58.11 | 56.1567 | 56.4867 | 323100.0 |
| 2008-11-06 | BIL | ETF | 91.72 | 91.94 | 91.72 | 91.9 | 118100.0 |
| 2008-11-06 | BITS | ETF | 16.12 | 16.12 | 15.32 | 15.56 | 950.0 |
| 2008-11-06 | BIV | ETF | 71.77 | 71.91 | 70.93 | 71.91 | 38700.0 |
| 2008-11-06 | BJK | ETF | 17.79 | 17.79 | 16.13 | 17.13 | 8100.0 |
| 2008-11-06 | BKF | ETF | 24.99 | 24.99 | 23.29 | 23.77 | 69766.0 |
| 2008-11-06 | BLV | ETF | 67.79 | 68.12 | 66.96 | 67.98 | 12700.0 |
| 2008-11-06 | BMVP | ETF | 10.76 | 10.84 | 10.39 | 10.39 | 13494.0 |
| 2008-11-06 | BND | ETF | 74.4 | 74.83 | 74.16 | 74.76 | 238400.0 |
| 2008-11-06 | BNE | ETF | 8.43 | 8.58 | 8.16 | 8.17 | 98929.0 |
| 2008-11-06 | BOSS | ETF | 15.8 | 16.0 | 15.8 | 16.0 | 600.0 |
| 2008-11-06 | BRF | ETF | 14.9099 | 14.91 | 14.9099 | 14.91 | 800.0 |
| 2008-11-06 | BSV | ETF | 76.0 | 76.39 | 75.54 | 75.96 | 86200.0 |
| 2008-11-06 | BTF | ETF | 65.99999999999999 | 65.99999999999999 | 60.55 | 60.7 | 14775.0 |
| 2008-11-06 | BWX | ETF | 24.87 | 24.875 | 24.5 | 24.705 | 189138.0 |
| 2008-11-06 | CBON | ETF | 4.02 | 4.05 | 3.97 | 4.0 | 21724.0 |
| 2008-11-06 | CDL | ETF | 0.26 | 0.32 | 0.25 | 0.26 | 2081260.0 |
| 2008-11-06 | CEF | ETF | 9.57 | 9.7 | 9.08 | 9.2 | 504600.0 |
| 2008-11-06 | CGO | ETF | 9.73 | 9.73 | 9.18 | 9.25 | 32210.0 |
| 2008-11-06 | CGW | ETF | 15.68 | 16.1684 | 15.11 | 15.26 | 80030.0 |
| 2008-11-06 | CHB | ETF | 1.79 | 2.01 | 1.71 | 1.85 | 1129285.0 |
| 2008-11-06 | CHI | ETF | 8.96 | 9.03 | 8.58 | 8.73 | 196029.0 |
| 2008-11-06 | CHIC | ETF | 7.91 | 8.46 | 7.85 | 7.94 | 241216.0 |
| 2008-11-06 | CHW | ETF | 6.5 | 7.71 | 5.8 | 6.07 | 132100.0 |
| 2008-11-06 | CHY | ETF | 8.9 | 8.97 | 8.55 | 8.75 | 270714.0 |
| 2008-11-06 | CMF | ETF | 51.63 | 52.15 | 51.25 | 51.8291 | 27972.0 |
| 2008-11-06 | CNXT | ETF | 1.57 | 1.72 | 1.56 | 1.59 | 695545.0 |
| 2008-11-06 | COW | ETF | 35.9 | 35.99 | 35.72 | 35.85 | 7783.0 |
| 2008-11-06 | CPI | ETF | 22.86 | 22.86 | 22.86 | 22.86 | 143.0 |
| 2008-11-06 | CPST | ETF | 1.47 | 1.57 | 1.255 | 1.29 | 3911090.0 |
| 2008-11-06 | CSA | ETF | 11.25 | 11.56 | 10.95 | 11.21 | 100545.0 |
| 2008-11-06 | CSB | ETF | 16.0 | 16.75 | 16.0 | 16.1 | 47350.0 |
| 2008-11-06 | CSD | ETF | 12.99 | 13.06 | 12.91 | 12.91 | 1000.0 |
> showing 50 of 611 rows — these rows as CSV