PREVIEW / etf_daily / 2001-07-24
file: by_date/etf_daily/2001/2001-07-24.parquet size: 8 KB rows: 96
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-07-24 | SPY | ETF | 119.0 | 119.2 | 116.75 | 117.8 | 12269000.0 |
| 2001-07-24 | QQQ | ETF | 40.381 | 40.9 | 39.31 | 40.15 | 70428900.0 |
| 2001-07-24 | IWM | ETF | 48.0 | 48.175 | 46.9 | 47.35 | 588200.0 |
| 2001-07-24 | DIA | ETF | 103.8 | 104.17 | 102.0 | 102.65 | 2675700.0 |
| 2001-07-24 | BBH | ETF | 38.1333 | 38.2333 | 36.8333 | 37.4033 | 5514900.0 |
| 2001-07-24 | BITS | ETF | 14.0 | 14.4 | 13.8 | 13.92 | 4950.0 |
| 2001-07-24 | CEF | ETF | 3.1 | 3.13 | 3.05 | 3.13 | 17200.0 |
| 2001-07-24 | CHB | ETF | 11.68 | 11.9 | 10.9 | 10.99 | 400300.0 |
| 2001-07-24 | CNXT | ETF | 8.32 | 8.71 | 8.07 | 8.19 | 2441100.0 |
| 2001-07-24 | DGT | ETF | 68.2 | 68.2 | 67.45 | 67.45 | 800.0 |
| 2001-07-24 | EWA | ETF | 9.37 | 9.38 | 9.37 | 9.38 | 15900.0 |
| 2001-07-24 | EWC | ETF | 11.3 | 11.3 | 11.1 | 11.1 | 2300.0 |
| 2001-07-24 | EWG | ETF | 16.0 | 16.16 | 15.9 | 15.99 | 51800.0 |
| 2001-07-24 | EWH | ETF | 9.59 | 9.7 | 9.44 | 9.44 | 22800.0 |
| 2001-07-24 | EWI | ETF | 35.24 | 35.5 | 35.24 | 35.5 | 300.0 |
| 2001-07-24 | EWJ | ETF | 37.32 | 37.32 | 36.84 | 36.88 | 93475.0 |
| 2001-07-24 | EWL | ETF | 13.2 | 13.2 | 12.9 | 12.9 | 2900.0 |
| 2001-07-24 | EWM | ETF | 18.36 | 18.36 | 18.04 | 18.32 | 1625.0 |
| 2001-07-24 | EWN | ETF | 18.64 | 18.64 | 18.48 | 18.48 | 900.0 |
| 2001-07-24 | EWO | ETF | 8.28 | 8.28 | 8.25 | 8.28 | 4800.0 |
| 2001-07-24 | EWP | ETF | 20.4 | 20.69 | 20.4 | 20.45 | 7800.0 |
| 2001-07-24 | EWQ | ETF | 19.23 | 19.28 | 19.19 | 19.19 | 3300.0 |
| 2001-07-24 | EWS | ETF | 9.82 | 9.94 | 9.82 | 9.94 | 20550.0 |
| 2001-07-24 | EWT | ETF | 16.62 | 16.62 | 16.4 | 16.4 | 12700.0 |
| 2001-07-24 | EWU | ETF | 29.6 | 30.08 | 29.52 | 29.58 | 51900.0 |
| 2001-07-24 | EWW | ETF | 15.45 | 15.58 | 15.35 | 15.38 | 13500.0 |
| 2001-07-24 | EWY | ETF | 12.7 | 12.7 | 12.3 | 12.3 | 1200.0 |
| 2001-07-24 | EWZ | ETF | 12.87 | 13.1 | 12.85 | 12.9 | 3900.0 |
| 2001-07-24 | EZU | ETF | 28.62 | 29.2 | 28.61 | 28.61 | 53200.0 |
| 2001-07-24 | FCTR | ETF | 18.0 | 18.15 | 17.9 | 17.9 | 5100.0 |
| 2001-07-24 | FMAR | ETF | 9.5 | 9.5 | 9.03 | 9.15 | 6200.0 |
| 2001-07-24 | GLDB | ETF | 7.46 | 7.65 | 7.45 | 7.6 | 78300.0 |
| 2001-07-24 | GSIG | ETF | 7.5 | 7.6 | 7.15 | 7.25 | 384000.0 |
| 2001-07-24 | IBB | ETF | 28.6333 | 28.6333 | 27.2167 | 27.5667 | 926700.0 |
| 2001-07-24 | ICF | ETF | 21.175 | 21.175 | 20.89 | 20.89 | 113200.0 |
| 2001-07-24 | IDU | ETF | 36.4 | 36.435 | 35.24 | 35.36 | 28800.0 |
| 2001-07-24 | IEV | ETF | 30.475 | 30.485 | 30.01 | 30.09 | 46000.0 |
| 2001-07-24 | IGLD | ETF | 70.0 | 70.0 | 70.0 | 70.0 | 13.0 |
| 2001-07-24 | IGM | ETF | 8.7917 | 8.7917 | 8.6833 | 8.7167 | 37200.0 |
| 2001-07-24 | IGV | ETF | 9.224 | 9.31 | 9.224 | 9.31 | 250000.0 |
| 2001-07-24 | IJH | ETF | 10.07 | 10.07 | 9.852 | 9.884 | 676000.0 |
| 2001-07-24 | IJJ | ETF | 22.355 | 22.375 | 21.9125 | 21.985 | 156000.0 |
| 2001-07-24 | IJK | ETF | 14.035 | 14.035 | 13.7312 | 13.7862 | 60000.0 |
| 2001-07-24 | IJR | ETF | 18.6733 | 18.6733 | 18.2817 | 18.3583 | 805200.0 |
| 2001-07-24 | IJS | ETF | 20.875 | 20.93 | 20.505 | 20.61 | 106800.0 |
| 2001-07-24 | IJT | ETF | 18.6775 | 18.6775 | 18.2825 | 18.3825 | 91600.0 |
| 2001-07-24 | IOO | ETF | 30.025 | 30.025 | 29.555 | 29.67 | 44000.0 |
| 2001-07-24 | IUSG | ETF | 20.84 | 20.84 | 20.59 | 20.59 | 88400.0 |
| 2001-07-24 | IUSV | ETF | 24.4467 | 24.46 | 24.13 | 24.13 | 9300.0 |
| 2001-07-24 | IVE | ETF | 59.57 | 59.57 | 58.15 | 58.32 | 53900.0 |
> showing 50 of 96 rows — these rows as CSV