PREVIEW / etf_daily / 2006-12-11
file: by_date/etf_daily/2006/2006-12-11.parquet size: 19 KB rows: 388
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-12-11 | SPY | ETF | 141.42 | 142.09 | 141.34 | 141.83 | 39779400.0 |
| 2006-12-11 | QQQ | ETF | 43.835 | 44.37 | 43.75 | 44.06 | 72990453.0 |
| 2006-12-11 | IWM | ETF | 78.8 | 79.18 | 78.54 | 78.98 | 35233200.0 |
| 2006-12-11 | DIA | ETF | 123.11 | 123.55 | 123.07 | 123.34 | 3908400.0 |
| 2006-12-11 | GLD | ETF | 62.18 | 62.6 | 62.07 | 62.57 | 3163800.0 |
| 2006-12-11 | TLT | ETF | 90.63 | 90.74 | 90.51 | 90.63 | 727700.0 |
| 2006-12-11 | AAA | ETF | 59.96 | 60.22 | 59.96 | 60.14 | 2600.0 |
| 2006-12-11 | ADRE | ETF | 37.42 | 37.56 | 37.36 | 37.4799 | 84952.0 |
| 2006-12-11 | AGG | ETF | 100.59 | 100.65 | 100.5 | 100.5 | 249200.0 |
| 2006-12-11 | AIQ | ETF | 31.7 | 31.95 | 31.05 | 31.4 | 53040.0 |
| 2006-12-11 | AIS | ETF | 1.18 | 1.19 | 1.15 | 1.16 | 123800.0 |
| 2006-12-11 | ARB | ETF | 44.29 | 44.52 | 44.2 | 44.32 | 79200.0 |
| 2006-12-11 | BAB | ETF | 99.3 | 99.78 | 98.86 | 99.78 | 54200.0 |
| 2006-12-11 | BBC | ETF | 4.99 | 4.99 | 4.7 | 4.78 | 215900.0 |
| 2006-12-11 | BBH | ETF | 62.4733 | 62.88 | 62.3633 | 62.5933 | 252900.0 |
| 2006-12-11 | BITS | ETF | 33.56 | 34.8 | 33.12 | 34.0 | 41096.0 |
| 2006-12-11 | BNE | ETF | 15.92 | 15.97 | 15.28 | 15.4 | 178900.0 |
| 2006-12-11 | BOSS | ETF | 39.27 | 39.8 | 39.27 | 39.8 | 300.0 |
| 2006-12-11 | BRF | ETF | 14.27 | 14.31 | 14.27 | 14.27 | 40200.0 |
| 2006-12-11 | BTF | ETF | 112.44999999999999 | 112.44999999999999 | 111.95 | 112.39999999999999 | 2320.0 |
| 2006-12-11 | CBON | ETF | 30.33 | 30.42 | 30.23 | 30.38 | 12658.0 |
| 2006-12-11 | CDL | ETF | 9.76 | 9.8 | 9.69 | 9.71 | 183600.0 |
| 2006-12-11 | CEF | ETF | 9.5 | 9.55 | 9.5 | 9.52 | 553300.0 |
| 2006-12-11 | CEW | ETF | 25.63 | 25.64 | 25.63 | 25.64 | 200.0 |
| 2006-12-11 | CFO | ETF | 11.11 | 11.11 | 11.11 | 11.11 | 28600.0 |
| 2006-12-11 | CGO | ETF | 16.5 | 16.53 | 16.37 | 16.39 | 9100.0 |
| 2006-12-11 | CHB | ETF | 9.47 | 9.83 | 9.47 | 9.77 | 989800.0 |
| 2006-12-11 | CHI | ETF | 20.12 | 20.18 | 20.05 | 20.18 | 85100.0 |
| 2006-12-11 | CHIC | ETF | 30.93 | 31.43 | 30.64 | 31.3 | 474441.0 |
| 2006-12-11 | CHY | ETF | 16.95 | 17.02 | 16.9 | 16.99 | 96400.0 |
| 2006-12-11 | CIL | ETF | 25.2 | 25.28 | 25.2 | 25.28 | 2700.0 |
| 2006-12-11 | CN | ETF | 46.21 | 46.8 | 45.8 | 46.7 | 125700.0 |
| 2006-12-11 | CNXT | ETF | 2.231 | 2.27 | 2.21 | 2.22 | 5666654.0 |
| 2006-12-11 | CPI | ETF | 23.6 | 23.68 | 23.55 | 23.65 | 1000.0 |
| 2006-12-11 | CPST | ETF | 1.35 | 1.36 | 1.31 | 1.32 | 1187344.0 |
| 2006-12-11 | CSA | ETF | 22.37 | 23.15 | 22.29 | 22.3 | 38100.0 |
| 2006-12-11 | CSB | ETF | 32.8 | 33.11 | 32.78 | 33.06 | 27300.0 |
| 2006-12-11 | CSM | ETF | 1.335 | 1.335 | 1.335 | 1.335 | 800.0 |
| 2006-12-11 | CSQ | ETF | 15.37 | 15.5 | 15.37 | 15.5 | 293100.0 |
| 2006-12-11 | CTEC | ETF | 91.8 | 93.85 | 91.48799999999999 | 93.8 | 26456.2 |
| 2006-12-11 | CVY | ETF | 26.8 | 26.83 | 26.73 | 26.73 | 20800.0 |
| 2006-12-11 | DBC | ETF | 25.1 | 25.26 | 24.98 | 25.14 | 321000.0 |
| 2006-12-11 | DBV | ETF | 25.22 | 25.33 | 25.22 | 25.31 | 47000.0 |
| 2006-12-11 | DDM | ETF | 7.2992 | 7.3375 | 7.2917 | 7.315 | 278400.0 |
| 2006-12-11 | DES | ETF | 19.2533 | 19.3033 | 19.24 | 19.2767 | 36000.0 |
| 2006-12-11 | DEW | ETF | 60.7 | 61.2 | 60.7 | 61.1 | 7700.0 |
| 2006-12-11 | DFE | ETF | 63.9 | 64.31 | 63.74 | 64.24 | 10000.0 |
| 2006-12-11 | DFJ | ETF | 50.84 | 51.05 | 50.82 | 50.96 | 6200.0 |
| 2006-12-11 | DGT | ETF | 75.1 | 75.45 | 75.0 | 75.38 | 3300.0 |
| 2006-12-11 | DHS | ETF | 57.1 | 57.28 | 57.1 | 57.28 | 9400.0 |
> showing 50 of 388 rows — these rows as CSV