PREVIEW / etf_daily / 2002-07-24
file: by_date/etf_daily/2002/2002-07-24.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-07-24 | SPY | ETF | 78.13 | 85.12 | 77.68 | 84.72 | 107022800.0 |
| 2002-07-24 | QQQ | ETF | 21.816 | 23.66 | 21.64 | 23.62 | 186594800.0 |
| 2002-07-24 | IWM | ETF | 35.2 | 38.0 | 34.75 | 38.0 | 6626600.0 |
| 2002-07-24 | DIA | ETF | 75.75 | 82.5 | 75.28 | 82.1 | 24784000.0 |
| 2002-07-24 | ARB | ETF | 30.1 | 30.6 | 28.6 | 30.43 | 303900.0 |
| 2002-07-24 | BBH | ETF | 22.8633 | 24.24 | 22.3 | 24.2333 | 7862100.0 |
| 2002-07-24 | BITS | ETF | 9.0 | 10.08 | 9.0 | 9.4 | 3150.0 |
| 2002-07-24 | CEF | ETF | 4.05 | 4.17 | 3.98 | 4.12 | 442900.0 |
| 2002-07-24 | CHB | ETF | 3.0 | 3.05 | 2.55 | 3.05 | 683300.0 |
| 2002-07-24 | CNXT | ETF | 1.57 | 2.01 | 1.52 | 1.95 | 9908520.0 |
| 2002-07-24 | CSB | ETF | 4.90000009536743 | 4.90000009536743 | 4.5 | 4.5 | 47300.0 |
| 2002-07-24 | DGT | ETF | 43.65 | 46.55 | 43.47 | 46.55 | 1000.0 |
| 2002-07-24 | EFA | ETF | 32.6 | 34.8367 | 32.5 | 34.8367 | 2543400.0 |
| 2002-07-24 | ELV | ETF | 29.75 | 32.0 | 29.635 | 31.505 | 16558700.0 |
| 2002-07-24 | EPP | ETF | 16.9367 | 17.88 | 16.9367 | 17.88 | 113100.0 |
| 2002-07-24 | EWA | ETF | 8.7 | 9.2 | 8.65 | 9.2 | 64600.0 |
| 2002-07-24 | EWC | ETF | 8.75 | 9.14 | 8.6 | 9.05 | 23200.0 |
| 2002-07-24 | EWD | ETF | 8.56 | 9.75 | 8.56 | 9.75 | 149300.0 |
| 2002-07-24 | EWG | ETF | 10.84 | 12.19 | 10.7 | 12.14 | 109600.0 |
| 2002-07-24 | EWH | ETF | 8.05 | 8.53 | 8.04 | 8.45 | 110200.0 |
| 2002-07-24 | EWI | ETF | 27.0 | 28.6 | 26.76 | 28.2 | 14000.0 |
| 2002-07-24 | EWJ | ETF | 32.2 | 33.44 | 32.12 | 33.44 | 612525.0 |
| 2002-07-24 | EWK | ETF | 8.81 | 9.5 | 8.81 | 9.5 | 9000.0 |
| 2002-07-24 | EWL | ETF | 10.11 | 11.29 | 10.1 | 11.06 | 75600.0 |
| 2002-07-24 | EWM | ETF | 22.6 | 23.0 | 22.6 | 23.0 | 11000.0 |
| 2002-07-24 | EWN | ETF | 12.41 | 13.65 | 12.41 | 13.65 | 22900.0 |
| 2002-07-24 | EWO | ETF | 8.05 | 8.35 | 8.01 | 8.35 | 9300.0 |
| 2002-07-24 | EWP | ETF | 16.56 | 17.81 | 16.51 | 17.81 | 8600.0 |
| 2002-07-24 | EWQ | ETF | 13.72 | 14.89 | 13.69 | 14.89 | 197500.0 |
| 2002-07-24 | EWS | ETF | 9.7 | 10.6 | 9.66 | 10.6 | 43400.0 |
| 2002-07-24 | EWT | ETF | 18.64 | 19.7 | 18.42 | 19.68 | 114950.0 |
| 2002-07-24 | EWU | ETF | 22.2 | 24.3 | 22.2 | 24.28 | 51150.0 |
| 2002-07-24 | EWW | ETF | 13.1 | 13.8 | 12.76 | 13.61 | 93600.0 |
| 2002-07-24 | EWY | ETF | 21.12 | 22.44 | 21.0 | 22.4 | 179000.0 |
| 2002-07-24 | EWZ | ETF | 7.82 | 8.5 | 7.76 | 8.35 | 800000.0 |
| 2002-07-24 | EZU | ETF | 20.425 | 22.195 | 20.425 | 22.15 | 129200.0 |
| 2002-07-24 | FCTR | ETF | 16.24 | 16.24 | 15.01 | 16.15 | 42900.0 |
| 2002-07-24 | FMAR | ETF | 10.01 | 10.19 | 9.95 | 10.11 | 10600.0 |
| 2002-07-24 | GLDB | ETF | 9.6 | 9.6 | 8.759 | 9.5 | 138600.0 |
| 2002-07-24 | GSIG | ETF | 6.75 | 7.2 | 6.75 | 6.9 | 29100.0 |
| 2002-07-24 | IBB | ETF | 13.8667 | 15.1667 | 13.8333 | 15.1667 | 5240400.0 |
| 2002-07-24 | ICF | ETF | 18.7 | 19.785 | 18.6125 | 19.425 | 427200.0 |
| 2002-07-24 | IDU | ETF | 20.425 | 22.85 | 20.4 | 22.835 | 549800.0 |
| 2002-07-24 | IEV | ETF | 22.15 | 24.095 | 22.05 | 24.075 | 650800.0 |
| 2002-07-24 | IGE | ETF | 12.0333 | 12.8667 | 12.0167 | 12.8667 | 3600.0 |
| 2002-07-24 | IGLD | ETF | 95.0 | 105.3 | 95.0 | 105.0 | 153.0 |
| 2002-07-24 | IGM | ETF | 4.6667 | 5.0567 | 4.6667 | 5.0567 | 49800.0 |
| 2002-07-24 | IGN | ETF | 13.05 | 13.95 | 13.0 | 13.95 | 15500.0 |
| 2002-07-24 | IGV | ETF | 4.24 | 4.686 | 4.24 | 4.686 | 119500.0 |
| 2002-07-24 | IJH | ETF | 7.675 | 8.31 | 7.671 | 8.31 | 1802000.0 |
> showing 50 of 117 rows — these rows as CSV