PREVIEW / etf_daily / 2005-01-28
file: by_date/etf_daily/2005/2005-01-28.parquet size: 14 KB rows: 251
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-01-28 | SPY | ETF | 117.49 | 117.55 | 116.61 | 117.43 | 60738900.0 |
| 2005-01-28 | QQQ | ETF | 37.22 | 37.27 | 36.62 | 36.92 | 111793283.0 |
| 2005-01-28 | IWM | ETF | 61.65 | 61.65 | 60.685 | 61.4 | 20704200.0 |
| 2005-01-28 | DIA | ETF | 104.54 | 104.65 | 103.76 | 104.44 | 7791600.0 |
| 2005-01-28 | GLD | ETF | 42.71 | 42.73 | 42.43 | 42.69 | 1149100.0 |
| 2005-01-28 | TLT | ETF | 91.22 | 91.6 | 91.17 | 91.45 | 1128000.0 |
| 2005-01-28 | AAA | ETF | 58.31 | 59.4 | 58.31 | 58.65 | 3300.0 |
| 2005-01-28 | ADRE | ETF | 82.0 | 82.0 | 80.69 | 81.16 | 3340.0 |
| 2005-01-28 | AFK | ETF | 26.46 | 26.46 | 26.36 | 26.4 | 14600.0 |
| 2005-01-28 | AGG | ETF | 102.89 | 103.03 | 102.76 | 103.03 | 79400.0 |
| 2005-01-28 | AIQ | ETF | 64.8 | 66.2 | 63.4 | 64.6 | 47320.0 |
| 2005-01-28 | ARB | ETF | 40.3 | 40.79 | 40.0 | 40.1 | 175100.0 |
| 2005-01-28 | BAB | ETF | 49.0 | 49.5 | 48.88 | 49.08 | 32600.0 |
| 2005-01-28 | BBH | ETF | 47.85 | 47.9033 | 46.7333 | 47.14 | 3573000.0 |
| 2005-01-28 | BCM | ETF | 55.58 | 55.59 | 55.07 | 55.43 | 19200.0 |
| 2005-01-28 | BIS | ETF | 904.0 | 952.0 | 904.0 | 952.0 | 28.75 |
| 2005-01-28 | BITS | ETF | 8.52 | 8.6 | 8.08 | 8.4 | 24870.0 |
| 2005-01-28 | BKF | ETF | 36.86 | 36.86 | 36.4 | 36.51 | 19700.0 |
| 2005-01-28 | BNE | ETF | 14.4 | 14.47 | 14.15 | 14.21 | 82000.0 |
| 2005-01-28 | BRF | ETF | 15.65 | 15.67 | 15.59 | 15.66 | 13700.0 |
| 2005-01-28 | BTF | ETF | 90.7 | 92.14999999999999 | 90.7 | 91.85 | 4460.0 |
| 2005-01-28 | CBON | ETF | 27.7 | 27.75 | 27.37 | 27.6 | 29887.0 |
| 2005-01-28 | CDC | ETF | 9.5 | 9.61 | 9.5 | 9.61 | 2700.0 |
| 2005-01-28 | CDL | ETF | 13.93 | 13.96 | 13.79 | 13.96 | 314100.0 |
| 2005-01-28 | CEF | ETF | 5.28 | 5.34 | 5.23 | 5.31 | 201200.0 |
| 2005-01-28 | CEW | ETF | 27.62 | 27.65 | 27.62 | 27.65 | 3100.0 |
| 2005-01-28 | CGW | ETF | 27.4 | 27.6 | 27.4 | 27.6 | 200.0 |
| 2005-01-28 | CHB | ETF | 10.69 | 10.69 | 10.25 | 10.35 | 311700.0 |
| 2005-01-28 | CHIC | ETF | 10.47 | 10.56 | 10.25 | 10.37 | 481883.0 |
| 2005-01-28 | CHIR | ETF | 33.63 | 33.63 | 32.28 | 32.91 | 3189057.0 |
| 2005-01-28 | CID | ETF | 8.97 | 8.97 | 8.77 | 8.95 | 9000.0 |
| 2005-01-28 | CIL | ETF | 26.15 | 26.3 | 26.15 | 26.3 | 2300.0 |
| 2005-01-28 | CN | ETF | 28.4 | 28.4 | 28.0 | 28.1 | 128200.0 |
| 2005-01-28 | CNXT | ETF | 1.68 | 1.69 | 1.59 | 1.65 | 4748270.0 |
| 2005-01-28 | CPI | ETF | 19.4 | 19.4 | 19.4 | 19.4 | 200.0 |
| 2005-01-28 | CSB | ETF | 35.85 | 35.92 | 35.84 | 35.86 | 2500.0 |
| 2005-01-28 | CSM | ETF | 2.3825 | 2.385 | 2.38 | 2.38 | 11600.0 |
| 2005-01-28 | CTEC | ETF | 61.55 | 65.0 | 61.3 | 64.89999999999999 | 49103.0 |
| 2005-01-28 | CURE | ETF | 0.6038 | 0.615 | 0.6038 | 0.6062 | 555520.0 |
| 2005-01-28 | CYA | ETF | 185.2 | 195.0 | 185.2 | 195.0 | 205.0 |
| 2005-01-28 | CYB | ETF | 4.15 | 4.15 | 3.98 | 4.09 | 5000.0 |
| 2005-01-28 | DGT | ETF | 62.92 | 62.93 | 62.68 | 62.71 | 1600.0 |
| 2005-01-28 | DIV | ETF | 14.22 | 14.26 | 14.18 | 14.19 | 17500.0 |
| 2005-01-28 | DJP | ETF | 26.73 | 26.73 | 26.73 | 26.73 | 100.0 |
| 2005-01-28 | DRIV | ETF | 39.06 | 39.8 | 37.74 | 38.6 | 1427240.0 |
| 2005-01-28 | DSI | ETF | 5.885 | 5.9 | 5.885 | 5.9 | 8600.0 |
| 2005-01-28 | DTH | ETF | 25.35 | 25.39 | 25.35 | 25.35 | 1500.0 |
| 2005-01-28 | DUSA | ETF | 13.44 | 13.66 | 13.08 | 13.57 | 107181.0 |
| 2005-01-28 | DVY | ETF | 59.11 | 59.26 | 58.63 | 58.95 | 586300.0 |
| 2005-01-28 | EDEN | ETF | 1.171 | 1.24 | 1.13 | 1.13 | 29476.0 |
> showing 50 of 251 rows — these rows as CSV