PREVIEW / etf_daily / 2006-07-21
file: by_date/etf_daily/2006/2006-07-21.parquet size: 18 KB rows: 357
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-07-21 | SPY | ETF | 125.15 | 125.19 | 123.82 | 123.95 | 101560000.0 |
| 2006-07-21 | QQQ | ETF | 35.88 | 35.96 | 35.62 | 35.7 | 119379886.0 |
| 2006-07-21 | IWM | ETF | 67.65 | 67.65 | 66.35 | 66.75 | 103313800.0 |
| 2006-07-21 | DIA | ETF | 109.6 | 109.61 | 108.29 | 108.56 | 9159500.0 |
| 2006-07-21 | GLD | ETF | 63.19 | 63.25 | 61.21 | 61.71 | 6949300.0 |
| 2006-07-21 | TLT | ETF | 85.6 | 85.67 | 85.2 | 85.33 | 652100.0 |
| 2006-07-21 | AAA | ETF | 54.22 | 54.5 | 53.9 | 54.25 | 6400.0 |
| 2006-07-21 | ADRE | ETF | 30.36 | 30.45 | 29.79 | 29.86 | 706161.0 |
| 2006-07-21 | AFK | ETF | 25.05 | 25.07 | 24.93 | 25.06 | 34200.0 |
| 2006-07-21 | AGG | ETF | 98.26 | 98.28 | 98.01 | 98.02 | 139800.0 |
| 2006-07-21 | AIQ | ETF | 29.25 | 30.0 | 28.5 | 29.2 | 20600.0 |
| 2006-07-21 | AIS | ETF | 1.2 | 1.2 | 1.09 | 1.11 | 86700.0 |
| 2006-07-21 | AOM | ETF | 6.48 | 6.48 | 6.42 | 6.47 | 2400.0 |
| 2006-07-21 | ARB | ETF | 36.31 | 36.31 | 35.62 | 35.89 | 332700.0 |
| 2006-07-21 | BAB | ETF | 66.61 | 66.79 | 66.07 | 66.08 | 46400.0 |
| 2006-07-21 | BBC | ETF | 12.5 | 12.5 | 12.0 | 12.05 | 145900.0 |
| 2006-07-21 | BBH | ETF | 56.9433 | 57.4133 | 56.89 | 57.0067 | 1954800.0 |
| 2006-07-21 | BITS | ETF | 19.4 | 20.32 | 17.28 | 18.12 | 20038.0 |
| 2006-07-21 | BKF | ETF | 5.4 | 5.48 | 5.33 | 5.38 | 96400.0 |
| 2006-07-21 | BNE | ETF | 13.2 | 13.4 | 13.05 | 13.17 | 126800.0 |
| 2006-07-21 | BOSS | ETF | 32.2 | 32.3 | 32.2 | 32.3 | 200.0 |
| 2006-07-21 | BRF | ETF | 14.02 | 14.02 | 14.02 | 14.02 | 500.0 |
| 2006-07-21 | BTF | ETF | 86.14999999999999 | 86.14999999999999 | 85.85000000000001 | 86.14999999999999 | 560.0 |
| 2006-07-21 | CBON | ETF | 32.13 | 32.39 | 31.84 | 32.22 | 39758.0 |
| 2006-07-21 | CDL | ETF | 9.01 | 9.12 | 8.7 | 8.7 | 334200.0 |
| 2006-07-21 | CEF | ETF | 8.75 | 8.75 | 8.5 | 8.53 | 952800.0 |
| 2006-07-21 | CEW | ETF | 25.95 | 25.95 | 25.95 | 25.95 | 400.0 |
| 2006-07-21 | CFO | ETF | 9.89 | 9.89 | 9.85 | 9.85 | 7200.0 |
| 2006-07-21 | CGO | ETF | 14.78 | 14.85 | 14.57 | 14.81 | 18200.0 |
| 2006-07-21 | CHB | ETF | 8.55 | 8.55 | 8.12 | 8.33 | 1244900.0 |
| 2006-07-21 | CHI | ETF | 19.51 | 19.73 | 19.42 | 19.57 | 90000.0 |
| 2006-07-21 | CHIC | ETF | 24.23 | 24.96 | 24.08 | 24.72 | 761405.0 |
| 2006-07-21 | CHY | ETF | 16.06 | 16.1 | 15.95 | 16.02 | 164900.0 |
| 2006-07-21 | CIZ | ETF | 22.15 | 22.15 | 22.15 | 22.15 | 300.0 |
| 2006-07-21 | CN | ETF | 36.3 | 36.3 | 35.5 | 35.72 | 92700.0 |
| 2006-07-21 | CNXT | ETF | 2.05 | 2.06 | 1.8 | 1.89 | 19783235.0 |
| 2006-07-21 | COMB | ETF | 9.67 | 9.79 | 9.33 | 9.79 | 5900.0 |
| 2006-07-21 | CPI | ETF | 29.15 | 29.15 | 29.15 | 29.15 | 7000.0 |
| 2006-07-21 | CPST | ETF | 2.03 | 2.08 | 1.99 | 2.02 | 773623.0 |
| 2006-07-21 | CSA | ETF | 18.65 | 18.85 | 18.65 | 18.69 | 4400.0 |
| 2006-07-21 | CSB | ETF | 27.2 | 27.2 | 26.92 | 27.05 | 4800.0 |
| 2006-07-21 | CSQ | ETF | 14.04 | 14.07 | 13.97 | 14.04 | 280800.0 |
| 2006-07-21 | CTEC | ETF | 59.15 | 59.3 | 58.2 | 58.949999999999996 | 14118.400000000001 |
| 2006-07-21 | CYB | ETF | 5.78 | 5.8 | 5.6 | 5.6 | 14500.0 |
| 2006-07-21 | DBC | ETF | 25.7 | 25.7 | 25.28 | 25.49 | 151700.0 |
| 2006-07-21 | DDM | ETF | 5.6683 | 5.7917 | 5.6683 | 5.7242 | 1042800.0 |
| 2006-07-21 | DES | ETF | 16.8833 | 16.8833 | 16.7533 | 16.8367 | 15300.0 |
| 2006-07-21 | DEW | ETF | 51.2 | 51.2 | 51.1 | 51.11 | 1100.0 |
| 2006-07-21 | DFE | ETF | 51.95 | 51.95 | 51.95 | 51.95 | 100.0 |
| 2006-07-21 | DFJ | ETF | 47.8 | 47.8 | 47.49 | 47.49 | 600.0 |
> showing 50 of 357 rows — these rows as CSV