PREVIEW / etf_daily / 2006-03-08
file: by_date/etf_daily/2006/2006-03-08.parquet size: 16 KB rows: 309
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-03-08 | SPY | ETF | 127.7 | 128.44 | 127.18 | 128.24 | 66692400.0 |
| 2006-03-08 | QQQ | ETF | 40.77 | 41.09 | 40.5 | 40.87 | 104013376.0 |
| 2006-03-08 | IWM | ETF | 71.45 | 72.0 | 70.88 | 71.85 | 51662600.0 |
| 2006-03-08 | DIA | ETF | 109.7 | 110.33 | 109.27 | 110.1 | 6353000.0 |
| 2006-03-08 | GLD | ETF | 54.21 | 54.27 | 53.56 | 53.97 | 6712100.0 |
| 2006-03-08 | TLT | ETF | 88.57 | 88.88 | 88.45 | 88.58 | 1184700.0 |
| 2006-03-08 | AAA | ETF | 53.47 | 54.26 | 53.47 | 54.25 | 20200.0 |
| 2006-03-08 | ADRE | ETF | 123.39 | 123.39 | 120.5 | 122.5799 | 160224.0 |
| 2006-03-08 | AFK | ETF | 25.44 | 25.51 | 25.42 | 25.49 | 6300.0 |
| 2006-03-08 | AGG | ETF | 99.35 | 99.35 | 99.1 | 99.25 | 196100.0 |
| 2006-03-08 | AIQ | ETF | 29.2 | 29.65 | 29.0 | 29.05 | 9980.0 |
| 2006-03-08 | AIS | ETF | 1.4 | 1.4 | 1.33 | 1.39 | 344100.0 |
| 2006-03-08 | AOM | ETF | 6.62 | 6.64 | 6.4 | 6.41 | 19700.0 |
| 2006-03-08 | ARB | ETF | 34.4 | 34.8 | 34.35 | 34.68 | 272400.0 |
| 2006-03-08 | BAB | ETF | 55.05 | 55.52 | 54.89 | 55.46 | 53300.0 |
| 2006-03-08 | BBC | ETF | 14.1 | 14.76 | 13.5 | 14.73 | 158300.0 |
| 2006-03-08 | BBH | ETF | 63.74 | 65.5 | 63.3533 | 65.0 | 3447600.0 |
| 2006-03-08 | BCM | ETF | 72.5 | 73.05 | 72.44 | 72.96 | 25500.0 |
| 2006-03-08 | BITS | ETF | 30.08 | 30.08 | 27.08 | 29.04 | 111099.0 |
| 2006-03-08 | BKF | ETF | 12.91 | 13.01 | 12.75 | 12.97 | 51600.0 |
| 2006-03-08 | BNE | ETF | 14.28 | 15.1 | 14.28 | 14.84 | 121100.0 |
| 2006-03-08 | BRF | ETF | 14.59 | 14.59 | 14.5 | 14.55 | 21100.0 |
| 2006-03-08 | BTF | ETF | 87.75 | 87.75 | 87.05 | 87.5 | 1900.0 |
| 2006-03-08 | CBON | ETF | 30.83 | 30.94 | 30.5 | 30.67 | 32082.0 |
| 2006-03-08 | CDL | ETF | 11.65 | 11.69 | 11.54 | 11.61 | 240700.0 |
| 2006-03-08 | CEF | ETF | 7.6 | 7.6 | 7.35 | 7.57 | 775800.0 |
| 2006-03-08 | CFO | ETF | 9.67 | 9.67 | 9.65 | 9.65 | 17000.0 |
| 2006-03-08 | CGO | ETF | 14.27 | 14.29 | 14.1 | 14.29 | 19600.0 |
| 2006-03-08 | CHB | ETF | 15.03 | 15.03 | 13.21 | 14.75 | 2129100.0 |
| 2006-03-08 | CHI | ETF | 20.81 | 20.88 | 20.81 | 20.83 | 90500.0 |
| 2006-03-08 | CHIC | ETF | 19.0 | 19.1 | 18.61 | 18.98 | 260304.0 |
| 2006-03-08 | CHIR | ETF | 45.3 | 45.6099 | 45.2901 | 45.48 | 655023.0 |
| 2006-03-08 | CHY | ETF | 16.48 | 16.52 | 16.4 | 16.43 | 94400.0 |
| 2006-03-08 | CIL | ETF | 25.62 | 25.62 | 25.58 | 25.58 | 6800.0 |
| 2006-03-08 | CIZ | ETF | 23.35 | 23.35 | 23.25 | 23.25 | 1500.0 |
| 2006-03-08 | CN | ETF | 35.6 | 36.0 | 35.35 | 35.87 | 39900.0 |
| 2006-03-08 | CNXT | ETF | 3.13 | 3.22 | 3.12 | 3.19 | 13024604.0 |
| 2006-03-08 | COMB | ETF | 8.45 | 8.45 | 8.45 | 8.45 | 790.0 |
| 2006-03-08 | CPI | ETF | 30.5 | 30.5 | 30.5 | 30.5 | 300.0 |
| 2006-03-08 | CPST | ETF | 3.23 | 3.25 | 3.15 | 3.19 | 1096459.0 |
| 2006-03-08 | CSA | ETF | 19.63 | 19.8 | 19.5 | 19.51 | 4400.0 |
| 2006-03-08 | CSB | ETF | 30.48 | 30.75 | 30.48 | 30.58 | 4100.0 |
| 2006-03-08 | CSQ | ETF | 14.05 | 14.2 | 13.97 | 14.15 | 334700.0 |
| 2006-03-08 | CTEC | ETF | 59.5 | 63.449999999999996 | 59.5 | 60.4 | 35370.6 |
| 2006-03-08 | CYB | ETF | 5.7 | 5.84 | 5.47 | 5.84 | 25500.0 |
| 2006-03-08 | DBC | ETF | 22.78 | 22.9 | 22.53 | 22.72 | 243700.0 |
| 2006-03-08 | DGT | ETF | 66.6 | 66.64 | 66.49 | 66.64 | 600.0 |
| 2006-03-08 | DIG | ETF | 17.25 | 17.25 | 17.0625 | 17.075 | 3520.0 |
| 2006-03-08 | DIV | ETF | 12.42 | 12.54 | 12.4 | 12.5 | 19700.0 |
| 2006-03-08 | DRIV | ETF | 38.49 | 40.56 | 38.3 | 40.03 | 2227231.0 |
> showing 50 of 309 rows — these rows as CSV