PREVIEW / etf_daily / 2000-04-25
file: by_date/etf_daily/2000/2000-04-25.parquet size: 7 KB rows: 48
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-04-25 | SPY | ETF | 144.625 | 148.1562 | 144.4375 | 148.1562 | 14102000.0 |
| 2000-04-25 | QQQ | ETF | 86.5 | 90.5 | 86.0 | 90.4688 | 28663200.0 |
| 2000-04-25 | DIA | ETF | 109.7188 | 111.625 | 108.7812 | 111.2812 | 2798800.0 |
| 2000-04-25 | BBH | ETF | 44.0 | 44.0 | 42.5625 | 43.8333 | 1266900.0 |
| 2000-04-25 | BITS | ETF | 22.5 | 23.0 | 20.25 | 21.0 | 28050.0 |
| 2000-04-25 | BOSS | ETF | 14.5 | 14.5 | 14.5 | 14.5 | 100.0 |
| 2000-04-25 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.4375 | 28500.0 |
| 2000-04-25 | CHB | ETF | 6.56 | 7.06 | 6.44 | 6.94 | 239900.0 |
| 2000-04-25 | CNXT | ETF | 59.63 | 62.13 | 56.25 | 62.0 | 4294680.0 |
| 2000-04-25 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 8000.0 |
| 2000-04-25 | EWA | ETF | 9.75 | 9.75 | 9.6875 | 9.6875 | 7500.0 |
| 2000-04-25 | EWC | ETF | 17.4375 | 17.5625 | 17.25 | 17.5625 | 5500.0 |
| 2000-04-25 | EWD | ETF | 32.3125 | 32.5 | 32.25 | 32.5 | 6100.0 |
| 2000-04-25 | EWG | ETF | 25.0625 | 25.125 | 24.875 | 25.0625 | 53600.0 |
| 2000-04-25 | EWH | ETF | 12.3125 | 12.4375 | 12.25 | 12.375 | 31500.0 |
| 2000-04-25 | EWI | ETF | 46.625 | 47.25 | 46.625 | 47.125 | 2900.0 |
| 2000-04-25 | EWJ | ETF | 62.0 | 62.75 | 61.75 | 62.75 | 64475.0 |
| 2000-04-25 | EWK | ETF | 12.5 | 12.5625 | 12.5 | 12.5625 | 2100.0 |
| 2000-04-25 | EWL | ETF | 15.125 | 15.1875 | 14.875 | 15.1875 | 3600.0 |
| 2000-04-25 | EWM | ETF | 24.75 | 24.75 | 24.25 | 24.5 | 36375.0 |
| 2000-04-25 | EWN | ETF | 23.4375 | 23.5 | 23.0625 | 23.4375 | 6200.0 |
| 2000-04-25 | EWO | ETF | 7.5 | 7.75 | 7.5 | 7.75 | 2200.0 |
| 2000-04-25 | EWP | ETF | 27.25 | 27.25 | 26.9375 | 27.125 | 7700.0 |
| 2000-04-25 | EWQ | ETF | 26.8125 | 27.0 | 26.8125 | 26.9375 | 7000.0 |
| 2000-04-25 | EWS | ETF | 14.625 | 14.875 | 14.5 | 14.875 | 49500.0 |
| 2000-04-25 | EWU | ETF | 39.375 | 40.0 | 39.25 | 40.0 | 6700.0 |
| 2000-04-25 | EWW | ETF | 16.3125 | 16.625 | 16.3125 | 16.625 | 3800.0 |
| 2000-04-25 | FCTR | ETF | 13.1875 | 13.5 | 13.0 | 13.5 | 20300.0 |
| 2000-04-25 | FMAR | ETF | 5.5 | 5.62 | 5.38 | 5.38 | 28700.0 |
| 2000-04-25 | GLDB | ETF | 6.7188 | 6.8125 | 6.125 | 6.25 | 37300.0 |
| 2000-04-25 | GSIG | ETF | 16.47 | 17.06 | 16.25 | 16.81 | 229500.0 |
| 2000-04-25 | IGLD | ETF | 1100.0 | 1200.0 | 1100.0 | 1125.0 | 323.0 |
| 2000-04-25 | KTEC | ETF | 9.375 | 9.5 | 8.625 | 9.5 | 57400.0 |
| 2000-04-25 | MDY | ETF | 84.8125 | 87.1562 | 84.75 | 87.1562 | 642900.0 |
| 2000-04-25 | MIG | ETF | 5.125 | 5.125 | 5.0625 | 5.0625 | 2500.0 |
| 2000-04-25 | PPH | ETF | 47.0625 | 48.3125 | 47.0625 | 48.3125 | 489600.0 |
| 2000-04-25 | SFY | ETF | 19.5625 | 20.625 | 19.5625 | 20.125 | 131600.0 |
| 2000-04-25 | TDSC | ETF | 5.56 | 5.56 | 5.19 | 5.47 | 95000.0 |
| 2000-04-25 | TINY | ETF | 9.34 | 10.69 | 9.34 | 10.38 | 85800.0 |
| 2000-04-25 | XLB | ETF | 11.3516 | 11.4062 | 11.1406 | 11.289 | 463800.0 |
| 2000-04-25 | XLE | ETF | 14.461 | 14.6484 | 14.461 | 14.4844 | 861600.0 |
| 2000-04-25 | XLF | ETF | 19.6994 | 20.3849 | 19.6994 | 20.3087 | 252724.0 |
| 2000-04-25 | XLI | ETF | 29.3438 | 30.3281 | 29.3125 | 30.25 | 13100.0 |
| 2000-04-25 | XLK | ETF | 26.375 | 27.1094 | 26.1328 | 27.1094 | 715800.0 |
| 2000-04-25 | XLP | ETF | 23.375 | 23.4375 | 23.0 | 23.2656 | 51400.0 |
| 2000-04-25 | XLU | ETF | 14.2969 | 14.6562 | 14.1953 | 14.6094 | 36600.0 |
| 2000-04-25 | XLV | ETF | 29.3125 | 29.9062 | 29.3125 | 29.9062 | 3600.0 |
| 2000-04-25 | XLY | ETF | 14.8594 | 15.0625 | 14.8594 | 15.0312 | 51200.0 |
> showing 48 of 48 rows — these rows as CSV