PREVIEW / etf_daily / 2000-10-26
file: by_date/etf_daily/2000/2000-10-26.parquet size: 8 KB rows: 89
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-26 | SPY | ETF | 137.125 | 137.6562 | 134.0312 | 136.6875 | 9345800.0 |
| 2000-10-26 | QQQ | ETF | 78.1875 | 80.0 | 73.625 | 79.875 | 70010400.0 |
| 2000-10-26 | IWM | ETF | 47.7109 | 48.0 | 46.8438 | 48.0 | 105800.0 |
| 2000-10-26 | DIA | ETF | 103.0938 | 104.7188 | 102.5156 | 103.6875 | 2003600.0 |
| 2000-10-26 | BBH | ETF | 59.5833 | 61.6458 | 58.1667 | 60.2917 | 4438200.0 |
| 2000-10-26 | BITS | ETF | 9.0 | 10.0 | 9.0 | 10.0 | 5725.0 |
| 2000-10-26 | BOSS | ETF | 25.0 | 25.0 | 24.0 | 25.0 | 500.0 |
| 2000-10-26 | CEF | ETF | 3.0625 | 3.0625 | 3.0 | 3.0625 | 15900.0 |
| 2000-10-26 | CHB | ETF | 3.31 | 3.38 | 3.19 | 3.38 | 37400.0 |
| 2000-10-26 | CNXT | ETF | 23.62 | 24.25 | 20.44 | 22.94 | 7857880.0 |
| 2000-10-26 | DGT | ETF | 81.125 | 81.625 | 81.0 | 81.625 | 50700.0 |
| 2000-10-26 | EWA | ETF | 9.0 | 9.0 | 8.875 | 9.0 | 11100.0 |
| 2000-10-26 | EWC | ETF | 14.9375 | 14.9375 | 14.3125 | 14.5625 | 61800.0 |
| 2000-10-26 | EWD | ETF | 19.25 | 19.25 | 18.875 | 18.875 | 1500.0 |
| 2000-10-26 | EWG | ETF | 18.1875 | 18.375 | 18.1875 | 18.25 | 92800.0 |
| 2000-10-26 | EWH | ETF | 11.0 | 11.375 | 10.9375 | 11.375 | 100100.0 |
| 2000-10-26 | EWI | ETF | 41.375 | 41.375 | 41.125 | 41.125 | 400.0 |
| 2000-10-26 | EWJ | ETF | 50.75 | 50.75 | 49.5 | 50.25 | 58850.0 |
| 2000-10-26 | EWK | ETF | 11.75 | 12.0 | 11.75 | 11.875 | 1700.0 |
| 2000-10-26 | EWL | ETF | 14.5 | 14.625 | 14.375 | 14.4375 | 2700.0 |
| 2000-10-26 | EWM | ETF | 23.0 | 23.5 | 23.0 | 23.5 | 11125.0 |
| 2000-10-26 | EWN | ETF | 21.4375 | 21.5 | 21.3125 | 21.3125 | 29700.0 |
| 2000-10-26 | EWO | ETF | 6.9375 | 6.9375 | 6.875 | 6.875 | 9600.0 |
| 2000-10-26 | EWP | ETF | 22.5625 | 22.625 | 22.1875 | 22.625 | 6900.0 |
| 2000-10-26 | EWQ | ETF | 22.9375 | 23.125 | 22.8125 | 23.0 | 22600.0 |
| 2000-10-26 | EWS | ETF | 13.125 | 13.125 | 13.0 | 13.125 | 8750.0 |
| 2000-10-26 | EWT | ETF | 25.5 | 26.375 | 25.5 | 26.375 | 300.0 |
| 2000-10-26 | EWU | ETF | 35.0 | 35.0 | 34.375 | 34.75 | 39900.0 |
| 2000-10-26 | EWW | ETF | 14.5 | 14.625 | 14.4375 | 14.5 | 7600.0 |
| 2000-10-26 | EWY | ETF | 13.75 | 14.0 | 13.6875 | 13.6875 | 2800.0 |
| 2000-10-26 | EWZ | ETF | 15.1875 | 15.1875 | 15.1875 | 15.1875 | 100.0 |
| 2000-10-26 | EZU | ETF | 33.9688 | 34.1562 | 33.875 | 34.1562 | 12200.0 |
| 2000-10-26 | FCTR | ETF | 15.5156 | 15.75 | 15.5 | 15.75 | 40300.0 |
| 2000-10-26 | FMAR | ETF | 4.25 | 4.94 | 4.12 | 4.94 | 6600.0 |
| 2000-10-26 | GLDB | ETF | 3.7813 | 4.0625 | 3.75 | 4.0625 | 80900.0 |
| 2000-10-26 | GSIG | ETF | 11.25 | 11.37 | 10.12 | 11.12 | 569900.0 |
| 2000-10-26 | IDU | ETF | 39.875 | 39.875 | 39.25 | 39.5938 | 58600.0 |
| 2000-10-26 | IEV | ETF | 36.3125 | 36.375 | 36.1172 | 36.2188 | 26200.0 |
| 2000-10-26 | IGLD | ETF | 309.375 | 325.0 | 306.25 | 325.0 | 637.0 |
| 2000-10-26 | IJH | ETF | 9.925 | 10.0391 | 9.775 | 10.0391 | 966000.0 |
| 2000-10-26 | IJJ | ETF | 18.543 | 18.6094 | 18.4062 | 18.6094 | 4400.0 |
| 2000-10-26 | IJK | ETF | 16.2969 | 16.4531 | 15.9746 | 16.2363 | 197600.0 |
| 2000-10-26 | IJR | ETF | 17.1354 | 17.3073 | 16.8568 | 17.3073 | 73800.0 |
| 2000-10-26 | IJS | ETF | 16.9648 | 16.9648 | 16.8438 | 16.8438 | 8400.0 |
| 2000-10-26 | IJT | ETF | 20.0078 | 20.0078 | 19.7734 | 19.7812 | 19600.0 |
| 2000-10-26 | IUSG | ETF | 29.6875 | 29.6875 | 29.1875 | 29.1875 | 13400.0 |
| 2000-10-26 | IVE | ETF | 61.125 | 61.1875 | 60.25 | 60.5938 | 18400.0 |
| 2000-10-26 | IVV | ETF | 136.9375 | 137.5156 | 134.5156 | 136.7969 | 47700.0 |
| 2000-10-26 | IVW | ETF | 19.2344 | 19.4766 | 18.9414 | 19.4141 | 253200.0 |
| 2000-10-26 | IWB | ETF | 73.25 | 73.25 | 71.6 | 71.6 | 9600.0 |
> showing 50 of 89 rows — these rows as CSV