PREVIEW / etf_daily / 2000-11-24
file: by_date/etf_daily/2000/2000-11-24.parquet size: 8 KB rows: 77
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-11-24 | SPY | ETF | 133.625 | 134.9688 | 133.625 | 134.8438 | 3411600.0 |
| 2000-11-24 | QQQ | ETF | 68.375 | 70.625 | 68.1719 | 70.4375 | 19987900.0 |
| 2000-11-24 | IWM | ETF | 46.2109 | 47.0938 | 46.0938 | 46.9375 | 82200.0 |
| 2000-11-24 | DIA | ETF | 104.9844 | 105.25 | 104.5625 | 105.0625 | 535800.0 |
| 2000-11-24 | BBH | ETF | 52.9167 | 55.3333 | 52.875 | 55.2917 | 1731000.0 |
| 2000-11-24 | BITS | ETF | 9.0 | 9.0 | 8.5 | 8.75 | 3600.0 |
| 2000-11-24 | CEF | ETF | 3.0 | 3.0 | 3.0 | 3.0 | 2400.0 |
| 2000-11-24 | CHB | ETF | 3.31 | 3.44 | 3.25 | 3.38 | 24000.0 |
| 2000-11-24 | CNXT | ETF | 27.06 | 29.0 | 26.62 | 28.94 | 1139200.0 |
| 2000-11-24 | CSB | ETF | 1.0 | 1.0 | 1.0 | 1.0 | 18000.0 |
| 2000-11-24 | DGT | ETF | 80.5625 | 80.8125 | 80.4688 | 80.4688 | 900.0 |
| 2000-11-24 | EWA | ETF | 9.0625 | 9.125 | 9.0625 | 9.0625 | 23100.0 |
| 2000-11-24 | EWC | ETF | 13.5625 | 13.5625 | 13.5625 | 13.5625 | 1100.0 |
| 2000-11-24 | EWD | ETF | 17.25 | 17.75 | 17.25 | 17.75 | 12800.0 |
| 2000-11-24 | EWG | ETF | 18.1875 | 18.375 | 18.125 | 18.125 | 16500.0 |
| 2000-11-24 | EWH | ETF | 11.125 | 11.1875 | 11.0625 | 11.1875 | 37300.0 |
| 2000-11-24 | EWI | ETF | 43.625 | 43.625 | 43.375 | 43.5 | 1000.0 |
| 2000-11-24 | EWJ | ETF | 47.25 | 47.5 | 47.0 | 47.0 | 42000.0 |
| 2000-11-24 | EWK | ETF | 11.8125 | 11.875 | 11.8125 | 11.875 | 18500.0 |
| 2000-11-24 | EWL | ETF | 14.75 | 15.0 | 14.75 | 14.9375 | 11800.0 |
| 2000-11-24 | EWN | ETF | 21.6875 | 21.6875 | 21.4375 | 21.5 | 6400.0 |
| 2000-11-24 | EWO | ETF | 7.0625 | 7.125 | 7.0625 | 7.125 | 5700.0 |
| 2000-11-24 | EWP | ETF | 21.3125 | 21.4375 | 21.3125 | 21.4375 | 300.0 |
| 2000-11-24 | EWQ | ETF | 22.9375 | 23.0 | 22.875 | 23.0 | 7000.0 |
| 2000-11-24 | EWS | ETF | 13.125 | 13.25 | 13.125 | 13.25 | 22450.0 |
| 2000-11-24 | EWU | ETF | 34.125 | 34.25 | 33.75 | 34.0 | 22700.0 |
| 2000-11-24 | EWW | ETF | 14.9375 | 15.125 | 14.9375 | 15.0 | 11400.0 |
| 2000-11-24 | EWY | ETF | 13.5 | 13.5 | 13.5 | 13.5 | 2000.0 |
| 2000-11-24 | EZU | ETF | 34.2812 | 34.4375 | 34.2812 | 34.375 | 10600.0 |
| 2000-11-24 | FCTR | ETF | 14.5 | 14.5625 | 14.3125 | 14.5625 | 8800.0 |
| 2000-11-24 | FMAR | ETF | 4.38 | 4.38 | 4.38 | 4.38 | 900.0 |
| 2000-11-24 | GLDB | ETF | 4.3125 | 4.3125 | 4.0 | 4.0625 | 40700.0 |
| 2000-11-24 | GSIG | ETF | 11.66 | 12.37 | 11.44 | 12.37 | 153300.0 |
| 2000-11-24 | IDU | ETF | 41.6562 | 41.75 | 41.6562 | 41.75 | 6800.0 |
| 2000-11-24 | IEV | ETF | 36.25 | 36.3438 | 36.1562 | 36.25 | 28000.0 |
| 2000-11-24 | IGLD | ETF | 268.75 | 271.875 | 237.5 | 250.0 | 344.0 |
| 2000-11-24 | IJH | ETF | 9.8547 | 10.0109 | 9.8406 | 10.0 | 49000.0 |
| 2000-11-24 | IJJ | ETF | 19.4805 | 19.5391 | 19.4805 | 19.5391 | 4400.0 |
| 2000-11-24 | IJK | ETF | 15.6094 | 15.9688 | 15.6094 | 15.9668 | 30400.0 |
| 2000-11-24 | IJR | ETF | 17.0104 | 17.3229 | 17.0104 | 17.3229 | 79800.0 |
| 2000-11-24 | IJS | ETF | 17.5 | 17.5 | 17.5 | 17.5 | 2000.0 |
| 2000-11-24 | IJT | ETF | 19.2266 | 19.2266 | 19.211 | 19.211 | 6400.0 |
| 2000-11-24 | IUSV | ETF | 24.0625 | 24.1146 | 24.0625 | 24.1146 | 1200.0 |
| 2000-11-24 | IVE | ETF | 60.8125 | 61.2188 | 60.8125 | 61.0 | 5200.0 |
| 2000-11-24 | IVV | ETF | 133.9375 | 134.7656 | 133.8125 | 134.5625 | 41300.0 |
| 2000-11-24 | IVW | ETF | 18.5156 | 18.625 | 18.5156 | 18.5938 | 65600.0 |
| 2000-11-24 | IWB | ETF | 71.06 | 71.14 | 70.9 | 71.12 | 10000.0 |
| 2000-11-24 | IWD | ETF | 56.9531 | 56.9844 | 56.9375 | 56.9375 | 2700.0 |
| 2000-11-24 | IWF | ETF | 17.5703 | 17.71875 | 17.5703 | 17.71875 | 6000.0 |
| 2000-11-24 | IWN | ETF | 35.4792 | 35.6667 | 35.4792 | 35.6042 | 3300.0 |
> showing 50 of 77 rows — these rows as CSV