PREVIEW / etf_daily / 2000-10-06
file: by_date/etf_daily/2000/2000-10-06.parquet size: 8 KB rows: 87
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-06 | SPY | ETF | 143.875 | 144.6406 | 139.75 | 141.0625 | 10014900.0 |
| 2000-10-06 | QQQ | ETF | 85.5625 | 86.5625 | 81.25 | 83.0 | 36335800.0 |
| 2000-10-06 | IWM | ETF | 50.1562 | 50.1562 | 48.7812 | 48.8438 | 185600.0 |
| 2000-10-06 | DIA | ETF | 107.25 | 107.9688 | 105.2188 | 106.1875 | 1306700.0 |
| 2000-10-06 | BBH | ETF | 60.5833 | 60.8333 | 57.2708 | 57.7292 | 3022800.0 |
| 2000-10-06 | BITS | ETF | 13.75 | 13.75 | 13.0 | 13.75 | 5850.0 |
| 2000-10-06 | BOSS | ETF | 22.0 | 22.3 | 22.0 | 22.3 | 1000.0 |
| 2000-10-06 | CEF | ETF | 3.1875 | 3.25 | 3.1875 | 3.1875 | 18400.0 |
| 2000-10-06 | CHB | ETF | 3.94 | 4.0 | 3.69 | 4.0 | 576800.0 |
| 2000-10-06 | CNXT | ETF | 36.13 | 38.88 | 36.13 | 37.25 | 4314550.0 |
| 2000-10-06 | CSB | ETF | 1.04999995231628 | 1.10000002384186 | 1.04999995231628 | 1.04999995231628 | 15300.0 |
| 2000-10-06 | DGT | ETF | 85.4062 | 85.4062 | 84.25 | 84.25 | 2900.0 |
| 2000-10-06 | EWA | ETF | 9.3125 | 9.3125 | 9.25 | 9.25 | 16000.0 |
| 2000-10-06 | EWC | ETF | 16.5625 | 16.5625 | 16.25 | 16.25 | 143200.0 |
| 2000-10-06 | EWD | ETF | 21.5625 | 21.5625 | 21.3125 | 21.3125 | 500.0 |
| 2000-10-06 | EWG | ETF | 19.25 | 19.25 | 18.6875 | 18.75 | 116100.0 |
| 2000-10-06 | EWH | ETF | 12.0625 | 12.125 | 11.75 | 11.8125 | 31100.0 |
| 2000-10-06 | EWI | ETF | 42.375 | 42.375 | 41.625 | 41.625 | 500.0 |
| 2000-10-06 | EWJ | ETF | 53.75 | 53.75 | 52.75 | 53.0 | 75850.0 |
| 2000-10-06 | EWK | ETF | 12.5 | 12.5 | 12.5 | 12.5 | 2000.0 |
| 2000-10-06 | EWL | ETF | 15.0 | 15.125 | 15.0 | 15.125 | 4800.0 |
| 2000-10-06 | EWM | ETF | 20.75 | 20.75 | 20.25 | 20.25 | 37525.0 |
| 2000-10-06 | EWN | ETF | 22.5 | 22.5 | 22.375 | 22.5 | 1000.0 |
| 2000-10-06 | EWQ | ETF | 24.5 | 24.5625 | 24.0 | 24.0 | 29400.0 |
| 2000-10-06 | EWS | ETF | 13.5 | 13.5 | 13.0 | 13.0 | 42900.0 |
| 2000-10-06 | EWT | ETF | 28.0 | 28.25 | 27.5 | 27.5 | 61000.0 |
| 2000-10-06 | EWU | ETF | 35.875 | 35.875 | 35.125 | 35.125 | 4750.0 |
| 2000-10-06 | EWW | ETF | 15.0 | 15.0 | 14.625 | 14.75 | 42700.0 |
| 2000-10-06 | EWY | ETF | 16.25 | 16.25 | 15.875 | 15.875 | 900.0 |
| 2000-10-06 | EWZ | ETF | 18.0 | 18.0 | 18.0 | 18.0 | 200.0 |
| 2000-10-06 | EZU | ETF | 35.625 | 35.625 | 35.3125 | 35.3125 | 1400.0 |
| 2000-10-06 | FCTR | ETF | 14.0 | 14.25 | 14.0 | 14.0 | 27600.0 |
| 2000-10-06 | FMAR | ETF | 5.25 | 5.38 | 5.0 | 5.38 | 5000.0 |
| 2000-10-06 | GLDB | ETF | 5.0313 | 5.125 | 5.0313 | 5.0313 | 28600.0 |
| 2000-10-06 | GSIG | ETF | 15.95 | 16.0 | 14.75 | 15.0 | 1205100.0 |
| 2000-10-06 | IDU | ETF | 41.375 | 41.7031 | 41.375 | 41.3906 | 3600.0 |
| 2000-10-06 | IEV | ETF | 37.4062 | 37.4062 | 37.125 | 37.25 | 132800.0 |
| 2000-10-06 | IGLD | ETF | 475.0 | 481.25 | 400.0 | 437.5 | 1080.0 |
| 2000-10-06 | IJH | ETF | 10.4984 | 10.4984 | 10.2156 | 10.2625 | 1326000.0 |
| 2000-10-06 | IJJ | ETF | 19.2539 | 19.2539 | 19.1523 | 19.1562 | 32000.0 |
| 2000-10-06 | IJK | ETF | 17.5469 | 17.5469 | 16.8887 | 16.9375 | 62400.0 |
| 2000-10-06 | IJR | ETF | 17.6042 | 17.6042 | 17.1979 | 17.2318 | 35400.0 |
| 2000-10-06 | IJS | ETF | 17.6016 | 17.6016 | 17.3984 | 17.3984 | 96800.0 |
| 2000-10-06 | IJT | ETF | 20.1562 | 20.1562 | 19.5703 | 19.5703 | 13600.0 |
| 2000-10-06 | IUSG | ETF | 30.875 | 30.875 | 30.875 | 30.875 | 200.0 |
| 2000-10-06 | IUSV | ETF | 24.1823 | 24.1823 | 24.1823 | 24.1823 | 1800.0 |
| 2000-10-06 | IVE | ETF | 62.7969 | 62.7969 | 61.7812 | 61.9844 | 9400.0 |
| 2000-10-06 | IVV | ETF | 144.1719 | 144.375 | 140.0 | 141.0781 | 103800.0 |
| 2000-10-06 | IVW | ETF | 20.5 | 20.5 | 20.0 | 20.2617 | 160800.0 |
| 2000-10-06 | IWB | ETF | 76.9 | 76.95 | 74.7 | 75.09 | 166800.0 |
> showing 50 of 87 rows — these rows as CSV