PREVIEW / etf_daily / 2005-12-22
file: by_date/etf_daily/2005/2005-12-22.parquet size: 16 KB rows: 295
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-22 | SPY | ETF | 126.31 | 126.69 | 126.08 | 126.69 | 32247900.0 |
| 2005-12-22 | QQQ | ETF | 41.11 | 41.462 | 40.98 | 41.397 | 59156975.0 |
| 2005-12-22 | IWM | ETF | 67.75 | 68.01 | 67.39 | 67.97 | 20624100.0 |
| 2005-12-22 | DIA | ETF | 108.36 | 108.75 | 108.16 | 108.71 | 4253800.0 |
| 2005-12-22 | GLD | ETF | 49.51 | 50.3 | 49.47 | 50.14 | 2965300.0 |
| 2005-12-22 | TLT | ETF | 90.92 | 91.31 | 90.91 | 91.24 | 692700.0 |
| 2005-12-22 | AAA | ETF | 54.57 | 54.81 | 54.4 | 54.72 | 3000.0 |
| 2005-12-22 | ADRE | ETF | 116.19 | 116.19 | 115.47 | 115.71 | 23140.0 |
| 2005-12-22 | AFK | ETF | 25.22 | 25.27 | 25.1201 | 25.26 | 15100.0 |
| 2005-12-22 | AGG | ETF | 100.5 | 100.64 | 100.4 | 100.62 | 171200.0 |
| 2005-12-22 | AIQ | ETF | 28.35 | 29.95 | 28.3 | 29.3 | 7440.0 |
| 2005-12-22 | AIS | ETF | 1.37 | 1.45 | 1.37 | 1.41 | 150700.0 |
| 2005-12-22 | AOM | ETF | 4.05 | 4.08 | 3.75 | 3.95 | 86300.0 |
| 2005-12-22 | ARB | ETF | 38.85 | 39.13 | 38.74 | 38.85 | 150800.0 |
| 2005-12-22 | BAB | ETF | 58.33 | 58.52 | 58.24 | 58.4 | 13400.0 |
| 2005-12-22 | BBC | ETF | 14.63 | 15.22 | 14.56 | 15.0 | 278700.0 |
| 2005-12-22 | BBH | ETF | 67.6667 | 68.4767 | 67.6333 | 68.4533 | 1288200.0 |
| 2005-12-22 | BCM | ETF | 67.0 | 67.41 | 66.81 | 67.0 | 257500.0 |
| 2005-12-22 | BITS | ETF | 12.844 | 14.4 | 12.844 | 14.28 | 11310.0 |
| 2005-12-22 | BKF | ETF | 20.07 | 20.19 | 20.0 | 20.19 | 14800.0 |
| 2005-12-22 | BNE | ETF | 15.05 | 15.25 | 14.95 | 15.02 | 103200.0 |
| 2005-12-22 | BRF | ETF | 15.06 | 15.06 | 15.01 | 15.06 | 6700.0 |
| 2005-12-22 | BTF | ETF | 84.74999999999999 | 85.0 | 84.74999999999999 | 85.0 | 1420.0 |
| 2005-12-22 | CBON | ETF | 31.9 | 32.4 | 31.9 | 32.28 | 10064.0 |
| 2005-12-22 | CDL | ETF | 12.94 | 12.95 | 12.81 | 12.93 | 334100.0 |
| 2005-12-22 | CEF | ETF | 6.21 | 6.33 | 6.21 | 6.31 | 346100.0 |
| 2005-12-22 | CEW | ETF | 25.98 | 26.01 | 25.98 | 26.01 | 400.0 |
| 2005-12-22 | CGO | ETF | 13.9 | 13.9 | 13.62 | 13.9 | 52000.0 |
| 2005-12-22 | CHB | ETF | 14.31 | 14.46 | 14.15 | 14.21 | 300000.0 |
| 2005-12-22 | CHI | ETF | 20.1 | 20.32 | 19.98 | 20.26 | 76500.0 |
| 2005-12-22 | CHIC | ETF | 19.32 | 19.49 | 19.0 | 19.47 | 183626.0 |
| 2005-12-22 | CHIR | ETF | 44.5599 | 44.7999 | 44.5599 | 44.7501 | 588070.0 |
| 2005-12-22 | CHY | ETF | 15.82 | 15.85 | 15.73 | 15.81 | 102500.0 |
| 2005-12-22 | CIL | ETF | 25.25 | 25.25 | 25.25 | 25.25 | 1900.0 |
| 2005-12-22 | CIZ | ETF | 21.7 | 21.7 | 21.7 | 21.7 | 200.0 |
| 2005-12-22 | CN | ETF | 33.4 | 33.4 | 32.51 | 32.74 | 70600.0 |
| 2005-12-22 | CNXT | ETF | 2.35 | 2.39 | 2.33 | 2.37 | 5686100.0 |
| 2005-12-22 | COMB | ETF | 8.0 | 8.11 | 8.0 | 8.11 | 1000.0 |
| 2005-12-22 | CPST | ETF | 3.1 | 3.18 | 3.01 | 3.04 | 2243307.0 |
| 2005-12-22 | CSA | ETF | 16.2 | 16.86 | 16.1 | 16.8 | 50900.0 |
| 2005-12-22 | CSB | ETF | 31.52 | 31.59 | 31.43 | 31.48 | 15200.0 |
| 2005-12-22 | CSM | ETF | 2.4525 | 2.4525 | 2.45 | 2.45 | 4000.0 |
| 2005-12-22 | CSQ | ETF | 13.09 | 13.36 | 13.08 | 13.32 | 972400.0 |
| 2005-12-22 | CTEC | ETF | 47.85 | 48.8 | 47.75 | 48.3 | 6899.0 |
| 2005-12-22 | CURE | ETF | 0.0312 | 0.0413 | 0.0312 | 0.0413 | 15096680.0 |
| 2005-12-22 | CYB | ETF | 3.3601 | 3.52 | 3.36 | 3.52 | 9600.0 |
| 2005-12-22 | DGT | ETF | 65.65 | 65.65 | 65.4 | 65.51 | 500.0 |
| 2005-12-22 | DIG | ETF | 15.625 | 15.625 | 15.625 | 15.625 | 1200.0 |
| 2005-12-22 | DIV | ETF | 11.96 | 11.98 | 11.94 | 11.98 | 48300.0 |
| 2005-12-22 | DRIV | ETF | 30.57 | 31.22 | 29.91 | 30.93 | 874204.0 |
> showing 50 of 295 rows — these rows as CSV