PREVIEW / etf_daily / 2006-02-23
file: by_date/etf_daily/2006/2006-02-23.parquet size: 16 KB rows: 303
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-23 | SPY | ETF | 129.27 | 129.64 | 128.28 | 129.08 | 43423200.0 |
| 2006-02-23 | QQQ | ETF | 41.22 | 41.54 | 41.08 | 41.15 | 66530589.0 |
| 2006-02-23 | IWM | ETF | 72.75 | 73.27 | 72.38 | 72.77 | 38795900.0 |
| 2006-02-23 | DIA | ETF | 111.1 | 111.34 | 110.48 | 110.74 | 9454300.0 |
| 2006-02-23 | GLD | ETF | 55.08 | 55.11 | 54.55 | 54.64 | 2428700.0 |
| 2006-02-23 | TLT | ETF | 91.31 | 91.31 | 90.93 | 91.19 | 288300.0 |
| 2006-02-23 | AAA | ETF | 53.94 | 54.1499 | 53.73 | 54.149 | 1700.0 |
| 2006-02-23 | ADRE | ETF | 128.75 | 129.49 | 128.424 | 129.0 | 18988.0 |
| 2006-02-23 | AFK | ETF | 25.5 | 25.5 | 25.36 | 25.36 | 10800.0 |
| 2006-02-23 | AGG | ETF | 100.34 | 100.34 | 100.04 | 100.24 | 157900.0 |
| 2006-02-23 | AIQ | ETF | 25.3 | 25.55 | 24.4 | 25.35 | 31680.0 |
| 2006-02-23 | AIS | ETF | 1.49 | 1.5 | 1.46 | 1.48 | 292900.0 |
| 2006-02-23 | AOM | ETF | 6.18 | 6.79 | 6.0805 | 6.42 | 296200.0 |
| 2006-02-23 | ARB | ETF | 38.9 | 38.9 | 38.43 | 38.63 | 163300.0 |
| 2006-02-23 | BAB | ETF | 58.61 | 58.87 | 58.39 | 58.65 | 25100.0 |
| 2006-02-23 | BBC | ETF | 15.6 | 16.65 | 15.5 | 16.37 | 370100.0 |
| 2006-02-23 | BBH | ETF | 65.1167 | 65.3533 | 64.8333 | 65.1 | 378300.0 |
| 2006-02-23 | BCM | ETF | 68.58 | 68.91 | 68.25 | 68.52 | 23600.0 |
| 2006-02-23 | BITS | ETF | 25.52 | 26.0 | 24.64 | 25.48 | 18290.0 |
| 2006-02-23 | BKF | ETF | 13.39 | 13.85 | 13.39 | 13.5 | 77800.0 |
| 2006-02-23 | BNE | ETF | 14.98 | 15.11 | 14.96 | 15.0 | 151300.0 |
| 2006-02-23 | BOSS | ETF | 34.56 | 35.41 | 34.56 | 35.41 | 100.0 |
| 2006-02-23 | BRF | ETF | 15.38 | 15.41 | 15.38 | 15.39 | 2600.0 |
| 2006-02-23 | BTF | ETF | 87.14999999999999 | 87.44999999999999 | 87.14999999999999 | 87.44999999999999 | 200.0 |
| 2006-02-23 | CBON | ETF | 29.8228 | 30.8699 | 29.81 | 30.27 | 14451.0 |
| 2006-02-23 | CDL | ETF | 11.52 | 11.53 | 11.31 | 11.4 | 591300.0 |
| 2006-02-23 | CEF | ETF | 7.58 | 7.6 | 7.48 | 7.49 | 284200.0 |
| 2006-02-23 | CEW | ETF | 26.55 | 26.55 | 26.42 | 26.44 | 1300.0 |
| 2006-02-23 | CFO | ETF | 9.93 | 9.93 | 9.9 | 9.93 | 4500.0 |
| 2006-02-23 | CGO | ETF | 14.45 | 14.45 | 14.12 | 14.3 | 67500.0 |
| 2006-02-23 | CHB | ETF | 15.53 | 15.8 | 15.28 | 15.57 | 612300.0 |
| 2006-02-23 | CHI | ETF | 20.7 | 20.82 | 20.64 | 20.77 | 77300.0 |
| 2006-02-23 | CHIC | ETF | 18.07 | 18.18 | 17.88 | 18.05 | 213189.0 |
| 2006-02-23 | CHIR | ETF | 45.36 | 45.63 | 45.33 | 45.42 | 541242.0 |
| 2006-02-23 | CHY | ETF | 16.31 | 16.4499 | 16.24 | 16.44 | 83700.0 |
| 2006-02-23 | CIL | ETF | 25.51 | 25.51 | 25.51 | 25.51 | 300.0 |
| 2006-02-23 | CN | ETF | 35.69 | 35.69 | 35.35 | 35.43 | 22200.0 |
| 2006-02-23 | CNXT | ETF | 2.83 | 2.93 | 2.83 | 2.91 | 9710649.0 |
| 2006-02-23 | CPI | ETF | 30.25 | 30.49 | 30.25 | 30.49 | 700.0 |
| 2006-02-23 | CPST | ETF | 3.08 | 3.18 | 3.05 | 3.12 | 1641524.0 |
| 2006-02-23 | CSA | ETF | 19.07 | 19.7 | 19.0 | 19.68 | 37000.0 |
| 2006-02-23 | CSB | ETF | 31.13 | 31.2 | 31.0 | 31.01 | 5900.0 |
| 2006-02-23 | CSM | ETF | 2.4775 | 2.4775 | 2.4775 | 2.4775 | 6000.0 |
| 2006-02-23 | CSQ | ETF | 14.22 | 14.28 | 14.12 | 14.26 | 394000.0 |
| 2006-02-23 | CTEC | ETF | 56.15 | 57.0 | 55.99999999999999 | 57.0 | 4323.400000000001 |
| 2006-02-23 | CYB | ETF | 5.91 | 5.94 | 5.8 | 5.9 | 25600.0 |
| 2006-02-23 | DBC | ETF | 22.85 | 23.1 | 22.644 | 22.82 | 380400.0 |
| 2006-02-23 | DGT | ETF | 66.59 | 66.88 | 66.59 | 66.72 | 1700.0 |
| 2006-02-23 | DIG | ETF | 17.05 | 17.05 | 17.05 | 17.05 | 800.0 |
| 2006-02-23 | DIV | ETF | 12.75 | 12.7799 | 12.63 | 12.71 | 19200.0 |
> showing 50 of 303 rows — these rows as CSV