PREVIEW / etf_daily / 2005-10-24
file: by_date/etf_daily/2005/2005-10-24.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-24 | SPY | ETF | 118.44 | 120.09 | 118.41 | 119.96 | 71308400.0 |
| 2005-10-24 | QQQ | ETF | 38.712 | 39.181 | 38.467 | 39.16 | 111785120.0 |
| 2005-10-24 | IWM | ETF | 63.15 | 64.4 | 62.92 | 64.4 | 30567800.0 |
| 2005-10-24 | DIA | ETF | 102.54 | 103.84 | 102.44 | 103.75 | 11279400.0 |
| 2005-10-24 | GLD | ETF | 46.39 | 46.73 | 46.31 | 46.39 | 2051300.0 |
| 2005-10-24 | TLT | ETF | 91.32 | 91.41 | 90.49 | 90.72 | 939100.0 |
| 2005-10-24 | AAA | ETF | 54.45 | 54.61 | 54.02 | 54.02 | 4300.0 |
| 2005-10-24 | ADRE | ETF | 101.11 | 102.29 | 100.5 | 102.29 | 224740.0 |
| 2005-10-24 | AFK | ETF | 25.45 | 25.46 | 25.41 | 25.414 | 2600.0 |
| 2005-10-24 | AGG | ETF | 101.07 | 101.11 | 100.73 | 100.85 | 137000.0 |
| 2005-10-24 | AIQ | ETF | 35.9 | 36.75 | 35.6 | 36.35 | 10360.0 |
| 2005-10-24 | AIS | ETF | 1.14 | 1.15 | 1.12 | 1.14 | 138000.0 |
| 2005-10-24 | ARB | ETF | 38.5 | 38.92 | 38.25 | 38.9 | 138500.0 |
| 2005-10-24 | BAB | ETF | 51.9 | 52.96 | 51.87 | 52.92 | 34400.0 |
| 2005-10-24 | BBC | ETF | 6.95 | 7.199 | 6.95 | 7.11 | 53800.0 |
| 2005-10-24 | BBH | ETF | 61.7 | 63.0133 | 61.6367 | 62.9967 | 1868400.0 |
| 2005-10-24 | BCM | ETF | 59.61 | 60.07 | 59.4 | 60.06 | 16500.0 |
| 2005-10-24 | BIS | ETF | 638.4 | 638.4 | 638.4 | 638.4 | 15.6 |
| 2005-10-24 | BITS | ETF | 10.4 | 11.2 | 10.4 | 10.6 | 4633.0 |
| 2005-10-24 | BKF | ETF | 16.95 | 17.33 | 16.8901 | 17.29 | 187500.0 |
| 2005-10-24 | BNE | ETF | 13.05 | 13.73 | 13.0 | 13.73 | 116300.0 |
| 2005-10-24 | BRF | ETF | 15.3 | 15.4 | 15.25 | 15.25 | 15900.0 |
| 2005-10-24 | BTF | ETF | 84.60000000000001 | 85.0 | 84.55 | 84.64999999999999 | 360.0 |
| 2005-10-24 | CBON | ETF | 32.83 | 33.15 | 32.68 | 33.0 | 15763.0 |
| 2005-10-24 | CDL | ETF | 13.64 | 13.88 | 13.62 | 13.79 | 210900.0 |
| 2005-10-24 | CEF | ETF | 5.73 | 5.76 | 5.64 | 5.66 | 321500.0 |
| 2005-10-24 | CEW | ETF | 25.9 | 25.92 | 25.9 | 25.92 | 400.0 |
| 2005-10-24 | CHB | ETF | 13.75 | 14.05 | 13.66 | 14.05 | 363300.0 |
| 2005-10-24 | CHI | ETF | 19.3 | 19.69 | 19.3 | 19.66 | 102200.0 |
| 2005-10-24 | CHIC | ETF | 17.34 | 17.34 | 16.56 | 17.13 | 326315.0 |
| 2005-10-24 | CHIR | ETF | 43.1601 | 44.3901 | 43.0299 | 43.95 | 1519603.0 |
| 2005-10-24 | CHY | ETF | 15.64 | 15.84 | 15.64 | 15.8 | 82400.0 |
| 2005-10-24 | CIL | ETF | 26.0 | 26.0 | 26.0 | 26.0 | 200.0 |
| 2005-10-24 | CIZ | ETF | 21.6 | 21.6 | 21.6 | 21.6 | 100.0 |
| 2005-10-24 | CN | ETF | 31.2 | 31.8 | 31.2 | 31.69 | 10600.0 |
| 2005-10-24 | CNXT | ETF | 1.97 | 1.97 | 1.88 | 1.9 | 6876535.0 |
| 2005-10-24 | COMB | ETF | 8.25 | 8.25 | 8.2 | 8.2 | 10700.0 |
| 2005-10-24 | CPST | ETF | 2.65 | 2.73 | 2.52 | 2.55 | 7338470.0 |
| 2005-10-24 | CSB | ETF | 28.58 | 28.86 | 28.58 | 28.86 | 5500.0 |
| 2005-10-24 | CSQ | ETF | 13.25 | 13.5 | 13.22 | 13.45 | 309300.0 |
| 2005-10-24 | CTEC | ETF | 48.2 | 49.4 | 48.2 | 49.4 | 10647.400000000001 |
| 2005-10-24 | CURE | ETF | 0.0988 | 0.1025 | 0.0925 | 0.0963 | 2254128.0 |
| 2005-10-24 | CYB | ETF | 3.18 | 3.2199 | 3.18 | 3.2199 | 200.0 |
| 2005-10-24 | DGT | ETF | 62.6 | 62.83 | 62.6 | 62.83 | 800.0 |
| 2005-10-24 | DIG | ETF | 13.8 | 13.8125 | 13.8 | 13.8125 | 2080.0 |
| 2005-10-24 | DIV | ETF | 11.9 | 12.04 | 11.9 | 11.96 | 20400.0 |
| 2005-10-24 | DRIV | ETF | 37.26 | 37.86 | 36.8 | 37.85 | 611149.0 |
| 2005-10-24 | DSI | ETF | 5.775 | 5.775 | 5.775 | 5.775 | 5000.0 |
| 2005-10-24 | DUSA | ETF | 8.88 | 8.9 | 8.67 | 8.89 | 98858.0 |
| 2005-10-24 | DVY | ETF | 59.97 | 60.64 | 59.85 | 60.64 | 618400.0 |
> showing 50 of 279 rows — these rows as CSV