PREVIEW / etf_daily / 2005-11-03
file: by_date/etf_daily/2005/2005-11-03.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-11-03 | SPY | ETF | 122.15 | 122.66 | 121.75 | 122.27 | 84897600.0 |
| 2005-11-03 | QQQ | ETF | 39.74 | 40.0901 | 39.68 | 39.94 | 137053991.0 |
| 2005-11-03 | IWM | ETF | 65.77 | 66.16 | 65.27 | 65.62 | 43129900.0 |
| 2005-11-03 | DIA | ETF | 105.15 | 105.59 | 104.88 | 105.24 | 6455800.0 |
| 2005-11-03 | GLD | ETF | 46.06 | 46.08 | 45.75 | 45.96 | 1703300.0 |
| 2005-11-03 | TLT | ETF | 88.89 | 88.97 | 88.24 | 88.26 | 962900.0 |
| 2005-11-03 | AAA | ETF | 56.47 | 56.83 | 56.2 | 56.45 | 10400.0 |
| 2005-11-03 | ADRE | ETF | 107.84 | 107.84 | 106.545 | 106.83 | 26036.0 |
| 2005-11-03 | AFK | ETF | 25.45 | 25.49 | 25.41 | 25.41 | 4700.0 |
| 2005-11-03 | AGG | ETF | 99.79 | 99.85 | 99.34 | 99.45 | 158100.0 |
| 2005-11-03 | AIQ | ETF | 34.75 | 34.75 | 32.5 | 33.0 | 21040.0 |
| 2005-11-03 | AIS | ETF | 1.17 | 1.18 | 1.11 | 1.13 | 189100.0 |
| 2005-11-03 | ARB | ETF | 37.98 | 38.35 | 37.13 | 37.35 | 208100.0 |
| 2005-11-03 | BAB | ETF | 55.4 | 55.6 | 54.99 | 55.08 | 21700.0 |
| 2005-11-03 | BBC | ETF | 7.03 | 7.45 | 6.91 | 7.01 | 172400.0 |
| 2005-11-03 | BBH | ETF | 65.7667 | 66.6667 | 65.65 | 66.3333 | 1834200.0 |
| 2005-11-03 | BCM | ETF | 62.11 | 62.12 | 61.69 | 61.7 | 12900.0 |
| 2005-11-03 | BITS | ETF | 10.6 | 11.12 | 10.6 | 10.84 | 5826.0 |
| 2005-11-03 | BKF | ETF | 21.6 | 23.0 | 21.6 | 22.5 | 176200.0 |
| 2005-11-03 | BNE | ETF | 14.64 | 14.71 | 14.47 | 14.48 | 282600.0 |
| 2005-11-03 | BRF | ETF | 15.3 | 15.3 | 15.24 | 15.24 | 7400.0 |
| 2005-11-03 | BTF | ETF | 85.0 | 85.7 | 85.0 | 85.5 | 7240.0 |
| 2005-11-03 | CBON | ETF | 33.18 | 33.18 | 32.9 | 33.09 | 3434.0 |
| 2005-11-03 | CDL | ETF | 13.76 | 14.0 | 13.72 | 14.0 | 286200.0 |
| 2005-11-03 | CEF | ETF | 5.7 | 5.7 | 5.66 | 5.68 | 223600.0 |
| 2005-11-03 | CEW | ETF | 25.9 | 26.0 | 25.9 | 25.98 | 700.0 |
| 2005-11-03 | CGO | ETF | 15.0 | 15.01 | 15.0 | 15.0 | 14300.0 |
| 2005-11-03 | CHB | ETF | 14.16 | 14.5 | 13.931 | 14.0 | 494100.0 |
| 2005-11-03 | CHI | ETF | 20.0 | 20.23 | 19.98 | 20.21 | 93800.0 |
| 2005-11-03 | CHIC | ETF | 18.66 | 19.05 | 17.0 | 17.4 | 723890.0 |
| 2005-11-03 | CHIR | ETF | 44.1999 | 44.2899 | 44.1999 | 44.25 | 2990521.0 |
| 2005-11-03 | CHY | ETF | 15.75 | 15.85 | 15.71 | 15.81 | 117900.0 |
| 2005-11-03 | CIZ | ETF | 21.5 | 21.5 | 21.5 | 21.5 | 200.0 |
| 2005-11-03 | CN | ETF | 33.85 | 34.5 | 33.75 | 34.2 | 19500.0 |
| 2005-11-03 | CNXT | ETF | 2.24 | 2.34 | 2.21 | 2.23 | 24808657.0 |
| 2005-11-03 | CPST | ETF | 2.85 | 2.87 | 2.68 | 2.69 | 3544119.0 |
| 2005-11-03 | CSA | ETF | 17.09 | 17.29 | 17.08 | 17.13 | 13600.0 |
| 2005-11-03 | CSB | ETF | 29.54 | 29.54 | 28.93 | 28.93 | 6400.0 |
| 2005-11-03 | CSQ | ETF | 13.49 | 13.59 | 13.45 | 13.47 | 291800.0 |
| 2005-11-03 | CTEC | ETF | 42.99999999999999 | 43.3 | 42.69499999999999 | 42.949999999999996 | 18786.8 |
| 2005-11-03 | CURE | ETF | 0.0688 | 0.0725 | 0.0625 | 0.0675 | 2213328.0 |
| 2005-11-03 | CYB | ETF | 3.19 | 3.25 | 3.19 | 3.25 | 2700.0 |
| 2005-11-03 | DGT | ETF | 64.49 | 64.73 | 64.49 | 64.49 | 3500.0 |
| 2005-11-03 | DIG | ETF | 13.75 | 13.7625 | 13.75 | 13.7625 | 2800.0 |
| 2005-11-03 | DIV | ETF | 12.3 | 12.32 | 12.06 | 12.06 | 32700.0 |
| 2005-11-03 | DRIV | ETF | 27.21 | 28.33 | 27.17 | 27.88 | 1983128.0 |
| 2005-11-03 | DSI | ETF | 5.84 | 5.84 | 5.835 | 5.835 | 8000.0 |
| 2005-11-03 | DUSA | ETF | 9.6 | 9.6 | 9.14 | 9.26 | 127889.0 |
| 2005-11-03 | DVY | ETF | 62.54 | 62.54 | 61.1 | 61.28 | 3056300.0 |
| 2005-11-03 | EDEN | ETF | 0.63 | 0.6601 | 0.62 | 0.66 | 38400.0 |
> showing 50 of 282 rows — these rows as CSV