PREVIEW / etf_daily / 2007-08-20
file: by_date/etf_daily/2007/2007-08-20.parquet size: 23 KB rows: 502
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-20 | SPY | ETF | 145.17 | 145.47 | 143.29 | 144.64 | 187320400.0 |
| 2007-08-20 | QQQ | ETF | 46.48 | 46.72 | 46.08 | 46.53 | 144715090.0 |
| 2007-08-20 | IWM | ETF | 78.67 | 79.07 | 77.47 | 78.47 | 126893400.0 |
| 2007-08-20 | DIA | ETF | 130.95 | 131.7 | 129.7 | 130.96 | 16906000.0 |
| 2007-08-20 | GLD | ETF | 65.06 | 65.4 | 64.78 | 65.12 | 4475200.0 |
| 2007-08-20 | TLT | ETF | 86.96 | 87.27 | 86.83 | 86.84 | 1048700.0 |
| 2007-08-20 | ADRE | ETF | 43.08 | 43.09 | 41.405 | 42.042 | 327613.0 |
| 2007-08-20 | AGG | ETF | 98.9 | 99.02 | 98.79 | 98.8 | 252400.0 |
| 2007-08-20 | AIQ | ETF | 42.85 | 43.7 | 42.15 | 43.15 | 44660.0 |
| 2007-08-20 | AIS | ETF | 1.34 | 1.34 | 1.28 | 1.31 | 129500.0 |
| 2007-08-20 | ARB | ETF | 52.05 | 52.06 | 50.5 | 51.26 | 237700.0 |
| 2007-08-20 | BBH | ETF | 53.86 | 53.9133 | 53.2633 | 53.72 | 448200.0 |
| 2007-08-20 | BIL | ETF | 91.92 | 92.1 | 91.92 | 92.04 | 19750.0 |
| 2007-08-20 | BITS | ETF | 25.6 | 25.8 | 25.12 | 25.24 | 8611.0 |
| 2007-08-20 | BIV | ETF | 74.87 | 75.01 | 74.83 | 74.86 | 19000.0 |
| 2007-08-20 | BLV | ETF | 73.34 | 73.76 | 73.34 | 73.55 | 12100.0 |
| 2007-08-20 | BMVP | ETF | 16.5433 | 16.5433 | 16.3033 | 16.4833 | 57000.0 |
| 2007-08-20 | BND | ETF | 74.97 | 75.07 | 74.7 | 74.71 | 66500.0 |
| 2007-08-20 | BNE | ETF | 15.8 | 16.24 | 15.68 | 16.0 | 349700.0 |
| 2007-08-20 | BRF | ETF | 14.55 | 14.5801 | 14.5 | 14.51 | 9100.0 |
| 2007-08-20 | BSV | ETF | 75.74 | 75.84 | 75.71 | 75.79 | 35600.0 |
| 2007-08-20 | BTF | ETF | 100.35 | 101.64999999999999 | 100.06 | 101.64999999999999 | 1040.0 |
| 2007-08-20 | CBON | ETF | 25.57 | 25.87 | 25.03 | 25.44 | 34916.0 |
| 2007-08-20 | CDL | ETF | 4.51 | 4.51 | 4.12 | 4.17 | 2265739.0 |
| 2007-08-20 | CEF | ETF | 9.12 | 9.13 | 8.96 | 9.04 | 396300.0 |
| 2007-08-20 | CGO | ETF | 15.9 | 16.02 | 15.596 | 15.74 | 32000.0 |
| 2007-08-20 | CGW | ETF | 23.6 | 23.61 | 23.22 | 23.57 | 107400.0 |
| 2007-08-20 | CHB | ETF | 10.69 | 11.04 | 10.58 | 10.73 | 2711551.0 |
| 2007-08-20 | CHI | ETF | 16.77 | 17.15 | 16.4501 | 16.53 | 260700.0 |
| 2007-08-20 | CHIC | ETF | 17.65 | 17.87 | 17.36 | 17.49 | 271598.0 |
| 2007-08-20 | CHW | ETF | 13.35 | 13.4 | 13.0 | 13.15 | 102000.0 |
| 2007-08-20 | CHY | ETF | 14.8 | 14.8 | 14.31 | 14.36 | 301900.0 |
| 2007-08-20 | CN | ETF | 46.75 | 47.18 | 45.89 | 46.6 | 179600.0 |
| 2007-08-20 | CNXT | ETF | 1.18 | 1.19 | 1.15 | 1.17 | 9583002.0 |
| 2007-08-20 | CPI | ETF | 26.8 | 26.8 | 26.35 | 26.8 | 1000.0 |
| 2007-08-20 | CPST | ETF | 1.0001 | 1.04 | 0.9811 | 1.01 | 713492.0 |
| 2007-08-20 | CSA | ETF | 17.01 | 17.25 | 16.9 | 17.0 | 50900.0 |
| 2007-08-20 | CSD | ETF | 28.1 | 28.17 | 27.82 | 28.02 | 29000.0 |
| 2007-08-20 | CSM | ETF | 1.3925 | 1.3925 | 1.3925 | 1.3925 | 800.0 |
| 2007-08-20 | CSQ | ETF | 13.75 | 14.19 | 13.64 | 14.19 | 390100.0 |
| 2007-08-20 | CTEC | ETF | 100.7 | 101.75 | 99.89999999999999 | 100.99999999999999 | 12361.6 |
| 2007-08-20 | CVY | ETF | 25.57 | 25.65 | 25.27 | 25.47 | 59500.0 |
| 2007-08-20 | CWI | ETF | 25.42 | 25.4533 | 25.0733 | 25.2933 | 146400.0 |
| 2007-08-20 | DBA | ETF | 25.85 | 26.0 | 25.64 | 25.9 | 104600.0 |
| 2007-08-20 | DBB | ETF | 25.16 | 25.16 | 24.73 | 24.74 | 30200.0 |
| 2007-08-20 | DBC | ETF | 25.02 | 25.24 | 24.94 | 25.23 | 269900.0 |
| 2007-08-20 | DBE | ETF | 27.81 | 27.82 | 27.54 | 27.82 | 39900.0 |
| 2007-08-20 | DBO | ETF | 26.34 | 26.39 | 25.56 | 26.1 | 24300.0 |
| 2007-08-20 | DBP | ETF | 25.29 | 25.39 | 25.2 | 25.24 | 22700.0 |
| 2007-08-20 | DBS | ETF | 23.37 | 23.37 | 23.098 | 23.1301 | 27800.0 |
> showing 50 of 502 rows — these rows as CSV