PREVIEW / etf_daily / 2024-10-15
file: by_date/etf_daily/2024/2024-10-15.parquet size: 143 KB rows: 3,739
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-15 | SPY | ETF | 584.59 | 584.9 | 578.545 | 579.78 | 54113231.0 |
| 2024-10-15 | QQQ | ETF | 497.83 | 498.5 | 488.68 | 490.85 | 34784506.0 |
| 2024-10-15 | IWM | ETF | 222.57 | 225.5 | 221.98 | 223.07 | 25881590.0 |
| 2024-10-15 | DIA | ETF | 429.33 | 430.13 | 427.03 | 427.54 | 3286400.0 |
| 2024-10-15 | GLD | ETF | 244.99 | 246.55 | 244.53 | 245.92 | 5629621.0 |
| 2024-10-15 | TLT | ETF | 94.46 | 95.0 | 94.3736 | 94.91 | 46393767.0 |
| 2024-10-15 | AAA | ETF | 25.035 | 25.1185 | 25.035 | 25.1 | 5675.0 |
| 2024-10-15 | AAAU | ETF | 26.22 | 26.3902 | 26.18 | 26.325 | 1964372.0 |
| 2024-10-15 | AADR | ETF | 65.0445 | 65.0445 | 65.0445 | 65.0445 | 90.0 |
| 2024-10-15 | AAPB | ETF | 30.0 | 30.969 | 29.68 | 30.07 | 169971.0 |
| 2024-10-15 | AAPD | ETF | 16.4 | 16.48 | 16.1287 | 16.4 | 496225.0 |
| 2024-10-15 | AAPR | ETF | 26.24 | 26.2655 | 26.185 | 26.2186 | 7636.0 |
| 2024-10-15 | AAPU | ETF | 38.01 | 39.26 | 37.5912 | 38.08 | 1271382.0 |
| 2024-10-15 | AAPX | ETF | 34.786 | 35.66 | 34.4402 | 34.5763 | 24878.0 |
| 2024-10-15 | AAPY | ETF | 28.0286 | 28.16 | 27.9261 | 27.9261 | 751.0 |
| 2024-10-15 | AAXJ | ETF | 78.27 | 78.3832 | 77.02 | 77.16 | 447137.0 |
| 2024-10-15 | ABCS | ETF | 28.63 | 28.6301 | 28.4899 | 28.4899 | 2558.0 |
| 2024-10-15 | ABEQ | ETF | 32.89 | 32.89 | 32.79 | 32.7934 | 2044.0 |
| 2024-10-15 | ABNY | ETF | 84.2495 | 84.5555 | 84.125 | 84.329 | 820.0 |
| 2024-10-15 | ACES | ETF | 28.59 | 28.655 | 28.25 | 28.35 | 279002.0 |
| 2024-10-15 | ACIO | ETF | 40.45 | 40.45 | 40.0601 | 40.16 | 166992.0 |
| 2024-10-15 | ACSI | ETF | 58.47 | 58.4934 | 58.44 | 58.44 | 1180.0 |
| 2024-10-15 | ACT | ETF | 36.23 | 36.8 | 36.1442 | 36.41 | 174914.0 |
| 2024-10-15 | ACTV | ETF | 33.99 | 34.4322 | 33.99 | 34.1134 | 5145.0 |
| 2024-10-15 | ACVF | ETF | 44.54 | 44.66 | 44.1 | 44.17 | 3284.0 |
| 2024-10-15 | ACWI | ETF | 120.58 | 120.68 | 119.26 | 119.52 | 901540.0 |
| 2024-10-15 | ACWV | ETF | 114.82 | 115.39 | 114.24 | 114.63 | 66468.0 |
| 2024-10-15 | ACWX | ETF | 56.6 | 56.6 | 55.68 | 55.75 | 512376.0 |
| 2024-10-15 | ADFI | ETF | 8.6503 | 8.68 | 8.6503 | 8.665 | 13290.0 |
| 2024-10-15 | ADIV | ETF | 15.9352 | 15.9412 | 15.9217 | 15.9412 | 768.0 |
| 2024-10-15 | ADME | ETF | 46.87 | 46.87 | 46.61 | 46.7 | 18291.0 |
| 2024-10-15 | ADPV | ETF | 33.04 | 33.2141 | 33.04 | 33.0746 | 728.0 |
| 2024-10-15 | ADVE | ETF | 35.23 | 35.23 | 35.1508 | 35.1508 | 301.0 |
| 2024-10-15 | AESR | ETF | 17.36 | 17.36 | 17.1 | 17.19 | 19943.0 |
| 2024-10-15 | AETH | ETF | 33.49 | 34.41 | 32.6182 | 33.262 | 10511.0 |
| 2024-10-15 | AFIF | ETF | 9.2 | 9.21 | 9.195 | 9.21 | 14566.0 |
| 2024-10-15 | AFK | ETF | 16.72 | 16.8 | 16.35 | 16.35 | 14457.0 |
| 2024-10-15 | AFLG | ETF | 34.7399 | 34.74 | 34.45 | 34.4568 | 5557.0 |
| 2024-10-15 | AFMC | ETF | 32.67 | 32.67 | 32.5459 | 32.5459 | 1929.0 |
| 2024-10-15 | AFSM | ETF | 31.1043 | 31.34 | 31.0886 | 31.0886 | 4256.0 |
| 2024-10-15 | AGG | ETF | 99.74 | 99.84 | 99.68 | 99.81 | 7148822.0 |
| 2024-10-15 | AGGH | ETF | 21.23 | 21.55 | 21.08 | 21.27 | 64514.0 |
| 2024-10-15 | AGGS | ETF | 41.85 | 41.8845 | 41.85 | 41.8845 | 100.0 |
| 2024-10-15 | AGGY | ETF | 44.18 | 44.2778 | 44.18 | 44.2549 | 65194.0 |
| 2024-10-15 | AGIH | ETF | 24.9758 | 24.9758 | 24.9758 | 24.9758 | 2.0 |
| 2024-10-15 | AGIX | ETF | 26.59 | 26.59 | 25.86 | 26.0659 | 3006.0 |
| 2024-10-15 | AGMI | ETF | 29.37 | 29.86 | 29.37 | 29.86 | 108.0 |
| 2024-10-15 | AGNG | ETF | 32.8 | 32.91 | 32.74 | 32.83 | 2264.0 |
| 2024-10-15 | AGOX | ETF | 29.59 | 29.59 | 29.13 | 29.25 | 22538.0 |
| 2024-10-15 | AGQ | ETF | 40.47 | 41.55 | 40.2101 | 41.03 | 1318880.0 |
> showing 50 of 3,739 rows — these rows as CSV