PREVIEW / etf_daily / 2007-09-24
file: by_date/etf_daily/2007/2007-09-24.parquet size: 23 KB rows: 497
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-24 | SPY | ETF | 152.42 | 152.82 | 151.36 | 151.69 | 139450200.0 |
| 2007-09-24 | QQQ | ETF | 50.49 | 50.96 | 50.33 | 50.59 | 107226720.0 |
| 2007-09-24 | IWM | ETF | 81.1 | 81.37 | 80.09 | 80.34 | 87072300.0 |
| 2007-09-24 | DIA | ETF | 138.36 | 138.65 | 137.37 | 137.55 | 9445500.0 |
| 2007-09-24 | GLD | ETF | 72.57 | 72.63 | 71.82 | 72.28 | 6475100.0 |
| 2007-09-24 | TLT | ETF | 88.03 | 88.28 | 87.91 | 88.14 | 1943600.0 |
| 2007-09-24 | ADRE | ETF | 51.01 | 51.33 | 50.92 | 51.26 | 261850.0 |
| 2007-09-24 | AGG | ETF | 99.73 | 99.74 | 99.5 | 99.72 | 274000.0 |
| 2007-09-24 | AIQ | ETF | 46.75 | 46.75 | 44.6 | 44.95 | 27060.0 |
| 2007-09-24 | AIS | ETF | 1.42 | 1.42 | 1.3816 | 1.42 | 153800.0 |
| 2007-09-24 | ARB | ETF | 46.68 | 47.68 | 46.49 | 47.25 | 228800.0 |
| 2007-09-24 | BBH | ETF | 58.5633 | 58.7167 | 58.2933 | 58.6233 | 161400.0 |
| 2007-09-24 | BIL | ETF | 91.92 | 91.94 | 91.8 | 91.9 | 57850.0 |
| 2007-09-24 | BITS | ETF | 26.44 | 26.4804 | 25.68 | 25.92 | 15906.0 |
| 2007-09-24 | BIV | ETF | 75.18 | 75.3 | 75.13 | 75.3 | 20400.0 |
| 2007-09-24 | BLV | ETF | 74.31 | 74.52 | 74.3 | 74.52 | 11800.0 |
| 2007-09-24 | BMVP | ETF | 17.1267 | 17.1767 | 17.025 | 17.03 | 89100.0 |
| 2007-09-24 | BND | ETF | 75.4 | 75.46 | 75.35 | 75.43 | 121500.0 |
| 2007-09-24 | BNE | ETF | 16.7 | 17.19 | 16.61 | 16.82 | 226200.0 |
| 2007-09-24 | BRF | ETF | 14.59 | 14.6 | 14.59 | 14.59 | 15600.0 |
| 2007-09-24 | BSV | ETF | 75.91 | 75.98 | 75.88 | 75.97 | 14100.0 |
| 2007-09-24 | BTF | ETF | 107.3 | 107.39999999999999 | 105.44999999999999 | 105.44999999999999 | 3400.0 |
| 2007-09-24 | CBON | ETF | 26.0 | 26.0 | 25.07 | 25.1 | 45311.0 |
| 2007-09-24 | CDL | ETF | 4.24 | 4.3201 | 4.17 | 4.21 | 1617900.0 |
| 2007-09-24 | CEF | ETF | 9.74 | 9.74 | 9.65 | 9.7 | 402000.0 |
| 2007-09-24 | CGO | ETF | 17.51 | 17.63 | 17.48 | 17.53 | 15300.0 |
| 2007-09-24 | CGW | ETF | 25.17 | 25.29 | 25.05 | 25.2 | 93700.0 |
| 2007-09-24 | CHB | ETF | 11.17 | 11.68 | 11.05 | 11.21 | 2653300.0 |
| 2007-09-24 | CHI | ETF | 17.02 | 17.13 | 17.01 | 17.08 | 173900.0 |
| 2007-09-24 | CHIC | ETF | 16.98 | 17.49 | 16.98 | 17.0 | 353947.0 |
| 2007-09-24 | CHW | ETF | 13.79 | 13.87 | 13.35 | 13.5 | 263300.0 |
| 2007-09-24 | CHY | ETF | 15.1 | 15.12 | 14.95 | 15.1 | 164900.0 |
| 2007-09-24 | CN | ETF | 48.35 | 48.88 | 48.18 | 48.4 | 160200.0 |
| 2007-09-24 | CNXT | ETF | 1.23 | 1.26 | 1.2 | 1.21 | 5800929.0 |
| 2007-09-24 | CPI | ETF | 24.05 | 24.15 | 23.85 | 23.85 | 1700.0 |
| 2007-09-24 | CPST | ETF | 1.19 | 1.23 | 1.15 | 1.17 | 1258309.0 |
| 2007-09-24 | CSA | ETF | 17.99 | 18.36 | 17.99 | 18.25 | 41300.0 |
| 2007-09-24 | CSD | ETF | 29.2 | 29.24 | 28.99 | 28.99 | 28100.0 |
| 2007-09-24 | CSQ | ETF | 14.69 | 14.69 | 14.6 | 14.67 | 315834.0 |
| 2007-09-24 | CVY | ETF | 26.1 | 26.3 | 25.99 | 26.04 | 29500.0 |
| 2007-09-24 | CWI | ETF | 27.9533 | 28.0 | 27.8333 | 27.8333 | 117750.0 |
| 2007-09-24 | CZA | ETF | 26.03 | 26.03 | 26.03 | 26.03 | 5000.0 |
| 2007-09-24 | DBA | ETF | 28.97 | 29.0 | 28.62 | 28.83 | 529500.0 |
| 2007-09-24 | DBB | ETF | 25.68 | 25.91 | 25.64 | 25.91 | 14900.0 |
| 2007-09-24 | DBC | ETF | 27.63 | 27.79 | 27.51 | 27.64 | 181800.0 |
| 2007-09-24 | DBE | ETF | 30.77 | 31.0 | 30.46 | 30.65 | 28300.0 |
| 2007-09-24 | DBO | ETF | 29.49 | 29.56 | 29.36 | 29.44 | 18600.0 |
| 2007-09-24 | DBP | ETF | 28.2 | 28.29 | 28.0 | 28.14 | 16800.0 |
| 2007-09-24 | DBS | ETF | 26.54 | 26.63 | 26.38 | 26.38 | 19100.0 |
| 2007-09-24 | DBV | ETF | 27.99 | 28.05 | 27.95 | 28.05 | 89200.0 |
> showing 50 of 497 rows — these rows as CSV