PREVIEW / etf_daily / 2005-09-12
file: by_date/etf_daily/2005/2005-09-12.parquet size: 15 KB rows: 277
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-09-12 | SPY | ETF | 124.45 | 124.67 | 124.27 | 124.35 | 33017600.0 |
| 2005-09-12 | QQQ | ETF | 39.63 | 39.863 | 39.58 | 39.73 | 51700997.0 |
| 2005-09-12 | IWM | ETF | 67.43 | 68.08 | 67.28 | 67.69 | 17628700.0 |
| 2005-09-12 | DIA | ETF | 106.7 | 107.01 | 106.63 | 106.81 | 4963100.0 |
| 2005-09-12 | GLD | ETF | 44.68 | 44.89 | 44.62 | 44.89 | 752500.0 |
| 2005-09-12 | TLT | ETF | 93.66 | 93.71 | 93.19 | 93.35 | 917300.0 |
| 2005-09-12 | AAA | ETF | 57.09 | 57.38 | 57.09 | 57.12 | 152800.0 |
| 2005-09-12 | ADRE | ETF | 104.99 | 104.99 | 103.8 | 103.93 | 30520.0 |
| 2005-09-12 | AFK | ETF | 26.1 | 26.24 | 25.92 | 26.01 | 9500.0 |
| 2005-09-12 | AGG | ETF | 102.0 | 102.19 | 101.88 | 102.05 | 106300.0 |
| 2005-09-12 | AIQ | ETF | 44.75 | 45.8 | 44.5 | 45.75 | 13540.0 |
| 2005-09-12 | AIS | ETF | 0.83 | 0.92 | 0.83 | 0.89 | 83400.0 |
| 2005-09-12 | ARB | ETF | 42.03 | 42.48 | 41.68 | 42.28 | 87000.0 |
| 2005-09-12 | BAB | ETF | 52.5 | 53.37 | 52.5 | 53.25 | 19000.0 |
| 2005-09-12 | BBC | ETF | 6.95 | 7.0 | 6.92 | 7.0 | 66200.0 |
| 2005-09-12 | BBH | ETF | 66.8633 | 67.0667 | 66.27 | 66.2833 | 1449300.0 |
| 2005-09-12 | BCM | ETF | 60.47 | 60.66 | 60.39 | 60.54 | 318200.0 |
| 2005-09-12 | BIS | ETF | 688.0 | 688.0 | 688.0 | 688.0 | 15.0 |
| 2005-09-12 | BITS | ETF | 12.352 | 12.4 | 12.04 | 12.24 | 4675.0 |
| 2005-09-12 | BKF | ETF | 32.85 | 33.2 | 32.12 | 32.21 | 41800.0 |
| 2005-09-12 | BNE | ETF | 14.44 | 14.56 | 14.24 | 14.24 | 140200.0 |
| 2005-09-12 | BRF | ETF | 15.47 | 15.53 | 15.37 | 15.46 | 17100.0 |
| 2005-09-12 | BTF | ETF | 86.25 | 87.5 | 86.25 | 86.6 | 5460.0 |
| 2005-09-12 | CBON | ETF | 32.89 | 33.2 | 32.89 | 33.0 | 4546.0 |
| 2005-09-12 | CDC | ETF | 3.51 | 3.51 | 2.9 | 3.0 | 107000.0 |
| 2005-09-12 | CDL | ETF | 13.06 | 13.31 | 13.04 | 13.22 | 191800.0 |
| 2005-09-12 | CEF | ETF | 5.26 | 5.38 | 5.25 | 5.35 | 605000.0 |
| 2005-09-12 | CHB | ETF | 13.3 | 13.7 | 13.28 | 13.62 | 974200.0 |
| 2005-09-12 | CHI | ETF | 20.59 | 20.64 | 20.47 | 20.5 | 86600.0 |
| 2005-09-12 | CHIC | ETF | 14.77 | 15.05 | 14.77 | 14.94 | 211673.0 |
| 2005-09-12 | CHIR | ETF | 43.8801 | 44.01 | 43.6701 | 43.74 | 1730540.0 |
| 2005-09-12 | CHY | ETF | 16.72 | 16.78 | 16.7 | 16.71 | 95900.0 |
| 2005-09-12 | CIL | ETF | 25.96 | 25.96 | 25.96 | 25.96 | 100.0 |
| 2005-09-12 | CN | ETF | 34.2 | 34.69 | 34.12 | 34.47 | 139600.0 |
| 2005-09-12 | CNXT | ETF | 1.71 | 1.71 | 1.63 | 1.66 | 3607890.0 |
| 2005-09-12 | CPST | ETF | 5.7 | 5.75 | 5.41 | 5.49 | 11804688.0 |
| 2005-09-12 | CSB | ETF | 31.08 | 31.1 | 30.9 | 30.96 | 6200.0 |
| 2005-09-12 | CSM | ETF | 2.43 | 2.4475 | 2.425 | 2.425 | 26800.0 |
| 2005-09-12 | CSQ | ETF | 14.46 | 14.49 | 14.36 | 14.39 | 312900.0 |
| 2005-09-12 | CTEC | ETF | 53.05 | 56.050000000000004 | 53.05 | 54.74999999999999 | 11876.400000000001 |
| 2005-09-12 | CURE | ETF | 0.27 | 0.2762 | 0.27 | 0.2712 | 130000.0 |
| 2005-09-12 | CYA | ETF | 64.0 | 65.64 | 59.6 | 60.0 | 3640.0 |
| 2005-09-12 | CYB | ETF | 3.85 | 3.85 | 3.72 | 3.75 | 69000.0 |
| 2005-09-12 | DGT | ETF | 65.75 | 65.78 | 65.62 | 65.62 | 600.0 |
| 2005-09-12 | DIG | ETF | 13.7375 | 13.75 | 13.7375 | 13.75 | 1200.0 |
| 2005-09-12 | DIV | ETF | 13.65 | 13.75 | 13.65 | 13.66 | 7700.0 |
| 2005-09-12 | DRIV | ETF | 38.67 | 39.68 | 38.55 | 39.11 | 654281.0 |
| 2005-09-12 | DSI | ETF | 5.805 | 5.82 | 5.78 | 5.78 | 3600.0 |
| 2005-09-12 | DUSA | ETF | 9.85 | 9.99 | 9.77 | 9.95 | 58824.0 |
| 2005-09-12 | DVY | ETF | 63.98 | 64.0 | 63.71 | 63.89 | 343200.0 |
> showing 50 of 277 rows — these rows as CSV