PREVIEW / etf_daily / 2000-09-29
file: by_date/etf_daily/2000/2000-09-29.parquet size: 8 KB rows: 83
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-29 | SPY | ETF | 145.4688 | 145.9688 | 143.625 | 143.625 | 9333600.0 |
| 2000-09-29 | QQQ | ETF | 92.0 | 92.4531 | 88.6875 | 88.75 | 27198800.0 |
| 2000-09-29 | IWM | ETF | 52.0156 | 52.1953 | 51.8125 | 51.8125 | 130400.0 |
| 2000-09-29 | DIA | ETF | 107.9375 | 108.125 | 106.625 | 106.625 | 780400.0 |
| 2000-09-29 | BBH | ETF | 66.3333 | 66.6458 | 64.8333 | 65.0 | 3235800.0 |
| 2000-09-29 | BITS | ETF | 14.75 | 15.5 | 14.5 | 14.5 | 9675.0 |
| 2000-09-29 | CEF | ETF | 3.25 | 3.25 | 3.25 | 3.25 | 3700.0 |
| 2000-09-29 | CHB | ETF | 4.31 | 4.31 | 4.13 | 4.13 | 49700.0 |
| 2000-09-29 | CNXT | ETF | 42.0 | 43.5 | 40.88 | 41.88 | 3518040.0 |
| 2000-09-29 | CSB | ETF | 0.949999988079071 | 1.5 | 0.949999988079071 | 1.39999997615814 | 153000.0 |
| 2000-09-29 | EWA | ETF | 9.625 | 9.625 | 9.4375 | 9.5 | 11200.0 |
| 2000-09-29 | EWC | ETF | 16.125 | 16.125 | 16.0 | 16.125 | 3000.0 |
| 2000-09-29 | EWD | ETF | 21.6875 | 21.9375 | 21.6875 | 21.875 | 3200.0 |
| 2000-09-29 | EWG | ETF | 19.4375 | 19.4375 | 19.125 | 19.3125 | 79600.0 |
| 2000-09-29 | EWH | ETF | 12.0 | 12.125 | 12.0 | 12.125 | 51400.0 |
| 2000-09-29 | EWI | ETF | 41.875 | 42.5 | 41.875 | 42.5 | 5200.0 |
| 2000-09-29 | EWJ | ETF | 52.25 | 53.0 | 51.75 | 53.0 | 159325.0 |
| 2000-09-29 | EWK | ETF | 12.5625 | 12.875 | 12.5625 | 12.875 | 5600.0 |
| 2000-09-29 | EWL | ETF | 15.125 | 15.125 | 14.8125 | 15.0 | 6700.0 |
| 2000-09-29 | EWM | ETF | 20.75 | 21.75 | 20.75 | 21.0 | 1075.0 |
| 2000-09-29 | EWN | ETF | 22.25 | 22.6875 | 22.25 | 22.6875 | 1800.0 |
| 2000-09-29 | EWO | ETF | 7.6875 | 7.75 | 7.5625 | 7.6875 | 8000.0 |
| 2000-09-29 | EWP | ETF | 24.125 | 24.5 | 24.125 | 24.375 | 5700.0 |
| 2000-09-29 | EWQ | ETF | 24.75 | 24.875 | 24.625 | 24.75 | 41600.0 |
| 2000-09-29 | EWS | ETF | 13.625 | 13.875 | 13.5 | 13.75 | 38250.0 |
| 2000-09-29 | EWT | ETF | 29.125 | 29.125 | 28.25 | 28.25 | 14800.0 |
| 2000-09-29 | EWU | ETF | 35.375 | 36.25 | 35.375 | 35.75 | 53600.0 |
| 2000-09-29 | EWW | ETF | 15.5 | 15.5 | 15.1875 | 15.1875 | 4900.0 |
| 2000-09-29 | EWY | ETF | 16.3125 | 16.4375 | 16.0625 | 16.375 | 2800.0 |
| 2000-09-29 | EWZ | ETF | 18.125 | 18.125 | 18.125 | 18.125 | 300.0 |
| 2000-09-29 | EZU | ETF | 36.0 | 36.0625 | 35.9688 | 36.0625 | 14200.0 |
| 2000-09-29 | FCTR | ETF | 14.375 | 14.9375 | 14.375 | 14.4375 | 27500.0 |
| 2000-09-29 | FMAR | ETF | 4.81 | 5.0 | 4.81 | 5.0 | 5200.0 |
| 2000-09-29 | GLDB | ETF | 5.0625 | 5.25 | 5.0 | 5.125 | 217200.0 |
| 2000-09-29 | GSIG | ETF | 17.06 | 17.19 | 16.25 | 16.5 | 246900.0 |
| 2000-09-29 | IDU | ETF | 43.5 | 43.8203 | 43.4844 | 43.4844 | 104800.0 |
| 2000-09-29 | IEV | ETF | 38.125 | 38.1328 | 37.8828 | 38.1328 | 79800.0 |
| 2000-09-29 | IGLD | ETF | 550.0 | 600.0 | 537.5 | 537.5 | 644.0 |
| 2000-09-29 | IJH | ETF | 10.8406 | 10.8406 | 10.7484 | 10.7484 | 1619000.0 |
| 2000-09-29 | IJJ | ETF | 19.668 | 19.7383 | 19.668 | 19.7383 | 29600.0 |
| 2000-09-29 | IJK | ETF | 18.3613 | 18.377 | 18.248 | 18.248 | 9600.0 |
| 2000-09-29 | IJR | ETF | 18.1667 | 18.2422 | 18.1068 | 18.1068 | 58200.0 |
| 2000-09-29 | IJS | ETF | 17.8984 | 18.0664 | 17.8984 | 18.0664 | 800.0 |
| 2000-09-29 | IJT | ETF | 21.2734 | 21.2734 | 21.2734 | 21.2734 | 400.0 |
| 2000-09-29 | IUSV | ETF | 24.6094 | 24.6094 | 24.6094 | 24.6094 | 900.0 |
| 2000-09-29 | IVE | ETF | 63.125 | 63.5625 | 62.9531 | 63.0938 | 9100.0 |
| 2000-09-29 | IVV | ETF | 145.3594 | 145.4375 | 143.7031 | 143.7031 | 60400.0 |
| 2000-09-29 | IVW | ETF | 21.043 | 21.0547 | 20.6875 | 20.7422 | 18400.0 |
| 2000-09-29 | IWB | ETF | 78.02 | 78.08 | 77.56 | 77.56 | 3200.0 |
| 2000-09-29 | IWD | ETF | 58.1562 | 58.5 | 58.0312 | 58.0312 | 26600.0 |
> showing 50 of 83 rows — these rows as CSV