PREVIEW / etf_daily / 2005-12-15
file: by_date/etf_daily/2005/2005-12-15.parquet size: 15 KB rows: 289
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-15 | SPY | ETF | 127.84 | 128.0 | 127.18 | 127.44 | 55900300.0 |
| 2005-12-15 | QQQ | ETF | 42.0 | 42.07 | 41.608 | 41.97 | 72678244.0 |
| 2005-12-15 | IWM | ETF | 68.82 | 68.82 | 67.73 | 68.08 | 31912800.0 |
| 2005-12-15 | DIA | ETF | 109.0 | 109.5 | 108.7 | 108.77 | 8461600.0 |
| 2005-12-15 | GLD | ETF | 50.48 | 50.79 | 50.11 | 50.24 | 4728500.0 |
| 2005-12-15 | TLT | ETF | 90.44 | 90.44 | 89.99 | 90.4 | 724300.0 |
| 2005-12-15 | AAA | ETF | 55.37 | 55.38 | 54.9 | 54.93 | 7600.0 |
| 2005-12-15 | ADRE | ETF | 115.22 | 116.0 | 114.65 | 114.78 | 28112.0 |
| 2005-12-15 | AFK | ETF | 25.35 | 25.35 | 25.14 | 25.28 | 8100.0 |
| 2005-12-15 | AGG | ETF | 100.4 | 100.44 | 100.01 | 100.3 | 300500.0 |
| 2005-12-15 | AIQ | ETF | 26.95 | 28.95 | 26.75 | 28.1 | 18480.0 |
| 2005-12-15 | AIS | ETF | 1.35 | 1.45 | 1.35 | 1.3999 | 92500.0 |
| 2005-12-15 | AOM | ETF | 3.9 | 4.05 | 3.9 | 3.95 | 19800.0 |
| 2005-12-15 | ARB | ETF | 40.05 | 40.09 | 39.0 | 39.14 | 150400.0 |
| 2005-12-15 | BAB | ETF | 59.99 | 60.08 | 59.62 | 59.87 | 19700.0 |
| 2005-12-15 | BBC | ETF | 14.4 | 14.69 | 13.6 | 14.26 | 536600.0 |
| 2005-12-15 | BBH | ETF | 67.9967 | 67.9967 | 67.0633 | 67.76 | 1197600.0 |
| 2005-12-15 | BCM | ETF | 64.91 | 65.12 | 64.52 | 64.53 | 18400.0 |
| 2005-12-15 | BITS | ETF | 13.24 | 13.32 | 12.956 | 13.24 | 3254.0 |
| 2005-12-15 | BKF | ETF | 20.1 | 20.75 | 20.0 | 20.17 | 80700.0 |
| 2005-12-15 | BNE | ETF | 14.78 | 14.8 | 14.55 | 14.56 | 117100.0 |
| 2005-12-15 | BRF | ETF | 15.1 | 15.29 | 15.1 | 15.15 | 15700.0 |
| 2005-12-15 | BTF | ETF | 87.6 | 88.69949999999999 | 87.5505 | 88.1 | 1120.0 |
| 2005-12-15 | CBON | ETF | 31.75 | 31.98 | 31.65 | 31.96 | 11378.0 |
| 2005-12-15 | CDL | ETF | 13.35 | 13.35 | 13.06 | 13.23 | 493400.0 |
| 2005-12-15 | CEF | ETF | 6.19 | 6.29 | 6.16 | 6.21 | 579400.0 |
| 2005-12-15 | CEW | ETF | 26.0 | 26.0 | 26.0 | 26.0 | 1000.0 |
| 2005-12-15 | CGO | ETF | 13.3 | 13.5 | 13.21 | 13.32 | 64300.0 |
| 2005-12-15 | CHB | ETF | 14.87 | 15.08 | 14.47 | 14.55 | 463700.0 |
| 2005-12-15 | CHI | ETF | 20.45 | 20.5 | 20.2 | 20.2 | 72300.0 |
| 2005-12-15 | CHIC | ETF | 19.94 | 19.99 | 19.26 | 19.42 | 189681.0 |
| 2005-12-15 | CHIR | ETF | 44.7 | 44.7099 | 44.6199 | 44.7 | 1739610.0 |
| 2005-12-15 | CHY | ETF | 15.85 | 15.85 | 15.76 | 15.77 | 83100.0 |
| 2005-12-15 | CIL | ETF | 25.23 | 25.23 | 25.23 | 25.23 | 200.0 |
| 2005-12-15 | CN | ETF | 32.75 | 33.09 | 32.7 | 33.09 | 6600.0 |
| 2005-12-15 | CNXT | ETF | 2.35 | 2.43 | 2.31 | 2.42 | 22353273.0 |
| 2005-12-15 | CPST | ETF | 3.515 | 3.54 | 3.23 | 3.27 | 4446877.0 |
| 2005-12-15 | CSA | ETF | 16.0 | 16.2 | 16.0 | 16.1 | 38200.0 |
| 2005-12-15 | CSB | ETF | 31.33 | 31.36 | 31.01 | 31.19 | 7600.0 |
| 2005-12-15 | CSM | ETF | 2.4475 | 2.45 | 2.4475 | 2.45 | 2400.0 |
| 2005-12-15 | CSQ | ETF | 12.88 | 13.01 | 12.85 | 12.98 | 656800.0 |
| 2005-12-15 | CTEC | ETF | 50.099999999999994 | 51.55 | 49.699999999999996 | 50.99999999999999 | 4887.2 |
| 2005-12-15 | CURE | ETF | 0.02 | 0.0213 | 0.0187 | 0.0187 | 1603472.0 |
| 2005-12-15 | CYB | ETF | 3.49 | 3.55 | 3.4 | 3.5 | 4700.0 |
| 2005-12-15 | DGT | ETF | 66.0 | 66.1 | 65.88 | 65.88 | 2700.0 |
| 2005-12-15 | DIV | ETF | 11.96 | 12.01 | 11.94 | 11.95 | 40000.0 |
| 2005-12-15 | DRIV | ETF | 29.7 | 29.7 | 29.12 | 29.37 | 569813.0 |
| 2005-12-15 | DSI | ETF | 6.09 | 6.09 | 6.06 | 6.06 | 4000.0 |
| 2005-12-15 | DUSA | ETF | 9.72 | 9.75 | 9.51 | 9.62 | 142816.0 |
| 2005-12-15 | DVY | ETF | 63.0 | 63.11 | 62.77 | 62.9 | 434100.0 |
> showing 50 of 289 rows — these rows as CSV