PREVIEW / etf_daily / 2002-03-22
file: by_date/etf_daily/2002/2002-03-22.parquet size: 9 KB rows: 116
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-22 | SPY | ETF | 115.5 | 115.94 | 114.7 | 115.04 | 15235400.0 |
| 2002-03-22 | QQQ | ETF | 36.944 | 37.14 | 36.47 | 36.68 | 58931200.0 |
| 2002-03-22 | IWM | ETF | 50.275 | 50.555 | 49.88 | 49.9 | 1018600.0 |
| 2002-03-22 | DIA | ETF | 104.76 | 105.04 | 103.96 | 104.23 | 4597900.0 |
| 2002-03-22 | ARB | ETF | 33.4 | 34.08 | 33.31 | 33.31 | 41600.0 |
| 2002-03-22 | BBH | ETF | 42.3 | 42.6967 | 42.1067 | 42.1667 | 4420200.0 |
| 2002-03-22 | BITS | ETF | 15.56 | 15.56 | 14.0 | 14.24 | 2525.0 |
| 2002-03-22 | CEF | ETF | 3.66 | 3.79 | 3.66 | 3.75 | 39600.0 |
| 2002-03-22 | CHB | ETF | 8.65 | 8.65 | 8.25 | 8.33 | 103700.0 |
| 2002-03-22 | CNXT | ETF | 11.71 | 12.25 | 11.7 | 11.7 | 2264200.0 |
| 2002-03-22 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 33000.0 |
| 2002-03-22 | DGT | ETF | 65.1 | 65.1 | 64.77 | 64.77 | 2500.0 |
| 2002-03-22 | EFA | ETF | 40.1867 | 40.27 | 39.9533 | 39.9867 | 179700.0 |
| 2002-03-22 | ELV | ETF | 28.7 | 29.025 | 28.325 | 28.4 | 293500.0 |
| 2002-03-22 | EPP | ETF | 18.9633 | 18.9833 | 18.9 | 18.9 | 9000.0 |
| 2002-03-22 | EWA | ETF | 9.95 | 9.95 | 9.9 | 9.9 | 44500.0 |
| 2002-03-22 | EWC | ETF | 11.3 | 11.3 | 11.16 | 11.2 | 140600.0 |
| 2002-03-22 | EWD | ETF | 13.68 | 13.74 | 13.61 | 13.74 | 7500.0 |
| 2002-03-22 | EWG | ETF | 15.31 | 15.41 | 15.31 | 15.36 | 8000.0 |
| 2002-03-22 | EWH | ETF | 8.89 | 9.06 | 8.89 | 8.94 | 58400.0 |
| 2002-03-22 | EWI | ETF | 33.36 | 33.36 | 33.36 | 33.36 | 900.0 |
| 2002-03-22 | EWJ | ETF | 32.32 | 32.4 | 32.04 | 32.12 | 183450.0 |
| 2002-03-22 | EWL | ETF | 13.21 | 13.21 | 13.21 | 13.21 | 1400.0 |
| 2002-03-22 | EWM | ETF | 23.4 | 23.4 | 23.24 | 23.4 | 5375.0 |
| 2002-03-22 | EWN | ETF | 18.0 | 18.0 | 17.99 | 17.99 | 200.0 |
| 2002-03-22 | EWP | ETF | 20.84 | 20.84 | 20.61 | 20.61 | 2900.0 |
| 2002-03-22 | EWQ | ETF | 18.5 | 18.6 | 18.5 | 18.6 | 2800.0 |
| 2002-03-22 | EWS | ETF | 11.6 | 11.6 | 11.36 | 11.44 | 62800.0 |
| 2002-03-22 | EWT | ETF | 23.44 | 23.86 | 23.44 | 23.44 | 47050.0 |
| 2002-03-22 | EWU | ETF | 29.28 | 29.28 | 28.9 | 29.14 | 9300.0 |
| 2002-03-22 | EWW | ETF | 17.94 | 18.1 | 17.75 | 18.05 | 378100.0 |
| 2002-03-22 | EWY | ETF | 22.96 | 23.04 | 22.71 | 22.78 | 99300.0 |
| 2002-03-22 | EWZ | ETF | 13.05 | 13.11 | 12.81 | 12.82 | 234200.0 |
| 2002-03-22 | EZU | ETF | 27.875 | 27.875 | 27.605 | 27.75 | 24200.0 |
| 2002-03-22 | FCTR | ETF | 19.25 | 19.39 | 18.8 | 19.0 | 24600.0 |
| 2002-03-22 | FMAR | ETF | 9.99 | 10.0 | 9.84 | 10.0 | 1100.0 |
| 2002-03-22 | GLDB | ETF | 8.39 | 8.5 | 8.25 | 8.3 | 98300.0 |
| 2002-03-22 | GSIG | ETF | 9.97 | 10.06 | 9.72 | 9.97 | 39900.0 |
| 2002-03-22 | IBB | ETF | 27.4167 | 27.58 | 27.1667 | 27.17 | 284400.0 |
| 2002-03-22 | ICF | ETF | 22.4625 | 22.5525 | 22.4625 | 22.4925 | 20800.0 |
| 2002-03-22 | IDU | ETF | 32.925 | 33.17 | 32.825 | 32.955 | 92400.0 |
| 2002-03-22 | IEV | ETF | 29.725 | 29.725 | 29.425 | 29.425 | 5072600.0 |
| 2002-03-22 | IGLD | ETF | 123.0 | 124.0 | 113.0 | 119.9 | 400.0 |
| 2002-03-22 | IGM | ETF | 7.8483 | 7.8483 | 7.7717 | 7.7717 | 103200.0 |
| 2002-03-22 | IGN | ETF | 24.65 | 24.91 | 24.24 | 24.24 | 19700.0 |
| 2002-03-22 | IGV | ETF | 8.234 | 8.252 | 8.22 | 8.224 | 33500.0 |
| 2002-03-22 | IJH | ETF | 10.79 | 10.793 | 10.711 | 10.729 | 193000.0 |
| 2002-03-22 | IJJ | ETF | 24.555 | 24.555 | 24.3625 | 24.3625 | 108800.0 |
| 2002-03-22 | IJK | ETF | 14.6362 | 14.6862 | 14.59 | 14.59 | 96000.0 |
| 2002-03-22 | IJR | ETF | 20.4083 | 20.5433 | 20.2767 | 20.2917 | 779400.0 |
> showing 50 of 116 rows — these rows as CSV