PREVIEW / etf_daily / 2008-04-22
file: by_date/etf_daily/2008/2008-04-22.parquet size: 26 KB rows: 588
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-22 | SPY | ETF | 138.19 | 138.31 | 136.9 | 137.94 | 162166000.0 |
| 2008-04-22 | QQQ | ETF | 46.73 | 46.77 | 45.93 | 46.34 | 104689529.0 |
| 2008-04-22 | IWM | ETF | 71.25 | 71.26 | 69.51 | 70.37 | 68800.0 |
| 2008-04-22 | DIA | ETF | 127.75 | 127.85 | 126.44 | 127.37 | 10086600.0 |
| 2008-04-22 | GLD | ETF | 90.42 | 91.35 | 90.12 | 90.27 | 14043600.0 |
| 2008-04-22 | TLT | ETF | 92.91 | 93.67 | 92.91 | 93.46 | 1799700.0 |
| 2008-04-22 | ACWI | ETF | 52.36 | 52.7 | 52.13 | 52.36 | 3600.0 |
| 2008-04-22 | ACWX | ETF | 53.92 | 53.92 | 53.37 | 53.37 | 905.0 |
| 2008-04-22 | ADRE | ETF | 54.31 | 54.4 | 53.52 | 53.75 | 323097.0 |
| 2008-04-22 | AGG | ETF | 102.0 | 102.28 | 101.8 | 102.16 | 569100.0 |
| 2008-04-22 | AIA | ETF | 46.96 | 46.96 | 45.53 | 46.3 | 35353.0 |
| 2008-04-22 | AIQ | ETF | 41.25 | 41.25 | 39.65 | 40.15 | 53873.0 |
| 2008-04-22 | AIS | ETF | 0.9 | 0.9 | 0.89 | 0.9 | 37275.0 |
| 2008-04-22 | AIVI | ETF | 67.12 | 67.35 | 66.78 | 67.12 | 13500.0 |
| 2008-04-22 | ARB | ETF | 46.65 | 48.95 | 46.65 | 47.9 | 1029162.0 |
| 2008-04-22 | BBH | ETF | 55.48 | 56.1367 | 55.48 | 56.1033 | 840900.0 |
| 2008-04-22 | BIL | ETF | 91.72 | 91.78 | 91.7 | 91.74 | 35850.0 |
| 2008-04-22 | BITS | ETF | 24.0 | 24.12 | 23.4 | 23.56 | 4664.0 |
| 2008-04-22 | BIV | ETF | 77.95 | 78.62 | 77.95 | 78.52 | 45800.0 |
| 2008-04-22 | BJK | ETF | 38.09 | 38.8 | 37.77 | 38.3 | 6000.0 |
| 2008-04-22 | BKF | ETF | 55.23 | 55.29 | 54.41 | 54.79 | 48773.0 |
| 2008-04-22 | BLV | ETF | 76.0 | 76.36 | 76.0 | 76.04 | 2100.0 |
| 2008-04-22 | BMVP | ETF | 15.8833 | 15.8833 | 15.67 | 15.736 | 32738.0 |
| 2008-04-22 | BND | ETF | 77.1 | 77.27 | 77.06 | 77.23 | 111400.0 |
| 2008-04-22 | BNE | ETF | 16.47 | 16.48 | 16.13 | 16.31 | 162949.0 |
| 2008-04-22 | BOSS | ETF | 35.04 | 35.04 | 33.7 | 33.7 | 200.0 |
| 2008-04-22 | BRF | ETF | 14.66 | 14.67 | 14.66 | 14.67 | 4100.0 |
| 2008-04-22 | BSV | ETF | 77.93 | 78.18 | 77.93 | 78.18 | 186600.0 |
| 2008-04-22 | BTF | ETF | 101.6 | 101.69999999999999 | 100.60399999999998 | 100.89949999999999 | 1720.0 |
| 2008-04-22 | BWX | ETF | 28.625 | 28.78 | 28.61 | 28.735 | 282186.0 |
| 2008-04-22 | CBON | ETF | 11.56 | 12.99 | 11.09 | 11.1 | 258705.0 |
| 2008-04-22 | CDL | ETF | 1.34 | 1.34 | 1.27 | 1.29 | 968026.0 |
| 2008-04-22 | CEF | ETF | 12.67 | 12.9 | 12.46 | 12.69 | 694200.0 |
| 2008-04-22 | CGO | ETF | 16.48 | 16.5 | 16.29 | 16.4 | 10410.0 |
| 2008-04-22 | CGW | ETF | 24.02 | 24.4 | 24.02 | 24.05 | 71520.0 |
| 2008-04-22 | CHB | ETF | 10.4 | 10.4 | 9.598 | 9.95 | 2149890.0 |
| 2008-04-22 | CHI | ETF | 14.8 | 15.0 | 14.73 | 14.98 | 83777.0 |
| 2008-04-22 | CHIC | ETF | 16.72 | 16.9 | 16.32 | 16.7 | 345761.0 |
| 2008-04-22 | CHW | ETF | 11.88 | 11.88 | 11.5 | 11.7 | 152918.0 |
| 2008-04-22 | CHY | ETF | 13.76 | 13.87 | 13.7301 | 13.84 | 109517.0 |
| 2008-04-22 | CMF | ETF | 52.1425 | 52.445 | 52.1425 | 52.445 | 18000.0 |
| 2008-04-22 | CN | ETF | 58.45 | 58.88 | 57.09 | 57.8 | 296085.0 |
| 2008-04-22 | CNXT | ETF | 0.5 | 0.5 | 0.43 | 0.43 | 5043220.0 |
| 2008-04-22 | COW | ETF | 42.42 | 43.05 | 42.42 | 43.05 | 246452.0 |
| 2008-04-22 | CPI | ETF | 18.0 | 18.17 | 17.95 | 17.95 | 800.0 |
| 2008-04-22 | CPST | ETF | 3.06 | 3.08 | 2.96 | 2.98 | 6419919.0 |
| 2008-04-22 | CSA | ETF | 16.55 | 16.7 | 16.27 | 16.51 | 37739.0 |
| 2008-04-22 | CSB | ETF | 22.97 | 23.75 | 22.43 | 23.5 | 186600.0 |
| 2008-04-22 | CSD | ETF | 23.42 | 23.42 | 23.18 | 23.33 | 8500.0 |
| 2008-04-22 | CSQ | ETF | 12.44 | 12.54 | 12.31 | 12.43 | 298380.0 |
> showing 50 of 588 rows — these rows as CSV