PREVIEW / etf_daily / 2005-07-12
file: by_date/etf_daily/2005/2005-07-12.parquet size: 15 KB rows: 275
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-07-12 | SPY | ETF | 121.99 | 122.63 | 121.64 | 122.26 | 51871100.0 |
| 2005-07-12 | QQQ | ETF | 38.12 | 38.46 | 38.01 | 38.3 | 86105577.0 |
| 2005-07-12 | IWM | ETF | 66.68 | 67.14 | 66.33 | 66.57 | 24254400.0 |
| 2005-07-12 | DIA | ETF | 105.19 | 105.49 | 104.85 | 105.1 | 6652800.0 |
| 2005-07-12 | GLD | ETF | 42.61 | 42.64 | 42.4 | 42.64 | 1274200.0 |
| 2005-07-12 | TLT | ETF | 94.35 | 94.53 | 94.06 | 94.1 | 743700.0 |
| 2005-07-12 | AAA | ETF | 51.21 | 51.23 | 50.82 | 51.06 | 6900.0 |
| 2005-07-12 | ADRE | ETF | 94.3 | 94.3 | 93.5499 | 94.06 | 3824.0 |
| 2005-07-12 | AFK | ETF | 25.99 | 25.99 | 25.77 | 25.8 | 32300.0 |
| 2005-07-12 | AGG | ETF | 102.48 | 102.48 | 102.28 | 102.38 | 127900.0 |
| 2005-07-12 | AIQ | ETF | 55.95 | 58.3 | 55.6 | 57.5 | 30120.0 |
| 2005-07-12 | AIS | ETF | 1.17 | 1.22 | 1.15 | 1.22 | 186500.0 |
| 2005-07-12 | ARB | ETF | 42.5 | 43.69 | 42.49 | 43.11 | 159100.0 |
| 2005-07-12 | BAB | ETF | 47.73 | 47.97 | 47.46 | 47.84 | 46200.0 |
| 2005-07-12 | BBH | ETF | 59.2833 | 59.9433 | 59.0967 | 59.8333 | 2202000.0 |
| 2005-07-12 | BCM | ETF | 63.26 | 63.4 | 63.03 | 63.04 | 23300.0 |
| 2005-07-12 | BIS | ETF | 640.0 | 640.0 | 640.0 | 640.0 | 1.25 |
| 2005-07-12 | BITS | ETF | 13.32 | 14.12 | 13.24 | 13.6 | 4568.0 |
| 2005-07-12 | BKF | ETF | 36.98 | 37.6 | 36.7 | 37.3 | 68100.0 |
| 2005-07-12 | BNE | ETF | 14.35 | 14.43 | 14.11 | 14.11 | 206200.0 |
| 2005-07-12 | BRF | ETF | 15.51 | 15.53 | 15.5 | 15.5 | 6900.0 |
| 2005-07-12 | BTF | ETF | 87.39999999999999 | 87.39999999999999 | 86.89999999999999 | 87.24999999999999 | 1020.0 |
| 2005-07-12 | CBON | ETF | 31.35 | 31.48 | 30.8 | 31.46 | 17599.0 |
| 2005-07-12 | CDC | ETF | 6.85 | 6.95 | 6.76 | 6.95 | 2700.0 |
| 2005-07-12 | CDL | ETF | 11.75 | 11.78 | 11.4 | 11.68 | 602900.0 |
| 2005-07-12 | CEF | ETF | 5.3 | 5.3 | 5.26 | 5.28 | 133600.0 |
| 2005-07-12 | CEW | ETF | 26.74 | 26.75 | 26.52 | 26.52 | 18000.0 |
| 2005-07-12 | CHB | ETF | 10.5 | 10.66 | 10.45 | 10.55 | 248400.0 |
| 2005-07-12 | CHI | ETF | 20.0 | 20.11 | 20.0 | 20.03 | 83400.0 |
| 2005-07-12 | CHIC | ETF | 13.29 | 14.85 | 13.28 | 14.21 | 1132192.0 |
| 2005-07-12 | CHIR | ETF | 35.9001 | 36.9699 | 35.8701 | 36.8199 | 1155738.0 |
| 2005-07-12 | CHY | ETF | 16.8 | 16.85 | 16.72 | 16.83 | 128900.0 |
| 2005-07-12 | CIL | ETF | 25.65 | 25.72 | 25.65 | 25.72 | 1000.0 |
| 2005-07-12 | CIZ | ETF | 22.85 | 22.85 | 22.85 | 22.85 | 200.0 |
| 2005-07-12 | CN | ETF | 29.95 | 29.95 | 29.69 | 29.71 | 6600.0 |
| 2005-07-12 | CNXT | ETF | 1.83 | 1.83 | 1.77 | 1.79 | 4714105.0 |
| 2005-07-12 | CPI | ETF | 24.5 | 24.5 | 24.5 | 24.5 | 200.0 |
| 2005-07-12 | CPST | ETF | 1.52 | 1.64 | 1.5 | 1.57 | 594613.0 |
| 2005-07-12 | CSB | ETF | 29.45 | 29.75 | 29.45 | 29.71 | 17900.0 |
| 2005-07-12 | CSM | ETF | 2.4075 | 2.4075 | 2.4075 | 2.4075 | 1200.0 |
| 2005-07-12 | CSQ | ETF | 14.28 | 14.34 | 14.19 | 14.25 | 525000.0 |
| 2005-07-12 | CTEC | ETF | 53.49999999999999 | 55.849999999999994 | 52.699999999999996 | 55.05 | 7556.8 |
| 2005-07-12 | CURE | ETF | 0.3187 | 0.3425 | 0.305 | 0.3237 | 1313000.0 |
| 2005-07-12 | CYA | ETF | 139.8 | 139.8 | 131.0 | 133.2 | 230.0 |
| 2005-07-12 | CYB | ETF | 3.03 | 3.05 | 2.98 | 3.018 | 17300.0 |
| 2005-07-12 | DGT | ETF | 64.0 | 64.5 | 64.0 | 64.5 | 1500.0 |
| 2005-07-12 | DIG | ETF | 12.6 | 12.6 | 12.6 | 12.6 | 800.0 |
| 2005-07-12 | DIV | ETF | 13.82 | 13.91 | 13.7405 | 13.77 | 15900.0 |
| 2005-07-12 | DRIV | ETF | 35.55 | 36.58 | 35.1 | 35.98 | 801701.0 |
| 2005-07-12 | DUSA | ETF | 9.35 | 9.901 | 9.15 | 9.69 | 98570.0 |
> showing 50 of 275 rows — these rows as CSV