PREVIEW / etf_daily / 2005-08-26
file: by_date/etf_daily/2005/2005-08-26.parquet size: 15 KB rows: 275
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-08-26 | SPY | ETF | 121.48 | 121.49 | 120.68 | 120.76 | 61956800.0 |
| 2005-08-26 | QQQ | ETF | 38.53 | 38.6 | 38.27 | 38.4599 | 63884156.0 |
| 2005-08-26 | IWM | ETF | 65.56 | 65.57 | 64.44 | 64.5 | 19853300.0 |
| 2005-08-26 | DIA | ETF | 104.36 | 104.39 | 103.79 | 103.9 | 5546700.0 |
| 2005-08-26 | GLD | ETF | 43.78 | 43.9 | 43.51 | 43.61 | 1301700.0 |
| 2005-08-26 | TLT | ETF | 94.65 | 94.88 | 94.2 | 94.47 | 874600.0 |
| 2005-08-26 | AAA | ETF | 56.68 | 56.79 | 56.65 | 56.77 | 1200.0 |
| 2005-08-26 | ADRE | ETF | 99.7 | 100.0 | 97.08 | 97.2399 | 9668.0 |
| 2005-08-26 | AFK | ETF | 25.7 | 25.78 | 25.7 | 25.77 | 3400.0 |
| 2005-08-26 | AGG | ETF | 102.22 | 102.25 | 101.99 | 102.16 | 103900.0 |
| 2005-08-26 | AIQ | ETF | 46.2 | 46.2 | 45.0 | 45.05 | 24860.0 |
| 2005-08-26 | AIS | ETF | 0.9 | 0.92 | 0.87 | 0.91 | 136300.0 |
| 2005-08-26 | ARB | ETF | 41.94 | 41.96 | 41.26 | 41.69 | 100400.0 |
| 2005-08-26 | BAB | ETF | 51.0 | 51.0 | 50.52 | 50.61 | 6500.0 |
| 2005-08-26 | BBC | ETF | 6.5 | 6.65 | 6.3 | 6.35 | 26400.0 |
| 2005-08-26 | BBH | ETF | 63.1167 | 63.2667 | 62.59 | 63.18 | 1803600.0 |
| 2005-08-26 | BCM | ETF | 58.95 | 59.19 | 58.3 | 58.59 | 172200.0 |
| 2005-08-26 | BITS | ETF | 12.44 | 13.16 | 12.44 | 13.0 | 3338.0 |
| 2005-08-26 | BKF | ETF | 34.21 | 34.21 | 33.45 | 33.55 | 54200.0 |
| 2005-08-26 | BNE | ETF | 13.73 | 13.79 | 13.51 | 13.51 | 69700.0 |
| 2005-08-26 | BOSS | ETF | 26.75 | 26.75 | 26.75 | 26.75 | 100.0 |
| 2005-08-26 | BRF | ETF | 15.48 | 15.5 | 15.45 | 15.5 | 9500.0 |
| 2005-08-26 | BTF | ETF | 85.29999999999998 | 85.64999999999999 | 85.25 | 85.64999999999999 | 680.0 |
| 2005-08-26 | CBON | ETF | 32.6 | 33.01 | 32.6 | 33.0 | 7475.0 |
| 2005-08-26 | CDC | ETF | 3.73 | 3.73 | 3.73 | 3.73 | 100.0 |
| 2005-08-26 | CDL | ETF | 13.6 | 13.69 | 13.45 | 13.47 | 506900.0 |
| 2005-08-26 | CEF | ETF | 5.37 | 5.37 | 5.27 | 5.28 | 360700.0 |
| 2005-08-26 | CHB | ETF | 11.15 | 11.2 | 10.96 | 11.08 | 335900.0 |
| 2005-08-26 | CHI | ETF | 19.98 | 20.07 | 19.9 | 20.03 | 71600.0 |
| 2005-08-26 | CHIC | ETF | 14.32 | 14.35 | 14.08 | 14.22 | 294165.0 |
| 2005-08-26 | CHIR | ETF | 35.25 | 35.5401 | 34.8999 | 35.2899 | 625541.0 |
| 2005-08-26 | CHY | ETF | 16.47 | 16.47 | 16.35 | 16.42 | 88800.0 |
| 2005-08-26 | CN | ETF | 33.0 | 33.05 | 32.85 | 33.0 | 4700.0 |
| 2005-08-26 | CNXT | ETF | 1.75 | 1.76 | 1.69 | 1.7 | 2848909.0 |
| 2005-08-26 | CPI | ETF | 23.4 | 23.4 | 23.4 | 23.4 | 500.0 |
| 2005-08-26 | CPST | ETF | 3.69 | 4.23 | 3.65 | 4.19 | 7723772.0 |
| 2005-08-26 | CSB | ETF | 30.51 | 30.55 | 30.16 | 30.2 | 7000.0 |
| 2005-08-26 | CSQ | ETF | 14.07 | 14.14 | 13.96 | 14.03 | 328000.0 |
| 2005-08-26 | CTEC | ETF | 51.74999999999999 | 53.449999999999996 | 51.74999999999999 | 52.699999999999996 | 2859.0 |
| 2005-08-26 | CURE | ETF | 0.275 | 0.2875 | 0.265 | 0.2875 | 1661440.0 |
| 2005-08-26 | CYA | ETF | 69.0 | 72.0 | 69.0 | 71.4 | 1225.0 |
| 2005-08-26 | CYB | ETF | 3.75 | 3.88 | 3.75 | 3.84 | 7200.0 |
| 2005-08-26 | DGT | ETF | 63.8 | 63.8 | 63.49 | 63.67 | 1400.0 |
| 2005-08-26 | DIG | ETF | 12.7125 | 12.7125 | 12.7125 | 12.7125 | 400.0 |
| 2005-08-26 | DIV | ETF | 13.58 | 13.67 | 13.57 | 13.6 | 6200.0 |
| 2005-08-26 | DRIV | ETF | 36.7 | 37.07 | 35.7 | 36.97 | 1094840.0 |
| 2005-08-26 | DSI | ETF | 5.72 | 5.72 | 5.715 | 5.715 | 4600.0 |
| 2005-08-26 | DUSA | ETF | 10.8 | 10.91 | 10.61 | 10.66 | 71178.0 |
| 2005-08-26 | DVY | ETF | 62.51 | 62.59 | 62.08 | 62.15 | 386600.0 |
| 2005-08-26 | EDEN | ETF | 0.84 | 0.9 | 0.84 | 0.84 | 18843.0 |
> showing 50 of 275 rows — these rows as CSV