PREVIEW / etf_daily / 2000-08-31
file: by_date/etf_daily/2000/2000-08-31.parquet size: 8 KB rows: 82
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-31 | SPY | ETF | 151.0625 | 153.0938 | 150.9062 | 152.3438 | 4863100.0 |
| 2000-08-31 | QQQ | ETF | 99.625 | 102.0 | 99.5625 | 101.625 | 15588700.0 |
| 2000-08-31 | IWM | ETF | 53.4062 | 54.1562 | 53.4062 | 53.75 | 151200.0 |
| 2000-08-31 | DIA | ETF | 111.5 | 113.2344 | 111.4375 | 112.4688 | 889600.0 |
| 2000-08-31 | BBH | ETF | 65.7083 | 68.1458 | 65.625 | 67.3125 | 2471100.0 |
| 2000-08-31 | BITS | ETF | 15.25 | 16.75 | 14.75 | 16.75 | 15625.0 |
| 2000-08-31 | CEF | ETF | 3.3125 | 3.375 | 3.3125 | 3.375 | 26400.0 |
| 2000-08-31 | CHB | ETF | 5.94 | 6.25 | 5.94 | 6.25 | 80200.0 |
| 2000-08-31 | CNXT | ETF | 36.0 | 37.67 | 35.94 | 37.19 | 3500380.0 |
| 2000-08-31 | EWA | ETF | 10.0 | 10.0625 | 9.875 | 9.9375 | 33300.0 |
| 2000-08-31 | EWC | ETF | 16.9375 | 17.125 | 16.8125 | 17.0 | 39600.0 |
| 2000-08-31 | EWD | ETF | 24.5 | 24.625 | 24.375 | 24.625 | 2500.0 |
| 2000-08-31 | EWG | ETF | 20.625 | 20.6875 | 20.3125 | 20.5625 | 49200.0 |
| 2000-08-31 | EWH | ETF | 13.375 | 13.5 | 13.3125 | 13.5 | 37500.0 |
| 2000-08-31 | EWI | ETF | 44.875 | 45.0 | 44.75 | 44.75 | 15800.0 |
| 2000-08-31 | EWJ | ETF | 55.75 | 56.0 | 55.5 | 55.75 | 55050.0 |
| 2000-08-31 | EWK | ETF | 13.5 | 13.5 | 13.25 | 13.25 | 2100.0 |
| 2000-08-31 | EWL | ETF | 15.8125 | 15.8125 | 15.75 | 15.8125 | 2400.0 |
| 2000-08-31 | EWM | ETF | 23.75 | 24.0 | 23.75 | 23.75 | 6850.0 |
| 2000-08-31 | EWN | ETF | 23.9375 | 23.9375 | 23.4375 | 23.625 | 7500.0 |
| 2000-08-31 | EWO | ETF | 7.875 | 7.875 | 7.6875 | 7.75 | 3500.0 |
| 2000-08-31 | EWP | ETF | 24.1875 | 24.5 | 24.1875 | 24.3125 | 4200.0 |
| 2000-08-31 | EWQ | ETF | 26.6875 | 26.6875 | 26.25 | 26.5 | 28900.0 |
| 2000-08-31 | EWS | ETF | 15.375 | 15.5 | 15.125 | 15.375 | 61450.0 |
| 2000-08-31 | EWT | ETF | 33.75 | 33.75 | 33.75 | 33.75 | 2450.0 |
| 2000-08-31 | EWU | ETF | 37.0 | 37.25 | 36.75 | 36.875 | 23300.0 |
| 2000-08-31 | EWW | ETF | 16.875 | 17.0 | 16.75 | 16.75 | 44500.0 |
| 2000-08-31 | EWY | ETF | 18.6875 | 18.75 | 18.625 | 18.75 | 1300.0 |
| 2000-08-31 | EWZ | ETF | 19.8125 | 19.875 | 19.75 | 19.75 | 2600.0 |
| 2000-08-31 | EZU | ETF | 37.9375 | 38.125 | 37.9375 | 38.125 | 600.0 |
| 2000-08-31 | FCTR | ETF | 16.0 | 16.1719 | 15.875 | 16.0625 | 84600.0 |
| 2000-08-31 | FMAR | ETF | 5.06 | 5.06 | 5.06 | 5.06 | 400.0 |
| 2000-08-31 | GLDB | ETF | 5.375 | 5.5 | 5.3125 | 5.3594 | 40000.0 |
| 2000-08-31 | GSIG | ETF | 26.37 | 27.44 | 26.0 | 26.19 | 344400.0 |
| 2000-08-31 | IDU | ETF | 39.6562 | 39.875 | 39.6562 | 39.8438 | 42400.0 |
| 2000-08-31 | IEV | ETF | 39.3438 | 39.5469 | 39.3438 | 39.5312 | 21400.0 |
| 2000-08-31 | IGLD | ETF | 575.0 | 587.5 | 537.5 | 543.75 | 1546.0 |
| 2000-08-31 | IJH | ETF | 10.8 | 10.9094 | 10.7984 | 10.8891 | 2764000.0 |
| 2000-08-31 | IJJ | ETF | 19.5 | 19.543 | 19.5 | 19.543 | 15600.0 |
| 2000-08-31 | IJK | ETF | 18.4688 | 18.7227 | 18.4609 | 18.7227 | 20000.0 |
| 2000-08-31 | IJR | ETF | 18.5417 | 18.6901 | 18.5417 | 18.6458 | 220200.0 |
| 2000-08-31 | IJS | ETF | 18.1289 | 18.1289 | 18.1289 | 18.1289 | 2400.0 |
| 2000-08-31 | IJT | ETF | 22.1094 | 22.3906 | 22.1094 | 22.25 | 9600.0 |
| 2000-08-31 | IVE | ETF | 63.0625 | 63.5938 | 63.0625 | 63.1094 | 126300.0 |
| 2000-08-31 | IVV | ETF | 151.0 | 153.0469 | 150.875 | 152.2656 | 843400.0 |
| 2000-08-31 | IVW | ETF | 22.7773 | 23.0547 | 22.7773 | 22.9141 | 62000.0 |
| 2000-08-31 | IWB | ETF | 81.4531 | 81.7812 | 81.4531 | 81.5 | 1300.0 |
| 2000-08-31 | IWD | ETF | 58.125 | 58.125 | 58.0 | 58.0 | 3500.0 |
| 2000-08-31 | IWF | ETF | 22.515625 | 22.75 | 22.515625 | 22.75 | 24800.0 |
| 2000-08-31 | IWN | ETF | 36.2083 | 36.2083 | 36.2083 | 36.2083 | 12300.0 |
> showing 50 of 82 rows — these rows as CSV