PREVIEW / etf_daily / 2000-04-20
file: by_date/etf_daily/2000/2000-04-20.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-04-20 | SPY | ETF | 143.5625 | 143.9375 | 142.375 | 143.8125 | 8537600.0 |
| 2000-04-20 | QQQ | ETF | 90.375 | 90.9688 | 86.0625 | 87.25 | 21255600.0 |
| 2000-04-20 | DIA | ETF | 107.0625 | 108.7812 | 106.8438 | 108.7812 | 1886300.0 |
| 2000-04-20 | BBH | ETF | 46.8542 | 47.5 | 43.6875 | 44.3333 | 1259700.0 |
| 2000-04-20 | BITS | ETF | 26.0 | 26.0 | 21.5 | 23.0 | 34625.0 |
| 2000-04-20 | CEF | ETF | 3.375 | 3.5 | 3.375 | 3.4375 | 37300.0 |
| 2000-04-20 | CHB | ETF | 6.06 | 6.06 | 5.81 | 5.94 | 91500.0 |
| 2000-04-20 | CNXT | ETF | 61.25 | 63.75 | 57.0 | 61.69 | 7998020.0 |
| 2000-04-20 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 1000.0 |
| 2000-04-20 | EWA | ETF | 9.6875 | 9.875 | 9.6875 | 9.8125 | 10700.0 |
| 2000-04-20 | EWD | ETF | 32.25 | 32.5 | 32.1875 | 32.5 | 1000.0 |
| 2000-04-20 | EWG | ETF | 24.9375 | 25.0 | 24.625 | 24.875 | 13300.0 |
| 2000-04-20 | EWH | ETF | 12.375 | 12.5 | 12.1875 | 12.25 | 45800.0 |
| 2000-04-20 | EWI | ETF | 47.0 | 47.25 | 46.25 | 46.875 | 12600.0 |
| 2000-04-20 | EWJ | ETF | 60.75 | 61.5 | 60.75 | 61.25 | 129200.0 |
| 2000-04-20 | EWK | ETF | 12.5625 | 12.8125 | 12.5625 | 12.75 | 4400.0 |
| 2000-04-20 | EWL | ETF | 15.1875 | 15.1875 | 14.9375 | 14.9375 | 15500.0 |
| 2000-04-20 | EWM | ETF | 24.5 | 24.75 | 24.5 | 24.75 | 5925.0 |
| 2000-04-20 | EWN | ETF | 23.125 | 23.5 | 23.125 | 23.1875 | 2300.0 |
| 2000-04-20 | EWO | ETF | 7.75 | 7.75 | 7.75 | 7.75 | 1000.0 |
| 2000-04-20 | EWP | ETF | 27.5625 | 27.5625 | 27.25 | 27.5 | 1600.0 |
| 2000-04-20 | EWQ | ETF | 26.9375 | 27.125 | 26.8125 | 26.9375 | 5600.0 |
| 2000-04-20 | EWS | ETF | 14.75 | 14.875 | 14.625 | 14.75 | 29200.0 |
| 2000-04-20 | EWU | ETF | 39.625 | 39.625 | 38.875 | 39.25 | 7850.0 |
| 2000-04-20 | EWW | ETF | 16.0 | 16.0 | 15.8125 | 16.0 | 5100.0 |
| 2000-04-20 | FCTR | ETF | 13.375 | 13.75 | 12.875 | 13.75 | 46300.0 |
| 2000-04-20 | FMAR | ETF | 5.87 | 6.0 | 5.5 | 5.69 | 10900.0 |
| 2000-04-20 | GLDB | ETF | 6.25 | 6.75 | 6.1875 | 6.75 | 71100.0 |
| 2000-04-20 | GSIG | ETF | 16.94 | 17.31 | 16.75 | 16.94 | 304400.0 |
| 2000-04-20 | IGLD | ETF | 1200.0 | 1250.0 | 1100.0 | 1106.25 | 699.0 |
| 2000-04-20 | KTEC | ETF | 9.0 | 9.125 | 8.75 | 9.125 | 2400.0 |
| 2000-04-20 | MDY | ETF | 84.875 | 85.5 | 83.625 | 84.8125 | 337500.0 |
| 2000-04-20 | MIG | ETF | 5.25 | 5.25 | 5.25 | 5.25 | 2300.0 |
| 2000-04-20 | PPH | ETF | 46.875 | 47.3125 | 46.5312 | 46.9688 | 209400.0 |
| 2000-04-20 | SFY | ETF | 19.0625 | 20.0 | 18.8125 | 19.9375 | 104100.0 |
| 2000-04-20 | TDSC | ETF | 4.905 | 5.0 | 4.845 | 4.97 | 57800.0 |
| 2000-04-20 | TINY | ETF | 11.25 | 11.25 | 8.88 | 10.25 | 111300.0 |
| 2000-04-20 | XLB | ETF | 11.0469 | 11.2578 | 11.0469 | 11.25 | 278000.0 |
| 2000-04-20 | XLE | ETF | 14.2812 | 14.3828 | 14.1562 | 14.3047 | 471200.0 |
| 2000-04-20 | XLF | ETF | 18.8998 | 19.2425 | 18.7855 | 19.2425 | 175048.0 |
| 2000-04-20 | XLI | ETF | 28.6562 | 28.7188 | 28.5 | 28.7188 | 2900.0 |
| 2000-04-20 | XLK | ETF | 26.75 | 26.9375 | 26.125 | 26.4375 | 482800.0 |
| 2000-04-20 | XLP | ETF | 22.7031 | 22.9219 | 22.5938 | 22.75 | 14300.0 |
| 2000-04-20 | XLU | ETF | 13.8672 | 13.875 | 13.8125 | 13.8125 | 16000.0 |
| 2000-04-20 | XLV | ETF | 29.4688 | 29.5938 | 29.25 | 29.5938 | 4000.0 |
| 2000-04-20 | XLY | ETF | 14.4062 | 14.6094 | 14.4062 | 14.6094 | 28600.0 |
> showing 46 of 46 rows — these rows as CSV