PREVIEW / etf_daily / 2000-11-22
file: by_date/etf_daily/2000/2000-11-22.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-11-22 | SPY | ETF | 134.3438 | 134.875 | 132.125 | 132.1406 | 5736900.0 |
| 2000-11-22 | QQQ | ETF | 68.4375 | 70.125 | 66.5 | 66.625 | 56624700.0 |
| 2000-11-22 | IWM | ETF | 46.2812 | 46.5 | 45.4688 | 45.6562 | 123400.0 |
| 2000-11-22 | DIA | ETF | 104.625 | 105.125 | 103.75 | 103.875 | 1096100.0 |
| 2000-11-22 | BBH | ETF | 51.0 | 52.7917 | 50.5208 | 51.4167 | 4434000.0 |
| 2000-11-22 | BITS | ETF | 9.125 | 9.25 | 8.5 | 8.875 | 4225.0 |
| 2000-11-22 | CEF | ETF | 3.0 | 3.0 | 2.9375 | 3.0 | 29200.0 |
| 2000-11-22 | CHB | ETF | 3.38 | 3.44 | 3.19 | 3.25 | 42200.0 |
| 2000-11-22 | CNXT | ETF | 26.59 | 28.22 | 25.91 | 25.97 | 2377300.0 |
| 2000-11-22 | DGT | ETF | 80.3125 | 80.3125 | 80.0 | 80.0 | 1600.0 |
| 2000-11-22 | EWA | ETF | 9.125 | 9.1875 | 9.0625 | 9.125 | 22300.0 |
| 2000-11-22 | EWC | ETF | 13.5 | 13.5 | 13.25 | 13.25 | 14200.0 |
| 2000-11-22 | EWD | ETF | 17.1875 | 17.25 | 17.1875 | 17.1875 | 4100.0 |
| 2000-11-22 | EWG | ETF | 18.0 | 18.0 | 17.75 | 17.75 | 62700.0 |
| 2000-11-22 | EWH | ETF | 11.1875 | 11.1875 | 10.8125 | 10.9375 | 30200.0 |
| 2000-11-22 | EWI | ETF | 43.125 | 43.125 | 42.625 | 42.625 | 750.0 |
| 2000-11-22 | EWJ | ETF | 47.0 | 47.25 | 46.5 | 46.75 | 95325.0 |
| 2000-11-22 | EWK | ETF | 12.1875 | 12.1875 | 12.1875 | 12.1875 | 2000.0 |
| 2000-11-22 | EWL | ETF | 14.875 | 15.0625 | 14.875 | 14.9375 | 8600.0 |
| 2000-11-22 | EWM | ETF | 21.25 | 21.25 | 21.25 | 21.25 | 5100.0 |
| 2000-11-22 | EWN | ETF | 21.375 | 21.6875 | 21.3125 | 21.3125 | 1200.0 |
| 2000-11-22 | EWO | ETF | 7.0625 | 7.1875 | 7.0 | 7.1875 | 700.0 |
| 2000-11-22 | EWP | ETF | 21.0 | 21.1875 | 20.75 | 20.875 | 12500.0 |
| 2000-11-22 | EWQ | ETF | 22.6875 | 22.6875 | 22.25 | 22.25 | 38800.0 |
| 2000-11-22 | EWS | ETF | 12.875 | 12.875 | 12.75 | 12.875 | 7100.0 |
| 2000-11-22 | EWT | ETF | 22.125 | 22.625 | 22.125 | 22.625 | 750.0 |
| 2000-11-22 | EWU | ETF | 34.5 | 34.625 | 34.0 | 34.0 | 5550.0 |
| 2000-11-22 | EWW | ETF | 14.9375 | 15.125 | 14.75 | 14.9375 | 38300.0 |
| 2000-11-22 | EWY | ETF | 13.5625 | 13.5625 | 13.5625 | 13.5625 | 100.0 |
| 2000-11-22 | EZU | ETF | 33.25 | 33.8125 | 33.25 | 33.8125 | 12000.0 |
| 2000-11-22 | FCTR | ETF | 14.5625 | 14.5625 | 13.875 | 13.875 | 13700.0 |
| 2000-11-22 | FMAR | ETF | 5.1693 | 5.1693 | 4.69 | 4.69 | 1820.0 |
| 2000-11-22 | GLDB | ETF | 4.375 | 4.375 | 4.0 | 4.0 | 55100.0 |
| 2000-11-22 | GSIG | ETF | 12.12 | 12.17 | 11.0 | 11.31 | 735500.0 |
| 2000-11-22 | IDU | ETF | 41.7969 | 41.9844 | 41.7812 | 41.7812 | 11600.0 |
| 2000-11-22 | IEV | ETF | 36.25 | 36.875 | 35.875 | 35.875 | 115400.0 |
| 2000-11-22 | IGLD | ETF | 275.0 | 275.0 | 268.75 | 268.75 | 176.0 |
| 2000-11-22 | IJH | ETF | 9.8312 | 9.8312 | 9.7 | 9.75 | 1187000.0 |
| 2000-11-22 | IJJ | ETF | 19.3398 | 19.3398 | 19.1172 | 19.2227 | 416000.0 |
| 2000-11-22 | IJK | ETF | 15.502 | 15.5762 | 15.2617 | 15.4531 | 391200.0 |
| 2000-11-22 | IJR | ETF | 17.0521 | 17.1094 | 16.8542 | 16.9141 | 14400.0 |
| 2000-11-22 | IJS | ETF | 17.4141 | 17.4141 | 17.2773 | 17.3906 | 25200.0 |
| 2000-11-22 | IJT | ETF | 19.1992 | 19.2188 | 18.8086 | 18.9023 | 24000.0 |
| 2000-11-22 | IUSG | ETF | 27.7422 | 27.7422 | 27.1094 | 27.1094 | 2000.0 |
| 2000-11-22 | IUSV | ETF | 23.9948 | 23.9948 | 23.9323 | 23.9323 | 1200.0 |
| 2000-11-22 | IVE | ETF | 61.0 | 61.0312 | 60.5 | 60.5625 | 26500.0 |
| 2000-11-22 | IVV | ETF | 134.0625 | 134.7812 | 132.25 | 132.25 | 36300.0 |
| 2000-11-22 | IVW | ETF | 18.6094 | 18.7578 | 18.3828 | 18.4844 | 235200.0 |
| 2000-11-22 | IWB | ETF | 70.89 | 70.94 | 70.0 | 70.25 | 70700.0 |
| 2000-11-22 | IWD | ETF | 56.9375 | 56.9375 | 56.5469 | 56.625 | 17900.0 |
> showing 50 of 87 rows — these rows as CSV