PREVIEW / etf_daily / 2007-12-11
file: by_date/etf_daily/2007/2007-12-11.parquet size: 25 KB rows: 552
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-12-11 | SPY | ETF | 152.14 | 152.89 | 147.83 | 147.91 | 250346400.0 |
| 2007-12-11 | QQQ | ETF | 52.61 | 52.84 | 51.21 | 51.32 | 167064664.0 |
| 2007-12-11 | IWM | ETF | 79.28 | 79.58 | 76.25 | 76.35 | 120369300.0 |
| 2007-12-11 | DIA | ETF | 137.54 | 137.9 | 134.21 | 134.4 | 20363200.0 |
| 2007-12-11 | GLD | ETF | 79.75 | 80.46 | 78.68 | 78.84 | 9579200.0 |
| 2007-12-11 | TLT | ETF | 91.73 | 93.23 | 91.58 | 92.99 | 2892400.0 |
| 2007-12-11 | ADRE | ETF | 58.25 | 58.25 | 55.29 | 55.6 | 766003.0 |
| 2007-12-11 | AGG | ETF | 100.89 | 101.41 | 100.65 | 101.15 | 1153500.0 |
| 2007-12-11 | AIA | ETF | 50.2199 | 50.36 | 47.96 | 48.24 | 6100.0 |
| 2007-12-11 | AIQ | ETF | 49.25 | 49.85 | 46.75 | 47.0 | 34740.0 |
| 2007-12-11 | AIS | ETF | 1.12 | 1.15 | 1.07 | 1.08 | 92100.0 |
| 2007-12-11 | AIVI | ETF | 75.65 | 76.1 | 73.42 | 73.69 | 54400.0 |
| 2007-12-11 | ARB | ETF | 42.09 | 42.25 | 41.33 | 41.39 | 472700.0 |
| 2007-12-11 | BBH | ETF | 57.63 | 58.0 | 56.7667 | 56.7667 | 409500.0 |
| 2007-12-11 | BIL | ETF | 91.72 | 91.78 | 91.6 | 91.78 | 41800.0 |
| 2007-12-11 | BITS | ETF | 23.44 | 24.6 | 22.12 | 22.56 | 13160.0 |
| 2007-12-11 | BIV | ETF | 76.56 | 77.54 | 76.56 | 77.5 | 37300.0 |
| 2007-12-11 | BKF | ETF | 62.03 | 68.99 | 59.83 | 59.96 | 27200.0 |
| 2007-12-11 | BLV | ETF | 75.37 | 76.6 | 75.37 | 76.6 | 19300.0 |
| 2007-12-11 | BMVP | ETF | 17.6967 | 17.7133 | 17.2356 | 17.2467 | 45200.0 |
| 2007-12-11 | BND | ETF | 76.64 | 76.95 | 76.37 | 76.88 | 97200.0 |
| 2007-12-11 | BNE | ETF | 18.44 | 18.52 | 17.8 | 17.87 | 171440.0 |
| 2007-12-11 | BRF | ETF | 14.66 | 14.66 | 14.64 | 14.65 | 2200.0 |
| 2007-12-11 | BSV | ETF | 76.87 | 77.75 | 76.87 | 77.36 | 94200.0 |
| 2007-12-11 | BTF | ETF | 117.35 | 117.75 | 113.9 | 115.55 | 5180.0 |
| 2007-12-11 | BWX | ETF | 26.965 | 27.04 | 26.75 | 26.97 | 149440.0 |
| 2007-12-11 | CBON | ETF | 19.22 | 19.22 | 17.89 | 17.9 | 96175.0 |
| 2007-12-11 | CDL | ETF | 2.12 | 2.25 | 2.04 | 2.06 | 2807100.0 |
| 2007-12-11 | CEF | ETF | 10.65 | 10.74 | 10.52 | 10.58 | 351000.0 |
| 2007-12-11 | CGO | ETF | 19.49 | 19.49 | 19.04 | 19.1 | 18300.0 |
| 2007-12-11 | CGW | ETF | 26.45 | 26.45 | 25.5 | 25.5601 | 72600.0 |
| 2007-12-11 | CHB | ETF | 10.01 | 10.3 | 8.7 | 8.85 | 2011007.0 |
| 2007-12-11 | CHI | ETF | 14.38 | 14.44 | 14.0 | 14.03 | 316700.0 |
| 2007-12-11 | CHIC | ETF | 17.12 | 17.13 | 15.49 | 15.6 | 615973.0 |
| 2007-12-11 | CHW | ETF | 12.93 | 12.93 | 12.32 | 12.5 | 350400.0 |
| 2007-12-11 | CHY | ETF | 13.78 | 13.78 | 13.15 | 13.42 | 289300.0 |
| 2007-12-11 | CMF | ETF | 51.75 | 52.0 | 51.75 | 52.0 | 204.0 |
| 2007-12-11 | CN | ETF | 63.18 | 63.4099 | 60.95 | 61.2 | 230700.0 |
| 2007-12-11 | CNXT | ETF | 1.11 | 1.14 | 1.08 | 1.08 | 4200645.0 |
| 2007-12-11 | COW | ETF | 49.06 | 49.26 | 48.94 | 49.13 | 3300.0 |
| 2007-12-11 | CPI | ETF | 24.8 | 25.55 | 24.75 | 25.55 | 2300.0 |
| 2007-12-11 | CPST | ETF | 1.29 | 1.37 | 1.27 | 1.3199 | 2602216.0 |
| 2007-12-11 | CSA | ETF | 16.6 | 16.68 | 15.84 | 16.06 | 31400.0 |
| 2007-12-11 | CSD | ETF | 28.05 | 28.2 | 27.56 | 27.56 | 8900.0 |
| 2007-12-11 | CSQ | ETF | 14.53 | 14.54 | 14.11 | 14.17 | 359500.0 |
| 2007-12-11 | CUT | ETF | 25.35 | 25.45 | 24.67 | 24.67 | 38200.0 |
| 2007-12-11 | CVY | ETF | 24.97 | 24.97 | 24.2 | 24.23 | 13600.0 |
| 2007-12-11 | CWI | ETF | 29.6533 | 29.7067 | 28.68 | 28.68 | 903900.0 |
| 2007-12-11 | CZA | ETF | 26.64 | 26.65 | 26.64 | 26.65 | 1000.0 |
| 2007-12-11 | DBA | ETF | 32.2 | 32.35 | 31.72 | 32.18 | 526800.0 |
> showing 50 of 552 rows — these rows as CSV