PREVIEW / etf_daily / 2000-09-07
file: by_date/etf_daily/2000/2000-09-07.parquet size: 8 KB rows: 85
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-09-07 | SPY | ETF | 150.25 | 151.0781 | 149.8281 | 150.8438 | 4265500.0 |
| 2000-09-07 | QQQ | ETF | 96.8125 | 99.4219 | 96.5625 | 98.125 | 16669700.0 |
| 2000-09-07 | IWM | ETF | 53.8125 | 54.4062 | 53.8125 | 54.375 | 213800.0 |
| 2000-09-07 | DIA | ETF | 112.7812 | 113.25 | 112.2656 | 112.7812 | 650300.0 |
| 2000-09-07 | BBH | ETF | 61.75 | 63.3125 | 61.4167 | 62.875 | 3921900.0 |
| 2000-09-07 | BITS | ETF | 18.5 | 19.75 | 18.5 | 19.75 | 2675.0 |
| 2000-09-07 | BOSS | ETF | 19.5 | 19.5 | 19.5 | 19.5 | 100.0 |
| 2000-09-07 | CEF | ETF | 3.3125 | 3.375 | 3.25 | 3.3125 | 52400.0 |
| 2000-09-07 | CHB | ETF | 5.75 | 5.75 | 5.63 | 5.69 | 89700.0 |
| 2000-09-07 | CNXT | ETF | 35.19 | 37.64 | 35.13 | 37.38 | 6364580.0 |
| 2000-09-07 | CSB | ETF | 2.40000009536743 | 2.40000009536743 | 2.40000009536743 | 2.40000009536743 | 500.0 |
| 2000-09-07 | EWA | ETF | 9.875 | 9.875 | 9.6875 | 9.6875 | 3300.0 |
| 2000-09-07 | EWC | ETF | 17.0 | 17.125 | 16.8125 | 16.8125 | 21300.0 |
| 2000-09-07 | EWD | ETF | 24.625 | 24.6875 | 24.625 | 24.6875 | 6300.0 |
| 2000-09-07 | EWG | ETF | 20.625 | 20.875 | 20.375 | 20.875 | 46500.0 |
| 2000-09-07 | EWH | ETF | 13.5 | 13.5625 | 13.375 | 13.5 | 35300.0 |
| 2000-09-07 | EWI | ETF | 44.5 | 44.625 | 44.5 | 44.625 | 12800.0 |
| 2000-09-07 | EWJ | ETF | 54.75 | 55.25 | 54.75 | 55.0 | 54675.0 |
| 2000-09-07 | EWK | ETF | 12.9375 | 12.9375 | 12.8125 | 12.875 | 1400.0 |
| 2000-09-07 | EWL | ETF | 15.3125 | 15.3125 | 15.0625 | 15.125 | 5800.0 |
| 2000-09-07 | EWM | ETF | 22.5 | 22.75 | 22.25 | 22.75 | 6100.0 |
| 2000-09-07 | EWN | ETF | 23.625 | 23.75 | 23.5 | 23.75 | 10000.0 |
| 2000-09-07 | EWO | ETF | 7.75 | 7.8125 | 7.6875 | 7.8125 | 12100.0 |
| 2000-09-07 | EWP | ETF | 24.4375 | 24.6875 | 24.4375 | 24.6875 | 6800.0 |
| 2000-09-07 | EWQ | ETF | 26.625 | 26.875 | 26.5 | 26.875 | 39400.0 |
| 2000-09-07 | EWS | ETF | 14.875 | 15.125 | 14.875 | 15.0 | 78250.0 |
| 2000-09-07 | EWT | ETF | 33.0 | 33.0 | 32.125 | 32.25 | 84000.0 |
| 2000-09-07 | EWU | ETF | 36.5 | 36.875 | 36.375 | 36.75 | 12100.0 |
| 2000-09-07 | EWW | ETF | 17.0625 | 17.3125 | 16.9375 | 16.9375 | 19400.0 |
| 2000-09-07 | EWY | ETF | 17.625 | 17.875 | 17.5 | 17.5 | 20400.0 |
| 2000-09-07 | EWZ | ETF | 20.375 | 20.375 | 20.25 | 20.3125 | 4400.0 |
| 2000-09-07 | EZU | ETF | 38.4062 | 38.4062 | 38.375 | 38.375 | 9200.0 |
| 2000-09-07 | FCTR | ETF | 16.0625 | 16.125 | 15.875 | 15.875 | 20500.0 |
| 2000-09-07 | FMAR | ETF | 5.06 | 5.44 | 5.06 | 5.44 | 3400.0 |
| 2000-09-07 | GLDB | ETF | 5.2813 | 5.3125 | 5.1875 | 5.25 | 83800.0 |
| 2000-09-07 | GSIG | ETF | 24.0 | 25.19 | 23.87 | 24.75 | 436200.0 |
| 2000-09-07 | IDU | ETF | 41.0 | 41.1406 | 40.8906 | 41.1406 | 14400.0 |
| 2000-09-07 | IEV | ETF | 39.2188 | 39.5938 | 39.2188 | 39.5938 | 13400.0 |
| 2000-09-07 | IGLD | ETF | 646.875 | 696.875 | 637.5 | 637.5 | 495.0 |
| 2000-09-07 | IJH | ETF | 10.8969 | 11.0141 | 10.875 | 11.0141 | 1088000.0 |
| 2000-09-07 | IJJ | ETF | 19.8711 | 19.8711 | 19.8711 | 19.8711 | 400.0 |
| 2000-09-07 | IJK | ETF | 18.4062 | 18.5371 | 18.4062 | 18.5371 | 38400.0 |
| 2000-09-07 | IJR | ETF | 18.5729 | 18.7969 | 18.5729 | 18.7969 | 107400.0 |
| 2000-09-07 | IJS | ETF | 18.2344 | 18.2578 | 18.2344 | 18.2578 | 8000.0 |
| 2000-09-07 | IJT | ETF | 22.082 | 22.0938 | 22.0156 | 22.0938 | 7200.0 |
| 2000-09-07 | IUSG | ETF | 35.0234 | 35.1406 | 35.0156 | 35.0156 | 2600.0 |
| 2000-09-07 | IVE | ETF | 63.7969 | 63.7969 | 63.5 | 63.5 | 10800.0 |
| 2000-09-07 | IVV | ETF | 150.2344 | 150.9375 | 149.875 | 150.9375 | 84000.0 |
| 2000-09-07 | IVW | ETF | 22.2383 | 22.418 | 22.207 | 22.418 | 3200.0 |
| 2000-09-07 | IWB | ETF | 80.1875 | 80.6875 | 80.1875 | 80.6875 | 3200.0 |
> showing 50 of 85 rows — these rows as CSV