PREVIEW / etf_daily / 2005-09-29
file: by_date/etf_daily/2005/2005-09-29.parquet size: 15 KB rows: 277
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-09-29 | SPY | ETF | 121.55 | 122.86 | 121.08 | 122.66 | 66607700.0 |
| 2005-09-29 | QQQ | ETF | 38.63 | 39.211 | 38.445 | 39.2 | 117774063.0 |
| 2005-09-29 | IWM | ETF | 65.25 | 66.15 | 64.81 | 66.03 | 24484600.0 |
| 2005-09-29 | DIA | ETF | 104.6 | 105.55 | 104.1 | 105.4 | 9185600.0 |
| 2005-09-29 | GLD | ETF | 46.86 | 47.23 | 46.83 | 47.1 | 2947200.0 |
| 2005-09-29 | TLT | ETF | 92.6 | 92.61 | 92.36 | 92.52 | 657100.0 |
| 2005-09-29 | AAA | ETF | 55.41 | 55.9 | 55.4 | 55.86 | 2900.0 |
| 2005-09-29 | ADRE | ETF | 108.17 | 108.82 | 107.9 | 108.81 | 35096.0 |
| 2005-09-29 | AFK | ETF | 25.51 | 25.52 | 25.43 | 25.43 | 9600.0 |
| 2005-09-29 | AGG | ETF | 101.72 | 101.79 | 101.57 | 101.6 | 137100.0 |
| 2005-09-29 | AIQ | ETF | 42.5 | 43.7 | 42.25 | 43.25 | 9000.0 |
| 2005-09-29 | AIS | ETF | 0.91 | 0.94 | 0.86 | 0.87 | 177300.0 |
| 2005-09-29 | ARB | ETF | 39.53 | 40.35 | 39.24 | 40.35 | 132500.0 |
| 2005-09-29 | BAB | ETF | 51.27 | 51.8 | 51.06 | 51.8 | 15400.0 |
| 2005-09-29 | BBC | ETF | 7.39 | 7.39 | 7.0 | 7.12 | 43500.0 |
| 2005-09-29 | BBH | ETF | 62.96 | 63.3333 | 62.73 | 63.28 | 1469100.0 |
| 2005-09-29 | BCM | ETF | 61.98 | 62.33 | 61.64 | 61.91 | 40300.0 |
| 2005-09-29 | BITS | ETF | 11.28 | 11.6 | 10.68 | 11.272 | 4348.0 |
| 2005-09-29 | BKF | ETF | 32.29 | 32.29 | 31.77 | 31.94 | 41700.0 |
| 2005-09-29 | BNE | ETF | 14.0 | 14.29 | 13.94 | 14.26 | 73500.0 |
| 2005-09-29 | BRF | ETF | 15.3 | 15.37 | 15.27 | 15.27 | 4200.0 |
| 2005-09-29 | BTF | ETF | 85.25 | 85.55 | 84.89999999999999 | 85.19999999999999 | 1380.0 |
| 2005-09-29 | CBON | ETF | 32.5 | 32.72 | 32.49 | 32.72 | 19679.0 |
| 2005-09-29 | CDC | ETF | 4.21 | 4.21 | 4.05 | 4.11 | 5300.0 |
| 2005-09-29 | CDL | ETF | 13.48 | 13.71 | 13.37 | 13.6 | 131300.0 |
| 2005-09-29 | CEF | ETF | 5.62 | 5.75 | 5.62 | 5.74 | 367200.0 |
| 2005-09-29 | CEW | ETF | 26.0 | 26.0 | 25.92 | 25.92 | 700.0 |
| 2005-09-29 | CHB | ETF | 14.01 | 14.84 | 14.01 | 14.66 | 1822600.0 |
| 2005-09-29 | CHI | ETF | 19.82 | 20.02 | 19.8 | 19.97 | 78300.0 |
| 2005-09-29 | CHIC | ETF | 13.45 | 13.59 | 12.95 | 13.31 | 480223.0 |
| 2005-09-29 | CHIR | ETF | 43.2501 | 43.56 | 43.1001 | 43.41 | 1512617.0 |
| 2005-09-29 | CHY | ETF | 16.14 | 16.3 | 16.1227 | 16.29 | 87000.0 |
| 2005-09-29 | CN | ETF | 33.98 | 34.6 | 33.98 | 34.0 | 33800.0 |
| 2005-09-29 | CNXT | ETF | 1.85 | 1.89 | 1.84 | 1.88 | 5197509.0 |
| 2005-09-29 | COMB | ETF | 7.62 | 8.16 | 7.62 | 8.16 | 6000.0 |
| 2005-09-29 | CPI | ETF | 24.1 | 24.15 | 24.1 | 24.15 | 400.0 |
| 2005-09-29 | CPST | ETF | 3.47 | 3.99 | 3.37 | 3.77 | 17380423.0 |
| 2005-09-29 | CSB | ETF | 28.75 | 29.076 | 28.69 | 29.076 | 14800.0 |
| 2005-09-29 | CSQ | ETF | 13.9 | 14.11 | 13.89 | 14.03 | 362700.0 |
| 2005-09-29 | CTEC | ETF | 49.65 | 50.449999999999996 | 49.55 | 50.35 | 4340.0 |
| 2005-09-29 | CURE | ETF | 0.1237 | 0.1275 | 0.1113 | 0.1175 | 9011840.0 |
| 2005-09-29 | CYA | ETF | 77.0 | 77.0 | 72.8 | 73.8 | 1225.0 |
| 2005-09-29 | CYB | ETF | 3.8 | 3.8 | 3.778 | 3.778 | 2600.0 |
| 2005-09-29 | DGT | ETF | 64.68 | 64.95 | 64.58 | 64.95 | 12300.0 |
| 2005-09-29 | DIG | ETF | 14.7 | 14.8125 | 14.625 | 14.8125 | 6400.0 |
| 2005-09-29 | DIV | ETF | 13.15 | 13.2 | 13.1 | 13.19 | 16900.0 |
| 2005-09-29 | DRIV | ETF | 33.85 | 34.65 | 33.5275 | 34.56 | 623665.0 |
| 2005-09-29 | DSI | ETF | 5.66 | 5.71 | 5.66 | 5.675 | 13400.0 |
| 2005-09-29 | DUSA | ETF | 10.57 | 10.76 | 10.401 | 10.68 | 119624.0 |
| 2005-09-29 | DVY | ETF | 61.95 | 62.44 | 61.51 | 62.41 | 796400.0 |
> showing 50 of 277 rows — these rows as CSV