PREVIEW / etf_daily / 2005-04-06
file: by_date/etf_daily/2005/2005-04-06.parquet size: 14 KB rows: 261
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-06 | SPY | ETF | 118.45 | 118.95 | 118.18 | 118.6 | 53268200.0 |
| 2005-04-06 | QQQ | ETF | 36.66 | 36.905 | 36.42 | 36.5 | 82219312.0 |
| 2005-04-06 | IWM | ETF | 61.315 | 61.805 | 61.175 | 61.345 | 19717800.0 |
| 2005-04-06 | DIA | ETF | 104.8 | 105.24 | 104.72 | 105.02 | 4531300.0 |
| 2005-04-06 | GLD | ETF | 42.49 | 42.72 | 42.49 | 42.63 | 1637500.0 |
| 2005-04-06 | TLT | ETF | 89.41 | 89.44 | 89.2 | 89.36 | 402800.0 |
| 2005-04-06 | AAA | ETF | 63.9 | 64.3 | 63.9 | 63.9 | 9000.0 |
| 2005-04-06 | ADRE | ETF | 86.9 | 86.9 | 85.544 | 85.689 | 17128.0 |
| 2005-04-06 | AFK | ETF | 25.95 | 26.1 | 25.89 | 25.95 | 1200.0 |
| 2005-04-06 | AGG | ETF | 101.14 | 101.19 | 100.89 | 101.12 | 279600.0 |
| 2005-04-06 | AIQ | ETF | 49.0 | 51.1 | 48.95 | 50.75 | 33280.0 |
| 2005-04-06 | ARB | ETF | 43.3 | 43.87 | 43.25 | 43.3 | 157600.0 |
| 2005-04-06 | BAB | ETF | 50.19 | 50.58 | 50.1 | 50.18 | 11700.0 |
| 2005-04-06 | BBH | ETF | 47.6 | 48.29 | 47.5 | 47.81 | 2050800.0 |
| 2005-04-06 | BCM | ETF | 60.55 | 60.74 | 60.44 | 60.54 | 15600.0 |
| 2005-04-06 | BIS | ETF | 595.2 | 657.6 | 595.2 | 657.6 | 15.0 |
| 2005-04-06 | BITS | ETF | 12.56 | 12.96 | 11.0 | 11.48 | 46570.0 |
| 2005-04-06 | BKF | ETF | 40.05 | 41.4 | 39.85 | 40.5 | 68200.0 |
| 2005-04-06 | BNE | ETF | 15.0 | 15.15 | 14.8 | 14.9 | 210400.0 |
| 2005-04-06 | BOSS | ETF | 22.71 | 22.71 | 22.53 | 22.53 | 100.0 |
| 2005-04-06 | BRF | ETF | 15.4 | 15.5 | 15.4 | 15.5 | 8600.0 |
| 2005-04-06 | BTF | ETF | 86.8 | 87.2 | 86.8 | 87.2 | 2860.0 |
| 2005-04-06 | CBON | ETF | 25.25 | 25.74 | 25.25 | 25.5 | 8750.0 |
| 2005-04-06 | CDC | ETF | 8.25 | 8.25 | 8.25 | 8.25 | 100.0 |
| 2005-04-06 | CDL | ETF | 14.09 | 14.09 | 13.93 | 14.03 | 255500.0 |
| 2005-04-06 | CEF | ETF | 5.45 | 5.48 | 5.37 | 5.38 | 307800.0 |
| 2005-04-06 | CGW | ETF | 28.91 | 29.0 | 28.91 | 29.0 | 8100.0 |
| 2005-04-06 | CHB | ETF | 9.22 | 9.29 | 9.18 | 9.18 | 1886800.0 |
| 2005-04-06 | CHIC | ETF | 13.01 | 13.09 | 12.84 | 13.09 | 422104.0 |
| 2005-04-06 | CHIR | ETF | 36.7401 | 37.95 | 36.6699 | 37.3599 | 1941688.0 |
| 2005-04-06 | CID | ETF | 10.0 | 10.06 | 10.0 | 10.0 | 11900.0 |
| 2005-04-06 | CIL | ETF | 26.15 | 26.3 | 26.05 | 26.05 | 1900.0 |
| 2005-04-06 | CIZ | ETF | 20.5 | 20.5 | 20.4 | 20.4 | 900.0 |
| 2005-04-06 | CN | ETF | 27.65 | 27.65 | 27.23 | 27.4 | 12700.0 |
| 2005-04-06 | CNXT | ETF | 1.345 | 1.35 | 1.25 | 1.29 | 16489212.0 |
| 2005-04-06 | CPI | ETF | 18.3 | 18.3 | 18.3 | 18.3 | 200.0 |
| 2005-04-06 | CSB | ETF | 33.0 | 33.5 | 33.0 | 33.37 | 8800.0 |
| 2005-04-06 | CTEC | ETF | 50.05 | 51.449999999999996 | 49.5 | 50.849999999999994 | 5595.6 |
| 2005-04-06 | CURE | ETF | 0.415 | 0.4238 | 0.41 | 0.4125 | 1027144.0 |
| 2005-04-06 | CYA | ETF | 169.6 | 170.0 | 169.6 | 170.0 | 120.0 |
| 2005-04-06 | CYB | ETF | 4.0 | 4.19 | 4.0 | 4.05 | 53000.0 |
| 2005-04-06 | CZA | ETF | 10.48 | 10.48 | 10.48 | 10.48 | 1000.0 |
| 2005-04-06 | DGT | ETF | 63.65 | 63.66 | 63.45 | 63.45 | 4700.0 |
| 2005-04-06 | DIV | ETF | 12.79 | 13.03 | 12.718 | 13.03 | 18000.0 |
| 2005-04-06 | DJP | ETF | 27.05 | 27.05 | 27.05 | 27.05 | 100.0 |
| 2005-04-06 | DRIV | ETF | 31.56 | 32.05 | 31.21 | 31.55 | 840220.0 |
| 2005-04-06 | DSI | ETF | 6.005 | 6.005 | 6.005 | 6.005 | 400.0 |
| 2005-04-06 | DUSA | ETF | 9.01 | 9.63 | 8.9 | 9.53 | 154291.0 |
| 2005-04-06 | DVY | ETF | 60.0 | 60.4 | 60.0 | 60.25 | 390900.0 |
| 2005-04-06 | EDEN | ETF | 0.53 | 0.62 | 0.53 | 0.59 | 26960.0 |
> showing 50 of 261 rows — these rows as CSV