PREVIEW / etf_daily / 2005-10-25
file: by_date/etf_daily/2005/2005-10-25.parquet size: 15 KB rows: 275
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-25 | SPY | ETF | 119.72 | 120.24 | 118.94 | 119.72 | 76594500.0 |
| 2005-10-25 | QQQ | ETF | 39.08 | 39.1901 | 38.77 | 39.01 | 86963965.0 |
| 2005-10-25 | IWM | ETF | 64.21 | 64.4 | 63.27 | 63.85 | 31535500.0 |
| 2005-10-25 | DIA | ETF | 103.58 | 104.06 | 103.07 | 103.73 | 6667100.0 |
| 2005-10-25 | GLD | ETF | 46.93 | 47.19 | 46.9 | 47.06 | 3290500.0 |
| 2005-10-25 | TLT | ETF | 90.82 | 91.05 | 89.93 | 89.94 | 632900.0 |
| 2005-10-25 | AAA | ETF | 54.91 | 55.24 | 54.91 | 55.0 | 1800.0 |
| 2005-10-25 | ADRE | ETF | 101.31 | 102.45 | 101.03 | 101.43 | 54512.0 |
| 2005-10-25 | AFK | ETF | 25.47 | 25.54 | 25.43 | 25.54 | 3000.0 |
| 2005-10-25 | AGG | ETF | 100.72 | 100.96 | 100.35 | 100.55 | 481600.0 |
| 2005-10-25 | AIQ | ETF | 35.85 | 36.0 | 34.75 | 35.85 | 12100.0 |
| 2005-10-25 | AIS | ETF | 1.15 | 1.2 | 1.15 | 1.19 | 346200.0 |
| 2005-10-25 | ARB | ETF | 38.85 | 38.95 | 38.03 | 38.19 | 122300.0 |
| 2005-10-25 | BAB | ETF | 52.6 | 53.05 | 52.41 | 52.6 | 48900.0 |
| 2005-10-25 | BBC | ETF | 7.16 | 7.16 | 6.91 | 7.05 | 46400.0 |
| 2005-10-25 | BBH | ETF | 63.2 | 63.88 | 63.1167 | 63.7733 | 1479300.0 |
| 2005-10-25 | BCM | ETF | 60.75 | 60.9 | 60.2 | 60.33 | 18100.0 |
| 2005-10-25 | BIS | ETF | 630.4 | 630.4 | 628.8 | 630.4 | 77.0 |
| 2005-10-25 | BITS | ETF | 10.56 | 11.24 | 10.48 | 10.88 | 1664.0 |
| 2005-10-25 | BKF | ETF | 17.23 | 18.489 | 17.23 | 17.33 | 182000.0 |
| 2005-10-25 | BNE | ETF | 13.63 | 13.71 | 13.01 | 13.56 | 108600.0 |
| 2005-10-25 | BRF | ETF | 15.28 | 15.28 | 15.2 | 15.25 | 10700.0 |
| 2005-10-25 | BTF | ETF | 84.3 | 84.74999999999999 | 84.0 | 84.25 | 4820.0 |
| 2005-10-25 | CBON | ETF | 32.65 | 32.83 | 32.44 | 32.83 | 2848.0 |
| 2005-10-25 | CDL | ETF | 13.79 | 13.79 | 13.41 | 13.54 | 217300.0 |
| 2005-10-25 | CEF | ETF | 5.7 | 5.81 | 5.7 | 5.79 | 451700.0 |
| 2005-10-25 | CEW | ETF | 25.92 | 25.92 | 25.92 | 25.92 | 700.0 |
| 2005-10-25 | CHB | ETF | 13.9 | 14.13 | 13.58 | 13.78 | 342500.0 |
| 2005-10-25 | CHI | ETF | 19.71 | 19.87 | 19.6545 | 19.84 | 82500.0 |
| 2005-10-25 | CHIC | ETF | 17.01 | 17.45 | 16.72 | 17.42 | 270454.0 |
| 2005-10-25 | CHIR | ETF | 44.0001 | 44.1399 | 43.08 | 44.0901 | 1422660.0 |
| 2005-10-25 | CHY | ETF | 15.75 | 15.84 | 15.7436 | 15.81 | 106200.0 |
| 2005-10-25 | CIL | ETF | 25.94 | 26.03 | 25.94 | 26.03 | 600.0 |
| 2005-10-25 | CN | ETF | 31.69 | 31.69 | 31.35 | 31.6 | 34000.0 |
| 2005-10-25 | CNXT | ETF | 1.87 | 1.8903 | 1.81 | 1.82 | 8840314.0 |
| 2005-10-25 | COMB | ETF | 8.25 | 8.25 | 8.25 | 8.25 | 100.0 |
| 2005-10-25 | CPST | ETF | 2.61 | 2.78 | 2.57 | 2.66 | 5857975.0 |
| 2005-10-25 | CSB | ETF | 28.7 | 28.86 | 28.52 | 28.65 | 53900.0 |
| 2005-10-25 | CSQ | ETF | 13.35 | 13.47 | 13.3 | 13.4 | 326200.0 |
| 2005-10-25 | CTEC | ETF | 48.699999999999996 | 49.74999999999999 | 48.699999999999996 | 49.15 | 7481.6 |
| 2005-10-25 | CURE | ETF | 0.1 | 0.1 | 0.0887 | 0.095 | 2570128.0 |
| 2005-10-25 | CYB | ETF | 3.23 | 3.23 | 3.18 | 3.18 | 500.0 |
| 2005-10-25 | DGT | ETF | 63.05 | 63.05 | 62.83 | 63.01 | 600.0 |
| 2005-10-25 | DIG | ETF | 13.975 | 14.125 | 13.975 | 14.125 | 3360.0 |
| 2005-10-25 | DIV | ETF | 11.93 | 12.06 | 11.91 | 12.03 | 27900.0 |
| 2005-10-25 | DRIV | ETF | 37.48 | 38.47 | 37.46 | 38.32 | 554127.0 |
| 2005-10-25 | DSI | ETF | 5.765 | 5.765 | 5.765 | 5.765 | 600.0 |
| 2005-10-25 | DUSA | ETF | 8.85 | 9.18 | 8.84 | 9.04 | 61482.0 |
| 2005-10-25 | DVY | ETF | 60.46 | 60.87 | 60.18 | 60.58 | 481300.0 |
| 2005-10-25 | EDEN | ETF | 0.65 | 0.71 | 0.65 | 0.7 | 33700.0 |
> showing 50 of 275 rows — these rows as CSV