PREVIEW / etf_daily / 2005-04-29
file: by_date/etf_daily/2005/2005-04-29.parquet size: 14 KB rows: 256
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-04-29 | SPY | ETF | 115.07 | 115.87 | 113.97 | 115.75 | 103993800.0 |
| 2005-04-29 | QQQ | ETF | 35.0 | 35.064 | 34.35 | 34.98 | 144508387.0 |
| 2005-04-29 | IWM | ETF | 57.49 | 57.715 | 56.495 | 57.62 | 57488600.0 |
| 2005-04-29 | DIA | ETF | 101.31 | 101.98 | 100.44 | 101.88 | 10176500.0 |
| 2005-04-29 | GLD | ETF | 43.18 | 43.61 | 43.18 | 43.35 | 3736700.0 |
| 2005-04-29 | TLT | ETF | 92.57 | 92.94 | 92.22 | 92.44 | 1445100.0 |
| 2005-04-29 | AAA | ETF | 62.7 | 63.3 | 62.23 | 62.65 | 28900.0 |
| 2005-04-29 | ADRE | ETF | 81.0 | 82.18 | 81.0 | 82.0 | 1624.0 |
| 2005-04-29 | AFK | ETF | 25.8 | 25.89 | 25.8 | 25.84 | 5300.0 |
| 2005-04-29 | AGG | ETF | 102.31 | 102.45 | 102.05 | 102.32 | 151000.0 |
| 2005-04-29 | AIQ | ETF | 51.5 | 54.05 | 51.1 | 52.2 | 69300.0 |
| 2005-04-29 | ARB | ETF | 41.8 | 42.78 | 41.52 | 42.32 | 398500.0 |
| 2005-04-29 | BAB | ETF | 45.97 | 45.97 | 45.19 | 45.73 | 43000.0 |
| 2005-04-29 | BBH | ETF | 51.1367 | 51.78 | 50.3333 | 51.5167 | 3189900.0 |
| 2005-04-29 | BCM | ETF | 59.58 | 59.58 | 59.11 | 59.35 | 11800.0 |
| 2005-04-29 | BIS | ETF | 577.6 | 577.6 | 577.6 | 577.6 | 9.4 |
| 2005-04-29 | BITS | ETF | 10.68 | 11.4 | 10.6 | 10.8 | 7675.0 |
| 2005-04-29 | BKF | ETF | 32.9 | 33.6 | 32.6 | 33.46 | 62600.0 |
| 2005-04-29 | BNE | ETF | 12.39 | 13.02 | 11.97 | 13.02 | 822400.0 |
| 2005-04-29 | BOSS | ETF | 22.25 | 22.9 | 22.25 | 22.9 | 100.0 |
| 2005-04-29 | BRF | ETF | 15.44 | 15.44 | 15.38 | 15.38 | 3300.0 |
| 2005-04-29 | BTF | ETF | 84.60000000000001 | 84.60000000000001 | 83.75 | 84.19999999999999 | 3320.0 |
| 2005-04-29 | CBON | ETF | 23.79 | 24.9 | 23.76 | 24.02 | 11597.0 |
| 2005-04-29 | CDC | ETF | 7.73 | 7.73 | 6.9 | 6.98 | 6100.0 |
| 2005-04-29 | CDL | ETF | 12.5 | 12.7 | 12.3 | 12.57 | 394000.0 |
| 2005-04-29 | CEF | ETF | 5.37 | 5.39 | 5.3 | 5.36 | 475600.0 |
| 2005-04-29 | CEW | ETF | 26.26 | 26.26 | 26.25 | 26.25 | 400.0 |
| 2005-04-29 | CGW | ETF | 27.5 | 28.32 | 27.5 | 28.32 | 17200.0 |
| 2005-04-29 | CHB | ETF | 9.48 | 9.69 | 9.16 | 9.44 | 610900.0 |
| 2005-04-29 | CHIC | ETF | 10.96 | 11.03 | 10.44 | 10.69 | 346809.0 |
| 2005-04-29 | CHIR | ETF | 33.8001 | 34.17 | 32.85 | 34.1499 | 1700239.0 |
| 2005-04-29 | CIL | ETF | 26.25 | 26.36 | 26.25 | 26.25 | 6700.0 |
| 2005-04-29 | CN | ETF | 26.86 | 26.9 | 26.52 | 26.75 | 8700.0 |
| 2005-04-29 | CNXT | ETF | 1.15 | 1.16 | 1.08 | 1.12 | 9788736.0 |
| 2005-04-29 | CSB | ETF | 31.52 | 31.64 | 31.36 | 31.5 | 24100.0 |
| 2005-04-29 | CSM | ETF | 2.385 | 2.385 | 2.385 | 2.385 | 18000.0 |
| 2005-04-29 | CTEC | ETF | 52.0 | 52.5 | 49.199999999999996 | 51.6 | 18316.4 |
| 2005-04-29 | CURE | ETF | 0.18 | 0.21 | 0.1725 | 0.2 | 12800552.0 |
| 2005-04-29 | CYA | ETF | 151.8 | 151.8 | 135.0 | 142.0 | 600.0 |
| 2005-04-29 | CYB | ETF | 3.4 | 3.55 | 3.35 | 3.55 | 13500.0 |
| 2005-04-29 | CZA | ETF | 10.22 | 10.22 | 10.22 | 10.22 | 100.0 |
| 2005-04-29 | DGT | ETF | 62.4 | 62.92 | 62.29 | 62.92 | 33800.0 |
| 2005-04-29 | DIG | ETF | 11.0625 | 11.075 | 11.0625 | 11.075 | 560.0 |
| 2005-04-29 | DIV | ETF | 12.98 | 13.1 | 12.97 | 13.0 | 19800.0 |
| 2005-04-29 | DRIV | ETF | 27.18 | 27.45 | 26.06 | 26.6 | 1134979.0 |
| 2005-04-29 | DSI | ETF | 5.87 | 5.93 | 5.87 | 5.93 | 13800.0 |
| 2005-04-29 | DUSA | ETF | 9.97 | 10.46 | 9.5 | 10.445 | 170625.0 |
| 2005-04-29 | DVY | ETF | 59.05 | 59.6 | 58.7 | 59.55 | 389000.0 |
| 2005-04-29 | EDEN | ETF | 0.6 | 0.85 | 0.58 | 0.66 | 105313.0 |
| 2005-04-29 | EDV | ETF | 26.13 | 26.2 | 25.85 | 26.08 | 45000.0 |
> showing 50 of 256 rows — these rows as CSV