PREVIEW / etf_daily / 2001-07-05
file: by_date/etf_daily/2001/2001-07-05.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-05 | SPY | ETF | 123.07 | 123.65 | 121.66 | 121.68 | 5517900.0 |
| 2001-07-05 | QQQ | ETF | 44.87 | 45.189 | 43.45 | 43.45 | 44409800.0 |
| 2001-07-05 | IWM | ETF | 49.0 | 49.495 | 48.775 | 48.85 | 849600.0 |
| 2001-07-05 | DIA | ETF | 105.25 | 105.74 | 104.65 | 104.65 | 1072000.0 |
| 2001-07-05 | BBH | ETF | 43.67 | 43.9633 | 42.06 | 42.0733 | 2725800.0 |
| 2001-07-05 | BITS | ETF | 12.96 | 13.0 | 12.28 | 12.4 | 550.0 |
| 2001-07-05 | CEF | ETF | 3.16 | 3.24 | 3.16 | 3.24 | 17000.0 |
| 2001-07-05 | CHB | ETF | 11.38 | 11.49 | 11.02 | 11.42 | 318200.0 |
| 2001-07-05 | CNXT | ETF | 8.23 | 8.28 | 7.95 | 8.0 | 976000.0 |
| 2001-07-05 | CSB | ETF | 2.20000004768372 | 2.20000004768372 | 2.20000004768372 | 2.20000004768372 | 10000.0 |
| 2001-07-05 | DGT | ETF | 69.88 | 69.88 | 69.8 | 69.8 | 200.0 |
| 2001-07-05 | EWA | ETF | 9.6 | 9.6 | 9.48 | 9.5 | 13500.0 |
| 2001-07-05 | EWC | ETF | 11.6 | 11.6 | 11.35 | 11.35 | 4700.0 |
| 2001-07-05 | EWD | ETF | 13.2 | 13.2 | 13.11 | 13.11 | 400.0 |
| 2001-07-05 | EWG | ETF | 16.25 | 16.25 | 16.1 | 16.1 | 17800.0 |
| 2001-07-05 | EWH | ETF | 9.96 | 9.99 | 9.91 | 9.91 | 28500.0 |
| 2001-07-05 | EWI | ETF | 35.6 | 35.62 | 35.6 | 35.6 | 900.0 |
| 2001-07-05 | EWJ | ETF | 39.68 | 39.92 | 39.44 | 39.44 | 95825.0 |
| 2001-07-05 | EWK | ETF | 11.06 | 11.06 | 11.05 | 11.05 | 11000.0 |
| 2001-07-05 | EWL | ETF | 13.15 | 13.15 | 13.0 | 13.1 | 4100.0 |
| 2001-07-05 | EWM | ETF | 17.6 | 18.0 | 17.6 | 18.0 | 6350.0 |
| 2001-07-05 | EWN | ETF | 19.2 | 19.2 | 19.2 | 19.2 | 100.0 |
| 2001-07-05 | EWP | ETF | 20.9 | 20.9 | 20.75 | 20.75 | 14400.0 |
| 2001-07-05 | EWQ | ETF | 19.49 | 19.49 | 19.3 | 19.44 | 4500.0 |
| 2001-07-05 | EWS | ETF | 10.6 | 10.6 | 10.52 | 10.52 | 5300.0 |
| 2001-07-05 | EWT | ETF | 19.88 | 19.9 | 19.42 | 19.78 | 65050.0 |
| 2001-07-05 | EWU | ETF | 30.8 | 30.86 | 30.66 | 30.86 | 15650.0 |
| 2001-07-05 | EWW | ETF | 17.0 | 17.19 | 16.99 | 17.05 | 54700.0 |
| 2001-07-05 | EWY | ETF | 14.18 | 14.18 | 14.12 | 14.12 | 1100.0 |
| 2001-07-05 | EWZ | ETF | 14.0 | 14.0 | 13.0 | 13.0 | 15100.0 |
| 2001-07-05 | EZU | ETF | 29.025 | 29.445 | 29.025 | 29.34 | 100200.0 |
| 2001-07-05 | FCTR | ETF | 17.14 | 17.48 | 17.04 | 17.04 | 10600.0 |
| 2001-07-05 | FMAR | ETF | 5.85 | 6.25 | 5.25 | 6.25 | 7200.0 |
| 2001-07-05 | GLDB | ETF | 7.92 | 7.99 | 7.7 | 7.75 | 39500.0 |
| 2001-07-05 | GSIG | ETF | 9.2 | 9.2 | 8.83 | 8.9 | 168600.0 |
| 2001-07-05 | IBB | ETF | 32.9167 | 32.9167 | 31.6733 | 31.6733 | 384300.0 |
| 2001-07-05 | IDU | ETF | 39.55 | 39.945 | 39.5 | 39.945 | 4000.0 |
| 2001-07-05 | IEV | ETF | 30.845 | 30.945 | 30.39 | 30.74 | 38600.0 |
| 2001-07-05 | IGLD | ETF | 70.0 | 72.0 | 70.0 | 71.0 | 33.0 |
| 2001-07-05 | IGM | ETF | 9.775 | 9.775 | 9.6033 | 9.6033 | 6600.0 |
| 2001-07-05 | IJH | ETF | 10.292 | 10.329 | 10.242 | 10.242 | 155000.0 |
| 2001-07-05 | IJJ | ETF | 22.825 | 22.89 | 22.755 | 22.78 | 48000.0 |
| 2001-07-05 | IJK | ETF | 14.41 | 14.4662 | 14.2712 | 14.2712 | 58400.0 |
| 2001-07-05 | IJR | ETF | 18.75 | 18.8 | 18.6667 | 18.69 | 488400.0 |
| 2001-07-05 | IJS | ETF | 20.9375 | 20.975 | 20.9 | 20.9075 | 26800.0 |
| 2001-07-05 | IJT | ETF | 18.8875 | 18.95 | 18.8375 | 18.885 | 22800.0 |
| 2001-07-05 | IOO | ETF | 31.3 | 31.3 | 30.965 | 30.965 | 4000.0 |
| 2001-07-05 | IUSG | ETF | 21.985 | 21.985 | 21.785 | 21.785 | 2400.0 |
| 2001-07-05 | IUSV | ETF | 25.11 | 25.11 | 24.9933 | 24.9933 | 8100.0 |
| 2001-07-05 | IVE | ETF | 61.83 | 61.9 | 61.45 | 61.45 | 18000.0 |
> showing 50 of 98 rows — these rows as CSV