PREVIEW / etf_daily / 2005-11-29
file: by_date/etf_daily/2005/2005-11-29.parquet size: 15 KB rows: 289
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-29 | SPY | ETF | 126.65 | 126.98 | 126.09 | 126.09 | 51738900.0 |
| 2005-11-29 | QQQ | ETF | 41.76 | 41.85 | 41.34 | 41.343 | 77444739.0 |
| 2005-11-29 | IWM | ETF | 67.1 | 67.57 | 66.85 | 67.16 | 23177100.0 |
| 2005-11-29 | DIA | ETF | 109.31 | 109.59 | 108.87 | 108.89 | 6523900.0 |
| 2005-11-29 | GLD | ETF | 49.57 | 49.98 | 49.38 | 49.8 | 2283600.0 |
| 2005-11-29 | TLT | ETF | 91.08 | 91.11 | 90.03 | 90.1 | 889200.0 |
| 2005-11-29 | AAA | ETF | 53.14 | 53.31 | 52.88 | 53.18 | 3200.0 |
| 2005-11-29 | ADRE | ETF | 111.89 | 113.0 | 110.5 | 111.2 | 23176.0 |
| 2005-11-29 | AFK | ETF | 25.48 | 25.48 | 25.4 | 25.41 | 7300.0 |
| 2005-11-29 | AGG | ETF | 100.8 | 100.83 | 100.3 | 100.43 | 199900.0 |
| 2005-11-29 | AIQ | ETF | 27.85 | 28.3 | 27.1 | 27.55 | 13480.0 |
| 2005-11-29 | AIS | ETF | 1.26 | 1.42 | 1.22 | 1.26 | 1917900.0 |
| 2005-11-29 | AOM | ETF | 3.5 | 3.5 | 3.45 | 3.48 | 9500.0 |
| 2005-11-29 | ARB | ETF | 38.75 | 39.11 | 38.45 | 38.63 | 88700.0 |
| 2005-11-29 | BAB | ETF | 54.2 | 54.24 | 53.42 | 53.42 | 16300.0 |
| 2005-11-29 | BBC | ETF | 10.59 | 10.59 | 9.52 | 10.0 | 239100.0 |
| 2005-11-29 | BBH | ETF | 68.8633 | 68.8633 | 68.0767 | 68.1167 | 1364400.0 |
| 2005-11-29 | BCM | ETF | 65.37 | 65.61 | 65.04 | 65.19 | 10100.0 |
| 2005-11-29 | BITS | ETF | 13.2 | 13.56 | 13.2 | 13.48 | 2230.0 |
| 2005-11-29 | BKF | ETF | 22.06 | 22.07 | 20.71 | 20.74 | 105400.0 |
| 2005-11-29 | BNE | ETF | 14.99 | 15.3 | 14.95 | 15.0 | 132700.0 |
| 2005-11-29 | BOSS | ETF | 29.8 | 29.96 | 29.8 | 29.96 | 100.0 |
| 2005-11-29 | BRF | ETF | 15.14 | 15.14 | 15.06 | 15.06 | 6900.0 |
| 2005-11-29 | BTF | ETF | 89.0 | 89.14999999999999 | 88.75 | 88.75 | 8440.0 |
| 2005-11-29 | CBON | ETF | 32.85 | 33.07 | 32.25 | 32.76 | 12475.0 |
| 2005-11-29 | CDL | ETF | 13.55 | 13.58 | 13.41 | 13.5 | 223800.0 |
| 2005-11-29 | CEF | ETF | 6.25 | 6.3 | 6.21 | 6.29 | 712800.0 |
| 2005-11-29 | CEW | ETF | 25.85 | 25.97 | 25.85 | 25.95 | 7300.0 |
| 2005-11-29 | CGO | ETF | 13.19 | 13.44 | 13.19 | 13.35 | 49500.0 |
| 2005-11-29 | CHB | ETF | 14.45 | 14.68 | 14.2603 | 14.38 | 425800.0 |
| 2005-11-29 | CHI | ETF | 19.96 | 20.33 | 19.9435 | 20.19 | 82700.0 |
| 2005-11-29 | CHIC | ETF | 17.76 | 18.53 | 17.66 | 18.47 | 501267.0 |
| 2005-11-29 | CHIR | ETF | 44.3499 | 44.49 | 44.25 | 44.25 | 833859.0 |
| 2005-11-29 | CHY | ETF | 15.65 | 15.76 | 15.61 | 15.72 | 92900.0 |
| 2005-11-29 | CIL | ETF | 25.14 | 25.25 | 25.13 | 25.15 | 1500.0 |
| 2005-11-29 | CIZ | ETF | 21.6 | 21.6 | 21.6 | 21.6 | 500.0 |
| 2005-11-29 | CN | ETF | 32.35 | 32.38 | 32.3 | 32.37 | 2500.0 |
| 2005-11-29 | CNXT | ETF | 2.54 | 2.54 | 2.36 | 2.42 | 7872494.0 |
| 2005-11-29 | CPI | ETF | 26.4 | 26.49 | 26.4 | 26.49 | 5500.0 |
| 2005-11-29 | CPST | ETF | 3.56 | 3.61 | 3.33 | 3.36 | 6396094.0 |
| 2005-11-29 | CSA | ETF | 16.9 | 16.9 | 16.75 | 16.88 | 82000.0 |
| 2005-11-29 | CSB | ETF | 29.44 | 29.58 | 29.39 | 29.5 | 13400.0 |
| 2005-11-29 | CSM | ETF | 2.4425 | 2.4425 | 2.4425 | 2.4425 | 2000.0 |
| 2005-11-29 | CSQ | ETF | 13.2 | 13.23 | 13.11 | 13.17 | 491800.0 |
| 2005-11-29 | CTEC | ETF | 46.3 | 47.5 | 46.25 | 46.25 | 9846.2 |
| 2005-11-29 | CURE | ETF | 0.085 | 0.0887 | 0.0813 | 0.085 | 2863400.0 |
| 2005-11-29 | CYB | ETF | 3.74 | 3.74 | 3.74 | 3.74 | 500.0 |
| 2005-11-29 | DGT | ETF | 65.6 | 65.75 | 65.42 | 65.42 | 4700.0 |
| 2005-11-29 | DIG | ETF | 15.15 | 15.15 | 15.1125 | 15.125 | 3680.0 |
| 2005-11-29 | DIV | ETF | 12.0 | 12.1 | 12.0 | 12.08 | 28600.0 |
> showing 50 of 289 rows — these rows as CSV