PREVIEW / etf_daily / 2000-06-07
file: by_date/etf_daily/2000/2000-06-07.parquet size: 7 KB rows: 61
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-06-07 | SPY | ETF | 146.625 | 148.0 | 146.0 | 147.4844 | 4919500.0 |
| 2000-06-07 | QQQ | ETF | 91.5625 | 94.0 | 89.5625 | 93.6875 | 22524400.0 |
| 2000-06-07 | IWM | ETF | 51.1875 | 51.5625 | 50.7188 | 51.5625 | 131000.0 |
| 2000-06-07 | DIA | ETF | 107.375 | 108.6875 | 107.0312 | 108.3438 | 895300.0 |
| 2000-06-07 | BBH | ETF | 53.4167 | 53.4167 | 51.6667 | 52.9792 | 2237400.0 |
| 2000-06-07 | BITS | ETF | 27.0 | 30.75 | 26.25 | 29.5 | 44800.0 |
| 2000-06-07 | BOSS | ETF | 16.0 | 16.5 | 16.0 | 16.5 | 500.0 |
| 2000-06-07 | CEF | ETF | 3.5 | 3.5 | 3.4375 | 3.5 | 22200.0 |
| 2000-06-07 | CHB | ETF | 5.94 | 5.94 | 5.81 | 5.94 | 68900.0 |
| 2000-06-07 | CNXT | ETF | 46.06 | 47.51 | 44.5 | 47.0 | 3279960.0 |
| 2000-06-07 | EWA | ETF | 9.875 | 10.125 | 9.875 | 10.0 | 31400.0 |
| 2000-06-07 | EWC | ETF | 18.75 | 19.0 | 18.5625 | 19.0 | 59700.0 |
| 2000-06-07 | EWD | ETF | 33.875 | 34.0 | 33.5625 | 34.0 | 6400.0 |
| 2000-06-07 | EWG | ETF | 25.6875 | 25.75 | 25.4375 | 25.5469 | 59900.0 |
| 2000-06-07 | EWH | ETF | 12.1875 | 12.5 | 12.1875 | 12.375 | 95500.0 |
| 2000-06-07 | EWI | ETF | 50.75 | 51.125 | 50.625 | 51.125 | 13600.0 |
| 2000-06-07 | EWJ | ETF | 60.25 | 60.5 | 60.0 | 60.5 | 80725.0 |
| 2000-06-07 | EWK | ETF | 13.375 | 13.6875 | 13.375 | 13.6875 | 4100.0 |
| 2000-06-07 | EWL | ETF | 16.1875 | 16.3125 | 16.0 | 16.3125 | 16300.0 |
| 2000-06-07 | EWM | ETF | 26.0 | 26.75 | 25.75 | 26.25 | 141600.0 |
| 2000-06-07 | EWN | ETF | 24.8125 | 25.0 | 24.5625 | 25.0 | 9100.0 |
| 2000-06-07 | EWO | ETF | 8.3125 | 8.3125 | 8.0625 | 8.3125 | 26500.0 |
| 2000-06-07 | EWP | ETF | 26.5 | 26.5625 | 26.3125 | 26.5 | 7100.0 |
| 2000-06-07 | EWQ | ETF | 29.0625 | 29.3125 | 28.8125 | 28.9375 | 49200.0 |
| 2000-06-07 | EWS | ETF | 15.0 | 15.25 | 14.75 | 15.0 | 23600.0 |
| 2000-06-07 | EWU | ETF | 39.625 | 39.625 | 38.875 | 39.125 | 42350.0 |
| 2000-06-07 | EWW | ETF | 15.5625 | 15.625 | 15.125 | 15.375 | 61600.0 |
| 2000-06-07 | EWY | ETF | 21.5 | 21.5 | 20.5 | 21.25 | 44100.0 |
| 2000-06-07 | FCTR | ETF | 16.0625 | 16.25 | 16.0625 | 16.25 | 30400.0 |
| 2000-06-07 | FMAR | ETF | 6.12 | 6.62 | 6.12 | 6.62 | 6800.0 |
| 2000-06-07 | GLDB | ETF | 6.125 | 6.125 | 6.0625 | 6.0625 | 18400.0 |
| 2000-06-07 | GSIG | ETF | 23.0 | 23.0 | 21.81 | 22.81 | 387400.0 |
| 2000-06-07 | IGLD | ETF | 1000.0 | 1000.0 | 950.0 | 956.25 | 629.0 |
| 2000-06-07 | IJH | ETF | 9.8031 | 9.8953 | 9.8031 | 9.8766 | 15000.0 |
| 2000-06-07 | IJR | ETF | 17.4323 | 17.4323 | 17.349 | 17.349 | 88200.0 |
| 2000-06-07 | IVE | ETF | 61.7031 | 62.0781 | 61.7031 | 62.0 | 4800.0 |
| 2000-06-07 | IVV | ETF | 146.2188 | 147.5 | 145.6562 | 147.1875 | 85400.0 |
| 2000-06-07 | IVW | ETF | 21.836 | 22.0703 | 21.7305 | 22.0547 | 40400.0 |
| 2000-06-07 | IWB | ETF | 77.5 | 78.2812 | 77.5 | 78.0938 | 2700.0 |
| 2000-06-07 | IWD | ETF | 57.6719 | 57.8438 | 57.6719 | 57.7188 | 20400.0 |
| 2000-06-07 | IWF | ETF | 21.10155 | 21.3203 | 21.10155 | 21.3203 | 4800.0 |
| 2000-06-07 | IYF | ETF | 37.875 | 38.5 | 37.8438 | 38.4531 | 3600.0 |
| 2000-06-07 | IYW | ETF | 30.5547 | 31.4922 | 30.5 | 31.4922 | 11200.0 |
| 2000-06-07 | IYZ | ETF | 62.25 | 62.2812 | 62.125 | 62.125 | 600.0 |
| 2000-06-07 | KTEC | ETF | 8.5 | 8.5625 | 8.5 | 8.5625 | 11100.0 |
| 2000-06-07 | MDY | ETF | 91.0 | 91.3438 | 89.875 | 91.3438 | 729600.0 |
| 2000-06-07 | MIG | ETF | 5.4375 | 5.4375 | 5.4375 | 5.4375 | 2000.0 |
| 2000-06-07 | PPH | ETF | 46.625 | 47.375 | 46.5312 | 46.5625 | 75000.0 |
| 2000-06-07 | SFY | ETF | 23.5 | 24.4375 | 23.125 | 24.375 | 124200.0 |
| 2000-06-07 | SMH | ETF | 47.875 | 48.5 | 46.5938 | 48.0938 | 431000.0 |
> showing 50 of 61 rows — these rows as CSV