PREVIEW / etf_daily / 2025-01-31
file: by_date/etf_daily/2025/2025-01-31.parquet size: 150 KB rows: 3,914
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-31 | SPY | ETF | 607.5 | 609.96 | 601.05 | 601.82 | 66094864.0 |
| 2025-01-31 | QQQ | ETF | 526.92 | 531.5178 | 521.19 | 522.29 | 38845467.0 |
| 2025-01-31 | IWM | ETF | 228.75 | 230.32 | 225.535 | 226.48 | 34817346.0 |
| 2025-01-31 | DIA | ETF | 450.03 | 450.36 | 445.04 | 445.39 | 2954762.0 |
| 2025-01-31 | GLD | ETF | 259.08 | 259.99 | 257.86 | 258.56 | 9145185.0 |
| 2025-01-31 | TLT | ETF | 88.38 | 88.66 | 87.43 | 87.76 | 48722794.0 |
| 2025-01-31 | AAA | ETF | 25.12 | 25.14 | 25.1 | 25.1 | 24357.0 |
| 2025-01-31 | AAAU | ETF | 27.81 | 27.845 | 27.625 | 27.69 | 2113778.0 |
| 2025-01-31 | AADR | ETF | 75.1967 | 75.1967 | 74.34 | 74.4033 | 1270.0 |
| 2025-01-31 | AAPB | ETF | 32.4 | 32.42 | 28.97 | 29.56 | 661853.0 |
| 2025-01-31 | AAPD | ETF | 15.43 | 16.345 | 15.42 | 16.19 | 2633485.0 |
| 2025-01-31 | AAPR | ETF | 26.68 | 26.68 | 26.56 | 26.6309 | 22930.0 |
| 2025-01-31 | AAPU | ETF | 36.0 | 36.02 | 32.21 | 32.86 | 3695632.0 |
| 2025-01-31 | AAPX | ETF | 30.87 | 30.87 | 27.555 | 28.18 | 220822.0 |
| 2025-01-31 | AAPY | ETF | 26.3025 | 26.3025 | 25.33 | 25.5328 | 12420.0 |
| 2025-01-31 | AAVM | ETF | 26.25 | 26.29 | 25.9 | 25.9668 | 3737.0 |
| 2025-01-31 | AAXJ | ETF | 73.4 | 73.58 | 72.53 | 72.66 | 2997318.0 |
| 2025-01-31 | ABCS | ETF | 29.95 | 30.05 | 29.67 | 29.67 | 2778.0 |
| 2025-01-31 | ABEQ | ETF | 32.7001 | 32.73 | 32.5339 | 32.5339 | 1865.0 |
| 2025-01-31 | ABFL | ETF | 70.035 | 70.09 | 69.28 | 69.4 | 13193.0 |
| 2025-01-31 | ABHY | ETF | 19.18 | 19.18 | 19.1397 | 19.1397 | 435.0 |
| 2025-01-31 | ABLD | ETF | 29.24 | 29.24 | 28.8967 | 28.8967 | 686.0 |
| 2025-01-31 | ABLG | ETF | 30.215 | 30.28 | 30.02 | 30.0216 | 6406.0 |
| 2025-01-31 | ABNY | ETF | 74.49 | 74.601 | 72.9005 | 73.319 | 1794.0 |
| 2025-01-31 | ABOT | ETF | 38.12 | 38.21 | 37.6674 | 37.6674 | 2019.0 |
| 2025-01-31 | ACES | ETF | 25.77 | 26.36 | 25.69 | 25.74 | 102198.0 |
| 2025-01-31 | ACGR | ETF | 58.3882 | 58.3882 | 58.3882 | 58.3882 | 48.0 |
| 2025-01-31 | ACIO | ETF | 41.22 | 41.36 | 40.92 | 40.97 | 169553.0 |
| 2025-01-31 | ACLC | ETF | 72.6 | 73.15 | 72.2227 | 72.2227 | 5257.0 |
| 2025-01-31 | ACSI | ETF | 63.609 | 63.609 | 63.609 | 63.609 | 77.0 |
| 2025-01-31 | ACT | ETF | 33.88 | 34.01 | 33.52 | 33.78 | 323051.0 |
| 2025-01-31 | ACTV | ETF | 32.9616 | 32.975 | 32.5906 | 32.6853 | 2561.0 |
| 2025-01-31 | ACVF | ETF | 45.13 | 45.43 | 44.8 | 44.84 | 8203.0 |
| 2025-01-31 | ACWI | ETF | 122.35 | 122.792 | 121.095 | 121.19 | 2870850.0 |
| 2025-01-31 | ACWV | ETF | 112.78 | 112.9454 | 112.05 | 112.11 | 182916.0 |
| 2025-01-31 | ACWX | ETF | 54.53 | 54.72 | 53.98 | 53.98 | 1429197.0 |
| 2025-01-31 | ADFI | ETF | 8.495 | 8.57 | 8.45 | 8.52 | 37183.0 |
| 2025-01-31 | ADIV | ETF | 15.7142 | 15.72 | 15.5386 | 15.5386 | 2580.0 |
| 2025-01-31 | ADME | ETF | 48.19 | 48.38 | 47.8115 | 47.8115 | 9414.0 |
| 2025-01-31 | ADPV | ETF | 39.2 | 39.32 | 38.7 | 39.08 | 37503.0 |
| 2025-01-31 | ADVE | ETF | 32.1136 | 32.1136 | 32.1136 | 32.1136 | 81.0 |
| 2025-01-31 | AESR | ETF | 18.14 | 18.16 | 17.89 | 17.89 | 6861.0 |
| 2025-01-31 | AETH | ETF | 32.7637 | 32.79 | 32.76 | 32.78 | 1507.0 |
| 2025-01-31 | AFIF | ETF | 9.22 | 9.23 | 9.19 | 9.22 | 42678.0 |
| 2025-01-31 | AFIX | ETF | 24.675 | 24.68 | 24.5957 | 24.5957 | 2565.0 |
| 2025-01-31 | AFK | ETF | 16.76 | 16.76 | 16.415 | 16.55 | 16654.0 |
| 2025-01-31 | AFLG | ETF | 35.77 | 35.87 | 35.4342 | 35.5 | 104089.0 |
| 2025-01-31 | AFMC | ETF | 33.19 | 33.3585 | 32.94 | 32.98 | 12725.0 |
| 2025-01-31 | AFSM | ETF | 31.2 | 31.24 | 30.81 | 30.87 | 7029.0 |
| 2025-01-31 | AGG | ETF | 97.62 | 97.73 | 97.26 | 97.4 | 10650395.0 |
> showing 50 of 3,914 rows — these rows as CSV