PREVIEW / etf_daily / 2005-09-15
file: by_date/etf_daily/2005/2005-09-15.parquet size: 15 KB rows: 282
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-15 | SPY | ETF | 123.59 | 123.65 | 122.9 | 123.15 | 73156900.0 |
| 2005-09-15 | QQQ | ETF | 39.26 | 39.34 | 39.05 | 39.16 | 80476183.0 |
| 2005-09-15 | IWM | ETF | 66.49 | 66.64 | 66.06 | 66.17 | 23098600.0 |
| 2005-09-15 | DIA | ETF | 105.81 | 105.9 | 105.26 | 105.66 | 7019500.0 |
| 2005-09-15 | GLD | ETF | 45.24 | 45.47 | 45.13 | 45.42 | 2150300.0 |
| 2005-09-15 | TLT | ETF | 93.35 | 93.35 | 92.4 | 92.71 | 2225800.0 |
| 2005-09-15 | AAA | ETF | 56.01 | 56.48 | 56.01 | 56.21 | 5800.0 |
| 2005-09-15 | ADRE | ETF | 103.95 | 104.19 | 103.69 | 104.154 | 17960.0 |
| 2005-09-15 | AFK | ETF | 25.48 | 25.65 | 25.48 | 25.65 | 4200.0 |
| 2005-09-15 | AGG | ETF | 102.05 | 102.21 | 101.75 | 101.94 | 165800.0 |
| 2005-09-15 | AIQ | ETF | 44.75 | 44.75 | 44.0 | 44.5 | 45320.0 |
| 2005-09-15 | AIS | ETF | 0.87 | 0.92 | 0.87 | 0.9 | 93500.0 |
| 2005-09-15 | ARB | ETF | 40.8 | 41.08 | 40.62 | 40.9 | 83900.0 |
| 2005-09-15 | BAB | ETF | 52.0 | 52.35 | 51.7 | 51.8 | 60600.0 |
| 2005-09-15 | BBC | ETF | 7.55 | 7.77 | 7.3 | 7.43 | 49100.0 |
| 2005-09-15 | BBH | ETF | 66.0 | 66.1633 | 65.5 | 65.88 | 900600.0 |
| 2005-09-15 | BCM | ETF | 62.11 | 62.46 | 62.06 | 62.45 | 274400.0 |
| 2005-09-15 | BIS | ETF | 688.0 | 688.0 | 688.0 | 688.0 | 37.5 |
| 2005-09-15 | BITS | ETF | 11.84 | 12.32 | 11.68 | 12.12 | 4721.0 |
| 2005-09-15 | BKF | ETF | 30.75 | 30.92 | 30.6 | 30.77 | 47900.0 |
| 2005-09-15 | BNE | ETF | 13.89 | 14.21 | 13.8 | 14.06 | 80400.0 |
| 2005-09-15 | BRF | ETF | 15.41 | 15.45 | 15.35 | 15.38 | 15900.0 |
| 2005-09-15 | BTF | ETF | 86.35 | 86.85 | 86.35 | 86.64999999999999 | 1780.0 |
| 2005-09-15 | CBON | ETF | 32.5 | 32.69 | 32.5 | 32.67 | 3373.0 |
| 2005-09-15 | CDC | ETF | 2.9 | 3.45 | 2.84 | 3.27 | 29600.0 |
| 2005-09-15 | CDL | ETF | 13.01 | 13.03 | 12.85 | 12.97 | 156800.0 |
| 2005-09-15 | CEF | ETF | 5.33 | 5.42 | 5.33 | 5.41 | 611600.0 |
| 2005-09-15 | CEW | ETF | 25.85 | 25.85 | 25.85 | 25.85 | 400.0 |
| 2005-09-15 | CHB | ETF | 13.31 | 14.03 | 13.3 | 14.03 | 937000.0 |
| 2005-09-15 | CHI | ETF | 20.13 | 20.28 | 20.03 | 20.12 | 79300.0 |
| 2005-09-15 | CHIC | ETF | 14.45 | 14.55 | 14.24 | 14.26 | 162817.0 |
| 2005-09-15 | CHIR | ETF | 44.0799 | 45.0699 | 43.6899 | 44.1201 | 3017962.0 |
| 2005-09-15 | CHY | ETF | 16.45 | 16.51 | 16.38 | 16.41 | 98100.0 |
| 2005-09-15 | CIL | ETF | 25.92 | 25.92 | 25.92 | 25.92 | 1500.0 |
| 2005-09-15 | CIZ | ETF | 22.2 | 22.2 | 22.2 | 22.2 | 300.0 |
| 2005-09-15 | CN | ETF | 35.05 | 35.29 | 34.75 | 34.99 | 37100.0 |
| 2005-09-15 | CNXT | ETF | 1.62 | 1.66 | 1.61 | 1.62 | 2599345.0 |
| 2005-09-15 | CPI | ETF | 24.0 | 24.05 | 24.0 | 24.05 | 500.0 |
| 2005-09-15 | CPST | ETF | 5.57 | 5.59 | 5.35 | 5.45 | 4297116.0 |
| 2005-09-15 | CSB | ETF | 31.03 | 31.09 | 30.8 | 30.97 | 5300.0 |
| 2005-09-15 | CSM | ETF | 2.425 | 2.425 | 2.425 | 2.425 | 14400.0 |
| 2005-09-15 | CSQ | ETF | 14.06 | 14.12 | 14.02 | 14.07 | 350800.0 |
| 2005-09-15 | CTEC | ETF | 55.0 | 55.599999999999994 | 54.349999999999994 | 54.699999999999996 | 5866.0 |
| 2005-09-15 | CURE | ETF | 0.2575 | 0.2575 | 0.25 | 0.25 | 824400.0 |
| 2005-09-15 | CYA | ETF | 58.0 | 64.8 | 58.0 | 61.0 | 3140.0 |
| 2005-09-15 | CYB | ETF | 4.28 | 4.31 | 4.07 | 4.14 | 41800.0 |
| 2005-09-15 | DIG | ETF | 13.925 | 13.95 | 13.925 | 13.95 | 6560.0 |
| 2005-09-15 | DIV | ETF | 13.72 | 13.75 | 13.71 | 13.71 | 5300.0 |
| 2005-09-15 | DRIV | ETF | 38.5 | 38.65 | 37.83 | 37.89 | 665801.0 |
| 2005-09-15 | DSI | ETF | 5.735 | 5.74 | 5.725 | 5.725 | 9200.0 |
> showing 50 of 282 rows — these rows as CSV