PREVIEW / etf_daily / 2006-07-17
file: by_date/etf_daily/2006/2006-07-17.parquet size: 18 KB rows: 355
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-07-17 | SPY | ETF | 123.52 | 124.1 | 123.15 | 123.34 | 81159000.0 |
| 2006-07-17 | QQQ | ETF | 35.95 | 36.25 | 35.87 | 36.03 | 134358093.0 |
| 2006-07-17 | IWM | ETF | 67.6 | 68.2 | 67.03 | 67.44 | 67427500.0 |
| 2006-07-17 | DIA | ETF | 107.38 | 108.07 | 107.17 | 107.52 | 8335300.0 |
| 2006-07-17 | GLD | ETF | 64.79 | 65.22 | 63.67 | 63.95 | 9905000.0 |
| 2006-07-17 | TLT | ETF | 84.97 | 85.19 | 84.85 | 85.17 | 514100.0 |
| 2006-07-17 | AAA | ETF | 54.2 | 54.58 | 54.15 | 54.26 | 5300.0 |
| 2006-07-17 | ADRE | ETF | 29.5 | 29.925 | 29.38 | 29.41 | 264252.0 |
| 2006-07-17 | AFK | ETF | 25.08 | 25.08 | 24.98 | 25.01 | 4700.0 |
| 2006-07-17 | AGG | ETF | 97.79 | 97.83 | 97.65 | 97.67 | 187300.0 |
| 2006-07-17 | AIQ | ETF | 30.75 | 31.4 | 29.6 | 30.65 | 12280.0 |
| 2006-07-17 | AIS | ETF | 1.05 | 1.1 | 1.02 | 1.1 | 105000.0 |
| 2006-07-17 | AOM | ETF | 6.43 | 6.5 | 6.4 | 6.5 | 5200.0 |
| 2006-07-17 | ARB | ETF | 36.4 | 36.78 | 36.31 | 36.37 | 133500.0 |
| 2006-07-17 | BAB | ETF | 62.37 | 63.11 | 62.3 | 62.93 | 78400.0 |
| 2006-07-17 | BBC | ETF | 12.6 | 12.85 | 12.18 | 12.4 | 127200.0 |
| 2006-07-17 | BBH | ETF | 57.2 | 57.6167 | 56.5333 | 56.9233 | 2106300.0 |
| 2006-07-17 | BITS | ETF | 17.6804 | 18.56 | 17.24 | 17.52 | 12469.0 |
| 2006-07-17 | BKF | ETF | 5.76 | 5.77 | 5.4 | 5.57 | 51000.0 |
| 2006-07-17 | BNE | ETF | 13.26 | 13.45 | 13.05 | 13.29 | 111100.0 |
| 2006-07-17 | BOSS | ETF | 30.98 | 30.98 | 30.55 | 30.55 | 100.0 |
| 2006-07-17 | BRF | ETF | 13.94 | 13.94 | 13.75 | 13.93 | 25100.0 |
| 2006-07-17 | BTF | ETF | 86.99999999999999 | 87.75 | 86.99999999999999 | 87.2 | 640.0 |
| 2006-07-17 | CBON | ETF | 30.58 | 30.72 | 30.41 | 30.41 | 11442.0 |
| 2006-07-17 | CDL | ETF | 8.49 | 8.9 | 8.49 | 8.7 | 435500.0 |
| 2006-07-17 | CEF | ETF | 9.5 | 9.5 | 9.17 | 9.2 | 689600.0 |
| 2006-07-17 | CEW | ETF | 25.96 | 25.96 | 25.9 | 25.9 | 800.0 |
| 2006-07-17 | CFO | ETF | 10.0 | 10.02 | 10.0 | 10.0 | 12500.0 |
| 2006-07-17 | CGO | ETF | 14.58 | 14.68 | 14.5 | 14.65 | 25800.0 |
| 2006-07-17 | CHB | ETF | 8.6 | 8.87 | 8.48 | 8.5 | 797100.0 |
| 2006-07-17 | CHI | ETF | 19.22 | 19.3 | 19.12 | 19.22 | 82400.0 |
| 2006-07-17 | CHIC | ETF | 21.76 | 23.23 | 21.76 | 23.14 | 716919.0 |
| 2006-07-17 | CHY | ETF | 15.94 | 16.0 | 15.8 | 16.0 | 151600.0 |
| 2006-07-17 | CIZ | ETF | 22.35 | 22.45 | 22.35 | 22.45 | 200.0 |
| 2006-07-17 | CN | ETF | 34.46 | 34.46 | 33.5 | 34.17 | 109100.0 |
| 2006-07-17 | CNXT | ETF | 2.085 | 2.13 | 2.01 | 2.05 | 14507106.0 |
| 2006-07-17 | COMB | ETF | 9.76 | 9.76 | 9.65 | 9.75 | 1057.0 |
| 2006-07-17 | CPST | ETF | 2.02 | 2.07 | 1.97 | 2.01 | 810413.0 |
| 2006-07-17 | CSA | ETF | 18.6601 | 18.9 | 18.6601 | 18.85 | 3900.0 |
| 2006-07-17 | CSB | ETF | 26.8 | 26.96 | 26.76 | 26.77 | 11200.0 |
| 2006-07-17 | CSQ | ETF | 13.62 | 13.75 | 13.59 | 13.71 | 278800.0 |
| 2006-07-17 | CTEC | ETF | 62.449999999999996 | 62.449999999999996 | 57.15 | 57.99999999999999 | 53963.8 |
| 2006-07-17 | CYB | ETF | 5.82 | 5.95 | 5.82 | 5.9 | 24600.0 |
| 2006-07-17 | DBC | ETF | 26.32 | 26.49 | 25.81 | 25.9 | 191500.0 |
| 2006-07-17 | DDM | ETF | 5.6375 | 5.6508 | 5.5733 | 5.6017 | 2010000.0 |
| 2006-07-17 | DES | ETF | 16.72 | 16.77 | 16.6533 | 16.7567 | 449400.0 |
| 2006-07-17 | DEW | ETF | 49.95 | 49.99 | 49.85 | 49.99 | 4600.0 |
| 2006-07-17 | DFJ | ETF | 47.88 | 47.88 | 47.88 | 47.88 | 200.0 |
| 2006-07-17 | DGT | ETF | 65.65 | 65.65 | 65.34 | 65.61 | 4500.0 |
| 2006-07-17 | DHS | ETF | 50.29 | 50.44 | 50.14 | 50.43 | 2700.0 |
> showing 50 of 355 rows — these rows as CSV