PREVIEW / etf_daily / 2007-08-28
file: by_date/etf_daily/2007/2007-08-28.parquet size: 22 KB rows: 494
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-28 | SPY | ETF | 146.16 | 146.25 | 143.46 | 143.72 | 219790700.0 |
| 2007-08-28 | QQQ | ETF | 47.6 | 47.7 | 46.71 | 46.74 | 106024956.0 |
| 2007-08-28 | IWM | ETF | 78.08 | 78.19 | 76.4 | 76.55 | 86275800.0 |
| 2007-08-28 | DIA | ETF | 132.54 | 132.7 | 130.31 | 130.49 | 13055600.0 |
| 2007-08-28 | GLD | ETF | 65.95 | 66.1 | 65.48 | 65.59 | 3473100.0 |
| 2007-08-28 | TLT | ETF | 88.43 | 88.74 | 88.28 | 88.46 | 1298900.0 |
| 2007-08-28 | ADRE | ETF | 45.25 | 45.59 | 43.49 | 43.5912 | 368250.0 |
| 2007-08-28 | AGG | ETF | 99.41 | 99.77 | 99.37 | 99.75 | 187700.0 |
| 2007-08-28 | AIQ | ETF | 44.0 | 44.3 | 43.35 | 43.35 | 44580.0 |
| 2007-08-28 | AIS | ETF | 1.44 | 1.49 | 1.4101 | 1.48 | 343100.0 |
| 2007-08-28 | ARB | ETF | 49.75 | 49.76 | 48.79 | 48.86 | 214100.0 |
| 2007-08-28 | BBH | ETF | 53.9333 | 53.9733 | 53.5033 | 53.54 | 192300.0 |
| 2007-08-28 | BIL | ETF | 91.84 | 91.92 | 91.84 | 91.92 | 29250.0 |
| 2007-08-28 | BITS | ETF | 26.7996 | 26.7996 | 25.8 | 25.84 | 4516.0 |
| 2007-08-28 | BIV | ETF | 75.31 | 75.66 | 75.14 | 75.66 | 7400.0 |
| 2007-08-28 | BLV | ETF | 74.54 | 74.74 | 74.38 | 74.71 | 4200.0 |
| 2007-08-28 | BMVP | ETF | 16.77 | 16.77 | 16.4533 | 16.46 | 64200.0 |
| 2007-08-28 | BND | ETF | 75.36 | 75.55 | 75.34 | 75.52 | 55400.0 |
| 2007-08-28 | BNE | ETF | 16.87 | 16.93 | 16.54 | 16.55 | 229800.0 |
| 2007-08-28 | BRF | ETF | 14.5501 | 14.56 | 14.55 | 14.55 | 2200.0 |
| 2007-08-28 | BSV | ETF | 75.7 | 75.94 | 75.7 | 75.94 | 23700.0 |
| 2007-08-28 | BTF | ETF | 105.5 | 105.5 | 104.19999999999999 | 104.35 | 1500.0 |
| 2007-08-28 | CBON | ETF | 25.2 | 25.7 | 25.03 | 25.22 | 67883.0 |
| 2007-08-28 | CDL | ETF | 4.24 | 4.24 | 4.09 | 4.13 | 3643200.0 |
| 2007-08-28 | CEF | ETF | 9.07 | 9.11 | 9.01 | 9.08 | 288200.0 |
| 2007-08-28 | CGO | ETF | 16.45 | 16.82 | 16.45 | 16.58 | 28000.0 |
| 2007-08-28 | CGW | ETF | 24.16 | 24.26 | 23.58 | 23.94 | 60200.0 |
| 2007-08-28 | CHB | ETF | 10.86 | 10.86 | 10.27 | 10.33 | 1791300.0 |
| 2007-08-28 | CHI | ETF | 16.54 | 16.64 | 16.38 | 16.63 | 135900.0 |
| 2007-08-28 | CHIC | ETF | 17.56 | 17.61 | 16.87 | 16.96 | 332095.0 |
| 2007-08-28 | CHW | ETF | 13.99 | 13.99 | 12.95 | 13.6 | 168200.0 |
| 2007-08-28 | CHY | ETF | 14.51 | 14.54 | 14.37 | 14.48 | 148100.0 |
| 2007-08-28 | CN | ETF | 48.18 | 48.5 | 46.52 | 46.52 | 187800.0 |
| 2007-08-28 | CNXT | ETF | 1.13 | 1.14 | 1.06 | 1.08 | 9067605.0 |
| 2007-08-28 | CPST | ETF | 1.09 | 1.16 | 1.07 | 1.1 | 3547105.0 |
| 2007-08-28 | CSA | ETF | 17.13 | 17.5 | 17.13 | 17.23 | 32500.0 |
| 2007-08-28 | CSD | ETF | 28.58 | 28.61 | 28.11 | 28.13 | 9900.0 |
| 2007-08-28 | CSQ | ETF | 14.26 | 14.26 | 13.9 | 14.06 | 332500.0 |
| 2007-08-28 | CTEC | ETF | 99.74999999999999 | 101.44999999999999 | 99.19999999999999 | 100.15 | 16057.6 |
| 2007-08-28 | CVY | ETF | 25.72 | 25.75 | 25.32 | 25.34 | 34200.0 |
| 2007-08-28 | CWI | ETF | 26.22 | 26.22 | 25.7133 | 25.7133 | 100200.0 |
| 2007-08-28 | CZA | ETF | 25.07 | 25.07 | 25.07 | 25.07 | 100.0 |
| 2007-08-28 | DBA | ETF | 26.73 | 26.83 | 26.4 | 26.49 | 112100.0 |
| 2007-08-28 | DBB | ETF | 25.46 | 25.46 | 25.25 | 25.41 | 11700.0 |
| 2007-08-28 | DBC | ETF | 25.62 | 25.62 | 25.26 | 25.39 | 112200.0 |
| 2007-08-28 | DBE | ETF | 27.97 | 27.97 | 27.73 | 27.8 | 21700.0 |
| 2007-08-28 | DBO | ETF | 26.45 | 26.54 | 26.26 | 26.26 | 4600.0 |
| 2007-08-28 | DBP | ETF | 25.55 | 25.55 | 25.42 | 25.44 | 27700.0 |
| 2007-08-28 | DBS | ETF | 23.0401 | 23.39 | 23.0 | 23.11 | 10900.0 |
| 2007-08-28 | DBV | ETF | 27.47 | 27.58 | 27.22 | 27.33 | 173200.0 |
> showing 50 of 494 rows — these rows as CSV