PREVIEW / etf_daily / 2000-03-01
file: by_date/etf_daily/2000/2000-03-01.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-03-01 | SPY | ETF | 137.625 | 139.0 | 137.2188 | 138.4375 | 6868000.0 |
| 2000-03-01 | QQQ | ETF | 53.625 | 54.2812 | 53.25 | 53.8125 | 24468400.0 |
| 2000-03-01 | DIA | ETF | 101.7812 | 102.7812 | 100.6875 | 101.625 | 1136200.0 |
| 2000-03-01 | BBH | ETF | 75.1667 | 76.5417 | 74.1667 | 76.0 | 1767900.0 |
| 2000-03-01 | BITS | ETF | 31.0 | 33.0 | 31.0 | 33.0 | 36000.0 |
| 2000-03-01 | CEF | ETF | 3.5 | 3.625 | 3.5 | 3.5 | 19900.0 |
| 2000-03-01 | CHB | ETF | 6.31 | 6.5 | 6.25 | 6.31 | 198700.0 |
| 2000-03-01 | CNXT | ETF | 98.16 | 99.97 | 87.78 | 89.53 | 9051930.0 |
| 2000-03-01 | CSB | ETF | 4.0 | 4.0 | 3.90000009536743 | 4.0 | 7600.0 |
| 2000-03-01 | EWA | ETF | 10.25 | 10.25 | 10.25 | 10.25 | 5700.0 |
| 2000-03-01 | EWC | ETF | 17.25 | 17.5 | 17.0 | 17.5 | 26000.0 |
| 2000-03-01 | EWD | ETF | 35.5 | 36.0 | 35.3125 | 35.75 | 9400.0 |
| 2000-03-01 | EWG | ETF | 27.5625 | 28.125 | 27.5625 | 28.125 | 27800.0 |
| 2000-03-01 | EWH | ETF | 13.125 | 13.1875 | 13.0 | 13.125 | 34000.0 |
| 2000-03-01 | EWI | ETF | 53.75 | 54.25 | 53.5 | 54.0 | 15500.0 |
| 2000-03-01 | EWJ | ETF | 61.25 | 62.0 | 61.0 | 62.0 | 88100.0 |
| 2000-03-01 | EWK | ETF | 12.8125 | 12.8125 | 12.625 | 12.625 | 2800.0 |
| 2000-03-01 | EWL | ETF | 14.5 | 14.5625 | 14.25 | 14.5625 | 179100.0 |
| 2000-03-01 | EWM | ETF | 29.25 | 29.5 | 28.75 | 29.0 | 40025.0 |
| 2000-03-01 | EWN | ETF | 23.6875 | 24.0625 | 23.625 | 24.0625 | 7400.0 |
| 2000-03-01 | EWO | ETF | 7.625 | 7.625 | 7.625 | 7.625 | 2800.0 |
| 2000-03-01 | EWP | ETF | 28.5625 | 28.875 | 28.375 | 28.8125 | 1900.0 |
| 2000-03-01 | EWQ | ETF | 28.0 | 28.4375 | 27.8125 | 28.4375 | 14800.0 |
| 2000-03-01 | EWS | ETF | 14.625 | 14.625 | 14.25 | 14.625 | 238550.0 |
| 2000-03-01 | EWU | ETF | 38.375 | 39.125 | 38.375 | 39.125 | 5000.0 |
| 2000-03-01 | EWW | ETF | 18.0 | 18.375 | 17.75 | 18.1875 | 16400.0 |
| 2000-03-01 | FCTR | ETF | 13.5938 | 13.75 | 13.3125 | 13.3125 | 17000.0 |
| 2000-03-01 | FMAR | ETF | 6.81 | 7.19 | 6.81 | 7.0 | 6400.0 |
| 2000-03-01 | GLDB | ETF | 8.0 | 8.0 | 7.75 | 7.8125 | 81800.0 |
| 2000-03-01 | GSIG | ETF | 25.37 | 25.5 | 23.25 | 23.69 | 934700.0 |
| 2000-03-01 | IGLD | ETF | 2468.75 | 2562.5 | 2375.0 | 2375.0 | 1694.0 |
| 2000-03-01 | KTEC | ETF | 9.0625 | 9.125 | 8.875 | 9.125 | 4400.0 |
| 2000-03-01 | MDY | ETF | 85.875 | 86.5625 | 85.375 | 86.3125 | 547400.0 |
| 2000-03-01 | MIG | ETF | 5.8125 | 5.8125 | 5.3125 | 5.5625 | 22000.0 |
| 2000-03-01 | PPH | ETF | 40.3125 | 40.4062 | 39.1875 | 39.5 | 272800.0 |
| 2000-03-01 | SFY | ETF | 11.9375 | 12.375 | 11.875 | 12.25 | 98400.0 |
| 2000-03-01 | TDSC | ETF | 5.78 | 6.125 | 5.595 | 6.03 | 367600.0 |
| 2000-03-01 | TINY | ETF | 21.62 | 25.12 | 21.62 | 24.06 | 744900.0 |
| 2000-03-01 | XLB | ETF | 10.6172 | 10.6172 | 10.289 | 10.3828 | 239400.0 |
| 2000-03-01 | XLE | ETF | 13.0078 | 13.4531 | 12.9688 | 13.4062 | 1761200.0 |
| 2000-03-01 | XLF | ETF | 16.7547 | 17.1101 | 16.6531 | 16.9578 | 1578634.0 |
| 2000-03-01 | XLI | ETF | 25.7031 | 25.9062 | 25.5 | 25.5469 | 2408000.0 |
| 2000-03-01 | XLK | ETF | 28.0 | 28.625 | 28.0 | 28.2188 | 1927000.0 |
| 2000-03-01 | XLP | ETF | 20.4219 | 20.625 | 20.25 | 20.3281 | 295500.0 |
| 2000-03-01 | XLU | ETF | 12.5781 | 12.711 | 12.5703 | 12.6719 | 92200.0 |
| 2000-03-01 | XLV | ETF | 28.2656 | 28.5312 | 28.0312 | 28.375 | 26700.0 |
| 2000-03-01 | XLY | ETF | 12.8516 | 12.8516 | 12.5938 | 12.6953 | 691400.0 |
> showing 47 of 47 rows — these rows as CSV