PREVIEW / etf_daily / 2000-04-14
file: by_date/etf_daily/2000/2000-04-14.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-14 | SPY | ETF | 142.625 | 142.8125 | 133.5 | 136.0 | 29604000.0 |
| 2000-04-14 | QQQ | ETF | 86.0625 | 88.5 | 78.0 | 80.375 | 60851300.0 |
| 2000-04-14 | DIA | ETF | 107.4375 | 108.25 | 101.5156 | 102.5156 | 4518600.0 |
| 2000-04-14 | BBH | ETF | 47.3333 | 49.6667 | 43.0 | 44.0 | 2532900.0 |
| 2000-04-14 | BITS | ETF | 20.0 | 21.875 | 18.0 | 21.5 | 91875.0 |
| 2000-04-14 | CEF | ETF | 3.4375 | 3.5625 | 3.4375 | 3.5 | 36300.0 |
| 2000-04-14 | CHB | ETF | 6.5 | 6.63 | 6.13 | 6.19 | 146100.0 |
| 2000-04-14 | CNXT | ETF | 51.0 | 53.63 | 42.63 | 46.11 | 8573840.0 |
| 2000-04-14 | EWA | ETF | 9.8125 | 9.8125 | 9.4375 | 9.6875 | 13900.0 |
| 2000-04-14 | EWC | ETF | 17.5625 | 17.625 | 16.9375 | 17.0 | 16600.0 |
| 2000-04-14 | EWD | ETF | 31.1875 | 31.1875 | 30.125 | 30.125 | 15900.0 |
| 2000-04-14 | EWG | ETF | 25.5625 | 25.8125 | 25.0625 | 25.0625 | 86600.0 |
| 2000-04-14 | EWH | ETF | 12.75 | 13.0 | 12.0 | 12.0625 | 163400.0 |
| 2000-04-14 | EWI | ETF | 47.375 | 47.875 | 46.75 | 46.75 | 2100.0 |
| 2000-04-14 | EWJ | ETF | 61.75 | 61.8752 | 60.5 | 60.5 | 150975.0 |
| 2000-04-14 | EWK | ETF | 13.375 | 13.375 | 13.125 | 13.25 | 2100.0 |
| 2000-04-14 | EWL | ETF | 15.75 | 15.875 | 15.25 | 15.25 | 18700.0 |
| 2000-04-14 | EWM | ETF | 26.0 | 26.5 | 24.0 | 24.5 | 42125.0 |
| 2000-04-14 | EWN | ETF | 23.4375 | 23.5 | 22.5 | 22.5 | 25600.0 |
| 2000-04-14 | EWO | ETF | 7.625 | 7.625 | 7.5 | 7.625 | 27700.0 |
| 2000-04-14 | EWP | ETF | 28.0625 | 28.0625 | 27.0 | 27.0 | 10200.0 |
| 2000-04-14 | EWQ | ETF | 26.75 | 27.0 | 26.5 | 26.75 | 39900.0 |
| 2000-04-14 | EWS | ETF | 14.875 | 15.0 | 13.5 | 13.5 | 123950.0 |
| 2000-04-14 | EWU | ETF | 39.25 | 39.25 | 37.625 | 37.625 | 21050.0 |
| 2000-04-14 | EWW | ETF | 16.3125 | 16.5625 | 15.3125 | 15.4375 | 56300.0 |
| 2000-04-14 | FCTR | ETF | 13.125 | 13.5625 | 12.75 | 13.0 | 30400.0 |
| 2000-04-14 | FMAR | ETF | 6.25 | 6.38 | 5.5 | 5.87 | 10700.0 |
| 2000-04-14 | GLDB | ETF | 6.25 | 6.25 | 5.9375 | 6.0625 | 75600.0 |
| 2000-04-14 | GSIG | ETF | 16.5 | 16.5 | 14.0 | 14.37 | 776300.0 |
| 2000-04-14 | IGLD | ETF | 1431.25 | 1475.0 | 1150.0 | 1200.0 | 1531.0 |
| 2000-04-14 | KTEC | ETF | 9.34375 | 9.40625 | 8.5625 | 8.5625 | 41500.0 |
| 2000-04-14 | MDY | ETF | 83.5625 | 83.875 | 78.0 | 79.0 | 1557300.0 |
| 2000-04-14 | MIG | ETF | 5.4375 | 5.4375 | 5.25 | 5.25 | 2900.0 |
| 2000-04-14 | PPH | ETF | 45.3125 | 46.1875 | 44.0312 | 44.75 | 391800.0 |
| 2000-04-14 | SFY | ETF | 19.3125 | 19.3125 | 17.5 | 18.125 | 166300.0 |
| 2000-04-14 | TDSC | ETF | 4.655 | 4.655 | 4.19 | 4.31 | 102200.0 |
| 2000-04-14 | TINY | ETF | 10.0 | 11.38 | 9.0 | 9.12 | 422500.0 |
| 2000-04-14 | XLB | ETF | 11.6875 | 11.8125 | 11.1875 | 11.3125 | 290400.0 |
| 2000-04-14 | XLE | ETF | 14.5625 | 14.6875 | 14.1094 | 14.25 | 3698200.0 |
| 2000-04-14 | XLF | ETF | 18.9379 | 19.2679 | 17.9732 | 18.2525 | 1045242.0 |
| 2000-04-14 | XLI | ETF | 28.2188 | 28.4688 | 27.5938 | 27.5938 | 19600.0 |
| 2000-04-14 | XLK | ETF | 25.375 | 26.0156 | 23.625 | 24.75 | 3816000.0 |
| 2000-04-14 | XLP | ETF | 22.1875 | 22.5625 | 21.5469 | 21.7344 | 62900.0 |
| 2000-04-14 | XLU | ETF | 14.3516 | 14.3672 | 13.6797 | 13.8125 | 276600.0 |
| 2000-04-14 | XLV | ETF | 28.4688 | 28.5938 | 27.7188 | 27.7188 | 9800.0 |
| 2000-04-14 | XLY | ETF | 14.6875 | 14.7188 | 14.0 | 14.0 | 235200.0 |
> showing 46 of 46 rows — these rows as CSV