PREVIEW / etf_daily / 2001-07-19
file: by_date/etf_daily/2001/2001-07-19.parquet size: 9 KB rows: 100
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-19 | SPY | ETF | 122.18 | 122.98 | 120.76 | 122.07 | 10082900.0 |
| 2001-07-19 | QQQ | ETF | 42.46 | 43.35 | 41.75 | 42.64 | 76590200.0 |
| 2001-07-19 | IWM | ETF | 48.6 | 49.085 | 48.25 | 48.5 | 431000.0 |
| 2001-07-19 | DIA | ETF | 106.78 | 107.0 | 105.4 | 106.4 | 1638000.0 |
| 2001-07-19 | BBH | ETF | 39.3833 | 39.75 | 38.3867 | 38.6667 | 4500000.0 |
| 2001-07-19 | BITS | ETF | 14.08 | 16.0 | 14.08 | 14.6 | 11250.0 |
| 2001-07-19 | CEF | ETF | 3.1 | 3.1 | 3.05 | 3.09 | 13200.0 |
| 2001-07-19 | CHB | ETF | 10.97 | 11.24 | 10.9 | 11.13 | 180600.0 |
| 2001-07-19 | CNXT | ETF | 8.29 | 8.92 | 8.27 | 8.59 | 2908100.0 |
| 2001-07-19 | CSB | ETF | 2.51999998092651 | 2.51999998092651 | 2.51999998092651 | 2.51999998092651 | 1800.0 |
| 2001-07-19 | DGT | ETF | 69.49 | 69.49 | 69.49 | 69.49 | 400.0 |
| 2001-07-19 | EWA | ETF | 9.65 | 9.66 | 9.65 | 9.66 | 16300.0 |
| 2001-07-19 | EWC | ETF | 11.15 | 11.15 | 11.06 | 11.14 | 11700.0 |
| 2001-07-19 | EWD | ETF | 12.91 | 13.15 | 12.86 | 13.15 | 1900.0 |
| 2001-07-19 | EWG | ETF | 16.14 | 16.28 | 16.13 | 16.27 | 35700.0 |
| 2001-07-19 | EWH | ETF | 9.76 | 9.99 | 9.75 | 9.77 | 22000.0 |
| 2001-07-19 | EWI | ETF | 35.0 | 35.6 | 35.0 | 35.6 | 2900.0 |
| 2001-07-19 | EWJ | ETF | 38.44 | 38.48 | 38.12 | 38.2 | 80500.0 |
| 2001-07-19 | EWK | ETF | 11.74 | 11.74 | 11.74 | 11.74 | 100.0 |
| 2001-07-19 | EWL | ETF | 13.2 | 13.49 | 13.2 | 13.49 | 12100.0 |
| 2001-07-19 | EWM | ETF | 18.76 | 18.8 | 18.6 | 18.8 | 2025.0 |
| 2001-07-19 | EWN | ETF | 18.45 | 18.8 | 18.45 | 18.8 | 3200.0 |
| 2001-07-19 | EWO | ETF | 8.1 | 8.15 | 8.1 | 8.15 | 600.0 |
| 2001-07-19 | EWP | ETF | 20.4 | 20.65 | 20.26 | 20.65 | 5300.0 |
| 2001-07-19 | EWQ | ETF | 19.25 | 19.39 | 19.25 | 19.26 | 22900.0 |
| 2001-07-19 | EWS | ETF | 9.9 | 10.02 | 9.86 | 9.92 | 4400.0 |
| 2001-07-19 | EWT | ETF | 17.1 | 17.26 | 17.0 | 17.14 | 15100.0 |
| 2001-07-19 | EWU | ETF | 30.2 | 30.56 | 30.16 | 30.56 | 51400.0 |
| 2001-07-19 | EWW | ETF | 15.4 | 15.4 | 15.35 | 15.35 | 200.0 |
| 2001-07-19 | EWY | ETF | 13.0 | 13.03 | 12.94 | 12.94 | 7100.0 |
| 2001-07-19 | EWZ | ETF | 12.41 | 12.73 | 12.41 | 12.49 | 2000.0 |
| 2001-07-19 | EZU | ETF | 29.2 | 29.35 | 28.975 | 29.3 | 20200.0 |
| 2001-07-19 | FCTR | ETF | 17.9 | 18.25 | 17.87 | 18.15 | 124300.0 |
| 2001-07-19 | FMAR | ETF | 8.52 | 9.6 | 8.3 | 9.05 | 39900.0 |
| 2001-07-19 | GLDB | ETF | 7.67 | 7.75 | 7.46 | 7.73 | 12800.0 |
| 2001-07-19 | GSIG | ETF | 7.99 | 8.03 | 7.5 | 7.65 | 109200.0 |
| 2001-07-19 | IBB | ETF | 29.4 | 29.6 | 28.7 | 28.8833 | 75000.0 |
| 2001-07-19 | ICF | ETF | 21.225 | 21.225 | 21.175 | 21.1875 | 3600.0 |
| 2001-07-19 | IDU | ETF | 39.03 | 39.15 | 38.92 | 38.92 | 2600.0 |
| 2001-07-19 | IEV | ETF | 30.95 | 30.995 | 30.4 | 30.605 | 60600.0 |
| 2001-07-19 | IGLD | ETF | 70.0 | 72.0 | 70.0 | 71.0 | 84.0 |
| 2001-07-19 | IGM | ETF | 9.175 | 9.2567 | 8.9917 | 9.075 | 99600.0 |
| 2001-07-19 | IGV | ETF | 9.55 | 9.55 | 9.55 | 9.55 | 500.0 |
| 2001-07-19 | IJH | ETF | 10.21 | 10.273 | 10.118 | 10.163 | 83000.0 |
| 2001-07-19 | IJJ | ETF | 22.72 | 22.815 | 22.5 | 22.5725 | 101200.0 |
| 2001-07-19 | IJK | ETF | 14.26 | 14.3738 | 14.2125 | 14.2125 | 148000.0 |
| 2001-07-19 | IJR | ETF | 18.7417 | 18.9017 | 18.6467 | 18.7917 | 982200.0 |
| 2001-07-19 | IJS | ETF | 20.9175 | 21.1225 | 20.9175 | 21.025 | 84400.0 |
| 2001-07-19 | IJT | ETF | 18.9 | 19.0325 | 18.6875 | 18.6875 | 18000.0 |
| 2001-07-19 | IOO | ETF | 30.715 | 30.79 | 30.5 | 30.65 | 102000.0 |
> showing 50 of 100 rows — these rows as CSV