PREVIEW / etf_daily / 2001-08-07
file: by_date/etf_daily/2001/2001-08-07.parquet size: 8 KB rows: 99
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-08-07 | SPY | ETF | 120.27 | 121.2 | 119.91 | 120.77 | 8865100.0 |
| 2001-08-07 | QQQ | ETF | 42.1 | 42.82 | 41.94 | 42.28 | 38407500.0 |
| 2001-08-07 | IWM | ETF | 47.9 | 48.05 | 47.65 | 47.95 | 427400.0 |
| 2001-08-07 | DIA | ETF | 104.1 | 104.88 | 103.73 | 104.56 | 2502500.0 |
| 2001-08-07 | BBH | ETF | 39.7333 | 39.9333 | 39.1833 | 39.35 | 2385000.0 |
| 2001-08-07 | BITS | ETF | 15.68 | 16.0 | 15.24 | 15.64 | 2825.0 |
| 2001-08-07 | BOSS | ETF | 26.0 | 26.9 | 26.0 | 26.9 | 100.0 |
| 2001-08-07 | CEF | ETF | 3.07 | 3.11 | 3.06 | 3.09 | 13400.0 |
| 2001-08-07 | CHB | ETF | 9.8 | 9.8 | 9.05 | 9.5 | 581100.0 |
| 2001-08-07 | CNXT | ETF | 9.85 | 10.47 | 9.67 | 10.03 | 4290880.0 |
| 2001-08-07 | CSB | ETF | 2.34999990463257 | 2.34999990463257 | 2.34999990463257 | 2.34999990463257 | 20000.0 |
| 2001-08-07 | EWA | ETF | 9.55 | 9.65 | 9.55 | 9.65 | 4700.0 |
| 2001-08-07 | EWC | ETF | 11.59 | 11.59 | 11.32 | 11.49 | 2900.0 |
| 2001-08-07 | EWD | ETF | 13.67 | 13.95 | 13.64 | 13.95 | 2800.0 |
| 2001-08-07 | EWG | ETF | 16.15 | 16.35 | 16.15 | 16.21 | 47800.0 |
| 2001-08-07 | EWH | ETF | 9.34 | 9.49 | 9.34 | 9.46 | 10800.0 |
| 2001-08-07 | EWI | ETF | 36.76 | 36.76 | 36.5 | 36.7 | 400.0 |
| 2001-08-07 | EWJ | ETF | 38.48 | 38.88 | 38.32 | 38.72 | 30175.0 |
| 2001-08-07 | EWK | ETF | 11.52 | 11.52 | 11.52 | 11.52 | 3100.0 |
| 2001-08-07 | EWL | ETF | 13.11 | 13.35 | 13.11 | 13.35 | 2200.0 |
| 2001-08-07 | EWM | ETF | 19.12 | 19.32 | 18.88 | 19.08 | 8200.0 |
| 2001-08-07 | EWN | ETF | 18.85 | 19.05 | 18.85 | 19.05 | 700.0 |
| 2001-08-07 | EWO | ETF | 8.18 | 8.18 | 8.18 | 8.18 | 1000.0 |
| 2001-08-07 | EWP | ETF | 21.17 | 21.45 | 21.17 | 21.25 | 1800.0 |
| 2001-08-07 | EWQ | ETF | 19.86 | 20.1 | 19.81 | 20.08 | 3800.0 |
| 2001-08-07 | EWS | ETF | 10.72 | 10.72 | 10.58 | 10.7 | 30800.0 |
| 2001-08-07 | EWT | ETF | 18.66 | 18.66 | 17.9 | 18.38 | 2300.0 |
| 2001-08-07 | EWU | ETF | 30.8 | 31.0 | 30.72 | 30.96 | 16800.0 |
| 2001-08-07 | EWW | ETF | 16.31 | 16.35 | 16.1 | 16.28 | 3200.0 |
| 2001-08-07 | EWY | ETF | 13.79 | 13.88 | 13.71 | 13.82 | 31700.0 |
| 2001-08-07 | EWZ | ETF | 13.2 | 13.29 | 12.91 | 13.23 | 2200.0 |
| 2001-08-07 | EZU | ETF | 29.97 | 29.995 | 29.92 | 29.92 | 1600.0 |
| 2001-08-07 | FCTR | ETF | 17.99 | 18.23 | 17.554 | 18.0 | 19000.0 |
| 2001-08-07 | FMAR | ETF | 9.8 | 9.99 | 9.55 | 9.55 | 4000.0 |
| 2001-08-07 | GLDB | ETF | 7.7 | 7.9 | 7.46 | 7.65 | 35700.0 |
| 2001-08-07 | GSIG | ETF | 8.53 | 8.62 | 8.4 | 8.42 | 73200.0 |
| 2001-08-07 | IBB | ETF | 28.5333 | 28.73 | 28.3 | 28.4233 | 33600.0 |
| 2001-08-07 | ICF | ETF | 21.23 | 21.3425 | 21.23 | 21.3425 | 10800.0 |
| 2001-08-07 | IDU | ETF | 37.515 | 37.525 | 37.175 | 37.175 | 1000.0 |
| 2001-08-07 | IEV | ETF | 30.985 | 31.095 | 30.625 | 30.805 | 26200.0 |
| 2001-08-07 | IGLD | ETF | 60.0 | 72.0 | 60.0 | 72.0 | 153.0 |
| 2001-08-07 | IGM | ETF | 9.1667 | 9.23 | 9.1667 | 9.23 | 12000.0 |
| 2001-08-07 | IJH | ETF | 10.1 | 10.128 | 10.046 | 10.08 | 555000.0 |
| 2001-08-07 | IJJ | ETF | 22.75 | 22.77 | 22.61 | 22.7425 | 46800.0 |
| 2001-08-07 | IJK | ETF | 13.9412 | 13.9412 | 13.85 | 13.8975 | 137600.0 |
| 2001-08-07 | IJR | ETF | 18.6417 | 18.665 | 18.5367 | 18.6617 | 497400.0 |
| 2001-08-07 | IJS | ETF | 21.0125 | 21.0675 | 20.8825 | 21.015 | 54000.0 |
| 2001-08-07 | IJT | ETF | 18.6125 | 18.615 | 18.465 | 18.595 | 10800.0 |
| 2001-08-07 | IOO | ETF | 30.345 | 30.605 | 30.345 | 30.6 | 61400.0 |
| 2001-08-07 | IUSG | ETF | 21.35 | 21.36 | 21.35 | 21.36 | 800.0 |
> showing 50 of 99 rows — these rows as CSV