PREVIEW / etf_daily / 2007-09-17
file: by_date/etf_daily/2007/2007-09-17.parquet size: 23 KB rows: 499
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-09-17 | SPY | ETF | 148.31 | 148.65 | 147.63 | 148.1 | 109870800.0 |
| 2007-09-17 | QQQ | ETF | 48.99 | 49.1 | 48.59 | 48.81 | 84882267.0 |
| 2007-09-17 | IWM | ETF | 77.88 | 78.12 | 77.19 | 77.23 | 53416800.0 |
| 2007-09-17 | DIA | ETF | 134.12 | 134.59 | 133.69 | 134.06 | 8774100.0 |
| 2007-09-17 | GLD | ETF | 70.4 | 71.24 | 70.35 | 70.97 | 7457800.0 |
| 2007-09-17 | TLT | ETF | 89.82 | 90.39 | 89.76 | 90.34 | 1285400.0 |
| 2007-09-17 | ADRE | ETF | 47.6 | 47.8 | 46.95 | 47.26 | 165981.0 |
| 2007-09-17 | AGG | ETF | 99.86 | 99.96 | 99.77 | 99.94 | 278000.0 |
| 2007-09-17 | AIQ | ETF | 43.3 | 44.75 | 43.2 | 44.2 | 17580.0 |
| 2007-09-17 | AIS | ETF | 1.39 | 1.42 | 1.3895 | 1.42 | 89800.0 |
| 2007-09-17 | ARB | ETF | 46.13 | 46.13 | 45.13 | 45.35 | 408700.0 |
| 2007-09-17 | BBH | ETF | 57.3333 | 57.3833 | 56.5833 | 56.9833 | 729900.0 |
| 2007-09-17 | BIL | ETF | 91.82 | 91.86 | 91.68 | 91.86 | 17350.0 |
| 2007-09-17 | BITS | ETF | 27.1984 | 27.32 | 26.8 | 26.92 | 6262.0 |
| 2007-09-17 | BIV | ETF | 75.44 | 75.56 | 75.42 | 75.55 | 16700.0 |
| 2007-09-17 | BLV | ETF | 75.13 | 75.36 | 75.06 | 75.36 | 6200.0 |
| 2007-09-17 | BMVP | ETF | 16.72 | 16.7567 | 16.6433 | 16.6767 | 48600.0 |
| 2007-09-17 | BND | ETF | 75.58 | 75.61 | 75.45 | 75.61 | 39300.0 |
| 2007-09-17 | BNE | ETF | 15.69 | 15.97 | 15.64 | 15.83 | 342600.0 |
| 2007-09-17 | BOSS | ETF | 46.02 | 47.05 | 46.02 | 47.05 | 200.0 |
| 2007-09-17 | BRF | ETF | 14.7 | 14.7 | 14.59 | 14.59 | 2300.0 |
| 2007-09-17 | BSV | ETF | 75.82 | 75.82 | 75.75 | 75.79 | 13700.0 |
| 2007-09-17 | BTF | ETF | 104.3 | 104.64999999999999 | 103.85 | 104.64999999999999 | 1680.0 |
| 2007-09-17 | CBON | ETF | 23.86 | 23.92 | 23.7 | 23.71 | 10789.0 |
| 2007-09-17 | CDL | ETF | 4.1 | 4.12 | 4.06 | 4.1 | 1411100.0 |
| 2007-09-17 | CEF | ETF | 9.5 | 9.5 | 9.36 | 9.4 | 750300.0 |
| 2007-09-17 | CGO | ETF | 16.95 | 17.04 | 16.82 | 16.98 | 14000.0 |
| 2007-09-17 | CGW | ETF | 24.43 | 24.542 | 24.28 | 24.47 | 38200.0 |
| 2007-09-17 | CHB | ETF | 11.39 | 11.55 | 11.01 | 11.43 | 1305000.0 |
| 2007-09-17 | CHI | ETF | 16.35 | 16.35 | 16.01 | 16.12 | 124600.0 |
| 2007-09-17 | CHIC | ETF | 17.1 | 17.13 | 16.76 | 17.01 | 267492.0 |
| 2007-09-17 | CHW | ETF | 13.24 | 13.29 | 12.93 | 13.06 | 93200.0 |
| 2007-09-17 | CHY | ETF | 14.31 | 14.31 | 14.15 | 14.199 | 142200.0 |
| 2007-09-17 | CN | ETF | 46.74 | 47.09 | 46.3 | 46.8 | 119700.0 |
| 2007-09-17 | CNXT | ETF | 1.23 | 1.27 | 1.21 | 1.22 | 4118440.0 |
| 2007-09-17 | CPI | ETF | 24.4 | 24.6075 | 24.4 | 24.6075 | 300.0 |
| 2007-09-17 | CPST | ETF | 1.18 | 1.24 | 1.18 | 1.23 | 1699855.0 |
| 2007-09-17 | CSA | ETF | 18.82 | 19.24 | 18.66 | 18.87 | 42000.0 |
| 2007-09-17 | CSD | ETF | 28.44 | 28.44 | 28.08 | 28.08 | 28300.0 |
| 2007-09-17 | CSM | ETF | 1.45 | 1.45 | 1.45 | 1.45 | 4800.0 |
| 2007-09-17 | CSQ | ETF | 14.01 | 14.08 | 13.81 | 13.99 | 297725.0 |
| 2007-09-17 | CVY | ETF | 25.84 | 25.84 | 25.78 | 25.82 | 4100.0 |
| 2007-09-17 | CWI | ETF | 26.6067 | 26.6667 | 26.42 | 26.5067 | 22950.0 |
| 2007-09-17 | DBA | ETF | 27.58 | 27.75 | 27.4 | 27.57 | 131700.0 |
| 2007-09-17 | DBB | ETF | 24.95 | 24.97 | 24.61 | 24.84 | 49700.0 |
| 2007-09-17 | DBC | ETF | 26.57 | 26.75 | 26.47 | 26.75 | 124300.0 |
| 2007-09-17 | DBE | ETF | 29.6 | 30.08 | 29.6 | 30.08 | 23400.0 |
| 2007-09-17 | DBO | ETF | 28.33 | 28.71 | 28.33 | 28.55 | 40100.0 |
| 2007-09-17 | DBP | ETF | 27.36 | 27.53 | 27.34 | 27.53 | 21000.0 |
| 2007-09-17 | DBS | ETF | 25.02 | 25.17 | 24.89 | 25.16 | 5500.0 |
> showing 50 of 499 rows — these rows as CSV