PREVIEW / etf_daily / 2001-07-13
file: by_date/etf_daily/2001/2001-07-13.parquet size: 8 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-13 | SPY | ETF | 120.84 | 122.32 | 120.62 | 122.24 | 10433800.0 |
| 2001-07-13 | QQQ | ETF | 43.38 | 44.43 | 42.9 | 43.15 | 62477800.0 |
| 2001-07-13 | IWM | ETF | 48.55 | 49.075 | 48.35 | 48.9 | 241200.0 |
| 2001-07-13 | DIA | ETF | 104.75 | 105.7 | 104.4 | 105.68 | 1200700.0 |
| 2001-07-13 | BBH | ETF | 37.8667 | 39.36 | 37.8667 | 38.8667 | 4699800.0 |
| 2001-07-13 | BITS | ETF | 12.72 | 12.72 | 12.44 | 12.48 | 2825.0 |
| 2001-07-13 | CEF | ETF | 3.06 | 3.12 | 3.06 | 3.06 | 18700.0 |
| 2001-07-13 | CHB | ETF | 11.12 | 11.12 | 10.79 | 11.0 | 206900.0 |
| 2001-07-13 | CNXT | ETF | 8.671 | 9.166 | 8.423 | 8.76 | 3425320.0 |
| 2001-07-13 | DGT | ETF | 69.15 | 69.5 | 69.15 | 69.5 | 5600.0 |
| 2001-07-13 | EWA | ETF | 9.35 | 9.5 | 9.35 | 9.45 | 4200.0 |
| 2001-07-13 | EWC | ETF | 11.4 | 11.4 | 11.4 | 11.4 | 1600.0 |
| 2001-07-13 | EWD | ETF | 12.8 | 13.15 | 12.8 | 13.07 | 3800.0 |
| 2001-07-13 | EWG | ETF | 16.1 | 16.3 | 16.1 | 16.2 | 6700.0 |
| 2001-07-13 | EWH | ETF | 9.87 | 9.96 | 9.87 | 9.93 | 14600.0 |
| 2001-07-13 | EWI | ETF | 34.8 | 35.4 | 34.8 | 35.0 | 2700.0 |
| 2001-07-13 | EWJ | ETF | 39.4 | 39.56 | 39.08 | 39.16 | 134325.0 |
| 2001-07-13 | EWL | ETF | 13.0 | 13.1 | 12.86 | 13.02 | 4500.0 |
| 2001-07-13 | EWM | ETF | 17.6 | 18.2 | 17.6 | 18.0 | 1450.0 |
| 2001-07-13 | EWN | ETF | 18.8 | 18.8 | 18.8 | 18.8 | 100.0 |
| 2001-07-13 | EWP | ETF | 20.15 | 20.15 | 20.0 | 20.0 | 300.0 |
| 2001-07-13 | EWQ | ETF | 19.15 | 19.35 | 19.15 | 19.35 | 11000.0 |
| 2001-07-13 | EWS | ETF | 10.26 | 10.28 | 10.18 | 10.28 | 2850.0 |
| 2001-07-13 | EWT | ETF | 18.68 | 18.68 | 18.2 | 18.4 | 68200.0 |
| 2001-07-13 | EWU | ETF | 30.6 | 30.9 | 30.32 | 30.74 | 18600.0 |
| 2001-07-13 | EWW | ETF | 15.75 | 15.75 | 15.35 | 15.45 | 12600.0 |
| 2001-07-13 | EWY | ETF | 13.1 | 13.1 | 13.0 | 13.1 | 2400.0 |
| 2001-07-13 | EWZ | ETF | 12.55 | 12.75 | 12.41 | 12.46 | 6100.0 |
| 2001-07-13 | EZU | ETF | 29.05 | 29.065 | 28.875 | 29.065 | 4800.0 |
| 2001-07-13 | FCTR | ETF | 16.5 | 16.65 | 16.5 | 16.6 | 7000.0 |
| 2001-07-13 | FMAR | ETF | 6.0 | 6.4 | 5.75 | 6.4 | 11300.0 |
| 2001-07-13 | GLDB | ETF | 7.55 | 7.69 | 7.33 | 7.33 | 34700.0 |
| 2001-07-13 | GSIG | ETF | 8.2 | 8.27 | 8.15 | 8.2 | 49500.0 |
| 2001-07-13 | IBB | ETF | 28.9333 | 30.1167 | 28.9333 | 29.6667 | 1152600.0 |
| 2001-07-13 | ICF | ETF | 21.0125 | 21.075 | 21.005 | 21.075 | 14800.0 |
| 2001-07-13 | IDU | ETF | 39.7 | 39.7 | 39.34 | 39.405 | 12600.0 |
| 2001-07-13 | IEV | ETF | 30.15 | 30.525 | 30.15 | 30.5 | 46400.0 |
| 2001-07-13 | IGLD | ETF | 69.0 | 69.0 | 69.0 | 69.0 | 11.0 |
| 2001-07-13 | IGM | ETF | 9.4 | 9.5 | 9.395 | 9.4633 | 314400.0 |
| 2001-07-13 | IJH | ETF | 10.105 | 10.223 | 10.105 | 10.183 | 85000.0 |
| 2001-07-13 | IJJ | ETF | 22.495 | 22.7025 | 22.425 | 22.665 | 76000.0 |
| 2001-07-13 | IJK | ETF | 14.225 | 14.275 | 14.1675 | 14.1675 | 107200.0 |
| 2001-07-13 | IJR | ETF | 18.65 | 18.8 | 18.6467 | 18.7833 | 164400.0 |
| 2001-07-13 | IJS | ETF | 20.825 | 20.955 | 20.795 | 20.9525 | 69600.0 |
| 2001-07-13 | IJT | ETF | 18.8 | 18.9925 | 18.8 | 18.9475 | 28000.0 |
| 2001-07-13 | IOO | ETF | 30.415 | 30.6 | 30.415 | 30.6 | 33800.0 |
| 2001-07-13 | IUSG | ETF | 21.585 | 21.83 | 21.555 | 21.785 | 62400.0 |
| 2001-07-13 | IUSV | ETF | 24.9233 | 24.9633 | 24.9233 | 24.9633 | 600.0 |
| 2001-07-13 | IVE | ETF | 60.76 | 61.23 | 60.7 | 61.15 | 502200.0 |
| 2001-07-13 | IVV | ETF | 120.81 | 122.2 | 120.66 | 122.0 | 101800.0 |
> showing 50 of 98 rows — these rows as CSV