PREVIEW / etf_daily / 2005-05-16
file: by_date/etf_daily/2005/2005-05-16.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-05-16 | SPY | ETF | 115.7 | 116.84 | 115.66 | 116.8 | 49207000.0 |
| 2005-05-16 | QQQ | ETF | 36.24 | 36.538 | 36.13 | 36.484 | 79136957.0 |
| 2005-05-16 | IWM | ETF | 58.015 | 59.0 | 57.95 | 58.985 | 31343600.0 |
| 2005-05-16 | DIA | ETF | 101.62 | 102.71 | 101.59 | 102.64 | 5840400.0 |
| 2005-05-16 | GLD | ETF | 41.77 | 41.9 | 41.77 | 41.88 | 874500.0 |
| 2005-05-16 | TLT | ETF | 93.04 | 93.07 | 92.68 | 92.69 | 824800.0 |
| 2005-05-16 | AAA | ETF | 58.9 | 59.25 | 58.9 | 59.24 | 3800.0 |
| 2005-05-16 | ADRE | ETF | 81.05 | 83.362 | 81.05 | 83.362 | 9964.0 |
| 2005-05-16 | AFK | ETF | 26.4 | 26.4 | 26.35 | 26.37 | 2800.0 |
| 2005-05-16 | AGG | ETF | 102.26 | 102.31 | 102.08 | 102.11 | 82800.0 |
| 2005-05-16 | AIQ | ETF | 48.55 | 51.0 | 48.55 | 49.85 | 16860.0 |
| 2005-05-16 | ARB | ETF | 39.32 | 40.1 | 39.32 | 39.82 | 259600.0 |
| 2005-05-16 | BAB | ETF | 47.87 | 48.14 | 47.77 | 48.1 | 11100.0 |
| 2005-05-16 | BBH | ETF | 53.4967 | 54.34 | 53.0133 | 54.2833 | 2332800.0 |
| 2005-05-16 | BCM | ETF | 58.85 | 59.07 | 58.8 | 58.84 | 8300.0 |
| 2005-05-16 | BITS | ETF | 10.16 | 11.0 | 10.08 | 10.48 | 4115.0 |
| 2005-05-16 | BKF | ETF | 31.1 | 31.39 | 30.9 | 31.16 | 40100.0 |
| 2005-05-16 | BNE | ETF | 11.94 | 12.38 | 11.94 | 11.95 | 406000.0 |
| 2005-05-16 | BRF | ETF | 15.32 | 15.35 | 15.25 | 15.31 | 14900.0 |
| 2005-05-16 | BTF | ETF | 83.49999999999999 | 83.69999999999999 | 83.1 | 83.39999999999999 | 2120.0 |
| 2005-05-16 | CBON | ETF | 26.75 | 27.06 | 26.36 | 27.0 | 10900.0 |
| 2005-05-16 | CDC | ETF | 6.43 | 6.61 | 6.31 | 6.61 | 1300.0 |
| 2005-05-16 | CDL | ETF | 11.61 | 11.63 | 11.47 | 11.55 | 192000.0 |
| 2005-05-16 | CEF | ETF | 5.22 | 5.22 | 5.12 | 5.15 | 564400.0 |
| 2005-05-16 | CEW | ETF | 26.38 | 26.5 | 26.37 | 26.5 | 3100.0 |
| 2005-05-16 | CGW | ETF | 28.48 | 28.48 | 28.0 | 28.0 | 1000.0 |
| 2005-05-16 | CHB | ETF | 9.55 | 9.74 | 9.51 | 9.67 | 352800.0 |
| 2005-05-16 | CHIC | ETF | 10.67 | 10.72 | 10.44 | 10.64 | 155234.0 |
| 2005-05-16 | CHIR | ETF | 35.4 | 35.8401 | 35.1699 | 35.8401 | 756934.0 |
| 2005-05-16 | CIL | ETF | 26.22 | 26.46 | 26.22 | 26.3 | 2500.0 |
| 2005-05-16 | CN | ETF | 27.23 | 27.4 | 27.23 | 27.29 | 5800.0 |
| 2005-05-16 | CNXT | ETF | 1.17 | 1.1701 | 1.15 | 1.17 | 1728881.0 |
| 2005-05-16 | CPI | ETF | 22.45 | 22.6 | 22.45 | 22.52 | 6800.0 |
| 2005-05-16 | CSB | ETF | 30.0 | 30.0 | 29.88 | 29.95 | 6400.0 |
| 2005-05-16 | CSM | ETF | 2.4 | 2.4025 | 2.4 | 2.4025 | 8000.0 |
| 2005-05-16 | CTEC | ETF | 50.99999999999999 | 52.24999999999999 | 50.99999999999999 | 51.199999999999996 | 9597.0 |
| 2005-05-16 | CURE | ETF | 0.2475 | 0.2737 | 0.2412 | 0.2637 | 1556000.0 |
| 2005-05-16 | CYA | ETF | 131.8 | 135.0 | 131.8 | 134.2 | 290.0 |
| 2005-05-16 | CYB | ETF | 3.31 | 3.35 | 3.0 | 3.21 | 10100.0 |
| 2005-05-16 | CZA | ETF | 10.28 | 10.28 | 10.27 | 10.27 | 4000.0 |
| 2005-05-16 | DGT | ETF | 62.75 | 63.01 | 62.52 | 62.98 | 3200.0 |
| 2005-05-16 | DIG | ETF | 10.6375 | 10.6375 | 10.5625 | 10.5625 | 3600.0 |
| 2005-05-16 | DIV | ETF | 13.21 | 13.29 | 13.21 | 13.22 | 2300.0 |
| 2005-05-16 | DRIV | ETF | 22.78 | 23.25 | 22.67 | 23.08 | 848607.0 |
| 2005-05-16 | DSI | ETF | 5.825 | 5.91 | 5.825 | 5.91 | 15200.0 |
| 2005-05-16 | DUSA | ETF | 10.1 | 10.57 | 10.1 | 10.54 | 157791.0 |
| 2005-05-16 | DVY | ETF | 59.4 | 60.09 | 59.31 | 60.09 | 328300.0 |
| 2005-05-16 | EDEN | ETF | 0.65 | 0.7 | 0.65 | 0.684 | 15500.0 |
| 2005-05-16 | EDV | ETF | 26.3 | 26.41 | 26.29 | 26.39 | 9600.0 |
| 2005-05-16 | EEM | ETF | 22.2778 | 22.4222 | 22.15 | 22.4222 | 6050700.0 |
> showing 50 of 259 rows — these rows as CSV