PREVIEW / etf_daily / 2001-06-29
file: by_date/etf_daily/2001/2001-06-29.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-06-29 | SPY | ETF | 122.8 | 124.01 | 122.26 | 122.6 | 9824200.0 |
| 2001-06-29 | QQQ | ETF | 45.09 | 46.52 | 44.7 | 45.7 | 59719600.0 |
| 2001-06-29 | IWM | ETF | 50.45 | 51.2 | 50.225 | 50.95 | 2283200.0 |
| 2001-06-29 | DIA | ETF | 105.85 | 106.2 | 105.16 | 105.24 | 1571400.0 |
| 2001-06-29 | BBH | ETF | 43.8333 | 44.91 | 43.57 | 44.1667 | 2554800.0 |
| 2001-06-29 | BITS | ETF | 12.92 | 12.92 | 12.28 | 12.4 | 2575.0 |
| 2001-06-29 | CEF | ETF | 3.25 | 3.3 | 3.24 | 3.29 | 13200.0 |
| 2001-06-29 | CHB | ETF | 10.95 | 11.48 | 10.95 | 11.38 | 528200.0 |
| 2001-06-29 | CNXT | ETF | 8.454 | 8.946 | 8.123 | 8.926 | 2108520.0 |
| 2001-06-29 | CSB | ETF | 2.20000004768372 | 2.20000004768372 | 2.20000004768372 | 2.20000004768372 | 14600.0 |
| 2001-06-29 | DGT | ETF | 71.12 | 71.3 | 70.95 | 70.95 | 4000.0 |
| 2001-06-29 | EWA | ETF | 9.7 | 9.78 | 9.68 | 9.69 | 9700.0 |
| 2001-06-29 | EWC | ETF | 11.45 | 11.5 | 11.45 | 11.5 | 4800.0 |
| 2001-06-29 | EWD | ETF | 13.75 | 13.9 | 13.55 | 13.55 | 4500.0 |
| 2001-06-29 | EWG | ETF | 16.55 | 16.6 | 16.38 | 16.6 | 125600.0 |
| 2001-06-29 | EWH | ETF | 10.04 | 10.09 | 10.02 | 10.08 | 27800.0 |
| 2001-06-29 | EWI | ETF | 36.04 | 36.06 | 35.8 | 35.8 | 1900.0 |
| 2001-06-29 | EWJ | ETF | 40.92 | 41.16 | 40.88 | 40.92 | 172825.0 |
| 2001-06-29 | EWL | ETF | 13.45 | 13.45 | 13.2 | 13.45 | 111400.0 |
| 2001-06-29 | EWM | ETF | 17.2 | 17.2 | 17.0 | 17.2 | 4475.0 |
| 2001-06-29 | EWN | ETF | 19.25 | 19.27 | 19.2 | 19.25 | 61000.0 |
| 2001-06-29 | EWO | ETF | 7.85 | 7.85 | 7.85 | 7.85 | 700.0 |
| 2001-06-29 | EWP | ETF | 21.24 | 21.4 | 21.2 | 21.25 | 6700.0 |
| 2001-06-29 | EWQ | ETF | 19.93 | 20.04 | 19.75 | 20.0 | 112000.0 |
| 2001-06-29 | EWS | ETF | 10.86 | 10.86 | 10.82 | 10.86 | 12450.0 |
| 2001-06-29 | EWT | ETF | 20.38 | 21.08 | 19.98 | 21.08 | 2900.0 |
| 2001-06-29 | EWU | ETF | 31.6 | 31.64 | 31.1 | 31.5 | 194000.0 |
| 2001-06-29 | EWW | ETF | 16.5 | 16.89 | 16.5 | 16.85 | 46300.0 |
| 2001-06-29 | EWY | ETF | 14.3 | 14.4 | 14.07 | 14.29 | 6500.0 |
| 2001-06-29 | EWZ | ETF | 14.4 | 14.4 | 14.38 | 14.38 | 1000.0 |
| 2001-06-29 | EZU | ETF | 29.9 | 30.09 | 29.9 | 30.09 | 9600.0 |
| 2001-06-29 | FCTR | ETF | 17.25 | 18.75 | 17.18 | 18.75 | 179000.0 |
| 2001-06-29 | FMAR | ETF | 6.45 | 6.45 | 6.45 | 6.45 | 2000.0 |
| 2001-06-29 | GLDB | ETF | 7.41 | 8.0 | 7.41 | 7.74 | 199900.0 |
| 2001-06-29 | GSIG | ETF | 8.95 | 9.45 | 8.95 | 9.25 | 193500.0 |
| 2001-06-29 | IBB | ETF | 32.8333 | 33.4833 | 32.6833 | 33.2667 | 393900.0 |
| 2001-06-29 | ICF | ETF | 21.345 | 21.345 | 21.27 | 21.285 | 6000.0 |
| 2001-06-29 | IDU | ETF | 39.075 | 39.165 | 39.02 | 39.105 | 3000.0 |
| 2001-06-29 | IEV | ETF | 31.325 | 31.8 | 31.09 | 31.6 | 131000.0 |
| 2001-06-29 | IGLD | ETF | 67.0 | 70.0 | 67.0 | 70.0 | 192.0 |
| 2001-06-29 | IGM | ETF | 9.925 | 9.9833 | 9.8167 | 9.9833 | 25800.0 |
| 2001-06-29 | IJH | ETF | 10.3 | 10.395 | 10.3 | 10.374 | 296000.0 |
| 2001-06-29 | IJJ | ETF | 22.6275 | 22.875 | 22.6175 | 22.875 | 270400.0 |
| 2001-06-29 | IJK | ETF | 14.4438 | 14.67 | 14.4288 | 14.6212 | 56000.0 |
| 2001-06-29 | IJR | ETF | 18.7917 | 19.1217 | 18.7867 | 19.0017 | 667200.0 |
| 2001-06-29 | IJS | ETF | 20.8625 | 21.2175 | 20.8625 | 21.135 | 58800.0 |
| 2001-06-29 | IJT | ETF | 19.0375 | 19.405 | 19.0375 | 19.275 | 54800.0 |
| 2001-06-29 | IOO | ETF | 31.39 | 31.72 | 31.39 | 31.65 | 48000.0 |
| 2001-06-29 | IUSG | ETF | 22.525 | 22.605 | 22.43 | 22.43 | 6400.0 |
| 2001-06-29 | IUSV | ETF | 24.9167 | 25.11 | 24.9167 | 25.0333 | 30600.0 |
> showing 50 of 99 rows — these rows as CSV