PREVIEW / etf_daily / 2005-10-26
file: by_date/etf_daily/2005/2005-10-26.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-26 | SPY | ETF | 119.51 | 120.54 | 119.19 | 119.37 | 80855800.0 |
| 2005-10-26 | QQQ | ETF | 38.96 | 39.274 | 38.76 | 38.81 | 90028088.0 |
| 2005-10-26 | IWM | ETF | 63.69 | 64.59 | 63.31 | 63.52 | 34786100.0 |
| 2005-10-26 | DIA | ETF | 103.45 | 104.26 | 103.31 | 103.53 | 7512100.0 |
| 2005-10-26 | GLD | ETF | 47.09 | 47.21 | 46.89 | 46.93 | 2248400.0 |
| 2005-10-26 | TLT | ETF | 89.45 | 89.7 | 89.16 | 89.28 | 2895800.0 |
| 2005-10-26 | AAA | ETF | 55.04 | 55.36 | 55.04 | 55.26 | 1900.0 |
| 2005-10-26 | ADRE | ETF | 101.59 | 102.37 | 101.33 | 101.38 | 45096.0 |
| 2005-10-26 | AFK | ETF | 25.53 | 25.53 | 25.36 | 25.37 | 2800.0 |
| 2005-10-26 | AGG | ETF | 100.38 | 100.4 | 100.03 | 100.15 | 134900.0 |
| 2005-10-26 | AIQ | ETF | 35.35 | 35.75 | 34.5 | 34.65 | 8520.0 |
| 2005-10-26 | AIS | ETF | 1.2 | 1.28 | 1.16 | 1.19 | 552900.0 |
| 2005-10-26 | ARB | ETF | 38.05 | 38.49 | 37.78 | 37.82 | 119900.0 |
| 2005-10-26 | BAB | ETF | 52.44 | 52.79 | 52.24 | 52.57 | 54100.0 |
| 2005-10-26 | BBC | ETF | 6.91 | 7.0 | 6.66 | 6.8 | 64800.0 |
| 2005-10-26 | BBH | ETF | 63.4 | 64.4633 | 63.4 | 63.81 | 1336200.0 |
| 2005-10-26 | BCM | ETF | 60.5 | 61.06 | 60.34 | 60.77 | 9000.0 |
| 2005-10-26 | BITS | ETF | 10.52 | 11.2 | 10.4 | 10.796 | 4262.0 |
| 2005-10-26 | BKF | ETF | 17.13 | 17.18 | 16.15 | 16.67 | 366800.0 |
| 2005-10-26 | BNE | ETF | 13.55 | 13.91 | 13.21 | 13.25 | 95300.0 |
| 2005-10-26 | BRF | ETF | 15.21 | 15.22 | 15.21 | 15.22 | 4100.0 |
| 2005-10-26 | BTF | ETF | 83.8505 | 84.19999999999999 | 83.8505 | 83.85999999999999 | 80.0 |
| 2005-10-26 | CBON | ETF | 32.59 | 32.8 | 32.24 | 32.59 | 10326.0 |
| 2005-10-26 | CDL | ETF | 13.55 | 13.65 | 13.42 | 13.52 | 133100.0 |
| 2005-10-26 | CEF | ETF | 5.75 | 5.81 | 5.74 | 5.79 | 314400.0 |
| 2005-10-26 | CEW | ETF | 25.9 | 25.9 | 25.86 | 25.86 | 1200.0 |
| 2005-10-26 | CHB | ETF | 13.88 | 14.06 | 13.55 | 13.56 | 323100.0 |
| 2005-10-26 | CHI | ETF | 19.86 | 19.92 | 19.75 | 19.9 | 78300.0 |
| 2005-10-26 | CHIC | ETF | 17.32 | 17.42 | 17.09 | 17.18 | 234762.0 |
| 2005-10-26 | CHIR | ETF | 43.3299 | 44.3799 | 43.1001 | 43.38 | 1334561.0 |
| 2005-10-26 | CHY | ETF | 15.82 | 15.83 | 15.65 | 15.74 | 101000.0 |
| 2005-10-26 | CIL | ETF | 25.94 | 25.94 | 25.88 | 25.88 | 1800.0 |
| 2005-10-26 | CN | ETF | 31.46 | 31.5599 | 31.16 | 31.21 | 6200.0 |
| 2005-10-26 | CNXT | ETF | 1.83 | 1.86 | 1.75 | 1.79 | 10966718.0 |
| 2005-10-26 | CPI | ETF | 24.3 | 24.3 | 24.15 | 24.15 | 1000.0 |
| 2005-10-26 | CPST | ETF | 2.66 | 2.7 | 2.44 | 2.47 | 3900489.0 |
| 2005-10-26 | CSB | ETF | 28.62 | 28.77 | 28.52 | 28.6 | 2800.0 |
| 2005-10-26 | CSQ | ETF | 13.4 | 13.43 | 13.33 | 13.38 | 274200.0 |
| 2005-10-26 | CTEC | ETF | 50.0 | 51.5 | 48.25 | 49.15 | 16379.0 |
| 2005-10-26 | CURE | ETF | 0.0925 | 0.095 | 0.0912 | 0.0912 | 3060672.0 |
| 2005-10-26 | CYB | ETF | 3.25 | 3.37 | 3.25 | 3.3699 | 5000.0 |
| 2005-10-26 | DGT | ETF | 63.05 | 63.43 | 63.05 | 63.08 | 4000.0 |
| 2005-10-26 | DIG | ETF | 14.175 | 14.2 | 14.175 | 14.2 | 5760.0 |
| 2005-10-26 | DIV | ETF | 11.95 | 12.05 | 11.95 | 12.0 | 23500.0 |
| 2005-10-26 | DRIV | ETF | 37.75 | 39.39 | 36.78 | 37.48 | 1560631.0 |
| 2005-10-26 | DSI | ETF | 5.79 | 5.79 | 5.79 | 5.79 | 2000.0 |
| 2005-10-26 | DUSA | ETF | 9.02 | 9.29 | 9.02 | 9.06 | 117891.0 |
| 2005-10-26 | DVY | ETF | 60.35 | 60.94 | 60.2 | 60.46 | 523300.0 |
| 2005-10-26 | EDEN | ETF | 0.65 | 0.69 | 0.65 | 0.69 | 7350.0 |
| 2005-10-26 | EDV | ETF | 25.4 | 25.46 | 25.38 | 25.38 | 8100.0 |
> showing 50 of 282 rows — these rows as CSV