PREVIEW / etf_daily / 2001-01-24
file: by_date/etf_daily/2001/2001-01-24.parquet size: 8 KB rows: 93
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-24 | SPY | ETF | 136.25 | 137.3125 | 135.8438 | 136.375 | 6199900.0 |
| 2001-01-24 | QQQ | ETF | 68.0625 | 69.125 | 66.75 | 67.125 | 53937500.0 |
| 2001-01-24 | IWM | ETF | 50.25 | 50.4062 | 49.8125 | 50.0 | 938800.0 |
| 2001-01-24 | DIA | ETF | 106.5312 | 106.9688 | 106.2188 | 106.3438 | 634400.0 |
| 2001-01-24 | BBH | ETF | 51.9167 | 53.7917 | 51.8333 | 53.0 | 3164100.0 |
| 2001-01-24 | BITS | ETF | 12.0 | 13.0 | 12.0 | 12.25 | 5800.0 |
| 2001-01-24 | CEF | ETF | 3.125 | 3.125 | 3.0625 | 3.125 | 63500.0 |
| 2001-01-24 | CHB | ETF | 6.5 | 7.0 | 6.44 | 6.81 | 172600.0 |
| 2001-01-24 | CNXT | ETF | 18.842 | 19.906 | 18.404 | 19.718 | 5080460.0 |
| 2001-01-24 | CSB | ETF | 1.07000005245209 | 1.07000005245209 | 1.07000005245209 | 1.07000005245209 | 300.0 |
| 2001-01-24 | DGT | ETF | 79.8125 | 79.8125 | 79.625 | 79.625 | 2300.0 |
| 2001-01-24 | EWA | ETF | 9.625 | 9.625 | 9.5 | 9.625 | 6800.0 |
| 2001-01-24 | EWC | ETF | 13.9375 | 14.0625 | 13.75 | 14.0 | 62000.0 |
| 2001-01-24 | EWD | ETF | 19.25 | 19.25 | 19.0625 | 19.125 | 2600.0 |
| 2001-01-24 | EWG | ETF | 20.0625 | 20.0625 | 19.875 | 19.875 | 237400.0 |
| 2001-01-24 | EWH | ETF | 12.3125 | 12.4375 | 12.3125 | 12.375 | 60000.0 |
| 2001-01-24 | EWI | ETF | 45.5 | 45.625 | 45.125 | 45.25 | 10250.0 |
| 2001-01-24 | EWJ | ETF | 43.75 | 44.0 | 43.5 | 43.75 | 87250.0 |
| 2001-01-24 | EWK | ETF | 12.875 | 12.875 | 12.875 | 12.875 | 21000.0 |
| 2001-01-24 | EWL | ETF | 16.125 | 16.3125 | 16.125 | 16.1875 | 3700.0 |
| 2001-01-24 | EWM | ETF | 21.5 | 22.0 | 21.5 | 21.5 | 1700.0 |
| 2001-01-24 | EWN | ETF | 22.8125 | 22.8125 | 22.6875 | 22.6875 | 14300.0 |
| 2001-01-24 | EWO | ETF | 7.75 | 7.75 | 7.75 | 7.75 | 2800.0 |
| 2001-01-24 | EWP | ETF | 25.3125 | 25.625 | 25.3125 | 25.5625 | 40800.0 |
| 2001-01-24 | EWQ | ETF | 24.1875 | 24.1875 | 24.0 | 24.0625 | 76800.0 |
| 2001-01-24 | EWS | ETF | 12.875 | 13.0 | 12.625 | 13.0 | 21450.0 |
| 2001-01-24 | EWT | ETF | 26.5 | 27.5 | 26.5 | 27.125 | 3600.0 |
| 2001-01-24 | EWU | ETF | 35.75 | 35.75 | 35.125 | 35.25 | 14700.0 |
| 2001-01-24 | EWW | ETF | 14.9375 | 15.125 | 14.8125 | 14.875 | 69000.0 |
| 2001-01-24 | EWY | ETF | 16.0 | 16.0 | 15.875 | 15.9375 | 10900.0 |
| 2001-01-24 | EWZ | ETF | 18.875 | 19.0 | 18.625 | 18.625 | 1800.0 |
| 2001-01-24 | EZU | ETF | 36.625 | 36.625 | 36.1562 | 36.4062 | 12400.0 |
| 2001-01-24 | FCTR | ETF | 15.125 | 15.125 | 14.5625 | 14.625 | 4100.0 |
| 2001-01-24 | FMAR | ETF | 5.5 | 5.62 | 5.5 | 5.62 | 2000.0 |
| 2001-01-24 | GLDB | ETF | 5.3125 | 5.5 | 5.3125 | 5.4375 | 22700.0 |
| 2001-01-24 | GSIG | ETF | 12.14 | 12.5 | 11.5 | 11.94 | 165900.0 |
| 2001-01-24 | IDU | ETF | 40.375 | 40.375 | 40.0 | 40.0 | 6800.0 |
| 2001-01-24 | IEV | ETF | 37.5 | 37.5234 | 37.2812 | 37.5 | 63200.0 |
| 2001-01-24 | IGLD | ETF | 275.0 | 287.5 | 265.625 | 265.625 | 428.0 |
| 2001-01-24 | IJH | ETF | 10.4031 | 10.4781 | 10.3891 | 10.4047 | 720000.0 |
| 2001-01-24 | IJJ | ETF | 21.8828 | 22.0352 | 21.8203 | 21.9141 | 129200.0 |
| 2001-01-24 | IJK | ETF | 15.3125 | 15.4726 | 15.3125 | 15.3184 | 44800.0 |
| 2001-01-24 | IJR | ETF | 18.7396 | 18.8125 | 18.6458 | 18.6875 | 1232400.0 |
| 2001-01-24 | IJS | ETF | 20.3438 | 20.4844 | 20.3281 | 20.3984 | 201600.0 |
| 2001-01-24 | IJT | ETF | 19.5 | 19.5156 | 19.3906 | 19.4766 | 42800.0 |
| 2001-01-24 | IOO | ETF | 35.875 | 36.0156 | 35.8672 | 35.8672 | 2800.0 |
| 2001-01-24 | IUSG | ETF | 27.9375 | 28.0625 | 27.75 | 27.8594 | 14400.0 |
| 2001-01-24 | IUSV | ETF | 24.9792 | 25.0625 | 24.9479 | 25.0313 | 3000.0 |
| 2001-01-24 | IVE | ETF | 65.1875 | 65.7812 | 65.1875 | 65.4844 | 28800.0 |
| 2001-01-24 | IVV | ETF | 135.9375 | 137.125 | 135.9375 | 136.5469 | 204800.0 |
> showing 50 of 93 rows — these rows as CSV