PREVIEW / etf_daily / 2005-10-17
file: by_date/etf_daily/2005/2005-10-17.parquet size: 15 KB rows: 280
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-17 | SPY | ETF | 118.8 | 119.27 | 118.45 | 119.11 | 68109300.0 |
| 2005-10-17 | QQQ | ETF | 38.056 | 38.19 | 37.82 | 38.18 | 64214160.0 |
| 2005-10-17 | IWM | ETF | 62.86 | 63.33 | 62.23 | 63.02 | 32203400.0 |
| 2005-10-17 | DIA | ETF | 103.07 | 103.64 | 102.94 | 103.5 | 10068700.0 |
| 2005-10-17 | GLD | ETF | 47.26 | 47.37 | 47.19 | 47.26 | 1784300.0 |
| 2005-10-17 | TLT | ETF | 90.42 | 90.61 | 90.12 | 90.21 | 1058200.0 |
| 2005-10-17 | AAA | ETF | 54.65 | 54.74 | 54.45 | 54.67 | 600.0 |
| 2005-10-17 | ADRE | ETF | 100.5 | 101.8705 | 100.5 | 101.85 | 14892.0 |
| 2005-10-17 | AFK | ETF | 25.6 | 25.65 | 25.4001 | 25.58 | 2300.0 |
| 2005-10-17 | AGG | ETF | 100.76 | 100.8 | 100.54 | 100.66 | 94600.0 |
| 2005-10-17 | AIQ | ETF | 34.95 | 36.45 | 33.6 | 36.4 | 20700.0 |
| 2005-10-17 | AIS | ETF | 1.0 | 1.05 | 0.95 | 1.05 | 175000.0 |
| 2005-10-17 | ARB | ETF | 38.05 | 38.56 | 37.93 | 38.5 | 79700.0 |
| 2005-10-17 | BAB | ETF | 52.4 | 52.93 | 52.4 | 52.9 | 28200.0 |
| 2005-10-17 | BBC | ETF | 7.4 | 7.6 | 7.25 | 7.6 | 73600.0 |
| 2005-10-17 | BBH | ETF | 62.1 | 62.2367 | 61.37 | 61.9633 | 2376600.0 |
| 2005-10-17 | BCM | ETF | 60.33 | 60.44 | 59.93 | 60.27 | 12100.0 |
| 2005-10-17 | BIS | ETF | 620.8 | 632.0 | 620.8 | 632.0 | 25.0 |
| 2005-10-17 | BITS | ETF | 10.24 | 10.8 | 10.0 | 10.72 | 2700.0 |
| 2005-10-17 | BKF | ETF | 25.25 | 25.45 | 24.5 | 24.75 | 56200.0 |
| 2005-10-17 | BNE | ETF | 13.89 | 13.89 | 13.25 | 13.45 | 120700.0 |
| 2005-10-17 | BOSS | ETF | 28.69 | 28.69 | 28.51 | 28.51 | 100.0 |
| 2005-10-17 | BRF | ETF | 15.3 | 15.37 | 15.28 | 15.37 | 8700.0 |
| 2005-10-17 | BTF | ETF | 85.7995 | 85.7995 | 85.5005 | 85.7 | 600.0 |
| 2005-10-17 | CBON | ETF | 30.75 | 31.42 | 30.51 | 30.64 | 22738.0 |
| 2005-10-17 | CDL | ETF | 13.9 | 14.0 | 13.74 | 13.8 | 442100.0 |
| 2005-10-17 | CEF | ETF | 5.74 | 5.82 | 5.74 | 5.75 | 276400.0 |
| 2005-10-17 | CHB | ETF | 12.85 | 13.25 | 12.61 | 12.96 | 472000.0 |
| 2005-10-17 | CHI | ETF | 18.92 | 19.14 | 18.92 | 19.12 | 88800.0 |
| 2005-10-17 | CHIC | ETF | 17.2 | 17.58 | 17.13 | 17.31 | 855786.0 |
| 2005-10-17 | CHIR | ETF | 43.3599 | 43.6899 | 43.1799 | 43.2999 | 1059721.0 |
| 2005-10-17 | CHY | ETF | 15.5 | 15.64 | 15.45 | 15.6 | 97700.0 |
| 2005-10-17 | CIL | ETF | 26.12 | 26.12 | 26.12 | 26.12 | 1000.0 |
| 2005-10-17 | CN | ETF | 30.81 | 30.99 | 30.6701 | 30.96 | 14400.0 |
| 2005-10-17 | CNXT | ETF | 1.8 | 1.8501 | 1.79 | 1.82 | 3263506.0 |
| 2005-10-17 | COMB | ETF | 7.901 | 8.16 | 7.9 | 8.16 | 2400.0 |
| 2005-10-17 | CPST | ETF | 2.4 | 2.57 | 2.3 | 2.39 | 8892981.0 |
| 2005-10-17 | CSB | ETF | 28.96 | 29.11 | 28.9 | 29.05 | 6000.0 |
| 2005-10-17 | CSQ | ETF | 13.6 | 13.67 | 13.51 | 13.59 | 200600.0 |
| 2005-10-17 | CTEC | ETF | 45.75 | 47.24999999999999 | 45.75 | 46.8 | 2760.0 |
| 2005-10-17 | CURE | ETF | 0.1 | 0.1037 | 0.0975 | 0.1025 | 1313272.0 |
| 2005-10-17 | CYB | ETF | 3.31 | 3.31 | 3.31 | 3.31 | 300.0 |
| 2005-10-17 | DGT | ETF | 63.65 | 63.65 | 63.25 | 63.43 | 2200.0 |
| 2005-10-17 | DIV | ETF | 11.97 | 12.09 | 11.97 | 12.02 | 16300.0 |
| 2005-10-17 | DRIV | ETF | 35.28 | 36.36 | 35.01 | 36.28 | 1225705.0 |
| 2005-10-17 | DSI | ETF | 5.68 | 5.68 | 5.68 | 5.68 | 2000.0 |
| 2005-10-17 | DUSA | ETF | 9.35 | 9.46 | 8.81 | 8.98 | 186341.0 |
| 2005-10-17 | DVY | ETF | 60.15 | 60.2 | 59.7 | 60.03 | 511600.0 |
| 2005-10-17 | EDEN | ETF | 0.73 | 0.73 | 0.67 | 0.72 | 7200.0 |
| 2005-10-17 | EDV | ETF | 25.47 | 25.62 | 25.47 | 25.55 | 6300.0 |
> showing 50 of 280 rows — these rows as CSV