PREVIEW / etf_daily / 2006-06-21
file: by_date/etf_daily/2006/2006-06-21.parquet size: 17 KB rows: 344
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-21 | SPY | ETF | 124.0 | 125.7 | 123.96 | 125.01 | 75008200.0 |
| 2006-06-21 | QQQ | ETF | 38.14 | 38.99 | 38.13 | 38.68 | 129566304.0 |
| 2006-06-21 | IWM | ETF | 67.37 | 69.06 | 67.25 | 68.6 | 81035400.0 |
| 2006-06-21 | DIA | ETF | 109.7 | 111.25 | 109.69 | 110.71 | 9160600.0 |
| 2006-06-21 | GLD | ETF | 56.62 | 58.77 | 56.62 | 58.33 | 6162100.0 |
| 2006-06-21 | TLT | ETF | 84.25 | 84.25 | 84.07 | 84.07 | 476000.0 |
| 2006-06-21 | AAA | ETF | 54.86 | 55.37 | 54.69 | 55.2 | 10200.0 |
| 2006-06-21 | ADRE | ETF | 113.92 | 117.5 | 113.78 | 117.001 | 111248.0 |
| 2006-06-21 | AFK | ETF | 24.84 | 24.84 | 24.76 | 24.79 | 6900.0 |
| 2006-06-21 | AGG | ETF | 97.51 | 97.69 | 97.41 | 97.59 | 95700.0 |
| 2006-06-21 | AIQ | ETF | 29.7 | 32.5 | 29.7 | 32.15 | 23460.0 |
| 2006-06-21 | AIS | ETF | 1.14 | 1.1901 | 1.14 | 1.18 | 77700.0 |
| 2006-06-21 | AOM | ETF | 6.2 | 6.26 | 6.2 | 6.26 | 20500.0 |
| 2006-06-21 | ARB | ETF | 36.75 | 37.28 | 36.7 | 37.15 | 205100.0 |
| 2006-06-21 | BAB | ETF | 67.17 | 67.98 | 66.87 | 67.79 | 60700.0 |
| 2006-06-21 | BBC | ETF | 10.3 | 10.9 | 10.2 | 10.57 | 189400.0 |
| 2006-06-21 | BBH | ETF | 56.4667 | 57.4867 | 56.4667 | 57.13 | 1543800.0 |
| 2006-06-21 | BCM | ETF | 67.8 | 68.57 | 67.34 | 67.63 | 40400.0 |
| 2006-06-21 | BITS | ETF | 19.88 | 20.2 | 18.48 | 19.08 | 45457.0 |
| 2006-06-21 | BKF | ETF | 6.08 | 6.38 | 6.08 | 6.31 | 48000.0 |
| 2006-06-21 | BNE | ETF | 13.53 | 13.9 | 13.53 | 13.8 | 167600.0 |
| 2006-06-21 | BRF | ETF | 13.99 | 14.0 | 13.95 | 14.0 | 6300.0 |
| 2006-06-21 | BTF | ETF | 88.55 | 89.45 | 88.55 | 89.1 | 940.0 |
| 2006-06-21 | CBON | ETF | 29.6 | 30.0 | 29.6 | 29.81 | 6000.0 |
| 2006-06-21 | CDL | ETF | 8.67 | 8.78 | 8.62 | 8.72 | 515900.0 |
| 2006-06-21 | CEF | ETF | 8.58 | 8.7 | 8.49 | 8.66 | 482800.0 |
| 2006-06-21 | CEW | ETF | 26.05 | 26.25 | 26.05 | 26.25 | 900.0 |
| 2006-06-21 | CFO | ETF | 9.6 | 9.6 | 9.6 | 9.6 | 2000.0 |
| 2006-06-21 | CGO | ETF | 14.05 | 14.18 | 14.0 | 14.07 | 15300.0 |
| 2006-06-21 | CHB | ETF | 9.28 | 10.26 | 9.28 | 10.26 | 1823200.0 |
| 2006-06-21 | CHI | ETF | 19.07 | 19.15 | 19.006 | 19.12 | 57200.0 |
| 2006-06-21 | CHIC | ETF | 19.76 | 20.03 | 19.73 | 19.95 | 223513.0 |
| 2006-06-21 | CHY | ETF | 16.05 | 16.0999 | 16.0 | 16.02 | 215700.0 |
| 2006-06-21 | CIL | ETF | 25.04 | 25.04 | 25.04 | 25.04 | 100.0 |
| 2006-06-21 | CN | ETF | 32.4 | 33.25 | 32.31 | 33.09 | 22300.0 |
| 2006-06-21 | CNXT | ETF | 2.365 | 2.49 | 2.36 | 2.43 | 10295922.0 |
| 2006-06-21 | COMB | ETF | 9.7 | 9.85 | 9.5 | 9.75 | 108600.0 |
| 2006-06-21 | CPI | ETF | 32.0 | 32.0 | 31.25 | 31.25 | 1300.0 |
| 2006-06-21 | CPST | ETF | 2.46 | 2.66 | 2.41 | 2.58 | 1986484.0 |
| 2006-06-21 | CSA | ETF | 18.75 | 19.0032 | 18.75 | 19.0032 | 1200.0 |
| 2006-06-21 | CSB | ETF | 27.01 | 27.37 | 27.01 | 27.3 | 36700.0 |
| 2006-06-21 | CSQ | ETF | 13.81 | 13.9 | 13.77 | 13.89 | 334600.0 |
| 2006-06-21 | CTEC | ETF | 62.949999999999996 | 65.25 | 62.55 | 63.75 | 20979.600000000002 |
| 2006-06-21 | CYB | ETF | 5.65 | 5.6514 | 5.55 | 5.55 | 7000.0 |
| 2006-06-21 | DBC | ETF | 24.05 | 24.5 | 23.9701 | 24.45 | 302100.0 |
| 2006-06-21 | DDM | ETF | 5.9025 | 6.0208 | 5.9025 | 5.98 | 2719200.0 |
| 2006-06-21 | DES | ETF | 16.5967 | 16.73 | 16.58 | 16.7067 | 13800.0 |
| 2006-06-21 | DEW | ETF | 50.25 | 50.37 | 50.25 | 50.37 | 600.0 |
| 2006-06-21 | DFE | ETF | 50.86 | 50.86 | 50.86 | 50.86 | 100.0 |
| 2006-06-21 | DFJ | ETF | 49.9 | 49.9 | 49.9 | 49.9 | 100.0 |
> showing 50 of 344 rows — these rows as CSV