PREVIEW / etf_daily / 2001-07-11
file: by_date/etf_daily/2001/2001-07-11.parquet size: 8 KB rows: 99
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-11 | SPY | ETF | 118.1 | 118.89 | 117.09 | 118.38 | 15328600.0 |
| 2001-07-11 | QQQ | ETF | 40.42 | 41.1 | 39.87 | 41.0 | 77843600.0 |
| 2001-07-11 | IWM | ETF | 47.4 | 47.62 | 46.745 | 47.5 | 1103400.0 |
| 2001-07-11 | DIA | ETF | 102.03 | 102.93 | 101.34 | 102.55 | 3559600.0 |
| 2001-07-11 | BBH | ETF | 39.0667 | 39.3267 | 37.9233 | 38.9667 | 6418200.0 |
| 2001-07-11 | BITS | ETF | 12.68 | 12.8 | 12.04 | 12.04 | 3325.0 |
| 2001-07-11 | CEF | ETF | 3.1 | 3.13 | 3.1 | 3.13 | 4400.0 |
| 2001-07-11 | CHB | ETF | 10.5 | 10.5 | 9.9 | 9.99 | 424700.0 |
| 2001-07-11 | CNXT | ETF | 7.53 | 8.28 | 7.48 | 8.11 | 3263400.0 |
| 2001-07-11 | CSB | ETF | 2.5 | 2.5 | 2.5 | 2.5 | 50000.0 |
| 2001-07-11 | DGT | ETF | 67.74 | 67.74 | 67.6 | 67.6 | 500.0 |
| 2001-07-11 | EWA | ETF | 9.39 | 9.39 | 9.3 | 9.31 | 17800.0 |
| 2001-07-11 | EWC | ETF | 11.3 | 11.3 | 11.05 | 11.07 | 12800.0 |
| 2001-07-11 | EWD | ETF | 12.6 | 12.6 | 12.37 | 12.45 | 10700.0 |
| 2001-07-11 | EWG | ETF | 15.87 | 16.1 | 15.85 | 15.92 | 172400.0 |
| 2001-07-11 | EWH | ETF | 9.7 | 9.85 | 9.68 | 9.8 | 29400.0 |
| 2001-07-11 | EWI | ETF | 36.06 | 36.06 | 35.42 | 35.64 | 17500.0 |
| 2001-07-11 | EWJ | ETF | 38.64 | 38.96 | 38.32 | 38.76 | 82200.0 |
| 2001-07-11 | EWK | ETF | 11.15 | 11.25 | 11.15 | 11.15 | 2200.0 |
| 2001-07-11 | EWL | ETF | 12.85 | 12.95 | 12.75 | 12.95 | 10300.0 |
| 2001-07-11 | EWM | ETF | 17.8 | 18.0 | 17.6 | 17.6 | 6925.0 |
| 2001-07-11 | EWN | ETF | 18.75 | 19.0 | 18.75 | 18.95 | 4700.0 |
| 2001-07-11 | EWO | ETF | 8.0 | 8.0 | 8.0 | 8.0 | 100.0 |
| 2001-07-11 | EWP | ETF | 20.25 | 20.4 | 20.1 | 20.1 | 31700.0 |
| 2001-07-11 | EWQ | ETF | 19.16 | 19.22 | 19.1 | 19.11 | 71800.0 |
| 2001-07-11 | EWS | ETF | 10.26 | 10.3 | 10.14 | 10.16 | 12200.0 |
| 2001-07-11 | EWT | ETF | 18.38 | 18.58 | 18.02 | 18.58 | 7950.0 |
| 2001-07-11 | EWU | ETF | 30.16 | 30.3 | 30.0 | 30.24 | 106650.0 |
| 2001-07-11 | EWW | ETF | 16.15 | 16.34 | 15.7 | 15.75 | 68000.0 |
| 2001-07-11 | EWY | ETF | 13.05 | 13.19 | 13.01 | 13.14 | 3900.0 |
| 2001-07-11 | EWZ | ETF | 12.17 | 12.3 | 12.02 | 12.3 | 15800.0 |
| 2001-07-11 | EZU | ETF | 28.5 | 29.045 | 28.5 | 28.91 | 7200.0 |
| 2001-07-11 | FCTR | ETF | 16.59 | 16.59 | 15.88 | 15.88 | 27300.0 |
| 2001-07-11 | FMAR | ETF | 5.78 | 6.15 | 5.75 | 6.15 | 5600.0 |
| 2001-07-11 | GLDB | ETF | 7.18 | 7.69 | 7.07 | 7.55 | 42200.0 |
| 2001-07-11 | GSIG | ETF | 8.35 | 8.36 | 7.7 | 7.8 | 264000.0 |
| 2001-07-11 | IBB | ETF | 29.6667 | 29.75 | 28.8167 | 29.1667 | 623400.0 |
| 2001-07-11 | ICF | ETF | 20.8375 | 20.85 | 20.79 | 20.79 | 6000.0 |
| 2001-07-11 | IDU | ETF | 40.725 | 40.725 | 39.9 | 39.955 | 14400.0 |
| 2001-07-11 | IEV | ETF | 30.1 | 30.495 | 29.75 | 30.49 | 171400.0 |
| 2001-07-11 | IGLD | ETF | 69.0 | 69.0 | 69.0 | 69.0 | 6.0 |
| 2001-07-11 | IGM | ETF | 8.8033 | 8.825 | 8.6333 | 8.7583 | 685200.0 |
| 2001-07-11 | IJH | ETF | 9.915 | 9.926 | 9.802 | 9.913 | 106000.0 |
| 2001-07-11 | IJJ | ETF | 22.08 | 22.1425 | 21.8825 | 22.135 | 1129200.0 |
| 2001-07-11 | IJK | ETF | 13.7938 | 13.8 | 13.6438 | 13.7712 | 88800.0 |
| 2001-07-11 | IJR | ETF | 18.1083 | 18.225 | 17.975 | 18.225 | 308400.0 |
| 2001-07-11 | IJS | ETF | 20.3375 | 20.3775 | 20.125 | 20.3775 | 199600.0 |
| 2001-07-11 | IJT | ETF | 18.2375 | 18.26 | 18.075 | 18.225 | 25200.0 |
| 2001-07-11 | IOO | ETF | 29.975 | 29.975 | 29.825 | 29.935 | 5200.0 |
| 2001-07-11 | IUSG | ETF | 20.775 | 20.785 | 20.775 | 20.785 | 1600.0 |
> showing 50 of 99 rows — these rows as CSV