PREVIEW / etf_daily / 2005-08-24
file: by_date/etf_daily/2005/2005-08-24.parquet size: 15 KB rows: 280
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-24 | SPY | ETF | 121.94 | 122.73 | 121.09 | 121.15 | 79104600.0 |
| 2005-08-24 | QQQ | ETF | 38.649 | 39.18 | 38.46 | 38.5 | 95038020.0 |
| 2005-08-24 | IWM | ETF | 65.24 | 66.03 | 64.91 | 65.21 | 28753000.0 |
| 2005-08-24 | DIA | ETF | 104.99 | 105.5 | 104.16 | 104.18 | 9086400.0 |
| 2005-08-24 | GLD | ETF | 43.94 | 43.96 | 43.41 | 43.59 | 894300.0 |
| 2005-08-24 | TLT | ETF | 94.27 | 94.33 | 93.85 | 94.2 | 998200.0 |
| 2005-08-24 | AAA | ETF | 56.6 | 56.82 | 56.52 | 56.53 | 1200.0 |
| 2005-08-24 | ADRE | ETF | 98.46 | 98.46 | 94.0 | 96.65 | 14888.0 |
| 2005-08-24 | AFK | ETF | 25.67 | 25.82 | 25.67 | 25.71 | 9900.0 |
| 2005-08-24 | AGG | ETF | 102.13 | 102.27 | 102.06 | 102.24 | 98900.0 |
| 2005-08-24 | AIQ | ETF | 45.45 | 47.7 | 45.45 | 46.75 | 19640.0 |
| 2005-08-24 | AIS | ETF | 0.83 | 0.95 | 0.83 | 0.9 | 207400.0 |
| 2005-08-24 | ARB | ETF | 42.5 | 42.7 | 41.83 | 41.85 | 87800.0 |
| 2005-08-24 | BAB | ETF | 51.4 | 51.72 | 51.0 | 51.0 | 17700.0 |
| 2005-08-24 | BBH | ETF | 63.2833 | 63.7367 | 62.84 | 62.9867 | 1440600.0 |
| 2005-08-24 | BCM | ETF | 57.61 | 58.68 | 57.61 | 57.76 | 47300.0 |
| 2005-08-24 | BIS | ETF | 656.0 | 664.0 | 656.0 | 664.0 | 26.25 |
| 2005-08-24 | BITS | ETF | 12.4 | 12.92 | 12.4 | 12.88 | 2550.0 |
| 2005-08-24 | BKF | ETF | 33.4 | 34.61 | 33.4 | 34.51 | 98500.0 |
| 2005-08-24 | BNE | ETF | 13.9 | 14.0 | 13.66 | 13.67 | 180500.0 |
| 2005-08-24 | BRF | ETF | 15.47 | 15.53 | 15.47 | 15.53 | 1900.0 |
| 2005-08-24 | BTF | ETF | 85.99999999999999 | 86.05 | 85.99999999999999 | 85.99999999999999 | 580.0 |
| 2005-08-24 | CBON | ETF | 32.93 | 33.0 | 32.68 | 32.9 | 10583.0 |
| 2005-08-24 | CDC | ETF | 3.75 | 3.75 | 3.4 | 3.6 | 6900.0 |
| 2005-08-24 | CDL | ETF | 13.75 | 13.87 | 13.7 | 13.77 | 410700.0 |
| 2005-08-24 | CEF | ETF | 5.38 | 5.39 | 5.32 | 5.33 | 725400.0 |
| 2005-08-24 | CHB | ETF | 11.39 | 11.64 | 11.07 | 11.27 | 604700.0 |
| 2005-08-24 | CHI | ETF | 20.11 | 20.2 | 20.06 | 20.11 | 105700.0 |
| 2005-08-24 | CHIC | ETF | 13.41 | 13.89 | 13.41 | 13.84 | 396421.0 |
| 2005-08-24 | CHIR | ETF | 35.3301 | 35.8101 | 35.07 | 35.0901 | 909661.0 |
| 2005-08-24 | CHY | ETF | 16.23 | 16.35 | 16.23 | 16.35 | 92300.0 |
| 2005-08-24 | CIL | ETF | 25.88 | 25.93 | 25.88 | 25.93 | 400.0 |
| 2005-08-24 | CIZ | ETF | 23.4 | 23.4 | 23.4 | 23.4 | 300.0 |
| 2005-08-24 | CN | ETF | 32.3 | 32.3 | 31.71 | 31.87 | 18700.0 |
| 2005-08-24 | CNXT | ETF | 1.65 | 1.68 | 1.63 | 1.67 | 2053160.0 |
| 2005-08-24 | CPI | ETF | 23.23 | 23.4 | 23.23 | 23.4 | 700.0 |
| 2005-08-24 | CPST | ETF | 3.12 | 4.13 | 3.1 | 3.83 | 15158741.0 |
| 2005-08-24 | CSB | ETF | 30.46 | 30.5 | 30.3 | 30.41 | 9400.0 |
| 2005-08-24 | CSQ | ETF | 14.12 | 14.2 | 14.05 | 14.06 | 382800.0 |
| 2005-08-24 | CTEC | ETF | 51.8 | 54.349999999999994 | 51.74999999999999 | 53.33 | 7915.400000000001 |
| 2005-08-24 | CURE | ETF | 0.25 | 0.2712 | 0.2475 | 0.2644 | 1690304.0 |
| 2005-08-24 | CYA | ETF | 69.0 | 69.0 | 66.6 | 66.6 | 635.0 |
| 2005-08-24 | CYB | ETF | 3.5 | 3.68 | 3.42 | 3.68 | 221400.0 |
| 2005-08-24 | DGT | ETF | 64.14 | 64.31 | 63.79 | 63.79 | 2900.0 |
| 2005-08-24 | DIG | ETF | 12.925 | 12.925 | 12.7875 | 12.7875 | 13760.0 |
| 2005-08-24 | DIV | ETF | 13.65 | 13.67 | 13.57 | 13.61 | 4100.0 |
| 2005-08-24 | DRIV | ETF | 39.0 | 39.43 | 38.105 | 38.5 | 581069.0 |
| 2005-08-24 | DSI | ETF | 5.745 | 5.745 | 5.735 | 5.735 | 2000.0 |
| 2005-08-24 | DUSA | ETF | 11.33 | 11.33 | 10.96 | 11.17 | 64616.0 |
| 2005-08-24 | DVY | ETF | 62.65 | 63.05 | 62.41 | 62.43 | 387200.0 |
> showing 50 of 280 rows — these rows as CSV