PREVIEW / etf_daily / 2005-04-20
file: by_date/etf_daily/2005/2005-04-20.parquet size: 14 KB rows: 260
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-20 | SPY | ETF | 115.38 | 115.63 | 113.55 | 113.8 | 107735900.0 |
| 2005-04-20 | QQQ | ETF | 35.21 | 35.29 | 34.59 | 34.704 | 140456063.0 |
| 2005-04-20 | IWM | ETF | 59.2 | 59.3 | 58.09 | 58.225 | 31657400.0 |
| 2005-04-20 | DIA | ETF | 101.51 | 101.78 | 99.89 | 100.14 | 12009900.0 |
| 2005-04-20 | GLD | ETF | 43.21 | 43.52 | 43.19 | 43.4 | 1248100.0 |
| 2005-04-20 | TLT | ETF | 91.22 | 91.77 | 91.18 | 91.67 | 1617900.0 |
| 2005-04-20 | AAA | ETF | 66.0 | 66.48 | 66.0 | 66.19 | 9400.0 |
| 2005-04-20 | ADRE | ETF | 83.0 | 83.0 | 81.201 | 81.201 | 2096.0 |
| 2005-04-20 | AFK | ETF | 25.71 | 25.77 | 25.7 | 25.7 | 17100.0 |
| 2005-04-20 | AGG | ETF | 101.94 | 102.15 | 101.71 | 102.14 | 114900.0 |
| 2005-04-20 | AIQ | ETF | 48.7 | 49.25 | 47.4 | 47.65 | 23660.0 |
| 2005-04-20 | ARB | ETF | 42.25 | 42.32 | 40.99 | 41.04 | 467600.0 |
| 2005-04-20 | BAB | ETF | 47.75 | 47.95 | 47.15 | 47.15 | 24200.0 |
| 2005-04-20 | BBH | ETF | 51.32 | 51.8 | 51.1533 | 51.5633 | 3857400.0 |
| 2005-04-20 | BCM | ETF | 58.45 | 59.4 | 58.45 | 58.99 | 9900.0 |
| 2005-04-20 | BIS | ETF | 588.8 | 620.8 | 588.8 | 620.8 | 7.5 |
| 2005-04-20 | BITS | ETF | 12.0 | 12.0 | 10.96 | 11.12 | 10348.0 |
| 2005-04-20 | BKF | ETF | 37.42 | 37.5 | 36.95 | 37.01 | 39300.0 |
| 2005-04-20 | BNE | ETF | 14.25 | 14.3 | 13.95 | 13.97 | 304200.0 |
| 2005-04-20 | BRF | ETF | 15.37 | 15.39 | 15.36 | 15.39 | 1800.0 |
| 2005-04-20 | BTF | ETF | 86.85 | 86.85 | 85.85000000000001 | 86.8 | 2360.0 |
| 2005-04-20 | CBON | ETF | 25.0 | 25.2 | 24.65 | 24.66 | 3950.0 |
| 2005-04-20 | CDC | ETF | 8.1 | 8.1 | 8.01 | 8.01 | 900.0 |
| 2005-04-20 | CDL | ETF | 13.17 | 13.2 | 13.1 | 13.2 | 320400.0 |
| 2005-04-20 | CEF | ETF | 5.43 | 5.49 | 5.3 | 5.44 | 238500.0 |
| 2005-04-20 | CHB | ETF | 9.15 | 10.03 | 9.15 | 9.52 | 2356000.0 |
| 2005-04-20 | CHIC | ETF | 11.47 | 11.5 | 11.07 | 11.19 | 429617.0 |
| 2005-04-20 | CHIR | ETF | 34.5801 | 34.8999 | 33.8301 | 34.2501 | 1768228.0 |
| 2005-04-20 | CID | ETF | 9.6 | 9.6 | 9.6 | 9.6 | 100.0 |
| 2005-04-20 | CIZ | ETF | 20.3 | 20.3 | 20.2 | 20.2 | 1100.0 |
| 2005-04-20 | CN | ETF | 25.7 | 25.7 | 25.28 | 25.45 | 11700.0 |
| 2005-04-20 | CNXT | ETF | 1.36 | 1.36 | 1.21 | 1.22 | 7662117.0 |
| 2005-04-20 | CSB | ETF | 32.76 | 32.95 | 32.45 | 32.45 | 12100.0 |
| 2005-04-20 | CSM | ETF | 2.385 | 2.385 | 2.38 | 2.385 | 8800.0 |
| 2005-04-20 | CTEC | ETF | 56.5 | 58.550000000000004 | 55.8 | 56.9 | 7403.400000000001 |
| 2005-04-20 | CURE | ETF | 0.33 | 0.3312 | 0.2975 | 0.2975 | 1477432.0 |
| 2005-04-20 | CYA | ETF | 160.0 | 162.6 | 159.0 | 162.6 | 330.0 |
| 2005-04-20 | CYB | ETF | 4.27 | 4.27 | 4.2 | 4.21 | 6700.0 |
| 2005-04-20 | CZA | ETF | 10.15 | 10.15 | 10.07 | 10.07 | 6400.0 |
| 2005-04-20 | DGT | ETF | 62.4 | 62.95 | 62.13 | 62.13 | 4700.0 |
| 2005-04-20 | DIG | ETF | 11.875 | 11.875 | 11.875 | 11.875 | 5200.0 |
| 2005-04-20 | DIV | ETF | 13.05 | 13.05 | 12.91 | 12.91 | 13700.0 |
| 2005-04-20 | DJP | ETF | 27.11 | 27.11 | 27.11 | 27.11 | 1900.0 |
| 2005-04-20 | DRIV | ETF | 29.65 | 29.9 | 28.85 | 29.01 | 733703.0 |
| 2005-04-20 | DSI | ETF | 5.855 | 5.875 | 5.835 | 5.86 | 9200.0 |
| 2005-04-20 | DUSA | ETF | 9.85 | 9.95 | 9.52 | 9.77 | 110174.0 |
| 2005-04-20 | DVY | ETF | 59.16 | 59.19 | 58.15 | 58.22 | 822900.0 |
| 2005-04-20 | EDEN | ETF | 0.6 | 0.61 | 0.53 | 0.55 | 55929.0 |
| 2005-04-20 | EDV | ETF | 25.85 | 26.02 | 25.85 | 25.96 | 4500.0 |
| 2005-04-20 | EEM | ETF | 22.3444 | 22.3444 | 21.7978 | 21.7978 | 5861700.0 |
> showing 50 of 260 rows — these rows as CSV