PREVIEW / etf_daily / 2008-04-24
file: by_date/etf_daily/2008/2008-04-24.parquet size: 26 KB rows: 583
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-24 | SPY | ETF | 138.08 | 139.74 | 137.04 | 138.32 | 229381300.0 |
| 2008-04-24 | QQQ | ETF | 46.87 | 47.79 | 46.39 | 47.27 | 166694557.0 |
| 2008-04-24 | IWM | ETF | 70.5 | 71.94 | 69.64 | 71.23 | 230600.0 |
| 2008-04-24 | DIA | ETF | 127.77 | 129.31 | 126.94 | 128.1 | 14614800.0 |
| 2008-04-24 | GLD | ETF | 88.26 | 89.91 | 87.1 | 87.22 | 22846600.0 |
| 2008-04-24 | TLT | ETF | 92.26 | 92.46 | 91.81 | 92.36 | 3213600.0 |
| 2008-04-24 | ACWI | ETF | 52.0 | 52.64 | 52.0 | 52.51 | 7100.0 |
| 2008-04-24 | ACWX | ETF | 53.11 | 53.67 | 53.0 | 53.67 | 2665.0 |
| 2008-04-24 | ADRE | ETF | 54.37 | 54.37 | 53.1878 | 53.8399 | 854875.0 |
| 2008-04-24 | AGG | ETF | 101.65 | 101.8 | 101.41 | 101.68 | 364000.0 |
| 2008-04-24 | AIA | ETF | 47.36 | 47.51 | 46.731 | 47.505 | 7206.0 |
| 2008-04-24 | AIQ | ETF | 42.3 | 42.3 | 40.15 | 41.1 | 33812.0 |
| 2008-04-24 | AIS | ETF | 0.8901 | 0.91 | 0.89 | 0.91 | 51300.0 |
| 2008-04-24 | AIVI | ETF | 66.24 | 66.81 | 65.91 | 66.5 | 23700.0 |
| 2008-04-24 | ARB | ETF | 48.21 | 49.02 | 47.57 | 49.02 | 363926.0 |
| 2008-04-24 | BBH | ETF | 56.4933 | 56.4933 | 55.5467 | 55.79 | 185400.0 |
| 2008-04-24 | BIL | ETF | 91.76 | 91.78 | 91.72 | 91.76 | 9800.0 |
| 2008-04-24 | BITS | ETF | 23.0 | 25.0 | 23.0 | 24.56 | 5616.0 |
| 2008-04-24 | BIV | ETF | 78.09 | 78.18 | 77.58 | 77.81 | 52600.0 |
| 2008-04-24 | BJK | ETF | 37.51 | 38.6 | 37.47 | 38.6 | 4200.0 |
| 2008-04-24 | BKF | ETF | 56.01 | 56.47 | 55.05 | 55.61 | 47873.0 |
| 2008-04-24 | BLV | ETF | 75.82 | 75.82 | 75.2 | 75.79 | 11300.0 |
| 2008-04-24 | BMVP | ETF | 15.9167 | 16.1333 | 15.8467 | 16.0467 | 19683.0 |
| 2008-04-24 | BND | ETF | 76.8 | 76.95 | 76.54 | 76.83 | 126000.0 |
| 2008-04-24 | BNE | ETF | 16.81 | 16.97 | 16.46 | 16.67 | 318439.0 |
| 2008-04-24 | BRF | ETF | 14.67 | 14.67 | 14.66 | 14.66 | 7100.0 |
| 2008-04-24 | BSV | ETF | 77.92 | 78.15 | 77.79 | 77.92 | 75400.0 |
| 2008-04-24 | BTF | ETF | 101.64999999999999 | 101.95 | 100.7 | 101.7375 | 10674.0 |
| 2008-04-24 | BWX | ETF | 28.555 | 28.66 | 28.31 | 28.31 | 777678.0 |
| 2008-04-24 | CBON | ETF | 11.42 | 12.51 | 11.13 | 11.49 | 107444.0 |
| 2008-04-24 | CDL | ETF | 1.25 | 1.27 | 1.145 | 1.22 | 1967866.0 |
| 2008-04-24 | CEF | ETF | 12.4 | 12.77 | 12.1 | 12.18 | 1432300.0 |
| 2008-04-24 | CGO | ETF | 16.42 | 16.51 | 16.3201 | 16.51 | 26827.0 |
| 2008-04-24 | CGW | ETF | 24.52 | 24.55 | 23.5 | 24.44 | 67707.0 |
| 2008-04-24 | CHB | ETF | 9.79 | 10.48 | 9.6 | 10.44 | 1821068.0 |
| 2008-04-24 | CHI | ETF | 15.18 | 15.42 | 15.09 | 15.38 | 95070.0 |
| 2008-04-24 | CHIC | ETF | 16.99 | 17.29 | 16.0 | 16.54 | 842978.0 |
| 2008-04-24 | CHW | ETF | 11.66 | 11.84 | 11.5244 | 11.84 | 139718.0 |
| 2008-04-24 | CHY | ETF | 14.08 | 14.23 | 13.89 | 14.19 | 139581.0 |
| 2008-04-24 | CMF | ETF | 52.84 | 52.84 | 52.125 | 52.2525 | 17492.0 |
| 2008-04-24 | CN | ETF | 60.12 | 61.88 | 60.02 | 61.48 | 303270.0 |
| 2008-04-24 | CNXT | ETF | 0.45 | 0.47 | 0.44 | 0.47 | 2634607.0 |
| 2008-04-24 | COW | ETF | 43.61 | 43.72 | 42.9 | 43.41 | 436727.0 |
| 2008-04-24 | CPI | ETF | 19.62 | 19.62 | 19.35 | 19.35 | 500.0 |
| 2008-04-24 | CPST | ETF | 2.86 | 2.9 | 2.59 | 2.82 | 8629008.0 |
| 2008-04-24 | CSA | ETF | 16.5 | 16.62 | 16.5 | 16.59 | 19650.0 |
| 2008-04-24 | CSB | ETF | 22.65 | 23.0399 | 22.11 | 22.2 | 38300.0 |
| 2008-04-24 | CSD | ETF | 23.05 | 23.42 | 23.05 | 23.38 | 1800.0 |
| 2008-04-24 | CSQ | ETF | 12.45 | 12.58 | 12.4 | 12.52 | 292231.0 |
| 2008-04-24 | CUT | ETF | 21.4 | 21.64 | 21.3 | 21.52 | 32100.0 |
> showing 50 of 583 rows — these rows as CSV