PREVIEW / etf_daily / 2005-08-02
file: by_date/etf_daily/2005/2005-08-02.parquet size: 15 KB rows: 274
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-08-02 | SPY | ETF | 123.87 | 124.6 | 123.74 | 124.39 | 45147400.0 |
| 2005-08-02 | QQQ | ETF | 39.7 | 40.14 | 39.654 | 40.08 | 79724703.0 |
| 2005-08-02 | IWM | ETF | 68.03 | 68.52 | 68.0 | 68.37 | 16505300.0 |
| 2005-08-02 | DIA | ETF | 106.47 | 107.0 | 106.36 | 106.71 | 4396000.0 |
| 2005-08-02 | GLD | ETF | 43.07 | 43.15 | 42.99 | 43.14 | 699600.0 |
| 2005-08-02 | TLT | ETF | 92.27 | 92.46 | 91.96 | 92.12 | 1071400.0 |
| 2005-08-02 | AAA | ETF | 53.5 | 53.5 | 53.376 | 53.49 | 5300.0 |
| 2005-08-02 | ADRE | ETF | 98.69 | 99.82 | 98.69 | 99.82 | 29908.0 |
| 2005-08-02 | AFK | ETF | 25.88 | 25.88 | 25.72 | 25.8 | 2500.0 |
| 2005-08-02 | AGG | ETF | 101.52 | 101.58 | 101.2 | 101.37 | 90200.0 |
| 2005-08-02 | AIQ | ETF | 50.4 | 51.9 | 50.35 | 51.35 | 19000.0 |
| 2005-08-02 | AIS | ETF | 1.09 | 1.1 | 1.04 | 1.1 | 73700.0 |
| 2005-08-02 | ARB | ETF | 41.58 | 41.8 | 41.42 | 41.6 | 200500.0 |
| 2005-08-02 | BAB | ETF | 51.0 | 51.18 | 50.8 | 51.18 | 39100.0 |
| 2005-08-02 | BBH | ETF | 65.2767 | 65.51 | 64.8167 | 65.2033 | 1351800.0 |
| 2005-08-02 | BCM | ETF | 66.12 | 67.02 | 66.11 | 66.36 | 175000.0 |
| 2005-08-02 | BIS | ETF | 696.0 | 696.0 | 662.4 | 662.4 | 13.1 |
| 2005-08-02 | BITS | ETF | 13.796 | 13.8 | 13.512 | 13.632 | 2000.0 |
| 2005-08-02 | BKF | ETF | 34.35 | 34.38 | 34.0 | 34.1 | 20500.0 |
| 2005-08-02 | BNE | ETF | 13.85 | 14.18 | 13.85 | 14.04 | 221600.0 |
| 2005-08-02 | BRF | ETF | 15.43 | 15.6 | 15.43 | 15.58 | 7100.0 |
| 2005-08-02 | BTF | ETF | 87.10000000000001 | 87.69999999999999 | 87.10000000000001 | 87.65 | 1740.0 |
| 2005-08-02 | CBON | ETF | 33.37 | 33.68 | 31.43 | 33.49 | 39848.0 |
| 2005-08-02 | CDC | ETF | 5.85 | 5.95 | 5.45 | 5.5 | 6200.0 |
| 2005-08-02 | CDL | ETF | 12.68 | 12.9 | 12.62 | 12.87 | 503400.0 |
| 2005-08-02 | CEF | ETF | 5.25 | 5.28 | 5.24 | 5.26 | 185300.0 |
| 2005-08-02 | CHB | ETF | 12.61 | 12.7 | 12.26 | 12.55 | 212800.0 |
| 2005-08-02 | CHI | ETF | 20.38 | 20.52 | 20.38 | 20.51 | 102900.0 |
| 2005-08-02 | CHIC | ETF | 14.67 | 14.75 | 14.51 | 14.65 | 125681.0 |
| 2005-08-02 | CHIR | ETF | 36.5601 | 36.9999 | 36.3 | 36.8001 | 855117.0 |
| 2005-08-02 | CHY | ETF | 16.64 | 16.68 | 16.61 | 16.68 | 103500.0 |
| 2005-08-02 | CIL | ETF | 25.84 | 25.84 | 25.84 | 25.84 | 700.0 |
| 2005-08-02 | CIZ | ETF | 22.6 | 23.2 | 22.55 | 23.2 | 9800.0 |
| 2005-08-02 | CN | ETF | 32.7 | 32.74 | 32.24 | 32.74 | 35800.0 |
| 2005-08-02 | CNXT | ETF | 1.955 | 1.97 | 1.91 | 1.93 | 3346526.0 |
| 2005-08-02 | CPI | ETF | 23.47 | 23.47 | 23.47 | 23.47 | 400.0 |
| 2005-08-02 | CPST | ETF | 1.97 | 2.2 | 1.96 | 2.2 | 2429909.0 |
| 2005-08-02 | CSB | ETF | 30.45 | 30.55 | 30.25 | 30.33 | 3200.0 |
| 2005-08-02 | CSQ | ETF | 14.37 | 14.42 | 14.29 | 14.42 | 324700.0 |
| 2005-08-02 | CTEC | ETF | 56.95 | 59.45 | 55.9 | 58.2 | 16122.6 |
| 2005-08-02 | CURE | ETF | 0.3187 | 0.3563 | 0.3187 | 0.35 | 2743552.0 |
| 2005-08-02 | CYA | ETF | 128.0 | 128.0 | 120.0 | 120.0 | 965.0 |
| 2005-08-02 | CYB | ETF | 3.72 | 3.75 | 3.6 | 3.7 | 34000.0 |
| 2005-08-02 | DGT | ETF | 64.5 | 65.05 | 64.5 | 64.93 | 13000.0 |
| 2005-08-02 | DIG | ETF | 12.2125 | 12.375 | 12.2125 | 12.325 | 4080.0 |
| 2005-08-02 | DIV | ETF | 13.88 | 13.96 | 13.86 | 13.91 | 21500.0 |
| 2005-08-02 | DRIV | ETF | 39.4 | 39.71 | 38.76 | 39.52 | 1237869.0 |
| 2005-08-02 | DSI | ETF | 5.795 | 5.855 | 5.795 | 5.845 | 4800.0 |
| 2005-08-02 | DUSA | ETF | 9.3 | 9.49 | 9.19 | 9.42 | 118758.0 |
| 2005-08-02 | DVY | ETF | 63.8 | 64.31 | 63.8 | 64.3 | 402700.0 |
> showing 50 of 274 rows — these rows as CSV