PREVIEW / etf_daily / 2005-05-19
file: by_date/etf_daily/2005/2005-05-19.parquet size: 14 KB rows: 261
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-05-19 | SPY | ETF | 119.02 | 119.41 | 118.7 | 119.29 | 61768100.0 |
| 2005-05-19 | QQQ | ETF | 37.29 | 37.52 | 37.2 | 37.512 | 93998428.0 |
| 2005-05-19 | IWM | ETF | 60.455 | 60.87 | 60.345 | 60.675 | 26642600.0 |
| 2005-05-19 | DIA | ETF | 104.96 | 105.2 | 104.59 | 105.14 | 5010200.0 |
| 2005-05-19 | GLD | ETF | 42.0 | 42.05 | 41.87 | 41.98 | 610200.0 |
| 2005-05-19 | TLT | ETF | 93.7 | 93.7 | 93.28 | 93.33 | 948800.0 |
| 2005-05-19 | AAA | ETF | 58.5 | 58.67 | 58.46 | 58.62 | 6900.0 |
| 2005-05-19 | ADRE | ETF | 85.34 | 86.4 | 85.34 | 86.33 | 52816.0 |
| 2005-05-19 | AFK | ETF | 26.41 | 26.5 | 26.33 | 26.5 | 5200.0 |
| 2005-05-19 | AGG | ETF | 102.32 | 102.37 | 102.04 | 102.25 | 64200.0 |
| 2005-05-19 | AIQ | ETF | 52.8 | 55.45 | 52.8 | 55.15 | 49840.0 |
| 2005-05-19 | ARB | ETF | 40.96 | 41.18 | 40.86 | 41.17 | 121900.0 |
| 2005-05-19 | BAB | ETF | 49.71 | 50.2 | 49.66 | 50.2 | 15200.0 |
| 2005-05-19 | BBH | ETF | 54.34 | 54.85 | 54.1767 | 54.8167 | 2205000.0 |
| 2005-05-19 | BCM | ETF | 59.39 | 59.8 | 59.38 | 59.8 | 320900.0 |
| 2005-05-19 | BIS | ETF | 636.8 | 664.0 | 630.4 | 664.0 | 31.25 |
| 2005-05-19 | BITS | ETF | 10.8 | 10.8 | 10.28 | 10.28 | 1260.0 |
| 2005-05-19 | BKF | ETF | 33.1 | 33.85 | 33.1 | 33.64 | 139800.0 |
| 2005-05-19 | BNE | ETF | 12.51 | 12.82 | 12.5 | 12.78 | 188400.0 |
| 2005-05-19 | BRF | ETF | 15.34 | 15.34 | 15.33 | 15.33 | 1700.0 |
| 2005-05-19 | BTF | ETF | 84.19999999999999 | 84.49999999999999 | 84.19999999999999 | 84.255 | 280.0 |
| 2005-05-19 | CBON | ETF | 26.69 | 27.48 | 26.51 | 27.05 | 6424.0 |
| 2005-05-19 | CDC | ETF | 7.3 | 8.1 | 7.14 | 7.14 | 2000.0 |
| 2005-05-19 | CDL | ETF | 11.63 | 11.89 | 11.57 | 11.86 | 288400.0 |
| 2005-05-19 | CEF | ETF | 5.15 | 5.17 | 5.11 | 5.15 | 267900.0 |
| 2005-05-19 | CEW | ETF | 26.6 | 26.6 | 26.6 | 26.6 | 300.0 |
| 2005-05-19 | CHB | ETF | 10.06 | 10.13 | 9.96 | 10.08 | 374800.0 |
| 2005-05-19 | CHIC | ETF | 10.8 | 10.96 | 10.8 | 10.95 | 110161.0 |
| 2005-05-19 | CHIR | ETF | 36.5799 | 36.75 | 36.2001 | 36.72 | 902209.0 |
| 2005-05-19 | CIL | ETF | 26.38 | 26.38 | 26.38 | 26.38 | 600.0 |
| 2005-05-19 | CN | ETF | 27.2 | 27.28 | 27.0 | 27.01 | 15700.0 |
| 2005-05-19 | CNXT | ETF | 1.18 | 1.24 | 1.18 | 1.21 | 3415192.0 |
| 2005-05-19 | CPI | ETF | 22.55 | 22.7 | 22.51 | 22.7 | 2900.0 |
| 2005-05-19 | CSB | ETF | 30.85 | 30.97 | 30.54 | 30.91 | 15500.0 |
| 2005-05-19 | CTEC | ETF | 49.0 | 49.3 | 47.85 | 48.550000000000004 | 18794.0 |
| 2005-05-19 | CURE | ETF | 0.2631 | 0.275 | 0.26 | 0.2712 | 999696.0 |
| 2005-05-19 | CYA | ETF | 146.0 | 154.0 | 146.0 | 152.0 | 290.0 |
| 2005-05-19 | CYB | ETF | 3.16 | 3.16 | 3.12 | 3.15 | 1500.0 |
| 2005-05-19 | CZA | ETF | 10.26 | 10.55 | 10.26 | 10.38 | 9100.0 |
| 2005-05-19 | DGT | ETF | 63.7 | 63.93 | 63.7 | 63.93 | 6200.0 |
| 2005-05-19 | DIG | ETF | 10.75 | 10.8125 | 10.75 | 10.8125 | 1920.0 |
| 2005-05-19 | DIV | ETF | 13.28 | 13.29 | 13.23 | 13.28 | 7700.0 |
| 2005-05-19 | DRIV | ETF | 25.1 | 26.34 | 25.1 | 26.34 | 2009781.0 |
| 2005-05-19 | DSI | ETF | 6.04 | 6.065 | 6.02 | 6.02 | 5200.0 |
| 2005-05-19 | DUSA | ETF | 10.88 | 10.9 | 10.45 | 10.8 | 116813.0 |
| 2005-05-19 | DVY | ETF | 61.4 | 61.4 | 60.92 | 61.27 | 519000.0 |
| 2005-05-19 | EDEN | ETF | 0.76 | 0.8 | 0.62 | 0.73 | 181380.0 |
| 2005-05-19 | EDV | ETF | 26.18 | 26.3 | 26.17 | 26.29 | 7000.0 |
| 2005-05-19 | EEM | ETF | 22.9356 | 23.0111 | 22.8611 | 22.9578 | 4374900.0 |
| 2005-05-19 | EFA | ETF | 51.9733 | 52.1633 | 51.9333 | 52.1533 | 1799400.0 |
> showing 50 of 261 rows — these rows as CSV