PREVIEW / etf_daily / 2006-07-14
file: by_date/etf_daily/2006/2006-07-14.parquet size: 18 KB rows: 358
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-07-14 | SPY | ETF | 124.13 | 124.26 | 122.83 | 123.52 | 103242500.0 |
| 2006-07-14 | QQQ | ETF | 36.3 | 36.38 | 35.79 | 35.94 | 172448477.0 |
| 2006-07-14 | IWM | ETF | 68.08 | 68.21 | 66.95 | 67.53 | 79083700.0 |
| 2006-07-14 | DIA | ETF | 108.43 | 108.59 | 107.01 | 107.32 | 8206500.0 |
| 2006-07-14 | GLD | ETF | 65.9 | 66.42 | 65.7 | 65.85 | 10035800.0 |
| 2006-07-14 | TLT | ETF | 84.82 | 85.16 | 84.82 | 85.04 | 1343900.0 |
| 2006-07-14 | AAA | ETF | 55.12 | 55.19 | 54.94 | 55.06 | 1700.0 |
| 2006-07-14 | ADRE | ETF | 29.97 | 30.15 | 29.01 | 29.97 | 569730.0 |
| 2006-07-14 | AFK | ETF | 24.97 | 25.0699 | 24.97 | 25.06 | 5200.0 |
| 2006-07-14 | AGG | ETF | 97.8 | 97.89 | 97.63 | 97.88 | 738700.0 |
| 2006-07-14 | AIQ | ETF | 30.55 | 31.4 | 29.0 | 31.15 | 30120.0 |
| 2006-07-14 | AIS | ETF | 1.1 | 1.14 | 1.03 | 1.1 | 107500.0 |
| 2006-07-14 | AOM | ETF | 6.3 | 6.53 | 6.3 | 6.53 | 16000.0 |
| 2006-07-14 | ARB | ETF | 36.34 | 36.56 | 36.0 | 36.27 | 225800.0 |
| 2006-07-14 | BAB | ETF | 64.7 | 64.9 | 63.33 | 64.05 | 64000.0 |
| 2006-07-14 | BBC | ETF | 12.8 | 12.81 | 11.85 | 12.5 | 275900.0 |
| 2006-07-14 | BBH | ETF | 58.3433 | 58.3533 | 56.75 | 57.2367 | 1726200.0 |
| 2006-07-14 | BITS | ETF | 17.6 | 18.4 | 17.6 | 17.84 | 10498.0 |
| 2006-07-14 | BKF | ETF | 5.83 | 6.0 | 5.81 | 5.81 | 22100.0 |
| 2006-07-14 | BNE | ETF | 13.3 | 13.51 | 13.2 | 13.29 | 120100.0 |
| 2006-07-14 | BOSS | ETF | 31.8 | 31.8 | 31.75 | 31.75 | 100.0 |
| 2006-07-14 | BRF | ETF | 13.9 | 14.0 | 13.9 | 14.0 | 11300.0 |
| 2006-07-14 | BTF | ETF | 88.1 | 88.1 | 87.14999999999999 | 87.14999999999999 | 440.0 |
| 2006-07-14 | CBON | ETF | 31.41 | 32.08 | 30.57 | 30.57 | 19160.0 |
| 2006-07-14 | CDL | ETF | 8.6 | 8.6 | 8.4 | 8.47 | 175100.0 |
| 2006-07-14 | CEF | ETF | 9.38 | 9.51 | 9.25 | 9.5 | 581000.0 |
| 2006-07-14 | CEW | ETF | 25.9 | 25.9 | 25.9 | 25.9 | 500.0 |
| 2006-07-14 | CFO | ETF | 10.02 | 10.02 | 10.0 | 10.0 | 2000.0 |
| 2006-07-14 | CGO | ETF | 14.8 | 14.84 | 14.5 | 14.56 | 24700.0 |
| 2006-07-14 | CHB | ETF | 9.16 | 9.16 | 8.23 | 8.6 | 3555700.0 |
| 2006-07-14 | CHI | ETF | 19.49 | 19.51 | 19.1 | 19.35 | 87300.0 |
| 2006-07-14 | CHIC | ETF | 22.42 | 22.47 | 21.7 | 21.82 | 393017.0 |
| 2006-07-14 | CHY | ETF | 16.08 | 16.08 | 15.9 | 16.0 | 124000.0 |
| 2006-07-14 | CIL | ETF | 25.25 | 25.25 | 25.21 | 25.21 | 800.0 |
| 2006-07-14 | CIZ | ETF | 22.4 | 22.4 | 22.4 | 22.4 | 200.0 |
| 2006-07-14 | CN | ETF | 34.7 | 34.7 | 34.3 | 34.46 | 48300.0 |
| 2006-07-14 | CNXT | ETF | 2.075 | 2.13 | 2.03 | 2.08 | 9275486.0 |
| 2006-07-14 | COMB | ETF | 9.75 | 9.9 | 9.75 | 9.9 | 5322.0 |
| 2006-07-14 | CPI | ETF | 29.4 | 29.4 | 29.1 | 29.1 | 500.0 |
| 2006-07-14 | CPST | ETF | 2.11 | 2.14 | 1.93 | 2.04 | 2046056.0 |
| 2006-07-14 | CSA | ETF | 18.75 | 18.8 | 18.75 | 18.79 | 3200.0 |
| 2006-07-14 | CSB | ETF | 27.73 | 27.73 | 27.44 | 27.61 | 10400.0 |
| 2006-07-14 | CSQ | ETF | 13.84 | 13.87 | 13.6 | 13.6 | 230400.0 |
| 2006-07-14 | CTEC | ETF | 63.699999999999996 | 63.949999999999996 | 60.8 | 62.75 | 23232.2 |
| 2006-07-14 | CYB | ETF | 5.9 | 5.9 | 5.66 | 5.82 | 55000.0 |
| 2006-07-14 | DBC | ETF | 26.7 | 26.74 | 26.33 | 26.5 | 462800.0 |
| 2006-07-14 | DDM | ETF | 5.6833 | 5.6833 | 5.5658 | 5.5933 | 2329200.0 |
| 2006-07-14 | DES | ETF | 16.83 | 16.83 | 16.63 | 16.7567 | 13500.0 |
| 2006-07-14 | DEW | ETF | 50.27 | 50.27 | 50.26 | 50.26 | 700.0 |
| 2006-07-14 | DFE | ETF | 51.63 | 51.63 | 51.63 | 51.63 | 600.0 |
> showing 50 of 358 rows — these rows as CSV