PREVIEW / etf_daily / 2006-02-06
file: by_date/etf_daily/2006/2006-02-06.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-06 | SPY | ETF | 126.44 | 126.8 | 126.17 | 126.6 | 45511900.0 |
| 2006-02-06 | QQQ | ETF | 40.9 | 41.01 | 40.59 | 40.81 | 58171412.0 |
| 2006-02-06 | IWM | ETF | 71.9 | 72.45 | 71.52 | 72.42 | 24741300.0 |
| 2006-02-06 | DIA | ETF | 107.95 | 108.13 | 107.67 | 108.02 | 3454100.0 |
| 2006-02-06 | GLD | ETF | 56.76 | 57.15 | 56.65 | 56.72 | 3455200.0 |
| 2006-02-06 | TLT | ETF | 90.98 | 91.21 | 90.89 | 91.03 | 755100.0 |
| 2006-02-06 | AAA | ETF | 53.98 | 54.3699 | 53.98 | 54.25 | 1600.0 |
| 2006-02-06 | ADRE | ETF | 128.0 | 129.69 | 127.39 | 129.69 | 38584.0 |
| 2006-02-06 | AFK | ETF | 25.43 | 25.44 | 25.34 | 25.34 | 3200.0 |
| 2006-02-06 | AGG | ETF | 100.07 | 100.29 | 100.01 | 100.21 | 119800.0 |
| 2006-02-06 | AIQ | ETF | 21.75 | 21.75 | 20.65 | 21.3 | 13780.0 |
| 2006-02-06 | AIS | ETF | 1.38 | 1.46 | 1.38 | 1.46 | 84100.0 |
| 2006-02-06 | AOM | ETF | 5.74 | 5.78 | 5.6 | 5.64 | 6400.0 |
| 2006-02-06 | ARB | ETF | 39.07 | 39.42 | 38.48 | 39.27 | 153700.0 |
| 2006-02-06 | BAB | ETF | 55.68 | 55.84 | 55.18 | 55.42 | 20800.0 |
| 2006-02-06 | BBC | ETF | 15.85 | 17.25 | 15.65 | 17.0 | 726200.0 |
| 2006-02-06 | BBH | ETF | 65.9233 | 65.9233 | 65.23 | 65.3633 | 450600.0 |
| 2006-02-06 | BCM | ETF | 69.49 | 69.7799 | 69.36 | 69.48 | 20900.0 |
| 2006-02-06 | BITS | ETF | 22.0 | 22.96 | 20.68 | 21.8 | 82200.0 |
| 2006-02-06 | BKF | ETF | 12.64 | 12.9899 | 12.3 | 12.72 | 120700.0 |
| 2006-02-06 | BNE | ETF | 14.99 | 15.1 | 14.97 | 15.05 | 67900.0 |
| 2006-02-06 | BRF | ETF | 15.389 | 15.39 | 15.38 | 15.39 | 3500.0 |
| 2006-02-06 | BTF | ETF | 85.5 | 85.6 | 85.15 | 85.15 | 7460.0 |
| 2006-02-06 | CBON | ETF | 31.94 | 31.94 | 31.21 | 31.3 | 11406.0 |
| 2006-02-06 | CDL | ETF | 12.05 | 12.2 | 11.86 | 12.0 | 2777400.0 |
| 2006-02-06 | CEF | ETF | 7.69 | 7.83 | 7.65 | 7.69 | 409800.0 |
| 2006-02-06 | CEW | ETF | 26.32 | 26.32 | 26.32 | 26.32 | 900.0 |
| 2006-02-06 | CFO | ETF | 10.06 | 10.1 | 10.06 | 10.1 | 5800.0 |
| 2006-02-06 | CGO | ETF | 14.23 | 14.29 | 14.17 | 14.29 | 24400.0 |
| 2006-02-06 | CHB | ETF | 13.88 | 14.12 | 13.77 | 14.06 | 699300.0 |
| 2006-02-06 | CHI | ETF | 20.7 | 20.7 | 20.43 | 20.6099 | 87300.0 |
| 2006-02-06 | CHIC | ETF | 16.66 | 16.84 | 15.99 | 16.6 | 355883.0 |
| 2006-02-06 | CHIR | ETF | 45.4899 | 45.6999 | 45.3999 | 45.6 | 703311.0 |
| 2006-02-06 | CHY | ETF | 16.25 | 16.32 | 16.19 | 16.32 | 98600.0 |
| 2006-02-06 | CIL | ETF | 25.45 | 25.45 | 25.45 | 25.45 | 600.0 |
| 2006-02-06 | CN | ETF | 33.8 | 34.02 | 33.56 | 33.84 | 33000.0 |
| 2006-02-06 | CNXT | ETF | 3.32 | 3.37 | 3.3 | 3.36 | 12025197.0 |
| 2006-02-06 | CPST | ETF | 3.59 | 3.69 | 3.49 | 3.59 | 3245182.0 |
| 2006-02-06 | CSA | ETF | 18.74 | 18.74 | 18.44 | 18.44 | 27000.0 |
| 2006-02-06 | CSB | ETF | 30.86 | 31.11 | 30.85 | 31.11 | 11800.0 |
| 2006-02-06 | CSM | ETF | 2.4725 | 2.4725 | 2.4725 | 2.4725 | 800.0 |
| 2006-02-06 | CSQ | ETF | 13.94 | 14.04 | 13.91 | 14.01 | 246300.0 |
| 2006-02-06 | CTEC | ETF | 54.24999999999999 | 54.800000000000004 | 54.05 | 54.74999999999999 | 8821.0 |
| 2006-02-06 | CURE | ETF | 0.0325 | 0.0338 | 0.0312 | 0.0312 | 1995816.0 |
| 2006-02-06 | CYB | ETF | 4.3 | 4.3 | 4.11 | 4.2 | 13800.0 |
| 2006-02-06 | DBC | ETF | 24.55 | 24.66 | 24.1 | 24.2 | 771500.0 |
| 2006-02-06 | DGT | ETF | 66.0 | 66.0 | 65.55 | 65.65 | 4200.0 |
| 2006-02-06 | DIG | ETF | 17.375 | 17.375 | 17.375 | 17.375 | 800.0 |
| 2006-02-06 | DIV | ETF | 12.36 | 12.4 | 12.32 | 12.39 | 21200.0 |
| 2006-02-06 | DRIV | ETF | 34.645 | 35.3 | 34.34 | 35.1 | 1381657.0 |
> showing 50 of 301 rows — these rows as CSV