PREVIEW / etf_daily / 2006-03-06
file: by_date/etf_daily/2006/2006-03-06.parquet size: 16 KB rows: 307
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-06 | SPY | ETF | 129.14 | 129.18 | 127.85 | 128.17 | 57478400.0 |
| 2006-03-06 | QQQ | ETF | 41.53 | 41.63 | 40.96 | 41.09 | 99593596.0 |
| 2006-03-06 | IWM | ETF | 73.4 | 73.46 | 72.44 | 72.65 | 29340300.0 |
| 2006-03-06 | DIA | ETF | 110.14 | 110.37 | 109.28 | 109.63 | 5497300.0 |
| 2006-03-06 | GLD | ETF | 56.41 | 56.45 | 54.96 | 55.23 | 5432000.0 |
| 2006-03-06 | TLT | ETF | 88.98 | 88.99 | 88.5 | 88.55 | 872700.0 |
| 2006-03-06 | AAA | ETF | 53.57 | 53.57 | 53.2301 | 53.33 | 3800.0 |
| 2006-03-06 | ADRE | ETF | 131.0 | 131.0 | 127.21 | 127.46 | 37768.0 |
| 2006-03-06 | AFK | ETF | 25.47 | 25.52 | 25.44 | 25.52 | 4000.0 |
| 2006-03-06 | AGG | ETF | 99.4 | 99.46 | 98.92 | 98.95 | 237300.0 |
| 2006-03-06 | AIQ | ETF | 30.0 | 30.1495 | 28.85 | 29.05 | 21640.0 |
| 2006-03-06 | AIS | ETF | 1.38 | 1.39 | 1.32 | 1.36 | 216600.0 |
| 2006-03-06 | AOM | ETF | 6.83 | 6.84 | 6.7 | 6.79 | 43400.0 |
| 2006-03-06 | ARB | ETF | 33.91 | 34.96 | 33.91 | 34.67 | 696800.0 |
| 2006-03-06 | BAB | ETF | 57.81 | 57.81 | 57.16 | 57.18 | 13300.0 |
| 2006-03-06 | BBC | ETF | 14.5 | 15.7 | 14.5 | 15.3 | 255400.0 |
| 2006-03-06 | BBH | ETF | 64.8733 | 64.88 | 64.0467 | 64.0833 | 980700.0 |
| 2006-03-06 | BCM | ETF | 73.23 | 73.79 | 72.57 | 73.57 | 43900.0 |
| 2006-03-06 | BITS | ETF | 33.48 | 33.48 | 31.6 | 32.0 | 50220.0 |
| 2006-03-06 | BKF | ETF | 13.02 | 13.14 | 12.98 | 13.0 | 51100.0 |
| 2006-03-06 | BNE | ETF | 14.04 | 15.1 | 14.04 | 15.0 | 90700.0 |
| 2006-03-06 | BRF | ETF | 14.73 | 14.76 | 14.62 | 14.63 | 27400.0 |
| 2006-03-06 | BTF | ETF | 88.39999999999999 | 88.49999999999999 | 87.89999999999999 | 88.3 | 6280.0 |
| 2006-03-06 | CBON | ETF | 30.15 | 30.37 | 30.15 | 30.15 | 29523.0 |
| 2006-03-06 | CDL | ETF | 11.6 | 11.74 | 11.45 | 11.65 | 432400.0 |
| 2006-03-06 | CEF | ETF | 8.09 | 8.09 | 7.69 | 7.85 | 783900.0 |
| 2006-03-06 | CEW | ETF | 25.5 | 25.5 | 25.5 | 25.5 | 200.0 |
| 2006-03-06 | CFO | ETF | 9.8 | 9.8 | 9.75 | 9.77 | 4600.0 |
| 2006-03-06 | CGO | ETF | 14.42 | 14.42 | 14.17 | 14.26 | 33900.0 |
| 2006-03-06 | CHB | ETF | 15.0 | 15.35 | 15.0 | 15.28 | 686300.0 |
| 2006-03-06 | CHI | ETF | 20.75 | 20.9 | 20.72 | 20.73 | 81300.0 |
| 2006-03-06 | CHIC | ETF | 18.82 | 19.44 | 18.75 | 19.31 | 409500.0 |
| 2006-03-06 | CHIR | ETF | 45.2199 | 45.4299 | 45.0201 | 45.2799 | 710009.0 |
| 2006-03-06 | CHY | ETF | 16.43 | 16.49 | 16.33 | 16.35 | 62800.0 |
| 2006-03-06 | CIL | ETF | 25.62 | 25.62 | 25.62 | 25.62 | 100.0 |
| 2006-03-06 | CN | ETF | 37.15 | 37.17 | 36.74 | 36.81 | 46000.0 |
| 2006-03-06 | CNXT | ETF | 3.285 | 3.33 | 3.13 | 3.15 | 18031960.0 |
| 2006-03-06 | COMB | ETF | 8.35 | 8.35 | 8.35 | 8.35 | 2750.0 |
| 2006-03-06 | CPST | ETF | 3.32 | 3.36 | 3.21 | 3.26 | 2394670.0 |
| 2006-03-06 | CSA | ETF | 19.52 | 19.85 | 19.5 | 19.85 | 8600.0 |
| 2006-03-06 | CSB | ETF | 30.75 | 30.9 | 30.62 | 30.68 | 5600.0 |
| 2006-03-06 | CSM | ETF | 2.485 | 2.4875 | 2.4825 | 2.4825 | 10000.0 |
| 2006-03-06 | CSQ | ETF | 14.27 | 14.28 | 14.1 | 14.1 | 363300.0 |
| 2006-03-06 | CTEC | ETF | 56.25 | 58.449999999999996 | 56.25 | 58.449999999999996 | 13424.400000000001 |
| 2006-03-06 | CYB | ETF | 6.1001 | 6.11 | 5.5 | 5.9 | 79500.0 |
| 2006-03-06 | DBC | ETF | 23.75 | 23.75 | 23.25 | 23.5 | 588300.0 |
| 2006-03-06 | DGT | ETF | 66.77 | 66.77 | 66.63 | 66.63 | 1500.0 |
| 2006-03-06 | DIG | ETF | 17.325 | 17.325 | 17.3125 | 17.3125 | 6480.0 |
| 2006-03-06 | DIV | ETF | 12.68 | 12.74 | 12.65 | 12.65 | 17200.0 |
| 2006-03-06 | DRIV | ETF | 37.82 | 38.58 | 37.82 | 38.17 | 727357.0 |
> showing 50 of 307 rows — these rows as CSV