PREVIEW / etf_daily / 2006-03-22
file: by_date/etf_daily/2006/2006-03-22.parquet size: 16 KB rows: 313
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-03-22 | SPY | ETF | 129.51 | 130.51 | 129.45 | 130.38 | 51605700.0 |
| 2006-03-22 | QQQ | ETF | 40.88 | 41.28 | 40.86 | 41.21 | 112323505.0 |
| 2006-03-22 | IWM | ETF | 72.99 | 74.22 | 72.89 | 74.13 | 36219500.0 |
| 2006-03-22 | DIA | ETF | 112.31 | 113.19 | 112.27 | 113.06 | 7281700.0 |
| 2006-03-22 | GLD | ETF | 54.75 | 54.93 | 54.6 | 54.75 | 1077300.0 |
| 2006-03-22 | TLT | ETF | 88.75 | 88.98 | 88.63 | 88.72 | 205500.0 |
| 2006-03-22 | AAA | ETF | 60.27 | 60.95 | 59.821 | 60.9 | 2800.0 |
| 2006-03-22 | ADRE | ETF | 129.21 | 129.21 | 126.46 | 127.74 | 20420.0 |
| 2006-03-22 | AFK | ETF | 25.12 | 25.179 | 25.12 | 25.17 | 2200.0 |
| 2006-03-22 | AGG | ETF | 99.62 | 99.72 | 99.45 | 99.48 | 117200.0 |
| 2006-03-22 | AIQ | ETF | 32.75 | 32.9 | 31.85 | 32.2 | 27760.0 |
| 2006-03-22 | AIS | ETF | 1.7 | 1.79 | 1.64 | 1.77 | 412400.0 |
| 2006-03-22 | AOM | ETF | 6.53 | 6.5384 | 5.9516 | 6.37 | 132900.0 |
| 2006-03-22 | ARB | ETF | 34.0 | 34.14 | 33.73 | 33.85 | 484700.0 |
| 2006-03-22 | BAB | ETF | 62.66 | 63.36 | 62.66 | 63.28 | 73900.0 |
| 2006-03-22 | BBC | ETF | 18.0 | 18.05 | 17.6 | 17.94 | 197200.0 |
| 2006-03-22 | BBH | ETF | 65.0067 | 65.5367 | 64.5 | 65.3167 | 1044300.0 |
| 2006-03-22 | BCM | ETF | 72.25 | 72.96 | 72.16 | 72.96 | 20700.0 |
| 2006-03-22 | BITS | ETF | 31.036 | 31.6 | 29.64 | 30.96 | 18924.0 |
| 2006-03-22 | BKF | ETF | 12.85 | 12.99 | 12.7 | 12.93 | 25800.0 |
| 2006-03-22 | BNE | ETF | 15.35 | 15.6 | 15.08 | 15.44 | 197800.0 |
| 2006-03-22 | BOSS | ETF | 35.66 | 35.66 | 35.36 | 35.36 | 300.0 |
| 2006-03-22 | BRF | ETF | 14.26 | 14.36 | 14.26 | 14.36 | 6600.0 |
| 2006-03-22 | BTF | ETF | 89.0 | 89.0 | 88.55 | 88.94999999999999 | 7760.0 |
| 2006-03-22 | CBON | ETF | 31.64 | 31.86 | 31.0 | 31.3 | 8772.0 |
| 2006-03-22 | CDL | ETF | 11.34 | 11.36 | 11.18 | 11.31 | 270500.0 |
| 2006-03-22 | CEF | ETF | 7.77 | 7.86 | 7.7 | 7.82 | 303600.0 |
| 2006-03-22 | CEW | ETF | 25.62 | 25.62 | 25.62 | 25.62 | 200.0 |
| 2006-03-22 | CFO | ETF | 9.7 | 9.7 | 9.7 | 9.7 | 400.0 |
| 2006-03-22 | CGO | ETF | 14.38 | 14.49 | 14.37 | 14.48 | 27200.0 |
| 2006-03-22 | CHB | ETF | 15.08 | 15.44 | 14.91 | 15.39 | 349300.0 |
| 2006-03-22 | CHI | ETF | 20.85 | 20.99 | 20.7 | 20.88 | 103800.0 |
| 2006-03-22 | CHIC | ETF | 18.0 | 18.98 | 17.95 | 18.84 | 593828.0 |
| 2006-03-22 | CHIR | ETF | 45.63 | 45.8301 | 45.6099 | 45.6999 | 756884.0 |
| 2006-03-22 | CHY | ETF | 16.54 | 16.62 | 16.45 | 16.6 | 98300.0 |
| 2006-03-22 | CIL | ETF | 25.6 | 25.6 | 25.6 | 25.6 | 200.0 |
| 2006-03-22 | CIZ | ETF | 23.5 | 23.5 | 23.5 | 23.5 | 500.0 |
| 2006-03-22 | CN | ETF | 35.15 | 35.56 | 34.9 | 35.16 | 59000.0 |
| 2006-03-22 | CNXT | ETF | 3.21 | 3.28 | 3.19 | 3.25 | 8248604.0 |
| 2006-03-22 | COMB | ETF | 8.41 | 8.41 | 8.31 | 8.31 | 200.0 |
| 2006-03-22 | CPST | ETF | 3.32 | 3.37 | 3.21 | 3.24 | 1629530.0 |
| 2006-03-22 | CSA | ETF | 21.5 | 21.5 | 21.25 | 21.4 | 80800.0 |
| 2006-03-22 | CSB | ETF | 30.65 | 30.74 | 30.46 | 30.53 | 4800.0 |
| 2006-03-22 | CSM | ETF | 2.485 | 2.485 | 2.485 | 2.485 | 4000.0 |
| 2006-03-22 | CSQ | ETF | 14.21 | 14.3 | 14.15 | 14.28 | 349500.0 |
| 2006-03-22 | CTEC | ETF | 59.0 | 60.0 | 58.75 | 60.0 | 6714.0 |
| 2006-03-22 | CYB | ETF | 6.05 | 6.2 | 6.05 | 6.16 | 49600.0 |
| 2006-03-22 | DBC | ETF | 23.0 | 23.05 | 22.76 | 22.88 | 283800.0 |
| 2006-03-22 | DGT | ETF | 67.2 | 67.77 | 67.2 | 67.76 | 4400.0 |
| 2006-03-22 | DIV | ETF | 12.51 | 12.62 | 12.46 | 12.6 | 23300.0 |
> showing 50 of 313 rows — these rows as CSV