PREVIEW / etf_daily / 2005-10-14
file: by_date/etf_daily/2005/2005-10-14.parquet size: 15 KB rows: 274
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-14 | SPY | ETF | 118.12 | 118.81 | 117.56 | 118.67 | 88651000.0 |
| 2005-10-14 | QQQ | ETF | 37.87 | 38.07 | 37.64 | 38.06 | 131480594.0 |
| 2005-10-14 | IWM | ETF | 62.5 | 63.02 | 61.32 | 62.91 | 52777600.0 |
| 2005-10-14 | DIA | ETF | 102.49 | 102.97 | 102.0 | 102.83 | 8777900.0 |
| 2005-10-14 | GLD | ETF | 46.49 | 46.83 | 46.41 | 46.8 | 2442300.0 |
| 2005-10-14 | TLT | ETF | 90.6 | 90.7 | 89.82 | 90.23 | 1042600.0 |
| 2005-10-14 | AAA | ETF | 54.46 | 54.8299 | 54.46 | 54.68 | 2000.0 |
| 2005-10-14 | ADRE | ETF | 100.25 | 100.9699 | 98.9 | 100.4 | 24416.0 |
| 2005-10-14 | AFK | ETF | 25.39 | 25.52 | 25.39 | 25.5 | 18800.0 |
| 2005-10-14 | AGG | ETF | 100.6 | 100.81 | 100.33 | 100.5 | 103500.0 |
| 2005-10-14 | AIQ | ETF | 34.6 | 35.45 | 34.25 | 34.95 | 81140.0 |
| 2005-10-14 | AIS | ETF | 0.98 | 1.04 | 0.95 | 1.0 | 127600.0 |
| 2005-10-14 | ARB | ETF | 38.45 | 38.45 | 37.76 | 38.0 | 295200.0 |
| 2005-10-14 | BAB | ETF | 53.6 | 54.05 | 53.38 | 54.05 | 44200.0 |
| 2005-10-14 | BBC | ETF | 7.0 | 7.4 | 7.0 | 7.4 | 82400.0 |
| 2005-10-14 | BBH | ETF | 61.9667 | 62.2933 | 61.5 | 62.1233 | 1246500.0 |
| 2005-10-14 | BCM | ETF | 60.32 | 60.32 | 59.91 | 60.28 | 14500.0 |
| 2005-10-14 | BIS | ETF | 612.8 | 612.8 | 612.8 | 612.8 | 3.125 |
| 2005-10-14 | BITS | ETF | 10.12 | 10.76 | 10.0 | 10.64 | 4688.0 |
| 2005-10-14 | BKF | ETF | 24.85 | 25.89 | 24.7 | 25.4 | 24900.0 |
| 2005-10-14 | BNE | ETF | 13.9 | 14.0 | 13.55 | 13.93 | 89000.0 |
| 2005-10-14 | BRF | ETF | 15.43 | 15.43 | 15.42 | 15.42 | 1200.0 |
| 2005-10-14 | BTF | ETF | 85.6 | 85.74999999999999 | 85.35 | 85.74999999999999 | 900.0 |
| 2005-10-14 | CBON | ETF | 31.48 | 31.48 | 30.76 | 30.78 | 6871.0 |
| 2005-10-14 | CDL | ETF | 13.92 | 13.92 | 13.53 | 13.86 | 1059000.0 |
| 2005-10-14 | CEF | ETF | 5.65 | 5.72 | 5.6 | 5.71 | 301400.0 |
| 2005-10-14 | CEW | ETF | 25.91 | 25.91 | 25.91 | 25.91 | 300.0 |
| 2005-10-14 | CHB | ETF | 12.84 | 12.85 | 12.61 | 12.77 | 625900.0 |
| 2005-10-14 | CHI | ETF | 18.6 | 18.96 | 18.57 | 18.94 | 118400.0 |
| 2005-10-14 | CHIC | ETF | 16.15 | 17.61 | 15.87 | 17.26 | 4001730.0 |
| 2005-10-14 | CHIR | ETF | 43.0701 | 43.7001 | 43.0599 | 43.35 | 1000755.0 |
| 2005-10-14 | CHY | ETF | 15.16 | 15.54 | 15.15 | 15.51 | 153900.0 |
| 2005-10-14 | CIL | ETF | 25.94 | 26.0 | 25.94 | 26.0 | 600.0 |
| 2005-10-14 | CIZ | ETF | 21.9 | 21.9 | 21.9 | 21.9 | 600.0 |
| 2005-10-14 | CN | ETF | 31.15 | 31.15 | 30.7 | 30.91 | 14200.0 |
| 2005-10-14 | CNXT | ETF | 1.77 | 1.83 | 1.7 | 1.82 | 13506337.0 |
| 2005-10-14 | COMB | ETF | 8.16 | 8.16 | 8.16 | 8.16 | 900.0 |
| 2005-10-14 | CPST | ETF | 2.725 | 2.75 | 2.28 | 2.35 | 10112793.0 |
| 2005-10-14 | CSB | ETF | 29.02 | 29.34 | 29.02 | 29.2 | 24600.0 |
| 2005-10-14 | CSQ | ETF | 13.18 | 13.63 | 13.18 | 13.62 | 228000.0 |
| 2005-10-14 | CTEC | ETF | 45.849999999999994 | 47.4 | 45.8 | 46.675000000000004 | 11218.400000000001 |
| 2005-10-14 | CURE | ETF | 0.1 | 0.1025 | 0.0925 | 0.0975 | 688424.0 |
| 2005-10-14 | CYB | ETF | 3.29 | 3.3899 | 3.29 | 3.3 | 2700.0 |
| 2005-10-14 | DGT | ETF | 63.08 | 63.43 | 63.08 | 63.43 | 1600.0 |
| 2005-10-14 | DIV | ETF | 11.9 | 12.15 | 11.87 | 11.94 | 24300.0 |
| 2005-10-14 | DRIV | ETF | 34.15 | 35.5 | 33.98 | 35.39 | 1137507.0 |
| 2005-10-14 | DUSA | ETF | 9.48 | 9.48 | 8.85 | 9.12 | 602641.0 |
| 2005-10-14 | DVY | ETF | 59.3 | 59.7 | 58.92 | 59.7 | 498000.0 |
| 2005-10-14 | EDEN | ETF | 0.66 | 0.74 | 0.66 | 0.73 | 32135.0 |
| 2005-10-14 | EDV | ETF | 25.5 | 25.59 | 25.46 | 25.58 | 8000.0 |
> showing 50 of 274 rows — these rows as CSV