PREVIEW / etf_daily / 2007-10-08
file: by_date/etf_daily/2007/2007-10-08.parquet size: 23 KB rows: 508
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-10-08 | SPY | ETF | 155.39 | 155.49 | 154.77 | 155.02 | 71280400.0 |
| 2007-10-08 | QQQ | ETF | 52.8 | 53.16 | 52.71 | 53.15 | 63022360.0 |
| 2007-10-08 | IWM | ETF | 83.91 | 84.18 | 83.25 | 83.5 | 34535400.0 |
| 2007-10-08 | DIA | ETF | 140.56 | 140.58 | 140.01 | 140.26 | 5129400.0 |
| 2007-10-08 | GLD | ETF | 72.66 | 72.89 | 72.28 | 72.53 | 3447600.0 |
| 2007-10-08 | TLT | ETF | 87.77 | 88.5 | 87.77 | 88.21 | 280100.0 |
| 2007-10-08 | ADRE | ETF | 55.9 | 55.9 | 54.63 | 55.11 | 265280.0 |
| 2007-10-08 | AGG | ETF | 99.36 | 99.95 | 99.08 | 99.65 | 367700.0 |
| 2007-10-08 | AIQ | ETF | 47.75 | 47.8 | 46.05 | 46.4 | 18300.0 |
| 2007-10-08 | AIS | ETF | 1.38 | 1.38 | 1.32 | 1.35 | 160900.0 |
| 2007-10-08 | ARB | ETF | 46.39 | 47.06 | 46.17 | 46.72 | 128600.0 |
| 2007-10-08 | BBH | ETF | 59.1533 | 59.2333 | 58.84 | 59.0467 | 271500.0 |
| 2007-10-08 | BIL | ETF | 91.58 | 91.7 | 91.56 | 91.68 | 8300.0 |
| 2007-10-08 | BITS | ETF | 26.52 | 26.536 | 26.0 | 26.08 | 5950.0 |
| 2007-10-08 | BIV | ETF | 75.33 | 75.5 | 75.27 | 75.5 | 13200.0 |
| 2007-10-08 | BLV | ETF | 74.49 | 74.8 | 74.41 | 74.8 | 8200.0 |
| 2007-10-08 | BMVP | ETF | 17.62 | 17.64 | 17.56 | 17.58 | 53100.0 |
| 2007-10-08 | BND | ETF | 75.54 | 75.6 | 75.38 | 75.57 | 43600.0 |
| 2007-10-08 | BNE | ETF | 17.97 | 18.17 | 17.48 | 17.49 | 138300.0 |
| 2007-10-08 | BRF | ETF | 14.62 | 14.62 | 14.62 | 14.62 | 500.0 |
| 2007-10-08 | BSV | ETF | 75.62 | 75.9 | 75.62 | 75.84 | 21700.0 |
| 2007-10-08 | BTF | ETF | 108.94999999999999 | 109.3 | 108.6 | 109.3 | 620.0 |
| 2007-10-08 | BWX | ETF | 26.0 | 26.17 | 26.0 | 26.16 | 48800.0 |
| 2007-10-08 | CBON | ETF | 25.91 | 26.01 | 25.62 | 25.84 | 81060.0 |
| 2007-10-08 | CDL | ETF | 4.15 | 4.27 | 4.12 | 4.27 | 1512800.0 |
| 2007-10-08 | CEF | ETF | 9.71 | 9.84 | 9.7 | 9.76 | 229800.0 |
| 2007-10-08 | CGO | ETF | 18.03 | 18.1001 | 18.01 | 18.07 | 14600.0 |
| 2007-10-08 | CGW | ETF | 26.14 | 26.16 | 26.0 | 26.1 | 46100.0 |
| 2007-10-08 | CHB | ETF | 12.55 | 12.55 | 12.0 | 12.14 | 991000.0 |
| 2007-10-08 | CHI | ETF | 17.05 | 17.17 | 17.05 | 17.09 | 92300.0 |
| 2007-10-08 | CHIC | ETF | 14.4 | 15.76 | 14.33 | 15.51 | 1150812.0 |
| 2007-10-08 | CHW | ETF | 13.63 | 13.82 | 13.55 | 13.76 | 83400.0 |
| 2007-10-08 | CHY | ETF | 15.49 | 15.58 | 15.45 | 15.48 | 90200.0 |
| 2007-10-08 | CMF | ETF | 51.99 | 52.065 | 51.945 | 52.03 | 27400.0 |
| 2007-10-08 | CN | ETF | 60.5 | 61.39 | 59.76 | 61.05 | 264800.0 |
| 2007-10-08 | CNXT | ETF | 1.43 | 1.47 | 1.4 | 1.42 | 9127363.0 |
| 2007-10-08 | CPI | ETF | 23.75 | 24.05 | 23.75 | 24.05 | 300.0 |
| 2007-10-08 | CPST | ETF | 1.17 | 1.18 | 1.13 | 1.14 | 1873552.0 |
| 2007-10-08 | CSA | ETF | 18.87 | 18.87 | 18.5 | 18.68 | 40800.0 |
| 2007-10-08 | CSD | ETF | 29.8 | 29.94 | 29.8 | 29.93 | 16300.0 |
| 2007-10-08 | CSQ | ETF | 14.74 | 14.77 | 14.63 | 14.6925 | 214800.0 |
| 2007-10-08 | CVY | ETF | 26.79 | 26.79 | 26.62 | 26.65 | 10400.0 |
| 2007-10-08 | CWI | ETF | 28.9733 | 28.9733 | 28.8133 | 28.88 | 9000.0 |
| 2007-10-08 | CZA | ETF | 27.07 | 27.12 | 27.07 | 27.12 | 900.0 |
| 2007-10-08 | DBA | ETF | 28.22 | 28.23 | 27.61 | 27.78 | 284100.0 |
| 2007-10-08 | DBB | ETF | 25.62 | 25.86 | 25.51 | 25.86 | 28700.0 |
| 2007-10-08 | DBC | ETF | 28.49 | 28.49 | 27.0 | 27.17 | 193100.0 |
| 2007-10-08 | DBE | ETF | 30.3 | 30.4 | 29.77 | 29.88 | 7100.0 |
| 2007-10-08 | DBO | ETF | 29.21 | 29.21 | 28.62 | 28.74 | 7900.0 |
| 2007-10-08 | DBP | ETF | 28.23 | 28.23 | 28.06 | 28.15 | 12900.0 |
> showing 50 of 508 rows — these rows as CSV