PREVIEW / etf_daily / 2001-07-20
file: by_date/etf_daily/2001/2001-07-20.parquet size: 9 KB rows: 101
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-07-20 | SPY | ETF | 121.15 | 121.94 | 120.92 | 121.34 | 6705800.0 |
| 2001-07-20 | QQQ | ETF | 41.49 | 42.14 | 41.36 | 41.65 | 49012800.0 |
| 2001-07-20 | IWM | ETF | 48.25 | 48.8 | 48.25 | 48.5 | 629600.0 |
| 2001-07-20 | DIA | ETF | 105.55 | 106.07 | 105.35 | 105.8 | 1203300.0 |
| 2001-07-20 | BBH | ETF | 38.93 | 39.5833 | 38.8167 | 39.25 | 1632000.0 |
| 2001-07-20 | BITS | ETF | 14.24 | 15.24 | 14.24 | 15.0 | 1875.0 |
| 2001-07-20 | BOSS | ETF | 28.0 | 29.5 | 28.0 | 29.5 | 100.0 |
| 2001-07-20 | CEF | ETF | 3.11 | 3.11 | 3.11 | 3.11 | 700.0 |
| 2001-07-20 | CHB | ETF | 11.13 | 11.14 | 11.04 | 11.11 | 75900.0 |
| 2001-07-20 | CNXT | ETF | 8.17 | 9.12 | 8.13 | 8.82 | 4379040.0 |
| 2001-07-20 | DGT | ETF | 69.35 | 69.6 | 69.35 | 69.55 | 3300.0 |
| 2001-07-20 | EWA | ETF | 9.5 | 9.5 | 9.37 | 9.46 | 52100.0 |
| 2001-07-20 | EWC | ETF | 11.14 | 11.25 | 11.06 | 11.2 | 6100.0 |
| 2001-07-20 | EWD | ETF | 13.05 | 13.05 | 12.8 | 12.8 | 700.0 |
| 2001-07-20 | EWG | ETF | 16.25 | 16.25 | 16.09 | 16.09 | 39500.0 |
| 2001-07-20 | EWH | ETF | 9.71 | 9.85 | 9.71 | 9.72 | 22000.0 |
| 2001-07-20 | EWI | ETF | 35.4 | 35.4 | 35.02 | 35.02 | 2000.0 |
| 2001-07-20 | EWJ | ETF | 38.04 | 38.44 | 38.04 | 38.24 | 124275.0 |
| 2001-07-20 | EWK | ETF | 11.6 | 11.6 | 11.6 | 11.6 | 100.0 |
| 2001-07-20 | EWL | ETF | 13.49 | 13.49 | 13.2 | 13.4 | 7000.0 |
| 2001-07-20 | EWM | ETF | 18.68 | 19.08 | 18.28 | 18.4 | 1250.0 |
| 2001-07-20 | EWN | ETF | 18.65 | 18.65 | 18.45 | 18.45 | 5100.0 |
| 2001-07-20 | EWO | ETF | 8.25 | 8.25 | 8.25 | 8.25 | 7300.0 |
| 2001-07-20 | EWP | ETF | 20.49 | 20.5 | 20.3 | 20.49 | 4200.0 |
| 2001-07-20 | EWQ | ETF | 19.4 | 19.4 | 19.21 | 19.21 | 3600.0 |
| 2001-07-20 | EWS | ETF | 10.08 | 10.1 | 9.94 | 9.94 | 4050.0 |
| 2001-07-20 | EWT | ETF | 17.2 | 17.2 | 16.98 | 17.06 | 7900.0 |
| 2001-07-20 | EWU | ETF | 30.44 | 30.44 | 30.1 | 30.44 | 12250.0 |
| 2001-07-20 | EWW | ETF | 15.4 | 15.65 | 15.4 | 15.65 | 3100.0 |
| 2001-07-20 | EWY | ETF | 12.88 | 12.88 | 12.75 | 12.86 | 6300.0 |
| 2001-07-20 | EWZ | ETF | 12.7 | 12.89 | 12.66 | 12.66 | 1200.0 |
| 2001-07-20 | EZU | ETF | 29.22 | 29.225 | 29.17 | 29.17 | 9800.0 |
| 2001-07-20 | FCTR | ETF | 18.3 | 18.49 | 18.0 | 18.25 | 58900.0 |
| 2001-07-20 | FMAR | ETF | 9.04 | 9.25 | 8.75 | 9.0 | 21500.0 |
| 2001-07-20 | GLDB | ETF | 7.57 | 7.75 | 7.4 | 7.75 | 16400.0 |
| 2001-07-20 | GRNB | ETF | 26.0139 | 26.0139 | 26.0139 | 26.0139 | 303.0 |
| 2001-07-20 | GSIG | ETF | 7.55 | 7.9 | 7.55 | 7.63 | 140700.0 |
| 2001-07-20 | IBB | ETF | 29.05 | 29.43 | 29.05 | 29.3833 | 112500.0 |
| 2001-07-20 | ICF | ETF | 21.2 | 21.2 | 21.1575 | 21.1575 | 5600.0 |
| 2001-07-20 | IDU | ETF | 38.75 | 38.75 | 37.98 | 37.98 | 5000.0 |
| 2001-07-20 | IEV | ETF | 30.715 | 30.715 | 30.28 | 30.335 | 24000.0 |
| 2001-07-20 | IGLD | ETF | 71.0 | 74.0 | 71.0 | 74.0 | 50.0 |
| 2001-07-20 | IGM | ETF | 8.9833 | 9.015 | 8.9833 | 9.015 | 31200.0 |
| 2001-07-20 | IGV | ETF | 9.37 | 9.424 | 9.37 | 9.424 | 250500.0 |
| 2001-07-20 | IJH | ETF | 10.126 | 10.218 | 10.126 | 10.192 | 710000.0 |
| 2001-07-20 | IJJ | ETF | 22.5575 | 22.645 | 22.53 | 22.6125 | 27600.0 |
| 2001-07-20 | IJK | ETF | 14.2475 | 14.3025 | 14.2288 | 14.3025 | 379200.0 |
| 2001-07-20 | IJR | ETF | 18.7083 | 18.85 | 18.6833 | 18.8317 | 168000.0 |
| 2001-07-20 | IJS | ETF | 21.025 | 21.11 | 20.9675 | 21.075 | 41600.0 |
| 2001-07-20 | IJT | ETF | 18.7875 | 18.8975 | 18.7875 | 18.8825 | 9200.0 |
> showing 50 of 101 rows — these rows as CSV