PREVIEW / etf_daily / 2005-12-21
file: by_date/etf_daily/2005/2005-12-21.parquet size: 16 KB rows: 293
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-12-21 | SPY | ETF | 126.22 | 126.76 | 125.8 | 126.03 | 51806900.0 |
| 2005-12-21 | QQQ | ETF | 41.02 | 41.41 | 40.95 | 41.13 | 68934959.0 |
| 2005-12-21 | IWM | ETF | 67.13 | 67.98 | 67.08 | 67.79 | 30167400.0 |
| 2005-12-21 | DIA | ETF | 108.08 | 108.84 | 107.99 | 108.15 | 5923100.0 |
| 2005-12-21 | GLD | ETF | 49.12 | 49.45 | 48.8 | 49.37 | 3956400.0 |
| 2005-12-21 | TLT | ETF | 90.53 | 90.58 | 90.29 | 90.52 | 193100.0 |
| 2005-12-21 | AAA | ETF | 54.19 | 54.24 | 54.19 | 54.24 | 2800.0 |
| 2005-12-21 | ADRE | ETF | 114.99 | 115.82 | 114.573 | 115.63 | 28512.0 |
| 2005-12-21 | AFK | ETF | 25.13 | 25.23 | 25.13 | 25.23 | 8700.0 |
| 2005-12-21 | AGG | ETF | 100.39 | 100.43 | 100.13 | 100.4 | 179400.0 |
| 2005-12-21 | AIQ | ETF | 29.85 | 30.0 | 28.5 | 28.85 | 10080.0 |
| 2005-12-21 | AIS | ETF | 1.35 | 1.43 | 1.35 | 1.41 | 184800.0 |
| 2005-12-21 | AOM | ETF | 4.0 | 4.05 | 3.96 | 4.05 | 10700.0 |
| 2005-12-21 | ARB | ETF | 37.99 | 39.1 | 37.99 | 38.92 | 185000.0 |
| 2005-12-21 | BAB | ETF | 59.64 | 59.64 | 58.56 | 58.88 | 17800.0 |
| 2005-12-21 | BBC | ETF | 13.9 | 14.65 | 13.9 | 14.5 | 250100.0 |
| 2005-12-21 | BBH | ETF | 66.4167 | 67.8 | 66.3767 | 67.62 | 2491800.0 |
| 2005-12-21 | BCM | ETF | 65.82 | 67.34 | 65.82 | 67.32 | 55200.0 |
| 2005-12-21 | BITS | ETF | 12.68 | 13.8 | 12.68 | 13.48 | 3725.0 |
| 2005-12-21 | BKF | ETF | 20.0 | 20.15 | 20.0 | 20.07 | 14500.0 |
| 2005-12-21 | BNE | ETF | 14.73 | 15.16 | 14.73 | 15.01 | 112800.0 |
| 2005-12-21 | BRF | ETF | 15.09 | 15.11 | 15.0 | 15.06 | 15700.0 |
| 2005-12-21 | BTF | ETF | 83.49999999999999 | 84.64999999999999 | 83.39999999999999 | 84.60000000000001 | 1400.0 |
| 2005-12-21 | CBON | ETF | 32.0 | 32.09 | 31.65 | 32.08 | 10520.0 |
| 2005-12-21 | CDL | ETF | 12.88 | 12.98 | 12.83 | 12.93 | 284400.0 |
| 2005-12-21 | CEF | ETF | 6.09 | 6.23 | 6.08 | 6.2 | 306000.0 |
| 2005-12-21 | CGO | ETF | 13.71 | 13.9 | 13.63 | 13.86 | 49500.0 |
| 2005-12-21 | CHB | ETF | 13.78 | 14.34 | 13.78 | 14.31 | 437300.0 |
| 2005-12-21 | CHI | ETF | 19.76 | 20.1 | 19.76 | 20.09 | 103400.0 |
| 2005-12-21 | CHIC | ETF | 19.38 | 19.75 | 19.13 | 19.26 | 172855.0 |
| 2005-12-21 | CHIR | ETF | 44.7201 | 44.8899 | 44.5599 | 44.64 | 1242795.0 |
| 2005-12-21 | CHY | ETF | 15.5 | 15.82 | 15.4601 | 15.77 | 156000.0 |
| 2005-12-21 | CN | ETF | 32.29 | 32.4 | 32.26 | 32.39 | 10500.0 |
| 2005-12-21 | CNXT | ETF | 2.36 | 2.4 | 2.33 | 2.34 | 4691423.0 |
| 2005-12-21 | CPI | ETF | 27.6 | 27.6 | 27.6 | 27.6 | 200.0 |
| 2005-12-21 | CPST | ETF | 3.2 | 3.2 | 3.08 | 3.12 | 1826143.0 |
| 2005-12-21 | CSA | ETF | 16.15 | 16.29 | 16.1 | 16.25 | 17200.0 |
| 2005-12-21 | CSB | ETF | 31.37 | 31.84 | 31.37 | 31.82 | 18200.0 |
| 2005-12-21 | CSM | ETF | 2.45 | 2.45 | 2.45 | 2.45 | 2000.0 |
| 2005-12-21 | CSQ | ETF | 12.94 | 13.09 | 12.93 | 13.06 | 914200.0 |
| 2005-12-21 | CTEC | ETF | 48.25 | 49.0 | 47.75 | 48.3 | 2214.4 |
| 2005-12-21 | CURE | ETF | 0.0375 | 0.0375 | 0.0312 | 0.035 | 9306704.0 |
| 2005-12-21 | CYB | ETF | 3.41 | 3.42 | 3.41 | 3.42 | 200.0 |
| 2005-12-21 | DGT | ETF | 65.65 | 65.66 | 65.31 | 65.4 | 2400.0 |
| 2005-12-21 | DIG | ETF | 15.375 | 15.375 | 15.375 | 15.375 | 1840.0 |
| 2005-12-21 | DIV | ETF | 11.98 | 12.036 | 11.95 | 11.97 | 39500.0 |
| 2005-12-21 | DRIV | ETF | 28.91 | 30.74 | 28.9 | 30.62 | 1519697.0 |
| 2005-12-21 | DSI | ETF | 6.05 | 6.135 | 6.05 | 6.085 | 16400.0 |
| 2005-12-21 | DUSA | ETF | 10.0 | 10.14 | 9.85 | 10.01 | 205449.0 |
| 2005-12-21 | DVY | ETF | 62.5 | 62.87 | 62.36 | 62.51 | 392300.0 |
> showing 50 of 293 rows — these rows as CSV