PREVIEW / etf_daily / 2006-07-10
file: by_date/etf_daily/2006/2006-07-10.parquet size: 18 KB rows: 351
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-10 | SPY | ETF | 126.94 | 127.43 | 126.41 | 126.85 | 60964100.0 |
| 2006-07-10 | QQQ | ETF | 37.79 | 37.93 | 37.17 | 37.36 | 105125940.0 |
| 2006-07-10 | IWM | ETF | 70.66 | 71.24 | 70.18 | 70.5 | 40166800.0 |
| 2006-07-10 | DIA | ETF | 111.34 | 111.78 | 110.9 | 111.15 | 4375500.0 |
| 2006-07-10 | GLD | ETF | 62.13 | 62.5 | 61.99 | 62.02 | 3512000.0 |
| 2006-07-10 | TLT | ETF | 84.18 | 84.4 | 84.05 | 84.37 | 480400.0 |
| 2006-07-10 | AAA | ETF | 56.42 | 56.42 | 56.09 | 56.09 | 1000.0 |
| 2006-07-10 | ADRE | ETF | 30.89 | 33.2 | 30.89 | 31.1745 | 229090.0 |
| 2006-07-10 | AFK | ETF | 24.83 | 24.91 | 24.83 | 24.91 | 22300.0 |
| 2006-07-10 | AGG | ETF | 97.48 | 97.54 | 97.36 | 97.45 | 92600.0 |
| 2006-07-10 | AIQ | ETF | 33.45 | 33.75 | 30.85 | 31.1 | 31740.0 |
| 2006-07-10 | AIS | ETF | 1.15 | 1.17 | 1.1 | 1.11 | 110400.0 |
| 2006-07-10 | AOM | ETF | 5.79 | 5.8 | 5.69 | 5.8 | 20500.0 |
| 2006-07-10 | ARB | ETF | 37.96 | 38.4 | 37.83 | 38.09 | 119500.0 |
| 2006-07-10 | BAB | ETF | 67.57 | 67.75 | 66.3 | 66.61 | 105200.0 |
| 2006-07-10 | BBC | ETF | 13.6 | 14.12 | 12.7 | 13.05 | 692100.0 |
| 2006-07-10 | BBH | ETF | 59.8667 | 60.5533 | 59.36 | 59.51 | 781800.0 |
| 2006-07-10 | BITS | ETF | 18.72 | 19.16 | 17.4 | 18.64 | 18722.0 |
| 2006-07-10 | BKF | ETF | 5.8 | 6.03 | 5.8 | 5.99 | 17800.0 |
| 2006-07-10 | BNE | ETF | 14.03 | 14.37 | 14.0 | 14.05 | 129800.0 |
| 2006-07-10 | BRF | ETF | 13.9 | 14.0 | 13.9 | 13.99 | 18700.0 |
| 2006-07-10 | BTF | ETF | 89.0 | 89.55 | 88.2 | 88.94999999999999 | 3320.0 |
| 2006-07-10 | CBON | ETF | 32.26 | 32.75 | 32.17 | 32.65 | 23831.0 |
| 2006-07-10 | CDL | ETF | 8.87 | 9.02 | 8.84 | 8.96 | 187300.0 |
| 2006-07-10 | CEF | ETF | 8.82 | 8.85 | 8.64 | 8.65 | 252300.0 |
| 2006-07-10 | CEW | ETF | 25.87 | 25.87 | 25.87 | 25.87 | 900.0 |
| 2006-07-10 | CFO | ETF | 10.0 | 10.0 | 10.0 | 10.0 | 200.0 |
| 2006-07-10 | CGO | ETF | 14.78 | 14.8896 | 14.62 | 14.8 | 50400.0 |
| 2006-07-10 | CHB | ETF | 10.27 | 10.73 | 10.2 | 10.46 | 1287600.0 |
| 2006-07-10 | CHI | ETF | 19.65 | 19.65 | 19.5 | 19.6 | 95700.0 |
| 2006-07-10 | CHIC | ETF | 23.05 | 23.64 | 22.73 | 22.82 | 333471.0 |
| 2006-07-10 | CHY | ETF | 16.11 | 16.11 | 16.04 | 16.1 | 147400.0 |
| 2006-07-10 | CIL | ETF | 25.12 | 25.12 | 25.12 | 25.12 | 200.0 |
| 2006-07-10 | CN | ETF | 37.35 | 37.73 | 37.31 | 37.55 | 57900.0 |
| 2006-07-10 | CNXT | ETF | 2.215 | 2.25 | 2.06 | 2.09 | 11765976.0 |
| 2006-07-10 | COMB | ETF | 9.9 | 9.9 | 9.88 | 9.9 | 3595.0 |
| 2006-07-10 | CPST | ETF | 2.4 | 2.45 | 2.33 | 2.35 | 977101.0 |
| 2006-07-10 | CSA | ETF | 18.75 | 18.9 | 18.75 | 18.9 | 9000.0 |
| 2006-07-10 | CSB | ETF | 27.57 | 27.86 | 27.55 | 27.78 | 45400.0 |
| 2006-07-10 | CSQ | ETF | 14.01 | 14.02 | 13.87 | 14.0 | 275000.0 |
| 2006-07-10 | CTEC | ETF | 64.89999999999999 | 65.3 | 62.949999999999996 | 63.05 | 12105.2 |
| 2006-07-10 | CYB | ETF | 6.26 | 6.34 | 6.21 | 6.22 | 22600.0 |
| 2006-07-10 | DBC | ETF | 25.65 | 25.76 | 25.46 | 25.57 | 204700.0 |
| 2006-07-10 | DDM | ETF | 6.0217 | 6.0708 | 5.9767 | 5.9933 | 1243200.0 |
| 2006-07-10 | DES | ETF | 17.1567 | 17.3167 | 17.1567 | 17.2333 | 30300.0 |
| 2006-07-10 | DEW | ETF | 52.38 | 52.38 | 52.38 | 52.38 | 1800.0 |
| 2006-07-10 | DFE | ETF | 53.0 | 53.0 | 53.0 | 53.0 | 1200.0 |
| 2006-07-10 | DFJ | ETF | 51.6 | 51.6 | 51.48 | 51.48 | 300.0 |
| 2006-07-10 | DGT | ETF | 67.9 | 67.97 | 67.74 | 67.76 | 4500.0 |
| 2006-07-10 | DHS | ETF | 51.35 | 51.67 | 51.35 | 51.5 | 17200.0 |
> showing 50 of 351 rows — these rows as CSV