PREVIEW / etf_daily / 2006-07-25
file: by_date/etf_daily/2006/2006-07-25.parquet size: 18 KB rows: 356
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-25 | SPY | ETF | 125.98 | 127.3 | 125.72 | 126.66 | 95480700.0 |
| 2006-07-25 | QQQ | ETF | 36.47 | 36.74 | 36.24 | 36.62 | 108869562.0 |
| 2006-07-25 | IWM | ETF | 68.7 | 69.78 | 68.39 | 69.05 | 87433100.0 |
| 2006-07-25 | DIA | ETF | 110.27 | 111.26 | 109.89 | 110.79 | 8120800.0 |
| 2006-07-25 | GLD | ETF | 61.34 | 61.6 | 60.56 | 61.55 | 4736800.0 |
| 2006-07-25 | TLT | ETF | 85.23 | 85.38 | 84.9 | 85.03 | 948200.0 |
| 2006-07-25 | AAA | ETF | 54.75 | 55.05 | 54.6 | 55.05 | 5600.0 |
| 2006-07-25 | ADRE | ETF | 31.02 | 31.31 | 30.76 | 31.25 | 351541.0 |
| 2006-07-25 | AFK | ETF | 25.01 | 25.07 | 25.01 | 25.07 | 5100.0 |
| 2006-07-25 | AGG | ETF | 98.16 | 98.16 | 97.93 | 98.09 | 86500.0 |
| 2006-07-25 | AIQ | ETF | 30.3 | 31.8 | 29.5 | 30.9 | 31880.0 |
| 2006-07-25 | AIS | ETF | 1.07 | 1.12 | 1.06 | 1.11 | 101400.0 |
| 2006-07-25 | AOM | ETF | 6.4 | 6.42 | 6.25 | 6.42 | 25800.0 |
| 2006-07-25 | ARB | ETF | 36.25 | 36.75 | 36.1 | 36.61 | 81700.0 |
| 2006-07-25 | BAB | ETF | 70.66 | 71.3 | 70.31 | 71.0 | 96700.0 |
| 2006-07-25 | BBC | ETF | 12.36 | 12.45 | 12.22 | 12.22 | 82000.0 |
| 2006-07-25 | BBH | ETF | 57.8 | 59.3167 | 57.7667 | 59.21 | 1685400.0 |
| 2006-07-25 | BITS | ETF | 17.8404 | 18.16 | 17.6 | 17.72 | 5739.0 |
| 2006-07-25 | BKF | ETF | 4.3 | 4.5 | 4.1 | 4.19 | 577300.0 |
| 2006-07-25 | BNE | ETF | 13.52 | 13.84 | 13.29 | 13.48 | 209100.0 |
| 2006-07-25 | BRF | ETF | 13.96 | 14.09 | 13.95 | 14.05 | 24900.0 |
| 2006-07-25 | BTF | ETF | 86.5 | 86.64999999999999 | 86.35 | 86.64999999999999 | 1300.0 |
| 2006-07-25 | CBON | ETF | 32.29 | 32.81 | 31.55 | 32.7 | 41610.0 |
| 2006-07-25 | CDL | ETF | 8.87 | 8.9 | 8.58 | 8.78 | 475700.0 |
| 2006-07-25 | CEF | ETF | 8.62 | 8.62 | 8.53 | 8.58 | 382100.0 |
| 2006-07-25 | CEW | ETF | 25.9 | 25.9 | 25.9 | 25.9 | 1000.0 |
| 2006-07-25 | CFO | ETF | 9.85 | 9.85 | 9.85 | 9.85 | 900.0 |
| 2006-07-25 | CGO | ETF | 14.71 | 14.81 | 14.65 | 14.75 | 29300.0 |
| 2006-07-25 | CHB | ETF | 8.5 | 8.5 | 6.6 | 6.62 | 5058100.0 |
| 2006-07-25 | CHI | ETF | 19.6 | 19.83 | 19.6 | 19.81 | 89800.0 |
| 2006-07-25 | CHIC | ETF | 25.46 | 26.03 | 25.42 | 25.96 | 769000.0 |
| 2006-07-25 | CHY | ETF | 16.05 | 16.1294 | 16.03 | 16.09 | 149500.0 |
| 2006-07-25 | CIL | ETF | 25.26 | 25.26 | 25.26 | 25.26 | 2000.0 |
| 2006-07-25 | CIZ | ETF | 22.2 | 22.25 | 22.2 | 22.2 | 800.0 |
| 2006-07-25 | CN | ETF | 36.0 | 36.1 | 35.63 | 36.0 | 59200.0 |
| 2006-07-25 | CNXT | ETF | 2.0 | 2.07 | 1.93 | 2.0 | 11313734.0 |
| 2006-07-25 | COMB | ETF | 9.77 | 9.79 | 9.75 | 9.79 | 9200.0 |
| 2006-07-25 | CPST | ETF | 1.95 | 1.98 | 1.78 | 1.9 | 5031484.0 |
| 2006-07-25 | CSA | ETF | 18.9 | 18.9 | 18.3 | 18.65 | 9500.0 |
| 2006-07-25 | CSB | ETF | 27.1 | 27.1 | 26.91 | 27.05 | 22700.0 |
| 2006-07-25 | CSQ | ETF | 14.08 | 14.09 | 14.0 | 14.09 | 371100.0 |
| 2006-07-25 | CTEC | ETF | 60.3 | 60.35 | 58.65 | 59.4 | 10441.6 |
| 2006-07-25 | CYB | ETF | 5.26 | 5.38 | 5.21 | 5.28 | 197100.0 |
| 2006-07-25 | DBC | ETF | 25.69 | 25.74 | 25.2 | 25.38 | 428100.0 |
| 2006-07-25 | DDM | ETF | 5.9083 | 6.0 | 5.8592 | 5.9708 | 2660400.0 |
| 2006-07-25 | DES | ETF | 17.1567 | 17.2133 | 17.1167 | 17.1733 | 43800.0 |
| 2006-07-25 | DEW | ETF | 51.75 | 51.87 | 51.6 | 51.87 | 2900.0 |
| 2006-07-25 | DGT | ETF | 67.45 | 68.11 | 67.45 | 68.08 | 1900.0 |
| 2006-07-25 | DHS | ETF | 52.1 | 52.41 | 52.03 | 52.41 | 3400.0 |
| 2006-07-25 | DIM | ETF | 52.19 | 52.19 | 51.99 | 52.07 | 1500.0 |
> showing 50 of 356 rows — these rows as CSV