PREVIEW / etf_daily / 2005-10-28
file: by_date/etf_daily/2005/2005-10-28.parquet size: 15 KB rows: 282
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-28 | SPY | ETF | 118.43 | 119.95 | 118.1 | 119.8 | 72322000.0 |
| 2005-10-28 | QQQ | ETF | 38.17 | 38.392 | 37.92 | 38.322 | 95367478.0 |
| 2005-10-28 | IWM | ETF | 62.44 | 63.27 | 62.02 | 63.06 | 38437300.0 |
| 2005-10-28 | DIA | ETF | 102.65 | 103.96 | 102.46 | 103.84 | 8511100.0 |
| 2005-10-28 | GLD | ETF | 46.87 | 47.26 | 46.82 | 47.22 | 1435000.0 |
| 2005-10-28 | TLT | ETF | 89.72 | 89.88 | 89.12 | 89.61 | 750400.0 |
| 2005-10-28 | AAA | ETF | 54.94 | 55.08 | 54.72 | 54.8 | 1100.0 |
| 2005-10-28 | ADRE | ETF | 99.0 | 100.98 | 98.7 | 100.98 | 136480.0 |
| 2005-10-28 | AFK | ETF | 25.37 | 25.47 | 25.37 | 25.45 | 2400.0 |
| 2005-10-28 | AGG | ETF | 100.49 | 100.5 | 100.04 | 100.22 | 85700.0 |
| 2005-10-28 | AIQ | ETF | 34.6 | 35.45 | 33.95 | 34.85 | 12260.0 |
| 2005-10-28 | AIS | ETF | 1.09 | 1.22 | 1.09 | 1.22 | 113500.0 |
| 2005-10-28 | ARB | ETF | 37.61 | 37.81 | 37.24 | 37.47 | 153000.0 |
| 2005-10-28 | BAB | ETF | 51.65 | 52.16 | 51.55 | 52.16 | 10700.0 |
| 2005-10-28 | BBC | ETF | 6.6 | 7.0 | 6.51 | 7.0 | 28600.0 |
| 2005-10-28 | BBH | ETF | 62.5667 | 63.3333 | 62.4033 | 63.2333 | 1161900.0 |
| 2005-10-28 | BCM | ETF | 61.12 | 61.45 | 61.09 | 61.21 | 17200.0 |
| 2005-10-28 | BITS | ETF | 10.48 | 11.2 | 10.48 | 10.9552 | 3080.0 |
| 2005-10-28 | BKF | ETF | 16.15 | 16.68 | 15.06 | 16.6 | 454400.0 |
| 2005-10-28 | BNE | ETF | 13.32 | 14.0 | 13.32 | 13.93 | 241400.0 |
| 2005-10-28 | BRF | ETF | 15.22 | 15.35 | 15.22 | 15.35 | 1900.0 |
| 2005-10-28 | BTF | ETF | 83.69999999999999 | 84.19999999999999 | 83.64999999999999 | 84.14999999999999 | 4940.0 |
| 2005-10-28 | CBON | ETF | 32.55 | 32.6 | 32.31 | 32.6 | 13404.0 |
| 2005-10-28 | CDL | ETF | 13.42 | 13.7 | 13.33 | 13.6 | 161400.0 |
| 2005-10-28 | CEF | ETF | 5.85 | 5.85 | 5.76 | 5.82 | 245300.0 |
| 2005-10-28 | CEW | ETF | 25.95 | 25.95 | 25.95 | 25.95 | 200.0 |
| 2005-10-28 | CGO | ETF | 15.0 | 15.01 | 15.0 | 15.01 | 55700.0 |
| 2005-10-28 | CHB | ETF | 12.99 | 13.76 | 12.99 | 13.73 | 536100.0 |
| 2005-10-28 | CHI | ETF | 19.83 | 19.87 | 19.66 | 19.75 | 71000.0 |
| 2005-10-28 | CHIC | ETF | 16.49 | 17.25 | 16.46 | 16.85 | 257117.0 |
| 2005-10-28 | CHIR | ETF | 43.7901 | 43.7901 | 43.1001 | 43.4001 | 1782938.0 |
| 2005-10-28 | CHY | ETF | 15.68 | 15.72 | 15.62 | 15.69 | 51000.0 |
| 2005-10-28 | CIL | ETF | 25.9 | 25.9 | 25.9 | 25.9 | 1000.0 |
| 2005-10-28 | CN | ETF | 30.51 | 31.37 | 30.5 | 31.37 | 14300.0 |
| 2005-10-28 | CNXT | ETF | 1.92 | 1.93 | 1.83 | 1.9 | 16324013.0 |
| 2005-10-28 | CPST | ETF | 2.38 | 2.49 | 2.3 | 2.43 | 1340606.0 |
| 2005-10-28 | CSA | ETF | 16.95 | 17.13 | 16.94 | 17.05 | 144500.0 |
| 2005-10-28 | CSB | ETF | 28.51 | 28.7 | 28.4 | 28.65 | 10000.0 |
| 2005-10-28 | CSM | ETF | 2.4275 | 2.4275 | 2.4275 | 2.4275 | 800.0 |
| 2005-10-28 | CSQ | ETF | 13.43 | 13.72 | 13.43 | 13.7 | 284800.0 |
| 2005-10-28 | CTEC | ETF | 47.05 | 47.300000000000004 | 44.949999999999996 | 45.3 | 10730.400000000001 |
| 2005-10-28 | CURE | ETF | 0.1013 | 0.1113 | 0.0988 | 0.1087 | 3828776.0 |
| 2005-10-28 | CYB | ETF | 3.3 | 3.3 | 3.21 | 3.21 | 1000.0 |
| 2005-10-28 | DGT | ETF | 63.12 | 63.31 | 63.09 | 63.23 | 5300.0 |
| 2005-10-28 | DIV | ETF | 12.0 | 12.05 | 11.91 | 12.03 | 24400.0 |
| 2005-10-28 | DRIV | ETF | 27.9 | 28.77 | 27.0 | 28.19 | 2385265.0 |
| 2005-10-28 | DSI | ETF | 5.725 | 5.75 | 5.725 | 5.75 | 7600.0 |
| 2005-10-28 | DUSA | ETF | 8.83 | 9.29 | 8.83 | 9.27 | 110015.0 |
| 2005-10-28 | DVY | ETF | 59.97 | 60.86 | 59.97 | 60.86 | 384800.0 |
| 2005-10-28 | EDEN | ETF | 0.57 | 0.7 | 0.57 | 0.67 | 33498.0 |
> showing 50 of 282 rows — these rows as CSV