PREVIEW / etf_daily / 2000-06-01
file: by_date/etf_daily/2000/2000-06-01.parquet size: 7 KB rows: 59
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-06-01 | SPY | ETF | 143.6875 | 145.4375 | 143.0 | 145.3125 | 8961600.0 |
| 2000-06-01 | QQQ | ETF | 85.1875 | 88.375 | 84.0 | 87.375 | 28993500.0 |
| 2000-06-01 | IWM | ETF | 48.5547 | 48.6562 | 48.5547 | 48.6562 | 7000.0 |
| 2000-06-01 | DIA | ETF | 105.9844 | 107.0 | 105.3438 | 106.5 | 791900.0 |
| 2000-06-01 | BBH | ETF | 43.9167 | 45.3125 | 43.6667 | 45.0 | 1077000.0 |
| 2000-06-01 | BITS | ETF | 21.0 | 21.5 | 20.25 | 21.0 | 25675.0 |
| 2000-06-01 | CEF | ETF | 3.375 | 3.4375 | 3.375 | 3.4375 | 9400.0 |
| 2000-06-01 | CHB | ETF | 5.75 | 5.88 | 5.44 | 5.5 | 86300.0 |
| 2000-06-01 | CNXT | ETF | 38.94 | 42.81 | 38.94 | 42.63 | 8900880.0 |
| 2000-06-01 | EWA | ETF | 9.375 | 9.625 | 9.375 | 9.5625 | 17600.0 |
| 2000-06-01 | EWC | ETF | 18.625 | 18.6875 | 18.375 | 18.6875 | 19000.0 |
| 2000-06-01 | EWD | ETF | 32.1875 | 32.5 | 32.1875 | 32.5 | 700.0 |
| 2000-06-01 | EWG | ETF | 24.875 | 25.0 | 24.6875 | 25.0 | 46300.0 |
| 2000-06-01 | EWH | ETF | 11.6875 | 12.125 | 11.6875 | 12.125 | 112300.0 |
| 2000-06-01 | EWI | ETF | 49.375 | 49.875 | 49.375 | 49.875 | 3250.0 |
| 2000-06-01 | EWJ | ETF | 57.5 | 58.25 | 57.25 | 58.25 | 52675.0 |
| 2000-06-01 | EWK | ETF | 12.8125 | 12.8125 | 12.8125 | 12.8125 | 1300.0 |
| 2000-06-01 | EWL | ETF | 15.6875 | 15.8125 | 15.5 | 15.5625 | 11200.0 |
| 2000-06-01 | EWM | ETF | 27.5 | 27.5 | 27.0 | 27.5 | 17775.0 |
| 2000-06-01 | EWN | ETF | 23.5 | 23.875 | 23.5 | 23.625 | 5200.0 |
| 2000-06-01 | EWO | ETF | 7.75 | 7.9375 | 7.6875 | 7.6875 | 7700.0 |
| 2000-06-01 | EWP | ETF | 26.0625 | 26.4375 | 26.0625 | 26.4375 | 5000.0 |
| 2000-06-01 | EWQ | ETF | 28.375 | 28.75 | 28.3125 | 28.75 | 14800.0 |
| 2000-06-01 | EWS | ETF | 13.5 | 14.0 | 13.25 | 14.0 | 89350.0 |
| 2000-06-01 | EWU | ETF | 38.125 | 38.5 | 37.875 | 38.0 | 20250.0 |
| 2000-06-01 | EWW | ETF | 15.125 | 15.5 | 15.125 | 15.5 | 42100.0 |
| 2000-06-01 | EWY | ETF | 19.3125 | 19.375 | 19.1875 | 19.1875 | 11500.0 |
| 2000-06-01 | FCTR | ETF | 16.0 | 16.25 | 15.875 | 16.125 | 27300.0 |
| 2000-06-01 | FMAR | ETF | 6.75 | 6.9375 | 6.13 | 6.13 | 6700.0 |
| 2000-06-01 | GLDB | ETF | 5.625 | 6.0 | 5.375 | 6.0 | 138700.0 |
| 2000-06-01 | GSIG | ETF | 21.44 | 21.75 | 20.75 | 21.19 | 367700.0 |
| 2000-06-01 | IGLD | ETF | 887.5 | 1150.0 | 862.5 | 937.5 | 4783.0 |
| 2000-06-01 | IJH | ETF | 9.5875 | 9.65 | 9.5875 | 9.65 | 102000.0 |
| 2000-06-01 | IJR | ETF | 16.7031 | 16.9688 | 16.7031 | 16.9688 | 905400.0 |
| 2000-06-01 | IVE | ETF | 60.7812 | 61.4219 | 60.6875 | 61.4219 | 25400.0 |
| 2000-06-01 | IVV | ETF | 143.9062 | 145.0625 | 143.625 | 145.0625 | 128700.0 |
| 2000-06-01 | IVW | ETF | 21.4219 | 21.5508 | 21.211 | 21.3438 | 62800.0 |
| 2000-06-01 | IWB | ETF | 75.6562 | 76.6875 | 75.6562 | 76.2656 | 400.0 |
| 2000-06-01 | IWD | ETF | 56.8125 | 57.3281 | 56.8125 | 57.0625 | 15300.0 |
| 2000-06-01 | IWF | ETF | 20.511725 | 20.796875 | 20.511725 | 20.71875 | 20800.0 |
| 2000-06-01 | IWV | ETF | 78.1562 | 79.0 | 78.1562 | 78.4844 | 800.0 |
| 2000-06-01 | IYF | ETF | 36.9375 | 37.8438 | 36.9375 | 37.7109 | 2000.0 |
| 2000-06-01 | IYW | ETF | 28.6875 | 29.5 | 28.6875 | 29.4922 | 13600.0 |
| 2000-06-01 | IYZ | ETF | 58.0 | 59.3125 | 58.0 | 59.3125 | 2200.0 |
| 2000-06-01 | KTEC | ETF | 8.625 | 8.625 | 8.625 | 8.625 | 4900.0 |
| 2000-06-01 | MDY | ETF | 88.5625 | 90.3125 | 88.3125 | 90.25 | 240900.0 |
| 2000-06-01 | PPH | ETF | 48.2812 | 48.9375 | 47.75 | 47.75 | 1000800.0 |
| 2000-06-01 | SFY | ETF | 25.8125 | 25.8125 | 24.625 | 25.1875 | 73500.0 |
| 2000-06-01 | TDSC | ETF | 5.875 | 6.0 | 5.56 | 6.0 | 122600.0 |
| 2000-06-01 | TINY | ETF | 6.0 | 7.88 | 6.0 | 7.81 | 114600.0 |
> showing 50 of 59 rows — these rows as CSV