PREVIEW / etf_daily / 2005-10-10
file: by_date/etf_daily/2005/2005-10-10.parquet size: 15 KB rows: 279
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-10 | SPY | ETF | 119.68 | 119.71 | 118.3 | 118.6 | 52677000.0 |
| 2005-10-10 | QQQ | ETF | 38.29 | 38.461 | 38.06 | 38.13 | 64031810.0 |
| 2005-10-10 | IWM | ETF | 64.25 | 64.28 | 63.3 | 63.38 | 16625700.0 |
| 2005-10-10 | DIA | ETF | 103.18 | 103.24 | 102.29 | 102.32 | 5053100.0 |
| 2005-10-10 | GLD | ETF | 47.31 | 47.44 | 47.09 | 47.37 | 1285500.0 |
| 2005-10-10 | TLT | ETF | 91.85 | 91.97 | 91.62 | 91.78 | 159700.0 |
| 2005-10-10 | AAA | ETF | 56.8 | 56.93 | 56.63 | 56.81 | 3100.0 |
| 2005-10-10 | ADRE | ETF | 107.83 | 109.89 | 104.04 | 104.19 | 29408.0 |
| 2005-10-10 | AFK | ETF | 25.65 | 25.65 | 25.51 | 25.58 | 1200.0 |
| 2005-10-10 | AGG | ETF | 101.09 | 101.24 | 101.0 | 101.13 | 90100.0 |
| 2005-10-10 | AIQ | ETF | 38.95 | 39.4 | 36.25 | 37.9 | 23100.0 |
| 2005-10-10 | AIS | ETF | 0.97 | 0.97 | 0.93 | 0.96 | 17800.0 |
| 2005-10-10 | ARB | ETF | 38.74 | 39.64 | 38.4 | 39.07 | 137200.0 |
| 2005-10-10 | BAB | ETF | 55.47 | 55.47 | 54.86 | 54.89 | 31800.0 |
| 2005-10-10 | BBC | ETF | 7.2 | 7.39 | 7.2 | 7.27 | 52100.0 |
| 2005-10-10 | BBH | ETF | 61.6467 | 61.8333 | 61.0267 | 61.4333 | 1723500.0 |
| 2005-10-10 | BCM | ETF | 61.15 | 61.3 | 61.01 | 61.0201 | 2800.0 |
| 2005-10-10 | BIS | ETF | 614.4 | 622.4 | 614.4 | 622.4 | 6.9 |
| 2005-10-10 | BITS | ETF | 10.64 | 11.12 | 10.64 | 10.68 | 800.0 |
| 2005-10-10 | BKF | ETF | 28.23 | 28.23 | 27.47 | 27.54 | 63100.0 |
| 2005-10-10 | BNE | ETF | 14.2 | 14.2 | 13.69 | 13.77 | 95000.0 |
| 2005-10-10 | BRF | ETF | 15.55 | 15.57 | 15.44 | 15.44 | 4200.0 |
| 2005-10-10 | BTF | ETF | 85.6 | 86.25 | 85.6 | 86.25 | 3740.0 |
| 2005-10-10 | CBON | ETF | 32.65 | 32.85 | 32.5 | 32.52 | 21793.0 |
| 2005-10-10 | CDC | ETF | 3.92 | 4.14 | 3.9 | 4.03 | 3300.0 |
| 2005-10-10 | CDL | ETF | 14.74 | 14.74 | 13.77 | 14.08 | 460300.0 |
| 2005-10-10 | CEF | ETF | 5.84 | 5.84 | 5.75 | 5.81 | 275800.0 |
| 2005-10-10 | CEW | ETF | 25.9 | 25.91 | 25.9 | 25.91 | 1000.0 |
| 2005-10-10 | CHB | ETF | 13.75 | 13.75 | 13.35 | 13.41 | 417300.0 |
| 2005-10-10 | CHI | ETF | 20.05 | 20.1 | 20.0 | 20.02 | 64600.0 |
| 2005-10-10 | CHIC | ETF | 15.81 | 16.0 | 15.26 | 15.34 | 523960.0 |
| 2005-10-10 | CHIR | ETF | 43.29 | 43.56 | 43.0599 | 43.08 | 1937716.0 |
| 2005-10-10 | CHY | ETF | 16.25 | 16.31 | 16.18 | 16.22 | 64400.0 |
| 2005-10-10 | CIL | ETF | 25.9 | 25.91 | 25.9 | 25.91 | 1500.0 |
| 2005-10-10 | CIZ | ETF | 21.75 | 21.75 | 21.75 | 21.75 | 1000.0 |
| 2005-10-10 | CN | ETF | 32.68 | 32.78 | 32.651 | 32.73 | 5100.0 |
| 2005-10-10 | CNXT | ETF | 1.85 | 1.86 | 1.78 | 1.78 | 8496893.0 |
| 2005-10-10 | COMB | ETF | 8.16 | 8.16 | 8.16 | 8.16 | 400.0 |
| 2005-10-10 | CPI | ETF | 24.1 | 24.1 | 24.1 | 24.1 | 200.0 |
| 2005-10-10 | CPST | ETF | 3.275 | 3.33 | 2.66 | 2.69 | 11938485.0 |
| 2005-10-10 | CSB | ETF | 29.6 | 29.79 | 29.55 | 29.58 | 7200.0 |
| 2005-10-10 | CSM | ETF | 2.4375 | 2.4375 | 2.4375 | 2.4375 | 800.0 |
| 2005-10-10 | CSQ | ETF | 13.83 | 13.85 | 13.71 | 13.75 | 151000.0 |
| 2005-10-10 | CTEC | ETF | 48.89999999999999 | 48.89999999999999 | 48.3 | 48.3 | 1238.6000000000001 |
| 2005-10-10 | CURE | ETF | 0.0975 | 0.1025 | 0.095 | 0.0988 | 853200.0 |
| 2005-10-10 | CYA | ETF | 70.2 | 72.0 | 65.4 | 72.0 | 485.0 |
| 2005-10-10 | CYB | ETF | 3.3 | 3.39 | 3.3 | 3.31 | 7400.0 |
| 2005-10-10 | DGT | ETF | 63.75 | 63.75 | 63.47 | 63.47 | 16800.0 |
| 2005-10-10 | DIG | ETF | 14.6875 | 14.6875 | 14.6875 | 14.6875 | 960.0 |
| 2005-10-10 | DIV | ETF | 12.74 | 12.85 | 12.6 | 12.61 | 20500.0 |
> showing 50 of 279 rows — these rows as CSV