PREVIEW / etf_daily / 2005-10-07
file: by_date/etf_daily/2005/2005-10-07.parquet size: 15 KB rows: 278
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-10-07 | SPY | ETF | 119.7 | 120.05 | 119.13 | 119.61 | 75661400.0 |
| 2005-10-07 | QQQ | ETF | 38.41 | 38.57 | 38.179 | 38.34 | 91132545.0 |
| 2005-10-07 | IWM | ETF | 64.0 | 64.26 | 63.6 | 64.1 | 24054600.0 |
| 2005-10-07 | DIA | ETF | 103.35 | 103.51 | 102.82 | 102.97 | 6857700.0 |
| 2005-10-07 | GLD | ETF | 46.99 | 47.48 | 46.94 | 47.36 | 1820500.0 |
| 2005-10-07 | TLT | ETF | 91.09 | 91.95 | 90.96 | 91.84 | 1337800.0 |
| 2005-10-07 | AAA | ETF | 57.3 | 57.49 | 56.9 | 57.01 | 2200.0 |
| 2005-10-07 | ADRE | ETF | 99.95 | 104.5075 | 99.95 | 104.43 | 24524.0 |
| 2005-10-07 | AFK | ETF | 25.52 | 25.63 | 25.5 | 25.63 | 2300.0 |
| 2005-10-07 | AGG | ETF | 100.95 | 101.23 | 100.85 | 101.0 | 81100.0 |
| 2005-10-07 | AIQ | ETF | 37.85 | 40.3 | 37.85 | 38.75 | 16700.0 |
| 2005-10-07 | AIS | ETF | 0.89 | 0.99 | 0.89 | 0.95 | 69700.0 |
| 2005-10-07 | ARB | ETF | 38.39 | 39.29 | 38.2 | 38.69 | 164600.0 |
| 2005-10-07 | BAB | ETF | 55.78 | 55.93 | 55.37 | 55.93 | 33100.0 |
| 2005-10-07 | BBC | ETF | 6.85 | 7.25 | 6.7401 | 7.15 | 128400.0 |
| 2005-10-07 | BBH | ETF | 61.2833 | 61.5767 | 60.4267 | 61.36 | 3876000.0 |
| 2005-10-07 | BCM | ETF | 60.95 | 61.43 | 60.9 | 61.14 | 13800.0 |
| 2005-10-07 | BIS | ETF | 617.6 | 617.6 | 614.4 | 614.4 | 12.5 |
| 2005-10-07 | BITS | ETF | 10.2 | 11.202 | 10.2 | 10.88 | 4722.0 |
| 2005-10-07 | BKF | ETF | 28.43 | 28.47 | 27.97 | 28.24 | 44600.0 |
| 2005-10-07 | BNE | ETF | 14.02 | 14.42 | 13.89 | 14.27 | 153100.0 |
| 2005-10-07 | BRF | ETF | 15.5 | 15.5 | 15.36 | 15.36 | 3600.0 |
| 2005-10-07 | BTF | ETF | 85.19999999999999 | 85.95 | 85.19999999999999 | 85.95 | 10680.0 |
| 2005-10-07 | CBON | ETF | 33.02 | 33.02 | 32.68 | 33.0 | 2620.0 |
| 2005-10-07 | CDC | ETF | 3.84 | 4.15 | 3.84 | 4.02 | 8200.0 |
| 2005-10-07 | CDL | ETF | 13.87 | 13.9 | 13.65 | 13.79 | 1152800.0 |
| 2005-10-07 | CEF | ETF | 5.7 | 5.84 | 5.69 | 5.83 | 1508500.0 |
| 2005-10-07 | CHB | ETF | 13.6 | 13.86 | 13.35 | 13.6 | 508000.0 |
| 2005-10-07 | CHI | ETF | 19.96 | 20.0 | 19.9 | 19.98 | 70700.0 |
| 2005-10-07 | CHIC | ETF | 15.98 | 16.51 | 15.63 | 15.89 | 634056.0 |
| 2005-10-07 | CHIR | ETF | 43.2699 | 43.5699 | 43.0101 | 43.32 | 1147459.0 |
| 2005-10-07 | CHY | ETF | 16.17 | 16.1973 | 16.12 | 16.15 | 44300.0 |
| 2005-10-07 | CIL | ETF | 25.95 | 25.95 | 25.9 | 25.9 | 1200.0 |
| 2005-10-07 | CIZ | ETF | 22.1 | 22.1 | 22.0 | 22.0 | 500.0 |
| 2005-10-07 | CN | ETF | 33.08 | 33.13 | 32.86 | 32.99 | 32000.0 |
| 2005-10-07 | CNXT | ETF | 1.88 | 1.88 | 1.82 | 1.83 | 4039061.0 |
| 2005-10-07 | COMB | ETF | 7.85 | 7.85 | 7.85 | 7.85 | 100.0 |
| 2005-10-07 | CPST | ETF | 3.31 | 3.4 | 3.1 | 3.27 | 3911184.0 |
| 2005-10-07 | CSB | ETF | 29.68 | 29.8 | 29.65 | 29.66 | 2600.0 |
| 2005-10-07 | CSQ | ETF | 13.61 | 13.89 | 13.6 | 13.85 | 195700.0 |
| 2005-10-07 | CTEC | ETF | 48.8 | 50.0 | 48.349999999999994 | 48.699999999999996 | 4900.400000000001 |
| 2005-10-07 | CURE | ETF | 0.1037 | 0.1037 | 0.0938 | 0.0975 | 2045432.0 |
| 2005-10-07 | CYA | ETF | 73.0 | 73.0 | 70.2 | 71.0 | 270.0 |
| 2005-10-07 | CYB | ETF | 3.32 | 3.36 | 3.3 | 3.33 | 62800.0 |
| 2005-10-07 | DGT | ETF | 63.82 | 63.83 | 63.82 | 63.83 | 200.0 |
| 2005-10-07 | DIG | ETF | 14.8125 | 14.9375 | 14.8125 | 14.9375 | 1520.0 |
| 2005-10-07 | DIV | ETF | 12.81 | 12.86 | 12.67 | 12.77 | 23600.0 |
| 2005-10-07 | DRIV | ETF | 31.85 | 33.32 | 31.85 | 33.21 | 1335952.0 |
| 2005-10-07 | DSI | ETF | 5.665 | 5.665 | 5.64 | 5.64 | 2400.0 |
| 2005-10-07 | DUSA | ETF | 10.3 | 10.7 | 10.25 | 10.54 | 82280.0 |
> showing 50 of 278 rows — these rows as CSV