PREVIEW / etf_daily / 2001-01-22
file: by_date/etf_daily/2001/2001-01-22.parquet size: 8 KB rows: 91
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-01-22 | SPY | ETF | 134.25 | 135.7812 | 133.5625 | 134.9062 | 7050900.0 |
| 2001-01-22 | QQQ | ETF | 65.875 | 67.0 | 64.75 | 66.375 | 35783800.0 |
| 2001-01-22 | IWM | ETF | 48.5 | 49.0938 | 48.2656 | 48.9688 | 237600.0 |
| 2001-01-22 | DIA | ETF | 105.75 | 106.4375 | 105.0625 | 106.125 | 851400.0 |
| 2001-01-22 | BBH | ETF | 50.0 | 50.625 | 49.1667 | 49.9375 | 5942700.0 |
| 2001-01-22 | BITS | ETF | 12.0 | 12.0 | 11.625 | 11.75 | 4850.0 |
| 2001-01-22 | BOSS | ETF | 25.0 | 25.0 | 25.0 | 25.0 | 100.0 |
| 2001-01-22 | CEF | ETF | 3.25 | 3.25 | 3.1875 | 3.25 | 10400.0 |
| 2001-01-22 | CHB | ETF | 6.5 | 6.69 | 6.44 | 6.56 | 308100.0 |
| 2001-01-22 | CNXT | ETF | 16.81 | 17.87 | 15.75 | 17.5 | 3349420.0 |
| 2001-01-22 | CSB | ETF | 1.04999995231628 | 1.04999995231628 | 1.04999995231628 | 1.04999995231628 | 700.0 |
| 2001-01-22 | DGT | ETF | 78.75 | 78.75 | 78.75 | 78.75 | 100.0 |
| 2001-01-22 | EWA | ETF | 9.8125 | 9.9375 | 9.75 | 9.875 | 5900.0 |
| 2001-01-22 | EWC | ETF | 13.8125 | 13.8125 | 13.6875 | 13.75 | 7100.0 |
| 2001-01-22 | EWD | ETF | 19.1875 | 19.5 | 19.125 | 19.5 | 16300.0 |
| 2001-01-22 | EWG | ETF | 19.875 | 20.125 | 19.875 | 20.125 | 23500.0 |
| 2001-01-22 | EWH | ETF | 12.375 | 12.4375 | 12.25 | 12.4375 | 24600.0 |
| 2001-01-22 | EWI | ETF | 45.25 | 45.75 | 45.25 | 45.75 | 1600.0 |
| 2001-01-22 | EWJ | ETF | 44.0 | 44.25 | 43.75 | 44.25 | 192025.0 |
| 2001-01-22 | EWL | ETF | 16.375 | 16.4375 | 16.25 | 16.4375 | 4900.0 |
| 2001-01-22 | EWM | ETF | 21.5 | 21.75 | 21.5 | 21.5 | 6575.0 |
| 2001-01-22 | EWN | ETF | 22.5 | 22.6875 | 22.5 | 22.6875 | 12300.0 |
| 2001-01-22 | EWO | ETF | 7.8125 | 7.8125 | 7.75 | 7.75 | 3600.0 |
| 2001-01-22 | EWP | ETF | 25.0 | 25.4375 | 24.875 | 25.375 | 15000.0 |
| 2001-01-22 | EWQ | ETF | 24.125 | 24.5 | 24.125 | 24.5 | 18800.0 |
| 2001-01-22 | EWS | ETF | 13.0 | 13.0 | 12.75 | 13.0 | 10300.0 |
| 2001-01-22 | EWT | ETF | 28.875 | 28.875 | 26.5 | 26.875 | 30050.0 |
| 2001-01-22 | EWU | ETF | 34.75 | 35.0 | 34.5 | 35.0 | 13350.0 |
| 2001-01-22 | EWW | ETF | 14.625 | 14.625 | 14.4375 | 14.625 | 22700.0 |
| 2001-01-22 | EWY | ETF | 15.25 | 15.4375 | 15.125 | 15.3125 | 10100.0 |
| 2001-01-22 | EWZ | ETF | 18.5625 | 18.5625 | 18.3125 | 18.3125 | 10600.0 |
| 2001-01-22 | EZU | ETF | 36.1875 | 36.75 | 36.1875 | 36.75 | 31400.0 |
| 2001-01-22 | FCTR | ETF | 15.6875 | 15.6875 | 14.6875 | 15.0 | 18600.0 |
| 2001-01-22 | FMAR | ETF | 5.62 | 5.6208 | 5.25 | 5.25 | 9200.0 |
| 2001-01-22 | GLDB | ETF | 5.25 | 5.5 | 5.1875 | 5.5 | 42600.0 |
| 2001-01-22 | GSIG | ETF | 12.78 | 12.92 | 12.0 | 12.06 | 331900.0 |
| 2001-01-22 | IDU | ETF | 38.7344 | 38.9688 | 38.4375 | 38.9375 | 52000.0 |
| 2001-01-22 | IEV | ETF | 37.5 | 37.9062 | 37.1875 | 37.4688 | 121600.0 |
| 2001-01-22 | IGLD | ETF | 284.375 | 284.375 | 268.75 | 268.75 | 310.0 |
| 2001-01-22 | IJH | ETF | 10.0656 | 10.1609 | 10.0656 | 10.1188 | 894000.0 |
| 2001-01-22 | IJJ | ETF | 21.2539 | 21.5 | 21.2539 | 21.4883 | 28000.0 |
| 2001-01-22 | IJK | ETF | 14.7148 | 14.875 | 14.7148 | 14.8125 | 233600.0 |
| 2001-01-22 | IJR | ETF | 18.1875 | 18.3386 | 18.1719 | 18.3386 | 291000.0 |
| 2001-01-22 | IJS | ETF | 19.9375 | 20.0312 | 19.8438 | 20.0312 | 30000.0 |
| 2001-01-22 | IJT | ETF | 18.9141 | 19.0 | 18.9141 | 18.9688 | 20800.0 |
| 2001-01-22 | IOO | ETF | 35.8906 | 35.9141 | 35.4531 | 35.5625 | 2200.0 |
| 2001-01-22 | IUSG | ETF | 27.2188 | 27.2188 | 27.2188 | 27.2188 | 200.0 |
| 2001-01-22 | IUSV | ETF | 24.7135 | 24.7135 | 24.7083 | 24.7083 | 3300.0 |
| 2001-01-22 | IVE | ETF | 64.5625 | 65.1094 | 64.25 | 64.8125 | 35400.0 |
| 2001-01-22 | IVV | ETF | 134.0781 | 135.5312 | 133.7656 | 134.5156 | 39500.0 |
> showing 50 of 91 rows — these rows as CSV