PREVIEW / etf_daily / 2006-10-24
file: by_date/etf_daily/2006/2006-10-24.parquet size: 19 KB rows: 376
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-10-24 | SPY | ETF | 137.28 | 137.93 | 137.22 | 137.88 | 53234900.0 |
| 2006-10-24 | QQQ | ETF | 42.29 | 42.45 | 41.92 | 42.13 | 103675795.0 |
| 2006-10-24 | IWM | ETF | 75.51 | 75.95 | 75.34 | 75.9 | 30504800.0 |
| 2006-10-24 | DIA | ETF | 120.86 | 121.25 | 120.75 | 121.21 | 7025100.0 |
| 2006-10-24 | GLD | ETF | 57.2 | 58.26 | 56.87 | 58.17 | 3558200.0 |
| 2006-10-24 | TLT | ETF | 87.17 | 87.25 | 87.15 | 87.2 | 243400.0 |
| 2006-10-24 | AAA | ETF | 54.37 | 54.6 | 54.3 | 54.44 | 25600.0 |
| 2006-10-24 | ADRE | ETF | 34.24 | 34.5 | 34.02 | 34.28 | 110006.0 |
| 2006-10-24 | AGG | ETF | 99.24 | 99.32 | 99.2 | 99.26 | 209000.0 |
| 2006-10-24 | AIQ | ETF | 40.95 | 41.4 | 40.5 | 41.35 | 31000.0 |
| 2006-10-24 | AIS | ETF | 1.28 | 1.28 | 1.23 | 1.23 | 131300.0 |
| 2006-10-24 | ARB | ETF | 41.88 | 41.88 | 41.1 | 41.32 | 188600.0 |
| 2006-10-24 | BAB | ETF | 85.69 | 86.849 | 85.69 | 86.37 | 35800.0 |
| 2006-10-24 | BBC | ETF | 9.55 | 9.6 | 9.2001 | 9.3 | 273600.0 |
| 2006-10-24 | BBH | ETF | 63.5 | 63.5 | 62.7267 | 63.0633 | 1239900.0 |
| 2006-10-24 | BITS | ETF | 40.64 | 42.88 | 40.2 | 41.76 | 102259.0 |
| 2006-10-24 | BNE | ETF | 15.5 | 15.7 | 15.4 | 15.57 | 534000.0 |
| 2006-10-24 | BRF | ETF | 14.27 | 14.28 | 14.23 | 14.28 | 10600.0 |
| 2006-10-24 | BTF | ETF | 100.19999999999999 | 100.95 | 100.19999999999999 | 100.95 | 920.0 |
| 2006-10-24 | CBON | ETF | 29.51 | 29.51 | 29.0 | 29.11 | 90506.0 |
| 2006-10-24 | CDL | ETF | 9.75 | 9.75 | 9.59 | 9.6 | 149900.0 |
| 2006-10-24 | CEF | ETF | 8.15 | 8.27 | 8.08 | 8.2 | 600300.0 |
| 2006-10-24 | CFO | ETF | 10.13 | 10.32 | 10.13 | 10.32 | 18600.0 |
| 2006-10-24 | CGO | ETF | 15.8 | 15.8 | 15.59 | 15.63 | 33300.0 |
| 2006-10-24 | CHB | ETF | 7.64 | 7.75 | 7.57 | 7.66 | 1081200.0 |
| 2006-10-24 | CHI | ETF | 19.28 | 19.46 | 19.28 | 19.44 | 134300.0 |
| 2006-10-24 | CHIC | ETF | 28.62 | 28.99 | 27.9354 | 28.44 | 243079.0 |
| 2006-10-24 | CHY | ETF | 16.95 | 17.07 | 16.95 | 17.02 | 168700.0 |
| 2006-10-24 | CIL | ETF | 25.87 | 25.88 | 25.87 | 25.88 | 1900.0 |
| 2006-10-24 | CN | ETF | 35.25 | 35.34 | 35.05 | 35.15 | 47800.0 |
| 2006-10-24 | CNXT | ETF | 1.98 | 1.99 | 1.87 | 1.87 | 14017710.0 |
| 2006-10-24 | COMB | ETF | 9.84 | 10.0 | 9.84 | 10.0 | 1999.0 |
| 2006-10-24 | CPST | ETF | 1.57 | 1.57 | 1.51 | 1.53 | 842029.0 |
| 2006-10-24 | CSA | ETF | 21.6 | 21.99 | 21.55 | 21.75 | 47500.0 |
| 2006-10-24 | CSB | ETF | 30.13 | 30.3399 | 30.06 | 30.26 | 7900.0 |
| 2006-10-24 | CSQ | ETF | 14.99 | 15.0 | 14.93 | 14.99 | 519300.0 |
| 2006-10-24 | CTEC | ETF | 61.39999999999999 | 62.449999999999996 | 60.599999999999994 | 60.8 | 8973.800000000001 |
| 2006-10-24 | CVY | ETF | 25.76 | 25.81 | 25.68 | 25.81 | 27600.0 |
| 2006-10-24 | CYB | ETF | 7.42 | 7.45 | 7.31 | 7.4 | 85900.0 |
| 2006-10-24 | DBC | ETF | 24.06 | 24.31 | 23.8 | 24.27 | 226500.0 |
| 2006-10-24 | DBV | ETF | 25.63 | 25.67 | 25.6 | 25.64 | 35700.0 |
| 2006-10-24 | DDM | ETF | 7.05 | 7.0883 | 7.04 | 7.0833 | 757200.0 |
| 2006-10-24 | DES | ETF | 18.5167 | 18.55 | 18.4833 | 18.55 | 30000.0 |
| 2006-10-24 | DEW | ETF | 56.99 | 57.34 | 56.94 | 57.34 | 9200.0 |
| 2006-10-24 | DFE | ETF | 57.68 | 58.0 | 57.68 | 58.0 | 4900.0 |
| 2006-10-24 | DFJ | ETF | 49.8 | 50.1 | 49.8 | 50.05 | 15500.0 |
| 2006-10-24 | DGT | ETF | 73.6 | 73.74 | 73.33 | 73.51 | 26100.0 |
| 2006-10-24 | DHS | ETF | 56.18 | 56.31 | 56.02 | 56.31 | 22300.0 |
| 2006-10-24 | DIM | ETF | 57.92 | 58.23 | 57.92 | 58.19 | 8200.0 |
| 2006-10-24 | DIV | ETF | 13.13 | 13.13 | 13.02 | 13.13 | 28900.0 |
> showing 50 of 376 rows — these rows as CSV