PREVIEW / etf_daily / 2005-12-08
file: by_date/etf_daily/2005/2005-12-08.parquet size: 16 KB rows: 294
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-12-08 | SPY | ETF | 126.22 | 126.82 | 125.48 | 126.0 | 62608600.0 |
| 2005-12-08 | QQQ | ETF | 41.96 | 42.0 | 41.27 | 41.561 | 112043175.0 |
| 2005-12-08 | IWM | ETF | 68.25 | 68.81 | 67.7 | 68.3 | 33286000.0 |
| 2005-12-08 | DIA | ETF | 108.17 | 108.53 | 107.37 | 107.64 | 7453200.0 |
| 2005-12-08 | GLD | ETF | 51.34 | 51.95 | 51.26 | 51.9 | 3046000.0 |
| 2005-12-08 | TLT | ETF | 89.98 | 90.36 | 89.8 | 90.25 | 976200.0 |
| 2005-12-08 | AAA | ETF | 54.24 | 54.85 | 54.24 | 54.32 | 13800.0 |
| 2005-12-08 | ADRE | ETF | 114.41 | 114.93 | 114.016 | 114.1 | 11040.0 |
| 2005-12-08 | AFK | ETF | 25.79 | 25.8 | 25.6 | 25.6 | 4100.0 |
| 2005-12-08 | AGG | ETF | 100.0 | 100.31 | 99.9 | 100.3 | 137100.0 |
| 2005-12-08 | AIQ | ETF | 27.85 | 28.75 | 27.8 | 28.45 | 10800.0 |
| 2005-12-08 | AIS | ETF | 1.49 | 1.49 | 1.4 | 1.41 | 287700.0 |
| 2005-12-08 | AOM | ETF | 3.5 | 3.5 | 3.45 | 3.45 | 11100.0 |
| 2005-12-08 | ARB | ETF | 39.6 | 40.08 | 39.43 | 39.72 | 120800.0 |
| 2005-12-08 | BAB | ETF | 59.03 | 59.24 | 58.59 | 58.69 | 138000.0 |
| 2005-12-08 | BBC | ETF | 12.1 | 13.1 | 12.07 | 13.0 | 481700.0 |
| 2005-12-08 | BBH | ETF | 68.2 | 68.96 | 67.5333 | 68.83 | 1111800.0 |
| 2005-12-08 | BCM | ETF | 65.55 | 65.7 | 65.3 | 65.59 | 30200.0 |
| 2005-12-08 | BITS | ETF | 13.44 | 13.8 | 13.24 | 13.52 | 2850.0 |
| 2005-12-08 | BKF | ETF | 20.17 | 20.95 | 20.13 | 20.2 | 60500.0 |
| 2005-12-08 | BNE | ETF | 15.06 | 15.15 | 14.73 | 15.1 | 107800.0 |
| 2005-12-08 | BRF | ETF | 15.08 | 15.15 | 15.08 | 15.13 | 10400.0 |
| 2005-12-08 | BTF | ETF | 86.89999999999999 | 87.10000000000001 | 86.85 | 87.05 | 740.0 |
| 2005-12-08 | CBON | ETF | 31.17 | 31.46 | 30.07 | 31.26 | 25772.0 |
| 2005-12-08 | CDL | ETF | 13.49 | 13.5 | 13.08 | 13.25 | 341300.0 |
| 2005-12-08 | CEF | ETF | 6.44 | 6.53 | 6.43 | 6.51 | 384000.0 |
| 2005-12-08 | CEW | ETF | 26.0 | 26.26 | 26.0 | 26.07 | 1400.0 |
| 2005-12-08 | CGO | ETF | 13.48 | 13.72 | 13.26 | 13.3 | 51800.0 |
| 2005-12-08 | CHB | ETF | 14.41 | 14.72 | 14.15 | 14.55 | 615400.0 |
| 2005-12-08 | CHI | ETF | 20.2 | 20.32 | 20.15 | 20.25 | 114200.0 |
| 2005-12-08 | CHIC | ETF | 19.66 | 19.85 | 19.17 | 19.39 | 260548.0 |
| 2005-12-08 | CHIR | ETF | 44.4999 | 44.5899 | 44.4501 | 44.5101 | 992821.0 |
| 2005-12-08 | CHY | ETF | 15.66 | 15.74 | 15.55 | 15.74 | 149400.0 |
| 2005-12-08 | CIL | ETF | 25.08 | 25.25 | 25.08 | 25.13 | 800.0 |
| 2005-12-08 | CN | ETF | 31.25 | 31.42 | 31.2 | 31.35 | 25400.0 |
| 2005-12-08 | CNXT | ETF | 2.64 | 2.6601 | 2.55 | 2.59 | 10704398.0 |
| 2005-12-08 | CPI | ETF | 27.6 | 27.7 | 27.6 | 27.7 | 400.0 |
| 2005-12-08 | CPST | ETF | 3.7 | 3.7201 | 3.57 | 3.62 | 2708063.0 |
| 2005-12-08 | CSA | ETF | 16.6 | 16.9 | 16.6 | 16.85 | 34900.0 |
| 2005-12-08 | CSB | ETF | 29.99 | 30.58 | 29.99 | 30.22 | 53200.0 |
| 2005-12-08 | CSM | ETF | 2.4425 | 2.4425 | 2.4425 | 2.4425 | 400.0 |
| 2005-12-08 | CSQ | ETF | 13.01 | 13.07 | 13.0 | 13.07 | 448600.0 |
| 2005-12-08 | CTEC | ETF | 50.8 | 52.8 | 50.35 | 52.75 | 5780.200000000001 |
| 2005-12-08 | CURE | ETF | 0.0288 | 0.03 | 0.0225 | 0.0238 | 7998904.0 |
| 2005-12-08 | CYB | ETF | 3.68 | 3.68 | 3.6655 | 3.6655 | 1900.0 |
| 2005-12-08 | DGT | ETF | 65.59 | 65.85 | 65.51 | 65.6 | 36900.0 |
| 2005-12-08 | DIG | ETF | 15.6 | 15.6625 | 15.6 | 15.6625 | 5120.0 |
| 2005-12-08 | DIV | ETF | 11.93 | 11.97 | 11.91 | 11.97 | 24300.0 |
| 2005-12-08 | DRIV | ETF | 29.74 | 29.8 | 28.84 | 29.17 | 1017705.0 |
| 2005-12-08 | DSI | ETF | 5.965 | 5.965 | 5.965 | 5.965 | 2000.0 |
> showing 50 of 294 rows — these rows as CSV