PREVIEW / etf_daily / 2001-11-21
file: by_date/etf_daily/2001/2001-11-21.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2001-11-21 | SPY | ETF | 114.5 | 114.67 | 113.51 | 114.04 | 11470200.0 |
| 2001-11-21 | QQQ | ETF | 38.47 | 38.95 | 37.98 | 38.64 | 60867900.0 |
| 2001-11-21 | IWM | ETF | 45.15 | 45.225 | 44.68 | 45.085 | 384800.0 |
| 2001-11-21 | DIA | ETF | 99.1 | 99.1 | 98.12 | 98.4 | 3219200.0 |
| 2001-11-21 | ARB | ETF | 29.3 | 29.85 | 29.27 | 29.84 | 146500.0 |
| 2001-11-21 | BBH | ETF | 44.8333 | 45.0 | 44.18 | 44.5267 | 1976700.0 |
| 2001-11-21 | BITS | ETF | 19.08 | 19.6792 | 19.08 | 19.6 | 4500.0 |
| 2001-11-21 | CEF | ETF | 3.3 | 3.3 | 3.25 | 3.25 | 17100.0 |
| 2001-11-21 | CHB | ETF | 11.05 | 11.06 | 10.32 | 10.82 | 411000.0 |
| 2001-11-21 | CNXT | ETF | 12.41 | 13.1 | 12.02 | 12.81 | 5743010.0 |
| 2001-11-21 | DGT | ETF | 67.2 | 67.2 | 66.86 | 67.06 | 1500.0 |
| 2001-11-21 | EFA | ETF | 39.9333 | 39.9333 | 39.6633 | 39.8133 | 143100.0 |
| 2001-11-21 | ELV | ETF | 24.35 | 24.85 | 24.205 | 24.505 | 1342000.0 |
| 2001-11-21 | EPP | ETF | 17.6667 | 17.7 | 17.62 | 17.62 | 12000.0 |
| 2001-11-21 | EWA | ETF | 9.2 | 9.4 | 9.2 | 9.39 | 10100.0 |
| 2001-11-21 | EWC | ETF | 10.3 | 10.3 | 10.3 | 10.3 | 1900.0 |
| 2001-11-21 | EWG | ETF | 14.4 | 14.44 | 14.31 | 14.31 | 133600.0 |
| 2001-11-21 | EWH | ETF | 8.86 | 8.97 | 8.73 | 8.88 | 23100.0 |
| 2001-11-21 | EWI | ETF | 32.18 | 32.3 | 32.18 | 32.3 | 1500.0 |
| 2001-11-21 | EWJ | ETF | 33.6 | 34.04 | 33.6 | 33.92 | 215025.0 |
| 2001-11-21 | EWL | ETF | 12.9 | 12.94 | 12.84 | 12.94 | 11500.0 |
| 2001-11-21 | EWM | ETF | 18.4 | 18.8 | 18.4 | 18.8 | 4650.0 |
| 2001-11-21 | EWN | ETF | 16.7 | 16.7 | 16.7 | 16.7 | 13000.0 |
| 2001-11-21 | EWP | ETF | 20.5 | 20.5 | 20.5 | 20.5 | 100.0 |
| 2001-11-21 | EWQ | ETF | 18.3 | 18.3 | 17.91 | 18.15 | 10600.0 |
| 2001-11-21 | EWS | ETF | 9.04 | 9.16 | 8.96 | 9.02 | 5500.0 |
| 2001-11-21 | EWT | ETF | 18.3 | 18.3 | 17.66 | 18.26 | 34200.0 |
| 2001-11-21 | EWU | ETF | 29.64 | 29.64 | 29.28 | 29.62 | 2450.0 |
| 2001-11-21 | EWW | ETF | 13.61 | 13.85 | 13.61 | 13.67 | 20200.0 |
| 2001-11-21 | EWY | ETF | 15.55 | 15.55 | 15.31 | 15.46 | 49900.0 |
| 2001-11-21 | EWZ | ETF | 11.15 | 11.15 | 10.95 | 10.95 | 65900.0 |
| 2001-11-21 | EZU | ETF | 27.125 | 27.125 | 26.88 | 27.12 | 27200.0 |
| 2001-11-21 | FCTR | ETF | 17.2 | 17.87 | 17.2 | 17.76 | 5200.0 |
| 2001-11-21 | FMAR | ETF | 8.18 | 8.18 | 8.05 | 8.15 | 2700.0 |
| 2001-11-21 | GLDB | ETF | 7.57 | 7.6 | 7.41 | 7.41 | 15000.0 |
| 2001-11-21 | GSIG | ETF | 8.57 | 8.65 | 8.01 | 8.25 | 224700.0 |
| 2001-11-21 | IBB | ETF | 30.4167 | 30.65 | 30.2167 | 30.4833 | 172200.0 |
| 2001-11-21 | ICF | ETF | 20.8825 | 20.8825 | 20.7975 | 20.825 | 10400.0 |
| 2001-11-21 | IDU | ETF | 31.97 | 31.98 | 31.435 | 31.98 | 21600.0 |
| 2001-11-21 | IEV | ETF | 29.375 | 29.375 | 29.0 | 29.325 | 99000.0 |
| 2001-11-21 | IGLD | ETF | 90.0 | 90.0 | 77.0 | 89.0 | 331.0 |
| 2001-11-21 | IGM | ETF | 8.3333 | 8.4083 | 8.2333 | 8.35 | 31200.0 |
| 2001-11-21 | IGN | ETF | 33.65 | 33.89 | 33.2 | 33.74 | 611500.0 |
| 2001-11-21 | IGV | ETF | 8.4 | 8.456 | 8.28 | 8.358 | 248500.0 |
| 2001-11-21 | IJH | ETF | 9.59 | 9.59 | 9.494 | 9.553 | 315000.0 |
| 2001-11-21 | IJJ | ETF | 21.3 | 21.3 | 21.04 | 21.2175 | 42800.0 |
| 2001-11-21 | IJK | ETF | 13.3862 | 13.3975 | 13.26 | 13.3788 | 86400.0 |
| 2001-11-21 | IJR | ETF | 17.75 | 17.75 | 17.5883 | 17.6667 | 264000.0 |
| 2001-11-21 | IJS | ETF | 19.6625 | 19.6625 | 19.4775 | 19.625 | 49600.0 |
| 2001-11-21 | IJT | ETF | 17.975 | 17.975 | 17.7875 | 17.875 | 64800.0 |
> showing 50 of 108 rows — these rows as CSV