PREVIEW / etf_daily / 2000-07-25
file: by_date/etf_daily/2000/2000-07-25.parquet size: 7 KB rows: 66
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-07-25 | SPY | ETF | 147.75 | 147.8438 | 146.7812 | 147.3125 | 4757100.0 |
| 2000-07-25 | QQQ | ETF | 95.625 | 97.0 | 93.8125 | 95.75 | 19065700.0 |
| 2000-07-25 | IWM | ETF | 51.6797 | 51.6797 | 51.0625 | 51.375 | 36800.0 |
| 2000-07-25 | DIA | ETF | 107.3438 | 107.5 | 106.6875 | 106.7812 | 275600.0 |
| 2000-07-25 | BBH | ETF | 60.375 | 60.4167 | 57.5208 | 57.9583 | 2268600.0 |
| 2000-07-25 | BITS | ETF | 18.0 | 18.25 | 16.5 | 18.0 | 9625.0 |
| 2000-07-25 | CEF | ETF | 3.25 | 3.375 | 3.25 | 3.25 | 20700.0 |
| 2000-07-25 | CHB | ETF | 5.19 | 5.44 | 5.13 | 5.31 | 65600.0 |
| 2000-07-25 | CNXT | ETF | 37.25 | 38.44 | 36.5 | 36.94 | 3552390.0 |
| 2000-07-25 | EWA | ETF | 10.3125 | 10.375 | 10.3125 | 10.375 | 10600.0 |
| 2000-07-25 | EWC | ETF | 21.25 | 21.75 | 21.125 | 21.5 | 180000.0 |
| 2000-07-25 | EWD | ETF | 31.3125 | 31.3125 | 31.3125 | 31.3125 | 2800.0 |
| 2000-07-25 | EWG | ETF | 24.8125 | 24.9375 | 24.5625 | 24.8125 | 16600.0 |
| 2000-07-25 | EWH | ETF | 13.5 | 13.6875 | 13.3125 | 13.5625 | 115100.0 |
| 2000-07-25 | EWI | ETF | 52.25 | 52.25 | 52.125 | 52.25 | 450.0 |
| 2000-07-25 | EWJ | ETF | 55.5 | 56.0 | 55.0 | 55.75 | 115425.0 |
| 2000-07-25 | EWK | ETF | 13.875 | 13.875 | 13.75 | 13.75 | 500.0 |
| 2000-07-25 | EWL | ETF | 16.5 | 16.5 | 16.25 | 16.5 | 9700.0 |
| 2000-07-25 | EWM | ETF | 24.75 | 25.0 | 24.5 | 24.5 | 3700.0 |
| 2000-07-25 | EWN | ETF | 24.4375 | 24.6875 | 24.375 | 24.5625 | 3300.0 |
| 2000-07-25 | EWO | ETF | 8.125 | 8.125 | 8.0 | 8.0 | 1000.0 |
| 2000-07-25 | EWP | ETF | 26.0625 | 26.25 | 26.0625 | 26.25 | 900.0 |
| 2000-07-25 | EWQ | ETF | 28.6875 | 28.6875 | 28.375 | 28.625 | 10000.0 |
| 2000-07-25 | EWS | ETF | 15.375 | 15.375 | 15.125 | 15.125 | 14850.0 |
| 2000-07-25 | EWU | ETF | 38.625 | 39.0 | 38.5 | 38.75 | 17200.0 |
| 2000-07-25 | EWW | ETF | 16.8125 | 17.1875 | 16.8125 | 17.1875 | 33600.0 |
| 2000-07-25 | EWY | ETF | 19.375 | 19.5625 | 19.375 | 19.5625 | 8500.0 |
| 2000-07-25 | FCTR | ETF | 14.75 | 14.9375 | 14.75 | 14.9375 | 9800.0 |
| 2000-07-25 | FMAR | ETF | 5.03 | 5.25 | 5.0 | 5.0 | 3500.0 |
| 2000-07-25 | GLDB | ETF | 4.9063 | 5.0 | 4.875 | 5.0 | 94900.0 |
| 2000-07-25 | GSIG | ETF | 38.0 | 38.25 | 33.0 | 34.75 | 875400.0 |
| 2000-07-25 | IGLD | ETF | 812.5 | 812.5 | 781.25 | 781.25 | 351.0 |
| 2000-07-25 | IJH | ETF | 10.0219 | 10.0219 | 9.9297 | 9.9625 | 836000.0 |
| 2000-07-25 | IJR | ETF | 17.599 | 17.6094 | 17.4375 | 17.5 | 124800.0 |
| 2000-07-25 | IVE | ETF | 60.1875 | 60.3281 | 59.9219 | 59.9219 | 46500.0 |
| 2000-07-25 | IVV | ETF | 147.4688 | 147.5156 | 146.8125 | 147.4219 | 116700.0 |
| 2000-07-25 | IVW | ETF | 22.582 | 22.6133 | 22.4531 | 22.5547 | 124000.0 |
| 2000-07-25 | IWB | ETF | 78.5 | 78.5 | 77.9531 | 78.1406 | 1200.0 |
| 2000-07-25 | IWD | ETF | 55.0938 | 55.5938 | 55.0938 | 55.1094 | 38700.0 |
| 2000-07-25 | IWF | ETF | 21.6875 | 21.886725 | 21.6875 | 21.85155 | 120800.0 |
| 2000-07-25 | IWV | ETF | 80.8438 | 80.8438 | 80.2344 | 80.5 | 3000.0 |
| 2000-07-25 | IYE | ETF | 15.2917 | 15.2917 | 15.25 | 15.25 | 600.0 |
| 2000-07-25 | IYF | ETF | 38.0938 | 38.4531 | 38.0938 | 38.4531 | 3600.0 |
| 2000-07-25 | IYG | ETF | 29.3021 | 29.3021 | 29.3021 | 29.3021 | 300.0 |
| 2000-07-25 | IYH | ETF | 12.8375 | 12.8375 | 12.55 | 12.55 | 16000.0 |
| 2000-07-25 | IYR | ETF | 36.6562 | 36.6562 | 36.625 | 36.625 | 5600.0 |
| 2000-07-25 | IYW | ETF | 31.8398 | 31.8906 | 31.5 | 31.8906 | 2400.0 |
| 2000-07-25 | IYY | ETF | 34.4375 | 34.4375 | 34.1094 | 34.2969 | 16800.0 |
| 2000-07-25 | IYZ | ETF | 59.625 | 59.9375 | 59.625 | 59.7812 | 700.0 |
| 2000-07-25 | KTEC | ETF | 8.875 | 8.875 | 8.25 | 8.25 | 7300.0 |
> showing 50 of 66 rows — these rows as CSV