PREVIEW / etf_daily / 2006-04-20
file: by_date/etf_daily/2006/2006-04-20.parquet size: 16 KB rows: 305
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 |
|---|---|---|---|---|---|---|---|
| 2006-04-20 | SPY | ETF | 131.0 | 131.86 | 130.6 | 131.13 | 86005500.0 |
| 2006-04-20 | QQQ | ETF | 42.62 | 42.82 | 42.38 | 42.5 | 81412978.0 |
| 2006-04-20 | IWM | ETF | 77.33 | 77.33 | 76.23 | 76.85 | 44622400.0 |
| 2006-04-20 | DIA | ETF | 112.91 | 113.88 | 112.84 | 113.49 | 10126900.0 |
| 2006-04-20 | GLD | ETF | 63.39 | 63.45 | 60.44 | 60.96 | 12977900.0 |
| 2006-04-20 | TLT | ETF | 84.42 | 84.51 | 84.12 | 84.31 | 1378200.0 |
| 2006-04-20 | AAA | ETF | 61.16 | 61.45 | 61.16 | 61.44 | 13400.0 |
| 2006-04-20 | ADRE | ETF | 139.29 | 139.29 | 137.28 | 137.7 | 32380.0 |
| 2006-04-20 | AFK | ETF | 25.14 | 25.14 | 25.1 | 25.1 | 3800.0 |
| 2006-04-20 | AGG | ETF | 98.41 | 98.44 | 98.06 | 98.24 | 242300.0 |
| 2006-04-20 | AIQ | ETF | 25.7 | 26.5 | 25.05 | 25.6 | 18740.0 |
| 2006-04-20 | AIS | ETF | 1.62 | 1.7 | 1.6 | 1.68 | 226100.0 |
| 2006-04-20 | AOM | ETF | 6.52 | 6.69 | 6.52 | 6.69 | 14700.0 |
| 2006-04-20 | ARB | ETF | 35.0 | 35.06 | 33.83 | 34.09 | 400400.0 |
| 2006-04-20 | BAB | ETF | 60.28 | 60.75 | 60.27 | 60.4 | 6000.0 |
| 2006-04-20 | BBC | ETF | 15.76 | 15.76 | 15.29 | 15.39 | 180400.0 |
| 2006-04-20 | BBH | ETF | 61.85 | 62.2067 | 61.3167 | 62.0933 | 1144500.0 |
| 2006-04-20 | BCM | ETF | 73.48 | 74.15 | 73.29 | 74.02 | 48700.0 |
| 2006-04-20 | BITS | ETF | 34.6 | 35.4 | 34.04 | 35.0 | 18416.0 |
| 2006-04-20 | BKF | ETF | 8.86 | 9.18 | 8.68 | 8.71 | 158400.0 |
| 2006-04-20 | BNE | ETF | 16.55 | 16.56 | 16.11 | 16.47 | 64900.0 |
| 2006-04-20 | BRF | ETF | 13.92 | 13.94 | 13.81 | 13.87 | 18600.0 |
| 2006-04-20 | BTF | ETF | 87.5 | 87.5 | 87.00049999999999 | 87.24999999999999 | 500.0 |
| 2006-04-20 | CBON | ETF | 32.75 | 33.46 | 32.71 | 33.18 | 40176.0 |
| 2006-04-20 | CDL | ETF | 10.25 | 10.27 | 9.92 | 10.0 | 1324000.0 |
| 2006-04-20 | CEF | ETF | 9.86 | 9.86 | 9.0 | 9.09 | 2054300.0 |
| 2006-04-20 | CFO | ETF | 10.28 | 10.3 | 10.25 | 10.25 | 7100.0 |
| 2006-04-20 | CGO | ETF | 14.46 | 14.55 | 14.37 | 14.42 | 53000.0 |
| 2006-04-20 | CHB | ETF | 15.7 | 15.8 | 15.37 | 15.73 | 466800.0 |
| 2006-04-20 | CHI | ETF | 20.04 | 20.2 | 20.01 | 20.11 | 85100.0 |
| 2006-04-20 | CHIC | ETF | 21.07 | 22.0 | 19.76 | 20.25 | 2296011.0 |
| 2006-04-20 | CHY | ETF | 15.82 | 16.0 | 15.8 | 15.9 | 68900.0 |
| 2006-04-20 | CN | ETF | 39.0 | 39.05 | 38.46 | 38.8 | 43800.0 |
| 2006-04-20 | CNXT | ETF | 3.73 | 3.8 | 3.68 | 3.76 | 19188839.0 |
| 2006-04-20 | COMB | ETF | 8.65 | 9.16 | 8.65 | 9.1 | 1700.0 |
| 2006-04-20 | CPST | ETF | 4.42 | 4.44 | 4.14 | 4.27 | 3445131.0 |
| 2006-04-20 | CSA | ETF | 19.67 | 19.8 | 19.56 | 19.74 | 10900.0 |
| 2006-04-20 | CSB | ETF | 30.82 | 31.01 | 30.82 | 30.91 | 7500.0 |
| 2006-04-20 | CSQ | ETF | 13.94 | 14.06 | 13.92 | 14.0 | 377500.0 |
| 2006-04-20 | CTEC | ETF | 63.49999999999999 | 64.45 | 62.05 | 63.25 | 7390.0 |
| 2006-04-20 | CYB | ETF | 6.2 | 6.34 | 6.2 | 6.29 | 55400.0 |
| 2006-04-20 | DBC | ETF | 25.88 | 25.88 | 25.3 | 25.6 | 640100.0 |
| 2006-04-20 | DGT | ETF | 68.18 | 68.5 | 68.15 | 68.22 | 1800.0 |
| 2006-04-20 | DIG | ETF | 17.75 | 17.7875 | 17.7125 | 17.7125 | 8320.0 |
| 2006-04-20 | DIV | ETF | 12.01 | 12.07 | 11.95 | 12.04 | 14000.0 |
| 2006-04-20 | DRIV | ETF | 46.54 | 47.22 | 45.06 | 46.79 | 1130993.0 |
| 2006-04-20 | DUSA | ETF | 6.98 | 7.05 | 6.91 | 7.01 | 46671.0 |
| 2006-04-20 | DVY | ETF | 62.9 | 63.44 | 62.89 | 63.17 | 287200.0 |
| 2006-04-20 | EDV | ETF | 25.14 | 25.18 | 25.13 | 25.15 | 30200.0 |
| 2006-04-20 | EEM | ETF | 35.6633 | 35.6667 | 35.0267 | 35.3567 | 12247800.0 |
> showing 50 of 305 rows — these rows as CSV