PREVIEW / etf_daily / 2024-10-23
file: by_date/etf_daily/2024/2024-10-23.parquet size: 143 KB rows: 3,751
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-23 | SPY | ETF | 581.26 | 581.7086 | 574.415 | 577.99 | 49201880.0 |
| 2024-10-23 | QQQ | ETF | 493.59 | 494.25 | 485.05 | 488.36 | 39346565.0 |
| 2024-10-23 | IWM | ETF | 220.03 | 220.8 | 217.37 | 219.24 | 23278623.0 |
| 2024-10-23 | DIA | ETF | 427.03 | 427.7599 | 422.92 | 425.16 | 3999922.0 |
| 2024-10-23 | GLD | ETF | 253.08 | 253.18 | 250.2 | 250.87 | 8040391.0 |
| 2024-10-23 | TLT | ETF | 91.84 | 92.37 | 91.6601 | 92.07 | 33277513.0 |
| 2024-10-23 | AAA | ETF | 25.14 | 25.14 | 25.1001 | 25.115 | 9112.0 |
| 2024-10-23 | AAAU | ETF | 27.1 | 27.1061 | 26.785 | 26.865 | 2929753.0 |
| 2024-10-23 | AADR | ETF | 63.75 | 64.51 | 63.75 | 64.51 | 615.0 |
| 2024-10-23 | AAPB | ETF | 30.09 | 30.32 | 28.46 | 29.18 | 413655.0 |
| 2024-10-23 | AAPD | ETF | 16.37 | 16.83 | 16.3299 | 16.63 | 333516.0 |
| 2024-10-23 | AAPR | ETF | 26.215 | 26.25 | 26.15 | 26.2003 | 41233.0 |
| 2024-10-23 | AAPU | ETF | 38.1 | 38.4 | 35.99 | 36.95 | 1075185.0 |
| 2024-10-23 | AAPX | ETF | 33.95 | 33.98 | 32.83 | 33.6004 | 12111.0 |
| 2024-10-23 | AAPY | ETF | 27.29 | 27.29 | 27.28 | 27.28 | 863.0 |
| 2024-10-23 | AAXJ | ETF | 77.55 | 77.86 | 77.09 | 77.42 | 248528.0 |
| 2024-10-23 | ABCS | ETF | 28.31 | 28.3349 | 28.29 | 28.3349 | 1565.0 |
| 2024-10-23 | ABEQ | ETF | 32.92 | 33.074 | 32.92 | 33.074 | 14063.0 |
| 2024-10-23 | ABNY | ETF | 82.35 | 82.35 | 79.8695 | 79.8695 | 2063.0 |
| 2024-10-23 | ACES | ETF | 27.65 | 27.78 | 27.1601 | 27.39 | 22507.0 |
| 2024-10-23 | ACIO | ETF | 40.28 | 40.28 | 39.846 | 40.01 | 133311.0 |
| 2024-10-23 | ACSI | ETF | 58.1724 | 58.1724 | 58.1724 | 58.1724 | 225.0 |
| 2024-10-23 | ACT | ETF | 35.99 | 36.1 | 35.39 | 35.62 | 302313.0 |
| 2024-10-23 | ACTV | ETF | 33.5 | 33.5 | 33.25 | 33.3938 | 5545.0 |
| 2024-10-23 | ACTX | ETF | 0.0001 | 0.0001 | 0.0001 | 0.0001 | 417.0 |
| 2024-10-23 | ACVF | ETF | 44.24 | 44.24 | 43.8225 | 44.0152 | 10485.0 |
| 2024-10-23 | ACWI | ETF | 119.5 | 119.5 | 118.1 | 118.75 | 2729956.0 |
| 2024-10-23 | ACWV | ETF | 113.48 | 113.72 | 113.31 | 113.59 | 61443.0 |
| 2024-10-23 | ACWX | ETF | 55.24 | 55.3799 | 54.91 | 55.17 | 580200.0 |
| 2024-10-23 | ADFI | ETF | 8.55 | 8.6 | 8.52 | 8.55 | 11164.0 |
| 2024-10-23 | ADIV | ETF | 16.19 | 16.19 | 16.015 | 16.015 | 169.0 |
| 2024-10-23 | ADME | ETF | 46.72 | 46.72 | 46.25 | 46.47 | 15183.0 |
| 2024-10-23 | ADPV | ETF | 33.09 | 33.09 | 32.8 | 32.8572 | 1602.0 |
| 2024-10-23 | ADVE | ETF | 34.7453 | 34.7453 | 34.7453 | 34.7453 | 3.0 |
| 2024-10-23 | AESR | ETF | 17.23 | 17.23 | 16.99 | 17.09 | 16715.0 |
| 2024-10-23 | AETH | ETF | 33.01 | 33.07 | 31.769 | 32.1063 | 8597.0 |
| 2024-10-23 | AFIF | ETF | 9.17 | 9.17 | 9.15 | 9.155 | 6674.0 |
| 2024-10-23 | AFK | ETF | 16.99 | 17.0 | 16.592 | 16.6 | 18853.0 |
| 2024-10-23 | AFLG | ETF | 34.425 | 34.45 | 34.185 | 34.2511 | 4737.0 |
| 2024-10-23 | AFMC | ETF | 31.9557 | 31.9557 | 31.9557 | 31.9557 | 244.0 |
| 2024-10-23 | AFSM | ETF | 30.35 | 30.35 | 30.0899 | 30.3 | 3150.0 |
| 2024-10-23 | AGG | ETF | 98.57 | 98.76 | 98.4815 | 98.6 | 19659176.0 |
| 2024-10-23 | AGGH | ETF | 20.98 | 21.04 | 20.86 | 20.88 | 34964.0 |
| 2024-10-23 | AGGS | ETF | 41.38 | 41.3961 | 41.3787 | 41.3961 | 317.0 |
| 2024-10-23 | AGGY | ETF | 43.74 | 43.77 | 43.6701 | 43.73 | 68836.0 |
| 2024-10-23 | AGIH | ETF | 24.7059 | 24.7059 | 24.7059 | 24.7059 | 1.0 |
| 2024-10-23 | AGIX | ETF | 26.2 | 26.2 | 25.77 | 25.8044 | 1853.0 |
| 2024-10-23 | AGMI | ETF | 32.38 | 32.38 | 32.21 | 32.35 | 615.0 |
| 2024-10-23 | AGNG | ETF | 32.39 | 32.44 | 32.26 | 32.4361 | 5688.0 |
| 2024-10-23 | AGOX | ETF | 29.09 | 29.09 | 28.5501 | 28.67 | 12506.0 |
> showing 50 of 3,751 rows — these rows as CSV