PREVIEW / etf_daily / 2000-04-11
file: by_date/etf_daily/2000/2000-04-11.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-11 | SPY | ETF | 150.0 | 151.625 | 148.375 | 150.4062 | 9006400.0 |
| 2000-04-11 | QQQ | ETF | 97.125 | 101.5 | 95.75 | 97.75 | 34497200.0 |
| 2000-04-11 | DIA | ETF | 112.25 | 113.7344 | 110.8438 | 113.25 | 3624800.0 |
| 2000-04-11 | BBH | ETF | 52.3333 | 53.3333 | 50.9167 | 52.375 | 2545500.0 |
| 2000-04-11 | BITS | ETF | 36.5 | 37.0 | 30.0 | 30.75 | 87200.0 |
| 2000-04-11 | CEF | ETF | 3.5 | 3.5625 | 3.4375 | 3.5625 | 46400.0 |
| 2000-04-11 | CHB | ETF | 6.38 | 6.38 | 6.19 | 6.25 | 259800.0 |
| 2000-04-11 | CNXT | ETF | 68.62 | 76.01 | 66.56 | 71.25 | 4738730.0 |
| 2000-04-11 | CSB | ETF | 4.0 | 4.0 | 4.0 | 4.0 | 2000.0 |
| 2000-04-11 | EWA | ETF | 10.0 | 10.1875 | 10.0 | 10.1875 | 10900.0 |
| 2000-04-11 | EWC | ETF | 18.125 | 18.125 | 18.0 | 18.0625 | 12200.0 |
| 2000-04-11 | EWD | ETF | 33.3125 | 33.5625 | 33.1875 | 33.25 | 6300.0 |
| 2000-04-11 | EWG | ETF | 26.25 | 26.75 | 26.1875 | 26.4375 | 77900.0 |
| 2000-04-11 | EWH | ETF | 13.25 | 13.25 | 12.9375 | 12.9375 | 63700.0 |
| 2000-04-11 | EWI | ETF | 49.25 | 49.25 | 48.5 | 48.5 | 14750.0 |
| 2000-04-11 | EWJ | ETF | 63.25 | 63.25 | 62.5 | 63.0 | 57675.0 |
| 2000-04-11 | EWK | ETF | 13.1875 | 13.375 | 13.1875 | 13.25 | 13500.0 |
| 2000-04-11 | EWL | ETF | 15.5 | 15.75 | 15.5 | 15.5 | 13500.0 |
| 2000-04-11 | EWM | ETF | 27.5 | 28.0 | 27.0 | 28.0 | 44325.0 |
| 2000-04-11 | EWN | ETF | 24.125 | 24.125 | 23.8125 | 24.0625 | 10100.0 |
| 2000-04-11 | EWO | ETF | 7.8125 | 7.875 | 7.75 | 7.875 | 18100.0 |
| 2000-04-11 | EWP | ETF | 28.0625 | 28.3125 | 27.875 | 27.875 | 5100.0 |
| 2000-04-11 | EWQ | ETF | 27.8125 | 27.875 | 27.5625 | 27.625 | 21300.0 |
| 2000-04-11 | EWS | ETF | 14.625 | 14.625 | 14.375 | 14.5 | 36650.0 |
| 2000-04-11 | EWU | ETF | 40.5 | 40.5 | 40.125 | 40.25 | 10250.0 |
| 2000-04-11 | EWW | ETF | 18.4375 | 18.4375 | 18.25 | 18.3125 | 7400.0 |
| 2000-04-11 | FCTR | ETF | 13.5 | 13.5625 | 13.25 | 13.5 | 23000.0 |
| 2000-04-11 | FMAR | ETF | 6.38 | 6.38 | 5.87 | 5.87 | 1500.0 |
| 2000-04-11 | GLDB | ETF | 6.375 | 6.4375 | 6.1875 | 6.3125 | 82700.0 |
| 2000-04-11 | GSIG | ETF | 18.37 | 18.87 | 17.0 | 18.12 | 505600.0 |
| 2000-04-11 | IGLD | ETF | 1662.5 | 1700.0 | 1625.0 | 1646.875 | 847.0 |
| 2000-04-11 | KTEC | ETF | 8.90625 | 9.75 | 8.875 | 9.3125 | 20500.0 |
| 2000-04-11 | MDY | ETF | 85.875 | 88.375 | 85.0625 | 87.0938 | 683700.0 |
| 2000-04-11 | MIG | ETF | 5.5 | 5.875 | 5.5 | 5.5 | 12100.0 |
| 2000-04-11 | PPH | ETF | 45.5625 | 46.8438 | 45.5625 | 46.75 | 644600.0 |
| 2000-04-11 | SFY | ETF | 17.1875 | 18.1875 | 17.125 | 17.9375 | 202000.0 |
| 2000-04-11 | TDSC | ETF | 5.0 | 5.155 | 5.0 | 5.155 | 103400.0 |
| 2000-04-11 | TINY | ETF | 15.28 | 15.28 | 13.0 | 13.56 | 230000.0 |
| 2000-04-11 | XLB | ETF | 11.9062 | 12.1953 | 11.875 | 12.0 | 786200.0 |
| 2000-04-11 | XLE | ETF | 14.2188 | 14.5781 | 14.2188 | 14.4688 | 975800.0 |
| 2000-04-11 | XLF | ETF | 20.131 | 20.3087 | 19.7756 | 20.3087 | 162861.0 |
| 2000-04-11 | XLI | ETF | 29.5469 | 30.0781 | 29.5 | 29.9844 | 313700.0 |
| 2000-04-11 | XLK | ETF | 28.7422 | 29.0625 | 28.0 | 28.4688 | 2958400.0 |
| 2000-04-11 | XLP | ETF | 22.5625 | 22.875 | 22.3438 | 22.75 | 60900.0 |
| 2000-04-11 | XLU | ETF | 13.9531 | 14.2578 | 13.9531 | 14.1953 | 56600.0 |
| 2000-04-11 | XLV | ETF | 30.5 | 30.8281 | 30.4844 | 30.8281 | 10100.0 |
| 2000-04-11 | XLY | ETF | 15.2578 | 15.539 | 15.2578 | 15.5234 | 92200.0 |
> showing 47 of 47 rows — these rows as CSV