PREVIEW / etf_daily / 2002-01-09
file: by_date/etf_daily/2002/2002-01-09.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-01-09 | SPY | ETF | 116.68 | 117.78 | 115.34 | 115.57 | 16610300.0 |
| 2002-01-09 | QQQ | ETF | 42.04 | 42.6 | 40.9 | 41.11 | 85123000.0 |
| 2002-01-09 | IWM | ETF | 49.875 | 50.065 | 49.0 | 49.0 | 868800.0 |
| 2002-01-09 | DIA | ETF | 101.95 | 102.99 | 100.72 | 100.86 | 3587500.0 |
| 2002-01-09 | ARB | ETF | 32.25 | 32.78 | 32.25 | 32.45 | 66500.0 |
| 2002-01-09 | BBH | ETF | 43.3667 | 43.6067 | 42.4833 | 42.5 | 1960800.0 |
| 2002-01-09 | BITS | ETF | 24.32 | 24.8 | 22.28 | 23.0 | 15475.0 |
| 2002-01-09 | CEF | ETF | 3.49 | 3.54 | 3.41 | 3.51 | 60600.0 |
| 2002-01-09 | CHB | ETF | 12.05 | 12.38 | 11.7 | 11.8 | 248600.0 |
| 2002-01-09 | CNXT | ETF | 14.08 | 14.63 | 13.76 | 13.9 | 5289100.0 |
| 2002-01-09 | CSB | ETF | 4.51000022888184 | 4.69999980926514 | 4.51000022888184 | 4.69999980926514 | 3100.0 |
| 2002-01-09 | DGT | ETF | 67.1 | 67.1 | 66.85 | 67.01 | 4600.0 |
| 2002-01-09 | EFA | ETF | 39.6067 | 39.6867 | 39.2 | 39.2 | 1169100.0 |
| 2002-01-09 | ELV | ETF | 23.775 | 24.125 | 23.75 | 23.8 | 427500.0 |
| 2002-01-09 | EPP | ETF | 18.76 | 18.76 | 18.7467 | 18.7467 | 4500.0 |
| 2002-01-09 | EWA | ETF | 9.61 | 9.62 | 9.55 | 9.62 | 7300.0 |
| 2002-01-09 | EWC | ETF | 11.2 | 11.2 | 11.05 | 11.17 | 2500.0 |
| 2002-01-09 | EWD | ETF | 13.96 | 13.99 | 13.8 | 13.8 | 14100.0 |
| 2002-01-09 | EWG | ETF | 15.31 | 15.41 | 15.2 | 15.26 | 20400.0 |
| 2002-01-09 | EWH | ETF | 9.67 | 9.78 | 9.46 | 9.46 | 56000.0 |
| 2002-01-09 | EWI | ETF | 32.7 | 32.7 | 32.44 | 32.68 | 1750.0 |
| 2002-01-09 | EWJ | ETF | 31.0 | 31.4 | 30.8 | 30.88 | 97200.0 |
| 2002-01-09 | EWK | ETF | 10.69 | 10.69 | 10.69 | 10.69 | 200.0 |
| 2002-01-09 | EWL | ETF | 12.69 | 12.7 | 12.51 | 12.7 | 8700.0 |
| 2002-01-09 | EWM | ETF | 20.72 | 20.76 | 20.6 | 20.68 | 2250.0 |
| 2002-01-09 | EWN | ETF | 16.85 | 16.85 | 16.66 | 16.84 | 8900.0 |
| 2002-01-09 | EWO | ETF | 7.29 | 7.29 | 7.26 | 7.29 | 3400.0 |
| 2002-01-09 | EWP | ETF | 20.22 | 20.22 | 19.9 | 20.09 | 3200.0 |
| 2002-01-09 | EWQ | ETF | 18.51 | 18.65 | 18.51 | 18.64 | 26800.0 |
| 2002-01-09 | EWS | ETF | 10.78 | 10.78 | 10.56 | 10.6 | 78300.0 |
| 2002-01-09 | EWT | ETF | 23.4 | 23.4 | 22.76 | 22.94 | 14250.0 |
| 2002-01-09 | EWU | ETF | 29.2 | 29.2 | 28.82 | 28.84 | 15000.0 |
| 2002-01-09 | EWW | ETF | 15.82 | 15.89 | 15.5 | 15.5 | 22300.0 |
| 2002-01-09 | EWY | ETF | 19.35 | 19.64 | 19.3 | 19.39 | 44500.0 |
| 2002-01-09 | EWZ | ETF | 12.75 | 12.88 | 12.6 | 12.8 | 21600.0 |
| 2002-01-09 | EZU | ETF | 27.6 | 27.75 | 27.255 | 27.255 | 72200.0 |
| 2002-01-09 | FCTR | ETF | 17.3 | 17.54 | 16.75 | 16.75 | 26800.0 |
| 2002-01-09 | FMAR | ETF | 10.1 | 10.1 | 9.9 | 9.94 | 9700.0 |
| 2002-01-09 | GLDB | ETF | 7.3 | 7.34 | 7.2 | 7.26 | 28300.0 |
| 2002-01-09 | GSIG | ETF | 10.32 | 10.72 | 10.22 | 10.49 | 127200.0 |
| 2002-01-09 | IBB | ETF | 29.1167 | 29.5667 | 28.6667 | 28.75 | 1029300.0 |
| 2002-01-09 | ICF | ETF | 21.25 | 21.25 | 21.1 | 21.1 | 26000.0 |
| 2002-01-09 | IDU | ETF | 31.475 | 31.84 | 31.45 | 31.575 | 70400.0 |
| 2002-01-09 | IEV | ETF | 29.47 | 29.47 | 29.025 | 29.025 | 116400.0 |
| 2002-01-09 | IGE | ETF | 15.6483 | 15.6483 | 15.6483 | 15.6483 | 600.0 |
| 2002-01-09 | IGLD | ETF | 101.0 | 108.0 | 101.0 | 105.0 | 922.0 |
| 2002-01-09 | IGM | ETF | 9.1667 | 9.2667 | 9.0167 | 9.0167 | 95400.0 |
| 2002-01-09 | IGN | ETF | 34.1 | 34.4 | 33.25 | 33.25 | 6300.0 |
| 2002-01-09 | IGV | ETF | 10.03 | 10.214 | 9.88 | 9.88 | 1543000.0 |
| 2002-01-09 | IJH | ETF | 10.295 | 10.385 | 10.235 | 10.235 | 293000.0 |
> showing 50 of 119 rows — these rows as CSV