PREVIEW / etf_daily / 2001-04-02
file: by_date/etf_daily/2001/2001-04-02.parquet size: 8 KB rows: 92
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-04-02 | SPY | ETF | 116.3 | 117.38 | 113.8 | 114.2 | 10561000.0 |
| 2001-04-02 | QQQ | ETF | 39.17 | 39.85 | 37.3 | 37.4 | 69713600.0 |
| 2001-04-02 | IWM | ETF | 44.775 | 45.0 | 43.675 | 43.75 | 340200.0 |
| 2001-04-02 | DIA | ETF | 98.4 | 99.97 | 97.02 | 97.39 | 8406800.0 |
| 2001-04-02 | BBH | ETF | 37.6667 | 37.99 | 35.4667 | 35.8133 | 3904200.0 |
| 2001-04-02 | BITS | ETF | 7.25 | 8.125 | 7.0 | 8.0 | 3800.0 |
| 2001-04-02 | CEF | ETF | 3.04 | 3.08 | 3.02 | 3.04 | 51900.0 |
| 2001-04-02 | CHB | ETF | 5.14 | 5.45 | 4.95 | 5.09 | 305800.0 |
| 2001-04-02 | CNXT | ETF | 9.16 | 9.34 | 7.66 | 7.94 | 2853420.0 |
| 2001-04-02 | CSB | ETF | 1.5 | 1.5 | 1.5 | 1.5 | 212000.0 |
| 2001-04-02 | EWA | ETF | 8.45 | 8.45 | 8.3 | 8.39 | 2600.0 |
| 2001-04-02 | EWC | ETF | 10.85 | 10.86 | 10.7 | 10.85 | 3800.0 |
| 2001-04-02 | EWD | ETF | 13.0 | 13.0 | 12.6 | 12.6 | 26100.0 |
| 2001-04-02 | EWG | ETF | 16.4 | 16.5 | 16.2 | 16.29 | 42200.0 |
| 2001-04-02 | EWH | ETF | 10.51 | 10.59 | 10.41 | 10.43 | 17000.0 |
| 2001-04-02 | EWI | ETF | 38.5 | 38.5 | 38.1 | 38.1 | 3800.0 |
| 2001-04-02 | EWJ | ETF | 40.44 | 40.64 | 40.0 | 40.24 | 79575.0 |
| 2001-04-02 | EWK | ETF | 11.45 | 11.5 | 11.45 | 11.5 | 200.0 |
| 2001-04-02 | EWM | ETF | 18.96 | 19.0 | 18.8 | 18.8 | 3600.0 |
| 2001-04-02 | EWN | ETF | 19.55 | 19.55 | 19.4 | 19.4 | 18800.0 |
| 2001-04-02 | EWP | ETF | 22.63 | 22.9 | 22.63 | 22.9 | 26700.0 |
| 2001-04-02 | EWQ | ETF | 20.3 | 20.4 | 20.15 | 20.24 | 17400.0 |
| 2001-04-02 | EWS | ETF | 10.4 | 10.66 | 10.32 | 10.5 | 11250.0 |
| 2001-04-02 | EWT | ETF | 23.54 | 23.66 | 23.08 | 23.5 | 28800.0 |
| 2001-04-02 | EWU | ETF | 31.2 | 31.3 | 30.9 | 31.18 | 11200.0 |
| 2001-04-02 | EWW | ETF | 14.1 | 14.1 | 13.65 | 13.9 | 17900.0 |
| 2001-04-02 | EWY | ETF | 12.0 | 12.0 | 11.5 | 11.85 | 1900.0 |
| 2001-04-02 | EWZ | ETF | 14.75 | 14.75 | 14.25 | 14.35 | 14000.0 |
| 2001-04-02 | EZU | ETF | 30.4531 | 30.75 | 30.3985 | 30.5 | 36800.0 |
| 2001-04-02 | FCTR | ETF | 15.5781 | 15.5781 | 14.9375 | 15.125 | 72200.0 |
| 2001-04-02 | GLDB | ETF | 7.0313 | 7.2344 | 7.0 | 7.0625 | 114600.0 |
| 2001-04-02 | GSIG | ETF | 7.66 | 8.06 | 7.62 | 7.75 | 115500.0 |
| 2001-04-02 | IBB | ETF | 25.1979 | 25.2188 | 23.8177 | 23.8333 | 612600.0 |
| 2001-04-02 | ICF | ETF | 19.5391 | 19.6172 | 19.5391 | 19.6172 | 5200.0 |
| 2001-04-02 | IDU | ETF | 41.1 | 41.345 | 40.495 | 40.89 | 21400.0 |
| 2001-04-02 | IEV | ETF | 32.25 | 32.25 | 31.625 | 31.69 | 27400.0 |
| 2001-04-02 | IGLD | ETF | 121.875 | 125.0 | 115.625 | 125.0 | 61.0 |
| 2001-04-02 | IGM | ETF | 8.6167 | 8.6167 | 8.225 | 8.2417 | 104400.0 |
| 2001-04-02 | IJH | ETF | 9.192 | 9.195 | 8.97 | 8.97 | 376000.0 |
| 2001-04-02 | IJJ | ETF | 20.5825 | 20.6975 | 20.25 | 20.285 | 65200.0 |
| 2001-04-02 | IJK | ETF | 12.7062 | 12.7062 | 12.225 | 12.2438 | 508800.0 |
| 2001-04-02 | IJR | ETF | 16.875 | 16.8833 | 16.4083 | 16.4417 | 898800.0 |
| 2001-04-02 | IJS | ETF | 18.875 | 18.95 | 18.55 | 18.575 | 22800.0 |
| 2001-04-02 | IJT | ETF | 16.8225 | 16.8225 | 16.4875 | 16.4875 | 3600.0 |
| 2001-04-02 | IOO | ETF | 30.3984 | 30.6406 | 29.7031 | 29.9219 | 245600.0 |
| 2001-04-02 | IUSG | ETF | 20.275 | 20.275 | 19.59 | 19.59 | 8600.0 |
| 2001-04-02 | IUSV | ETF | 23.63 | 23.63 | 23.63 | 23.63 | 300.0 |
| 2001-04-02 | IVE | ETF | 59.37 | 59.9 | 58.38 | 58.56 | 166100.0 |
| 2001-04-02 | IVV | ETF | 116.1 | 117.16 | 114.05 | 114.25 | 299900.0 |
| 2001-04-02 | IVW | ETF | 14.1925 | 14.2225 | 13.825 | 13.93 | 32400.0 |
> showing 50 of 92 rows — these rows as CSV