PREVIEW / etf_daily / 2000-05-10
file: by_date/etf_daily/2000/2000-05-10.parquet size: 6 KB rows: 47
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-10 | SPY | ETF | 140.5 | 140.9688 | 137.75 | 138.125 | 10293900.0 |
| 2000-05-10 | QQQ | ETF | 84.375 | 84.9844 | 79.5 | 79.75 | 34847600.0 |
| 2000-05-10 | DIA | ETF | 104.5312 | 105.0938 | 102.625 | 103.3125 | 1832600.0 |
| 2000-05-10 | BBH | ETF | 46.4167 | 46.4167 | 44.1667 | 44.8333 | 1139700.0 |
| 2000-05-10 | BITS | ETF | 22.0 | 22.0 | 18.5 | 19.5 | 43825.0 |
| 2000-05-10 | CEF | ETF | 3.5 | 3.5 | 3.4375 | 3.4375 | 17000.0 |
| 2000-05-10 | CHB | ETF | 6.5 | 6.5 | 6.13 | 6.13 | 52600.0 |
| 2000-05-10 | CNXT | ETF | 42.38 | 43.69 | 41.0 | 41.88 | 4935490.0 |
| 2000-05-10 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 300.0 |
| 2000-05-10 | EWA | ETF | 9.6875 | 9.6875 | 9.4375 | 9.5 | 46300.0 |
| 2000-05-10 | EWC | ETF | 17.75 | 17.75 | 17.375 | 17.4375 | 15900.0 |
| 2000-05-10 | EWD | ETF | 31.9375 | 31.9375 | 31.5625 | 31.8125 | 2200.0 |
| 2000-05-10 | EWG | ETF | 24.0 | 24.125 | 23.5 | 23.8125 | 60500.0 |
| 2000-05-10 | EWH | ETF | 11.625 | 11.625 | 11.1875 | 11.375 | 60600.0 |
| 2000-05-10 | EWI | ETF | 46.75 | 46.75 | 46.0 | 46.0 | 4350.0 |
| 2000-05-10 | EWJ | ETF | 60.0 | 60.5 | 59.75 | 59.75 | 79275.0 |
| 2000-05-10 | EWK | ETF | 12.5 | 12.5 | 12.1875 | 12.4375 | 25000.0 |
| 2000-05-10 | EWL | ETF | 15.125 | 15.125 | 14.9375 | 15.0625 | 6900.0 |
| 2000-05-10 | EWM | ETF | 26.0 | 26.25 | 26.0 | 26.25 | 16775.0 |
| 2000-05-10 | EWN | ETF | 23.0 | 23.0 | 22.8125 | 22.8125 | 4300.0 |
| 2000-05-10 | EWO | ETF | 7.4375 | 7.4375 | 7.375 | 7.4375 | 17800.0 |
| 2000-05-10 | EWP | ETF | 25.5625 | 25.5625 | 25.125 | 25.25 | 12800.0 |
| 2000-05-10 | EWQ | ETF | 26.375 | 26.5625 | 26.125 | 26.25 | 43800.0 |
| 2000-05-10 | EWS | ETF | 14.25 | 14.625 | 14.125 | 14.25 | 40550.0 |
| 2000-05-10 | EWU | ETF | 37.0 | 37.25 | 36.25 | 36.75 | 13850.0 |
| 2000-05-10 | EWW | ETF | 15.0 | 15.125 | 14.8125 | 14.9375 | 34400.0 |
| 2000-05-10 | FCTR | ETF | 15.6875 | 16.125 | 15.25 | 15.25 | 23300.0 |
| 2000-05-10 | FMAR | ETF | 7.0 | 7.0 | 6.03 | 6.25 | 9600.0 |
| 2000-05-10 | GLDB | ETF | 6.0938 | 6.1875 | 6.0 | 6.0 | 82800.0 |
| 2000-05-10 | GSIG | ETF | 20.06 | 20.12 | 19.31 | 19.62 | 924500.0 |
| 2000-05-10 | IGLD | ETF | 1093.75 | 1093.75 | 1043.75 | 1050.0 | 623.0 |
| 2000-05-10 | KTEC | ETF | 7.25 | 7.28125 | 7.125 | 7.125 | 55700.0 |
| 2000-05-10 | MDY | ETF | 87.375 | 87.375 | 85.0 | 85.375 | 586400.0 |
| 2000-05-10 | MIG | ETF | 5.4375 | 5.4375 | 5.4375 | 5.4375 | 2400.0 |
| 2000-05-10 | PPH | ETF | 48.9375 | 48.9375 | 47.5938 | 48.2812 | 325000.0 |
| 2000-05-10 | SFY | ETF | 21.875 | 22.0625 | 21.0625 | 21.25 | 166200.0 |
| 2000-05-10 | TDSC | ETF | 4.69 | 4.81 | 4.625 | 4.625 | 14800.0 |
| 2000-05-10 | TINY | ETF | 8.59 | 8.81 | 7.75 | 8.31 | 101000.0 |
| 2000-05-10 | XLB | ETF | 11.4062 | 11.5625 | 11.336 | 11.3906 | 92400.0 |
| 2000-05-10 | XLE | ETF | 15.2188 | 15.3594 | 15.1094 | 15.2734 | 707400.0 |
| 2000-05-10 | XLF | ETF | 19.0267 | 19.0394 | 18.5571 | 18.5698 | 348373.0 |
| 2000-05-10 | XLI | ETF | 29.0625 | 29.1094 | 28.75 | 29.0156 | 2100.0 |
| 2000-05-10 | XLK | ETF | 24.8125 | 24.9062 | 23.875 | 24.0625 | 2039600.0 |
| 2000-05-10 | XLP | ETF | 23.6562 | 23.7188 | 23.3125 | 23.6562 | 87000.0 |
| 2000-05-10 | XLU | ETF | 13.8906 | 14.1797 | 13.8594 | 14.0938 | 76400.0 |
| 2000-05-10 | XLV | ETF | 28.9375 | 29.0938 | 28.4688 | 28.6562 | 9100.0 |
| 2000-05-10 | XLY | ETF | 13.9531 | 14.0469 | 13.8906 | 14.0156 | 126000.0 |
> showing 47 of 47 rows — these rows as CSV