PREVIEW / etf_daily / 2007-12-10
file: by_date/etf_daily/2007/2007-12-10.parquet size: 25 KB rows: 546
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-10 | SPY | ETF | 151.28 | 152.25 | 150.86 | 152.08 | 123914300.0 |
| 2007-12-10 | QQQ | ETF | 52.44 | 52.69 | 52.32 | 52.54 | 75657874.0 |
| 2007-12-10 | IWM | ETF | 78.5 | 79.25 | 78.2 | 79.11 | 49937400.0 |
| 2007-12-10 | DIA | ETF | 136.78 | 137.63 | 136.51 | 137.4 | 7327600.0 |
| 2007-12-10 | GLD | ETF | 79.15 | 80.3 | 79.13 | 80.0 | 4850900.0 |
| 2007-12-10 | TLT | ETF | 91.64 | 91.69 | 90.75 | 91.2 | 2242500.0 |
| 2007-12-10 | ADRE | ETF | 57.54 | 57.72 | 57.12 | 57.39 | 546976.0 |
| 2007-12-10 | AGG | ETF | 100.88 | 100.88 | 100.32 | 100.66 | 916400.0 |
| 2007-12-10 | AIA | ETF | 51.26 | 51.26 | 49.59 | 50.0 | 6300.0 |
| 2007-12-10 | AIQ | ETF | 48.3 | 49.1 | 48.15 | 49.0 | 37420.0 |
| 2007-12-10 | AIS | ETF | 1.12 | 1.16 | 1.11 | 1.13 | 43000.0 |
| 2007-12-10 | AIVI | ETF | 75.57 | 75.96 | 75.46 | 75.89 | 50600.0 |
| 2007-12-10 | ARB | ETF | 42.01 | 42.17 | 41.6 | 41.89 | 388616.0 |
| 2007-12-10 | BBH | ETF | 57.3867 | 57.6467 | 57.06 | 57.59 | 661800.0 |
| 2007-12-10 | BIL | ETF | 91.72 | 94.24 | 91.66 | 91.66 | 206050.0 |
| 2007-12-10 | BITS | ETF | 21.56 | 23.32 | 21.56 | 23.24 | 9386.0 |
| 2007-12-10 | BIV | ETF | 76.85 | 76.89 | 76.58 | 76.69 | 25100.0 |
| 2007-12-10 | BKF | ETF | 61.49 | 62.11 | 61.35 | 61.69 | 21800.0 |
| 2007-12-10 | BLV | ETF | 75.68 | 75.68 | 75.02 | 75.35 | 3600.0 |
| 2007-12-10 | BMVP | ETF | 17.5567 | 17.6767 | 17.5567 | 17.67 | 40200.0 |
| 2007-12-10 | BND | ETF | 76.55 | 76.58 | 76.23 | 76.37 | 84600.0 |
| 2007-12-10 | BNE | ETF | 18.44 | 18.47 | 18.13 | 18.31 | 166500.0 |
| 2007-12-10 | BRF | ETF | 14.64 | 14.64 | 14.63 | 14.63 | 6200.0 |
| 2007-12-10 | BSV | ETF | 76.98 | 77.04 | 76.87 | 76.96 | 109100.0 |
| 2007-12-10 | BTF | ETF | 116.85 | 117.69999999999999 | 116.85 | 117.39999999999999 | 1040.0 |
| 2007-12-10 | BWX | ETF | 26.605 | 26.82 | 26.605 | 26.81 | 126400.0 |
| 2007-12-10 | CBON | ETF | 18.01 | 19.17 | 17.94 | 19.1 | 100345.0 |
| 2007-12-10 | CDL | ETF | 1.99 | 2.15 | 1.99 | 2.1 | 3426844.0 |
| 2007-12-10 | CEF | ETF | 10.65 | 10.75 | 10.58 | 10.63 | 355300.0 |
| 2007-12-10 | CGO | ETF | 19.9 | 19.9 | 18.92 | 19.44 | 48200.0 |
| 2007-12-10 | CGW | ETF | 25.88 | 26.3 | 25.88 | 26.3 | 109910.0 |
| 2007-12-10 | CHB | ETF | 9.43 | 10.15 | 9.304 | 9.97 | 1985906.0 |
| 2007-12-10 | CHI | ETF | 14.56 | 14.65 | 14.35 | 14.4 | 307800.0 |
| 2007-12-10 | CHIC | ETF | 16.54 | 17.1599 | 16.53 | 17.1 | 457180.0 |
| 2007-12-10 | CHW | ETF | 12.71 | 12.92 | 12.54 | 12.89 | 358600.0 |
| 2007-12-10 | CHY | ETF | 13.79 | 13.85 | 13.5 | 13.63 | 300200.0 |
| 2007-12-10 | CMF | ETF | 51.585 | 51.775 | 51.585 | 51.775 | 2400.0 |
| 2007-12-10 | CN | ETF | 61.06 | 62.67 | 61.06 | 61.87 | 273300.0 |
| 2007-12-10 | CNXT | ETF | 1.08 | 1.15 | 1.08 | 1.11 | 5925235.0 |
| 2007-12-10 | COW | ETF | 48.62 | 49.23 | 48.58 | 49.2 | 11700.0 |
| 2007-12-10 | CPI | ETF | 24.8 | 25.15 | 24.8 | 25.1 | 8700.0 |
| 2007-12-10 | CPST | ETF | 1.35 | 1.37 | 1.27 | 1.28 | 2358994.0 |
| 2007-12-10 | CSA | ETF | 16.26 | 16.65 | 16.17 | 16.65 | 29300.0 |
| 2007-12-10 | CSD | ETF | 27.87 | 28.1 | 27.87 | 28.1 | 40100.0 |
| 2007-12-10 | CSQ | ETF | 14.45 | 14.54 | 14.372 | 14.54 | 349700.0 |
| 2007-12-10 | CUT | ETF | 25.25 | 25.3 | 25.18 | 25.21 | 18400.0 |
| 2007-12-10 | CVY | ETF | 24.69 | 25.03 | 24.69 | 24.97 | 5000.0 |
| 2007-12-10 | CWI | ETF | 29.1667 | 29.4133 | 29.1667 | 29.4133 | 370800.0 |
| 2007-12-10 | CZA | ETF | 26.51 | 26.64 | 26.51 | 26.596 | 5200.0 |
| 2007-12-10 | DBA | ETF | 32.5 | 32.5 | 31.95 | 32.19 | 596800.0 |
> showing 50 of 546 rows — these rows as CSV