PREVIEW / etf_daily / 2001-04-20
file: by_date/etf_daily/2001/2001-04-20.parquet size: 8 KB rows: 98
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-20 | SPY | ETF | 124.9 | 125.4 | 123.66 | 124.5 | 7626700.0 |
| 2001-04-20 | QQQ | ETF | 48.18 | 49.44 | 43.05 | 48.4 | 80598100.0 |
| 2001-04-20 | IWM | ETF | 47.0 | 47.0 | 46.0 | 46.645 | 504000.0 |
| 2001-04-20 | DIA | ETF | 106.0 | 106.67 | 105.26 | 105.95 | 2753000.0 |
| 2001-04-20 | BBH | ETF | 41.5367 | 41.5367 | 40.55 | 40.8333 | 1732200.0 |
| 2001-04-20 | BITS | ETF | 7.44 | 8.0 | 7.16 | 7.96 | 2100.0 |
| 2001-04-20 | CEF | ETF | 3.17 | 3.18 | 3.17 | 3.17 | 19500.0 |
| 2001-04-20 | CHB | ETF | 7.05 | 7.24 | 7.0 | 7.2 | 149400.0 |
| 2001-04-20 | CNXT | ETF | 11.04 | 11.71 | 10.4 | 11.05 | 6668550.0 |
| 2001-04-20 | CSB | ETF | 1.39999997615814 | 1.39999997615814 | 1.39999997615814 | 1.39999997615814 | 3100.0 |
| 2001-04-20 | DGT | ETF | 73.49 | 73.8 | 73.49 | 73.73 | 600.0 |
| 2001-04-20 | EWA | ETF | 9.25 | 9.38 | 9.25 | 9.38 | 10300.0 |
| 2001-04-20 | EWC | ETF | 11.95 | 12.05 | 11.75 | 11.75 | 20600.0 |
| 2001-04-20 | EWD | ETF | 14.8 | 14.84 | 14.8 | 14.84 | 200.0 |
| 2001-04-20 | EWG | ETF | 17.65 | 17.75 | 17.55 | 17.75 | 62200.0 |
| 2001-04-20 | EWH | ETF | 10.95 | 10.95 | 10.76 | 10.76 | 14900.0 |
| 2001-04-20 | EWI | ETF | 40.38 | 40.7 | 40.3 | 40.7 | 2600.0 |
| 2001-04-20 | EWJ | ETF | 43.36 | 43.4 | 42.92 | 43.16 | 107225.0 |
| 2001-04-20 | EWK | ETF | 11.55 | 11.55 | 11.55 | 11.55 | 400.0 |
| 2001-04-20 | EWL | ETF | 14.25 | 14.55 | 14.25 | 14.55 | 2800.0 |
| 2001-04-20 | EWM | ETF | 16.56 | 16.56 | 16.32 | 16.44 | 2700.0 |
| 2001-04-20 | EWN | ETF | 20.4 | 20.65 | 20.35 | 20.65 | 11500.0 |
| 2001-04-20 | EWO | ETF | 8.22 | 8.4 | 8.22 | 8.3 | 31300.0 |
| 2001-04-20 | EWP | ETF | 23.92 | 24.1 | 23.75 | 24.1 | 45000.0 |
| 2001-04-20 | EWQ | ETF | 21.7 | 22.0 | 21.7 | 22.0 | 53300.0 |
| 2001-04-20 | EWS | ETF | 10.88 | 10.88 | 10.54 | 10.68 | 7200.0 |
| 2001-04-20 | EWT | ETF | 23.2 | 23.2 | 22.8 | 22.86 | 12150.0 |
| 2001-04-20 | EWU | ETF | 33.3 | 33.3 | 32.82 | 33.1 | 13800.0 |
| 2001-04-20 | EWW | ETF | 14.86 | 14.86 | 14.45 | 14.45 | 64000.0 |
| 2001-04-20 | EWY | ETF | 13.43 | 13.43 | 13.27 | 13.27 | 1200.0 |
| 2001-04-20 | EWZ | ETF | 14.08 | 14.08 | 13.5 | 13.66 | 289300.0 |
| 2001-04-20 | EZU | ETF | 32.525 | 32.875 | 32.525 | 32.685 | 7600.0 |
| 2001-04-20 | FCTR | ETF | 16.1 | 16.19 | 15.5 | 16.19 | 85500.0 |
| 2001-04-20 | FMAR | ETF | 7.0 | 7.25 | 6.77 | 7.25 | 4700.0 |
| 2001-04-20 | GLDB | ETF | 7.01 | 7.05 | 7.0 | 7.03 | 170700.0 |
| 2001-04-20 | GSIG | ETF | 10.4 | 10.49 | 9.6 | 9.95 | 130200.0 |
| 2001-04-20 | IBB | ETF | 28.9333 | 28.9667 | 28.4 | 28.7667 | 40800.0 |
| 2001-04-20 | ICF | ETF | 19.59 | 19.59 | 19.45 | 19.4625 | 101200.0 |
| 2001-04-20 | IDU | ETF | 41.6 | 41.825 | 41.125 | 41.125 | 6400.0 |
| 2001-04-20 | IEV | ETF | 33.75 | 33.95 | 33.575 | 33.94 | 38200.0 |
| 2001-04-20 | IGLD | ETF | 95.0 | 100.0 | 84.0 | 92.0 | 231.0 |
| 2001-04-20 | IGM | ETF | 10.625 | 10.65 | 10.5 | 10.65 | 19800.0 |
| 2001-04-20 | IJH | ETF | 9.875 | 9.936 | 9.75 | 9.828 | 720000.0 |
| 2001-04-20 | IJJ | ETF | 21.6925 | 21.6925 | 21.365 | 21.5975 | 87200.0 |
| 2001-04-20 | IJK | ETF | 13.9788 | 14.0975 | 13.8188 | 13.9675 | 348800.0 |
| 2001-04-20 | IJR | ETF | 17.6417 | 17.6583 | 17.3167 | 17.4667 | 185400.0 |
| 2001-04-20 | IJS | ETF | 19.5 | 19.5 | 19.1625 | 19.425 | 50000.0 |
| 2001-04-20 | IJT | ETF | 17.995 | 18.045 | 17.7225 | 17.925 | 337600.0 |
| 2001-04-20 | IOO | ETF | 32.925 | 33.075 | 32.76 | 33.0 | 185600.0 |
| 2001-04-20 | IUSG | ETF | 23.085 | 23.085 | 22.975 | 23.015 | 15400.0 |
> showing 50 of 98 rows — these rows as CSV