PREVIEW / etf_daily / 2024-10-25
file: by_date/etf_daily/2024/2024-10-25.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-25 | SPY | ETF | 581.51 | 584.46 | 578.08 | 579.04 | 46948386.0 |
| 2024-10-25 | QQQ | ETF | 495.14 | 500.28 | 494.43 | 495.32 | 38762143.0 |
| 2024-10-25 | IWM | ETF | 221.31 | 221.97 | 218.52 | 218.89 | 23708441.0 |
| 2024-10-25 | DIA | ETF | 425.45 | 426.0 | 420.47 | 421.14 | 2406072.0 |
| 2024-10-25 | GLD | ETF | 252.0 | 253.5499 | 251.77 | 253.32 | 4288503.0 |
| 2024-10-25 | TLT | ETF | 92.99 | 93.0375 | 92.02 | 92.14 | 28587212.0 |
| 2024-10-25 | AAA | ETF | 25.15 | 25.1664 | 25.1161 | 25.15 | 3908.0 |
| 2024-10-25 | AAAU | ETF | 26.985 | 27.145 | 26.9501 | 27.125 | 2233092.0 |
| 2024-10-25 | AADR | ETF | 65.4173 | 65.4173 | 65.4173 | 65.4173 | 3.0 |
| 2024-10-25 | AAPB | ETF | 29.0 | 29.76 | 29.0 | 29.32 | 104455.0 |
| 2024-10-25 | AAPD | ETF | 16.69 | 16.69 | 16.4699 | 16.61 | 272389.0 |
| 2024-10-25 | AAPR | ETF | 26.26 | 26.26 | 26.21 | 26.2237 | 8786.0 |
| 2024-10-25 | AAPU | ETF | 36.57 | 37.7 | 36.57 | 37.13 | 421322.0 |
| 2024-10-25 | AAPX | ETF | 33.47 | 34.215 | 33.47 | 33.78 | 24530.0 |
| 2024-10-25 | AAPY | ETF | 27.6199 | 27.6199 | 27.4443 | 27.4443 | 689.0 |
| 2024-10-25 | AAXJ | ETF | 77.61 | 77.74 | 77.085 | 77.2 | 263119.0 |
| 2024-10-25 | ABCS | ETF | 28.6 | 28.67 | 28.3 | 28.31 | 1868.0 |
| 2024-10-25 | ABEQ | ETF | 33.06 | 33.06 | 32.7786 | 32.7786 | 4568.0 |
| 2024-10-25 | ABNY | ETF | 80.705 | 81.497 | 80.705 | 81.05 | 524.0 |
| 2024-10-25 | ACES | ETF | 27.8 | 28.09 | 27.73 | 27.92 | 68113.0 |
| 2024-10-25 | ACIO | ETF | 40.31 | 40.38 | 40.0699 | 40.11 | 97148.0 |
| 2024-10-25 | ACSI | ETF | 58.3356 | 58.3356 | 58.3356 | 58.3356 | 30.0 |
| 2024-10-25 | ACT | ETF | 35.57 | 35.57 | 34.62 | 34.65 | 564526.0 |
| 2024-10-25 | ACTV | ETF | 33.44 | 33.44 | 33.07 | 33.07 | 5740.0 |
| 2024-10-25 | ACVF | ETF | 44.3 | 44.3 | 44.0 | 44.0073 | 9940.0 |
| 2024-10-25 | ACWI | ETF | 119.52 | 119.93 | 118.75 | 118.82 | 3116004.0 |
| 2024-10-25 | ACWV | ETF | 113.89 | 113.92 | 112.865 | 112.93 | 52428.0 |
| 2024-10-25 | ACWX | ETF | 55.56 | 55.56 | 55.085 | 55.18 | 515874.0 |
| 2024-10-25 | ADFI | ETF | 8.5799 | 8.5799 | 8.5111 | 8.56 | 17937.0 |
| 2024-10-25 | ADIV | ETF | 16.03 | 16.03 | 15.985 | 15.985 | 114.0 |
| 2024-10-25 | ADME | ETF | 46.9228 | 46.9228 | 46.5352 | 46.5352 | 6810.0 |
| 2024-10-25 | ADPV | ETF | 33.4 | 33.445 | 33.1151 | 33.1151 | 1947.0 |
| 2024-10-25 | ADVE | ETF | 34.7772 | 34.7772 | 34.7772 | 34.7772 | 0.0 |
| 2024-10-25 | AESR | ETF | 17.3 | 17.3122 | 17.151 | 17.151 | 24670.0 |
| 2024-10-25 | AETH | ETF | 32.48 | 32.625 | 31.6377 | 31.6574 | 5630.0 |
| 2024-10-25 | AFIF | ETF | 9.13 | 9.16 | 9.13 | 9.155 | 37677.0 |
| 2024-10-25 | AFK | ETF | 17.02 | 17.04 | 16.802 | 16.85 | 7973.0 |
| 2024-10-25 | AFLG | ETF | 34.4499 | 34.48 | 34.14 | 34.14 | 3407.0 |
| 2024-10-25 | AFMC | ETF | 31.995 | 31.995 | 31.7725 | 31.7725 | 286.0 |
| 2024-10-25 | AFSM | ETF | 30.4337 | 30.54 | 30.121 | 30.121 | 2426.0 |
| 2024-10-25 | AGG | ETF | 98.97 | 98.99 | 98.54 | 98.59 | 9017711.0 |
| 2024-10-25 | AGGH | ETF | 20.85 | 21.03 | 20.81 | 20.81 | 57791.0 |
| 2024-10-25 | AGGS | ETF | 41.5 | 41.5 | 41.4 | 41.4 | 400.0 |
| 2024-10-25 | AGGY | ETF | 43.87 | 43.898 | 43.695 | 43.73 | 68775.0 |
| 2024-10-25 | AGIH | ETF | 24.6512 | 24.6512 | 24.6512 | 24.6512 | 5.0 |
| 2024-10-25 | AGIX | ETF | 26.6 | 26.61 | 26.41 | 26.41 | 3766.0 |
| 2024-10-25 | AGMI | ETF | 32.08 | 32.08 | 31.7391 | 31.7391 | 112.0 |
| 2024-10-25 | AGNG | ETF | 32.47 | 32.47 | 32.25 | 32.25 | 1341.0 |
| 2024-10-25 | AGOX | ETF | 28.99 | 29.29 | 28.66 | 28.66 | 13236.0 |
| 2024-10-25 | AGQ | ETF | 46.27 | 47.61 | 45.88 | 46.43 | 1422230.0 |
> showing 50 of 3,739 rows — these rows as CSV