PREVIEW / etf_daily / 2001-06-21
file: by_date/etf_daily/2001/2001-06-21.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-06-21 | SPY | ETF | 122.22 | 124.31 | 122.15 | 123.82 | 12259100.0 |
| 2001-06-21 | QQQ | ETF | 42.67 | 44.23 | 42.3 | 43.35 | 67212600.0 |
| 2001-06-21 | IWM | ETF | 49.325 | 49.8 | 49.275 | 49.495 | 776800.0 |
| 2001-06-21 | DIA | ETF | 106.35 | 107.75 | 106.0 | 107.14 | 3673100.0 |
| 2001-06-21 | BBH | ETF | 45.0 | 46.33 | 44.8367 | 45.9333 | 6009900.0 |
| 2001-06-21 | BITS | ETF | 12.92 | 13.4 | 12.16 | 13.16 | 2475.0 |
| 2001-06-21 | CEF | ETF | 3.27 | 3.3 | 3.27 | 3.3 | 11700.0 |
| 2001-06-21 | CHB | ETF | 10.85 | 11.65 | 10.42 | 11.65 | 319400.0 |
| 2001-06-21 | CNXT | ETF | 7.2 | 7.83 | 7.05 | 7.83 | 1944850.0 |
| 2001-06-21 | CSB | ETF | 2.09999990463257 | 2.10999989509583 | 2.09999990463257 | 2.09999990463257 | 162000.0 |
| 2001-06-21 | DGT | ETF | 71.1 | 71.59 | 71.0 | 71.59 | 3600.0 |
| 2001-06-21 | EWA | ETF | 9.7 | 9.7 | 9.62 | 9.62 | 2900.0 |
| 2001-06-21 | EWC | ETF | 11.26 | 11.55 | 11.26 | 11.55 | 7700.0 |
| 2001-06-21 | EWD | ETF | 13.14 | 13.14 | 13.1 | 13.1 | 600.0 |
| 2001-06-21 | EWG | ETF | 16.06 | 16.25 | 16.05 | 16.16 | 17600.0 |
| 2001-06-21 | EWH | ETF | 10.2 | 10.33 | 10.16 | 10.33 | 33100.0 |
| 2001-06-21 | EWI | ETF | 35.02 | 35.3 | 34.7 | 35.3 | 5250.0 |
| 2001-06-21 | EWJ | ETF | 40.96 | 41.44 | 40.92 | 41.2 | 114325.0 |
| 2001-06-21 | EWL | ETF | 13.3 | 13.65 | 13.3 | 13.65 | 6000.0 |
| 2001-06-21 | EWM | ETF | 16.88 | 17.08 | 16.88 | 17.08 | 6575.0 |
| 2001-06-21 | EWN | ETF | 18.96 | 19.1 | 18.96 | 19.1 | 1000.0 |
| 2001-06-21 | EWO | ETF | 7.95 | 7.95 | 7.91 | 7.91 | 700.0 |
| 2001-06-21 | EWP | ETF | 21.52 | 21.68 | 21.52 | 21.52 | 600.0 |
| 2001-06-21 | EWQ | ETF | 19.85 | 19.99 | 19.85 | 19.99 | 14000.0 |
| 2001-06-21 | EWS | ETF | 10.74 | 10.86 | 10.74 | 10.84 | 7950.0 |
| 2001-06-21 | EWT | ETF | 20.28 | 20.28 | 20.26 | 20.26 | 3600.0 |
| 2001-06-21 | EWU | ETF | 31.72 | 31.78 | 31.64 | 31.74 | 3600.0 |
| 2001-06-21 | EWW | ETF | 16.2 | 16.36 | 16.0 | 16.33 | 10700.0 |
| 2001-06-21 | EWY | ETF | 14.3 | 14.4 | 14.3 | 14.3 | 2500.0 |
| 2001-06-21 | EWZ | ETF | 14.1 | 14.44 | 14.06 | 14.44 | 2500.0 |
| 2001-06-21 | EZU | ETF | 29.75 | 30.015 | 29.635 | 30.015 | 4600.0 |
| 2001-06-21 | FCTR | ETF | 16.5 | 16.65 | 16.42 | 16.65 | 15300.0 |
| 2001-06-21 | FMAR | ETF | 6.9 | 6.9 | 6.8 | 6.9 | 5600.0 |
| 2001-06-21 | GLDB | ETF | 7.065 | 7.42 | 7.065 | 7.32 | 30300.0 |
| 2001-06-21 | GSIG | ETF | 8.7 | 8.82 | 8.46 | 8.56 | 117000.0 |
| 2001-06-21 | IBB | ETF | 33.6667 | 34.15 | 33.4 | 33.7667 | 619500.0 |
| 2001-06-21 | ICF | ETF | 21.0675 | 21.13 | 21.0525 | 21.1225 | 10800.0 |
| 2001-06-21 | IDU | ETF | 39.4 | 39.4 | 38.095 | 38.155 | 93000.0 |
| 2001-06-21 | IEV | ETF | 31.16 | 31.495 | 31.075 | 31.49 | 14600.0 |
| 2001-06-21 | IGLD | ETF | 71.0 | 75.0 | 70.0 | 70.0 | 23.0 |
| 2001-06-21 | IGM | ETF | 9.275 | 9.3067 | 9.275 | 9.3067 | 6000.0 |
| 2001-06-21 | IJH | ETF | 10.215 | 10.26 | 10.185 | 10.245 | 82000.0 |
| 2001-06-21 | IJJ | ETF | 22.2875 | 22.4 | 22.2 | 22.4 | 80000.0 |
| 2001-06-21 | IJK | ETF | 14.5312 | 14.6738 | 14.5188 | 14.5425 | 517600.0 |
| 2001-06-21 | IJR | ETF | 18.3367 | 18.4867 | 18.3 | 18.4467 | 528600.0 |
| 2001-06-21 | IJS | ETF | 20.6625 | 20.8175 | 20.625 | 20.75 | 166800.0 |
| 2001-06-21 | IJT | ETF | 18.4325 | 18.475 | 18.315 | 18.46 | 121600.0 |
| 2001-06-21 | IOO | ETF | 31.495 | 31.735 | 31.495 | 31.65 | 40800.0 |
| 2001-06-21 | IUSG | ETF | 21.97 | 22.33 | 21.97 | 22.33 | 800.0 |
| 2001-06-21 | IUSV | ETF | 24.99 | 24.99 | 24.99 | 24.99 | 600.0 |
> showing 50 of 97 rows — these rows as CSV