PREVIEW / etf_daily / 2006-05-10
file: by_date/etf_daily/2006/2006-05-10.parquet size: 17 KB rows: 325
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-05-10 | SPY | ETF | 132.41 | 132.75 | 131.89 | 132.55 | 64378200.0 |
| 2006-05-10 | QQQ | ETF | 41.93 | 41.98 | 41.55 | 41.67 | 92440514.0 |
| 2006-05-10 | IWM | ETF | 77.38 | 77.46 | 76.73 | 77.05 | 26824100.0 |
| 2006-05-10 | DIA | ETF | 116.25 | 116.8 | 116.04 | 116.56 | 8291900.0 |
| 2006-05-10 | GLD | ETF | 69.27 | 70.49 | 69.27 | 70.38 | 10312100.0 |
| 2006-05-10 | TLT | ETF | 83.8 | 84.02 | 83.35 | 83.75 | 1320200.0 |
| 2006-05-10 | AAA | ETF | 63.14 | 63.16 | 62.96 | 62.99 | 7300.0 |
| 2006-05-10 | ADRE | ETF | 147.93 | 147.93 | 144.85 | 145.44 | 49240.0 |
| 2006-05-10 | AFK | ETF | 25.16 | 25.2199 | 25.16 | 25.17 | 6000.0 |
| 2006-05-10 | AGG | ETF | 97.97 | 98.19 | 97.22 | 97.86 | 170700.0 |
| 2006-05-10 | AIQ | ETF | 31.9 | 32.0 | 30.95 | 31.75 | 39180.0 |
| 2006-05-10 | AIS | ETF | 1.49 | 1.55 | 1.47 | 1.5099 | 187200.0 |
| 2006-05-10 | AOM | ETF | 6.89 | 7.0 | 6.8 | 6.93 | 127200.0 |
| 2006-05-10 | ARB | ETF | 36.6 | 36.605 | 36.29 | 36.32 | 346700.0 |
| 2006-05-10 | BAB | ETF | 65.18 | 65.7 | 65.14 | 65.56 | 144100.0 |
| 2006-05-10 | BBC | ETF | 14.68 | 15.2 | 14.25 | 14.64 | 865100.0 |
| 2006-05-10 | BBH | ETF | 58.35 | 58.7433 | 58.1 | 58.1667 | 1833900.0 |
| 2006-05-10 | BCM | ETF | 74.77 | 75.66 | 74.75 | 75.27 | 23000.0 |
| 2006-05-10 | BITS | ETF | 34.2 | 34.2 | 32.32 | 33.0 | 41797.0 |
| 2006-05-10 | BKF | ETF | 9.44 | 9.44 | 9.02 | 9.12 | 31600.0 |
| 2006-05-10 | BNE | ETF | 15.88 | 16.0 | 15.1 | 15.42 | 148100.0 |
| 2006-05-10 | BRF | ETF | 14.0 | 14.0 | 14.0 | 14.0 | 200.0 |
| 2006-05-10 | BTF | ETF | 89.0 | 89.3 | 89.0 | 89.3 | 280.0 |
| 2006-05-10 | CBON | ETF | 33.49 | 33.96 | 32.61 | 32.99 | 12754.0 |
| 2006-05-10 | CDL | ETF | 10.55 | 10.76 | 10.52 | 10.65 | 1352700.0 |
| 2006-05-10 | CEF | ETF | 10.28 | 10.4 | 10.2 | 10.25 | 1054800.0 |
| 2006-05-10 | CEW | ETF | 25.55 | 25.55 | 25.55 | 25.55 | 700.0 |
| 2006-05-10 | CFO | ETF | 10.35 | 10.4 | 10.35 | 10.35 | 5400.0 |
| 2006-05-10 | CGO | ETF | 14.82 | 15.06 | 14.82 | 14.93 | 61600.0 |
| 2006-05-10 | CHB | ETF | 15.8 | 15.8428 | 15.4 | 15.57 | 677300.0 |
| 2006-05-10 | CHI | ETF | 20.02 | 20.09 | 19.98 | 20.0 | 72500.0 |
| 2006-05-10 | CHIC | ETF | 23.1 | 23.32 | 23.1 | 23.3 | 167937.0 |
| 2006-05-10 | CHY | ETF | 16.2 | 16.24 | 16.08 | 16.17 | 113700.0 |
| 2006-05-10 | CIL | ETF | 25.85 | 25.85 | 25.85 | 25.85 | 200.0 |
| 2006-05-10 | CIZ | ETF | 23.1 | 23.1 | 23.1 | 23.1 | 200.0 |
| 2006-05-10 | CN | ETF | 39.65 | 39.66 | 39.16 | 39.32 | 83300.0 |
| 2006-05-10 | CNXT | ETF | 3.665 | 3.68 | 3.57 | 3.65 | 12771286.0 |
| 2006-05-10 | COMB | ETF | 10.14 | 10.25 | 10.0 | 10.1 | 126411.0 |
| 2006-05-10 | CPI | ETF | 31.4 | 31.65 | 31.4 | 31.65 | 2400.0 |
| 2006-05-10 | CPST | ETF | 3.78 | 3.79 | 3.43 | 3.55 | 3956950.0 |
| 2006-05-10 | CSA | ETF | 19.44 | 19.62 | 19.0 | 19.45 | 11800.0 |
| 2006-05-10 | CSB | ETF | 31.35 | 31.64 | 31.35 | 31.64 | 8000.0 |
| 2006-05-10 | CSQ | ETF | 14.01 | 14.04 | 13.96 | 13.98 | 357300.0 |
| 2006-05-10 | CTEC | ETF | 65.25 | 66.14999999999999 | 62.55049999999999 | 63.8 | 21677.800000000003 |
| 2006-05-10 | CYB | ETF | 6.21 | 6.3 | 6.16 | 6.24 | 36500.0 |
| 2006-05-10 | DBC | ETF | 26.13 | 26.68 | 26.03 | 26.68 | 757600.0 |
| 2006-05-10 | DGT | ETF | 69.96 | 69.96 | 69.6 | 69.76 | 1800.0 |
| 2006-05-10 | DIG | ETF | 17.9625 | 17.9625 | 17.9625 | 17.9625 | 160.0 |
| 2006-05-10 | DIV | ETF | 12.02 | 12.048 | 11.99 | 12.03 | 10900.0 |
| 2006-05-10 | DRIV | ETF | 47.39 | 47.39 | 46.6184 | 46.76 | 537861.0 |
> showing 50 of 325 rows — these rows as CSV