PREVIEW / etf_daily / 2000-08-01
file: by_date/etf_daily/2000/2000-08-01.parquet size: 8 KB rows: 76
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-08-01 | SPY | ETF | 143.625 | 144.7188 | 143.125 | 143.875 | 3946600.0 |
| 2000-08-01 | QQQ | ETF | 89.8125 | 89.9844 | 87.6875 | 88.25 | 15751800.0 |
| 2000-08-01 | IWM | ETF | 49.875 | 50.0625 | 49.6406 | 49.9219 | 263400.0 |
| 2000-08-01 | DIA | ETF | 105.5312 | 106.3125 | 105.0469 | 106.0 | 385600.0 |
| 2000-08-01 | BBH | ETF | 56.3333 | 59.9792 | 56.3333 | 58.9583 | 2197200.0 |
| 2000-08-01 | BITS | ETF | 15.5 | 16.25 | 15.5 | 16.0 | 12450.0 |
| 2000-08-01 | CEF | ETF | 3.3125 | 3.3125 | 3.3125 | 3.3125 | 6300.0 |
| 2000-08-01 | CHB | ETF | 5.44 | 5.69 | 5.38 | 5.5 | 32000.0 |
| 2000-08-01 | CNXT | ETF | 31.62 | 33.0 | 31.25 | 31.37 | 4604520.0 |
| 2000-08-01 | CSB | ETF | 2.70000004768372 | 2.70000004768372 | 2.70000004768372 | 2.70000004768372 | 7300.0 |
| 2000-08-01 | EWA | ETF | 10.125 | 10.1875 | 10.125 | 10.1875 | 8400.0 |
| 2000-08-01 | EWC | ETF | 20.125 | 20.25 | 20.0 | 20.0 | 31300.0 |
| 2000-08-01 | EWD | ETF | 29.625 | 29.625 | 29.1875 | 29.1875 | 11700.0 |
| 2000-08-01 | EWG | ETF | 24.125 | 24.125 | 23.6875 | 23.6875 | 69800.0 |
| 2000-08-01 | EWH | ETF | 13.0625 | 13.1875 | 12.9375 | 12.9375 | 36400.0 |
| 2000-08-01 | EWI | ETF | 50.0 | 50.25 | 49.625 | 49.625 | 4900.0 |
| 2000-08-01 | EWJ | ETF | 54.5 | 55.0 | 54.0 | 54.5 | 85975.0 |
| 2000-08-01 | EWK | ETF | 13.6875 | 13.8125 | 13.625 | 13.625 | 2600.0 |
| 2000-08-01 | EWL | ETF | 16.0625 | 16.1875 | 15.875 | 16.1875 | 50600.0 |
| 2000-08-01 | EWM | ETF | 24.0 | 24.25 | 24.0 | 24.0 | 3400.0 |
| 2000-08-01 | EWN | ETF | 23.8125 | 23.9375 | 23.75 | 23.75 | 21300.0 |
| 2000-08-01 | EWO | ETF | 8.0 | 8.125 | 8.0 | 8.0 | 20700.0 |
| 2000-08-01 | EWP | ETF | 25.625 | 25.625 | 25.25 | 25.4375 | 10900.0 |
| 2000-08-01 | EWQ | ETF | 28.3125 | 28.4375 | 27.9375 | 28.0 | 63600.0 |
| 2000-08-01 | EWS | ETF | 14.875 | 15.0 | 14.875 | 14.875 | 37200.0 |
| 2000-08-01 | EWU | ETF | 38.375 | 38.875 | 38.375 | 38.375 | 31800.0 |
| 2000-08-01 | EWW | ETF | 16.4375 | 16.75 | 16.4375 | 16.5 | 8500.0 |
| 2000-08-01 | EWY | ETF | 18.875 | 18.875 | 18.75 | 18.75 | 17000.0 |
| 2000-08-01 | EWZ | ETF | 19.0 | 19.25 | 19.0 | 19.25 | 7400.0 |
| 2000-08-01 | EZU | ETF | 38.9688 | 38.9688 | 38.9375 | 38.9375 | 400.0 |
| 2000-08-01 | FCTR | ETF | 14.5 | 14.5313 | 13.8125 | 14.0 | 17600.0 |
| 2000-08-01 | FMAR | ETF | 5.25 | 5.25 | 5.0 | 5.0 | 4300.0 |
| 2000-08-01 | GLDB | ETF | 4.9063 | 4.9375 | 4.8438 | 4.875 | 91000.0 |
| 2000-08-01 | GSIG | ETF | 27.44 | 29.0 | 25.12 | 26.62 | 568000.0 |
| 2000-08-01 | IEV | ETF | 38.9375 | 38.9375 | 38.4375 | 38.4688 | 51200.0 |
| 2000-08-01 | IGLD | ETF | 743.75 | 750.0 | 693.75 | 700.0 | 343.0 |
| 2000-08-01 | IJH | ETF | 9.8344 | 9.8688 | 9.8297 | 9.8297 | 37000.0 |
| 2000-08-01 | IJK | ETF | 16.3555 | 16.3555 | 16.3555 | 16.3555 | 1600.0 |
| 2000-08-01 | IJR | ETF | 17.1094 | 17.1406 | 17.0833 | 17.099 | 6600.0 |
| 2000-08-01 | IJS | ETF | 17.1172 | 17.1172 | 17.1172 | 17.1172 | 5200.0 |
| 2000-08-01 | IUSG | ETF | 32.75 | 32.75 | 32.75 | 32.75 | 200.0 |
| 2000-08-01 | IVE | ETF | 59.375 | 59.9844 | 59.375 | 59.7188 | 47800.0 |
| 2000-08-01 | IVV | ETF | 143.2812 | 144.3906 | 143.2812 | 144.0625 | 481700.0 |
| 2000-08-01 | IVW | ETF | 21.6641 | 21.8125 | 21.6016 | 21.6602 | 254400.0 |
| 2000-08-01 | IWB | ETF | 75.7188 | 76.1875 | 75.7188 | 76.1875 | 6100.0 |
| 2000-08-01 | IWD | ETF | 54.7656 | 55.3281 | 54.7656 | 55.1875 | 20400.0 |
| 2000-08-01 | IWF | ETF | 20.925775 | 20.925775 | 20.8164 | 20.886725 | 10400.0 |
| 2000-08-01 | IWN | ETF | 34.6458 | 34.6979 | 34.6458 | 34.6979 | 2400.0 |
| 2000-08-01 | IWO | ETF | 76.375 | 76.75 | 75.5625 | 75.5625 | 47600.0 |
| 2000-08-01 | IWV | ETF | 78.5625 | 78.6406 | 78.5625 | 78.6406 | 500.0 |
> showing 50 of 76 rows — these rows as CSV