PREVIEW / etf_daily / 2005-12-02
file: by_date/etf_daily/2005/2005-12-02.parquet size: 16 KB rows: 290
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-02 | SPY | ETF | 126.77 | 127.08 | 126.5 | 126.85 | 46699400.0 |
| 2005-12-02 | QQQ | ETF | 41.932 | 42.133 | 41.87 | 42.107 | 72929167.0 |
| 2005-12-02 | IWM | ETF | 68.6 | 68.82 | 68.12 | 68.82 | 23767700.0 |
| 2005-12-02 | DIA | ETF | 109.03 | 109.26 | 108.65 | 108.82 | 5143600.0 |
| 2005-12-02 | GLD | ETF | 49.93 | 50.34 | 49.89 | 50.32 | 1651900.0 |
| 2005-12-02 | TLT | ETF | 89.27 | 89.55 | 89.15 | 89.5 | 746200.0 |
| 2005-12-02 | AAA | ETF | 53.16 | 53.36 | 52.95 | 53.21 | 3800.0 |
| 2005-12-02 | ADRE | ETF | 114.91 | 114.91 | 113.56 | 114.089 | 30940.0 |
| 2005-12-02 | AFK | ETF | 25.56 | 25.59 | 25.46 | 25.47 | 2000.0 |
| 2005-12-02 | AGG | ETF | 99.84 | 99.88 | 99.59 | 99.7 | 151700.0 |
| 2005-12-02 | AIQ | ETF | 27.95 | 28.5 | 27.0 | 28.3 | 21040.0 |
| 2005-12-02 | AIS | ETF | 1.25 | 1.2699 | 1.22 | 1.23 | 333400.0 |
| 2005-12-02 | AOM | ETF | 3.5 | 3.5 | 3.4 | 3.49 | 18600.0 |
| 2005-12-02 | ARB | ETF | 39.58 | 39.85 | 39.26 | 39.77 | 99200.0 |
| 2005-12-02 | BAB | ETF | 55.3 | 56.0 | 55.3 | 55.68 | 18700.0 |
| 2005-12-02 | BBC | ETF | 10.1 | 10.18 | 9.55 | 9.7 | 141700.0 |
| 2005-12-02 | BBH | ETF | 68.8433 | 69.4733 | 68.34 | 69.3933 | 955800.0 |
| 2005-12-02 | BCM | ETF | 64.72 | 65.37 | 64.45 | 65.37 | 28300.0 |
| 2005-12-02 | BITS | ETF | 13.96 | 14.12 | 13.32 | 13.8 | 4870.0 |
| 2005-12-02 | BKF | ETF | 21.25 | 21.74 | 20.82 | 21.5 | 39900.0 |
| 2005-12-02 | BNE | ETF | 15.09 | 15.33 | 15.0 | 15.33 | 76600.0 |
| 2005-12-02 | BRF | ETF | 15.06 | 15.25 | 15.06 | 15.13 | 14800.0 |
| 2005-12-02 | BTF | ETF | 88.3 | 88.39999999999999 | 87.89999999999999 | 88.39999999999999 | 15020.0 |
| 2005-12-02 | CBON | ETF | 31.46 | 31.92 | 31.41 | 31.67 | 18859.0 |
| 2005-12-02 | CDL | ETF | 13.72 | 13.82 | 13.61 | 13.81 | 479100.0 |
| 2005-12-02 | CEF | ETF | 6.31 | 6.32 | 6.22 | 6.25 | 463000.0 |
| 2005-12-02 | CEW | ETF | 26.03 | 26.2 | 26.03 | 26.2 | 1100.0 |
| 2005-12-02 | CGO | ETF | 13.23 | 13.4 | 13.23 | 13.4 | 23200.0 |
| 2005-12-02 | CHB | ETF | 15.0 | 15.1 | 14.77 | 15.08 | 394200.0 |
| 2005-12-02 | CHI | ETF | 20.3 | 20.48 | 20.2672 | 20.45 | 55600.0 |
| 2005-12-02 | CHIC | ETF | 19.0 | 19.19 | 18.73 | 18.94 | 213186.0 |
| 2005-12-02 | CHIR | ETF | 44.2701 | 44.3901 | 44.1999 | 44.3001 | 1008459.0 |
| 2005-12-02 | CHY | ETF | 15.9 | 15.93 | 15.7601 | 15.91 | 72200.0 |
| 2005-12-02 | CIL | ETF | 25.17 | 25.33 | 25.17 | 25.26 | 800.0 |
| 2005-12-02 | CN | ETF | 32.3 | 32.35 | 32.18 | 32.25 | 6000.0 |
| 2005-12-02 | CNXT | ETF | 2.65 | 2.69 | 2.6 | 2.69 | 24940813.0 |
| 2005-12-02 | COMB | ETF | 8.6 | 8.6 | 8.5 | 8.6 | 8719.0 |
| 2005-12-02 | CPI | ETF | 27.1 | 27.3 | 27.1 | 27.3 | 900.0 |
| 2005-12-02 | CPST | ETF | 3.5 | 3.52 | 3.25 | 3.35 | 3845351.0 |
| 2005-12-02 | CSA | ETF | 16.7 | 16.75 | 16.68 | 16.7 | 18000.0 |
| 2005-12-02 | CSB | ETF | 29.66 | 29.94 | 29.5 | 29.72 | 27400.0 |
| 2005-12-02 | CSM | ETF | 2.4425 | 2.4425 | 2.4425 | 2.4425 | 2800.0 |
| 2005-12-02 | CSQ | ETF | 13.16 | 13.25 | 13.16 | 13.24 | 311700.0 |
| 2005-12-02 | CTEC | ETF | 48.49999999999999 | 50.0 | 48.25 | 49.9 | 12406.400000000001 |
| 2005-12-02 | CURE | ETF | 0.0887 | 0.0887 | 0.0776 | 0.0875 | 1161776.0 |
| 2005-12-02 | CYB | ETF | 3.6101 | 3.6101 | 3.61 | 3.61 | 3700.0 |
| 2005-12-02 | DGT | ETF | 65.74 | 65.75 | 65.72 | 65.75 | 1500.0 |
| 2005-12-02 | DIG | ETF | 15.15 | 15.2875 | 14.875 | 15.0625 | 11600.0 |
| 2005-12-02 | DIV | ETF | 12.03 | 12.12 | 12.02 | 12.04 | 34700.0 |
| 2005-12-02 | DRIV | ETF | 26.61 | 28.44 | 26.51 | 28.24 | 2065275.0 |
> showing 50 of 290 rows — these rows as CSV