PREVIEW / etf_daily / 2000-09-22
file: by_date/etf_daily/2000/2000-09-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-09-22 | SPY | ETF | 142.625 | 145.3125 | 142.4219 | 145.2812 | 7791300.0 |
| 2000-09-22 | QQQ | ETF | 87.625 | 93.25 | 87.5 | 92.9375 | 33713300.0 |
| 2000-09-22 | IWM | ETF | 50.0 | 51.5938 | 50.0 | 51.5938 | 127600.0 |
| 2000-09-22 | DIA | ETF | 106.1875 | 108.875 | 106.0 | 108.75 | 1539300.0 |
| 2000-09-22 | BBH | ETF | 61.5 | 65.9167 | 61.5 | 65.6667 | 2269800.0 |
| 2000-09-22 | BITS | ETF | 15.0 | 15.5 | 14.0 | 14.5 | 5725.0 |
| 2000-09-22 | CEF | ETF | 3.375 | 3.375 | 3.375 | 3.375 | 70500.0 |
| 2000-09-22 | CHB | ETF | 4.44 | 4.75 | 4.13 | 4.75 | 1024500.0 |
| 2000-09-22 | CNXT | ETF | 44.19 | 45.75 | 43.44 | 44.44 | 7768940.0 |
| 2000-09-22 | CSB | ETF | 1.39999997615814 | 1.39999997615814 | 1.39999997615814 | 1.39999997615814 | 200.0 |
| 2000-09-22 | EWA | ETF | 9.4375 | 9.4375 | 9.25 | 9.3125 | 10900.0 |
| 2000-09-22 | EWC | ETF | 16.1875 | 16.1875 | 16.0 | 16.125 | 29700.0 |
| 2000-09-22 | EWD | ETF | 22.25 | 22.4375 | 22.1875 | 22.4375 | 6000.0 |
| 2000-09-22 | EWG | ETF | 18.6875 | 19.0625 | 18.6875 | 18.9375 | 86900.0 |
| 2000-09-22 | EWH | ETF | 11.0 | 11.5625 | 10.9375 | 11.375 | 56400.0 |
| 2000-09-22 | EWI | ETF | 41.875 | 42.5 | 41.875 | 42.125 | 13200.0 |
| 2000-09-22 | EWJ | ETF | 52.75 | 53.25 | 52.5 | 53.25 | 45625.0 |
| 2000-09-22 | EWK | ETF | 12.625 | 12.625 | 12.3125 | 12.3125 | 15100.0 |
| 2000-09-22 | EWL | ETF | 15.0 | 15.25 | 15.0 | 15.0 | 38600.0 |
| 2000-09-22 | EWM | ETF | 21.75 | 22.0 | 21.5 | 21.75 | 7175.0 |
| 2000-09-22 | EWN | ETF | 22.5 | 22.5625 | 22.5 | 22.5 | 3900.0 |
| 2000-09-22 | EWO | ETF | 7.625 | 7.625 | 7.5625 | 7.5625 | 17100.0 |
| 2000-09-22 | EWP | ETF | 23.625 | 24.25 | 23.625 | 24.1875 | 23800.0 |
| 2000-09-22 | EWQ | ETF | 24.5 | 24.75 | 24.375 | 24.75 | 72600.0 |
| 2000-09-22 | EWS | ETF | 13.25 | 13.5 | 13.0 | 13.5 | 33450.0 |
| 2000-09-22 | EWT | ETF | 28.875 | 29.375 | 28.5 | 29.375 | 850.0 |
| 2000-09-22 | EWU | ETF | 34.5 | 35.25 | 34.125 | 35.25 | 43250.0 |
| 2000-09-22 | EWW | ETF | 15.125 | 15.8125 | 15.125 | 15.625 | 23600.0 |
| 2000-09-22 | EWY | ETF | 14.4375 | 14.75 | 14.25 | 14.75 | 37500.0 |
| 2000-09-22 | EWZ | ETF | 18.0625 | 18.0625 | 18.0625 | 18.0625 | 1800.0 |
| 2000-09-22 | EZU | ETF | 35.5625 | 36.0625 | 35.5312 | 35.9375 | 18000.0 |
| 2000-09-22 | FCTR | ETF | 13.875 | 13.875 | 13.375 | 13.625 | 41300.0 |
| 2000-09-22 | FMAR | ETF | 5.0 | 5.12 | 4.9975 | 5.12 | 1400.0 |
| 2000-09-22 | GLDB | ETF | 4.9688 | 5.0625 | 4.875 | 5.0 | 89200.0 |
| 2000-09-22 | GSIG | ETF | 20.19 | 20.19 | 18.62 | 19.37 | 400600.0 |
| 2000-09-22 | IDU | ETF | 40.5781 | 41.2188 | 40.5781 | 41.2188 | 21000.0 |
| 2000-09-22 | IEV | ETF | 38.5 | 38.8125 | 38.5 | 38.8125 | 19400.0 |
| 2000-09-22 | IGLD | ETF | 584.375 | 593.75 | 575.0 | 581.25 | 186.0 |
| 2000-09-22 | IJH | ETF | 10.3953 | 10.5063 | 10.3563 | 10.5 | 1450000.0 |
| 2000-09-22 | IJJ | ETF | 19.1133 | 19.1875 | 19.0938 | 19.1875 | 3600.0 |
| 2000-09-22 | IJK | ETF | 17.4688 | 17.8242 | 17.4688 | 17.8242 | 9600.0 |
| 2000-09-22 | IJR | ETF | 17.6354 | 18.0625 | 17.5625 | 18.0625 | 563400.0 |
| 2000-09-22 | IJS | ETF | 17.4375 | 17.5312 | 17.4375 | 17.5312 | 4800.0 |
| 2000-09-22 | IJT | ETF | 20.5781 | 20.8594 | 20.5781 | 20.8594 | 7600.0 |
| 2000-09-22 | IUSG | ETF | 32.8125 | 32.8125 | 32.8125 | 32.8125 | 400.0 |
| 2000-09-22 | IVE | ETF | 61.0 | 61.75 | 61.0 | 61.75 | 33100.0 |
| 2000-09-22 | IVV | ETF | 142.25 | 145.25 | 142.25 | 145.25 | 124600.0 |
| 2000-09-22 | IVW | ETF | 20.9062 | 21.2773 | 20.9062 | 21.2773 | 35600.0 |
| 2000-09-22 | IWB | ETF | 76.4062 | 77.0469 | 76.4062 | 77.0469 | 900.0 |
| 2000-09-22 | IWD | ETF | 56.375 | 56.8438 | 56.0938 | 56.7812 | 106700.0 |
> showing 50 of 80 rows — these rows as CSV