PREVIEW / etf_daily / 2000-10-20
file: by_date/etf_daily/2000/2000-10-20.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-10-20 | SPY | ETF | 138.375 | 141.1875 | 138.375 | 139.9062 | 7373500.0 |
| 2000-10-20 | QQQ | ETF | 84.5 | 87.875 | 84.3906 | 86.3125 | 40692200.0 |
| 2000-10-20 | IWM | ETF | 48.3438 | 49.0312 | 48.3203 | 48.5781 | 264800.0 |
| 2000-10-20 | DIA | ETF | 100.875 | 102.6875 | 100.8125 | 102.375 | 1682500.0 |
| 2000-10-20 | BBH | ETF | 59.3333 | 60.125 | 58.6875 | 59.3542 | 1386900.0 |
| 2000-10-20 | BITS | ETF | 7.875 | 10.75 | 7.75 | 9.5 | 19725.0 |
| 2000-10-20 | CEF | ETF | 2.8125 | 3.0625 | 2.8125 | 3.0 | 91200.0 |
| 2000-10-20 | CHB | ETF | 3.38 | 3.44 | 3.19 | 3.25 | 98900.0 |
| 2000-10-20 | CNXT | ETF | 29.0 | 30.75 | 27.5 | 28.19 | 5853710.0 |
| 2000-10-20 | DGT | ETF | 82.5312 | 82.9688 | 82.3906 | 82.9688 | 400.0 |
| 2000-10-20 | EWA | ETF | 9.125 | 9.1875 | 9.0 | 9.0625 | 13100.0 |
| 2000-10-20 | EWC | ETF | 15.8125 | 16.25 | 15.8125 | 15.9375 | 220800.0 |
| 2000-10-20 | EWD | ETF | 19.1875 | 19.625 | 19.1875 | 19.375 | 105200.0 |
| 2000-10-20 | EWG | ETF | 17.8125 | 18.25 | 17.8125 | 18.1875 | 426400.0 |
| 2000-10-20 | EWH | ETF | 11.25 | 11.375 | 11.0625 | 11.25 | 159500.0 |
| 2000-10-20 | EWI | ETF | 40.875 | 41.25 | 40.625 | 41.25 | 6100.0 |
| 2000-10-20 | EWJ | ETF | 51.0 | 51.0 | 50.5 | 50.75 | 41525.0 |
| 2000-10-20 | EWK | ETF | 11.9375 | 12.125 | 11.9375 | 12.125 | 5600.0 |
| 2000-10-20 | EWL | ETF | 14.3125 | 14.625 | 14.3125 | 14.625 | 289500.0 |
| 2000-10-20 | EWM | ETF | 22.5 | 22.5 | 22.5 | 22.5 | 5975.0 |
| 2000-10-20 | EWN | ETF | 21.6875 | 21.8125 | 21.4375 | 21.8125 | 164600.0 |
| 2000-10-20 | EWO | ETF | 6.875 | 6.875 | 6.875 | 6.875 | 5000.0 |
| 2000-10-20 | EWP | ETF | 23.0 | 23.0625 | 23.0 | 23.0 | 1800.0 |
| 2000-10-20 | EWQ | ETF | 22.625 | 23.25 | 22.625 | 23.25 | 26800.0 |
| 2000-10-20 | EWS | ETF | 13.25 | 13.25 | 13.125 | 13.125 | 15300.0 |
| 2000-10-20 | EWT | ETF | 25.0 | 25.0 | 23.875 | 23.875 | 7700.0 |
| 2000-10-20 | EWU | ETF | 34.375 | 35.0 | 34.375 | 34.625 | 37800.0 |
| 2000-10-20 | EWW | ETF | 14.25 | 14.625 | 14.25 | 14.4375 | 39900.0 |
| 2000-10-20 | EWY | ETF | 14.5 | 14.625 | 14.5 | 14.5625 | 5000.0 |
| 2000-10-20 | EWZ | ETF | 16.875 | 16.9375 | 16.875 | 16.9375 | 1500.0 |
| 2000-10-20 | EZU | ETF | 33.6875 | 34.0 | 33.6875 | 34.0 | 3000.0 |
| 2000-10-20 | FCTR | ETF | 15.0 | 15.5625 | 15.0 | 15.4375 | 5800.0 |
| 2000-10-20 | FMAR | ETF | 4.88 | 5.0 | 4.75 | 4.75 | 9200.0 |
| 2000-10-20 | GLDB | ETF | 4.0 | 4.125 | 3.875 | 4.125 | 62200.0 |
| 2000-10-20 | GSIG | ETF | 13.34 | 13.37 | 12.81 | 13.0 | 326400.0 |
| 2000-10-20 | IDU | ETF | 40.9531 | 41.1406 | 40.7031 | 40.7031 | 34600.0 |
| 2000-10-20 | IEV | ETF | 36.0 | 36.375 | 35.9688 | 36.3047 | 7800.0 |
| 2000-10-20 | IGLD | ETF | 300.0 | 306.25 | 275.0 | 293.75 | 1115.0 |
| 2000-10-20 | IJH | ETF | 10.2 | 10.3656 | 10.2 | 10.3469 | 353000.0 |
| 2000-10-20 | IJJ | ETF | 18.918 | 18.9727 | 18.918 | 18.9688 | 12800.0 |
| 2000-10-20 | IJK | ETF | 17.0781 | 17.4356 | 17.0742 | 17.3301 | 147200.0 |
| 2000-10-20 | IJR | ETF | 17.2292 | 17.487 | 17.2188 | 17.4479 | 69000.0 |
| 2000-10-20 | IJT | ETF | 20.5078 | 20.6211 | 20.5078 | 20.6211 | 7200.0 |
| 2000-10-20 | IVE | ETF | 60.5625 | 61.1562 | 60.5625 | 61.125 | 26800.0 |
| 2000-10-20 | IVV | ETF | 138.9844 | 141.1094 | 138.7812 | 140.2188 | 177100.0 |
| 2000-10-20 | IVW | ETF | 20.0938 | 20.5156 | 20.0586 | 20.2266 | 179600.0 |
| 2000-10-20 | IWB | ETF | 74.25 | 75.44 | 74.25 | 74.74 | 7900.0 |
| 2000-10-20 | IWD | ETF | 56.1719 | 56.4531 | 56.0156 | 56.3281 | 14300.0 |
| 2000-10-20 | IWF | ETF | 19.667975 | 20.109375 | 19.644525 | 19.8125 | 81200.0 |
| 2000-10-20 | IWN | ETF | 34.2917 | 34.3698 | 34.2917 | 34.3698 | 7500.0 |
> showing 50 of 80 rows — these rows as CSV