PREVIEW / etf_daily / 2006-06-30
file: by_date/etf_daily/2006/2006-06-30.parquet size: 18 KB rows: 361
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-06-30 | SPY | ETF | 127.54 | 127.66 | 126.96 | 127.28 | 54227800.0 |
| 2006-06-30 | QQQ | ETF | 39.12 | 39.14 | 38.68 | 38.77 | 82721238.0 |
| 2006-06-30 | IWM | ETF | 71.46 | 71.9 | 70.55 | 71.73 | 61004300.0 |
| 2006-06-30 | DIA | ETF | 112.22 | 112.28 | 111.59 | 111.79 | 3904500.0 |
| 2006-06-30 | GLD | ETF | 60.87 | 61.35 | 60.68 | 61.23 | 7773800.0 |
| 2006-06-30 | TLT | ETF | 83.5 | 84.4 | 83.5 | 84.32 | 1219000.0 |
| 2006-06-30 | AAA | ETF | 55.17 | 55.985 | 55.1 | 55.88 | 9600.0 |
| 2006-06-30 | ADRE | ETF | 125.87 | 125.87 | 123.87 | 124.69 | 134200.0 |
| 2006-06-30 | AFK | ETF | 24.76 | 24.93 | 24.76 | 24.93 | 10100.0 |
| 2006-06-30 | AGG | ETF | 97.55 | 97.62 | 97.4 | 97.44 | 187400.0 |
| 2006-06-30 | AIQ | ETF | 32.55 | 33.15 | 31.75 | 32.0 | 29580.0 |
| 2006-06-30 | AIS | ETF | 1.18 | 1.18 | 1.11 | 1.15 | 71000.0 |
| 2006-06-30 | AOM | ETF | 5.9 | 5.9 | 5.5 | 5.75 | 102300.0 |
| 2006-06-30 | ARB | ETF | 37.99 | 38.36 | 37.7 | 38.33 | 325300.0 |
| 2006-06-30 | BAB | ETF | 63.1 | 63.77 | 63.1 | 63.51 | 26400.0 |
| 2006-06-30 | BBC | ETF | 13.38 | 13.85 | 13.15 | 13.51 | 337300.0 |
| 2006-06-30 | BBH | ETF | 57.4267 | 59.5267 | 57.4267 | 58.8267 | 1771800.0 |
| 2006-06-30 | BCM | ETF | 67.79 | 68.07 | 66.9 | 67.12 | 44400.0 |
| 2006-06-30 | BITS | ETF | 18.24 | 19.76 | 18.24 | 18.8 | 17271.0 |
| 2006-06-30 | BKF | ETF | 6.07 | 6.25 | 5.8 | 6.25 | 470100.0 |
| 2006-06-30 | BNE | ETF | 13.99 | 14.31 | 13.73 | 14.3 | 253700.0 |
| 2006-06-30 | BOSS | ETF | 33.5 | 33.5 | 33.41 | 33.41 | 200.0 |
| 2006-06-30 | BRF | ETF | 13.96 | 14.03 | 13.96 | 13.96 | 6500.0 |
| 2006-06-30 | BTF | ETF | 89.3 | 90.0 | 89.3 | 90.0 | 440.0 |
| 2006-06-30 | CBON | ETF | 30.41 | 31.89 | 30.41 | 31.08 | 250319.0 |
| 2006-06-30 | CDL | ETF | 8.91 | 8.92 | 8.8 | 8.9 | 601200.0 |
| 2006-06-30 | CEF | ETF | 8.8 | 8.94 | 8.53 | 8.6 | 694900.0 |
| 2006-06-30 | CEW | ETF | 25.7 | 25.7 | 25.7 | 25.7 | 100.0 |
| 2006-06-30 | CFO | ETF | 9.97 | 10.0 | 9.97 | 10.0 | 14200.0 |
| 2006-06-30 | CGO | ETF | 14.75 | 14.79 | 14.65 | 14.7 | 27900.0 |
| 2006-06-30 | CHB | ETF | 11.04 | 11.3 | 10.93 | 11.04 | 594600.0 |
| 2006-06-30 | CHI | ETF | 19.09 | 19.24 | 19.04 | 19.24 | 58700.0 |
| 2006-06-30 | CHIC | ETF | 23.4 | 24.08 | 22.78 | 23.94 | 1421370.0 |
| 2006-06-30 | CHY | ETF | 16.02 | 16.02 | 15.96 | 15.99 | 145100.0 |
| 2006-06-30 | CIL | ETF | 25.0601 | 25.14 | 25.0601 | 25.14 | 2100.0 |
| 2006-06-30 | CIZ | ETF | 22.4 | 22.75 | 22.4 | 22.75 | 2500.0 |
| 2006-06-30 | CN | ETF | 35.15 | 35.6 | 34.89 | 35.16 | 68800.0 |
| 2006-06-30 | CNXT | ETF | 2.375 | 2.5 | 2.35 | 2.5 | 24899068.0 |
| 2006-06-30 | COMB | ETF | 9.96 | 10.0 | 9.94 | 10.0 | 8941.0 |
| 2006-06-30 | CPST | ETF | 2.35 | 2.48 | 2.26 | 2.28 | 12121632.0 |
| 2006-06-30 | CSA | ETF | 19.8 | 19.8 | 19.51 | 19.51 | 3000.0 |
| 2006-06-30 | CSB | ETF | 27.81 | 27.98 | 27.67 | 27.93 | 9600.0 |
| 2006-06-30 | CSQ | ETF | 13.95 | 14.0 | 13.87 | 13.97 | 212800.0 |
| 2006-06-30 | CTEC | ETF | 62.85 | 63.89999999999999 | 62.099999999999994 | 63.49999999999999 | 19661.0 |
| 2006-06-30 | CYB | ETF | 6.81 | 7.11 | 6.48 | 6.49 | 160300.0 |
| 2006-06-30 | DBC | ETF | 25.28 | 25.45 | 25.28 | 25.3 | 405600.0 |
| 2006-06-30 | DDM | ETF | 6.1208 | 6.1208 | 6.0625 | 6.0833 | 465600.0 |
| 2006-06-30 | DES | ETF | 17.1967 | 17.32 | 17.1967 | 17.2733 | 10500.0 |
| 2006-06-30 | DEW | ETF | 52.15 | 52.23 | 52.15 | 52.23 | 200.0 |
| 2006-06-30 | DFE | ETF | 53.07 | 53.07 | 53.07 | 53.07 | 300.0 |
> showing 50 of 361 rows — these rows as CSV