PREVIEW / etf_daily / 2006-08-25
file: by_date/etf_daily/2006/2006-08-25.parquet size: 18 KB rows: 362
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-08-25 | SPY | ETF | 129.64 | 130.25 | 129.55 | 129.81 | 41756000.0 |
| 2006-08-25 | QQQ | ETF | 38.17 | 38.64 | 38.06 | 38.32 | 73588175.0 |
| 2006-08-25 | IWM | ETF | 69.38 | 70.09 | 69.23 | 69.6 | 22449400.0 |
| 2006-08-25 | DIA | ETF | 112.73 | 113.15 | 112.52 | 112.84 | 3559800.0 |
| 2006-08-25 | GLD | ETF | 61.88 | 62.0 | 61.58 | 61.77 | 2127000.0 |
| 2006-08-25 | TLT | ETF | 87.24 | 87.59 | 87.2 | 87.44 | 569000.0 |
| 2006-08-25 | AAA | ETF | 57.59 | 57.65 | 57.36 | 57.43 | 4300.0 |
| 2006-08-25 | ADRE | ETF | 31.89 | 32.07 | 31.8 | 31.91 | 196404.0 |
| 2006-08-25 | AFK | ETF | 25.32 | 25.34 | 25.31 | 25.31 | 4700.0 |
| 2006-08-25 | AGG | ETF | 99.32 | 99.44 | 99.22 | 99.32 | 173600.0 |
| 2006-08-25 | AIQ | ETF | 32.5 | 32.95 | 32.0 | 32.5 | 5560.0 |
| 2006-08-25 | AIS | ETF | 1.05 | 1.07 | 1.04 | 1.06 | 153900.0 |
| 2006-08-25 | AOM | ETF | 5.57 | 5.62 | 5.46 | 5.51 | 5100.0 |
| 2006-08-25 | ARB | ETF | 35.82 | 36.04 | 35.67 | 35.77 | 59400.0 |
| 2006-08-25 | BAB | ETF | 74.96 | 75.41 | 74.77 | 74.99 | 51200.0 |
| 2006-08-25 | BBC | ETF | 12.35 | 12.35 | 12.1 | 12.15 | 104600.0 |
| 2006-08-25 | BBH | ETF | 58.7267 | 59.17 | 58.5733 | 58.99 | 659100.0 |
| 2006-08-25 | BITS | ETF | 28.32 | 29.0 | 28.32 | 28.72 | 11207.0 |
| 2006-08-25 | BKF | ETF | 3.91 | 3.96 | 3.91 | 3.92 | 80600.0 |
| 2006-08-25 | BNE | ETF | 14.84 | 15.1 | 14.59 | 14.59 | 95800.0 |
| 2006-08-25 | BRF | ETF | 14.09 | 14.1 | 14.09 | 14.1 | 6500.0 |
| 2006-08-25 | BTF | ETF | 90.89999999999999 | 90.99999999999999 | 90.7 | 90.85000000000001 | 1460.0 |
| 2006-08-25 | CBON | ETF | 33.2 | 33.78 | 33.2 | 33.71 | 8579.0 |
| 2006-08-25 | CDL | ETF | 8.72 | 8.78 | 8.65 | 8.67 | 132900.0 |
| 2006-08-25 | CEF | ETF | 8.92 | 9.03 | 8.91 | 8.95 | 201900.0 |
| 2006-08-25 | CEW | ETF | 26.2 | 26.21 | 26.11 | 26.21 | 2800.0 |
| 2006-08-25 | CFO | ETF | 10.02 | 10.12 | 10.02 | 10.1 | 4300.0 |
| 2006-08-25 | CGO | ETF | 15.16 | 15.4 | 15.08 | 15.3 | 43900.0 |
| 2006-08-25 | CHB | ETF | 5.94 | 6.1 | 5.86 | 6.06 | 799900.0 |
| 2006-08-25 | CHI | ETF | 20.27 | 20.35 | 20.26 | 20.34 | 90400.0 |
| 2006-08-25 | CHIC | ETF | 26.78 | 26.92 | 26.44 | 26.74 | 345793.0 |
| 2006-08-25 | CHY | ETF | 16.35 | 16.47 | 16.33 | 16.46 | 133300.0 |
| 2006-08-25 | CIL | ETF | 25.42 | 25.42 | 25.42 | 25.42 | 2200.0 |
| 2006-08-25 | CN | ETF | 33.71 | 34.1 | 33.69 | 33.88 | 45100.0 |
| 2006-08-25 | CNXT | ETF | 2.11 | 2.15 | 2.07 | 2.13 | 8940395.0 |
| 2006-08-25 | COMB | ETF | 9.94 | 9.95 | 9.9 | 9.92 | 20000.0 |
| 2006-08-25 | CPI | ETF | 29.0 | 29.3 | 29.0 | 29.2 | 1300.0 |
| 2006-08-25 | CPST | ETF | 1.86 | 1.91 | 1.86 | 1.89 | 674588.0 |
| 2006-08-25 | CSA | ETF | 18.65 | 18.94 | 18.45 | 18.94 | 9200.0 |
| 2006-08-25 | CSB | ETF | 28.58 | 28.7 | 28.51 | 28.58 | 25200.0 |
| 2006-08-25 | CSQ | ETF | 14.45 | 14.45 | 14.22 | 14.34 | 365200.0 |
| 2006-08-25 | CTEC | ETF | 53.6 | 54.9 | 53.6 | 53.949999999999996 | 11897.2 |
| 2006-08-25 | CYB | ETF | 5.6 | 5.8 | 5.58 | 5.78 | 28100.0 |
| 2006-08-25 | DBC | ETF | 25.22 | 25.3 | 25.02 | 25.06 | 145700.0 |
| 2006-08-25 | DDM | ETF | 6.1583 | 6.1942 | 6.1517 | 6.175 | 460800.0 |
| 2006-08-25 | DES | ETF | 17.2633 | 17.3067 | 17.19 | 17.2333 | 101100.0 |
| 2006-08-25 | DEW | ETF | 54.75 | 54.75 | 54.44 | 54.54 | 2300.0 |
| 2006-08-25 | DFE | ETF | 54.35 | 54.38 | 54.23 | 54.38 | 1600.0 |
| 2006-08-25 | DFJ | ETF | 51.18 | 51.28 | 50.98 | 50.98 | 1300.0 |
| 2006-08-25 | DGT | ETF | 70.85 | 71.06 | 70.78 | 71.0 | 4900.0 |
> showing 50 of 362 rows — these rows as CSV