PREVIEW / etf_daily / 2001-09-05
file: by_date/etf_daily/2001/2001-09-05.parquet size: 9 KB rows: 106
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-09-05 | SPY | ETF | 113.7 | 114.19 | 111.95 | 113.7 | 21477100.0 |
| 2001-09-05 | QQQ | ETF | 35.49 | 35.91 | 34.15 | 35.33 | 95461200.0 |
| 2001-09-05 | IWM | ETF | 46.6 | 46.675 | 45.7 | 46.175 | 569200.0 |
| 2001-09-05 | DIA | ETF | 100.0 | 100.95 | 99.01 | 100.56 | 7027300.0 |
| 2001-09-05 | BBH | ETF | 41.3333 | 41.6 | 40.5067 | 41.1667 | 2179500.0 |
| 2001-09-05 | BITS | ETF | 15.28 | 15.76 | 14.72 | 14.8 | 3275.0 |
| 2001-09-05 | BOSS | ETF | 19.7 | 19.7 | 19.7 | 19.7 | 100.0 |
| 2001-09-05 | CHB | ETF | 10.15 | 10.45 | 10.15 | 10.4 | 172000.0 |
| 2001-09-05 | CNXT | ETF | 11.42 | 11.54 | 10.46 | 11.33 | 4578830.0 |
| 2001-09-05 | CSB | ETF | 3.5 | 3.5 | 3.5 | 3.5 | 44000.0 |
| 2001-09-05 | DGT | ETF | 64.25 | 64.89 | 64.25 | 64.89 | 2200.0 |
| 2001-09-05 | EFA | ETF | 40.5667 | 40.6833 | 40.3333 | 40.45 | 31500.0 |
| 2001-09-05 | EWA | ETF | 9.21 | 9.25 | 9.15 | 9.25 | 13500.0 |
| 2001-09-05 | EWC | ETF | 10.7 | 10.79 | 10.58 | 10.58 | 204400.0 |
| 2001-09-05 | EWD | ETF | 12.05 | 12.05 | 11.96 | 11.98 | 7400.0 |
| 2001-09-05 | EWG | ETF | 14.6 | 14.73 | 14.45 | 14.55 | 21400.0 |
| 2001-09-05 | EWH | ETF | 8.92 | 8.92 | 8.77 | 8.91 | 18800.0 |
| 2001-09-05 | EWI | ETF | 33.72 | 34.08 | 33.38 | 33.58 | 2600.0 |
| 2001-09-05 | EWJ | ETF | 35.56 | 35.6 | 34.84 | 35.16 | 160900.0 |
| 2001-09-05 | EWK | ETF | 11.28 | 11.35 | 11.28 | 11.35 | 2300.0 |
| 2001-09-05 | EWL | ETF | 12.51 | 12.65 | 12.51 | 12.63 | 2800.0 |
| 2001-09-05 | EWM | ETF | 19.8 | 20.16 | 19.8 | 20.16 | 19925.0 |
| 2001-09-05 | EWN | ETF | 17.95 | 17.95 | 17.84 | 17.85 | 2000.0 |
| 2001-09-05 | EWO | ETF | 8.0 | 8.0 | 7.91 | 8.0 | 2700.0 |
| 2001-09-05 | EWP | ETF | 20.31 | 20.31 | 20.15 | 20.15 | 500.0 |
| 2001-09-05 | EWQ | ETF | 18.88 | 18.88 | 18.56 | 18.63 | 13800.0 |
| 2001-09-05 | EWS | ETF | 10.6 | 10.7 | 10.6 | 10.66 | 1550.0 |
| 2001-09-05 | EWT | ETF | 17.9 | 17.9 | 17.52 | 17.72 | 41600.0 |
| 2001-09-05 | EWU | ETF | 30.24 | 30.3 | 29.9 | 30.3 | 6950.0 |
| 2001-09-05 | EWW | ETF | 15.05 | 15.05 | 14.6 | 14.8 | 12400.0 |
| 2001-09-05 | EWY | ETF | 13.44 | 13.44 | 13.18 | 13.43 | 2900.0 |
| 2001-09-05 | EWZ | ETF | 10.9 | 10.91 | 10.9 | 10.91 | 15800.0 |
| 2001-09-05 | EZU | ETF | 27.25 | 27.375 | 27.08 | 27.15 | 10400.0 |
| 2001-09-05 | FCTR | ETF | 17.25 | 17.25 | 16.9 | 17.17 | 23500.0 |
| 2001-09-05 | FMAR | ETF | 9.15 | 9.35 | 9.05 | 9.1 | 8700.0 |
| 2001-09-05 | GLDB | ETF | 7.63 | 7.75 | 7.5 | 7.75 | 76200.0 |
| 2001-09-05 | GRNB | ETF | 19.6331 | 19.6331 | 19.6331 | 19.6331 | 7671.0 |
| 2001-09-05 | GSIG | ETF | 8.2 | 8.32 | 8.11 | 8.24 | 228900.0 |
| 2001-09-05 | IBB | ETF | 29.4 | 29.6467 | 28.75 | 29.1833 | 441000.0 |
| 2001-09-05 | ICF | ETF | 21.79 | 21.79 | 21.6625 | 21.69 | 117200.0 |
| 2001-09-05 | IDU | ETF | 36.5 | 36.735 | 36.425 | 36.43 | 11600.0 |
| 2001-09-05 | IEV | ETF | 29.525 | 29.65 | 29.355 | 29.515 | 24400.0 |
| 2001-09-05 | IGLD | ETF | 70.0 | 70.0 | 63.0 | 66.0 | 34.0 |
| 2001-09-05 | IGM | ETF | 7.625 | 7.665 | 7.4583 | 7.5833 | 37200.0 |
| 2001-09-05 | IGN | ETF | 29.5 | 29.5 | 28.05 | 28.73 | 3000.0 |
| 2001-09-05 | IGV | ETF | 7.552 | 7.552 | 7.45 | 7.45 | 6000.0 |
| 2001-09-05 | IJH | ETF | 9.811 | 9.839 | 9.654 | 9.731 | 167000.0 |
| 2001-09-05 | IJJ | ETF | 22.225 | 22.225 | 21.925 | 22.0225 | 125200.0 |
| 2001-09-05 | IJK | ETF | 13.45 | 13.5 | 13.1775 | 13.2925 | 66400.0 |
| 2001-09-05 | IJR | ETF | 18.435 | 18.4483 | 18.1683 | 18.3033 | 351000.0 |
> showing 50 of 106 rows — these rows as CSV