PREVIEW / etf_daily / 2001-04-05
file: by_date/etf_daily/2001/2001-04-05.parquet size: 8 KB rows: 97
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-04-05 | SPY | ETF | 113.3 | 115.49 | 112.5 | 115.05 | 21522800.0 |
| 2001-04-05 | QQQ | ETF | 36.0 | 37.96 | 35.71 | 37.31 | 87035800.0 |
| 2001-04-05 | IWM | ETF | 43.0 | 44.45 | 43.0 | 44.45 | 950000.0 |
| 2001-04-05 | DIA | ETF | 97.24 | 99.49 | 97.1 | 99.39 | 5670100.0 |
| 2001-04-05 | BBH | ETF | 35.5333 | 36.5333 | 34.3833 | 36.5 | 5903400.0 |
| 2001-04-05 | BITS | ETF | 7.0 | 7.25 | 6.875 | 7.25 | 3300.0 |
| 2001-04-05 | CEF | ETF | 3.09 | 3.09 | 3.04 | 3.04 | 6400.0 |
| 2001-04-05 | CHB | ETF | 5.01 | 5.1 | 4.9 | 5.1 | 296600.0 |
| 2001-04-05 | CNXT | ETF | 7.94 | 8.13 | 7.44 | 8.0 | 7139920.0 |
| 2001-04-05 | CSB | ETF | 1.5 | 1.5 | 1.5 | 1.5 | 39000.0 |
| 2001-04-05 | DGT | ETF | 68.05 | 68.05 | 68.05 | 68.05 | 100.0 |
| 2001-04-05 | EWA | ETF | 8.65 | 8.69 | 8.65 | 8.69 | 6400.0 |
| 2001-04-05 | EWC | ETF | 10.75 | 10.9 | 10.75 | 10.9 | 1200.0 |
| 2001-04-05 | EWD | ETF | 13.65 | 14.0 | 13.6 | 14.0 | 30400.0 |
| 2001-04-05 | EWG | ETF | 16.72 | 16.9 | 16.6 | 16.88 | 31000.0 |
| 2001-04-05 | EWH | ETF | 10.16 | 10.7 | 10.16 | 10.69 | 72200.0 |
| 2001-04-05 | EWI | ETF | 39.4 | 39.46 | 39.34 | 39.46 | 15350.0 |
| 2001-04-05 | EWJ | ETF | 42.88 | 43.4 | 42.48 | 43.2 | 167175.0 |
| 2001-04-05 | EWK | ETF | 12.0 | 12.0 | 11.8 | 11.8 | 18400.0 |
| 2001-04-05 | EWL | ETF | 14.05 | 14.2 | 13.91 | 13.95 | 15100.0 |
| 2001-04-05 | EWM | ETF | 17.0 | 19.84 | 17.0 | 17.36 | 385875.0 |
| 2001-04-05 | EWN | ETF | 19.85 | 20.1 | 19.85 | 19.87 | 23900.0 |
| 2001-04-05 | EWP | ETF | 23.4 | 23.9 | 23.4 | 23.65 | 46000.0 |
| 2001-04-05 | EWQ | ETF | 20.72 | 21.0 | 20.61 | 20.94 | 15200.0 |
| 2001-04-05 | EWS | ETF | 10.8 | 11.2 | 10.62 | 11.18 | 24650.0 |
| 2001-04-05 | EWT | ETF | 22.46 | 23.28 | 22.46 | 23.28 | 17800.0 |
| 2001-04-05 | EWU | ETF | 32.1 | 32.2 | 31.3 | 32.2 | 12000.0 |
| 2001-04-05 | EWW | ETF | 14.15 | 14.2 | 14.0 | 14.0 | 20700.0 |
| 2001-04-05 | EWY | ETF | 11.2 | 11.6 | 11.16 | 11.6 | 2800.0 |
| 2001-04-05 | EWZ | ETF | 14.8 | 14.98 | 14.76 | 14.98 | 21800.0 |
| 2001-04-05 | EZU | ETF | 31.125 | 31.375 | 30.9531 | 31.375 | 16400.0 |
| 2001-04-05 | FCTR | ETF | 15.0938 | 15.625 | 15.0625 | 15.625 | 22700.0 |
| 2001-04-05 | FMAR | ETF | 5.0 | 5.5 | 5.0 | 5.5 | 3200.0 |
| 2001-04-05 | GLDB | ETF | 6.875 | 6.9375 | 6.75 | 6.8125 | 160700.0 |
| 2001-04-05 | GSIG | ETF | 7.31 | 7.75 | 7.31 | 7.5 | 165600.0 |
| 2001-04-05 | IBB | ETF | 23.3333 | 24.3646 | 23.1667 | 24.3281 | 33600.0 |
| 2001-04-05 | ICF | ETF | 19.4961 | 19.5 | 19.4961 | 19.5 | 60800.0 |
| 2001-04-05 | IDU | ETF | 40.0 | 40.15 | 39.945 | 40.15 | 4800.0 |
| 2001-04-05 | IEV | ETF | 32.15 | 32.6 | 31.75 | 32.5 | 85400.0 |
| 2001-04-05 | IGLD | ETF | 96.875 | 106.25 | 87.5 | 87.5 | 454.0 |
| 2001-04-05 | IGM | ETF | 8.0667 | 8.0667 | 8.0667 | 8.0667 | 3000.0 |
| 2001-04-05 | IJH | ETF | 8.879 | 9.11 | 8.856 | 9.081 | 349000.0 |
| 2001-04-05 | IJJ | ETF | 20.0125 | 20.4875 | 20.0125 | 20.48 | 71600.0 |
| 2001-04-05 | IJK | ETF | 12.0788 | 12.4688 | 12.0625 | 12.45 | 68800.0 |
| 2001-04-05 | IJR | ETF | 16.225 | 16.7317 | 16.225 | 16.7317 | 280800.0 |
| 2001-04-05 | IJS | ETF | 18.25 | 18.73 | 18.2375 | 18.71 | 141200.0 |
| 2001-04-05 | IJT | ETF | 16.1375 | 16.7225 | 16.1375 | 16.7225 | 34800.0 |
| 2001-04-05 | IOO | ETF | 30.2734 | 30.7031 | 30.0625 | 30.6484 | 267800.0 |
| 2001-04-05 | IUSG | ETF | 19.365 | 20.09 | 19.365 | 20.0 | 7600.0 |
| 2001-04-05 | IUSV | ETF | 23.36 | 23.6067 | 23.36 | 23.6067 | 25800.0 |
> showing 50 of 97 rows — these rows as CSV