PREVIEW / etf_daily / 2001-03-19
file: by_date/etf_daily/2001/2001-03-19.parquet size: 8 KB rows: 95
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-03-19 | SPY | ETF | 115.76 | 117.69 | 114.82 | 117.35 | 10067800.0 |
| 2001-03-19 | QQQ | ETF | 41.44 | 43.26 | 40.75 | 43.26 | 53248200.0 |
| 2001-03-19 | IWM | ETF | 44.5 | 45.2 | 43.755 | 45.15 | 784600.0 |
| 2001-03-19 | DIA | ETF | 98.91 | 100.0 | 97.91 | 99.75 | 4135000.0 |
| 2001-03-19 | BBH | ETF | 39.5 | 41.33 | 39.0167 | 41.33 | 2502900.0 |
| 2001-03-19 | BITS | ETF | 8.125 | 8.125 | 7.5 | 8.125 | 9275.0 |
| 2001-03-19 | CEF | ETF | 3.14 | 3.14 | 3.1 | 3.11 | 26200.0 |
| 2001-03-19 | CHB | ETF | 5.0 | 5.35 | 5.0 | 5.35 | 47700.0 |
| 2001-03-19 | CNXT | ETF | 9.88 | 10.75 | 9.31 | 10.56 | 3784650.0 |
| 2001-03-19 | CSB | ETF | 1.51999998092651 | 1.51999998092651 | 1.51999998092651 | 1.51999998092651 | 29900.0 |
| 2001-03-19 | DGT | ETF | 67.68 | 67.68 | 67.29 | 67.29 | 700.0 |
| 2001-03-19 | EWA | ETF | 8.65 | 8.75 | 8.65 | 8.75 | 3000.0 |
| 2001-03-19 | EWC | ETF | 11.0 | 11.4 | 11.0 | 11.4 | 7200.0 |
| 2001-03-19 | EWD | ETF | 14.0 | 14.1 | 13.8 | 14.1 | 9200.0 |
| 2001-03-19 | EWG | ETF | 16.5 | 16.55 | 16.4 | 16.55 | 69900.0 |
| 2001-03-19 | EWH | ETF | 11.1 | 11.25 | 11.01 | 11.25 | 55500.0 |
| 2001-03-19 | EWI | ETF | 37.44 | 38.0 | 37.44 | 38.0 | 1150.0 |
| 2001-03-19 | EWJ | ETF | 39.0 | 39.0 | 38.48 | 38.88 | 173875.0 |
| 2001-03-19 | EWK | ETF | 11.06 | 11.25 | 11.06 | 11.2 | 1200.0 |
| 2001-03-19 | EWL | ETF | 13.85 | 14.1 | 13.85 | 14.1 | 5200.0 |
| 2001-03-19 | EWM | ETF | 19.68 | 19.8 | 19.52 | 19.6 | 9075.0 |
| 2001-03-19 | EWN | ETF | 19.55 | 19.75 | 19.4 | 19.75 | 1100.0 |
| 2001-03-19 | EWO | ETF | 7.95 | 7.95 | 7.83 | 7.83 | 3300.0 |
| 2001-03-19 | EWP | ETF | 23.15 | 23.4 | 23.12 | 23.2 | 5300.0 |
| 2001-03-19 | EWQ | ETF | 20.12 | 20.39 | 20.1 | 20.39 | 51000.0 |
| 2001-03-19 | EWS | ETF | 11.3 | 11.3 | 11.02 | 11.22 | 11200.0 |
| 2001-03-19 | EWT | ETF | 23.1 | 23.5 | 23.08 | 23.1 | 74300.0 |
| 2001-03-19 | EWU | ETF | 30.9 | 31.02 | 30.62 | 31.02 | 35250.0 |
| 2001-03-19 | EWW | ETF | 13.85 | 14.4 | 13.85 | 14.4 | 12200.0 |
| 2001-03-19 | EWY | ETF | 12.61 | 12.7 | 12.4 | 12.7 | 46900.0 |
| 2001-03-19 | EZU | ETF | 30.25 | 30.8281 | 30.25 | 30.8281 | 70400.0 |
| 2001-03-19 | FCTR | ETF | 14.1875 | 14.375 | 14.0 | 14.3125 | 24800.0 |
| 2001-03-19 | GLDB | ETF | 7.25 | 7.25 | 6.8125 | 7.0 | 50400.0 |
| 2001-03-19 | GSIG | ETF | 8.62 | 9.0 | 8.27 | 9.0 | 65100.0 |
| 2001-03-19 | IBB | ETF | 25.599 | 26.4167 | 25.3646 | 26.4167 | 27300.0 |
| 2001-03-19 | ICF | ETF | 19.5273 | 19.5273 | 19.5273 | 19.5273 | 1200.0 |
| 2001-03-19 | IDU | ETF | 39.4 | 39.49 | 39.05 | 39.25 | 62400.0 |
| 2001-03-19 | IEV | ETF | 31.59 | 31.675 | 31.31 | 31.65 | 34800.0 |
| 2001-03-19 | IGLD | ETF | 143.75 | 146.875 | 143.75 | 143.75 | 66.0 |
| 2001-03-19 | IGM | ETF | 8.8917 | 8.8917 | 8.8917 | 8.8917 | 600.0 |
| 2001-03-19 | IJH | ETF | 9.197 | 9.415 | 9.13 | 9.415 | 399000.0 |
| 2001-03-19 | IJJ | ETF | 20.53 | 20.815 | 20.375 | 20.815 | 61600.0 |
| 2001-03-19 | IJK | ETF | 12.775 | 13.1288 | 12.6375 | 13.1288 | 100000.0 |
| 2001-03-19 | IJR | ETF | 16.7167 | 17.025 | 16.5767 | 17.025 | 677400.0 |
| 2001-03-19 | IJS | ETF | 18.7875 | 19.2 | 18.66 | 19.2 | 481600.0 |
| 2001-03-19 | IJT | ETF | 16.575 | 16.9375 | 16.575 | 16.9075 | 26800.0 |
| 2001-03-19 | IOO | ETF | 30.4766 | 30.875 | 30.25 | 30.875 | 6400.0 |
| 2001-03-19 | IUSG | ETF | 20.44 | 20.95 | 20.44 | 20.95 | 2800.0 |
| 2001-03-19 | IUSV | ETF | 23.5833 | 23.8433 | 23.5167 | 23.8433 | 128100.0 |
| 2001-03-19 | IVE | ETF | 59.12 | 60.26 | 58.99 | 60.12 | 112900.0 |
> showing 50 of 95 rows — these rows as CSV