PREVIEW / etf_daily / 2000-11-07
file: by_date/etf_daily/2000/2000-11-07.parquet size: 8 KB rows: 88
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-07 | SPY | ETF | 143.1406 | 144.0 | 142.5625 | 143.75 | 5231300.0 |
| 2000-11-07 | QQQ | ETF | 81.4375 | 82.4688 | 80.25 | 82.125 | 24339600.0 |
| 2000-11-07 | IWM | ETF | 50.2969 | 50.6875 | 50.0625 | 50.6875 | 79400.0 |
| 2000-11-07 | DIA | ETF | 109.875 | 110.0625 | 109.3438 | 109.75 | 1136900.0 |
| 2000-11-07 | BBH | ETF | 62.5833 | 63.2917 | 62.0833 | 63.2917 | 1121400.0 |
| 2000-11-07 | BITS | ETF | 14.0 | 14.5 | 11.0 | 13.75 | 17625.0 |
| 2000-11-07 | CEF | ETF | 3.0 | 3.0 | 2.9375 | 3.0 | 21700.0 |
| 2000-11-07 | CHB | ETF | 3.13 | 3.19 | 3.06 | 3.19 | 42800.0 |
| 2000-11-07 | CNXT | ETF | 28.53 | 28.78 | 27.28 | 28.41 | 3923870.0 |
| 2000-11-07 | DGT | ETF | 84.8125 | 85.0625 | 84.8125 | 85.0625 | 600.0 |
| 2000-11-07 | EWA | ETF | 9.375 | 9.5 | 9.375 | 9.5 | 6600.0 |
| 2000-11-07 | EWC | ETF | 14.75 | 15.0 | 14.75 | 14.875 | 4400.0 |
| 2000-11-07 | EWD | ETF | 19.875 | 20.125 | 19.875 | 20.0625 | 2300.0 |
| 2000-11-07 | EWG | ETF | 19.625 | 19.8125 | 19.5 | 19.75 | 103800.0 |
| 2000-11-07 | EWH | ETF | 11.625 | 11.8125 | 11.625 | 11.8125 | 20500.0 |
| 2000-11-07 | EWI | ETF | 44.75 | 45.0 | 44.25 | 45.0 | 1450.0 |
| 2000-11-07 | EWJ | ETF | 52.25 | 52.5 | 52.0 | 52.25 | 31275.0 |
| 2000-11-07 | EWK | ETF | 12.875 | 12.875 | 12.8125 | 12.8125 | 1100.0 |
| 2000-11-07 | EWL | ETF | 15.375 | 15.5 | 15.3125 | 15.5 | 2700.0 |
| 2000-11-07 | EWM | ETF | 23.0 | 23.25 | 23.0 | 23.25 | 7150.0 |
| 2000-11-07 | EWN | ETF | 22.625 | 22.75 | 22.625 | 22.75 | 1600.0 |
| 2000-11-07 | EWO | ETF | 7.3125 | 7.3125 | 7.3125 | 7.3125 | 1100.0 |
| 2000-11-07 | EWP | ETF | 23.75 | 24.0 | 23.75 | 24.0 | 2700.0 |
| 2000-11-07 | EWQ | ETF | 24.125 | 24.5 | 24.125 | 24.5 | 4200.0 |
| 2000-11-07 | EWS | ETF | 14.0 | 14.125 | 14.0 | 14.125 | 27300.0 |
| 2000-11-07 | EWT | ETF | 26.875 | 26.875 | 26.75 | 26.75 | 11400.0 |
| 2000-11-07 | EWU | ETF | 35.25 | 36.0 | 35.25 | 36.0 | 9600.0 |
| 2000-11-07 | EWW | ETF | 15.0625 | 15.625 | 15.0625 | 15.625 | 39600.0 |
| 2000-11-07 | EWY | ETF | 14.75 | 14.75 | 14.6875 | 14.75 | 1100.0 |
| 2000-11-07 | EWZ | ETF | 16.0 | 16.0 | 16.0 | 16.0 | 12000.0 |
| 2000-11-07 | EZU | ETF | 36.3125 | 36.3125 | 36.2812 | 36.3125 | 1400.0 |
| 2000-11-07 | FCTR | ETF | 14.875 | 15.0 | 14.6875 | 14.75 | 45000.0 |
| 2000-11-07 | FMAR | ETF | 4.38 | 4.44 | 4.25 | 4.25 | 10290.0 |
| 2000-11-07 | GLDB | ETF | 4.5469 | 4.5625 | 4.4375 | 4.5 | 75000.0 |
| 2000-11-07 | GSIG | ETF | 13.25 | 13.31 | 12.87 | 13.12 | 249700.0 |
| 2000-11-07 | IDU | ETF | 41.3906 | 41.3906 | 41.2031 | 41.25 | 800.0 |
| 2000-11-07 | IEV | ETF | 37.1875 | 37.375 | 37.1875 | 37.375 | 15600.0 |
| 2000-11-07 | IGLD | ETF | 293.75 | 300.0 | 293.75 | 293.75 | 288.0 |
| 2000-11-07 | IJH | ETF | 10.5844 | 10.5891 | 10.5078 | 10.5891 | 72000.0 |
| 2000-11-07 | IJJ | ETF | 19.5234 | 19.5469 | 19.5039 | 19.5469 | 8000.0 |
| 2000-11-07 | IJK | ETF | 17.582 | 17.6836 | 17.5449 | 17.6836 | 114400.0 |
| 2000-11-07 | IJR | ETF | 18.2031 | 18.3464 | 18.1667 | 18.3464 | 482400.0 |
| 2000-11-07 | IJS | ETF | 18.1875 | 18.2227 | 18.168 | 18.1992 | 145200.0 |
| 2000-11-07 | IJT | ETF | 21.125 | 21.125 | 21.0039 | 21.1133 | 53600.0 |
| 2000-11-07 | IUSG | ETF | 31.5156 | 31.5156 | 31.5156 | 31.5156 | 400.0 |
| 2000-11-07 | IUSV | ETF | 25.0313 | 25.0573 | 24.9063 | 25.0 | 18600.0 |
| 2000-11-07 | IVE | ETF | 64.0625 | 64.0625 | 63.7656 | 64.0312 | 29700.0 |
| 2000-11-07 | IVV | ETF | 143.3438 | 143.9375 | 142.8125 | 143.8438 | 36700.0 |
| 2000-11-07 | IVW | ETF | 20.2344 | 20.3672 | 20.0703 | 20.3281 | 237600.0 |
| 2000-11-07 | IWB | ETF | 76.54 | 76.98 | 76.48 | 76.48 | 25600.0 |
> showing 50 of 88 rows — these rows as CSV