PREVIEW / etf_daily / 2006-08-02
file: by_date/etf_daily/2006/2006-08-02.parquet size: 18 KB rows: 353
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-08-02 | SPY | ETF | 127.58 | 128.46 | 127.55 | 128.08 | 64770900.0 |
| 2006-08-02 | QQQ | ETF | 36.61 | 37.13 | 36.61 | 36.89 | 87398979.0 |
| 2006-08-02 | IWM | ETF | 69.01 | 69.72 | 68.9 | 69.5 | 50137500.0 |
| 2006-08-02 | DIA | ETF | 111.55 | 112.2 | 111.44 | 111.98 | 3929700.0 |
| 2006-08-02 | GLD | ETF | 64.74 | 65.22 | 64.4 | 64.75 | 5052000.0 |
| 2006-08-02 | TLT | ETF | 85.37 | 85.78 | 85.2 | 85.78 | 477400.0 |
| 2006-08-02 | AAA | ETF | 57.87 | 58.07 | 57.29 | 57.4 | 11100.0 |
| 2006-08-02 | ADRE | ETF | 31.75 | 32.23 | 31.74 | 32.06 | 185896.0 |
| 2006-08-02 | AFK | ETF | 25.13 | 25.1899 | 25.12 | 25.1799 | 1800.0 |
| 2006-08-02 | AGG | ETF | 98.34 | 98.43 | 98.2 | 98.27 | 127400.0 |
| 2006-08-02 | AIQ | ETF | 33.4 | 33.9 | 32.7 | 33.25 | 24900.0 |
| 2006-08-02 | AIS | ETF | 1.08 | 1.0899 | 1.05 | 1.07 | 44100.0 |
| 2006-08-02 | AOM | ETF | 6.2 | 6.33 | 6.1 | 6.2 | 19100.0 |
| 2006-08-02 | ARB | ETF | 36.4 | 36.69 | 36.02 | 36.02 | 157700.0 |
| 2006-08-02 | BAB | ETF | 72.72 | 73.11 | 72.58 | 72.77 | 45200.0 |
| 2006-08-02 | BBC | ETF | 12.81 | 13.11 | 12.81 | 13.05 | 136400.0 |
| 2006-08-02 | BBH | ETF | 59.0 | 59.7167 | 59.0 | 59.42 | 563400.0 |
| 2006-08-02 | BITS | ETF | 16.52 | 18.32 | 16.4 | 17.72 | 21724.0 |
| 2006-08-02 | BKF | ETF | 3.9 | 3.98 | 3.9 | 3.96 | 47500.0 |
| 2006-08-02 | BNE | ETF | 13.5 | 14.11 | 13.5 | 13.89 | 98600.0 |
| 2006-08-02 | BRF | ETF | 14.0 | 14.08 | 14.0 | 14.0301 | 6300.0 |
| 2006-08-02 | BTF | ETF | 86.89999999999999 | 87.69999999999999 | 86.89999999999999 | 87.69999999999999 | 540.0 |
| 2006-08-02 | CBON | ETF | 33.85 | 33.85 | 33.56 | 33.68 | 28190.0 |
| 2006-08-02 | CDL | ETF | 9.3 | 9.59 | 9.24 | 9.56 | 481200.0 |
| 2006-08-02 | CEF | ETF | 8.99 | 9.14 | 8.92 | 9.1 | 565500.0 |
| 2006-08-02 | CFO | ETF | 10.1 | 10.12 | 10.1 | 10.12 | 3500.0 |
| 2006-08-02 | CGO | ETF | 14.91 | 15.08 | 14.9 | 15.0 | 24900.0 |
| 2006-08-02 | CHB | ETF | 6.45 | 6.5 | 6.32 | 6.46 | 1526400.0 |
| 2006-08-02 | CHI | ETF | 19.97 | 20.09 | 19.96 | 19.98 | 86400.0 |
| 2006-08-02 | CHIC | ETF | 26.56 | 26.56 | 25.25 | 25.39 | 503668.0 |
| 2006-08-02 | CHY | ETF | 16.12 | 16.22 | 16.12 | 16.2 | 139200.0 |
| 2006-08-02 | CIZ | ETF | 21.9 | 22.15 | 21.9 | 22.0 | 2200.0 |
| 2006-08-02 | CN | ETF | 36.0 | 36.49 | 36.0 | 36.22 | 25700.0 |
| 2006-08-02 | CNXT | ETF | 1.74 | 1.78 | 1.66 | 1.68 | 13794413.0 |
| 2006-08-02 | COMB | ETF | 9.8 | 9.82 | 9.74 | 9.77 | 45700.0 |
| 2006-08-02 | CPI | ETF | 29.05 | 29.05 | 29.05 | 29.05 | 100.0 |
| 2006-08-02 | CPST | ETF | 1.83 | 2.01 | 1.81 | 1.98 | 1978194.0 |
| 2006-08-02 | CSA | ETF | 18.5 | 18.75 | 18.5 | 18.6 | 14800.0 |
| 2006-08-02 | CSB | ETF | 26.78 | 26.81 | 26.6 | 26.65 | 12000.0 |
| 2006-08-02 | CSQ | ETF | 14.22 | 14.24 | 14.17 | 14.23 | 279900.0 |
| 2006-08-02 | CTEC | ETF | 56.349999999999994 | 57.449999999999996 | 53.05 | 54.349999999999994 | 40928.200000000004 |
| 2006-08-02 | CYB | ETF | 5.5 | 5.5 | 5.24 | 5.25 | 54500.0 |
| 2006-08-02 | DBC | ETF | 26.15 | 26.4 | 26.12 | 26.33 | 641900.0 |
| 2006-08-02 | DDM | ETF | 6.0433 | 6.0975 | 6.0192 | 6.0575 | 903600.0 |
| 2006-08-02 | DES | ETF | 17.2 | 17.29 | 17.1633 | 17.1967 | 7200.0 |
| 2006-08-02 | DEW | ETF | 53.6 | 53.6 | 53.6 | 53.6 | 100.0 |
| 2006-08-02 | DFE | ETF | 54.05 | 54.05 | 54.0 | 54.0 | 200.0 |
| 2006-08-02 | DFJ | ETF | 50.54 | 50.54 | 50.54 | 50.54 | 100.0 |
| 2006-08-02 | DGT | ETF | 69.22 | 69.5 | 69.05 | 69.29 | 15900.0 |
| 2006-08-02 | DHS | ETF | 52.75 | 53.05 | 52.75 | 52.95 | 8500.0 |
> showing 50 of 353 rows — these rows as CSV