PREVIEW / etf_daily / 2006-04-24
file: by_date/etf_daily/2006/2006-04-24.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-24 | SPY | ETF | 130.89 | 131.07 | 130.38 | 130.91 | 52546400.0 |
| 2006-04-24 | QQQ | ETF | 41.96 | 42.07 | 41.72 | 41.96 | 78556475.0 |
| 2006-04-24 | IWM | ETF | 76.54 | 76.64 | 75.73 | 76.07 | 39232800.0 |
| 2006-04-24 | DIA | ETF | 113.25 | 113.47 | 112.93 | 113.35 | 5136000.0 |
| 2006-04-24 | GLD | ETF | 62.35 | 62.53 | 61.6 | 61.65 | 7385300.0 |
| 2006-04-24 | TLT | ETF | 84.94 | 85.39 | 84.85 | 85.14 | 991500.0 |
| 2006-04-24 | AAA | ETF | 61.8 | 62.25 | 61.7944 | 62.01 | 1700.0 |
| 2006-04-24 | ADRE | ETF | 139.36 | 139.36 | 137.21 | 138.03 | 27648.0 |
| 2006-04-24 | AFK | ETF | 25.1 | 25.12 | 25.05 | 25.06 | 3600.0 |
| 2006-04-24 | AGG | ETF | 98.49 | 98.65 | 98.32 | 98.6 | 141300.0 |
| 2006-04-24 | AIQ | ETF | 25.85 | 25.85 | 24.5 | 25.1 | 17360.0 |
| 2006-04-24 | AIS | ETF | 1.63 | 1.67 | 1.61 | 1.65 | 155300.0 |
| 2006-04-24 | AOM | ETF | 7.01 | 7.13 | 6.91 | 7.1 | 169700.0 |
| 2006-04-24 | ARB | ETF | 33.79 | 34.47 | 33.45 | 34.2 | 278800.0 |
| 2006-04-24 | BAB | ETF | 59.86 | 60.06 | 59.45 | 59.85 | 56600.0 |
| 2006-04-24 | BBC | ETF | 14.67 | 14.93 | 14.41 | 14.789 | 443400.0 |
| 2006-04-24 | BBH | ETF | 61.11 | 61.5633 | 60.7067 | 61.1667 | 1974900.0 |
| 2006-04-24 | BCM | ETF | 73.3 | 73.92 | 73.3 | 73.78 | 7400.0 |
| 2006-04-24 | BITS | ETF | 37.24 | 39.16 | 36.8 | 38.08 | 79946.0 |
| 2006-04-24 | BKF | ETF | 8.5 | 8.66 | 8.49 | 8.55 | 122300.0 |
| 2006-04-24 | BNE | ETF | 16.27 | 16.47 | 15.99 | 16.07 | 83400.0 |
| 2006-04-24 | BRF | ETF | 13.9 | 13.9 | 13.9 | 13.9 | 1000.0 |
| 2006-04-24 | BTF | ETF | 87.24999999999999 | 87.24999999999999 | 87.10499999999999 | 87.24999999999999 | 580.0 |
| 2006-04-24 | CBON | ETF | 33.26 | 34.31 | 32.9 | 33.94 | 18251.0 |
| 2006-04-24 | CDL | ETF | 9.65 | 9.68 | 9.5 | 9.56 | 842500.0 |
| 2006-04-24 | CEF | ETF | 9.27 | 9.61 | 9.11 | 9.29 | 1088400.0 |
| 2006-04-24 | CEW | ETF | 25.5 | 25.5 | 25.5 | 25.5 | 200.0 |
| 2006-04-24 | CFO | ETF | 10.38 | 10.38 | 10.35 | 10.35 | 55600.0 |
| 2006-04-24 | CGO | ETF | 14.28 | 14.46 | 14.26 | 14.46 | 43100.0 |
| 2006-04-24 | CHB | ETF | 15.45 | 15.61 | 15.17 | 15.2 | 474300.0 |
| 2006-04-24 | CHI | ETF | 20.07 | 20.3 | 20.03 | 20.26 | 69300.0 |
| 2006-04-24 | CHIC | ETF | 20.3 | 20.9 | 20.3 | 20.3 | 903305.0 |
| 2006-04-24 | CHY | ETF | 15.92 | 16.03 | 15.9 | 16.02 | 83900.0 |
| 2006-04-24 | CIL | ETF | 25.72 | 25.72 | 25.72 | 25.72 | 800.0 |
| 2006-04-24 | CN | ETF | 37.1 | 37.34 | 36.72 | 37.33 | 54900.0 |
| 2006-04-24 | CNXT | ETF | 3.76 | 3.761 | 3.54 | 3.62 | 26553853.0 |
| 2006-04-24 | COMB | ETF | 9.39 | 10.45 | 9.39 | 9.91 | 4550.0 |
| 2006-04-24 | CPST | ETF | 4.09 | 4.15 | 3.99 | 4.04 | 2999575.0 |
| 2006-04-24 | CSA | ETF | 19.7 | 19.7 | 19.5 | 19.5 | 5500.0 |
| 2006-04-24 | CSB | ETF | 31.53 | 31.92 | 31.53 | 31.79 | 3500.0 |
| 2006-04-24 | CSQ | ETF | 14.04 | 14.1 | 13.92 | 14.1 | 435600.0 |
| 2006-04-24 | CTEC | ETF | 63.4 | 63.65 | 63.05 | 63.25 | 5665.0 |
| 2006-04-24 | CYB | ETF | 6.2 | 6.2 | 6.1 | 6.12 | 3600.0 |
| 2006-04-24 | DBC | ETF | 25.99 | 26.09 | 25.56 | 25.62 | 481900.0 |
| 2006-04-24 | DGT | ETF | 68.29 | 68.29 | 68.25 | 68.25 | 600.0 |
| 2006-04-24 | DIG | ETF | 17.8125 | 17.8125 | 17.8125 | 17.8125 | 4320.0 |
| 2006-04-24 | DIV | ETF | 12.0 | 12.07 | 11.96 | 12.07 | 8500.0 |
| 2006-04-24 | DRIV | ETF | 46.51 | 46.77 | 46.2 | 46.52 | 607179.0 |
| 2006-04-24 | DSI | ETF | 6.325 | 6.335 | 6.325 | 6.335 | 1800.0 |
| 2006-04-24 | DUSA | ETF | 6.88 | 7.0 | 6.75 | 6.81 | 149293.0 |
> showing 50 of 308 rows — these rows as CSV