PREVIEW / etf_daily / 2006-06-19
file: by_date/etf_daily/2006/2006-06-19.parquet size: 17 KB rows: 336
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-06-19 | SPY | ETF | 125.4 | 125.48 | 123.55 | 123.67 | 95804400.0 |
| 2006-06-19 | QQQ | ETF | 38.5 | 38.54 | 37.91 | 38.03 | 129464799.0 |
| 2006-06-19 | IWM | ETF | 69.1 | 69.12 | 67.44 | 67.5 | 71705700.0 |
| 2006-06-19 | DIA | ETF | 110.3 | 110.44 | 108.96 | 109.17 | 7078800.0 |
| 2006-06-19 | GLD | ETF | 56.85 | 57.25 | 56.15 | 56.36 | 5737400.0 |
| 2006-06-19 | TLT | ETF | 84.21 | 84.29 | 83.98 | 84.19 | 1233700.0 |
| 2006-06-19 | AAA | ETF | 54.6 | 54.7 | 54.39 | 54.53 | 7000.0 |
| 2006-06-19 | ADRE | ETF | 116.98 | 116.98 | 112.83 | 112.83 | 250012.0 |
| 2006-06-19 | AFK | ETF | 24.86 | 24.9 | 24.8 | 24.8001 | 4600.0 |
| 2006-06-19 | AGG | ETF | 97.64 | 97.75 | 97.42 | 97.5 | 164400.0 |
| 2006-06-19 | AIQ | ETF | 28.15 | 29.95 | 27.95 | 29.1 | 37940.0 |
| 2006-06-19 | AIS | ETF | 1.23 | 1.23 | 1.15 | 1.2 | 203100.0 |
| 2006-06-19 | AOM | ETF | 6.15 | 6.22 | 6.1 | 6.2 | 12100.0 |
| 2006-06-19 | ARB | ETF | 37.57 | 37.79 | 36.95 | 37.05 | 324200.0 |
| 2006-06-19 | BAB | ETF | 66.71 | 66.9 | 66.0 | 66.45 | 42200.0 |
| 2006-06-19 | BBC | ETF | 10.25 | 11.0 | 10.08 | 10.12 | 365100.0 |
| 2006-06-19 | BBH | ETF | 58.2067 | 58.3333 | 56.9633 | 57.25 | 789000.0 |
| 2006-06-19 | BCM | ETF | 68.29 | 68.88 | 67.5 | 68.38 | 39200.0 |
| 2006-06-19 | BITS | ETF | 23.36 | 23.64 | 22.32 | 22.56 | 11272.0 |
| 2006-06-19 | BKF | ETF | 6.15 | 6.24 | 6.03 | 6.21 | 157900.0 |
| 2006-06-19 | BNE | ETF | 13.57 | 13.74 | 13.44 | 13.55 | 139500.0 |
| 2006-06-19 | BRF | ETF | 13.98 | 13.98 | 13.92 | 13.97 | 4300.0 |
| 2006-06-19 | BTF | ETF | 88.85 | 90.35 | 88.8 | 90.35 | 4180.0 |
| 2006-06-19 | CBON | ETF | 30.3 | 30.4 | 29.56 | 29.68 | 20381.0 |
| 2006-06-19 | CDL | ETF | 8.91 | 8.97 | 8.65 | 8.69 | 310000.0 |
| 2006-06-19 | CEF | ETF | 8.48 | 8.53 | 8.16 | 8.19 | 719600.0 |
| 2006-06-19 | CEW | ETF | 25.95 | 26.05 | 25.95 | 26.05 | 1000.0 |
| 2006-06-19 | CFO | ETF | 9.7 | 9.7 | 9.7 | 9.7 | 1000.0 |
| 2006-06-19 | CGO | ETF | 13.92 | 14.18 | 13.88 | 14.12 | 18600.0 |
| 2006-06-19 | CHB | ETF | 9.68 | 9.69 | 9.25 | 9.46 | 847500.0 |
| 2006-06-19 | CHI | ETF | 19.01 | 19.24 | 19.01 | 19.15 | 95200.0 |
| 2006-06-19 | CHIC | ETF | 19.89 | 19.96 | 19.24 | 19.5 | 187964.0 |
| 2006-06-19 | CHY | ETF | 16.0 | 16.1 | 16.0 | 16.07 | 242300.0 |
| 2006-06-19 | CIL | ETF | 25.12 | 25.12 | 25.12 | 25.12 | 200.0 |
| 2006-06-19 | CN | ETF | 32.85 | 33.0 | 32.02 | 32.28 | 51500.0 |
| 2006-06-19 | CNXT | ETF | 2.47 | 2.49 | 2.35 | 2.37 | 9263092.0 |
| 2006-06-19 | COMB | ETF | 9.85 | 9.92 | 9.66 | 9.7 | 34125.0 |
| 2006-06-19 | CPI | ETF | 33.3 | 33.3 | 32.75 | 32.75 | 700.0 |
| 2006-06-19 | CPST | ETF | 2.39 | 2.4 | 2.25 | 2.26 | 1002498.0 |
| 2006-06-19 | CSB | ETF | 27.31 | 27.31 | 26.85 | 27.04 | 9000.0 |
| 2006-06-19 | CSQ | ETF | 13.8 | 13.83 | 13.74 | 13.83 | 269000.0 |
| 2006-06-19 | CTEC | ETF | 64.69999999999999 | 65.89999999999999 | 60.75 | 61.6 | 23884.0 |
| 2006-06-19 | CYB | ETF | 5.51 | 5.76 | 5.37 | 5.45 | 43600.0 |
| 2006-06-19 | DBC | ETF | 24.09 | 24.1699 | 23.84 | 23.9 | 178200.0 |
| 2006-06-19 | DES | ETF | 16.7667 | 16.7733 | 16.5667 | 16.61 | 19200.0 |
| 2006-06-19 | DEW | ETF | 50.17 | 50.17 | 49.85 | 49.85 | 1500.0 |
| 2006-06-19 | DFE | ETF | 51.01 | 51.01 | 51.01 | 51.01 | 100.0 |
| 2006-06-19 | DFJ | ETF | 50.5 | 50.59 | 50.5 | 50.59 | 700.0 |
| 2006-06-19 | DGT | ETF | 65.28 | 65.3 | 64.94 | 65.0 | 3600.0 |
| 2006-06-19 | DHS | ETF | 50.18 | 50.18 | 49.58 | 49.77 | 8200.0 |
> showing 50 of 336 rows — these rows as CSV