PREVIEW / etf_daily / 2005-12-30
file: by_date/etf_daily/2005/2005-12-30.parquet size: 16 KB rows: 297
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-30 | SPY | ETF | 124.8 | 125.06 | 124.36 | 124.51 | 44645600.0 |
| 2005-12-30 | QQQ | ETF | 40.55 | 40.58 | 40.36 | 40.412 | 60052840.0 |
| 2005-12-30 | IWM | ETF | 66.76 | 66.99 | 66.46 | 66.72 | 33860500.0 |
| 2005-12-30 | DIA | ETF | 107.4 | 107.58 | 106.82 | 106.95 | 5063100.0 |
| 2005-12-30 | GLD | ETF | 51.19 | 51.72 | 51.17 | 51.58 | 2635900.0 |
| 2005-12-30 | TLT | ETF | 92.54 | 92.59 | 91.7 | 91.9 | 1099500.0 |
| 2005-12-30 | AAA | ETF | 54.26 | 54.47 | 54.08 | 54.47 | 2500.0 |
| 2005-12-30 | ADRE | ETF | 115.99 | 115.99 | 114.6 | 115.33 | 22200.0 |
| 2005-12-30 | AFK | ETF | 25.28 | 25.28 | 25.2 | 25.2001 | 4100.0 |
| 2005-12-30 | AGG | ETF | 100.56 | 100.76 | 100.28 | 100.59 | 141000.0 |
| 2005-12-30 | AIQ | ETF | 28.6 | 30.25 | 28.5 | 29.75 | 20140.0 |
| 2005-12-30 | AIS | ETF | 1.48 | 1.61 | 1.47 | 1.55 | 689100.0 |
| 2005-12-30 | AOM | ETF | 4.1 | 4.15 | 4.1 | 4.15 | 5000.0 |
| 2005-12-30 | ARB | ETF | 38.31 | 38.31 | 37.61 | 37.98 | 177100.0 |
| 2005-12-30 | BAB | ETF | 57.88 | 57.88 | 57.22 | 57.5 | 6900.0 |
| 2005-12-30 | BBC | ETF | 13.25 | 14.35 | 13.25 | 14.0 | 212300.0 |
| 2005-12-30 | BBH | ETF | 66.8033 | 67.0467 | 66.25 | 66.9233 | 1251300.0 |
| 2005-12-30 | BCM | ETF | 65.8 | 66.01 | 65.42 | 65.8 | 15900.0 |
| 2005-12-30 | BITS | ETF | 15.044 | 15.4 | 15.04 | 15.04 | 3928.0 |
| 2005-12-30 | BKF | ETF | 19.8 | 19.8 | 18.27 | 18.95 | 102700.0 |
| 2005-12-30 | BNE | ETF | 14.85 | 15.06 | 14.7 | 14.84 | 123100.0 |
| 2005-12-30 | BRF | ETF | 15.21 | 15.21 | 15.11 | 15.11 | 2800.0 |
| 2005-12-30 | BTF | ETF | 84.49999999999999 | 85.25 | 83.85 | 84.9995 | 2820.0 |
| 2005-12-30 | CBON | ETF | 31.8 | 31.8 | 31.45 | 31.61 | 15149.0 |
| 2005-12-30 | CDL | ETF | 13.55 | 13.57 | 13.44 | 13.44 | 244500.0 |
| 2005-12-30 | CEF | ETF | 6.73 | 6.82 | 6.68 | 6.81 | 596600.0 |
| 2005-12-30 | CFO | ETF | 9.9 | 9.95 | 9.9 | 9.95 | 2100.0 |
| 2005-12-30 | CGO | ETF | 13.66 | 14.17 | 13.6 | 14.17 | 129100.0 |
| 2005-12-30 | CHB | ETF | 13.75 | 13.78 | 13.24 | 13.62 | 390300.0 |
| 2005-12-30 | CHI | ETF | 19.97 | 20.0 | 19.79 | 19.81 | 59900.0 |
| 2005-12-30 | CHIC | ETF | 20.48 | 20.83 | 20.27 | 20.83 | 207717.0 |
| 2005-12-30 | CHIR | ETF | 44.3901 | 44.4999 | 44.3901 | 44.4399 | 623687.0 |
| 2005-12-30 | CHY | ETF | 15.74 | 15.77 | 15.6 | 15.7 | 96700.0 |
| 2005-12-30 | CIL | ETF | 25.3 | 25.3 | 25.3 | 25.3 | 200.0 |
| 2005-12-30 | CIZ | ETF | 21.9 | 22.55 | 21.9 | 22.55 | 2500.0 |
| 2005-12-30 | CN | ETF | 32.44 | 32.44 | 32.11 | 32.44 | 28000.0 |
| 2005-12-30 | CNXT | ETF | 2.21 | 2.33 | 2.13 | 2.26 | 13860438.0 |
| 2005-12-30 | CPI | ETF | 27.95 | 27.95 | 27.95 | 27.95 | 1400.0 |
| 2005-12-30 | CPST | ETF | 3.08 | 3.13 | 2.95 | 2.99 | 3793001.0 |
| 2005-12-30 | CSA | ETF | 16.92 | 17.02 | 16.85 | 16.89 | 12200.0 |
| 2005-12-30 | CSB | ETF | 32.15 | 32.36 | 32.1 | 32.3 | 9200.0 |
| 2005-12-30 | CSQ | ETF | 13.36 | 13.51 | 13.22 | 13.51 | 613100.0 |
| 2005-12-30 | CTEC | ETF | 47.35 | 49.949999999999996 | 47.199999999999996 | 49.599999999999994 | 10221.400000000001 |
| 2005-12-30 | CURE | ETF | 0.0312 | 0.0325 | 0.0288 | 0.0288 | 3757448.0 |
| 2005-12-30 | CYB | ETF | 3.54 | 3.77 | 3.54 | 3.7 | 7500.0 |
| 2005-12-30 | DGT | ETF | 64.97 | 65.01 | 64.89 | 65.01 | 6500.0 |
| 2005-12-30 | DIG | ETF | 16.3625 | 16.475 | 16.25 | 16.475 | 9760.0 |
| 2005-12-30 | DIV | ETF | 12.06 | 12.17 | 12.05 | 12.11 | 187900.0 |
| 2005-12-30 | DRIV | ETF | 29.55 | 29.89 | 29.22 | 29.74 | 387488.0 |
| 2005-12-30 | DSI | ETF | 5.985 | 5.985 | 5.985 | 5.985 | 2000.0 |
> showing 50 of 297 rows — these rows as CSV