PREVIEW / etf_daily / 2000-08-04
file: by_date/etf_daily/2000/2000-08-04.parquet size: 8 KB rows: 78
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-04 | SPY | ETF | 146.3125 | 146.7188 | 145.4062 | 146.375 | 3686600.0 |
| 2000-08-04 | QQQ | ETF | 92.0 | 92.7656 | 89.125 | 90.125 | 22283400.0 |
| 2000-08-04 | IWM | ETF | 50.5625 | 50.5781 | 49.9219 | 50.2188 | 570400.0 |
| 2000-08-04 | DIA | ETF | 107.125 | 107.7344 | 106.6406 | 107.5 | 880100.0 |
| 2000-08-04 | BBH | ETF | 61.5833 | 62.3333 | 60.2917 | 61.6042 | 1832700.0 |
| 2000-08-04 | BITS | ETF | 15.0 | 16.25 | 14.0 | 14.5 | 4900.0 |
| 2000-08-04 | CEF | ETF | 3.3125 | 3.3125 | 3.3125 | 3.3125 | 6100.0 |
| 2000-08-04 | CHB | ETF | 5.13 | 5.19 | 5.06 | 5.19 | 33700.0 |
| 2000-08-04 | CNXT | ETF | 32.13 | 32.31 | 29.31 | 30.0 | 5305710.0 |
| 2000-08-04 | CSB | ETF | 2.40000009536743 | 2.40000009536743 | 2.40000009536743 | 2.40000009536743 | 5900.0 |
| 2000-08-04 | EWA | ETF | 10.4375 | 10.4375 | 10.3125 | 10.4375 | 6600.0 |
| 2000-08-04 | EWC | ETF | 20.625 | 20.625 | 20.5 | 20.625 | 23900.0 |
| 2000-08-04 | EWD | ETF | 28.4375 | 28.6875 | 28.4375 | 28.4375 | 3300.0 |
| 2000-08-04 | EWG | ETF | 23.4375 | 23.4375 | 23.0625 | 23.3125 | 11000.0 |
| 2000-08-04 | EWH | ETF | 13.4375 | 13.625 | 13.4375 | 13.5625 | 36500.0 |
| 2000-08-04 | EWJ | ETF | 54.5 | 54.5 | 54.0 | 54.5 | 121875.0 |
| 2000-08-04 | EWK | ETF | 13.75 | 13.75 | 13.75 | 13.75 | 6900.0 |
| 2000-08-04 | EWL | ETF | 16.0 | 16.0625 | 16.0 | 16.0625 | 4700.0 |
| 2000-08-04 | EWM | ETF | 24.25 | 24.75 | 24.25 | 24.75 | 22000.0 |
| 2000-08-04 | EWN | ETF | 23.8125 | 23.8125 | 23.5 | 23.5 | 1000.0 |
| 2000-08-04 | EWO | ETF | 7.8125 | 8.0 | 7.8125 | 8.0 | 1200.0 |
| 2000-08-04 | EWP | ETF | 25.0 | 25.375 | 25.0 | 25.375 | 1400.0 |
| 2000-08-04 | EWQ | ETF | 27.25 | 27.3125 | 27.25 | 27.25 | 5700.0 |
| 2000-08-04 | EWS | ETF | 14.875 | 15.0 | 14.75 | 14.875 | 8700.0 |
| 2000-08-04 | EWT | ETF | 36.125 | 36.125 | 35.875 | 36.0 | 13900.0 |
| 2000-08-04 | EWU | ETF | 38.75 | 38.75 | 38.375 | 38.75 | 4200.0 |
| 2000-08-04 | EWW | ETF | 16.75 | 16.75 | 16.5 | 16.6875 | 27800.0 |
| 2000-08-04 | EWY | ETF | 18.75 | 18.75 | 18.25 | 18.625 | 28100.0 |
| 2000-08-04 | EWZ | ETF | 19.375 | 19.625 | 19.375 | 19.625 | 700.0 |
| 2000-08-04 | EZU | ETF | 38.125 | 38.125 | 37.7812 | 37.8438 | 80600.0 |
| 2000-08-04 | FCTR | ETF | 14.0625 | 14.375 | 13.6875 | 13.875 | 9600.0 |
| 2000-08-04 | FMAR | ETF | 5.0 | 5.0 | 5.0 | 5.0 | 100.0 |
| 2000-08-04 | GLDB | ETF | 4.8125 | 4.8438 | 4.75 | 4.75 | 63600.0 |
| 2000-08-04 | GSIG | ETF | 22.09 | 23.56 | 21.75 | 23.25 | 1051800.0 |
| 2000-08-04 | IDU | ETF | 36.875 | 37.0938 | 36.4609 | 37.0625 | 25000.0 |
| 2000-08-04 | IEV | ETF | 38.6875 | 38.6875 | 38.0625 | 38.125 | 39400.0 |
| 2000-08-04 | IGLD | ETF | 725.0 | 725.0 | 700.0 | 700.0 | 175.0 |
| 2000-08-04 | IJH | ETF | 10.075 | 10.1031 | 10.0719 | 10.0906 | 120000.0 |
| 2000-08-04 | IJJ | ETF | 18.7656 | 18.7656 | 18.7656 | 18.7656 | 400.0 |
| 2000-08-04 | IJK | ETF | 16.793 | 16.793 | 16.7773 | 16.7773 | 1600.0 |
| 2000-08-04 | IJR | ETF | 17.2839 | 17.2839 | 17.1667 | 17.2136 | 19200.0 |
| 2000-08-04 | IJS | ETF | 17.1914 | 17.2344 | 17.1719 | 17.2344 | 5200.0 |
| 2000-08-04 | IJT | ETF | 20.0312 | 20.0312 | 20.0312 | 20.0312 | 1600.0 |
| 2000-08-04 | IUSG | ETF | 33.1484 | 33.1797 | 33.0703 | 33.1797 | 1400.0 |
| 2000-08-04 | IVE | ETF | 61.0625 | 61.4062 | 60.9375 | 61.4062 | 5200.0 |
| 2000-08-04 | IVV | ETF | 146.0312 | 146.4219 | 145.4688 | 146.25 | 132900.0 |
| 2000-08-04 | IVW | ETF | 22.0 | 22.0312 | 21.7773 | 21.9141 | 101600.0 |
| 2000-08-04 | IWB | ETF | 77.25 | 77.2812 | 77.1875 | 77.2344 | 4500.0 |
| 2000-08-04 | IWD | ETF | 56.125 | 56.5469 | 56.125 | 56.5469 | 7400.0 |
| 2000-08-04 | IWF | ETF | 21.1289 | 21.1289 | 20.90625 | 21.050775 | 240400.0 |
> showing 50 of 78 rows — these rows as CSV