PREVIEW / etf_daily / 2005-05-04
file: by_date/etf_daily/2005/2005-05-04.parquet size: 14 KB rows: 259
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-04 | SPY | ETF | 116.65 | 117.75 | 116.28 | 117.5 | 81055700.0 |
| 2005-05-04 | QQQ | ETF | 35.29 | 35.832 | 35.24 | 35.728 | 90934885.0 |
| 2005-05-04 | IWM | ETF | 58.385 | 59.275 | 58.215 | 59.15 | 23520000.0 |
| 2005-05-04 | DIA | ETF | 103.01 | 103.93 | 102.67 | 103.77 | 8803600.0 |
| 2005-05-04 | GLD | ETF | 42.87 | 42.92 | 42.73 | 42.9 | 607600.0 |
| 2005-05-04 | TLT | ETF | 91.45 | 91.72 | 91.05 | 91.53 | 2211500.0 |
| 2005-05-04 | AAA | ETF | 59.8 | 60.08 | 59.8 | 60.0 | 25100.0 |
| 2005-05-04 | ADRE | ETF | 81.7 | 84.72 | 81.7 | 84.72 | 4592.0 |
| 2005-05-04 | AFK | ETF | 26.15 | 26.15 | 25.95 | 25.95 | 4200.0 |
| 2005-05-04 | AGG | ETF | 101.92 | 102.09 | 101.65 | 102.03 | 63900.0 |
| 2005-05-04 | AIQ | ETF | 50.0 | 51.1 | 48.9 | 50.9 | 34820.0 |
| 2005-05-04 | ARB | ETF | 40.95 | 40.95 | 39.49 | 39.53 | 597600.0 |
| 2005-05-04 | BAB | ETF | 46.46 | 47.57 | 46.46 | 47.56 | 23000.0 |
| 2005-05-04 | BBH | ETF | 53.0367 | 53.5533 | 52.94 | 53.54 | 1706400.0 |
| 2005-05-04 | BCM | ETF | 59.59 | 60.08 | 59.59 | 59.99 | 9000.0 |
| 2005-05-04 | BITS | ETF | 10.28 | 10.52 | 9.8 | 10.04 | 3450.0 |
| 2005-05-04 | BKF | ETF | 35.15 | 35.15 | 34.55 | 34.6 | 17800.0 |
| 2005-05-04 | BNE | ETF | 12.93 | 13.14 | 12.88 | 13.0 | 268400.0 |
| 2005-05-04 | BRF | ETF | 15.46 | 15.46 | 15.41 | 15.41 | 9900.0 |
| 2005-05-04 | BTF | ETF | 84.74999999999999 | 85.0 | 84.04999999999998 | 85.0 | 2740.0 |
| 2005-05-04 | CBON | ETF | 23.86 | 24.0 | 23.68 | 23.71 | 13421.0 |
| 2005-05-04 | CDC | ETF | 7.65 | 7.79 | 7.65 | 7.79 | 1500.0 |
| 2005-05-04 | CDL | ETF | 12.43 | 12.65 | 12.41 | 12.57 | 427100.0 |
| 2005-05-04 | CEF | ETF | 5.4 | 5.42 | 5.35 | 5.41 | 336500.0 |
| 2005-05-04 | CEW | ETF | 26.32 | 26.45 | 26.32 | 26.45 | 900.0 |
| 2005-05-04 | CGW | ETF | 28.11 | 28.11 | 28.11 | 28.11 | 100.0 |
| 2005-05-04 | CHB | ETF | 10.02 | 10.19 | 9.92 | 10.11 | 569300.0 |
| 2005-05-04 | CHIC | ETF | 10.56 | 10.84 | 10.56 | 10.82 | 193301.0 |
| 2005-05-04 | CHIR | ETF | 34.8501 | 35.4399 | 34.5201 | 35.37 | 1243038.0 |
| 2005-05-04 | CIZ | ETF | 20.7 | 20.7 | 20.7 | 20.7 | 100.0 |
| 2005-05-04 | CN | ETF | 27.43 | 27.75 | 27.43 | 27.75 | 6900.0 |
| 2005-05-04 | CNXT | ETF | 1.055 | 1.1 | 0.95 | 1.1 | 24811671.0 |
| 2005-05-04 | CPI | ETF | 21.8 | 22.1 | 21.7 | 22.1 | 17000.0 |
| 2005-05-04 | CSB | ETF | 31.8 | 31.94 | 31.62 | 31.94 | 5700.0 |
| 2005-05-04 | CSM | ETF | 2.385 | 2.3875 | 2.385 | 2.3875 | 12000.0 |
| 2005-05-04 | CTEC | ETF | 55.49999999999999 | 57.75 | 55.0 | 55.05 | 13236.800000000001 |
| 2005-05-04 | CURE | ETF | 0.2462 | 0.2587 | 0.2275 | 0.235 | 3026152.0 |
| 2005-05-04 | CYA | ETF | 160.0 | 165.0 | 160.0 | 165.0 | 220.0 |
| 2005-05-04 | CYB | ETF | 3.4 | 3.4 | 3.2 | 3.27 | 7800.0 |
| 2005-05-04 | CZA | ETF | 10.3 | 10.3 | 10.22 | 10.22 | 17300.0 |
| 2005-05-04 | DGT | ETF | 63.6 | 63.63 | 63.21 | 63.59 | 5200.0 |
| 2005-05-04 | DIG | ETF | 11.3125 | 11.5 | 11.3125 | 11.5 | 1680.0 |
| 2005-05-04 | DIV | ETF | 13.24 | 13.29 | 13.2 | 13.29 | 14700.0 |
| 2005-05-04 | DRIV | ETF | 26.71 | 28.02 | 26.7 | 27.98 | 1215049.0 |
| 2005-05-04 | DSI | ETF | 6.0 | 6.025 | 6.0 | 6.015 | 9400.0 |
| 2005-05-04 | DUSA | ETF | 10.74 | 10.74 | 10.32 | 10.49 | 41542.0 |
| 2005-05-04 | DVY | ETF | 60.34 | 60.83 | 60.07 | 60.78 | 545700.0 |
| 2005-05-04 | EDEN | ETF | 0.85 | 0.85 | 0.76 | 0.79 | 70273.0 |
| 2005-05-04 | EDV | ETF | 26.2 | 26.2 | 26.0 | 26.04 | 5000.0 |
| 2005-05-04 | EEM | ETF | 22.4444 | 23.0633 | 22.4444 | 22.9889 | 13998600.0 |
> showing 50 of 259 rows — these rows as CSV