PREVIEW / etf_daily / 2006-04-21
file: by_date/etf_daily/2006/2006-04-21.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-04-21 | SPY | ETF | 131.69 | 131.79 | 130.62 | 131.15 | 72342600.0 |
| 2006-04-21 | QQQ | ETF | 42.67 | 42.86 | 41.82 | 42.0 | 130186988.0 |
| 2006-04-21 | IWM | ETF | 77.27 | 77.35 | 76.26 | 76.68 | 40075800.0 |
| 2006-04-21 | DIA | ETF | 113.91 | 113.98 | 113.1 | 113.4 | 6997100.0 |
| 2006-04-21 | GLD | ETF | 62.51 | 63.28 | 61.78 | 63.2 | 7528100.0 |
| 2006-04-21 | TLT | ETF | 84.53 | 84.86 | 84.25 | 84.8 | 1303000.0 |
| 2006-04-21 | AAA | ETF | 61.54 | 61.55 | 61.11 | 61.23 | 3500.0 |
| 2006-04-21 | ADRE | ETF | 138.0 | 140.1 | 138.0 | 139.15 | 29844.0 |
| 2006-04-21 | AFK | ETF | 25.09 | 25.11 | 25.02 | 25.03 | 3300.0 |
| 2006-04-21 | AGG | ETF | 98.24 | 98.42 | 98.08 | 98.23 | 396000.0 |
| 2006-04-21 | AIQ | ETF | 26.0 | 26.0 | 24.5 | 24.8 | 17240.0 |
| 2006-04-21 | AIS | ETF | 1.7 | 1.75 | 1.62 | 1.67 | 382200.0 |
| 2006-04-21 | AOM | ETF | 6.69 | 6.69 | 6.67 | 6.67 | 300.0 |
| 2006-04-21 | ARB | ETF | 34.25 | 34.25 | 33.69 | 33.74 | 269100.0 |
| 2006-04-21 | BAB | ETF | 61.29 | 61.29 | 60.12 | 60.3 | 49800.0 |
| 2006-04-21 | BBC | ETF | 15.39 | 15.45 | 14.51 | 14.7 | 462200.0 |
| 2006-04-21 | BBH | ETF | 62.0867 | 62.2667 | 60.9933 | 61.0167 | 1682100.0 |
| 2006-04-21 | BCM | ETF | 74.14 | 74.21 | 73.43 | 73.86 | 19000.0 |
| 2006-04-21 | BITS | ETF | 34.36 | 37.92 | 34.36 | 36.64 | 79919.0 |
| 2006-04-21 | BKF | ETF | 8.8 | 8.84 | 8.51 | 8.54 | 81800.0 |
| 2006-04-21 | BNE | ETF | 16.97 | 16.97 | 16.05 | 16.19 | 99700.0 |
| 2006-04-21 | BRF | ETF | 13.83 | 13.93 | 13.83 | 13.9 | 24000.0 |
| 2006-04-21 | BTF | ETF | 87.24999999999999 | 87.35 | 87.24999999999999 | 87.24999999999999 | 840.0 |
| 2006-04-21 | CBON | ETF | 33.5 | 34.0 | 32.88 | 33.25 | 42759.0 |
| 2006-04-21 | CDL | ETF | 10.0 | 10.0 | 9.65 | 9.66 | 1023800.0 |
| 2006-04-21 | CEF | ETF | 9.27 | 9.82 | 9.18 | 9.65 | 1330900.0 |
| 2006-04-21 | CEW | ETF | 25.45 | 25.45 | 25.42 | 25.42 | 1100.0 |
| 2006-04-21 | CFO | ETF | 10.28 | 10.3 | 10.28 | 10.3 | 4200.0 |
| 2006-04-21 | CGO | ETF | 14.32 | 14.45 | 14.2 | 14.24 | 62400.0 |
| 2006-04-21 | CHB | ETF | 15.94 | 15.95 | 15.44 | 15.46 | 602500.0 |
| 2006-04-21 | CHI | ETF | 20.15 | 20.21 | 20.07 | 20.19 | 75100.0 |
| 2006-04-21 | CHIC | ETF | 21.21 | 21.25 | 20.25 | 20.42 | 1288091.0 |
| 2006-04-21 | CHY | ETF | 16.02 | 16.03 | 15.9 | 15.97 | 82300.0 |
| 2006-04-21 | CIL | ETF | 25.7 | 25.71 | 25.7 | 25.71 | 800.0 |
| 2006-04-21 | CN | ETF | 38.55 | 38.75 | 38.44 | 38.5 | 41300.0 |
| 2006-04-21 | CNXT | ETF | 3.81 | 3.86 | 3.58 | 3.64 | 44792419.0 |
| 2006-04-21 | COMB | ETF | 9.1 | 9.1 | 9.1 | 9.1 | 300.0 |
| 2006-04-21 | CPST | ETF | 4.18 | 4.24 | 4.009 | 4.03 | 3329913.0 |
| 2006-04-21 | CSA | ETF | 19.69 | 19.85 | 19.6 | 19.6 | 8500.0 |
| 2006-04-21 | CSB | ETF | 31.02 | 31.3 | 31.0001 | 31.16 | 3900.0 |
| 2006-04-21 | CSQ | ETF | 14.09 | 14.1 | 13.94 | 14.0 | 353000.0 |
| 2006-04-21 | CTEC | ETF | 63.449999999999996 | 63.699999999999996 | 62.99999999999999 | 63.550000000000004 | 6820.200000000001 |
| 2006-04-21 | CYB | ETF | 6.2 | 6.25 | 6.15 | 6.22 | 4600.0 |
| 2006-04-21 | DBC | ETF | 25.67 | 26.21 | 25.51 | 26.14 | 559000.0 |
| 2006-04-21 | DGT | ETF | 68.49 | 68.49 | 68.26 | 68.46 | 1200.0 |
| 2006-04-21 | DIG | ETF | 17.75 | 17.9375 | 17.75 | 17.9375 | 8400.0 |
| 2006-04-21 | DIV | ETF | 12.02 | 12.07 | 11.95 | 12.0 | 10100.0 |
| 2006-04-21 | DRIV | ETF | 46.68 | 47.0 | 45.9 | 46.76 | 1010280.0 |
| 2006-04-21 | DUSA | ETF | 7.05 | 7.05 | 6.75 | 6.92 | 253498.0 |
| 2006-04-21 | DVY | ETF | 63.37 | 63.42 | 62.92 | 63.06 | 294200.0 |
> showing 50 of 307 rows — these rows as CSV