PREVIEW / etf_daily / 2007-08-30
file: by_date/etf_daily/2007/2007-08-30.parquet size: 23 KB rows: 492
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-30 | SPY | ETF | 145.45 | 147.19 | 145.31 | 146.15 | 191817300.0 |
| 2007-08-30 | QQQ | ETF | 47.83 | 48.74 | 47.75 | 48.33 | 138929922.0 |
| 2007-08-30 | IWM | ETF | 77.62 | 78.95 | 77.5 | 78.03 | 63330500.0 |
| 2007-08-30 | DIA | ETF | 131.91 | 133.1 | 131.75 | 132.57 | 12705200.0 |
| 2007-08-30 | GLD | ETF | 65.87 | 66.1 | 65.63 | 65.8 | 3027700.0 |
| 2007-08-30 | TLT | ETF | 88.61 | 88.96 | 88.47 | 88.81 | 1806800.0 |
| 2007-08-30 | ADRE | ETF | 44.96 | 45.8999 | 44.92 | 45.26 | 129865.0 |
| 2007-08-30 | AGG | ETF | 99.74 | 99.83 | 99.64 | 99.76 | 186400.0 |
| 2007-08-30 | AIQ | ETF | 45.15 | 45.4 | 44.6 | 44.95 | 6880.0 |
| 2007-08-30 | AIS | ETF | 1.47 | 1.5 | 1.43 | 1.48 | 105500.0 |
| 2007-08-30 | ARB | ETF | 49.1 | 49.68 | 48.7 | 49.49 | 338800.0 |
| 2007-08-30 | BBH | ETF | 54.3867 | 54.6967 | 54.1733 | 54.43 | 255300.0 |
| 2007-08-30 | BIL | ETF | 92.04 | 92.04 | 91.92 | 92.0 | 31650.0 |
| 2007-08-30 | BITS | ETF | 26.0 | 26.16 | 25.72 | 25.88 | 4520.0 |
| 2007-08-30 | BIV | ETF | 75.49 | 75.62 | 75.44 | 75.57 | 11600.0 |
| 2007-08-30 | BLV | ETF | 74.62 | 74.84 | 74.62 | 74.77 | 2700.0 |
| 2007-08-30 | BMVP | ETF | 16.6967 | 16.83 | 16.6767 | 16.74 | 81400.0 |
| 2007-08-30 | BND | ETF | 75.47 | 75.52 | 75.41 | 75.48 | 44500.0 |
| 2007-08-30 | BNE | ETF | 16.47 | 17.0 | 16.47 | 16.71 | 178100.0 |
| 2007-08-30 | BRF | ETF | 14.65 | 14.65 | 14.55 | 14.55 | 200.0 |
| 2007-08-30 | BSV | ETF | 75.96 | 75.99 | 75.88 | 75.96 | 67100.0 |
| 2007-08-30 | BTF | ETF | 105.74999999999999 | 106.25 | 105.64999999999999 | 105.99999999999999 | 320.0 |
| 2007-08-30 | CBON | ETF | 24.65 | 24.99 | 23.83 | 24.54 | 93332.0 |
| 2007-08-30 | CDL | ETF | 4.19 | 4.19 | 3.95 | 4.01 | 2967700.0 |
| 2007-08-30 | CEF | ETF | 9.12 | 9.12 | 9.0 | 9.02 | 111100.0 |
| 2007-08-30 | CGO | ETF | 16.76 | 16.89 | 16.71 | 16.74 | 11500.0 |
| 2007-08-30 | CGW | ETF | 24.46 | 24.9 | 24.36 | 24.7 | 183500.0 |
| 2007-08-30 | CHB | ETF | 10.82 | 11.4 | 10.69 | 11.3 | 1707200.0 |
| 2007-08-30 | CHI | ETF | 16.26 | 16.57 | 16.1 | 16.19 | 156700.0 |
| 2007-08-30 | CHIC | ETF | 17.226 | 17.23 | 16.7 | 17.0 | 349174.0 |
| 2007-08-30 | CHW | ETF | 13.6 | 13.92 | 13.5 | 13.75 | 65100.0 |
| 2007-08-30 | CHY | ETF | 14.25 | 14.45 | 14.08 | 14.11 | 176500.0 |
| 2007-08-30 | CN | ETF | 48.63 | 49.64 | 48.16 | 48.71 | 145800.0 |
| 2007-08-30 | CNXT | ETF | 1.08 | 1.09 | 1.05 | 1.08 | 8809457.0 |
| 2007-08-30 | CPI | ETF | 24.8 | 24.8 | 24.8 | 24.8 | 200.0 |
| 2007-08-30 | CPST | ETF | 1.15 | 1.17 | 1.11 | 1.14 | 1479054.0 |
| 2007-08-30 | CSA | ETF | 17.25 | 17.64 | 17.25 | 17.48 | 25900.0 |
| 2007-08-30 | CSD | ETF | 28.51 | 28.81 | 28.51 | 28.61 | 15800.0 |
| 2007-08-30 | CSQ | ETF | 14.34 | 14.34 | 14.13 | 14.2 | 231100.0 |
| 2007-08-30 | CTEC | ETF | 100.15 | 102.2 | 100.05 | 101.75 | 35793.8 |
| 2007-08-30 | CVY | ETF | 25.7 | 25.91 | 25.69 | 25.76 | 14700.0 |
| 2007-08-30 | CWI | ETF | 26.08 | 26.4933 | 26.08 | 26.2467 | 594900.0 |
| 2007-08-30 | DBA | ETF | 26.87 | 27.05 | 26.67 | 26.89 | 141200.0 |
| 2007-08-30 | DBB | ETF | 25.34 | 25.52 | 25.25 | 25.52 | 16700.0 |
| 2007-08-30 | DBC | ETF | 26.39 | 26.39 | 25.44 | 25.68 | 182500.0 |
| 2007-08-30 | DBE | ETF | 28.16 | 28.25 | 28.0 | 28.23 | 6600.0 |
| 2007-08-30 | DBO | ETF | 26.55 | 26.57 | 26.46 | 26.46 | 2100.0 |
| 2007-08-30 | DBP | ETF | 25.39 | 25.61 | 25.39 | 25.5 | 2800.0 |
| 2007-08-30 | DBS | ETF | 23.16 | 23.32 | 23.16 | 23.21 | 4200.0 |
| 2007-08-30 | DBV | ETF | 27.42 | 27.621 | 27.42 | 27.55 | 121400.0 |
> showing 50 of 492 rows — these rows as CSV