PREVIEW / etf_daily / 2007-11-28
file: by_date/etf_daily/2007/2007-11-28.parquet size: 24 KB rows: 541
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-11-28 | SPY | ETF | 144.19 | 147.47 | 144.14 | 147.13 | 258596900.0 |
| 2007-11-28 | QQQ | ETF | 50.63 | 51.7 | 50.6 | 51.48 | 216868008.0 |
| 2007-11-28 | IWM | ETF | 74.91 | 76.89 | 74.86 | 76.87 | 112697000.0 |
| 2007-11-28 | DIA | ETF | 130.48 | 133.25 | 130.41 | 132.83 | 17995800.0 |
| 2007-11-28 | GLD | ETF | 79.42 | 79.87 | 78.76 | 79.57 | 9706700.0 |
| 2007-11-28 | TLT | ETF | 94.56 | 94.69 | 93.84 | 94.03 | 2088100.0 |
| 2007-11-28 | ADRE | ETF | 52.77 | 54.8 | 52.77 | 54.8 | 748851.0 |
| 2007-11-28 | AGG | ETF | 101.62 | 101.76 | 101.42 | 101.5 | 536500.0 |
| 2007-11-28 | AIA | ETF | 48.55 | 49.28 | 48.33 | 49.28 | 15900.0 |
| 2007-11-28 | AIQ | ETF | 46.65 | 49.9 | 46.4 | 49.15 | 57460.0 |
| 2007-11-28 | AIS | ETF | 1.05 | 1.08 | 1.04 | 1.04 | 127300.0 |
| 2007-11-28 | AIVI | ETF | 72.91 | 74.75 | 72.91 | 74.66 | 22500.0 |
| 2007-11-28 | ARB | ETF | 41.83 | 43.15 | 39.82 | 40.6 | 1761618.0 |
| 2007-11-28 | BBH | ETF | 59.3867 | 59.69 | 58.7067 | 59.5833 | 755400.0 |
| 2007-11-28 | BIL | ETF | 91.92 | 91.96 | 91.84 | 91.94 | 52700.0 |
| 2007-11-28 | BITS | ETF | 21.4 | 22.24 | 20.84 | 20.92 | 18372.0 |
| 2007-11-28 | BIV | ETF | 77.67 | 77.67 | 77.32 | 77.5 | 33000.0 |
| 2007-11-28 | BKF | ETF | 56.8 | 58.63 | 56.8 | 58.6 | 16500.0 |
| 2007-11-28 | BLV | ETF | 77.71 | 77.88 | 77.45 | 77.57 | 10500.0 |
| 2007-11-28 | BMVP | ETF | 16.55 | 17.06 | 16.55 | 17.06 | 43600.0 |
| 2007-11-28 | BND | ETF | 77.04 | 77.05 | 76.82 | 76.96 | 73100.0 |
| 2007-11-28 | BNE | ETF | 16.47 | 17.18 | 16.47 | 17.15 | 300100.0 |
| 2007-11-28 | BRF | ETF | 14.65 | 14.65 | 14.6 | 14.61 | 18200.0 |
| 2007-11-28 | BSV | ETF | 77.34 | 77.34 | 77.06 | 77.17 | 87000.0 |
| 2007-11-28 | BTF | ETF | 111.85 | 114.0 | 110.99999999999999 | 113.75 | 5480.0 |
| 2007-11-28 | BWX | ETF | 27.3 | 27.3 | 27.06 | 27.18 | 149000.0 |
| 2007-11-28 | CBON | ETF | 18.23 | 19.2 | 17.9 | 19.17 | 94344.0 |
| 2007-11-28 | CDL | ETF | 2.22 | 2.34 | 2.17 | 2.29 | 2853986.0 |
| 2007-11-28 | CEF | ETF | 10.68 | 10.71 | 10.5 | 10.67 | 421900.0 |
| 2007-11-28 | CGO | ETF | 17.98 | 18.4 | 17.98 | 18.37 | 22200.0 |
| 2007-11-28 | CGW | ETF | 25.15 | 25.72 | 24.93 | 25.635 | 70400.0 |
| 2007-11-28 | CHB | ETF | 8.64 | 9.23 | 8.4 | 9.13 | 1590469.0 |
| 2007-11-28 | CHI | ETF | 13.8 | 14.52 | 13.8 | 14.19 | 326666.0 |
| 2007-11-28 | CHIC | ETF | 15.15 | 16.16 | 15.15 | 15.97 | 626964.0 |
| 2007-11-28 | CHW | ETF | 12.0 | 12.2 | 11.92 | 12.15 | 414269.0 |
| 2007-11-28 | CHY | ETF | 12.46 | 13.09 | 12.46 | 12.9 | 314402.0 |
| 2007-11-28 | CMF | ETF | 52.25 | 52.32 | 52.25 | 52.32 | 3200.0 |
| 2007-11-28 | CN | ETF | 58.1 | 61.61 | 57.62 | 61.09 | 545800.0 |
| 2007-11-28 | CNXT | ETF | 1.14 | 1.17 | 1.12 | 1.16 | 4896164.0 |
| 2007-11-28 | COW | ETF | 49.0 | 49.0 | 48.71 | 48.71 | 500.0 |
| 2007-11-28 | CPI | ETF | 25.0 | 25.0 | 25.0 | 25.0 | 100.0 |
| 2007-11-28 | CPST | ETF | 1.2 | 1.22 | 1.19 | 1.21 | 887154.0 |
| 2007-11-28 | CSA | ETF | 16.06 | 16.18 | 15.81 | 15.86 | 174000.0 |
| 2007-11-28 | CSD | ETF | 26.5 | 26.89 | 26.48 | 26.89 | 3300.0 |
| 2007-11-28 | CSQ | ETF | 13.28 | 13.88 | 13.28 | 13.74 | 567201.0 |
| 2007-11-28 | CUT | ETF | 24.2 | 24.45 | 24.2 | 24.45 | 9900.0 |
| 2007-11-28 | CVY | ETF | 23.91 | 24.32 | 23.91 | 24.32 | 18600.0 |
| 2007-11-28 | CWI | ETF | 28.1133 | 28.76 | 28.1133 | 28.74 | 92550.0 |
| 2007-11-28 | CZA | ETF | 25.54 | 25.87 | 25.54 | 25.87 | 200.0 |
| 2007-11-28 | DBA | ETF | 30.64 | 30.81 | 30.26 | 30.74 | 521700.0 |
> showing 50 of 541 rows — these rows as CSV