PREVIEW / etf_daily / 2007-08-21
file: by_date/etf_daily/2007/2007-08-21.parquet size: 23 KB rows: 498
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-21 | SPY | ETF | 144.6 | 145.97 | 144.14 | 144.93 | 157066400.0 |
| 2007-08-21 | QQQ | ETF | 46.48 | 47.1272 | 46.39 | 47.02 | 115029555.0 |
| 2007-08-21 | IWM | ETF | 78.47 | 79.09 | 78.0 | 78.69 | 92754900.0 |
| 2007-08-21 | DIA | ETF | 130.82 | 131.66 | 130.42 | 130.68 | 14383300.0 |
| 2007-08-21 | GLD | ETF | 65.18 | 65.3 | 64.73 | 65.07 | 4478600.0 |
| 2007-08-21 | TLT | ETF | 87.1 | 87.41 | 87.05 | 87.26 | 1517200.0 |
| 2007-08-21 | ADRE | ETF | 42.0 | 42.21 | 41.54 | 41.98 | 128562.0 |
| 2007-08-21 | AGG | ETF | 99.31 | 99.38 | 99.11 | 99.26 | 224600.0 |
| 2007-08-21 | AIQ | ETF | 43.05 | 43.65 | 42.55 | 42.9 | 25540.0 |
| 2007-08-21 | AIS | ETF | 1.25 | 1.39 | 1.25 | 1.37 | 239900.0 |
| 2007-08-21 | ARB | ETF | 50.8 | 51.25 | 50.35 | 50.7 | 217400.0 |
| 2007-08-21 | BBH | ETF | 53.6867 | 53.8267 | 53.3233 | 53.56 | 216600.0 |
| 2007-08-21 | BIL | ETF | 92.06 | 92.06 | 91.9 | 92.02 | 157700.0 |
| 2007-08-21 | BITS | ETF | 25.32 | 26.2 | 25.04 | 25.48 | 6006.0 |
| 2007-08-21 | BIV | ETF | 75.09 | 75.13 | 74.98 | 75.04 | 7100.0 |
| 2007-08-21 | BLV | ETF | 73.71 | 73.84 | 73.42 | 73.84 | 3000.0 |
| 2007-08-21 | BMVP | ETF | 16.3967 | 16.58 | 16.3967 | 16.5033 | 72100.0 |
| 2007-08-21 | BND | ETF | 75.14 | 75.16 | 74.97 | 74.97 | 24900.0 |
| 2007-08-21 | BNE | ETF | 16.0 | 16.35 | 15.86 | 16.04 | 288400.0 |
| 2007-08-21 | BOSS | ETF | 47.85 | 48.02 | 47.85 | 48.02 | 100.0 |
| 2007-08-21 | BRF | ETF | 14.54 | 14.55 | 14.54 | 14.55 | 1700.0 |
| 2007-08-21 | BSV | ETF | 75.93 | 76.02 | 75.76 | 75.97 | 72300.0 |
| 2007-08-21 | BTF | ETF | 101.35 | 102.3 | 101.35 | 102.3 | 340.0 |
| 2007-08-21 | CBON | ETF | 25.52 | 26.11 | 25.0 | 25.82 | 20645.0 |
| 2007-08-21 | CDL | ETF | 4.19 | 4.33 | 4.17 | 4.21 | 1803515.0 |
| 2007-08-21 | CEF | ETF | 9.01 | 9.1 | 8.97 | 9.03 | 449700.0 |
| 2007-08-21 | CGO | ETF | 15.92 | 16.49 | 15.75 | 16.4099 | 29300.0 |
| 2007-08-21 | CGW | ETF | 23.75 | 23.75 | 23.33 | 23.46 | 73800.0 |
| 2007-08-21 | CHB | ETF | 10.75 | 11.04 | 10.57 | 10.91 | 2182424.0 |
| 2007-08-21 | CHI | ETF | 16.4 | 16.79 | 16.3901 | 16.7099 | 138100.0 |
| 2007-08-21 | CHIC | ETF | 17.45 | 18.31 | 17.44 | 18.24 | 517274.0 |
| 2007-08-21 | CHW | ETF | 13.15 | 13.7 | 13.0 | 13.5716 | 96400.0 |
| 2007-08-21 | CHY | ETF | 14.37 | 14.69 | 14.34 | 14.56 | 200400.0 |
| 2007-08-21 | CN | ETF | 46.2 | 46.98 | 46.13 | 46.43 | 115000.0 |
| 2007-08-21 | CNXT | ETF | 1.17 | 1.17 | 1.14 | 1.15 | 6874806.0 |
| 2007-08-21 | CPI | ETF | 26.7 | 26.7 | 25.0 | 25.5 | 4900.0 |
| 2007-08-21 | CPST | ETF | 1.0 | 1.02 | 0.986 | 0.987 | 527809.0 |
| 2007-08-21 | CSA | ETF | 16.95 | 17.12 | 16.61 | 16.96 | 36700.0 |
| 2007-08-21 | CSD | ETF | 28.05 | 28.26 | 28.05 | 28.22 | 7400.0 |
| 2007-08-21 | CSM | ETF | 1.4225 | 1.4225 | 1.42 | 1.4225 | 20800.0 |
| 2007-08-21 | CSQ | ETF | 14.18 | 14.43 | 14.06 | 14.2 | 571400.0 |
| 2007-08-21 | CTEC | ETF | 97.70049999999999 | 101.64999999999999 | 97.70049999999999 | 100.35 | 12182.400000000001 |
| 2007-08-21 | CVY | ETF | 25.41 | 25.68 | 25.41 | 25.62 | 24200.0 |
| 2007-08-21 | CWI | ETF | 25.26 | 25.42 | 25.2467 | 25.3 | 36600.0 |
| 2007-08-21 | CZA | ETF | 24.91 | 24.91 | 24.91 | 24.91 | 100.0 |
| 2007-08-21 | DBA | ETF | 26.08 | 26.32 | 26.0 | 26.06 | 173400.0 |
| 2007-08-21 | DBB | ETF | 24.74 | 24.8 | 24.57 | 24.67 | 10700.0 |
| 2007-08-21 | DBC | ETF | 25.15 | 25.4144 | 25.03 | 25.19 | 315800.0 |
| 2007-08-21 | DBE | ETF | 27.69 | 27.96 | 27.25 | 27.32 | 10700.0 |
| 2007-08-21 | DBO | ETF | 26.01 | 27.1 | 25.43 | 25.8 | 38700.0 |
> showing 50 of 498 rows — these rows as CSV