PREVIEW / etf_daily / 2000-08-22
file: by_date/etf_daily/2000/2000-08-22.parquet size: 8 KB rows: 80
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-08-22 | SPY | ETF | 150.5625 | 151.3125 | 150.0938 | 150.25 | 3075300.0 |
| 2000-08-22 | QQQ | ETF | 96.0 | 97.3594 | 95.2656 | 95.5 | 14878200.0 |
| 2000-08-22 | IWM | ETF | 51.7656 | 52.0938 | 51.6562 | 51.6562 | 195600.0 |
| 2000-08-22 | DIA | ETF | 111.0781 | 112.0 | 111.0 | 111.5469 | 1054000.0 |
| 2000-08-22 | BBH | ETF | 59.8125 | 61.2708 | 59.4583 | 60.5208 | 3084600.0 |
| 2000-08-22 | BITS | ETF | 12.125 | 13.625 | 12.125 | 12.75 | 8175.0 |
| 2000-08-22 | CEF | ETF | 3.25 | 3.3125 | 3.25 | 3.3125 | 18200.0 |
| 2000-08-22 | CHB | ETF | 5.69 | 5.69 | 5.5 | 5.69 | 58000.0 |
| 2000-08-22 | CNXT | ETF | 38.31 | 38.44 | 37.0 | 37.19 | 3503800.0 |
| 2000-08-22 | EWA | ETF | 10.625 | 10.6875 | 10.5625 | 10.5625 | 26900.0 |
| 2000-08-22 | EWC | ETF | 21.625 | 21.75 | 21.4375 | 21.75 | 20600.0 |
| 2000-08-22 | EWD | ETF | 29.4375 | 29.4375 | 29.25 | 29.25 | 500.0 |
| 2000-08-22 | EWG | ETF | 23.3125 | 23.4375 | 23.125 | 23.1875 | 25300.0 |
| 2000-08-22 | EWH | ETF | 13.8125 | 14.0 | 13.8125 | 13.9375 | 63000.0 |
| 2000-08-22 | EWI | ETF | 49.5 | 49.5 | 49.125 | 49.5 | 1450.0 |
| 2000-08-22 | EWJ | ETF | 55.5 | 55.75 | 55.25 | 55.25 | 61850.0 |
| 2000-08-22 | EWK | ETF | 14.0625 | 14.0625 | 13.75 | 13.875 | 8700.0 |
| 2000-08-22 | EWL | ETF | 16.0625 | 16.125 | 15.875 | 16.0625 | 9400.0 |
| 2000-08-22 | EWM | ETF | 24.25 | 24.5 | 24.0 | 24.25 | 9175.0 |
| 2000-08-22 | EWN | ETF | 24.5 | 24.625 | 24.3125 | 24.5 | 16700.0 |
| 2000-08-22 | EWO | ETF | 8.0 | 8.0625 | 8.0 | 8.0625 | 3700.0 |
| 2000-08-22 | EWP | ETF | 26.125 | 26.125 | 25.75 | 26.0 | 2400.0 |
| 2000-08-22 | EWQ | ETF | 27.5625 | 27.625 | 27.3125 | 27.5625 | 33300.0 |
| 2000-08-22 | EWS | ETF | 16.125 | 16.375 | 16.125 | 16.25 | 33150.0 |
| 2000-08-22 | EWT | ETF | 37.5 | 37.5 | 37.5 | 37.5 | 16400.0 |
| 2000-08-22 | EWU | ETF | 39.625 | 39.75 | 39.25 | 39.25 | 34150.0 |
| 2000-08-22 | EWW | ETF | 16.5625 | 16.5625 | 16.1875 | 16.375 | 11600.0 |
| 2000-08-22 | EWY | ETF | 19.5 | 19.6875 | 19.5 | 19.5 | 1400.0 |
| 2000-08-22 | EZU | ETF | 38.1875 | 38.1875 | 38.1875 | 38.1875 | 16400.0 |
| 2000-08-22 | FCTR | ETF | 14.125 | 15.25 | 14.0 | 15.25 | 38000.0 |
| 2000-08-22 | FMAR | ETF | 5.25 | 5.25 | 5.0 | 5.0 | 2200.0 |
| 2000-08-22 | GLDB | ETF | 5.4375 | 5.5 | 5.25 | 5.4375 | 135900.0 |
| 2000-08-22 | GSIG | ETF | 26.31 | 26.62 | 25.0 | 25.81 | 422800.0 |
| 2000-08-22 | IDU | ETF | 39.0938 | 39.1094 | 39.0938 | 39.1094 | 1400.0 |
| 2000-08-22 | IEV | ETF | 39.25 | 39.2812 | 39.2344 | 39.2656 | 21800.0 |
| 2000-08-22 | IGLD | ETF | 612.5 | 675.0 | 581.25 | 643.75 | 814.0 |
| 2000-08-22 | IJH | ETF | 10.5203 | 10.5375 | 10.4922 | 10.5031 | 571000.0 |
| 2000-08-22 | IJJ | ETF | 19.1797 | 19.1797 | 19.1797 | 19.1797 | 5200.0 |
| 2000-08-22 | IJK | ETF | 17.6992 | 17.75 | 17.6797 | 17.6797 | 19200.0 |
| 2000-08-22 | IJR | ETF | 17.9479 | 17.9922 | 17.9193 | 17.9193 | 39000.0 |
| 2000-08-22 | IJS | ETF | 17.7227 | 17.7656 | 17.7227 | 17.7344 | 43600.0 |
| 2000-08-22 | IJT | ETF | 21.1484 | 21.1484 | 21.1484 | 21.1484 | 1200.0 |
| 2000-08-22 | IUSG | ETF | 34.7188 | 34.7188 | 34.7188 | 34.7188 | 4000.0 |
| 2000-08-22 | IVE | ETF | 62.8906 | 63.0625 | 62.8906 | 63.0 | 3900.0 |
| 2000-08-22 | IVV | ETF | 150.4062 | 151.0938 | 150.125 | 150.4375 | 380100.0 |
| 2000-08-22 | IVW | ETF | 22.5898 | 22.6445 | 22.5117 | 22.5117 | 7200.0 |
| 2000-08-22 | IWB | ETF | 79.8438 | 80.0938 | 79.6875 | 79.6875 | 56800.0 |
| 2000-08-22 | IWD | ETF | 57.625 | 57.875 | 57.625 | 57.7188 | 10100.0 |
| 2000-08-22 | IWF | ETF | 21.9922 | 22.16405 | 21.9375 | 21.9375 | 24000.0 |
| 2000-08-22 | IWN | ETF | 35.8125 | 35.8125 | 35.8125 | 35.8125 | 600.0 |
> showing 50 of 80 rows — these rows as CSV