PREVIEW / etf_daily / 2006-04-26
file: by_date/etf_daily/2006/2006-04-26.parquet size: 16 KB rows: 307
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-04-26 | SPY | ETF | 130.5 | 131.14 | 130.3 | 130.4 | 67262400.0 |
| 2006-04-26 | QQQ | ETF | 41.87 | 42.06 | 41.7 | 41.86 | 82566672.0 |
| 2006-04-26 | IWM | ETF | 76.06 | 76.75 | 75.78 | 76.06 | 31348600.0 |
| 2006-04-26 | DIA | ETF | 112.97 | 113.69 | 112.91 | 113.39 | 6018800.0 |
| 2006-04-26 | GLD | ETF | 63.04 | 63.79 | 63.04 | 63.65 | 5795200.0 |
| 2006-04-26 | TLT | ETF | 83.85 | 84.08 | 83.73 | 83.99 | 1544900.0 |
| 2006-04-26 | AAA | ETF | 63.17 | 63.19 | 62.75 | 62.93 | 5200.0 |
| 2006-04-26 | ADRE | ETF | 137.29 | 139.5 | 135.5 | 138.9 | 49232.0 |
| 2006-04-26 | AFK | ETF | 25.05 | 25.08 | 25.05 | 25.08 | 13200.0 |
| 2006-04-26 | AGG | ETF | 98.12 | 98.2 | 97.95 | 98.1 | 128300.0 |
| 2006-04-26 | AIQ | ETF | 26.2 | 27.1 | 24.726 | 25.45 | 37380.0 |
| 2006-04-26 | AIS | ETF | 1.63 | 1.65 | 1.56 | 1.58 | 228500.0 |
| 2006-04-26 | AOM | ETF | 7.04 | 7.05 | 7.0048 | 7.01 | 7300.0 |
| 2006-04-26 | ARB | ETF | 34.44 | 34.92 | 34.44 | 34.85 | 287000.0 |
| 2006-04-26 | BAB | ETF | 61.96 | 62.0 | 61.02 | 61.48 | 59300.0 |
| 2006-04-26 | BBC | ETF | 14.85 | 15.2 | 14.85 | 15.11 | 342000.0 |
| 2006-04-26 | BBH | ETF | 58.07 | 58.07 | 56.6433 | 57.0733 | 1222800.0 |
| 2006-04-26 | BCM | ETF | 74.5 | 74.5 | 73.75 | 74.21 | 25500.0 |
| 2006-04-26 | BITS | ETF | 37.92 | 37.92 | 36.56 | 36.64 | 25850.0 |
| 2006-04-26 | BKF | ETF | 8.85 | 9.24 | 8.85 | 8.97 | 94400.0 |
| 2006-04-26 | BNE | ETF | 16.12 | 16.58 | 15.91 | 16.06 | 76800.0 |
| 2006-04-26 | BRF | ETF | 13.89 | 13.89 | 13.83 | 13.88 | 4900.0 |
| 2006-04-26 | BTF | ETF | 87.39999999999999 | 87.39999999999999 | 87.3 | 87.39999999999999 | 1900.0 |
| 2006-04-26 | CBON | ETF | 33.38 | 33.95 | 32.83 | 33.51 | 3696.0 |
| 2006-04-26 | CDL | ETF | 9.47 | 9.47 | 9.33 | 9.37 | 629800.0 |
| 2006-04-26 | CEF | ETF | 9.49 | 9.7 | 9.41 | 9.46 | 722700.0 |
| 2006-04-26 | CEW | ETF | 26.0 | 26.0 | 26.0 | 26.0 | 200.0 |
| 2006-04-26 | CFO | ETF | 10.3 | 10.32 | 10.25 | 10.32 | 23000.0 |
| 2006-04-26 | CGO | ETF | 14.32 | 14.36 | 14.25 | 14.25 | 20400.0 |
| 2006-04-26 | CHB | ETF | 14.99 | 15.4 | 14.94 | 15.16 | 619100.0 |
| 2006-04-26 | CHI | ETF | 19.99 | 20.14 | 19.98 | 20.0601 | 73700.0 |
| 2006-04-26 | CHIC | ETF | 20.55 | 20.93 | 20.47 | 20.85 | 470605.0 |
| 2006-04-26 | CHY | ETF | 15.91 | 15.92 | 15.84 | 15.91 | 77300.0 |
| 2006-04-26 | CIL | ETF | 25.73 | 25.73 | 25.73 | 25.73 | 300.0 |
| 2006-04-26 | CN | ETF | 35.98 | 36.68 | 35.89 | 36.12 | 58200.0 |
| 2006-04-26 | CNXT | ETF | 3.711 | 3.7801 | 3.69 | 3.74 | 15230826.0 |
| 2006-04-26 | COMB | ETF | 10.0 | 10.0 | 9.93 | 9.93 | 1205.0 |
| 2006-04-26 | CPI | ETF | 31.0 | 31.0 | 31.0 | 31.0 | 100.0 |
| 2006-04-26 | CPST | ETF | 4.03 | 4.2 | 4.03 | 4.2 | 2447701.0 |
| 2006-04-26 | CSA | ETF | 19.6 | 19.67 | 19.45 | 19.5 | 13400.0 |
| 2006-04-26 | CSB | ETF | 31.16 | 31.19 | 31.0 | 31.01 | 6200.0 |
| 2006-04-26 | CSQ | ETF | 14.05 | 14.05 | 13.87 | 13.97 | 472000.0 |
| 2006-04-26 | CTEC | ETF | 62.05 | 63.949999999999996 | 62.05 | 63.89999999999999 | 12118.400000000001 |
| 2006-04-26 | CYB | ETF | 6.48 | 6.48 | 6.34 | 6.39 | 43400.0 |
| 2006-04-26 | DBC | ETF | 25.73 | 25.9 | 25.55 | 25.6 | 493900.0 |
| 2006-04-26 | DGT | ETF | 68.4 | 68.65 | 68.17 | 68.17 | 1400.0 |
| 2006-04-26 | DIV | ETF | 12.08 | 12.08 | 11.97 | 11.98 | 6900.0 |
| 2006-04-26 | DRIV | ETF | 47.22 | 48.0 | 46.8 | 47.38 | 953920.0 |
| 2006-04-26 | DSI | ETF | 6.35 | 6.4 | 6.35 | 6.4 | 10200.0 |
| 2006-04-26 | DUSA | ETF | 6.64 | 6.89 | 6.6 | 6.87 | 106848.0 |
> showing 50 of 307 rows — these rows as CSV