PREVIEW / etf_daily / 2005-08-03
file: by_date/etf_daily/2005/2005-08-03.parquet size: 15 KB rows: 279
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-03 | SPY | ETF | 124.25 | 124.74 | 124.12 | 124.72 | 36837200.0 |
| 2005-08-03 | QQQ | ETF | 39.91 | 40.13 | 39.88 | 40.06 | 61975627.0 |
| 2005-08-03 | IWM | ETF | 68.15 | 68.31 | 67.87 | 68.03 | 16877600.0 |
| 2005-08-03 | DIA | ETF | 106.53 | 107.04 | 106.37 | 107.0 | 3290700.0 |
| 2005-08-03 | GLD | ETF | 43.38 | 43.62 | 43.35 | 43.53 | 1545900.0 |
| 2005-08-03 | TLT | ETF | 92.25 | 92.66 | 92.25 | 92.57 | 591100.0 |
| 2005-08-03 | AAA | ETF | 56.43 | 56.55 | 55.82 | 56.0 | 33100.0 |
| 2005-08-03 | ADRE | ETF | 100.0 | 100.26 | 99.53 | 99.99 | 15288.0 |
| 2005-08-03 | AFK | ETF | 25.83 | 25.83 | 25.72 | 25.83 | 5500.0 |
| 2005-08-03 | AGG | ETF | 101.54 | 101.7 | 101.35 | 101.7 | 167700.0 |
| 2005-08-03 | AIQ | ETF | 51.25 | 51.3 | 50.25 | 51.2 | 32420.0 |
| 2005-08-03 | AIS | ETF | 1.09 | 1.1 | 1.04 | 1.06 | 43600.0 |
| 2005-08-03 | ARB | ETF | 41.64 | 41.78 | 41.56 | 41.68 | 318000.0 |
| 2005-08-03 | BAB | ETF | 50.4 | 50.83 | 50.39 | 50.7 | 19700.0 |
| 2005-08-03 | BBH | ETF | 65.0 | 65.6433 | 64.9333 | 65.6433 | 1236300.0 |
| 2005-08-03 | BCM | ETF | 61.5 | 62.02 | 61.0 | 61.25 | 390900.0 |
| 2005-08-03 | BIS | ETF | 672.0 | 672.0 | 662.4 | 672.0 | 39.4 |
| 2005-08-03 | BITS | ETF | 13.8 | 14.016 | 13.044 | 13.6 | 3685.0 |
| 2005-08-03 | BKF | ETF | 34.09 | 34.49 | 33.97 | 34.49 | 20600.0 |
| 2005-08-03 | BNE | ETF | 14.02 | 14.02 | 13.86 | 13.86 | 145700.0 |
| 2005-08-03 | BOSS | ETF | 27.71 | 27.71 | 27.6 | 27.7 | 400.0 |
| 2005-08-03 | BRF | ETF | 15.54 | 15.56 | 15.43 | 15.43 | 12300.0 |
| 2005-08-03 | BTF | ETF | 87.24999999999999 | 87.65 | 87.24999999999999 | 87.39999999999999 | 1740.0 |
| 2005-08-03 | CBON | ETF | 33.44 | 33.44 | 32.5 | 33.39 | 9564.0 |
| 2005-08-03 | CDC | ETF | 5.45 | 5.45 | 4.65 | 4.92 | 22100.0 |
| 2005-08-03 | CDL | ETF | 12.87 | 13.1 | 12.79 | 13.03 | 605000.0 |
| 2005-08-03 | CEF | ETF | 5.28 | 5.37 | 5.27 | 5.36 | 519600.0 |
| 2005-08-03 | CEW | ETF | 26.8 | 26.89 | 26.8 | 26.89 | 200.0 |
| 2005-08-03 | CHB | ETF | 12.45 | 12.52 | 12.3 | 12.42 | 252800.0 |
| 2005-08-03 | CHI | ETF | 20.55 | 20.7 | 20.49 | 20.62 | 76500.0 |
| 2005-08-03 | CHIC | ETF | 14.55 | 14.77 | 14.29 | 14.7 | 134584.0 |
| 2005-08-03 | CHIR | ETF | 36.78 | 36.9399 | 36.2199 | 36.9201 | 746453.0 |
| 2005-08-03 | CHY | ETF | 16.62 | 16.74 | 16.62 | 16.67 | 138500.0 |
| 2005-08-03 | CIL | ETF | 25.82 | 25.87 | 25.79 | 25.79 | 2300.0 |
| 2005-08-03 | CIZ | ETF | 23.25 | 23.57 | 23.25 | 23.57 | 3100.0 |
| 2005-08-03 | CN | ETF | 32.54 | 32.54 | 32.15 | 32.39 | 58300.0 |
| 2005-08-03 | CNXT | ETF | 1.91 | 1.911 | 1.8 | 1.81 | 7606041.0 |
| 2005-08-03 | CPI | ETF | 23.75 | 23.89 | 23.75 | 23.87 | 600.0 |
| 2005-08-03 | CPST | ETF | 2.23 | 2.73 | 2.15 | 2.7 | 4582553.0 |
| 2005-08-03 | CSB | ETF | 30.99 | 31.0 | 30.77 | 31.0 | 9100.0 |
| 2005-08-03 | CSM | ETF | 2.4175 | 2.42 | 2.4175 | 2.42 | 2000.0 |
| 2005-08-03 | CSQ | ETF | 14.43 | 14.46 | 14.34 | 14.42 | 312300.0 |
| 2005-08-03 | CTEC | ETF | 58.2 | 58.8 | 55.55 | 56.55 | 5504.400000000001 |
| 2005-08-03 | CURE | ETF | 0.3688 | 0.4313 | 0.3575 | 0.43 | 8489576.0 |
| 2005-08-03 | CYA | ETF | 120.0 | 120.2 | 100.0 | 109.0 | 1660.0 |
| 2005-08-03 | CYB | ETF | 3.73 | 4.1 | 3.71 | 4.0 | 57900.0 |
| 2005-08-03 | DGT | ETF | 65.07 | 65.24 | 65.07 | 65.23 | 27000.0 |
| 2005-08-03 | DIG | ETF | 12.5 | 12.85 | 12.5 | 12.8125 | 9280.0 |
| 2005-08-03 | DIV | ETF | 13.92 | 13.95 | 13.85 | 13.85 | 13900.0 |
| 2005-08-03 | DRIV | ETF | 39.3 | 39.99 | 38.46 | 38.89 | 1082875.0 |
> showing 50 of 279 rows — these rows as CSV