PREVIEW / etf_daily / 2002-03-27
file: by_date/etf_daily/2002/2002-03-27.parquet size: 9 KB rows: 117
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-03-27 | SPY | ETF | 114.03 | 115.01 | 113.76 | 114.57 | 19020300.0 |
| 2002-03-27 | QQQ | ETF | 35.637 | 36.0 | 35.4 | 35.61 | 64548400.0 |
| 2002-03-27 | IWM | ETF | 49.85 | 50.315 | 49.735 | 50.315 | 976400.0 |
| 2002-03-27 | DIA | ETF | 103.55 | 104.65 | 103.4 | 104.3 | 5929100.0 |
| 2002-03-27 | ARB | ETF | 33.4 | 34.25 | 33.4 | 34.25 | 37200.0 |
| 2002-03-27 | BBH | ETF | 40.6333 | 41.05 | 40.5 | 40.5833 | 2077200.0 |
| 2002-03-27 | BITS | ETF | 14.2 | 14.4 | 14.12 | 14.4 | 1750.0 |
| 2002-03-27 | CEF | ETF | 3.85 | 3.94 | 3.82 | 3.89 | 141500.0 |
| 2002-03-27 | CHB | ETF | 8.54 | 8.68 | 7.69 | 7.95 | 1057000.0 |
| 2002-03-27 | CNXT | ETF | 11.99 | 12.39 | 11.89 | 12.1 | 2138400.0 |
| 2002-03-27 | DGT | ETF | 64.5 | 64.58 | 64.25 | 64.55 | 2900.0 |
| 2002-03-27 | EFA | ETF | 39.8333 | 39.9467 | 39.7667 | 39.8033 | 196500.0 |
| 2002-03-27 | ELV | ETF | 27.99 | 29.005 | 27.95 | 29.0 | 601300.0 |
| 2002-03-27 | EPP | ETF | 18.8467 | 18.8633 | 18.8467 | 18.8467 | 18600.0 |
| 2002-03-27 | EWA | ETF | 9.75 | 9.77 | 9.69 | 9.75 | 16200.0 |
| 2002-03-27 | EWC | ETF | 11.0 | 11.1 | 11.0 | 11.1 | 4500.0 |
| 2002-03-27 | EWD | ETF | 13.27 | 13.27 | 13.11 | 13.11 | 6600.0 |
| 2002-03-27 | EWG | ETF | 15.28 | 15.34 | 15.14 | 15.26 | 31200.0 |
| 2002-03-27 | EWH | ETF | 9.1 | 9.24 | 9.1 | 9.18 | 40100.0 |
| 2002-03-27 | EWI | ETF | 32.8 | 32.96 | 32.68 | 32.96 | 2850.0 |
| 2002-03-27 | EWJ | ETF | 32.08 | 32.36 | 32.04 | 32.12 | 219725.0 |
| 2002-03-27 | EWK | ETF | 10.99 | 10.99 | 10.99 | 10.99 | 3400.0 |
| 2002-03-27 | EWL | ETF | 13.02 | 13.14 | 13.01 | 13.14 | 11000.0 |
| 2002-03-27 | EWM | ETF | 23.68 | 23.68 | 23.28 | 23.68 | 10900.0 |
| 2002-03-27 | EWN | ETF | 17.71 | 17.71 | 17.71 | 17.71 | 6100.0 |
| 2002-03-27 | EWO | ETF | 8.11 | 8.23 | 8.11 | 8.21 | 8700.0 |
| 2002-03-27 | EWP | ETF | 20.06 | 20.24 | 20.01 | 20.23 | 4400.0 |
| 2002-03-27 | EWQ | ETF | 18.53 | 18.65 | 18.52 | 18.65 | 13800.0 |
| 2002-03-27 | EWS | ETF | 11.38 | 11.38 | 11.06 | 11.18 | 21850.0 |
| 2002-03-27 | EWT | ETF | 23.7 | 23.7 | 23.2 | 23.58 | 56000.0 |
| 2002-03-27 | EWU | ETF | 28.82 | 29.1 | 28.82 | 28.86 | 21350.0 |
| 2002-03-27 | EWW | ETF | 17.56 | 17.76 | 17.51 | 17.71 | 114800.0 |
| 2002-03-27 | EWY | ETF | 23.05 | 23.35 | 23.0 | 23.19 | 62600.0 |
| 2002-03-27 | EWZ | ETF | 13.01 | 13.48 | 12.96 | 13.48 | 252500.0 |
| 2002-03-27 | EZU | ETF | 27.59 | 27.665 | 27.5 | 27.62 | 33000.0 |
| 2002-03-27 | FCTR | ETF | 19.25 | 19.5 | 18.91 | 19.4 | 33100.0 |
| 2002-03-27 | FMAR | ETF | 10.0 | 10.7 | 10.0 | 10.41 | 45400.0 |
| 2002-03-27 | GLDB | ETF | 8.635 | 8.78 | 8.4 | 8.78 | 241800.0 |
| 2002-03-27 | GSIG | ETF | 10.11 | 10.35 | 9.95 | 10.33 | 81300.0 |
| 2002-03-27 | IBB | ETF | 26.05 | 26.3 | 25.9167 | 25.97 | 975300.0 |
| 2002-03-27 | ICF | ETF | 22.5 | 22.5575 | 22.4425 | 22.4425 | 480400.0 |
| 2002-03-27 | IDU | ETF | 32.675 | 33.07 | 32.57 | 33.035 | 195800.0 |
| 2002-03-27 | IEV | ETF | 29.175 | 29.46 | 29.175 | 29.435 | 65400.0 |
| 2002-03-27 | IGLD | ETF | 115.0 | 117.0 | 114.0 | 117.0 | 149.0 |
| 2002-03-27 | IGM | ETF | 7.585 | 7.6433 | 7.5833 | 7.6433 | 83400.0 |
| 2002-03-27 | IGN | ETF | 23.95 | 23.95 | 23.57 | 23.75 | 17900.0 |
| 2002-03-27 | IGV | ETF | 8.04 | 8.104 | 8.03 | 8.07 | 28500.0 |
| 2002-03-27 | IJH | ETF | 10.672 | 10.794 | 10.65 | 10.765 | 1116000.0 |
| 2002-03-27 | IJJ | ETF | 24.35 | 24.67 | 24.35 | 24.6625 | 704000.0 |
| 2002-03-27 | IJK | ETF | 14.495 | 14.65 | 14.495 | 14.6 | 173600.0 |
> showing 50 of 117 rows — these rows as CSV