PREVIEW / etf_daily / 2006-05-17
file: by_date/etf_daily/2006/2006-05-17.parquet size: 17 KB rows: 323
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-05-17 | SPY | ETF | 128.67 | 129.1 | 126.77 | 126.85 | 144789500.0 |
| 2006-05-17 | QQQ | ETF | 39.68 | 39.81 | 39.23 | 39.32 | 207927819.0 |
| 2006-05-17 | IWM | ETF | 72.45 | 73.14 | 71.85 | 71.95 | 76491400.0 |
| 2006-05-17 | DIA | ETF | 113.7 | 113.84 | 111.92 | 111.99 | 17248200.0 |
| 2006-05-17 | GLD | ETF | 69.51 | 70.17 | 68.07 | 68.15 | 16414700.0 |
| 2006-05-17 | TLT | ETF | 82.91 | 83.08 | 82.72 | 83.08 | 1440800.0 |
| 2006-05-17 | AAA | ETF | 60.67 | 60.67 | 59.5101 | 59.6 | 11500.0 |
| 2006-05-17 | ADRE | ETF | 135.06 | 136.1 | 129.81 | 130.64 | 140576.0 |
| 2006-05-17 | AFK | ETF | 25.21 | 25.21 | 25.13 | 25.13 | 4400.0 |
| 2006-05-17 | AGG | ETF | 97.76 | 97.85 | 97.41 | 97.85 | 163200.0 |
| 2006-05-17 | AIQ | ETF | 32.0 | 33.4 | 31.75 | 33.0 | 19940.0 |
| 2006-05-17 | AIS | ETF | 1.39 | 1.45 | 1.34 | 1.45 | 205500.0 |
| 2006-05-17 | AOM | ETF | 7.35 | 7.35 | 7.15 | 7.24 | 8000.0 |
| 2006-05-17 | ARB | ETF | 37.5 | 37.97 | 37.33 | 37.82 | 842300.0 |
| 2006-05-17 | BAB | ETF | 63.67 | 63.88 | 61.0 | 61.49 | 145900.0 |
| 2006-05-17 | BBC | ETF | 11.98 | 11.98 | 10.8 | 11.56 | 361300.0 |
| 2006-05-17 | BBH | ETF | 58.3333 | 58.3733 | 57.2967 | 57.74 | 2076000.0 |
| 2006-05-17 | BCM | ETF | 74.98 | 75.56 | 74.05 | 74.24 | 56500.0 |
| 2006-05-17 | BITS | ETF | 27.84 | 28.0 | 26.8 | 26.88 | 15988.0 |
| 2006-05-17 | BKF | ETF | 7.89 | 7.95 | 7.8 | 7.9 | 77700.0 |
| 2006-05-17 | BNE | ETF | 14.0 | 14.32 | 13.65 | 14.05 | 216500.0 |
| 2006-05-17 | BRF | ETF | 13.92 | 14.05 | 13.92 | 14.04 | 26000.0 |
| 2006-05-17 | BTF | ETF | 88.9 | 89.14999999999999 | 88.9 | 89.14999999999999 | 1660.0 |
| 2006-05-17 | CBON | ETF | 32.0 | 32.3 | 31.23 | 31.782 | 16654.0 |
| 2006-05-17 | CDL | ETF | 10.64 | 10.69 | 10.48 | 10.55 | 247600.0 |
| 2006-05-17 | CEF | ETF | 9.7 | 9.77 | 9.27 | 9.3 | 919300.0 |
| 2006-05-17 | CEW | ETF | 25.85 | 25.99 | 25.85 | 25.93 | 2100.0 |
| 2006-05-17 | CGO | ETF | 14.73 | 14.73 | 14.57 | 14.64 | 42600.0 |
| 2006-05-17 | CHB | ETF | 14.14 | 14.16 | 13.3 | 13.78 | 934300.0 |
| 2006-05-17 | CHI | ETF | 19.88 | 19.88 | 19.7 | 19.73 | 122400.0 |
| 2006-05-17 | CHIC | ETF | 21.48 | 21.79 | 21.38 | 21.46 | 178844.0 |
| 2006-05-17 | CHY | ETF | 16.04 | 16.04 | 15.91 | 15.94 | 130100.0 |
| 2006-05-17 | CIL | ETF | 25.87 | 25.91 | 25.87 | 25.91 | 2700.0 |
| 2006-05-17 | CN | ETF | 35.9 | 35.9 | 34.61 | 35.0 | 99100.0 |
| 2006-05-17 | CNXT | ETF | 3.275 | 3.3 | 3.2 | 3.21 | 13439060.0 |
| 2006-05-17 | COMB | ETF | 9.99 | 9.99 | 9.75 | 9.75 | 2500.0 |
| 2006-05-17 | CPI | ETF | 31.4 | 31.5 | 31.4 | 31.5 | 200.0 |
| 2006-05-17 | CPST | ETF | 3.13 | 3.23 | 3.1 | 3.2 | 1630762.0 |
| 2006-05-17 | CSA | ETF | 19.35 | 19.38 | 19.3 | 19.32 | 5000.0 |
| 2006-05-17 | CSB | ETF | 30.24 | 30.24 | 29.34 | 29.51 | 10500.0 |
| 2006-05-17 | CSQ | ETF | 13.8 | 13.856 | 13.76 | 13.85 | 485000.0 |
| 2006-05-17 | CTEC | ETF | 62.199999999999996 | 64.35 | 62.199999999999996 | 62.75 | 11064.6 |
| 2006-05-17 | CYB | ETF | 5.48 | 5.93 | 5.35 | 5.79 | 979800.0 |
| 2006-05-17 | DBC | ETF | 26.25 | 26.25 | 25.63 | 25.98 | 784900.0 |
| 2006-05-17 | DGT | ETF | 68.51 | 68.51 | 67.05 | 67.28 | 1700.0 |
| 2006-05-17 | DIG | ETF | 17.825 | 17.825 | 17.825 | 17.825 | 8000.0 |
| 2006-05-17 | DIV | ETF | 11.78 | 11.8 | 11.74 | 11.79 | 10300.0 |
| 2006-05-17 | DRIV | ETF | 45.985 | 46.87 | 45.73 | 46.53 | 818527.0 |
| 2006-05-17 | DSI | ETF | 6.405 | 6.405 | 6.405 | 6.405 | 200.0 |
| 2006-05-17 | DUSA | ETF | 6.78 | 6.79 | 6.47 | 6.48 | 175161.0 |
> showing 50 of 323 rows — these rows as CSV