PREVIEW / etf_daily / 2000-09-21
file: by_date/etf_daily/2000/2000-09-21.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-09-21 | SPY | ETF | 144.4688 | 145.5625 | 142.625 | 142.6875 | 5972300.0 |
| 2000-09-21 | QQQ | ETF | 93.75 | 94.4844 | 87.0 | 87.75 | 25032600.0 |
| 2000-09-21 | IWM | ETF | 52.0 | 52.0 | 50.9375 | 50.9375 | 207400.0 |
| 2000-09-21 | DIA | ETF | 106.5625 | 108.0 | 106.25 | 106.25 | 1943500.0 |
| 2000-09-21 | BBH | ETF | 61.1667 | 62.6667 | 61.1667 | 62.0833 | 2316000.0 |
| 2000-09-21 | BITS | ETF | 16.25 | 16.25 | 14.125 | 16.0 | 7900.0 |
| 2000-09-21 | CEF | ETF | 3.375 | 3.375 | 3.25 | 3.375 | 16100.0 |
| 2000-09-21 | CHB | ETF | 4.75 | 4.75 | 4.5 | 4.5 | 75500.0 |
| 2000-09-21 | CNXT | ETF | 48.31 | 48.63 | 46.31 | 47.31 | 4640030.0 |
| 2000-09-21 | EWA | ETF | 9.3125 | 9.4375 | 9.3125 | 9.3125 | 9100.0 |
| 2000-09-21 | EWC | ETF | 16.5 | 16.5 | 16.1875 | 16.25 | 22200.0 |
| 2000-09-21 | EWD | ETF | 22.0 | 22.125 | 21.8125 | 21.875 | 11100.0 |
| 2000-09-21 | EWG | ETF | 18.3125 | 18.375 | 18.125 | 18.375 | 96800.0 |
| 2000-09-21 | EWH | ETF | 11.5 | 11.625 | 11.375 | 11.5 | 100100.0 |
| 2000-09-21 | EWI | ETF | 40.375 | 40.875 | 40.375 | 40.75 | 11700.0 |
| 2000-09-21 | EWJ | ETF | 54.0 | 54.25 | 53.75 | 53.75 | 38600.0 |
| 2000-09-21 | EWK | ETF | 12.25 | 12.25 | 12.125 | 12.125 | 2100.0 |
| 2000-09-21 | EWL | ETF | 14.5 | 14.8125 | 14.5 | 14.75 | 9100.0 |
| 2000-09-21 | EWM | ETF | 22.25 | 22.5 | 22.0 | 22.25 | 7450.0 |
| 2000-09-21 | EWN | ETF | 22.125 | 22.3125 | 22.0 | 22.0625 | 6400.0 |
| 2000-09-21 | EWO | ETF | 7.3125 | 7.5 | 7.3125 | 7.375 | 2500.0 |
| 2000-09-21 | EWP | ETF | 22.875 | 23.1875 | 22.875 | 23.0 | 4600.0 |
| 2000-09-21 | EWQ | ETF | 24.0625 | 24.125 | 23.875 | 24.0 | 31600.0 |
| 2000-09-21 | EWS | ETF | 13.625 | 13.75 | 13.5 | 13.5 | 14100.0 |
| 2000-09-21 | EWU | ETF | 34.25 | 34.375 | 33.625 | 34.0 | 21700.0 |
| 2000-09-21 | EWW | ETF | 16.25 | 16.25 | 16.0 | 16.0 | 2600.0 |
| 2000-09-21 | EWY | ETF | 15.5 | 15.6875 | 15.375 | 15.375 | 6800.0 |
| 2000-09-21 | EWZ | ETF | 18.0 | 18.0 | 18.0 | 18.0 | 10000.0 |
| 2000-09-21 | EZU | ETF | 34.8438 | 35.0938 | 34.8125 | 35.0 | 6200.0 |
| 2000-09-21 | FCTR | ETF | 14.875 | 14.9375 | 13.75 | 14.0 | 290100.0 |
| 2000-09-21 | FMAR | ETF | 5.03 | 5.06 | 4.94 | 5.06 | 18400.0 |
| 2000-09-21 | GLDB | ETF | 5.0625 | 5.0625 | 4.9688 | 5.0 | 46500.0 |
| 2000-09-21 | GSIG | ETF | 21.31 | 21.37 | 20.0 | 20.5 | 680400.0 |
| 2000-09-21 | IDU | ETF | 40.8906 | 40.8906 | 40.0781 | 40.125 | 51600.0 |
| 2000-09-21 | IEV | ETF | 37.8438 | 38.0312 | 37.8438 | 38.0312 | 21200.0 |
| 2000-09-21 | IGLD | ETF | 600.0 | 600.0 | 575.0 | 575.0 | 177.0 |
| 2000-09-21 | IJH | ETF | 10.5484 | 10.5812 | 10.4891 | 10.4891 | 989000.0 |
| 2000-09-21 | IJJ | ETF | 19.336 | 19.336 | 19.168 | 19.168 | 7600.0 |
| 2000-09-21 | IJK | ETF | 17.7793 | 17.7793 | 17.7793 | 17.7793 | 6400.0 |
| 2000-09-21 | IJR | ETF | 18.0417 | 18.0573 | 17.8386 | 17.8386 | 127800.0 |
| 2000-09-21 | IJT | ETF | 21.2812 | 21.2812 | 21.1055 | 21.1055 | 1200.0 |
| 2000-09-21 | IUSG | ETF | 33.75 | 33.7812 | 33.75 | 33.7656 | 1600.0 |
| 2000-09-21 | IVE | ETF | 60.9844 | 61.0781 | 60.6719 | 60.8438 | 8000.0 |
| 2000-09-21 | IVV | ETF | 145.125 | 145.125 | 144.125 | 144.8438 | 284200.0 |
| 2000-09-21 | IVW | ETF | 21.4883 | 21.6836 | 21.4883 | 21.5781 | 20000.0 |
| 2000-09-21 | IWB | ETF | 77.5312 | 77.5312 | 77.3125 | 77.3125 | 14400.0 |
| 2000-09-21 | IWD | ETF | 56.0312 | 56.0312 | 55.8125 | 56.0312 | 54500.0 |
| 2000-09-21 | IWF | ETF | 21.296875 | 21.296875 | 21.2422 | 21.2422 | 102800.0 |
| 2000-09-21 | IWN | ETF | 35.7604 | 35.7604 | 35.5417 | 35.5417 | 4200.0 |
| 2000-09-21 | IWO | ETF | 80.9688 | 80.9688 | 79.75 | 80.0625 | 39100.0 |
> showing 50 of 79 rows — these rows as CSV