PREVIEW / etf_daily / 2000-08-28
file: by_date/etf_daily/2000/2000-08-28.parquet size: 8 KB rows: 79
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-28 | SPY | ETF | 151.25 | 152.9062 | 151.25 | 151.7656 | 5518700.0 |
| 2000-08-28 | QQQ | ETF | 98.25 | 99.8438 | 97.9375 | 98.5 | 12314200.0 |
| 2000-08-28 | IWM | ETF | 52.8125 | 53.125 | 52.5625 | 52.6562 | 156000.0 |
| 2000-08-28 | DIA | ETF | 112.2344 | 113.3281 | 112.0781 | 112.6875 | 531700.0 |
| 2000-08-28 | BBH | ETF | 65.625 | 65.625 | 64.125 | 64.6667 | 980100.0 |
| 2000-08-28 | BITS | ETF | 12.0 | 15.75 | 12.0 | 15.0 | 30750.0 |
| 2000-08-28 | BOSS | ETF | 20.35 | 20.35 | 20.35 | 20.35 | 100.0 |
| 2000-08-28 | CEF | ETF | 3.375 | 3.375 | 3.3125 | 3.3125 | 69600.0 |
| 2000-08-28 | CHB | ETF | 5.94 | 5.94 | 5.5 | 5.88 | 91800.0 |
| 2000-08-28 | CNXT | ETF | 37.75 | 38.75 | 37.06 | 38.38 | 3234800.0 |
| 2000-08-28 | EWA | ETF | 10.25 | 10.25 | 10.25 | 10.25 | 200.0 |
| 2000-08-28 | EWC | ETF | 16.8125 | 16.9375 | 16.6875 | 16.75 | 29000.0 |
| 2000-08-28 | EWD | ETF | 23.9375 | 24.3125 | 23.9375 | 24.3125 | 4400.0 |
| 2000-08-28 | EWG | ETF | 20.9375 | 21.125 | 20.9375 | 21.0625 | 27700.0 |
| 2000-08-28 | EWH | ETF | 13.3125 | 13.5 | 13.1875 | 13.375 | 77900.0 |
| 2000-08-28 | EWI | ETF | 45.125 | 45.375 | 45.125 | 45.375 | 23050.0 |
| 2000-08-28 | EWJ | ETF | 56.5 | 56.75 | 56.25 | 56.75 | 55075.0 |
| 2000-08-28 | EWK | ETF | 13.5 | 13.8125 | 13.5 | 13.625 | 7400.0 |
| 2000-08-28 | EWL | ETF | 16.25 | 16.25 | 16.1875 | 16.1875 | 7600.0 |
| 2000-08-28 | EWM | ETF | 23.75 | 24.0 | 23.75 | 23.75 | 2175.0 |
| 2000-08-28 | EWN | ETF | 24.25 | 24.3125 | 24.0 | 24.125 | 6800.0 |
| 2000-08-28 | EWP | ETF | 24.625 | 24.9375 | 24.625 | 24.75 | 2600.0 |
| 2000-08-28 | EWQ | ETF | 26.6875 | 26.75 | 26.5625 | 26.75 | 6400.0 |
| 2000-08-28 | EWS | ETF | 15.5 | 15.625 | 15.25 | 15.375 | 51950.0 |
| 2000-08-28 | EWT | ETF | 33.25 | 34.25 | 33.25 | 33.75 | 15400.0 |
| 2000-08-28 | EWU | ETF | 37.5 | 37.5 | 37.0 | 37.25 | 25450.0 |
| 2000-08-28 | EWW | ETF | 15.75 | 16.0 | 15.625 | 15.6875 | 25300.0 |
| 2000-08-28 | EWY | ETF | 19.0 | 19.75 | 19.0 | 19.6875 | 12900.0 |
| 2000-08-28 | EWZ | ETF | 19.75 | 19.75 | 19.6875 | 19.6875 | 500.0 |
| 2000-08-28 | EZU | ETF | 38.625 | 38.625 | 38.5625 | 38.5938 | 6600.0 |
| 2000-08-28 | FCTR | ETF | 16.375 | 16.375 | 15.875 | 16.125 | 293900.0 |
| 2000-08-28 | FMAR | ETF | 5.0928 | 5.0928 | 4.9365 | 4.9365 | 1100.0 |
| 2000-08-28 | GLDB | ETF | 5.375 | 5.5 | 5.25 | 5.25 | 269800.0 |
| 2000-08-28 | GSIG | ETF | 26.31 | 26.81 | 26.0 | 26.44 | 274200.0 |
| 2000-08-28 | IDU | ETF | 38.7812 | 39.2812 | 38.7812 | 39.2656 | 6800.0 |
| 2000-08-28 | IEV | ETF | 39.25 | 39.75 | 39.25 | 39.75 | 25800.0 |
| 2000-08-28 | IGLD | ETF | 625.0 | 625.0 | 581.25 | 600.0 | 511.0 |
| 2000-08-28 | IJH | ETF | 10.6656 | 10.7375 | 10.6656 | 10.7078 | 1958000.0 |
| 2000-08-28 | IJJ | ETF | 19.293 | 19.3281 | 19.293 | 19.3281 | 1600.0 |
| 2000-08-28 | IJK | ETF | 18.2559 | 18.2812 | 18.1973 | 18.1973 | 16000.0 |
| 2000-08-28 | IJR | ETF | 18.3412 | 18.3412 | 18.2136 | 18.2214 | 16800.0 |
| 2000-08-28 | IJT | ETF | 21.6797 | 21.8086 | 21.586 | 21.586 | 21200.0 |
| 2000-08-28 | IUSG | ETF | 35.5156 | 35.5156 | 35.5156 | 35.5156 | 2000.0 |
| 2000-08-28 | IUSV | ETF | 24.4688 | 24.4688 | 24.4688 | 24.4688 | 2700.0 |
| 2000-08-28 | IVE | ETF | 62.6562 | 63.3281 | 62.6562 | 63.1094 | 22100.0 |
| 2000-08-28 | IVV | ETF | 151.0938 | 152.7344 | 151.0938 | 151.7812 | 354000.0 |
| 2000-08-28 | IVW | ETF | 22.8555 | 23.0586 | 22.8555 | 22.9844 | 11600.0 |
| 2000-08-28 | IWB | ETF | 81.2188 | 81.2812 | 80.875 | 80.875 | 26500.0 |
| 2000-08-28 | IWD | ETF | 57.5 | 57.9062 | 57.4688 | 57.6562 | 53700.0 |
| 2000-08-28 | IWF | ETF | 22.40625 | 22.609375 | 22.375 | 22.5703 | 22800.0 |
> showing 50 of 79 rows — these rows as CSV