PREVIEW / etf_daily / 2001-07-12
file: by_date/etf_daily/2001/2001-07-12.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-12 | SPY | ETF | 119.5 | 121.47 | 119.31 | 121.19 | 12002800.0 |
| 2001-07-12 | QQQ | ETF | 42.63 | 43.83 | 42.3 | 43.6 | 70367600.0 |
| 2001-07-12 | IWM | ETF | 47.9 | 48.75 | 47.875 | 48.665 | 1254200.0 |
| 2001-07-12 | DIA | ETF | 103.45 | 105.3 | 103.21 | 105.15 | 3186600.0 |
| 2001-07-12 | BBH | ETF | 38.0733 | 38.21 | 37.67 | 37.8 | 5365800.0 |
| 2001-07-12 | BITS | ETF | 12.08 | 12.6 | 12.04 | 12.6 | 3725.0 |
| 2001-07-12 | CEF | ETF | 3.13 | 3.13 | 3.13 | 3.13 | 5100.0 |
| 2001-07-12 | CHB | ETF | 10.0 | 11.05 | 10.0 | 11.05 | 224600.0 |
| 2001-07-12 | CNXT | ETF | 8.5 | 9.15 | 8.45 | 9.05 | 4941300.0 |
| 2001-07-12 | DGT | ETF | 68.64 | 69.3 | 68.64 | 69.3 | 2500.0 |
| 2001-07-12 | EWA | ETF | 9.4 | 9.45 | 9.35 | 9.35 | 42400.0 |
| 2001-07-12 | EWC | ETF | 11.35 | 11.45 | 11.19 | 11.45 | 3300.0 |
| 2001-07-12 | EWD | ETF | 12.7 | 12.98 | 12.7 | 12.8 | 18800.0 |
| 2001-07-12 | EWG | ETF | 16.17 | 16.17 | 16.05 | 16.15 | 70800.0 |
| 2001-07-12 | EWH | ETF | 9.87 | 10.05 | 9.87 | 10.05 | 160800.0 |
| 2001-07-12 | EWI | ETF | 35.42 | 35.42 | 35.0 | 35.2 | 14650.0 |
| 2001-07-12 | EWJ | ETF | 39.4 | 39.96 | 39.32 | 39.84 | 113325.0 |
| 2001-07-12 | EWK | ETF | 11.2 | 11.38 | 11.18 | 11.38 | 37300.0 |
| 2001-07-12 | EWL | ETF | 12.85 | 13.15 | 12.85 | 13.15 | 60700.0 |
| 2001-07-12 | EWM | ETF | 17.56 | 17.8 | 17.4 | 17.6 | 6000.0 |
| 2001-07-12 | EWN | ETF | 18.7 | 19.0 | 18.7 | 19.0 | 37500.0 |
| 2001-07-12 | EWO | ETF | 7.95 | 7.95 | 7.95 | 7.95 | 1600.0 |
| 2001-07-12 | EWP | ETF | 19.7 | 19.95 | 19.7 | 19.95 | 17600.0 |
| 2001-07-12 | EWQ | ETF | 19.15 | 19.23 | 19.08 | 19.23 | 70000.0 |
| 2001-07-12 | EWS | ETF | 10.32 | 10.44 | 10.26 | 10.44 | 55750.0 |
| 2001-07-12 | EWT | ETF | 18.5 | 19.0 | 18.5 | 19.0 | 3600.0 |
| 2001-07-12 | EWU | ETF | 30.3 | 30.9 | 30.2 | 30.9 | 107850.0 |
| 2001-07-12 | EWW | ETF | 16.05 | 16.05 | 15.36 | 15.5 | 47300.0 |
| 2001-07-12 | EWY | ETF | 13.25 | 13.53 | 13.25 | 13.4 | 7800.0 |
| 2001-07-12 | EWZ | ETF | 12.35 | 12.74 | 12.06 | 12.74 | 7000.0 |
| 2001-07-12 | EZU | ETF | 28.755 | 28.945 | 28.71 | 28.945 | 5200.0 |
| 2001-07-12 | FCTR | ETF | 15.89 | 16.65 | 15.88 | 16.65 | 140800.0 |
| 2001-07-12 | FMAR | ETF | 6.15 | 6.55 | 6.15 | 6.55 | 1000.0 |
| 2001-07-12 | GLDB | ETF | 7.6 | 7.65 | 7.4 | 7.5 | 40800.0 |
| 2001-07-12 | GSIG | ETF | 7.88 | 8.44 | 7.86 | 8.24 | 375300.0 |
| 2001-07-12 | IBB | ETF | 29.4167 | 29.4167 | 28.7167 | 28.9467 | 551400.0 |
| 2001-07-12 | ICF | ETF | 20.875 | 20.9375 | 20.875 | 20.9375 | 2000.0 |
| 2001-07-12 | IDU | ETF | 39.7 | 39.85 | 39.525 | 39.65 | 10400.0 |
| 2001-07-12 | IEV | ETF | 30.34 | 30.625 | 29.805 | 30.25 | 32400.0 |
| 2001-07-12 | IGLD | ETF | 69.0 | 69.0 | 69.0 | 69.0 | 22.0 |
| 2001-07-12 | IGM | ETF | 9.15 | 9.4483 | 9.15 | 9.4483 | 685800.0 |
| 2001-07-12 | IJH | ETF | 9.995 | 10.14 | 9.975 | 10.14 | 158000.0 |
| 2001-07-12 | IJJ | ETF | 22.295 | 22.58 | 22.2325 | 22.58 | 284400.0 |
| 2001-07-12 | IJK | ETF | 13.9262 | 14.1362 | 13.9262 | 14.1362 | 59200.0 |
| 2001-07-12 | IJR | ETF | 18.3 | 18.6933 | 18.3 | 18.6817 | 811200.0 |
| 2001-07-12 | IJS | ETF | 20.45 | 20.8525 | 20.4375 | 20.8525 | 226000.0 |
| 2001-07-12 | IJT | ETF | 18.47 | 18.8375 | 18.47 | 18.8375 | 43600.0 |
| 2001-07-12 | IOO | ETF | 30.3 | 30.585 | 30.3 | 30.585 | 26200.0 |
| 2001-07-12 | IUSG | ETF | 21.3 | 21.43 | 21.27 | 21.33 | 9400.0 |
| 2001-07-12 | IUSV | ETF | 24.5233 | 24.8867 | 24.5233 | 24.8867 | 3900.0 |
> showing 50 of 99 rows — these rows as CSV