PREVIEW / etf_daily / 2006-04-28
file: by_date/etf_daily/2006/2006-04-28.parquet size: 16 KB rows: 313
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-04-28 | SPY | ETF | 130.79 | 131.75 | 130.71 | 131.47 | 55854400.0 |
| 2006-04-28 | QQQ | ETF | 42.0 | 42.22 | 41.78 | 41.85 | 88883223.0 |
| 2006-04-28 | IWM | ETF | 75.24 | 76.35 | 75.1 | 76.2 | 37918800.0 |
| 2006-04-28 | DIA | ETF | 113.66 | 114.1 | 113.39 | 113.88 | 4110100.0 |
| 2006-04-28 | GLD | ETF | 63.9 | 65.27 | 63.83 | 65.09 | 8378000.0 |
| 2006-04-28 | TLT | ETF | 83.97 | 84.21 | 83.76 | 84.16 | 809400.0 |
| 2006-04-28 | AAA | ETF | 62.7 | 63.13 | 62.7 | 63.13 | 14400.0 |
| 2006-04-28 | ADRE | ETF | 136.0 | 138.8 | 136.0 | 138.42 | 31200.0 |
| 2006-04-28 | AFK | ETF | 25.14 | 25.14 | 25.1 | 25.1 | 3900.0 |
| 2006-04-28 | AGG | ETF | 98.44 | 98.55 | 98.21 | 98.55 | 219900.0 |
| 2006-04-28 | AIQ | ETF | 26.35 | 26.8 | 25.75 | 26.2 | 8560.0 |
| 2006-04-28 | AIS | ETF | 1.6 | 1.74 | 1.56 | 1.7199 | 407200.0 |
| 2006-04-28 | AOM | ETF | 6.95 | 6.95 | 6.68 | 6.82 | 20200.0 |
| 2006-04-28 | ARB | ETF | 34.8 | 35.66 | 34.8 | 35.66 | 345300.0 |
| 2006-04-28 | BAB | ETF | 60.79 | 61.29 | 60.73 | 60.89 | 21800.0 |
| 2006-04-28 | BBC | ETF | 14.95 | 14.98 | 14.7 | 14.75 | 417400.0 |
| 2006-04-28 | BBH | ETF | 57.97 | 58.4333 | 57.54 | 58.1867 | 749400.0 |
| 2006-04-28 | BCM | ETF | 74.44 | 74.65 | 73.95 | 74.0 | 29400.0 |
| 2006-04-28 | BITS | ETF | 36.04 | 36.24 | 33.32 | 34.4 | 51774.0 |
| 2006-04-28 | BKF | ETF | 8.91 | 9.3 | 8.89 | 9.03 | 45500.0 |
| 2006-04-28 | BNE | ETF | 15.98 | 16.13 | 15.69 | 15.71 | 94700.0 |
| 2006-04-28 | BOSS | ETF | 37.46 | 37.46 | 37.46 | 37.46 | 200.0 |
| 2006-04-28 | BRF | ETF | 13.85 | 13.93 | 13.85 | 13.85 | 19400.0 |
| 2006-04-28 | BTF | ETF | 87.24999999999999 | 87.35 | 86.99999999999999 | 86.99999999999999 | 1460.0 |
| 2006-04-28 | CBON | ETF | 32.85 | 33.54 | 32.26 | 32.63 | 13156.0 |
| 2006-04-28 | CDL | ETF | 9.33 | 9.41 | 9.23 | 9.41 | 782400.0 |
| 2006-04-28 | CEF | ETF | 9.21 | 9.33 | 8.89 | 9.13 | 2178400.0 |
| 2006-04-28 | CEW | ETF | 25.75 | 25.75 | 25.75 | 25.75 | 200.0 |
| 2006-04-28 | CFO | ETF | 10.27 | 10.3 | 10.27 | 10.3 | 13900.0 |
| 2006-04-28 | CGO | ETF | 14.35 | 14.44 | 14.25 | 14.44 | 38600.0 |
| 2006-04-28 | CHB | ETF | 15.0 | 15.45 | 14.93 | 15.26 | 544100.0 |
| 2006-04-28 | CHI | ETF | 20.06 | 20.2999 | 20.06 | 20.29 | 44800.0 |
| 2006-04-28 | CHIC | ETF | 21.37 | 21.79 | 21.37 | 21.6 | 212167.0 |
| 2006-04-28 | CHY | ETF | 15.98 | 16.04 | 15.92 | 16.02 | 59100.0 |
| 2006-04-28 | CIZ | ETF | 22.9 | 22.9 | 22.9 | 22.9 | 100.0 |
| 2006-04-28 | CN | ETF | 36.4 | 37.05 | 36.4 | 36.93 | 28600.0 |
| 2006-04-28 | CNXT | ETF | 3.72 | 3.73 | 3.37 | 3.54 | 54445406.0 |
| 2006-04-28 | COMB | ETF | 10.1 | 10.5 | 9.621 | 10.44 | 6863.0 |
| 2006-04-28 | CPI | ETF | 31.15 | 31.39 | 31.05 | 31.39 | 400.0 |
| 2006-04-28 | CPST | ETF | 4.11 | 4.13 | 3.75 | 3.78 | 4464585.0 |
| 2006-04-28 | CSA | ETF | 18.8 | 19.4 | 18.8 | 19.34 | 16100.0 |
| 2006-04-28 | CSB | ETF | 30.39 | 30.7 | 30.39 | 30.62 | 11700.0 |
| 2006-04-28 | CSQ | ETF | 13.93 | 13.96 | 13.85 | 13.89 | 311800.0 |
| 2006-04-28 | CTEC | ETF | 64.0 | 64.69999999999999 | 63.25 | 63.89999999999999 | 12076.2 |
| 2006-04-28 | CYB | ETF | 6.26 | 6.26 | 6.0001 | 6.07 | 11800.0 |
| 2006-04-28 | DBC | ETF | 25.45 | 25.77 | 25.36 | 25.62 | 453800.0 |
| 2006-04-28 | DGT | ETF | 68.85 | 69.07 | 68.85 | 69.07 | 600.0 |
| 2006-04-28 | DIG | ETF | 17.8125 | 17.8125 | 17.8125 | 17.8125 | 320.0 |
| 2006-04-28 | DIV | ETF | 11.98 | 12.0 | 11.93 | 11.98 | 17700.0 |
| 2006-04-28 | DRIV | ETF | 44.51 | 45.41 | 43.26 | 43.54 | 2801721.0 |
> showing 50 of 313 rows — these rows as CSV