PREVIEW / etf_daily / 2005-04-04
file: by_date/etf_daily/2005/2005-04-04.parquet size: 14 KB rows: 259
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-04-04 | SPY | ETF | 117.36 | 117.86 | 116.74 | 117.63 | 71581200.0 |
| 2005-04-04 | QQQ | ETF | 36.25 | 36.6 | 36.03 | 36.46 | 100153714.0 |
| 2005-04-04 | IWM | ETF | 60.72 | 61.19 | 60.2 | 61.045 | 30577600.0 |
| 2005-04-04 | DIA | ETF | 104.08 | 104.82 | 103.46 | 104.22 | 11559300.0 |
| 2005-04-04 | GLD | ETF | 42.43 | 42.43 | 42.23 | 42.4 | 1893100.0 |
| 2005-04-04 | TLT | ETF | 89.28 | 89.66 | 89.17 | 89.28 | 754800.0 |
| 2005-04-04 | AAA | ETF | 63.0 | 63.05 | 62.74 | 62.9 | 2600.0 |
| 2005-04-04 | ADRE | ETF | 85.2 | 85.2 | 84.939 | 85.15 | 16704.0 |
| 2005-04-04 | AFK | ETF | 26.05 | 26.05 | 25.9 | 25.9 | 9400.0 |
| 2005-04-04 | AGG | ETF | 101.09 | 101.24 | 100.8 | 101.06 | 387300.0 |
| 2005-04-04 | AIQ | ETF | 48.65 | 49.25 | 48.4 | 48.95 | 29540.0 |
| 2005-04-04 | ARB | ETF | 42.96 | 43.4 | 42.66 | 43.33 | 153500.0 |
| 2005-04-04 | BAB | ETF | 48.96 | 49.43 | 48.8 | 49.29 | 64000.0 |
| 2005-04-04 | BBH | ETF | 46.4 | 46.6033 | 45.7733 | 46.4467 | 1834500.0 |
| 2005-04-04 | BCM | ETF | 60.57 | 60.57 | 60.04 | 60.04 | 5800.0 |
| 2005-04-04 | BIS | ETF | 563.2 | 584.0 | 563.2 | 572.8 | 37.5 |
| 2005-04-04 | BITS | ETF | 12.96 | 12.96 | 12.04 | 12.6 | 8969.0 |
| 2005-04-04 | BKF | ETF | 39.9 | 40.05 | 39.82 | 39.95 | 6800.0 |
| 2005-04-04 | BNE | ETF | 14.68 | 14.96 | 14.61 | 14.62 | 235900.0 |
| 2005-04-04 | BRF | ETF | 15.7 | 15.7 | 15.51 | 15.51 | 6100.0 |
| 2005-04-04 | BTF | ETF | 86.35 | 86.69999999999999 | 86.14999999999999 | 86.54999999999998 | 4840.0 |
| 2005-04-04 | CBON | ETF | 25.08 | 25.53 | 25.08 | 25.53 | 3351.0 |
| 2005-04-04 | CDC | ETF | 8.3 | 8.42 | 8.21 | 8.22 | 2200.0 |
| 2005-04-04 | CDL | ETF | 13.84 | 13.9 | 13.75 | 13.86 | 261900.0 |
| 2005-04-04 | CEF | ETF | 5.44 | 5.44 | 5.35 | 5.41 | 82900.0 |
| 2005-04-04 | CEW | ETF | 26.65 | 26.75 | 26.62 | 26.75 | 600.0 |
| 2005-04-04 | CHB | ETF | 9.33 | 9.38 | 9.17 | 9.26 | 406800.0 |
| 2005-04-04 | CHIC | ETF | 12.9 | 13.1 | 12.82 | 12.87 | 297712.0 |
| 2005-04-04 | CHIR | ETF | 35.01 | 36.0801 | 35.01 | 35.7201 | 1252132.0 |
| 2005-04-04 | CID | ETF | 9.97 | 10.0 | 9.97 | 10.0 | 7300.0 |
| 2005-04-04 | CIL | ETF | 26.05 | 26.05 | 25.95 | 25.96 | 900.0 |
| 2005-04-04 | CIZ | ETF | 20.3 | 20.3 | 20.3 | 20.3 | 200.0 |
| 2005-04-04 | CN | ETF | 27.7 | 27.7 | 27.55 | 27.61 | 2000.0 |
| 2005-04-04 | CNXT | ETF | 1.44 | 1.46 | 1.37 | 1.38 | 5662562.0 |
| 2005-04-04 | CPI | ETF | 18.4 | 18.4 | 18.4 | 18.4 | 1000.0 |
| 2005-04-04 | CSB | ETF | 32.62 | 32.79 | 32.46 | 32.75 | 5400.0 |
| 2005-04-04 | CTEC | ETF | 50.35 | 50.75 | 48.25 | 50.7 | 5111.8 |
| 2005-04-04 | CURE | ETF | 0.4363 | 0.45 | 0.4075 | 0.4325 | 1789040.0 |
| 2005-04-04 | CYA | ETF | 168.0 | 169.8 | 168.0 | 169.8 | 30.0 |
| 2005-04-04 | CYB | ETF | 3.99 | 4.05 | 3.99 | 4.03 | 56800.0 |
| 2005-04-04 | CZA | ETF | 10.41 | 10.42 | 10.41 | 10.41 | 11000.0 |
| 2005-04-04 | DGT | ETF | 63.0 | 63.08 | 62.49 | 62.88 | 2800.0 |
| 2005-04-04 | DIG | ETF | 12.1875 | 12.275 | 12.1875 | 12.275 | 8960.0 |
| 2005-04-04 | DIV | ETF | 12.85 | 12.85 | 12.64 | 12.68 | 23900.0 |
| 2005-04-04 | DRIV | ETF | 30.87 | 31.28 | 30.14 | 31.04 | 814109.0 |
| 2005-04-04 | DSI | ETF | 5.95 | 5.955 | 5.94 | 5.955 | 7400.0 |
| 2005-04-04 | DUSA | ETF | 8.76 | 8.76 | 8.33 | 8.54 | 132810.0 |
| 2005-04-04 | DVY | ETF | 59.62 | 59.88 | 59.39 | 59.85 | 588200.0 |
| 2005-04-04 | EDEN | ETF | 0.65 | 0.65 | 0.58 | 0.6 | 18600.0 |
| 2005-04-04 | EDV | ETF | 25.97 | 26.2 | 25.97 | 26.05 | 15900.0 |
> showing 50 of 259 rows — these rows as CSV