PREVIEW / etf_daily / 2006-03-07
file: by_date/etf_daily/2006/2006-03-07.parquet size: 16 KB rows: 304
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-07 | SPY | ETF | 127.86 | 128.06 | 127.4 | 127.97 | 61780800.0 |
| 2006-03-07 | QQQ | ETF | 41.03 | 41.07 | 40.65 | 40.85 | 96498119.0 |
| 2006-03-07 | IWM | ETF | 72.35 | 72.4 | 71.44 | 71.6 | 38899700.0 |
| 2006-03-07 | DIA | ETF | 109.36 | 109.91 | 109.3 | 109.85 | 6271500.0 |
| 2006-03-07 | GLD | ETF | 55.33 | 55.33 | 54.55 | 54.95 | 4385400.0 |
| 2006-03-07 | TLT | ETF | 88.4 | 88.75 | 88.31 | 88.61 | 1692900.0 |
| 2006-03-07 | AAA | ETF | 53.5 | 53.66 | 53.4 | 53.5 | 4100.0 |
| 2006-03-07 | ADRE | ETF | 126.6 | 126.6 | 122.39 | 123.43 | 76400.0 |
| 2006-03-07 | AFK | ETF | 25.52 | 25.52 | 25.45 | 25.45 | 3500.0 |
| 2006-03-07 | AGG | ETF | 99.25 | 99.37 | 99.1 | 99.2 | 211200.0 |
| 2006-03-07 | AIQ | ETF | 29.0 | 29.65 | 29.0 | 29.25 | 41360.0 |
| 2006-03-07 | AIS | ETF | 1.34 | 1.36 | 1.32 | 1.3599 | 318700.0 |
| 2006-03-07 | AOM | ETF | 6.8 | 6.8 | 6.51 | 6.65 | 45700.0 |
| 2006-03-07 | ARB | ETF | 34.51 | 34.85 | 34.4 | 34.54 | 399000.0 |
| 2006-03-07 | BAB | ETF | 56.7 | 57.09 | 56.36 | 56.53 | 19200.0 |
| 2006-03-07 | BBC | ETF | 15.21 | 15.21 | 13.88 | 14.15 | 413500.0 |
| 2006-03-07 | BBH | ETF | 63.7 | 64.2833 | 63.5533 | 63.74 | 1011000.0 |
| 2006-03-07 | BCM | ETF | 72.75 | 73.25 | 72.54 | 72.92 | 19600.0 |
| 2006-03-07 | BITS | ETF | 32.2 | 32.36 | 29.0 | 30.32 | 44226.0 |
| 2006-03-07 | BKF | ETF | 12.9 | 13.04 | 12.8401 | 12.95 | 37300.0 |
| 2006-03-07 | BNE | ETF | 14.94 | 15.01 | 14.73 | 14.78 | 179600.0 |
| 2006-03-07 | BOSS | ETF | 34.66 | 34.66 | 34.46 | 34.46 | 100.0 |
| 2006-03-07 | BRF | ETF | 14.53 | 14.69 | 14.49 | 14.69 | 29300.0 |
| 2006-03-07 | BTF | ETF | 88.24999999999999 | 88.24999999999999 | 87.75 | 88.0 | 1920.0 |
| 2006-03-07 | CBON | ETF | 30.15 | 30.66 | 30.15 | 30.62 | 12070.0 |
| 2006-03-07 | CDL | ETF | 11.65 | 11.73 | 11.6 | 11.63 | 488500.0 |
| 2006-03-07 | CEF | ETF | 7.79 | 7.8 | 7.65 | 7.73 | 441700.0 |
| 2006-03-07 | CEW | ETF | 25.6 | 25.6 | 25.55 | 25.55 | 400.0 |
| 2006-03-07 | CFO | ETF | 9.7 | 9.74 | 9.65 | 9.74 | 16500.0 |
| 2006-03-07 | CGO | ETF | 14.15 | 14.3 | 14.08 | 14.3 | 36900.0 |
| 2006-03-07 | CHB | ETF | 15.14 | 15.49 | 14.75 | 15.03 | 794500.0 |
| 2006-03-07 | CHI | ETF | 20.83 | 20.9 | 20.7 | 20.87 | 84400.0 |
| 2006-03-07 | CHIC | ETF | 19.25 | 19.27 | 18.89 | 18.98 | 310820.0 |
| 2006-03-07 | CHIR | ETF | 45.3 | 45.48 | 45.15 | 45.42 | 457039.0 |
| 2006-03-07 | CHY | ETF | 16.42 | 16.5 | 16.29 | 16.45 | 72100.0 |
| 2006-03-07 | CIZ | ETF | 23.7501 | 23.8 | 23.45 | 23.45 | 1900.0 |
| 2006-03-07 | CN | ETF | 36.9 | 36.9 | 36.35 | 36.46 | 66600.0 |
| 2006-03-07 | CNXT | ETF | 3.14 | 3.15 | 3.1 | 3.15 | 12300847.0 |
| 2006-03-07 | COMB | ETF | 8.3 | 8.5 | 8.3 | 8.45 | 52178.0 |
| 2006-03-07 | CPST | ETF | 3.24 | 3.25 | 3.17 | 3.22 | 1217613.0 |
| 2006-03-07 | CSA | ETF | 19.85 | 19.95 | 19.5 | 19.51 | 5400.0 |
| 2006-03-07 | CSB | ETF | 30.5 | 30.51 | 30.2 | 30.47 | 5700.0 |
| 2006-03-07 | CSQ | ETF | 14.08 | 14.13 | 14.0 | 14.13 | 286300.0 |
| 2006-03-07 | CTEC | ETF | 58.49999999999999 | 60.0 | 58.449999999999996 | 59.45 | 21439.800000000003 |
| 2006-03-07 | CYB | ETF | 5.9 | 5.95 | 5.66 | 5.8 | 54400.0 |
| 2006-03-07 | DBC | ETF | 23.29 | 23.34 | 22.97 | 23.09 | 341300.0 |
| 2006-03-07 | DGT | ETF | 66.42 | 66.46 | 66.25 | 66.46 | 1800.0 |
| 2006-03-07 | DIG | ETF | 17.2125 | 17.275 | 17.1875 | 17.2625 | 6880.0 |
| 2006-03-07 | DIV | ETF | 12.66 | 12.66 | 12.45 | 12.45 | 24000.0 |
| 2006-03-07 | DRIV | ETF | 37.96 | 38.69 | 36.85 | 38.49 | 1060069.0 |
> showing 50 of 304 rows — these rows as CSV