PREVIEW / etf_daily / 2000-09-12
file: by_date/etf_daily/2000/2000-09-12.parquet size: 8 KB rows: 82
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-09-12 | SPY | ETF | 149.75 | 150.25 | 148.4375 | 148.5 | 4769100.0 |
| 2000-09-12 | QQQ | ETF | 93.5 | 94.6875 | 90.8438 | 91.375 | 24256100.0 |
| 2000-09-12 | IWM | ETF | 53.8125 | 53.8125 | 53.25 | 53.3281 | 93000.0 |
| 2000-09-12 | DIA | ETF | 111.9375 | 113.0625 | 111.1562 | 112.9062 | 617600.0 |
| 2000-09-12 | BBH | ETF | 61.4583 | 62.1458 | 60.0 | 60.375 | 2664900.0 |
| 2000-09-12 | BITS | ETF | 18.5 | 20.0 | 18.5 | 19.0 | 4625.0 |
| 2000-09-12 | CEF | ETF | 3.3125 | 3.3125 | 3.25 | 3.25 | 10700.0 |
| 2000-09-12 | CHB | ETF | 5.5 | 5.75 | 4.75 | 4.81 | 216000.0 |
| 2000-09-12 | CNXT | ETF | 34.56 | 35.5 | 33.63 | 33.75 | 2850300.0 |
| 2000-09-12 | CSB | ETF | 1.79999995231628 | 1.79999995231628 | 1.79999995231628 | 1.79999995231628 | 11000.0 |
| 2000-09-12 | EWA | ETF | 9.75 | 9.9375 | 9.75 | 9.75 | 28800.0 |
| 2000-09-12 | EWC | ETF | 16.5 | 16.6875 | 16.4375 | 16.5 | 11300.0 |
| 2000-09-12 | EWD | ETF | 23.625 | 23.625 | 23.4375 | 23.5 | 3400.0 |
| 2000-09-12 | EWG | ETF | 19.875 | 19.875 | 19.625 | 19.75 | 27800.0 |
| 2000-09-12 | EWH | ETF | 12.875 | 12.875 | 12.6875 | 12.6875 | 31500.0 |
| 2000-09-12 | EWI | ETF | 43.5 | 43.5 | 43.375 | 43.375 | 4250.0 |
| 2000-09-12 | EWJ | ETF | 53.5 | 53.5 | 53.0 | 53.5 | 42775.0 |
| 2000-09-12 | EWK | ETF | 12.5625 | 12.5625 | 12.4375 | 12.4375 | 5000.0 |
| 2000-09-12 | EWL | ETF | 15.25 | 15.25 | 14.9375 | 14.9375 | 11900.0 |
| 2000-09-12 | EWM | ETF | 21.5 | 21.75 | 21.5 | 21.75 | 2575.0 |
| 2000-09-12 | EWN | ETF | 23.3125 | 23.3125 | 22.9375 | 23.0 | 900.0 |
| 2000-09-12 | EWO | ETF | 7.625 | 7.625 | 7.4375 | 7.4375 | 5000.0 |
| 2000-09-12 | EWP | ETF | 24.25 | 24.5625 | 24.25 | 24.375 | 5300.0 |
| 2000-09-12 | EWQ | ETF | 25.875 | 26.0 | 25.75 | 26.0 | 31900.0 |
| 2000-09-12 | EWS | ETF | 14.625 | 14.625 | 14.25 | 14.25 | 43950.0 |
| 2000-09-12 | EWT | ETF | 32.25 | 32.25 | 32.25 | 32.25 | 800.0 |
| 2000-09-12 | EWU | ETF | 35.625 | 35.625 | 35.125 | 35.25 | 17400.0 |
| 2000-09-12 | EWW | ETF | 16.875 | 16.875 | 16.25 | 16.25 | 49800.0 |
| 2000-09-12 | EWY | ETF | 17.5 | 17.5 | 17.25 | 17.5 | 5200.0 |
| 2000-09-12 | EWZ | ETF | 19.6875 | 19.6875 | 19.6875 | 19.6875 | 500.0 |
| 2000-09-12 | EZU | ETF | 37.5938 | 37.6562 | 37.5938 | 37.6562 | 9200.0 |
| 2000-09-12 | FCTR | ETF | 15.8125 | 16.0 | 15.75 | 16.0 | 49900.0 |
| 2000-09-12 | FMAR | ETF | 5.59 | 5.59 | 5.12 | 5.12 | 5600.0 |
| 2000-09-12 | GLDB | ETF | 5.1875 | 5.375 | 5.1563 | 5.25 | 128600.0 |
| 2000-09-12 | GSIG | ETF | 22.5 | 22.75 | 21.81 | 22.25 | 245400.0 |
| 2000-09-12 | IDU | ETF | 43.25 | 43.375 | 42.4844 | 42.9219 | 89200.0 |
| 2000-09-12 | IEV | ETF | 38.625 | 38.8125 | 38.5 | 38.8125 | 14600.0 |
| 2000-09-12 | IGLD | ETF | 600.0 | 625.0 | 596.875 | 596.875 | 269.0 |
| 2000-09-12 | IJH | ETF | 10.9781 | 10.9969 | 10.85 | 10.8719 | 2120000.0 |
| 2000-09-12 | IJJ | ETF | 20.0898 | 20.0898 | 19.9922 | 19.9922 | 15600.0 |
| 2000-09-12 | IJK | ETF | 18.5293 | 18.5352 | 18.3906 | 18.4043 | 18400.0 |
| 2000-09-12 | IJR | ETF | 18.5651 | 18.5651 | 18.5469 | 18.5469 | 27000.0 |
| 2000-09-12 | IJT | ETF | 21.8594 | 22.0469 | 21.8594 | 22.0469 | 8800.0 |
| 2000-09-12 | IUSG | ETF | 34.2188 | 34.2188 | 34.2188 | 34.2188 | 600.0 |
| 2000-09-12 | IVE | ETF | 64.375 | 64.375 | 64.0938 | 64.2031 | 900.0 |
| 2000-09-12 | IVV | ETF | 149.6875 | 149.875 | 148.5 | 148.5 | 109000.0 |
| 2000-09-12 | IVW | ETF | 21.9062 | 21.9883 | 21.7539 | 21.7539 | 7600.0 |
| 2000-09-12 | IWB | ETF | 80.0 | 80.125 | 79.375 | 79.375 | 2500.0 |
| 2000-09-12 | IWD | ETF | 58.7812 | 58.875 | 58.6875 | 58.8438 | 90600.0 |
| 2000-09-12 | IWF | ETF | 21.59375 | 21.71875 | 21.25 | 21.25 | 87600.0 |
> showing 50 of 82 rows — these rows as CSV