PREVIEW / etf_daily / 2002-02-19
file: by_date/etf_daily/2002/2002-02-19.parquet size: 9 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2002-02-19 | SPY | ETF | 110.15 | 110.29 | 108.61 | 108.76 | 15988100.0 |
| 2002-02-19 | QQQ | ETF | 35.375 | 35.46 | 34.0 | 34.68 | 72437200.0 |
| 2002-02-19 | IWM | ETF | 46.25 | 46.4 | 45.625 | 45.775 | 981400.0 |
| 2002-02-19 | DIA | ETF | 98.6 | 98.9 | 97.37 | 97.52 | 3716300.0 |
| 2002-02-19 | ARB | ETF | 30.8 | 30.9 | 30.0 | 30.01 | 92300.0 |
| 2002-02-19 | BBH | ETF | 39.2167 | 39.45 | 38.6333 | 38.7267 | 2163900.0 |
| 2002-02-19 | BITS | ETF | 15.72 | 16.52 | 13.96 | 14.2364 | 6600.0 |
| 2002-02-19 | CEF | ETF | 3.72 | 3.79 | 3.66 | 3.7 | 89000.0 |
| 2002-02-19 | CHB | ETF | 9.47 | 9.75 | 9.47 | 9.65 | 278100.0 |
| 2002-02-19 | CNXT | ETF | 11.05 | 11.28 | 10.5 | 10.69 | 3270560.0 |
| 2002-02-19 | CSB | ETF | 4.25 | 4.25 | 4.25 | 4.25 | 1000.0 |
| 2002-02-19 | DGT | ETF | 62.25 | 62.25 | 61.41 | 61.5 | 7400.0 |
| 2002-02-19 | EFA | ETF | 37.0733 | 37.1167 | 36.7867 | 36.9333 | 300000.0 |
| 2002-02-19 | ELV | ETF | 28.0 | 28.035 | 26.725 | 27.185 | 1103600.0 |
| 2002-02-19 | EPP | ETF | 18.58 | 18.58 | 18.5333 | 18.5333 | 8700.0 |
| 2002-02-19 | EWA | ETF | 9.75 | 9.75 | 9.6 | 9.68 | 134600.0 |
| 2002-02-19 | EWC | ETF | 10.51 | 10.7 | 10.5 | 10.52 | 27300.0 |
| 2002-02-19 | EWD | ETF | 12.28 | 12.37 | 12.28 | 12.28 | 25800.0 |
| 2002-02-19 | EWG | ETF | 13.64 | 13.7 | 13.52 | 13.59 | 205000.0 |
| 2002-02-19 | EWH | ETF | 8.94 | 9.0 | 8.84 | 8.84 | 61400.0 |
| 2002-02-19 | EWI | ETF | 29.8 | 30.2 | 29.8 | 29.84 | 3750.0 |
| 2002-02-19 | EWJ | ETF | 28.4 | 28.4 | 27.96 | 27.96 | 86125.0 |
| 2002-02-19 | EWK | ETF | 10.68 | 10.69 | 10.68 | 10.69 | 7800.0 |
| 2002-02-19 | EWL | ETF | 12.24 | 12.24 | 12.06 | 12.19 | 4600.0 |
| 2002-02-19 | EWM | ETF | 21.92 | 22.32 | 21.92 | 22.08 | 27500.0 |
| 2002-02-19 | EWN | ETF | 16.45 | 16.45 | 16.45 | 16.45 | 4100.0 |
| 2002-02-19 | EWO | ETF | 7.91 | 7.91 | 7.82 | 7.82 | 7100.0 |
| 2002-02-19 | EWP | ETF | 19.05 | 19.18 | 19.0 | 19.0 | 5000.0 |
| 2002-02-19 | EWQ | ETF | 17.42 | 17.42 | 17.2 | 17.3 | 211900.0 |
| 2002-02-19 | EWS | ETF | 10.9 | 11.08 | 10.72 | 10.92 | 31950.0 |
| 2002-02-19 | EWT | ETF | 22.4 | 22.5 | 21.88 | 22.0 | 80950.0 |
| 2002-02-19 | EWU | ETF | 28.24 | 28.24 | 28.02 | 28.02 | 33750.0 |
| 2002-02-19 | EWW | ETF | 16.05 | 16.05 | 15.8 | 15.8 | 49500.0 |
| 2002-02-19 | EWY | ETF | 19.95 | 20.1 | 19.86 | 19.92 | 67400.0 |
| 2002-02-19 | EWZ | ETF | 12.1 | 12.15 | 11.99 | 11.99 | 208900.0 |
| 2002-02-19 | EZU | ETF | 25.525 | 25.575 | 25.395 | 25.395 | 125600.0 |
| 2002-02-19 | FCTR | ETF | 17.55 | 17.65 | 17.13 | 17.13 | 20300.0 |
| 2002-02-19 | FMAR | ETF | 10.475 | 10.629 | 10.27 | 10.28 | 8270.0 |
| 2002-02-19 | GLDB | ETF | 7.06 | 7.06 | 7.0 | 7.0 | 50200.0 |
| 2002-02-19 | GRNB | ETF | 17.5521 | 17.5521 | 17.5521 | 17.5521 | 505.0 |
| 2002-02-19 | GSIG | ETF | 8.5 | 8.66 | 8.47 | 8.55 | 27000.0 |
| 2002-02-19 | IBB | ETF | 25.1667 | 25.3167 | 24.7333 | 24.9 | 153300.0 |
| 2002-02-19 | ICF | ETF | 21.3625 | 21.3675 | 21.2925 | 21.3275 | 9200.0 |
| 2002-02-19 | IDU | ETF | 30.1 | 30.2 | 29.875 | 29.875 | 45200.0 |
| 2002-02-19 | IEV | ETF | 27.7 | 27.725 | 27.505 | 27.565 | 50600.0 |
| 2002-02-19 | IGE | ETF | 15.5567 | 15.5567 | 15.5567 | 15.5567 | 600.0 |
| 2002-02-19 | IGLD | ETF | 110.0 | 112.0 | 97.0 | 108.0 | 553.0 |
| 2002-02-19 | IGM | ETF | 7.65 | 7.6667 | 7.4667 | 7.4667 | 64200.0 |
| 2002-02-19 | IGN | ETF | 24.54 | 24.54 | 23.73 | 23.74 | 910600.0 |
| 2002-02-19 | IGV | ETF | 8.182 | 8.182 | 7.908 | 7.908 | 284500.0 |
> showing 50 of 119 rows — these rows as CSV