PREVIEW / etf_daily / 2006-12-28
file: by_date/etf_daily/2006/2006-12-28.parquet size: 19 KB rows: 388
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-28 | SPY | ETF | 142.41 | 142.7 | 141.99 | 142.21 | 37288800.0 |
| 2006-12-28 | QQQ | ETF | 43.2 | 43.38 | 43.05 | 43.12 | 70759863.0 |
| 2006-12-28 | IWM | ETF | 79.03 | 79.28 | 78.65 | 78.78 | 28257400.0 |
| 2006-12-28 | DIA | ETF | 124.9 | 125.14 | 124.59 | 124.8 | 6691600.0 |
| 2006-12-28 | GLD | ETF | 62.97 | 63.05 | 62.69 | 62.9 | 2538900.0 |
| 2006-12-28 | TLT | ETF | 88.9 | 88.96 | 88.06 | 88.5 | 1080200.0 |
| 2006-12-28 | AAA | ETF | 61.83 | 62.09 | 61.5 | 61.86 | 2700.0 |
| 2006-12-28 | ADRE | ETF | 39.0 | 39.11 | 38.84 | 39.0 | 160093.0 |
| 2006-12-28 | AGG | ETF | 99.95 | 99.98 | 99.61 | 99.71 | 326900.0 |
| 2006-12-28 | AIQ | ETF | 33.8 | 34.1 | 33.25 | 34.05 | 19940.0 |
| 2006-12-28 | AIS | ETF | 1.23 | 1.23 | 1.18 | 1.21 | 420100.0 |
| 2006-12-28 | ARB | ETF | 44.42 | 44.7 | 44.08 | 44.48 | 72300.0 |
| 2006-12-28 | BAB | ETF | 104.39 | 104.89 | 103.67 | 104.83 | 50300.0 |
| 2006-12-28 | BBC | ETF | 4.5 | 5.23 | 4.477 | 5.09 | 1018700.0 |
| 2006-12-28 | BBH | ETF | 61.0033 | 61.49 | 60.8067 | 61.45 | 750300.0 |
| 2006-12-28 | BITS | ETF | 34.76 | 35.44 | 34.76 | 35.04 | 15242.0 |
| 2006-12-28 | BNE | ETF | 16.08 | 16.3 | 16.02 | 16.13 | 184400.0 |
| 2006-12-28 | BRF | ETF | 14.33 | 14.33 | 14.26 | 14.33 | 27500.0 |
| 2006-12-28 | BTF | ETF | 109.0 | 110.9995 | 109.0 | 110.89999999999999 | 1880.0 |
| 2006-12-28 | CBON | ETF | 30.36 | 30.5 | 30.25 | 30.48 | 31504.0 |
| 2006-12-28 | CDL | ETF | 9.9 | 10.01 | 9.85 | 9.94 | 345200.0 |
| 2006-12-28 | CEF | ETF | 9.39 | 9.4 | 9.3 | 9.33 | 408100.0 |
| 2006-12-28 | CEW | ETF | 26.0 | 26.0 | 25.95 | 25.95 | 300.0 |
| 2006-12-28 | CGO | ETF | 17.09 | 17.11 | 16.91 | 16.99 | 19600.0 |
| 2006-12-28 | CHB | ETF | 9.42 | 9.62 | 9.4 | 9.55 | 580500.0 |
| 2006-12-28 | CHI | ETF | 20.03 | 20.25 | 20.03 | 20.17 | 70700.0 |
| 2006-12-28 | CHIC | ETF | 30.71 | 31.14 | 30.7 | 30.77 | 210460.0 |
| 2006-12-28 | CHY | ETF | 17.1 | 17.2252 | 17.1 | 17.2 | 76400.0 |
| 2006-12-28 | CN | ETF | 59.4 | 59.4 | 56.0 | 56.0 | 455800.0 |
| 2006-12-28 | CNXT | ETF | 2.06 | 2.08 | 2.03 | 2.06 | 8638211.0 |
| 2006-12-28 | CPI | ETF | 23.59 | 24.0 | 23.584 | 24.0 | 1900.0 |
| 2006-12-28 | CPST | ETF | 1.25 | 1.27 | 1.23 | 1.25 | 1835638.0 |
| 2006-12-28 | CSA | ETF | 21.3 | 21.7 | 21.3 | 21.35 | 15700.0 |
| 2006-12-28 | CSB | ETF | 33.39 | 33.7 | 33.19 | 33.41 | 13300.0 |
| 2006-12-28 | CSD | ETF | 25.18 | 25.18 | 25.16 | 25.16 | 3000.0 |
| 2006-12-28 | CSQ | ETF | 15.6 | 15.63 | 15.55 | 15.58 | 230800.0 |
| 2006-12-28 | CTEC | ETF | 91.85 | 91.85 | 90.8 | 91.35 | 17917.8 |
| 2006-12-28 | CVY | ETF | 26.65 | 26.65 | 26.52 | 26.57 | 16300.0 |
| 2006-12-28 | DBC | ETF | 24.47 | 24.58 | 24.33 | 24.48 | 319600.0 |
| 2006-12-28 | DBV | ETF | 25.92 | 26.0 | 25.91 | 26.0 | 360600.0 |
| 2006-12-28 | DDM | ETF | 6.9542 | 6.9717 | 6.92 | 6.9492 | 477600.0 |
| 2006-12-28 | DEF | ETF | 25.22 | 25.22 | 25.1201 | 25.15 | 18800.0 |
| 2006-12-28 | DES | ETF | 19.3 | 19.37 | 19.0733 | 19.3133 | 69600.0 |
| 2006-12-28 | DEW | ETF | 61.97 | 62.06 | 61.82 | 61.86 | 10600.0 |
| 2006-12-28 | DFE | ETF | 65.5 | 65.66 | 65.36 | 65.46 | 8600.0 |
| 2006-12-28 | DFJ | ETF | 51.07 | 51.07 | 50.82 | 51.04 | 11500.0 |
| 2006-12-28 | DGT | ETF | 76.24 | 76.46 | 76.2 | 76.41 | 2600.0 |
| 2006-12-28 | DHS | ETF | 58.2 | 58.2 | 57.95 | 58.01 | 13800.0 |
| 2006-12-28 | DIM | ETF | 63.85 | 64.0 | 63.69 | 63.86 | 17000.0 |
| 2006-12-28 | DIV | ETF | 13.56 | 13.59 | 13.54 | 13.58 | 12800.0 |
> showing 50 of 388 rows — these rows as CSV