PREVIEW / etf_daily / 2006-11-28
file: by_date/etf_daily/2006/2006-11-28.parquet size: 19 KB rows: 381
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-11-28 | SPY | ETF | 138.24 | 139.16 | 138.11 | 139.02 | 106652900.0 |
| 2006-11-28 | QQQ | ETF | 43.52 | 43.84 | 43.34 | 43.77 | 118279827.0 |
| 2006-11-28 | IWM | ETF | 76.59 | 77.16 | 76.29 | 77.06 | 59174400.0 |
| 2006-11-28 | DIA | ETF | 121.0 | 121.45 | 120.68 | 121.26 | 8415800.0 |
| 2006-11-28 | GLD | ETF | 63.6 | 63.71 | 62.82 | 63.57 | 6057400.0 |
| 2006-11-28 | TLT | ETF | 91.24 | 91.25 | 90.76 | 91.14 | 1466300.0 |
| 2006-11-28 | AAA | ETF | 58.06 | 58.2 | 57.97 | 58.05 | 1300.0 |
| 2006-11-28 | ADRE | ETF | 35.54 | 35.85 | 35.42 | 35.8 | 183607.0 |
| 2006-11-28 | AGG | ETF | 100.87 | 100.94 | 100.6 | 100.91 | 269600.0 |
| 2006-11-28 | AIQ | ETF | 29.45 | 30.25 | 29.3 | 29.75 | 99340.0 |
| 2006-11-28 | AIS | ETF | 1.21 | 1.26 | 1.2 | 1.23 | 151800.0 |
| 2006-11-28 | ARB | ETF | 44.08 | 44.55 | 43.86 | 44.39 | 131200.0 |
| 2006-11-28 | BAB | ETF | 94.23 | 95.61 | 93.98 | 95.3 | 75700.0 |
| 2006-11-28 | BBC | ETF | 5.28 | 5.48 | 5.2 | 5.43 | 284300.0 |
| 2006-11-28 | BBH | ETF | 61.5 | 62.2133 | 61.3367 | 62.1533 | 1047300.0 |
| 2006-11-28 | BITS | ETF | 34.4 | 34.4 | 32.32 | 32.6 | 41388.0 |
| 2006-11-28 | BNE | ETF | 15.4 | 15.74 | 15.32 | 15.7 | 129800.0 |
| 2006-11-28 | BRF | ETF | 14.24 | 14.3 | 14.24 | 14.3 | 8500.0 |
| 2006-11-28 | BTF | ETF | 105.35 | 105.39999999999999 | 104.85 | 105.39999999999999 | 5040.0 |
| 2006-11-28 | CBON | ETF | 30.17 | 30.29 | 29.85 | 29.99 | 34372.0 |
| 2006-11-28 | CDL | ETF | 9.38 | 9.4299 | 9.3 | 9.37 | 299100.0 |
| 2006-11-28 | CEF | ETF | 10.25 | 10.3 | 9.91 | 10.28 | 1787600.0 |
| 2006-11-28 | CEW | ETF | 25.65 | 25.65 | 25.65 | 25.65 | 100.0 |
| 2006-11-28 | CFO | ETF | 10.85 | 10.85 | 10.85 | 10.85 | 5000.0 |
| 2006-11-28 | CGO | ETF | 16.08 | 16.25 | 16.05 | 16.15 | 15500.0 |
| 2006-11-28 | CHB | ETF | 8.8 | 9.38 | 8.56 | 8.94 | 1222500.0 |
| 2006-11-28 | CHI | ETF | 19.74 | 19.95 | 19.74 | 19.9 | 111000.0 |
| 2006-11-28 | CHIC | ETF | 29.26 | 29.3 | 28.47 | 29.23 | 533616.0 |
| 2006-11-28 | CHY | ETF | 16.9 | 17.0 | 16.88 | 16.97 | 99000.0 |
| 2006-11-28 | CIL | ETF | 25.03 | 25.03 | 25.01 | 25.01 | 1200.0 |
| 2006-11-28 | CN | ETF | 39.15 | 39.15 | 37.9 | 38.73 | 69800.0 |
| 2006-11-28 | CNXT | ETF | 2.16 | 2.18 | 2.09 | 2.1 | 14953599.0 |
| 2006-11-28 | CPI | ETF | 24.3899 | 24.3899 | 24.3899 | 24.3899 | 300.0 |
| 2006-11-28 | CPST | ETF | 1.37 | 1.43 | 1.32 | 1.38 | 4089777.0 |
| 2006-11-28 | CSA | ETF | 21.16 | 21.34 | 21.12 | 21.3 | 19600.0 |
| 2006-11-28 | CSB | ETF | 31.83 | 32.08 | 31.73 | 31.98 | 15100.0 |
| 2006-11-28 | CSQ | ETF | 15.22 | 15.41 | 15.21 | 15.33 | 536500.0 |
| 2006-11-28 | CTEC | ETF | 90.6 | 91.89999999999999 | 90.05 | 91.6 | 15594.2 |
| 2006-11-28 | CVY | ETF | 26.01 | 26.21 | 26.01 | 26.21 | 18700.0 |
| 2006-11-28 | DBC | ETF | 25.12 | 25.24 | 25.06 | 25.23 | 156800.0 |
| 2006-11-28 | DBV | ETF | 25.1 | 25.15 | 25.0 | 25.14 | 52800.0 |
| 2006-11-28 | DDM | ETF | 7.0567 | 7.1067 | 7.0242 | 7.0908 | 1224000.0 |
| 2006-11-28 | DES | ETF | 18.75 | 18.8833 | 18.7367 | 18.8833 | 53100.0 |
| 2006-11-28 | DEW | ETF | 59.22 | 59.77 | 59.22 | 59.77 | 3100.0 |
| 2006-11-28 | DFE | ETF | 60.95 | 61.2 | 60.9 | 61.2 | 1300.0 |
| 2006-11-28 | DFJ | ETF | 48.45 | 48.92 | 48.39 | 48.92 | 33000.0 |
| 2006-11-28 | DGT | ETF | 73.75 | 74.26 | 73.7 | 74.26 | 18600.0 |
| 2006-11-28 | DHS | ETF | 56.1 | 56.27 | 55.97 | 56.13 | 30300.0 |
| 2006-11-28 | DIM | ETF | 59.98 | 60.41 | 59.98 | 60.36 | 7300.0 |
| 2006-11-28 | DIV | ETF | 13.2499 | 13.28 | 13.22 | 13.27 | 35400.0 |
> showing 50 of 381 rows — these rows as CSV