PREVIEW / etf_daily / 2000-12-29
file: by_date/etf_daily/2000/2000-12-29.parquet size: 8 KB rows: 92
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-12-29 | SPY | ETF | 134.0625 | 134.2812 | 131.1875 | 131.1875 | 8774600.0 |
| 2000-12-29 | QQQ | ETF | 61.5625 | 62.2344 | 58.0 | 58.375 | 49195400.0 |
| 2000-12-29 | IWM | ETF | 49.4688 | 49.6094 | 47.8125 | 47.875 | 1803800.0 |
| 2000-12-29 | DIA | ETF | 109.1562 | 109.1562 | 106.7812 | 106.7812 | 1552800.0 |
| 2000-12-29 | BBH | ETF | 58.375 | 58.9792 | 56.5 | 56.7708 | 1853700.0 |
| 2000-12-29 | BITS | ETF | 8.5 | 10.25 | 8.0 | 10.25 | 39200.0 |
| 2000-12-29 | CEF | ETF | 3.125 | 3.1875 | 3.0625 | 3.1875 | 103200.0 |
| 2000-12-29 | CHB | ETF | 2.88 | 3.13 | 2.75 | 2.75 | 303800.0 |
| 2000-12-29 | CNXT | ETF | 15.94 | 16.25 | 15.0 | 15.38 | 5801820.0 |
| 2000-12-29 | DGT | ETF | 77.375 | 77.375 | 76.9688 | 76.9688 | 1100.0 |
| 2000-12-29 | EWA | ETF | 9.25 | 9.5 | 9.25 | 9.5 | 97800.0 |
| 2000-12-29 | EWC | ETF | 13.25 | 13.4375 | 13.125 | 13.375 | 35300.0 |
| 2000-12-29 | EWD | ETF | 18.0625 | 18.1875 | 17.875 | 17.875 | 18800.0 |
| 2000-12-29 | EWG | ETF | 19.125 | 19.625 | 19.125 | 19.5 | 79200.0 |
| 2000-12-29 | EWH | ETF | 11.5 | 11.75 | 11.4375 | 11.5 | 78500.0 |
| 2000-12-29 | EWI | ETF | 44.5 | 45.25 | 44.5 | 45.25 | 21700.0 |
| 2000-12-29 | EWJ | ETF | 44.0 | 44.75 | 44.0 | 44.25 | 301900.0 |
| 2000-12-29 | EWK | ETF | 12.75 | 13.0 | 12.75 | 12.75 | 8900.0 |
| 2000-12-29 | EWL | ETF | 16.5 | 16.8125 | 16.5 | 16.8125 | 49700.0 |
| 2000-12-29 | EWM | ETF | 20.5 | 20.5 | 20.0 | 20.25 | 11975.0 |
| 2000-12-29 | EWN | ETF | 22.6875 | 22.8125 | 22.625 | 22.6875 | 18800.0 |
| 2000-12-29 | EWO | ETF | 7.5 | 7.6875 | 7.5 | 7.5625 | 18800.0 |
| 2000-12-29 | EWP | ETF | 22.875 | 23.0625 | 22.875 | 22.9375 | 14900.0 |
| 2000-12-29 | EWQ | ETF | 24.4375 | 24.875 | 24.4375 | 24.6875 | 55500.0 |
| 2000-12-29 | EWS | ETF | 13.125 | 13.25 | 13.0 | 13.0 | 26250.0 |
| 2000-12-29 | EWT | ETF | 20.75 | 21.375 | 20.75 | 21.125 | 31850.0 |
| 2000-12-29 | EWU | ETF | 35.25 | 35.875 | 35.125 | 35.25 | 126400.0 |
| 2000-12-29 | EWW | ETF | 13.5 | 13.5625 | 13.25 | 13.3125 | 19600.0 |
| 2000-12-29 | EWY | ETF | 12.1875 | 12.25 | 12.125 | 12.25 | 5100.0 |
| 2000-12-29 | EWZ | ETF | 16.375 | 16.5 | 16.0 | 16.5 | 24400.0 |
| 2000-12-29 | EZU | ETF | 36.7812 | 36.7812 | 36.25 | 36.625 | 178800.0 |
| 2000-12-29 | FCTR | ETF | 14.0625 | 14.9375 | 14.0 | 14.875 | 70000.0 |
| 2000-12-29 | FMAR | ETF | 3.88 | 4.19 | 3.8785 | 4.0 | 30790.0 |
| 2000-12-29 | GLDB | ETF | 4.6406 | 5.0625 | 4.6406 | 4.6875 | 385000.0 |
| 2000-12-29 | GSIG | ETF | 7.91 | 8.44 | 7.5 | 8.0 | 381900.0 |
| 2000-12-29 | IDU | ETF | 44.7812 | 44.7812 | 44.2812 | 44.3906 | 7400.0 |
| 2000-12-29 | IEV | ETF | 38.25 | 38.4062 | 38.1875 | 38.3438 | 69400.0 |
| 2000-12-29 | IGLD | ETF | 128.125 | 187.5 | 121.875 | 168.75 | 2183.0 |
| 2000-12-29 | IJH | ETF | 10.55 | 10.5641 | 10.3234 | 10.3281 | 367000.0 |
| 2000-12-29 | IJJ | ETF | 21.6328 | 21.6797 | 21.375 | 21.375 | 94400.0 |
| 2000-12-29 | IJK | ETF | 15.918 | 15.9492 | 15.4375 | 15.4844 | 575200.0 |
| 2000-12-29 | IJR | ETF | 18.5156 | 18.6094 | 18.0156 | 18.0156 | 1050000.0 |
| 2000-12-29 | IJS | ETF | 19.4688 | 19.5664 | 19.25 | 19.25 | 41600.0 |
| 2000-12-29 | IJT | ETF | 20.1406 | 20.1406 | 19.6016 | 19.6016 | 29600.0 |
| 2000-12-29 | IOO | ETF | 35.0547 | 35.0703 | 34.8281 | 34.8438 | 5400.0 |
| 2000-12-29 | IUSG | ETF | 26.0703 | 26.0703 | 25.8281 | 25.8906 | 14200.0 |
| 2000-12-29 | IUSV | ETF | 25.5417 | 25.5417 | 25.4583 | 25.5417 | 8700.0 |
| 2000-12-29 | IVE | ETF | 64.375 | 64.375 | 63.375 | 63.375 | 509700.0 |
| 2000-12-29 | IVV | ETF | 133.9375 | 134.1875 | 131.3594 | 131.3594 | 250800.0 |
| 2000-12-29 | IVW | ETF | 17.4062 | 17.5 | 17.0625 | 17.0625 | 1297600.0 |
> showing 50 of 92 rows — these rows as CSV