PREVIEW / etf_daily / 2000-04-10
file: by_date/etf_daily/2000/2000-04-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-04-10 | SPY | ETF | 151.75 | 153.1094 | 150.3125 | 150.8438 | 9624200.0 |
| 2000-04-10 | QQQ | ETF | 107.625 | 107.6875 | 99.25 | 100.125 | 26988200.0 |
| 2000-04-10 | DIA | ETF | 111.2188 | 112.9844 | 110.9062 | 112.0625 | 1833500.0 |
| 2000-04-10 | BBH | ETF | 58.0 | 58.6667 | 55.3333 | 55.3333 | 1612200.0 |
| 2000-04-10 | BITS | ETF | 40.0 | 40.0 | 35.5 | 36.5 | 45225.0 |
| 2000-04-10 | BOSS | ETF | 13.8 | 13.8 | 13.8 | 13.8 | 100.0 |
| 2000-04-10 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.4375 | 77400.0 |
| 2000-04-10 | CHB | ETF | 6.31 | 6.5 | 6.31 | 6.31 | 97800.0 |
| 2000-04-10 | CNXT | ETF | 78.94 | 79.0 | 69.25 | 71.5 | 4650800.0 |
| 2000-04-10 | EWA | ETF | 10.375 | 10.4375 | 10.1875 | 10.1875 | 5000.0 |
| 2000-04-10 | EWC | ETF | 18.25 | 18.25 | 18.1875 | 18.25 | 7100.0 |
| 2000-04-10 | EWD | ETF | 34.625 | 34.8125 | 34.625 | 34.625 | 4800.0 |
| 2000-04-10 | EWG | ETF | 26.875 | 27.125 | 26.75 | 26.75 | 36600.0 |
| 2000-04-10 | EWH | ETF | 13.4375 | 13.4375 | 13.25 | 13.3125 | 55100.0 |
| 2000-04-10 | EWI | ETF | 49.75 | 49.75 | 49.5 | 49.5 | 12350.0 |
| 2000-04-10 | EWJ | ETF | 63.75 | 63.75 | 63.0 | 63.5 | 86425.0 |
| 2000-04-10 | EWK | ETF | 13.125 | 13.125 | 13.125 | 13.125 | 3200.0 |
| 2000-04-10 | EWL | ETF | 15.625 | 15.6875 | 15.625 | 15.6875 | 75300.0 |
| 2000-04-10 | EWM | ETF | 27.5 | 27.75 | 27.25 | 27.75 | 16625.0 |
| 2000-04-10 | EWN | ETF | 24.3125 | 24.375 | 24.25 | 24.375 | 1900.0 |
| 2000-04-10 | EWO | ETF | 7.875 | 7.9375 | 7.875 | 7.9375 | 12000.0 |
| 2000-04-10 | EWP | ETF | 28.375 | 28.5 | 28.3125 | 28.5 | 1600.0 |
| 2000-04-10 | EWQ | ETF | 28.4375 | 28.5 | 28.0 | 28.0 | 34400.0 |
| 2000-04-10 | EWS | ETF | 14.75 | 14.875 | 14.5 | 14.5 | 21700.0 |
| 2000-04-10 | EWU | ETF | 41.25 | 41.25 | 40.625 | 41.0 | 10700.0 |
| 2000-04-10 | EWW | ETF | 18.75 | 19.0625 | 18.75 | 18.8125 | 19400.0 |
| 2000-04-10 | FCTR | ETF | 13.625 | 13.75 | 13.0 | 13.3125 | 39300.0 |
| 2000-04-10 | FMAR | ETF | 6.5 | 6.5 | 5.5 | 6.25 | 6200.0 |
| 2000-04-10 | GLDB | ETF | 6.4063 | 6.5 | 6.375 | 6.4375 | 52200.0 |
| 2000-04-10 | GSIG | ETF | 19.5 | 21.75 | 17.87 | 18.37 | 1633800.0 |
| 2000-04-10 | IGLD | ETF | 1900.0 | 1900.0 | 1700.0 | 1700.0 | 590.0 |
| 2000-04-10 | KTEC | ETF | 9.0 | 9.75 | 9.0 | 9.75 | 1200.0 |
| 2000-04-10 | MDY | ETF | 90.25 | 90.25 | 86.875 | 86.875 | 418200.0 |
| 2000-04-10 | MIG | ETF | 5.6875 | 5.6875 | 5.6875 | 5.6875 | 3000.0 |
| 2000-04-10 | PPH | ETF | 44.375 | 46.0938 | 44.375 | 45.5312 | 284000.0 |
| 2000-04-10 | SFY | ETF | 17.375 | 17.375 | 16.875 | 17.125 | 82900.0 |
| 2000-04-10 | TDSC | ETF | 5.155 | 5.19 | 5.0 | 5.0 | 37800.0 |
| 2000-04-10 | TINY | ETF | 17.44 | 18.12 | 15.25 | 15.44 | 123100.0 |
| 2000-04-10 | XLB | ETF | 11.5938 | 11.875 | 11.4766 | 11.7188 | 85200.0 |
| 2000-04-10 | XLE | ETF | 14.3438 | 14.3984 | 14.164 | 14.2188 | 54000.0 |
| 2000-04-10 | XLF | ETF | 19.5471 | 20.1437 | 19.3567 | 20.0548 | 179111.0 |
| 2000-04-10 | XLI | ETF | 29.625 | 29.75 | 29.4219 | 29.625 | 21100.0 |
| 2000-04-10 | XLK | ETF | 30.2812 | 30.375 | 29.1875 | 29.1875 | 1330200.0 |
| 2000-04-10 | XLP | ETF | 22.0312 | 22.4531 | 21.875 | 22.3594 | 55200.0 |
| 2000-04-10 | XLU | ETF | 13.7734 | 14.0 | 13.75 | 13.836 | 53200.0 |
| 2000-04-10 | XLV | ETF | 30.8125 | 30.8594 | 30.5625 | 30.5625 | 16000.0 |
| 2000-04-10 | XLY | ETF | 15.1719 | 15.4297 | 15.125 | 15.414 | 31600.0 |
> showing 47 of 47 rows — these rows as CSV