PREVIEW / etf_daily / 2001-06-11
file: by_date/etf_daily/2001/2001-06-11.parquet size: 8 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-11 | SPY | ETF | 126.71 | 126.99 | 125.41 | 126.1 | 7012200.0 |
| 2001-06-11 | QQQ | ETF | 46.9 | 48.47 | 45.49 | 46.05 | 48874400.0 |
| 2001-06-11 | IWM | ETF | 50.95 | 50.95 | 50.25 | 50.275 | 513400.0 |
| 2001-06-11 | DIA | ETF | 109.55 | 109.85 | 108.8 | 109.35 | 2264700.0 |
| 2001-06-11 | BBH | ETF | 45.7667 | 45.8333 | 44.0533 | 44.5667 | 4559400.0 |
| 2001-06-11 | BITS | ETF | 10.68 | 10.72 | 9.52 | 9.64 | 5575.0 |
| 2001-06-11 | BOSS | ETF | 33.0 | 33.6 | 33.0 | 33.6 | 100.0 |
| 2001-06-11 | CEF | ETF | 3.3 | 3.32 | 3.26 | 3.28 | 6900.0 |
| 2001-06-11 | CHB | ETF | 10.64 | 10.85 | 10.54 | 10.61 | 58700.0 |
| 2001-06-11 | CNXT | ETF | 9.5 | 9.52 | 8.94 | 9.0 | 2131200.0 |
| 2001-06-11 | DGT | ETF | 72.59 | 72.59 | 72.4 | 72.4 | 200.0 |
| 2001-06-11 | EWA | ETF | 10.0 | 10.0 | 9.85 | 9.87 | 6000.0 |
| 2001-06-11 | EWC | ETF | 12.01 | 12.15 | 11.92 | 12.0 | 2800.0 |
| 2001-06-11 | EWD | ETF | 13.7 | 13.7 | 13.4 | 13.5 | 1300.0 |
| 2001-06-11 | EWG | ETF | 16.9 | 16.9 | 16.73 | 16.73 | 48200.0 |
| 2001-06-11 | EWH | ETF | 10.75 | 10.79 | 10.71 | 10.72 | 6200.0 |
| 2001-06-11 | EWI | ETF | 37.2 | 37.2 | 37.0 | 37.2 | 1100.0 |
| 2001-06-11 | EWJ | ETF | 42.44 | 42.44 | 41.8 | 42.0 | 70775.0 |
| 2001-06-11 | EWK | ETF | 11.25 | 11.25 | 10.95 | 11.0 | 2500.0 |
| 2001-06-11 | EWL | ETF | 13.95 | 13.95 | 13.65 | 13.85 | 2200.0 |
| 2001-06-11 | EWM | ETF | 16.52 | 16.6 | 16.48 | 16.48 | 3075.0 |
| 2001-06-11 | EWN | ETF | 19.65 | 19.65 | 19.57 | 19.57 | 2700.0 |
| 2001-06-11 | EWP | ETF | 22.63 | 22.71 | 22.6 | 22.6 | 10900.0 |
| 2001-06-11 | EWQ | ETF | 20.65 | 20.7 | 20.57 | 20.6 | 40400.0 |
| 2001-06-11 | EWS | ETF | 10.94 | 10.94 | 10.84 | 10.84 | 6700.0 |
| 2001-06-11 | EWT | ETF | 21.96 | 21.98 | 21.8 | 21.8 | 800.0 |
| 2001-06-11 | EWU | ETF | 32.28 | 32.34 | 31.76 | 32.06 | 34900.0 |
| 2001-06-11 | EWW | ETF | 17.0 | 17.0 | 16.67 | 16.79 | 11900.0 |
| 2001-06-11 | EWY | ETF | 14.85 | 14.87 | 14.79 | 14.79 | 4400.0 |
| 2001-06-11 | EWZ | ETF | 14.9 | 14.9 | 14.64 | 14.64 | 2700.0 |
| 2001-06-11 | EZU | ETF | 31.0 | 31.265 | 30.935 | 31.175 | 6400.0 |
| 2001-06-11 | FCTR | ETF | 16.63 | 16.73 | 16.6 | 16.62 | 10200.0 |
| 2001-06-11 | FMAR | ETF | 6.99 | 7.0 | 6.68 | 7.0 | 600.0 |
| 2001-06-11 | GLDB | ETF | 7.1 | 7.13 | 7.05 | 7.09 | 21100.0 |
| 2001-06-11 | GSIG | ETF | 9.6 | 9.6 | 9.11 | 9.37 | 170700.0 |
| 2001-06-11 | IBB | ETF | 34.9667 | 34.9667 | 33.5 | 33.9333 | 932100.0 |
| 2001-06-11 | IDU | ETF | 40.525 | 40.915 | 40.52 | 40.915 | 4600.0 |
| 2001-06-11 | IEV | ETF | 32.625 | 32.625 | 32.13 | 32.175 | 19800.0 |
| 2001-06-11 | IGLD | ETF | 78.0 | 80.0 | 75.0 | 78.0 | 136.0 |
| 2001-06-11 | IGM | ETF | 10.025 | 10.03 | 10.025 | 10.03 | 7800.0 |
| 2001-06-11 | IJH | ETF | 10.6 | 10.6 | 10.453 | 10.499 | 503000.0 |
| 2001-06-11 | IJJ | ETF | 23.0725 | 23.0725 | 22.7925 | 22.8825 | 76400.0 |
| 2001-06-11 | IJK | ETF | 15.1112 | 15.1112 | 14.8862 | 14.8862 | 208800.0 |
| 2001-06-11 | IJR | ETF | 19.0567 | 19.0783 | 18.8417 | 18.9583 | 815400.0 |
| 2001-06-11 | IJS | ETF | 21.235 | 21.235 | 21.0375 | 21.1 | 65600.0 |
| 2001-06-11 | IJT | ETF | 19.38 | 19.38 | 19.065 | 19.2 | 19200.0 |
| 2001-06-11 | IOO | ETF | 32.54 | 32.54 | 32.31 | 32.325 | 9800.0 |
| 2001-06-11 | IUSG | ETF | 23.175 | 23.175 | 22.86 | 22.91 | 96400.0 |
| 2001-06-11 | IUSV | ETF | 25.32 | 25.3767 | 25.2633 | 25.3633 | 8400.0 |
| 2001-06-11 | IVE | ETF | 63.37 | 63.56 | 62.91 | 63.2 | 133000.0 |
> showing 50 of 97 rows — these rows as CSV