PREVIEW / etf_daily / 2001-04-18
file: by_date/etf_daily/2001/2001-04-18.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-04-18 | SPY | ETF | 121.06 | 126.0 | 120.69 | 124.0 | 32481600.0 |
| 2001-04-18 | QQQ | ETF | 43.721 | 51.0 | 43.2 | 45.55 | 129199600.0 |
| 2001-04-18 | IWM | ETF | 46.075 | 48.0 | 46.0 | 46.675 | 688600.0 |
| 2001-04-18 | DIA | ETF | 103.25 | 107.45 | 103.11 | 106.42 | 8816500.0 |
| 2001-04-18 | BBH | ETF | 41.0833 | 43.39 | 40.4333 | 42.7733 | 4213200.0 |
| 2001-04-18 | BITS | ETF | 7.04 | 7.72 | 6.8 | 7.6 | 2625.0 |
| 2001-04-18 | CEF | ETF | 3.11 | 3.15 | 3.11 | 3.15 | 4800.0 |
| 2001-04-18 | CHB | ETF | 5.12 | 5.99 | 5.1 | 5.78 | 454300.0 |
| 2001-04-18 | CNXT | ETF | 10.1 | 12.256 | 9.77 | 11.79 | 10547110.0 |
| 2001-04-18 | DGT | ETF | 72.92 | 73.44 | 72.92 | 73.4 | 1700.0 |
| 2001-04-18 | EWA | ETF | 9.05 | 9.19 | 8.9 | 9.15 | 33400.0 |
| 2001-04-18 | EWC | ETF | 11.35 | 11.9 | 11.35 | 11.65 | 14100.0 |
| 2001-04-18 | EWD | ETF | 14.32 | 14.95 | 14.32 | 14.75 | 10300.0 |
| 2001-04-18 | EWG | ETF | 17.17 | 18.0 | 17.06 | 17.6 | 55500.0 |
| 2001-04-18 | EWH | ETF | 10.6 | 11.13 | 10.57 | 10.88 | 170900.0 |
| 2001-04-18 | EWI | ETF | 39.34 | 40.4 | 39.3 | 40.2 | 12350.0 |
| 2001-04-18 | EWJ | ETF | 43.12 | 44.76 | 43.0 | 44.36 | 249050.0 |
| 2001-04-18 | EWK | ETF | 11.45 | 12.0 | 11.45 | 11.8 | 9700.0 |
| 2001-04-18 | EWL | ETF | 14.3 | 14.64 | 14.2 | 14.35 | 17100.0 |
| 2001-04-18 | EWM | ETF | 16.0 | 16.52 | 16.0 | 16.4 | 30750.0 |
| 2001-04-18 | EWN | ETF | 20.56 | 20.6 | 20.55 | 20.55 | 1700.0 |
| 2001-04-18 | EWO | ETF | 8.2 | 8.25 | 8.1 | 8.1 | 2300.0 |
| 2001-04-18 | EWP | ETF | 24.4 | 24.4 | 24.1 | 24.1 | 4500.0 |
| 2001-04-18 | EWQ | ETF | 21.3 | 21.85 | 21.15 | 21.65 | 137800.0 |
| 2001-04-18 | EWS | ETF | 10.3 | 10.9 | 10.3 | 10.8 | 29800.0 |
| 2001-04-18 | EWT | ETF | 22.86 | 24.52 | 22.86 | 23.9 | 209900.0 |
| 2001-04-18 | EWU | ETF | 32.2 | 33.58 | 32.2 | 33.2 | 19600.0 |
| 2001-04-18 | EWW | ETF | 15.35 | 16.05 | 15.35 | 15.54 | 95700.0 |
| 2001-04-18 | EWY | ETF | 12.98 | 14.0 | 12.98 | 13.81 | 51000.0 |
| 2001-04-18 | EWZ | ETF | 16.0 | 16.0 | 15.5 | 15.5 | 200.0 |
| 2001-04-18 | EZU | ETF | 32.05 | 33.0 | 31.825 | 32.945 | 28600.0 |
| 2001-04-18 | FCTR | ETF | 15.41 | 15.79 | 15.41 | 15.45 | 25200.0 |
| 2001-04-18 | FMAR | ETF | 6.49 | 6.95 | 6.0 | 6.95 | 6500.0 |
| 2001-04-18 | GLDB | ETF | 6.5 | 6.88 | 6.45 | 6.88 | 84800.0 |
| 2001-04-18 | GSIG | ETF | 9.37 | 10.8 | 9.2 | 10.55 | 271500.0 |
| 2001-04-18 | IBB | ETF | 28.4333 | 29.6167 | 28.1067 | 29.5 | 108900.0 |
| 2001-04-18 | ICF | ETF | 19.275 | 19.5 | 19.275 | 19.5 | 112000.0 |
| 2001-04-18 | IDU | ETF | 42.8 | 42.8 | 41.755 | 42.225 | 10800.0 |
| 2001-04-18 | IEV | ETF | 33.125 | 34.0 | 32.735 | 33.75 | 55200.0 |
| 2001-04-18 | IGLD | ETF | 97.0 | 103.0 | 97.0 | 100.0 | 71.0 |
| 2001-04-18 | IGM | ETF | 9.5833 | 10.3317 | 9.5833 | 10.0583 | 10489200.0 |
| 2001-04-18 | IJH | ETF | 9.656 | 9.95 | 9.645 | 9.843 | 1136000.0 |
| 2001-04-18 | IJJ | ETF | 21.19 | 21.875 | 21.19 | 21.475 | 78000.0 |
| 2001-04-18 | IJK | ETF | 13.5812 | 14.125 | 13.5538 | 13.9462 | 136000.0 |
| 2001-04-18 | IJR | ETF | 17.3767 | 18.1667 | 17.3583 | 17.54 | 487200.0 |
| 2001-04-18 | IJS | ETF | 19.225 | 20.0 | 19.2 | 19.32 | 94400.0 |
| 2001-04-18 | IJT | ETF | 17.7375 | 18.5 | 17.7375 | 18.0625 | 77200.0 |
| 2001-04-18 | IOO | ETF | 32.025 | 33.575 | 32.025 | 32.84 | 271400.0 |
| 2001-04-18 | IUSG | ETF | 22.025 | 23.475 | 21.97 | 22.515 | 20400.0 |
| 2001-04-18 | IUSV | ETF | 26.0 | 26.0 | 24.8267 | 24.8267 | 2400.0 |
> showing 50 of 97 rows — these rows as CSV