PREVIEW / etf_daily / 2006-11-06
file: by_date/etf_daily/2006/2006-11-06.parquet size: 19 KB rows: 377
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-06 | SPY | ETF | 136.96 | 138.28 | 136.95 | 138.08 | 63303300.0 |
| 2006-11-06 | QQQ | ETF | 42.06 | 42.71 | 42.06 | 42.54 | 101359757.0 |
| 2006-11-06 | IWM | ETF | 75.21 | 76.08 | 75.0 | 75.7 | 47702600.0 |
| 2006-11-06 | DIA | ETF | 120.06 | 121.14 | 120.02 | 121.01 | 7444400.0 |
| 2006-11-06 | GLD | ETF | 62.17 | 62.34 | 61.85 | 61.89 | 4078400.0 |
| 2006-11-06 | TLT | ETF | 88.35 | 88.79 | 88.35 | 88.79 | 528000.0 |
| 2006-11-06 | AAA | ETF | 56.85 | 57.1 | 56.59 | 57.1 | 21800.0 |
| 2006-11-06 | ADRE | ETF | 35.03 | 35.36 | 34.93 | 35.3 | 125682.0 |
| 2006-11-06 | AGG | ETF | 99.5 | 99.63 | 99.42 | 99.55 | 240000.0 |
| 2006-11-06 | AIQ | ETF | 38.0 | 38.25 | 36.45 | 37.0 | 33760.0 |
| 2006-11-06 | AIS | ETF | 1.18 | 1.24 | 1.18 | 1.23 | 183200.0 |
| 2006-11-06 | ARB | ETF | 42.15 | 42.73 | 42.15 | 42.7 | 289200.0 |
| 2006-11-06 | BAB | ETF | 85.45 | 86.5 | 85.26 | 86.42 | 96700.0 |
| 2006-11-06 | BBC | ETF | 9.3 | 10.44 | 9.3 | 10.39 | 563200.0 |
| 2006-11-06 | BBH | ETF | 62.8333 | 63.47 | 62.8333 | 63.3367 | 703800.0 |
| 2006-11-06 | BITS | ETF | 32.8 | 33.44 | 31.6 | 31.88 | 46542.0 |
| 2006-11-06 | BNE | ETF | 15.4 | 15.5 | 15.19 | 15.4 | 112900.0 |
| 2006-11-06 | BRF | ETF | 14.3 | 14.3 | 14.26 | 14.2701 | 3300.0 |
| 2006-11-06 | BTF | ETF | 103.05 | 105.35 | 103.05 | 105.1 | 4600.0 |
| 2006-11-06 | CBON | ETF | 29.1 | 30.31 | 28.88 | 30.04 | 107138.0 |
| 2006-11-06 | CDL | ETF | 9.25 | 10.4 | 9.08 | 10.4 | 547200.0 |
| 2006-11-06 | CEF | ETF | 8.89 | 8.93 | 8.8 | 8.83 | 426100.0 |
| 2006-11-06 | CEW | ETF | 25.46 | 25.46 | 25.46 | 25.46 | 10300.0 |
| 2006-11-06 | CFO | ETF | 10.3 | 10.56 | 10.3 | 10.56 | 2300.0 |
| 2006-11-06 | CGO | ETF | 15.77 | 15.79 | 15.6501 | 15.72 | 32300.0 |
| 2006-11-06 | CHB | ETF | 8.89 | 9.06 | 8.8 | 8.99 | 1121400.0 |
| 2006-11-06 | CHI | ETF | 19.34 | 19.63 | 19.34 | 19.6 | 99200.0 |
| 2006-11-06 | CHIC | ETF | 26.43 | 26.74 | 26.09 | 26.7 | 267937.0 |
| 2006-11-06 | CHY | ETF | 16.73 | 16.97 | 16.72 | 16.95 | 113000.0 |
| 2006-11-06 | CIZ | ETF | 22.6 | 22.6 | 22.6 | 22.6 | 700.0 |
| 2006-11-06 | CN | ETF | 35.26 | 35.95 | 35.26 | 35.77 | 37800.0 |
| 2006-11-06 | CNXT | ETF | 1.94 | 2.02 | 1.93 | 2.0 | 21322270.0 |
| 2006-11-06 | COMB | ETF | 9.62 | 9.62 | 9.62 | 9.62 | 400.0 |
| 2006-11-06 | CPI | ETF | 24.05 | 24.25 | 24.05 | 24.25 | 300.0 |
| 2006-11-06 | CPST | ETF | 1.49 | 1.55 | 1.49 | 1.53 | 468232.0 |
| 2006-11-06 | CSA | ETF | 20.25 | 20.25 | 20.0 | 20.03 | 13300.0 |
| 2006-11-06 | CSB | ETF | 30.99 | 31.23 | 30.99 | 31.13 | 8000.0 |
| 2006-11-06 | CSM | ETF | 1.3 | 1.305 | 1.3 | 1.305 | 41600.0 |
| 2006-11-06 | CSQ | ETF | 14.87 | 14.99 | 14.87 | 14.97 | 323600.0 |
| 2006-11-06 | CTEC | ETF | 80.25 | 81.69999999999999 | 80.15 | 81.05 | 36096.4 |
| 2006-11-06 | CVY | ETF | 25.8 | 25.99 | 25.76 | 25.97 | 44700.0 |
| 2006-11-06 | CYB | ETF | 6.7 | 6.84 | 6.1 | 6.43 | 366800.0 |
| 2006-11-06 | DBC | ETF | 24.7 | 25.07 | 24.65 | 25.05 | 282500.0 |
| 2006-11-06 | DBV | ETF | 25.6 | 25.64 | 25.53 | 25.62 | 95100.0 |
| 2006-11-06 | DDM | ETF | 6.9367 | 7.0558 | 6.9292 | 7.0383 | 981600.0 |
| 2006-11-06 | DES | ETF | 18.45 | 18.6667 | 18.4333 | 18.6267 | 53100.0 |
| 2006-11-06 | DEW | ETF | 58.6 | 59.05 | 58.59 | 58.99 | 21100.0 |
| 2006-11-06 | DFE | ETF | 59.06 | 59.42 | 59.06 | 59.42 | 1300.0 |
| 2006-11-06 | DFJ | ETF | 49.5 | 50.05 | 49.49 | 49.9 | 33400.0 |
| 2006-11-06 | DGT | ETF | 73.65 | 74.32 | 73.64 | 73.99 | 5800.0 |
> showing 50 of 377 rows — these rows as CSV