PREVIEW / etf_daily / 2000-05-04
file: by_date/etf_daily/2000/2000-05-04.parquet size: 6 KB rows: 46
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-05-04 | SPY | ETF | 142.0 | 142.3594 | 140.75 | 141.8125 | 5963600.0 |
| 2000-05-04 | QQQ | ETF | 89.0 | 90.75 | 87.625 | 89.3125 | 17750700.0 |
| 2000-05-04 | DIA | ETF | 105.2812 | 105.2812 | 103.7812 | 104.3125 | 1154900.0 |
| 2000-05-04 | BBH | ETF | 45.4167 | 47.0833 | 44.6667 | 46.3333 | 1611900.0 |
| 2000-05-04 | BITS | ETF | 26.5 | 27.0 | 21.75 | 23.0 | 62475.0 |
| 2000-05-04 | BOSS | ETF | 14.7 | 15.5 | 14.7 | 15.5 | 400.0 |
| 2000-05-04 | CEF | ETF | 3.5625 | 3.5625 | 3.5 | 3.5 | 6200.0 |
| 2000-05-04 | CHB | ETF | 5.94 | 6.25 | 5.88 | 6.25 | 44400.0 |
| 2000-05-04 | CNXT | ETF | 52.31 | 53.0 | 49.0 | 50.06 | 3063570.0 |
| 2000-05-04 | EWA | ETF | 9.5625 | 9.6875 | 9.5 | 9.5 | 270900.0 |
| 2000-05-04 | EWC | ETF | 17.5625 | 17.75 | 17.5625 | 17.75 | 2300.0 |
| 2000-05-04 | EWD | ETF | 33.0 | 33.0 | 33.0 | 33.0 | 200.0 |
| 2000-05-04 | EWG | ETF | 24.3125 | 24.3125 | 24.0 | 24.1875 | 68200.0 |
| 2000-05-04 | EWH | ETF | 12.1875 | 12.3125 | 12.125 | 12.25 | 12300.0 |
| 2000-05-04 | EWI | ETF | 46.375 | 46.875 | 46.375 | 46.875 | 600.0 |
| 2000-05-04 | EWJ | ETF | 61.0 | 61.75 | 61.0 | 61.5 | 55350.0 |
| 2000-05-04 | EWK | ETF | 12.1875 | 12.1875 | 12.125 | 12.125 | 21100.0 |
| 2000-05-04 | EWL | ETF | 14.6875 | 14.9375 | 14.6875 | 14.9375 | 3300.0 |
| 2000-05-04 | EWM | ETF | 25.25 | 25.25 | 25.25 | 25.25 | 10575.0 |
| 2000-05-04 | EWN | ETF | 22.6875 | 22.6875 | 22.375 | 22.5 | 2000.0 |
| 2000-05-04 | EWP | ETF | 26.0625 | 26.25 | 26.0625 | 26.0625 | 13200.0 |
| 2000-05-04 | EWQ | ETF | 26.5 | 26.75 | 26.5 | 26.75 | 52800.0 |
| 2000-05-04 | EWS | ETF | 14.625 | 14.75 | 14.625 | 14.625 | 21850.0 |
| 2000-05-04 | EWU | ETF | 37.625 | 38.0 | 37.5 | 37.75 | 25850.0 |
| 2000-05-04 | EWW | ETF | 16.0 | 16.0625 | 15.6875 | 15.9375 | 10100.0 |
| 2000-05-04 | FCTR | ETF | 15.875 | 16.25 | 15.6875 | 16.125 | 99700.0 |
| 2000-05-04 | FMAR | ETF | 6.03 | 6.75 | 6.03 | 6.5 | 10600.0 |
| 2000-05-04 | GLDB | ETF | 6.4375 | 6.4375 | 6.125 | 6.4063 | 48700.0 |
| 2000-05-04 | GSIG | ETF | 19.37 | 19.37 | 17.31 | 18.75 | 449100.0 |
| 2000-05-04 | IGLD | ETF | 1150.0 | 1150.0 | 1100.0 | 1118.75 | 215.0 |
| 2000-05-04 | KTEC | ETF | 7.3125 | 7.5 | 7.125 | 7.375 | 10500.0 |
| 2000-05-04 | MDY | ETF | 86.25 | 88.2188 | 85.9375 | 88.0625 | 2003000.0 |
| 2000-05-04 | MIG | ETF | 5.1875 | 5.1875 | 5.1875 | 5.1875 | 10400.0 |
| 2000-05-04 | PPH | ETF | 46.75 | 47.125 | 46.5 | 47.0 | 93800.0 |
| 2000-05-04 | SFY | ETF | 21.125 | 22.75 | 20.9375 | 22.6875 | 241700.0 |
| 2000-05-04 | TDSC | ETF | 4.875 | 5.0 | 4.75 | 4.97 | 32000.0 |
| 2000-05-04 | TINY | ETF | 9.75 | 10.06 | 9.75 | 9.88 | 41400.0 |
| 2000-05-04 | XLB | ETF | 11.3281 | 11.4922 | 11.2266 | 11.3984 | 200600.0 |
| 2000-05-04 | XLE | ETF | 14.5938 | 14.8984 | 14.5938 | 14.875 | 88000.0 |
| 2000-05-04 | XLF | ETF | 18.7855 | 18.8363 | 18.5063 | 18.6332 | 180834.0 |
| 2000-05-04 | XLI | ETF | 28.8594 | 29.2812 | 28.8281 | 29.0469 | 29200.0 |
| 2000-05-04 | XLK | ETF | 26.1406 | 26.5 | 25.8438 | 26.0 | 357200.0 |
| 2000-05-04 | XLP | ETF | 22.75 | 22.9375 | 22.5156 | 22.6875 | 30600.0 |
| 2000-05-04 | XLU | ETF | 13.5938 | 13.8047 | 13.539 | 13.75 | 56000.0 |
| 2000-05-04 | XLV | ETF | 28.875 | 29.0625 | 28.7656 | 28.875 | 18600.0 |
| 2000-05-04 | XLY | ETF | 13.9062 | 13.9062 | 13.6719 | 13.7422 | 45600.0 |
> showing 46 of 46 rows — these rows as CSV