PREVIEW / etf_daily / 2006-11-15
file: by_date/etf_daily/2006/2006-11-15.parquet size: 19 KB rows: 382
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-15 | SPY | ETF | 139.57 | 140.45 | 139.53 | 140.02 | 76509600.0 |
| 2006-11-15 | QQQ | ETF | 43.98 | 44.4 | 43.92 | 44.11 | 116585246.0 |
| 2006-11-15 | IWM | ETF | 78.15 | 79.01 | 77.98 | 78.7 | 65076400.0 |
| 2006-11-15 | DIA | ETF | 122.34 | 123.11 | 122.28 | 122.69 | 8817400.0 |
| 2006-11-15 | GLD | ETF | 61.34 | 62.07 | 61.25 | 61.84 | 3760500.0 |
| 2006-11-15 | TLT | ETF | 90.05 | 90.05 | 89.74 | 89.85 | 1803200.0 |
| 2006-11-15 | AAA | ETF | 57.47 | 58.03 | 57.47 | 57.99 | 6000.0 |
| 2006-11-15 | ADRE | ETF | 36.0 | 36.19 | 35.63 | 36.0 | 157264.0 |
| 2006-11-15 | AGG | ETF | 100.28 | 100.28 | 100.07 | 100.15 | 213000.0 |
| 2006-11-15 | AIQ | ETF | 37.0 | 37.5 | 36.5 | 37.0 | 14220.0 |
| 2006-11-15 | AIS | ETF | 1.28 | 1.29 | 1.2216 | 1.23 | 74700.0 |
| 2006-11-15 | ARB | ETF | 44.7 | 45.4 | 44.7 | 45.35 | 154200.0 |
| 2006-11-15 | BAB | ETF | 89.09 | 91.91 | 89.09 | 91.78 | 114100.0 |
| 2006-11-15 | BBC | ETF | 5.96 | 6.25 | 5.2699 | 5.29 | 1527000.0 |
| 2006-11-15 | BBH | ETF | 62.1333 | 62.8667 | 62.11 | 62.6333 | 734100.0 |
| 2006-11-15 | BITS | ETF | 38.24 | 38.36 | 34.68 | 34.8 | 115748.0 |
| 2006-11-15 | BNE | ETF | 15.56 | 16.0 | 15.45 | 15.91 | 157400.0 |
| 2006-11-15 | BRF | ETF | 14.26 | 14.2618 | 14.21 | 14.21 | 20900.0 |
| 2006-11-15 | BTF | ETF | 105.0 | 105.6245 | 105.0 | 105.5 | 5680.0 |
| 2006-11-15 | CBON | ETF | 31.19 | 31.644 | 30.76 | 31.17 | 56548.0 |
| 2006-11-15 | CDL | ETF | 10.49 | 10.55 | 10.44 | 10.52 | 255800.0 |
| 2006-11-15 | CEF | ETF | 9.09 | 9.19 | 9.0 | 9.17 | 397900.0 |
| 2006-11-15 | CFO | ETF | 10.71 | 10.85 | 10.71 | 10.85 | 1500.0 |
| 2006-11-15 | CGO | ETF | 15.78 | 15.9 | 15.7 | 15.89 | 22600.0 |
| 2006-11-15 | CHB | ETF | 8.97 | 9.32 | 8.9501 | 9.14 | 1393500.0 |
| 2006-11-15 | CHI | ETF | 19.56 | 19.64 | 19.52 | 19.64 | 133000.0 |
| 2006-11-15 | CHIC | ETF | 28.01 | 28.49 | 27.77 | 27.78 | 574006.0 |
| 2006-11-15 | CHY | ETF | 16.74 | 16.8 | 16.6501 | 16.69 | 124700.0 |
| 2006-11-15 | CIL | ETF | 25.88 | 25.88 | 25.88 | 25.88 | 400.0 |
| 2006-11-15 | CIZ | ETF | 22.2 | 22.25 | 22.2 | 22.25 | 500.0 |
| 2006-11-15 | CN | ETF | 40.3 | 40.4 | 40.2 | 40.21 | 213500.0 |
| 2006-11-15 | CNXT | ETF | 2.27 | 2.36 | 2.25 | 2.29 | 14000458.0 |
| 2006-11-15 | CPST | ETF | 1.4 | 1.4 | 1.34 | 1.35 | 2010798.0 |
| 2006-11-15 | CSA | ETF | 20.35 | 20.5 | 20.3 | 20.41 | 266200.0 |
| 2006-11-15 | CSB | ETF | 31.3 | 31.48 | 31.29 | 31.48 | 4200.0 |
| 2006-11-15 | CSM | ETF | 1.3075 | 1.3125 | 1.3075 | 1.3125 | 20800.0 |
| 2006-11-15 | CSQ | ETF | 14.97 | 14.99 | 14.92 | 14.96 | 338800.0 |
| 2006-11-15 | CTEC | ETF | 88.8 | 88.8 | 86.95 | 88.75 | 25707.2 |
| 2006-11-15 | CVY | ETF | 26.04 | 26.21 | 26.04 | 26.19 | 42600.0 |
| 2006-11-15 | CYB | ETF | 6.63 | 6.63 | 6.46 | 6.6 | 39700.0 |
| 2006-11-15 | DBC | ETF | 24.56 | 24.95 | 24.56 | 24.84 | 235500.0 |
| 2006-11-15 | DBV | ETF | 25.3 | 25.31 | 25.2 | 25.23 | 30700.0 |
| 2006-11-15 | DDM | ETF | 7.2042 | 7.275 | 7.2042 | 7.2392 | 956400.0 |
| 2006-11-15 | DES | ETF | 19.0267 | 19.17 | 19.0267 | 19.13 | 49500.0 |
| 2006-11-15 | DEW | ETF | 60.27 | 60.36 | 59.5 | 59.64 | 36000.0 |
| 2006-11-15 | DFE | ETF | 60.42 | 60.71 | 60.42 | 60.6 | 9200.0 |
| 2006-11-15 | DFJ | ETF | 48.42 | 48.79 | 48.42 | 48.7 | 34600.0 |
| 2006-11-15 | DGT | ETF | 74.65 | 74.9 | 74.42 | 74.8 | 9200.0 |
| 2006-11-15 | DHS | ETF | 56.4 | 56.4 | 56.2 | 56.37 | 36100.0 |
| 2006-11-15 | DIM | ETF | 59.8 | 60.26 | 59.8 | 60.1 | 20600.0 |
> showing 50 of 382 rows — these rows as CSV