PREVIEW / etf_daily / 2006-04-10
file: by_date/etf_daily/2006/2006-04-10.parquet size: 16 KB rows: 308
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-10 | SPY | ETF | 129.74 | 130.08 | 129.26 | 129.74 | 41496500.0 |
| 2006-04-10 | QQQ | ETF | 42.4 | 42.5 | 42.09 | 42.26 | 58988051.0 |
| 2006-04-10 | IWM | ETF | 75.03 | 75.46 | 74.51 | 74.93 | 39109200.0 |
| 2006-04-10 | DIA | ETF | 111.43 | 111.84 | 111.17 | 111.51 | 5947700.0 |
| 2006-04-10 | GLD | ETF | 59.48 | 59.65 | 58.95 | 59.6 | 3682000.0 |
| 2006-04-10 | TLT | ETF | 85.15 | 85.3 | 84.96 | 85.26 | 1527100.0 |
| 2006-04-10 | AAA | ETF | 60.5 | 60.69 | 60.4 | 60.5 | 3200.0 |
| 2006-04-10 | ADRE | ETF | 133.49 | 133.49 | 132.0 | 132.13 | 18784.0 |
| 2006-04-10 | AFK | ETF | 25.11 | 25.17 | 25.06 | 25.15 | 6300.0 |
| 2006-04-10 | AGG | ETF | 98.06 | 98.33 | 98.06 | 98.3 | 267400.0 |
| 2006-04-10 | AIQ | ETF | 30.0 | 30.15 | 28.15 | 28.6 | 16540.0 |
| 2006-04-10 | AIS | ETF | 1.55 | 1.59 | 1.45 | 1.54 | 401100.0 |
| 2006-04-10 | AOM | ETF | 6.73 | 6.99 | 6.7 | 6.88 | 56500.0 |
| 2006-04-10 | ARB | ETF | 33.09 | 33.14 | 32.69 | 33.0 | 406600.0 |
| 2006-04-10 | BAB | ETF | 60.3 | 60.61 | 60.03 | 60.07 | 16100.0 |
| 2006-04-10 | BBC | ETF | 16.8 | 17.0 | 16.1 | 16.6 | 220300.0 |
| 2006-04-10 | BBH | ETF | 62.2933 | 62.6133 | 62.1067 | 62.26 | 1596300.0 |
| 2006-04-10 | BCM | ETF | 73.79 | 73.8 | 73.18 | 73.18 | 16100.0 |
| 2006-04-10 | BITS | ETF | 31.0 | 31.04 | 30.28 | 30.44 | 38621.0 |
| 2006-04-10 | BKF | ETF | 10.17 | 10.29 | 9.84 | 10.0 | 104400.0 |
| 2006-04-10 | BNE | ETF | 16.1 | 16.33 | 15.9 | 16.08 | 81300.0 |
| 2006-04-10 | BRF | ETF | 14.05 | 14.05 | 14.01 | 14.05 | 29600.0 |
| 2006-04-10 | BTF | ETF | 88.14999999999999 | 88.14999999999999 | 87.65 | 87.94999999999999 | 1240.0 |
| 2006-04-10 | CBON | ETF | 30.89 | 31.72 | 30.75 | 31.0 | 40443.0 |
| 2006-04-10 | CDL | ETF | 10.71 | 10.84 | 10.66 | 10.69 | 266900.0 |
| 2006-04-10 | CEF | ETF | 8.96 | 8.98 | 8.77 | 8.91 | 850800.0 |
| 2006-04-10 | CEW | ETF | 25.45 | 25.45 | 25.45 | 25.45 | 400.0 |
| 2006-04-10 | CFO | ETF | 10.15 | 10.2 | 10.05 | 10.05 | 25400.0 |
| 2006-04-10 | CGO | ETF | 14.4 | 14.5 | 14.31 | 14.43 | 41300.0 |
| 2006-04-10 | CHB | ETF | 15.33 | 15.49 | 15.15 | 15.37 | 332800.0 |
| 2006-04-10 | CHI | ETF | 20.83 | 20.86 | 20.65 | 20.74 | 82000.0 |
| 2006-04-10 | CHIC | ETF | 20.92 | 21.22 | 20.85 | 21.05 | 442706.0 |
| 2006-04-10 | CHIR | ETF | 47.88 | 47.94 | 47.8701 | 47.94 | 517259.0 |
| 2006-04-10 | CHY | ETF | 16.32 | 16.35 | 16.22 | 16.33 | 64600.0 |
| 2006-04-10 | CIL | ETF | 25.63 | 25.63 | 25.63 | 25.63 | 400.0 |
| 2006-04-10 | CIZ | ETF | 23.65 | 23.65 | 23.65 | 23.65 | 200.0 |
| 2006-04-10 | CN | ETF | 37.0 | 37.0 | 36.6 | 36.6 | 47100.0 |
| 2006-04-10 | CNXT | ETF | 3.77 | 3.77 | 3.55 | 3.55 | 15531323.0 |
| 2006-04-10 | CPST | ETF | 3.81 | 4.4 | 3.77 | 4.26 | 14789180.0 |
| 2006-04-10 | CSA | ETF | 20.56 | 20.6 | 19.72 | 19.86 | 15300.0 |
| 2006-04-10 | CSB | ETF | 29.68 | 29.75 | 29.54 | 29.55 | 21700.0 |
| 2006-04-10 | CSQ | ETF | 14.08 | 14.11 | 13.98 | 14.07 | 309700.0 |
| 2006-04-10 | CTEC | ETF | 65.0 | 65.0 | 63.550000000000004 | 63.550000000000004 | 4518.0 |
| 2006-04-10 | CYB | ETF | 6.12 | 6.33 | 6.01 | 6.1 | 20800.0 |
| 2006-04-10 | DBC | ETF | 24.69 | 24.85 | 24.51 | 24.84 | 497100.0 |
| 2006-04-10 | DGT | ETF | 67.1 | 67.32 | 67.1 | 67.17 | 3300.0 |
| 2006-04-10 | DIG | ETF | 17.5625 | 17.675 | 17.5625 | 17.675 | 240.0 |
| 2006-04-10 | DIV | ETF | 12.19 | 12.2 | 12.12 | 12.2 | 14700.0 |
| 2006-04-10 | DRIV | ETF | 44.16 | 44.23 | 43.1 | 43.98 | 825657.0 |
| 2006-04-10 | DUSA | ETF | 6.75 | 6.84 | 6.63 | 6.76 | 93000.0 |
> showing 50 of 308 rows — these rows as CSV