PREVIEW / etf_daily / 2005-10-13
file: by_date/etf_daily/2005/2005-10-13.parquet size: 15 KB rows: 278
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-10-13 | SPY | ETF | 117.46 | 118.08 | 116.88 | 117.43 | 99052900.0 |
| 2005-10-13 | QQQ | ETF | 37.47 | 37.91 | 37.33 | 37.78 | 138583649.0 |
| 2005-10-13 | IWM | ETF | 61.64 | 62.14 | 61.05 | 61.87 | 48558500.0 |
| 2005-10-13 | DIA | ETF | 102.03 | 102.44 | 101.58 | 101.96 | 8091400.0 |
| 2005-10-13 | GLD | ETF | 46.89 | 47.06 | 46.6 | 47.02 | 2632300.0 |
| 2005-10-13 | TLT | ETF | 90.25 | 90.5 | 90.08 | 90.37 | 1376600.0 |
| 2005-10-13 | AAA | ETF | 54.54 | 54.54 | 53.66 | 54.31 | 4400.0 |
| 2005-10-13 | ADRE | ETF | 101.4 | 101.421 | 99.47 | 100.96 | 50964.0 |
| 2005-10-13 | AFK | ETF | 25.6 | 25.64 | 25.4 | 25.4 | 4400.0 |
| 2005-10-13 | AGG | ETF | 100.66 | 100.72 | 100.31 | 100.53 | 108000.0 |
| 2005-10-13 | AIQ | ETF | 36.0 | 36.0 | 34.05 | 34.5 | 103600.0 |
| 2005-10-13 | AIS | ETF | 0.92 | 0.99 | 0.92 | 0.99 | 82300.0 |
| 2005-10-13 | ARB | ETF | 38.15 | 38.96 | 38.0 | 38.2 | 174800.0 |
| 2005-10-13 | BAB | ETF | 52.55 | 53.05 | 52.35 | 52.95 | 50800.0 |
| 2005-10-13 | BBC | ETF | 6.8 | 7.08 | 6.8 | 7.0 | 38800.0 |
| 2005-10-13 | BBH | ETF | 60.2667 | 61.7733 | 60.2633 | 61.4267 | 2990700.0 |
| 2005-10-13 | BCM | ETF | 60.45 | 60.59 | 59.81 | 60.21 | 29700.0 |
| 2005-10-13 | BITS | ETF | 10.6 | 10.96 | 10.6 | 10.72 | 1075.0 |
| 2005-10-13 | BKF | ETF | 25.08 | 25.08 | 24.63 | 24.95 | 29300.0 |
| 2005-10-13 | BNE | ETF | 13.27 | 14.05 | 13.27 | 13.8 | 171100.0 |
| 2005-10-13 | BRF | ETF | 15.26 | 15.39 | 15.18 | 15.39 | 17600.0 |
| 2005-10-13 | BTF | ETF | 85.95 | 85.95 | 85.35 | 85.35 | 260.0 |
| 2005-10-13 | CBON | ETF | 32.34 | 32.35 | 31.17 | 31.34 | 16039.0 |
| 2005-10-13 | CDL | ETF | 13.98 | 13.98 | 13.7 | 13.83 | 802600.0 |
| 2005-10-13 | CEF | ETF | 5.7 | 5.74 | 5.65 | 5.7 | 463400.0 |
| 2005-10-13 | CHB | ETF | 12.69 | 13.03 | 12.3 | 12.71 | 1101000.0 |
| 2005-10-13 | CHI | ETF | 19.2 | 19.22 | 18.5 | 18.8 | 262100.0 |
| 2005-10-13 | CHIC | ETF | 14.4 | 14.75 | 14.1 | 14.59 | 389311.0 |
| 2005-10-13 | CHIR | ETF | 43.05 | 43.3701 | 42.9999 | 43.17 | 1045764.0 |
| 2005-10-13 | CHY | ETF | 15.59 | 15.5909 | 14.91 | 15.25 | 281200.0 |
| 2005-10-13 | CIL | ETF | 25.96 | 25.96 | 25.96 | 25.96 | 1000.0 |
| 2005-10-13 | CIZ | ETF | 21.65 | 21.8 | 21.65 | 21.8 | 600.0 |
| 2005-10-13 | CN | ETF | 31.45 | 31.6 | 31.4 | 31.6 | 16100.0 |
| 2005-10-13 | CNXT | ETF | 1.76 | 1.7809 | 1.73 | 1.77 | 5804593.0 |
| 2005-10-13 | CPST | ETF | 2.84 | 2.89 | 2.61 | 2.68 | 3785286.0 |
| 2005-10-13 | CSB | ETF | 28.75 | 29.0 | 28.72 | 28.98 | 3800.0 |
| 2005-10-13 | CSM | ETF | 2.4375 | 2.4375 | 2.425 | 2.425 | 132000.0 |
| 2005-10-13 | CSQ | ETF | 13.29 | 13.4 | 13.02 | 13.18 | 378500.0 |
| 2005-10-13 | CTEC | ETF | 45.05 | 46.95 | 45.0 | 45.8 | 7570.0 |
| 2005-10-13 | CURE | ETF | 0.1025 | 0.1025 | 0.095 | 0.1013 | 756720.0 |
| 2005-10-13 | CYB | ETF | 3.2801 | 3.368 | 3.28 | 3.29 | 8000.0 |
| 2005-10-13 | DGT | ETF | 62.9 | 63.08 | 62.85 | 63.08 | 2000.0 |
| 2005-10-13 | DIG | ETF | 14.625 | 14.625 | 14.3625 | 14.3625 | 19280.0 |
| 2005-10-13 | DIV | ETF | 12.38 | 12.38 | 11.9 | 11.9 | 50500.0 |
| 2005-10-13 | DRIV | ETF | 32.6 | 34.15 | 32.6 | 33.88 | 1167391.0 |
| 2005-10-13 | DSI | ETF | 5.62 | 5.62 | 5.615 | 5.615 | 3000.0 |
| 2005-10-13 | DUSA | ETF | 9.64 | 9.88 | 9.39 | 9.7 | 61413.0 |
| 2005-10-13 | DVY | ETF | 59.17 | 59.25 | 58.46 | 58.98 | 1824600.0 |
| 2005-10-13 | EDEN | ETF | 0.68 | 0.7 | 0.6 | 0.66 | 46470.0 |
| 2005-10-13 | EDV | ETF | 25.5 | 25.59 | 25.47 | 25.5 | 8500.0 |
> showing 50 of 278 rows — these rows as CSV