PREVIEW / etf_daily / 2000-05-12
file: by_date/etf_daily/2000/2000-05-12.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-12 | SPY | ETF | 141.8125 | 143.4688 | 141.625 | 142.8125 | 5960800.0 |
| 2000-05-12 | QQQ | ETF | 85.375 | 87.5625 | 84.0 | 84.625 | 17832000.0 |
| 2000-05-12 | DIA | ETF | 106.0 | 106.7812 | 105.75 | 106.25 | 999400.0 |
| 2000-05-12 | BBH | ETF | 46.7917 | 47.6667 | 46.3542 | 47.1458 | 846600.0 |
| 2000-05-12 | BITS | ETF | 20.25 | 21.5 | 20.0 | 20.25 | 45700.0 |
| 2000-05-12 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.5 | 5100.0 |
| 2000-05-12 | CHB | ETF | 6.5 | 6.63 | 6.19 | 6.38 | 116400.0 |
| 2000-05-12 | CNXT | ETF | 41.94 | 45.88 | 41.0 | 43.94 | 7136530.0 |
| 2000-05-12 | EWA | ETF | 9.375 | 9.625 | 9.375 | 9.5 | 5000.0 |
| 2000-05-12 | EWC | ETF | 17.625 | 17.625 | 17.625 | 17.625 | 600.0 |
| 2000-05-12 | EWD | ETF | 32.0 | 32.375 | 32.0 | 32.375 | 1600.0 |
| 2000-05-12 | EWG | ETF | 24.375 | 24.625 | 24.1875 | 24.5 | 82200.0 |
| 2000-05-12 | EWH | ETF | 12.1875 | 12.25 | 12.0625 | 12.125 | 84700.0 |
| 2000-05-12 | EWI | ETF | 47.25 | 48.0 | 47.125 | 47.625 | 7600.0 |
| 2000-05-12 | EWJ | ETF | 59.5 | 60.5 | 59.25 | 60.0 | 76100.0 |
| 2000-05-12 | EWK | ETF | 12.5625 | 12.6875 | 12.5625 | 12.6875 | 2300.0 |
| 2000-05-12 | EWL | ETF | 15.375 | 15.625 | 15.25 | 15.625 | 92700.0 |
| 2000-05-12 | EWM | ETF | 27.5 | 27.5 | 27.0 | 27.0 | 6950.0 |
| 2000-05-12 | EWN | ETF | 23.25 | 23.875 | 23.25 | 23.875 | 3100.0 |
| 2000-05-12 | EWO | ETF | 7.5 | 7.5 | 7.5 | 7.5 | 2100.0 |
| 2000-05-12 | EWP | ETF | 25.875 | 26.125 | 25.625 | 26.125 | 4900.0 |
| 2000-05-12 | EWQ | ETF | 27.0625 | 27.5 | 27.0625 | 27.5 | 109600.0 |
| 2000-05-12 | EWS | ETF | 14.375 | 14.625 | 14.25 | 14.375 | 127650.0 |
| 2000-05-12 | EWU | ETF | 37.625 | 38.375 | 37.625 | 38.0 | 32300.0 |
| 2000-05-12 | EWW | ETF | 15.4375 | 15.5 | 15.4375 | 15.4375 | 5100.0 |
| 2000-05-12 | EWY | ETF | 19.62 | 19.69 | 19.62 | 19.69 | 4800.0 |
| 2000-05-12 | FCTR | ETF | 15.5625 | 16.9375 | 15.5625 | 16.4375 | 31600.0 |
| 2000-05-12 | FMAR | ETF | 6.03 | 6.69 | 6.03 | 6.69 | 700.0 |
| 2000-05-12 | GLDB | ETF | 5.875 | 6.1875 | 5.6875 | 6.1875 | 46300.0 |
| 2000-05-12 | GSIG | ETF | 20.5 | 21.0 | 20.19 | 20.56 | 835300.0 |
| 2000-05-12 | IGLD | ETF | 1050.0 | 1093.75 | 1050.0 | 1093.75 | 191.0 |
| 2000-05-12 | KTEC | ETF | 7.0625 | 7.1875 | 7.0 | 7.125 | 5200.0 |
| 2000-05-12 | MDY | ETF | 88.0625 | 89.0 | 87.5625 | 87.5625 | 508900.0 |
| 2000-05-12 | MIG | ETF | 5.625 | 5.625 | 5.625 | 5.625 | 500.0 |
| 2000-05-12 | PPH | ETF | 47.1562 | 48.0312 | 46.8125 | 47.875 | 221400.0 |
| 2000-05-12 | SFY | ETF | 21.375 | 23.125 | 21.375 | 23.0 | 247300.0 |
| 2000-05-12 | TDSC | ETF | 4.53 | 4.75 | 4.53 | 4.75 | 24000.0 |
| 2000-05-12 | TINY | ETF | 8.16 | 8.25 | 8.0 | 8.19 | 61000.0 |
| 2000-05-12 | XLB | ETF | 11.6172 | 11.6172 | 11.4688 | 11.5781 | 28000.0 |
| 2000-05-12 | XLE | ETF | 15.6875 | 15.8125 | 15.664 | 15.8047 | 90200.0 |
| 2000-05-12 | XLF | ETF | 19.0902 | 19.5725 | 19.0394 | 19.344 | 611192.0 |
| 2000-05-12 | XLI | ETF | 29.875 | 30.0938 | 29.875 | 30.0938 | 4100.0 |
| 2000-05-12 | XLK | ETF | 25.25 | 25.7031 | 25.0625 | 25.0625 | 443000.0 |
| 2000-05-12 | XLP | ETF | 23.5781 | 23.5781 | 23.1562 | 23.3125 | 26400.0 |
| 2000-05-12 | XLU | ETF | 14.2734 | 14.2734 | 14.0312 | 14.0781 | 24000.0 |
| 2000-05-12 | XLV | ETF | 28.875 | 29.2188 | 28.8438 | 29.125 | 5100.0 |
| 2000-05-12 | XLY | ETF | 14.2969 | 14.3438 | 14.2188 | 14.3438 | 6000.0 |
> showing 47 of 47 rows — these rows as CSV