PREVIEW / etf_daily / 2001-08-28
file: by_date/etf_daily/2001/2001-08-28.parquet size: 9 KB rows: 105
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-08-28 | SPY | ETF | 118.28 | 118.49 | 116.58 | 116.58 | 12046600.0 |
| 2001-08-28 | QQQ | ETF | 39.32 | 39.44 | 38.011 | 38.12 | 65275500.0 |
| 2001-08-28 | IWM | ETF | 47.825 | 47.85 | 47.25 | 47.35 | 985000.0 |
| 2001-08-28 | DIA | ETF | 103.99 | 103.99 | 102.25 | 102.32 | 2799200.0 |
| 2001-08-28 | BBH | ETF | 42.0 | 42.1133 | 41.1867 | 41.1867 | 3985800.0 |
| 2001-08-28 | BITS | ETF | 15.44 | 15.68 | 15.0 | 15.08 | 1600.0 |
| 2001-08-28 | CEF | ETF | 3.2 | 3.2 | 3.16 | 3.16 | 13600.0 |
| 2001-08-28 | CHB | ETF | 10.45 | 10.45 | 10.3 | 10.38 | 112800.0 |
| 2001-08-28 | CNXT | ETF | 12.45 | 12.85 | 11.81 | 12.06 | 5792140.0 |
| 2001-08-28 | CSB | ETF | 3.29999995231628 | 3.29999995231628 | 3.29999995231628 | 3.29999995231628 | 23700.0 |
| 2001-08-28 | DGT | ETF | 66.82 | 66.82 | 66.65 | 66.65 | 2200.0 |
| 2001-08-28 | EFA | ETF | 42.5333 | 42.5833 | 42.2633 | 42.3433 | 319800.0 |
| 2001-08-28 | EWA | ETF | 9.52 | 9.6 | 9.52 | 9.6 | 2200.0 |
| 2001-08-28 | EWC | ETF | 11.06 | 11.24 | 10.96 | 11.01 | 14700.0 |
| 2001-08-28 | EWD | ETF | 13.75 | 13.8 | 13.55 | 13.69 | 1900.0 |
| 2001-08-28 | EWG | ETF | 15.84 | 15.84 | 15.5 | 15.59 | 30500.0 |
| 2001-08-28 | EWH | ETF | 9.02 | 9.07 | 8.93 | 8.94 | 18000.0 |
| 2001-08-28 | EWI | ETF | 36.22 | 36.36 | 36.0 | 36.36 | 1900.0 |
| 2001-08-28 | EWJ | ETF | 37.56 | 37.6 | 37.0 | 37.24 | 93325.0 |
| 2001-08-28 | EWK | ETF | 11.65 | 11.65 | 11.65 | 11.65 | 7400.0 |
| 2001-08-28 | EWL | ETF | 13.06 | 13.14 | 13.06 | 13.14 | 1600.0 |
| 2001-08-28 | EWM | ETF | 19.8 | 19.8 | 19.6 | 19.6 | 4975.0 |
| 2001-08-28 | EWN | ETF | 19.06 | 19.06 | 18.83 | 18.84 | 11400.0 |
| 2001-08-28 | EWO | ETF | 8.2 | 8.2 | 8.2 | 8.2 | 10000.0 |
| 2001-08-28 | EWP | ETF | 21.95 | 21.95 | 21.3 | 21.3 | 5800.0 |
| 2001-08-28 | EWQ | ETF | 20.26 | 20.28 | 19.92 | 19.98 | 55600.0 |
| 2001-08-28 | EWS | ETF | 10.62 | 10.68 | 10.6 | 10.62 | 8700.0 |
| 2001-08-28 | EWT | ETF | 17.22 | 18.06 | 17.22 | 17.42 | 11600.0 |
| 2001-08-28 | EWU | ETF | 30.78 | 30.8 | 30.28 | 30.58 | 26900.0 |
| 2001-08-28 | EWW | ETF | 15.71 | 15.71 | 15.35 | 15.38 | 3100.0 |
| 2001-08-28 | EWY | ETF | 13.96 | 14.04 | 13.76 | 14.03 | 3300.0 |
| 2001-08-28 | EWZ | ETF | 11.21 | 11.21 | 11.21 | 11.21 | 300.0 |
| 2001-08-28 | EZU | ETF | 29.225 | 29.435 | 29.18 | 29.215 | 3200.0 |
| 2001-08-28 | FCTR | ETF | 18.14 | 18.16 | 17.96 | 17.96 | 15500.0 |
| 2001-08-28 | FMAR | ETF | 9.02 | 9.02 | 9.0 | 9.01 | 2500.0 |
| 2001-08-28 | GLDB | ETF | 7.55 | 7.89 | 7.55 | 7.74 | 49900.0 |
| 2001-08-28 | GSIG | ETF | 8.3 | 8.44 | 8.28 | 8.44 | 19200.0 |
| 2001-08-28 | IBB | ETF | 30.3 | 30.3 | 29.4667 | 29.6667 | 160500.0 |
| 2001-08-28 | ICF | ETF | 22.3225 | 22.36 | 22.2875 | 22.3225 | 132800.0 |
| 2001-08-28 | IDU | ETF | 37.45 | 37.515 | 37.37 | 37.46 | 4600.0 |
| 2001-08-28 | IEV | ETF | 31.2 | 31.24 | 30.825 | 30.9 | 83800.0 |
| 2001-08-28 | IGLD | ETF | 62.0 | 69.0 | 62.0 | 69.0 | 53.0 |
| 2001-08-28 | IGM | ETF | 8.6083 | 8.6083 | 8.5833 | 8.5833 | 12000.0 |
| 2001-08-28 | IGV | ETF | 8.326 | 8.326 | 8.326 | 8.326 | 489500.0 |
| 2001-08-28 | IJH | ETF | 10.064 | 10.071 | 9.95 | 9.959 | 445000.0 |
| 2001-08-28 | IJJ | ETF | 22.5775 | 22.5775 | 22.4 | 22.435 | 54000.0 |
| 2001-08-28 | IJK | ETF | 13.8688 | 13.8938 | 13.6962 | 13.7125 | 42400.0 |
| 2001-08-28 | IJR | ETF | 18.7917 | 18.8133 | 18.6167 | 18.6417 | 1005000.0 |
| 2001-08-28 | IJS | ETF | 21.1625 | 21.1975 | 21.025 | 21.045 | 79200.0 |
| 2001-08-28 | IJT | ETF | 18.72 | 18.7975 | 18.575 | 18.6025 | 18800.0 |
> showing 50 of 105 rows — these rows as CSV