PREVIEW / etf_daily / 2006-02-07
file: by_date/etf_daily/2006/2006-02-07.parquet size: 16 KB rows: 301
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-07 | SPY | ETF | 126.38 | 126.66 | 125.4 | 125.48 | 71208100.0 |
| 2006-02-07 | QQQ | ETF | 40.74 | 40.93 | 40.44 | 40.63 | 87377388.0 |
| 2006-02-07 | IWM | ETF | 72.27 | 72.59 | 71.15 | 71.25 | 41861300.0 |
| 2006-02-07 | DIA | ETF | 107.83 | 108.21 | 107.32 | 107.48 | 11363000.0 |
| 2006-02-07 | GLD | ETF | 55.88 | 55.92 | 54.33 | 54.6 | 10197200.0 |
| 2006-02-07 | TLT | ETF | 91.12 | 91.12 | 90.5 | 90.6 | 280500.0 |
| 2006-02-07 | AAA | ETF | 54.18 | 54.18 | 53.88 | 54.1 | 1600.0 |
| 2006-02-07 | ADRE | ETF | 129.69 | 130.79 | 125.4325 | 125.77 | 42724.0 |
| 2006-02-07 | AFK | ETF | 25.43 | 25.43 | 25.34 | 25.39 | 6300.0 |
| 2006-02-07 | AGG | ETF | 100.33 | 100.34 | 99.93 | 100.14 | 122900.0 |
| 2006-02-07 | AIQ | ETF | 21.0 | 21.4 | 20.6 | 20.95 | 18480.0 |
| 2006-02-07 | AIS | ETF | 1.47 | 1.48 | 1.42 | 1.42 | 74300.0 |
| 2006-02-07 | AOM | ETF | 5.6 | 5.63 | 5.59 | 5.59 | 2700.0 |
| 2006-02-07 | ARB | ETF | 39.27 | 39.54 | 38.57 | 38.66 | 215200.0 |
| 2006-02-07 | BAB | ETF | 55.42 | 56.02 | 55.37 | 55.56 | 42800.0 |
| 2006-02-07 | BBC | ETF | 16.75 | 18.7 | 15.45 | 15.75 | 434400.0 |
| 2006-02-07 | BBH | ETF | 65.9233 | 65.9233 | 64.5933 | 64.64 | 1506000.0 |
| 2006-02-07 | BCM | ETF | 69.05 | 69.23 | 68.44 | 68.59 | 21100.0 |
| 2006-02-07 | BITS | ETF | 21.8 | 24.4 | 21.8 | 23.2 | 90466.0 |
| 2006-02-07 | BKF | ETF | 12.85 | 13.15 | 12.55 | 13.15 | 158700.0 |
| 2006-02-07 | BNE | ETF | 15.05 | 15.1 | 14.95 | 15.01 | 119000.0 |
| 2006-02-07 | BRF | ETF | 15.39 | 15.39 | 15.39 | 15.39 | 1600.0 |
| 2006-02-07 | BTF | ETF | 85.15 | 85.15 | 84.85 | 84.94999999999999 | 5320.0 |
| 2006-02-07 | CBON | ETF | 31.35 | 31.35 | 30.52 | 30.52 | 12560.0 |
| 2006-02-07 | CDL | ETF | 12.0 | 12.0 | 11.19 | 11.48 | 2403000.0 |
| 2006-02-07 | CEF | ETF | 7.6 | 7.66 | 7.21 | 7.28 | 1250100.0 |
| 2006-02-07 | CEW | ETF | 26.3 | 26.5 | 26.3 | 26.35 | 3000.0 |
| 2006-02-07 | CFO | ETF | 10.13 | 10.13 | 10.06 | 10.06 | 13500.0 |
| 2006-02-07 | CGO | ETF | 14.25 | 14.37 | 14.15 | 14.23 | 36100.0 |
| 2006-02-07 | CHB | ETF | 13.96 | 14.26 | 13.76 | 14.11 | 1238700.0 |
| 2006-02-07 | CHI | ETF | 20.5 | 20.72 | 20.5 | 20.6501 | 83100.0 |
| 2006-02-07 | CHIC | ETF | 16.61 | 17.18 | 16.52 | 16.93 | 499448.0 |
| 2006-02-07 | CHIR | ETF | 45.5499 | 45.96 | 45.5499 | 45.8901 | 1057505.0 |
| 2006-02-07 | CHY | ETF | 16.28 | 16.31 | 16.18 | 16.2201 | 91100.0 |
| 2006-02-07 | CIZ | ETF | 24.03 | 24.03 | 23.9 | 23.9999 | 500.0 |
| 2006-02-07 | CN | ETF | 33.05 | 33.1 | 32.22 | 32.82 | 48200.0 |
| 2006-02-07 | CNXT | ETF | 3.03 | 3.12 | 2.61 | 2.7 | 91233442.0 |
| 2006-02-07 | COMB | ETF | 8.4 | 8.5 | 8.35 | 8.5 | 1400.0 |
| 2006-02-07 | CPST | ETF | 3.59 | 3.63 | 3.36 | 3.41 | 2693333.0 |
| 2006-02-07 | CSA | ETF | 18.49 | 18.7 | 18.48 | 18.51 | 15900.0 |
| 2006-02-07 | CSB | ETF | 31.6 | 31.6 | 31.2 | 31.5 | 22300.0 |
| 2006-02-07 | CSM | ETF | 2.4825 | 2.4825 | 2.4825 | 2.4825 | 1200.0 |
| 2006-02-07 | CSQ | ETF | 14.03 | 14.08 | 13.94 | 14.0 | 318300.0 |
| 2006-02-07 | CTEC | ETF | 54.699999999999996 | 54.699999999999996 | 52.5 | 52.55 | 9901.0 |
| 2006-02-07 | CURE | ETF | 0.03 | 0.0312 | 0.0288 | 0.0288 | 2793760.0 |
| 2006-02-07 | CYB | ETF | 4.21 | 4.21 | 4.18 | 4.18 | 5500.0 |
| 2006-02-07 | DBC | ETF | 24.05 | 24.2 | 23.45 | 23.5 | 674400.0 |
| 2006-02-07 | DGT | ETF | 65.65 | 65.65 | 65.12 | 65.3 | 36600.0 |
| 2006-02-07 | DIG | ETF | 17.2125 | 17.2125 | 17.1375 | 17.1375 | 1040.0 |
| 2006-02-07 | DIV | ETF | 12.37 | 12.42 | 12.36 | 12.4 | 12600.0 |
> showing 50 of 301 rows — these rows as CSV