PREVIEW / etf_daily / 2005-09-26
file: by_date/etf_daily/2005/2005-09-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-09-26 | SPY | ETF | 122.02 | 122.24 | 121.08 | 121.58 | 70415400.0 |
| 2005-09-26 | QQQ | ETF | 38.97 | 39.03 | 38.55 | 38.76 | 69345114.0 |
| 2005-09-26 | IWM | ETF | 65.62 | 65.85 | 65.19 | 65.62 | 22874700.0 |
| 2005-09-26 | DIA | ETF | 104.65 | 105.03 | 104.02 | 104.44 | 6407000.0 |
| 2005-09-26 | GLD | ETF | 45.84 | 46.61 | 45.84 | 46.57 | 1361200.0 |
| 2005-09-26 | TLT | ETF | 92.11 | 92.38 | 92.1 | 92.19 | 680900.0 |
| 2005-09-26 | AAA | ETF | 55.26 | 55.65 | 55.26 | 55.444 | 1600.0 |
| 2005-09-26 | ADRE | ETF | 107.99 | 107.99 | 105.49 | 106.85 | 18372.0 |
| 2005-09-26 | AFK | ETF | 25.45 | 25.51 | 25.44 | 25.44 | 6400.0 |
| 2005-09-26 | AGG | ETF | 101.65 | 101.76 | 101.54 | 101.62 | 126100.0 |
| 2005-09-26 | AIQ | ETF | 43.15 | 43.3 | 41.8 | 42.8 | 31560.0 |
| 2005-09-26 | AIS | ETF | 0.93 | 1.0 | 0.86 | 0.98 | 365200.0 |
| 2005-09-26 | ARB | ETF | 39.83 | 39.94 | 39.52 | 39.82 | 64000.0 |
| 2005-09-26 | BAB | ETF | 51.15 | 51.37 | 50.7 | 51.18 | 22000.0 |
| 2005-09-26 | BBC | ETF | 7.52 | 7.67 | 7.5 | 7.5 | 35500.0 |
| 2005-09-26 | BBH | ETF | 64.0 | 64.6633 | 62.6 | 63.0867 | 4233000.0 |
| 2005-09-26 | BCM | ETF | 62.6 | 62.97 | 62.26 | 62.37 | 52300.0 |
| 2005-09-26 | BIS | ETF | 651.2 | 651.2 | 625.6 | 625.6 | 54.5 |
| 2005-09-26 | BITS | ETF | 11.28 | 11.36 | 11.0 | 11.12 | 8555.0 |
| 2005-09-26 | BKF | ETF | 31.6 | 32.0 | 31.6 | 31.94 | 16900.0 |
| 2005-09-26 | BNE | ETF | 14.13 | 14.13 | 14.0 | 14.03 | 94700.0 |
| 2005-09-26 | BRF | ETF | 15.23 | 15.36 | 15.23 | 15.36 | 9600.0 |
| 2005-09-26 | BTF | ETF | 85.99999999999999 | 86.3 | 85.7 | 86.05 | 4860.0 |
| 2005-09-26 | CBON | ETF | 32.58 | 32.83 | 32.4 | 32.62 | 40748.0 |
| 2005-09-26 | CDC | ETF | 3.99 | 3.99 | 3.55 | 3.9 | 28500.0 |
| 2005-09-26 | CDL | ETF | 13.5 | 13.89 | 13.5 | 13.61 | 427400.0 |
| 2005-09-26 | CEF | ETF | 5.5 | 5.65 | 5.49 | 5.62 | 437900.0 |
| 2005-09-26 | CEW | ETF | 26.09 | 26.09 | 26.0 | 26.0 | 1000.0 |
| 2005-09-26 | CHB | ETF | 14.57 | 14.84 | 14.03 | 14.35 | 779600.0 |
| 2005-09-26 | CHI | ETF | 20.25 | 20.29 | 20.03 | 20.03 | 105000.0 |
| 2005-09-26 | CHIC | ETF | 14.0 | 14.34 | 13.98 | 14.19 | 207801.0 |
| 2005-09-26 | CHIR | ETF | 43.6599 | 43.6599 | 43.2999 | 43.5999 | 1926284.0 |
| 2005-09-26 | CHY | ETF | 16.28 | 16.43 | 16.26 | 16.3 | 116500.0 |
| 2005-09-26 | CIZ | ETF | 21.7 | 21.7 | 21.6 | 21.6 | 400.0 |
| 2005-09-26 | CN | ETF | 33.8 | 34.08 | 33.8 | 33.93 | 32900.0 |
| 2005-09-26 | CNXT | ETF | 1.85 | 1.9 | 1.83 | 1.84 | 10581177.0 |
| 2005-09-26 | CPST | ETF | 4.2 | 4.26 | 4.0 | 4.09 | 4071670.0 |
| 2005-09-26 | CSB | ETF | 29.23 | 29.42 | 29.19 | 29.36 | 23900.0 |
| 2005-09-26 | CSQ | ETF | 13.8 | 13.96 | 13.63 | 13.68 | 378800.0 |
| 2005-09-26 | CTEC | ETF | 52.85 | 52.85 | 49.4 | 50.49999999999999 | 8300.2 |
| 2005-09-26 | CURE | ETF | 0.21 | 0.21 | 0.1875 | 0.1963 | 2078728.0 |
| 2005-09-26 | CYA | ETF | 72.0 | 78.0 | 72.0 | 78.0 | 1015.0 |
| 2005-09-26 | CYB | ETF | 4.15 | 4.15 | 4.0 | 4.0 | 3400.0 |
| 2005-09-26 | DGT | ETF | 64.55 | 64.75 | 64.43 | 64.46 | 14400.0 |
| 2005-09-26 | DIG | ETF | 14.425 | 14.55 | 14.425 | 14.55 | 6960.0 |
| 2005-09-26 | DIV | ETF | 13.1 | 13.32 | 13.07 | 13.28 | 18400.0 |
| 2005-09-26 | DRIV | ETF | 35.38 | 35.9 | 33.52 | 34.09 | 1295088.0 |
| 2005-09-26 | DSI | ETF | 5.65 | 5.65 | 5.645 | 5.645 | 2000.0 |
| 2005-09-26 | DUSA | ETF | 9.53 | 9.8 | 9.47 | 9.8 | 70974.0 |
| 2005-09-26 | DVY | ETF | 62.3 | 62.3 | 61.7 | 61.87 | 585400.0 |
> showing 50 of 275 rows — these rows as CSV