PREVIEW / etf_daily / 2005-08-15
file: by_date/etf_daily/2005/2005-08-15.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-08-15 | SPY | ETF | 123.22 | 123.87 | 122.83 | 123.82 | 36208500.0 |
| 2005-08-15 | QQQ | ETF | 39.14 | 39.63 | 39.077 | 39.446 | 63066320.0 |
| 2005-08-15 | IWM | ETF | 65.65 | 66.49 | 65.25 | 66.22 | 23665800.0 |
| 2005-08-15 | DIA | ETF | 106.06 | 106.7 | 105.73 | 106.62 | 4665800.0 |
| 2005-08-15 | GLD | ETF | 44.19 | 44.27 | 43.98 | 44.13 | 1524500.0 |
| 2005-08-15 | TLT | ETF | 93.26 | 93.3 | 93.05 | 93.07 | 954300.0 |
| 2005-08-15 | AAA | ETF | 56.207 | 56.46 | 56.207 | 56.46 | 4900.0 |
| 2005-08-15 | ADRE | ETF | 101.82 | 101.82 | 100.2 | 101.44 | 6328.0 |
| 2005-08-15 | AFK | ETF | 25.58 | 25.73 | 25.58 | 25.67 | 8800.0 |
| 2005-08-15 | AGG | ETF | 101.85 | 101.85 | 101.67 | 101.74 | 145300.0 |
| 2005-08-15 | AIQ | ETF | 45.5 | 47.25 | 45.5 | 47.15 | 28260.0 |
| 2005-08-15 | AIS | ETF | 0.93 | 0.95 | 0.91 | 0.95 | 176500.0 |
| 2005-08-15 | ARB | ETF | 41.9 | 43.06 | 41.85 | 42.5 | 319700.0 |
| 2005-08-15 | BAB | ETF | 52.73 | 53.18 | 52.68 | 53.11 | 22200.0 |
| 2005-08-15 | BBH | ETF | 63.6533 | 64.2633 | 63.47 | 63.9767 | 739200.0 |
| 2005-08-15 | BCM | ETF | 59.6 | 59.82 | 59.19 | 59.3 | 13700.0 |
| 2005-08-15 | BITS | ETF | 13.4 | 13.44 | 12.64 | 12.88 | 6254.0 |
| 2005-08-15 | BKF | ETF | 30.98 | 32.25 | 30.9 | 32.13 | 26100.0 |
| 2005-08-15 | BNE | ETF | 13.58 | 13.82 | 13.54 | 13.7 | 156300.0 |
| 2005-08-15 | BRF | ETF | 15.4 | 15.49 | 15.37 | 15.4 | 18200.0 |
| 2005-08-15 | BTF | ETF | 85.35 | 85.89999999999999 | 85.35 | 85.89999999999999 | 2140.0 |
| 2005-08-15 | CBON | ETF | 33.17 | 33.17 | 32.42 | 32.85 | 4898.0 |
| 2005-08-15 | CDC | ETF | 3.56 | 3.6 | 3.4 | 3.5 | 20600.0 |
| 2005-08-15 | CDL | ETF | 13.5 | 13.76 | 13.44 | 13.75 | 319300.0 |
| 2005-08-15 | CEF | ETF | 5.34 | 5.37 | 5.3 | 5.33 | 216000.0 |
| 2005-08-15 | CEW | ETF | 26.8 | 26.89 | 26.75 | 26.75 | 2700.0 |
| 2005-08-15 | CHB | ETF | 11.91 | 12.21 | 11.76 | 12.08 | 241800.0 |
| 2005-08-15 | CHI | ETF | 20.25 | 20.37 | 20.11 | 20.19 | 125300.0 |
| 2005-08-15 | CHIC | ETF | 14.49 | 14.8 | 14.25 | 14.57 | 172485.0 |
| 2005-08-15 | CHIR | ETF | 36.5301 | 36.9999 | 36.2499 | 36.75 | 528931.0 |
| 2005-08-15 | CHY | ETF | 16.37 | 16.4 | 16.27 | 16.3 | 97400.0 |
| 2005-08-15 | CIL | ETF | 25.82 | 25.82 | 25.82 | 25.82 | 1000.0 |
| 2005-08-15 | CIZ | ETF | 23.6 | 23.6 | 23.6 | 23.6 | 1000.0 |
| 2005-08-15 | CN | ETF | 36.0 | 36.0 | 35.83 | 35.99 | 36900.0 |
| 2005-08-15 | CNXT | ETF | 1.72 | 1.74 | 1.69 | 1.7 | 3367123.0 |
| 2005-08-15 | CPST | ETF | 3.23 | 3.27 | 3.0 | 3.08 | 1740736.0 |
| 2005-08-15 | CSB | ETF | 31.45 | 31.45 | 31.19 | 31.28 | 5300.0 |
| 2005-08-15 | CSM | ETF | 2.4175 | 2.42 | 2.4175 | 2.42 | 10800.0 |
| 2005-08-15 | CSQ | ETF | 14.2 | 14.25 | 14.17 | 14.19 | 274400.0 |
| 2005-08-15 | CTEC | ETF | 53.4 | 54.65 | 53.3 | 53.550000000000004 | 6317.0 |
| 2005-08-15 | CURE | ETF | 0.2737 | 0.275 | 0.2625 | 0.2687 | 1640688.0 |
| 2005-08-15 | CYA | ETF | 78.0 | 78.0 | 62.2 | 69.0 | 1890.0 |
| 2005-08-15 | CYB | ETF | 3.5 | 3.546 | 3.45 | 3.546 | 32400.0 |
| 2005-08-15 | DGT | ETF | 65.05 | 65.3 | 65.05 | 65.27 | 1500.0 |
| 2005-08-15 | DIG | ETF | 13.5 | 13.5 | 13.4125 | 13.4125 | 9120.0 |
| 2005-08-15 | DIV | ETF | 13.55 | 13.7 | 13.5 | 13.52 | 10000.0 |
| 2005-08-15 | DRIV | ETF | 38.71 | 39.85 | 38.55 | 39.4 | 1020763.0 |
| 2005-08-15 | DUSA | ETF | 10.79 | 11.05 | 10.49 | 11.05 | 58482.0 |
| 2005-08-15 | DVY | ETF | 63.4 | 63.54 | 63.01 | 63.48 | 298100.0 |
| 2005-08-15 | EDEN | ETF | 0.78 | 0.87 | 0.78 | 0.87 | 37689.0 |
> showing 50 of 275 rows — these rows as CSV