PREVIEW / etf_daily / 2000-08-24
file: by_date/etf_daily/2000/2000-08-24.parquet size: 8 KB rows: 80
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-24 | SPY | ETF | 151.1562 | 151.5 | 150.5 | 151.3125 | 4529000.0 |
| 2000-08-24 | QQQ | ETF | 97.4375 | 98.6875 | 96.0625 | 98.5625 | 13567700.0 |
| 2000-08-24 | IWM | ETF | 51.8594 | 52.625 | 51.8594 | 52.3438 | 276200.0 |
| 2000-08-24 | DIA | ETF | 111.4062 | 112.125 | 111.1562 | 112.0312 | 408400.0 |
| 2000-08-24 | BBH | ETF | 61.375 | 63.6667 | 61.375 | 63.4167 | 1947900.0 |
| 2000-08-24 | BITS | ETF | 12.125 | 13.5 | 11.625 | 12.0 | 19225.0 |
| 2000-08-24 | BOSS | ETF | 20.35 | 20.4 | 20.35 | 20.35 | 700.0 |
| 2000-08-24 | CEF | ETF | 3.3125 | 3.375 | 3.3125 | 3.375 | 6500.0 |
| 2000-08-24 | CHB | ETF | 5.75 | 6.0 | 5.63 | 5.75 | 67200.0 |
| 2000-08-24 | CNXT | ETF | 39.56 | 39.62 | 37.25 | 37.69 | 4607780.0 |
| 2000-08-24 | EWA | ETF | 10.4375 | 10.4375 | 10.1875 | 10.25 | 18600.0 |
| 2000-08-24 | EWC | ETF | 16.6875 | 16.75 | 16.5 | 16.625 | 56000.0 |
| 2000-08-24 | EWD | ETF | 24.1875 | 24.1875 | 23.75 | 24.0 | 13700.0 |
| 2000-08-24 | EWG | ETF | 20.9375 | 20.9375 | 20.6875 | 20.75 | 50300.0 |
| 2000-08-24 | EWH | ETF | 13.4375 | 13.625 | 13.4375 | 13.625 | 32000.0 |
| 2000-08-24 | EWI | ETF | 44.875 | 45.125 | 44.75 | 44.75 | 3950.0 |
| 2000-08-24 | EWJ | ETF | 55.5 | 55.5 | 55.0 | 55.5 | 83875.0 |
| 2000-08-24 | EWK | ETF | 14.25 | 14.25 | 13.75 | 13.75 | 1900.0 |
| 2000-08-24 | EWL | ETF | 16.0625 | 16.4375 | 16.0625 | 16.375 | 21400.0 |
| 2000-08-24 | EWM | ETF | 24.0 | 24.25 | 24.0 | 24.25 | 2150.0 |
| 2000-08-24 | EWN | ETF | 24.125 | 24.25 | 24.0625 | 24.0625 | 6600.0 |
| 2000-08-24 | EWO | ETF | 7.9375 | 8.0 | 7.9375 | 7.9375 | 11500.0 |
| 2000-08-24 | EWP | ETF | 24.5625 | 24.8125 | 24.5625 | 24.625 | 4300.0 |
| 2000-08-24 | EWQ | ETF | 26.1875 | 26.3125 | 26.125 | 26.3125 | 20900.0 |
| 2000-08-24 | EWS | ETF | 16.0 | 16.125 | 15.5 | 15.625 | 32950.0 |
| 2000-08-24 | EWT | ETF | 34.5 | 35.375 | 34.5 | 35.375 | 9050.0 |
| 2000-08-24 | EWU | ETF | 37.5 | 37.75 | 37.25 | 37.625 | 34150.0 |
| 2000-08-24 | EWW | ETF | 16.125 | 16.125 | 15.875 | 15.875 | 17500.0 |
| 2000-08-24 | EWY | ETF | 18.8125 | 19.125 | 18.8125 | 19.125 | 3000.0 |
| 2000-08-24 | EWZ | ETF | 19.25 | 19.25 | 19.25 | 19.25 | 15000.0 |
| 2000-08-24 | EZU | ETF | 38.4375 | 38.4375 | 38.1562 | 38.1562 | 45600.0 |
| 2000-08-24 | FCTR | ETF | 15.6875 | 16.5 | 15.6875 | 16.25 | 66200.0 |
| 2000-08-24 | FMAR | ETF | 5.0 | 5.25 | 5.0 | 5.12 | 6900.0 |
| 2000-08-24 | GLDB | ETF | 5.375 | 5.375 | 5.25 | 5.25 | 88500.0 |
| 2000-08-24 | GSIG | ETF | 25.19 | 26.69 | 25.12 | 26.56 | 286500.0 |
| 2000-08-24 | IDU | ETF | 39.5625 | 39.5625 | 38.9062 | 39.0312 | 9400.0 |
| 2000-08-24 | IEV | ETF | 39.4375 | 39.5 | 39.375 | 39.3906 | 9800.0 |
| 2000-08-24 | IGLD | ETF | 687.5 | 687.5 | 612.5 | 621.875 | 768.0 |
| 2000-08-24 | IJH | ETF | 10.5656 | 10.6328 | 10.5234 | 10.6328 | 806000.0 |
| 2000-08-24 | IJK | ETF | 17.8711 | 17.9238 | 17.8711 | 17.9238 | 1600.0 |
| 2000-08-24 | IJR | ETF | 18.0 | 18.1042 | 18.0 | 18.1042 | 55800.0 |
| 2000-08-24 | IJS | ETF | 17.8125 | 17.8125 | 17.8125 | 17.8125 | 9200.0 |
| 2000-08-24 | IJT | ETF | 21.0469 | 21.4805 | 21.0469 | 21.4727 | 145200.0 |
| 2000-08-24 | IVE | ETF | 62.8125 | 62.8125 | 62.4844 | 62.5625 | 2500.0 |
| 2000-08-24 | IVV | ETF | 150.7188 | 151.4219 | 150.6719 | 151.0781 | 53100.0 |
| 2000-08-24 | IVW | ETF | 22.8047 | 22.8945 | 22.7383 | 22.8945 | 27600.0 |
| 2000-08-24 | IWB | ETF | 80.1875 | 80.4219 | 80.1875 | 80.4219 | 2000.0 |
| 2000-08-24 | IWD | ETF | 57.5 | 57.5 | 57.2812 | 57.4375 | 7000.0 |
| 2000-08-24 | IWF | ETF | 22.28125 | 22.375 | 22.25 | 22.375 | 22800.0 |
| 2000-08-24 | IWN | ETF | 35.7865 | 35.8542 | 35.7865 | 35.8542 | 900.0 |
> showing 50 of 80 rows — these rows as CSV