PREVIEW / etf_daily / 2000-06-19
file: by_date/etf_daily/2000/2000-06-19.parquet size: 7 KB rows: 66
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 |
|---|---|---|---|---|---|---|---|
| 2000-06-19 | SPY | ETF | 146.4688 | 149.1562 | 146.25 | 148.4688 | 5106900.0 |
| 2000-06-19 | QQQ | ETF | 94.0156 | 98.25 | 93.0 | 98.0 | 20042500.0 |
| 2000-06-19 | IWM | ETF | 51.25 | 52.25 | 51.0156 | 52.25 | 59200.0 |
| 2000-06-19 | DIA | ETF | 104.7656 | 106.0625 | 104.3281 | 105.5938 | 930300.0 |
| 2000-06-19 | BBH | ETF | 54.5 | 57.8333 | 53.375 | 57.8333 | 1815600.0 |
| 2000-06-19 | BITS | ETF | 29.25 | 29.5 | 28.0 | 28.25 | 10375.0 |
| 2000-06-19 | CEF | ETF | 3.4375 | 3.4375 | 3.4375 | 3.4375 | 34900.0 |
| 2000-06-19 | CHB | ETF | 5.63 | 5.63 | 5.31 | 5.31 | 91000.0 |
| 2000-06-19 | CNXT | ETF | 53.5 | 56.0 | 51.38 | 55.06 | 8659560.0 |
| 2000-06-19 | EWA | ETF | 10.4375 | 10.4375 | 10.1875 | 10.25 | 4000.0 |
| 2000-06-19 | EWC | ETF | 19.875 | 19.875 | 19.6875 | 19.75 | 4600.0 |
| 2000-06-19 | EWD | ETF | 31.125 | 31.125 | 30.8125 | 31.0625 | 3100.0 |
| 2000-06-19 | EWG | ETF | 25.5 | 25.625 | 25.25 | 25.5625 | 102800.0 |
| 2000-06-19 | EWH | ETF | 12.5 | 12.8125 | 12.5 | 12.8125 | 21500.0 |
| 2000-06-19 | EWI | ETF | 51.375 | 51.875 | 51.375 | 51.625 | 4150.0 |
| 2000-06-19 | EWJ | ETF | 58.5 | 59.0 | 58.25 | 59.0 | 119200.0 |
| 2000-06-19 | EWK | ETF | 13.25 | 13.625 | 13.25 | 13.375 | 2200.0 |
| 2000-06-19 | EWL | ETF | 16.0625 | 16.3125 | 16.0 | 16.3125 | 49700.0 |
| 2000-06-19 | EWM | ETF | 25.0 | 25.0 | 24.75 | 24.75 | 14300.0 |
| 2000-06-19 | EWN | ETF | 25.1875 | 25.1875 | 24.9375 | 24.9375 | 3200.0 |
| 2000-06-19 | EWO | ETF | 8.25 | 8.25 | 8.0625 | 8.0625 | 21500.0 |
| 2000-06-19 | EWP | ETF | 26.5 | 26.5 | 26.25 | 26.4375 | 2100.0 |
| 2000-06-19 | EWQ | ETF | 29.25 | 29.3125 | 29.0625 | 29.25 | 62300.0 |
| 2000-06-19 | EWS | ETF | 14.625 | 14.625 | 14.25 | 14.5 | 43450.0 |
| 2000-06-19 | EWU | ETF | 39.375 | 39.375 | 38.625 | 39.0 | 24150.0 |
| 2000-06-19 | EWW | ETF | 15.9375 | 15.9375 | 15.375 | 15.75 | 13900.0 |
| 2000-06-19 | EWY | ETF | 19.75 | 19.75 | 19.5 | 19.6875 | 3000.0 |
| 2000-06-19 | FCTR | ETF | 16.8438 | 16.9375 | 16.5625 | 16.75 | 26500.0 |
| 2000-06-19 | FMAR | ETF | 6.0 | 6.12 | 5.69 | 5.69 | 4600.0 |
| 2000-06-19 | GLDB | ETF | 6.7188 | 6.8125 | 6.6875 | 6.7813 | 124300.0 |
| 2000-06-19 | GSIG | ETF | 27.97 | 28.44 | 27.62 | 28.19 | 425600.0 |
| 2000-06-19 | IGLD | ETF | 881.25 | 900.0 | 843.75 | 887.5 | 278.0 |
| 2000-06-19 | IJH | ETF | 9.9156 | 10.0969 | 9.9 | 10.0781 | 62000.0 |
| 2000-06-19 | IJR | ETF | 17.5573 | 17.5573 | 17.5104 | 17.5104 | 27000.0 |
| 2000-06-19 | IVE | ETF | 60.25 | 60.5938 | 60.125 | 60.5 | 12300.0 |
| 2000-06-19 | IVV | ETF | 146.5625 | 149.0312 | 146.5 | 148.5156 | 160000.0 |
| 2000-06-19 | IVW | ETF | 22.375 | 22.5547 | 22.375 | 22.5547 | 2800.0 |
| 2000-06-19 | IWB | ETF | 78.7188 | 78.7188 | 77.9219 | 77.9219 | 500.0 |
| 2000-06-19 | IWD | ETF | 56.2812 | 56.7656 | 56.2812 | 56.6094 | 13900.0 |
| 2000-06-19 | IWF | ETF | 21.53905 | 22.0 | 21.53905 | 22.0 | 38000.0 |
| 2000-06-19 | IWV | ETF | 79.9688 | 80.8438 | 79.9688 | 80.8438 | 1000.0 |
| 2000-06-19 | IYE | ETF | 17.1771 | 17.1771 | 16.875 | 16.875 | 7200.0 |
| 2000-06-19 | IYF | ETF | 35.8125 | 36.5859 | 35.8125 | 36.4375 | 2200.0 |
| 2000-06-19 | IYH | ETF | 12.5531 | 12.8125 | 12.5531 | 12.8125 | 9000.0 |
| 2000-06-19 | IYK | ETF | 13.7083 | 13.7083 | 13.7083 | 13.7083 | 300.0 |
| 2000-06-19 | IYR | ETF | 35.03 | 35.03 | 35.03 | 35.03 | 200.0 |
| 2000-06-19 | IYW | ETF | 31.75 | 32.9609 | 31.7422 | 32.8438 | 10000.0 |
| 2000-06-19 | IYY | ETF | 33.9375 | 34.6875 | 33.8438 | 34.5625 | 20400.0 |
| 2000-06-19 | IYZ | ETF | 62.625 | 63.875 | 62.5312 | 63.75 | 2800.0 |
| 2000-06-19 | KTEC | ETF | 8.75 | 8.75 | 8.6875 | 8.6875 | 28200.0 |
> showing 50 of 66 rows — these rows as CSV