PREVIEW / etf_daily / 2000-10-24
file: by_date/etf_daily/2000/2000-10-24.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-10-24 | SPY | ETF | 140.9688 | 141.9375 | 139.0 | 139.5938 | 5750700.0 |
| 2000-10-24 | QQQ | ETF | 86.4375 | 87.0 | 82.375 | 82.4375 | 31466200.0 |
| 2000-10-24 | IWM | ETF | 49.2188 | 49.5312 | 48.3438 | 48.3438 | 73800.0 |
| 2000-10-24 | DIA | ETF | 103.25 | 104.3594 | 102.8438 | 103.4375 | 1545400.0 |
| 2000-10-24 | BBH | ETF | 62.3333 | 62.8125 | 60.3125 | 60.4792 | 2393100.0 |
| 2000-10-24 | BITS | ETF | 10.0 | 10.75 | 9.0 | 10.0 | 12900.0 |
| 2000-10-24 | BOSS | ETF | 24.0 | 24.5 | 24.0 | 24.5 | 300.0 |
| 2000-10-24 | CEF | ETF | 3.0625 | 3.125 | 3.0625 | 3.125 | 43600.0 |
| 2000-10-24 | CHB | ETF | 3.38 | 3.5 | 3.19 | 3.31 | 48400.0 |
| 2000-10-24 | CNXT | ETF | 26.45 | 26.56 | 24.5 | 25.44 | 7939370.0 |
| 2000-10-24 | EWA | ETF | 9.25 | 9.25 | 9.0625 | 9.0625 | 11300.0 |
| 2000-10-24 | EWC | ETF | 16.1875 | 16.25 | 16.0 | 16.0 | 30200.0 |
| 2000-10-24 | EWD | ETF | 19.75 | 20.0625 | 19.75 | 19.75 | 7800.0 |
| 2000-10-24 | EWG | ETF | 17.8125 | 18.4375 | 17.8125 | 18.375 | 207600.0 |
| 2000-10-24 | EWH | ETF | 11.1875 | 11.3125 | 11.125 | 11.1875 | 78000.0 |
| 2000-10-24 | EWI | ETF | 41.375 | 41.875 | 41.375 | 41.5 | 4850.0 |
| 2000-10-24 | EWJ | ETF | 50.5 | 51.0 | 50.5 | 50.75 | 36900.0 |
| 2000-10-24 | EWK | ETF | 12.0 | 12.0 | 11.875 | 11.875 | 6400.0 |
| 2000-10-24 | EWL | ETF | 14.875 | 14.875 | 14.5625 | 14.5625 | 35100.0 |
| 2000-10-24 | EWM | ETF | 22.75 | 23.5 | 22.75 | 23.25 | 30750.0 |
| 2000-10-24 | EWN | ETF | 22.9375 | 23.0625 | 21.8125 | 21.8125 | 400.0 |
| 2000-10-24 | EWO | ETF | 6.875 | 6.875 | 6.875 | 6.875 | 400.0 |
| 2000-10-24 | EWP | ETF | 23.0625 | 23.0625 | 22.9375 | 22.9375 | 4500.0 |
| 2000-10-24 | EWQ | ETF | 22.875 | 23.625 | 22.875 | 23.4375 | 54300.0 |
| 2000-10-24 | EWS | ETF | 13.0 | 13.125 | 12.875 | 13.0 | 18800.0 |
| 2000-10-24 | EWT | ETF | 26.25 | 26.875 | 26.25 | 26.625 | 38550.0 |
| 2000-10-24 | EWU | ETF | 35.375 | 35.75 | 35.375 | 35.625 | 21700.0 |
| 2000-10-24 | EWW | ETF | 14.4375 | 14.75 | 14.4375 | 14.5 | 11700.0 |
| 2000-10-24 | EWY | ETF | 14.25 | 14.4375 | 14.0625 | 14.4375 | 20700.0 |
| 2000-10-24 | EZU | ETF | 34.4375 | 34.4375 | 34.4375 | 34.4375 | 400.0 |
| 2000-10-24 | FCTR | ETF | 15.25 | 15.5938 | 15.25 | 15.5625 | 30200.0 |
| 2000-10-24 | FMAR | ETF | 4.88 | 5.25 | 4.78 | 4.78 | 1200.0 |
| 2000-10-24 | GLDB | ETF | 3.9375 | 4.0 | 3.8125 | 3.8125 | 51500.0 |
| 2000-10-24 | GSIG | ETF | 12.87 | 12.94 | 11.25 | 12.25 | 444600.0 |
| 2000-10-24 | IDU | ETF | 41.5938 | 41.5938 | 40.8125 | 40.8125 | 26800.0 |
| 2000-10-24 | IEV | ETF | 36.75 | 36.75 | 36.7188 | 36.75 | 15000.0 |
| 2000-10-24 | IGLD | ETF | 318.75 | 337.5 | 318.75 | 325.0 | 372.0 |
| 2000-10-24 | IJH | ETF | 10.3406 | 10.3406 | 10.1984 | 10.2281 | 639000.0 |
| 2000-10-24 | IJJ | ETF | 18.9766 | 18.9883 | 18.875 | 18.8828 | 42000.0 |
| 2000-10-24 | IJK | ETF | 17.3477 | 17.3477 | 17.0586 | 17.084 | 80000.0 |
| 2000-10-24 | IJR | ETF | 17.5651 | 17.5886 | 17.5391 | 17.5886 | 311400.0 |
| 2000-10-24 | IJS | ETF | 17.2969 | 17.2969 | 17.2031 | 17.2031 | 1600.0 |
| 2000-10-24 | IJT | ETF | 20.5625 | 20.5625 | 20.5469 | 20.5469 | 1600.0 |
| 2000-10-24 | IUSG | ETF | 31.4531 | 31.5 | 31.4531 | 31.5 | 2000.0 |
| 2000-10-24 | IVE | ETF | 61.625 | 62.125 | 61.5 | 61.75 | 10800.0 |
| 2000-10-24 | IVV | ETF | 140.9219 | 141.875 | 139.2344 | 139.5781 | 51700.0 |
| 2000-10-24 | IVW | ETF | 20.2617 | 20.3906 | 19.875 | 19.8906 | 148000.0 |
| 2000-10-24 | IWB | ETF | 75.48 | 75.76 | 74.4 | 74.4 | 6900.0 |
| 2000-10-24 | IWD | ETF | 57.0625 | 57.2031 | 56.7031 | 56.7031 | 15600.0 |
| 2000-10-24 | IWF | ETF | 19.9453 | 19.9453 | 19.4336 | 19.4453 | 10800.0 |
> showing 50 of 83 rows — these rows as CSV