PREVIEW / etf_daily / 2025-01-24
file: by_date/etf_daily/2025/2025-01-24.parquet size: 148 KB rows: 3,905
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-24 | SPY | ETF | 609.81 | 610.78 | 606.8 | 607.97 | 34466732.0 |
| 2025-01-24 | QQQ | ETF | 533.02 | 533.79 | 528.15 | 529.63 | 19878251.0 |
| 2025-01-24 | IWM | ETF | 228.82 | 230.23 | 228.04 | 228.69 | 18964423.0 |
| 2025-01-24 | DIA | ETF | 444.8 | 445.48 | 443.34 | 444.12 | 1916719.0 |
| 2025-01-24 | GLD | ETF | 255.96 | 257.07 | 255.61 | 255.65 | 7205274.0 |
| 2025-01-24 | TLT | ETF | 86.72 | 87.28 | 86.6 | 87.22 | 20966129.0 |
| 2025-01-24 | AAA | ETF | 25.2 | 25.24 | 25.16 | 25.22 | 17137.0 |
| 2025-01-24 | AAAU | ETF | 27.5 | 27.54 | 27.381 | 27.4 | 1359121.0 |
| 2025-01-24 | AADR | ETF | 74.25 | 74.5092 | 74.25 | 74.5092 | 328.0 |
| 2025-01-24 | AAPB | ETF | 26.99 | 27.127 | 26.15 | 26.48 | 301217.0 |
| 2025-01-24 | AAPD | ETF | 17.01 | 17.26 | 16.96 | 17.17 | 646910.0 |
| 2025-01-24 | AAPR | ETF | 26.65 | 26.685 | 26.65 | 26.67 | 6801.0 |
| 2025-01-24 | AAPU | ETF | 30.0 | 30.2 | 29.09 | 29.46 | 2720992.0 |
| 2025-01-24 | AAPX | ETF | 25.7 | 25.84 | 25.0 | 25.24 | 89942.0 |
| 2025-01-24 | AAPY | ETF | 24.33 | 24.34 | 24.11 | 24.183 | 8357.0 |
| 2025-01-24 | AAXJ | ETF | 73.01 | 73.2 | 72.73 | 73.07 | 600789.0 |
| 2025-01-24 | ABCS | ETF | 29.74 | 29.74 | 29.7167 | 29.7167 | 2032.0 |
| 2025-01-24 | ABEQ | ETF | 32.48 | 32.62 | 32.48 | 32.5571 | 10906.0 |
| 2025-01-24 | ABFL | ETF | 69.05 | 69.05 | 68.73 | 68.8057 | 11974.0 |
| 2025-01-24 | ABHY | ETF | 19.13 | 19.1483 | 19.13 | 19.1483 | 489.0 |
| 2025-01-24 | ABLD | ETF | 29.346 | 29.346 | 29.307 | 29.307 | 1131.0 |
| 2025-01-24 | ABLG | ETF | 29.83 | 29.84 | 29.65 | 29.84 | 16221.0 |
| 2025-01-24 | ABNY | ETF | 72.5 | 72.7 | 70.65 | 70.65 | 3606.0 |
| 2025-01-24 | ABOT | ETF | 37.47 | 37.47 | 37.34 | 37.343 | 342.0 |
| 2025-01-24 | ACES | ETF | 26.0 | 26.31 | 25.9013 | 25.97 | 139965.0 |
| 2025-01-24 | ACGR | ETF | 59.9386 | 59.94 | 59.8011 | 59.8011 | 3345.0 |
| 2025-01-24 | ACIO | ETF | 41.44 | 41.489 | 41.26 | 41.36 | 131302.0 |
| 2025-01-24 | ACLC | ETF | 73.45 | 73.49 | 73.1677 | 73.2249 | 1946.0 |
| 2025-01-24 | ACSI | ETF | 62.7037 | 62.7037 | 62.7037 | 62.7037 | 20.0 |
| 2025-01-24 | ACT | ETF | 33.3 | 33.47 | 33.12 | 33.2 | 218264.0 |
| 2025-01-24 | ACTV | ETF | 32.92 | 33.26 | 32.92 | 33.1603 | 13017.0 |
| 2025-01-24 | ACVF | ETF | 45.87 | 45.92 | 45.62 | 45.7169 | 21580.0 |
| 2025-01-24 | ACWI | ETF | 122.3 | 122.48 | 121.865 | 122.06 | 1252988.0 |
| 2025-01-24 | ACWV | ETF | 110.49 | 110.8767 | 110.49 | 110.76 | 117378.0 |
| 2025-01-24 | ACWX | ETF | 54.07 | 54.275 | 54.03 | 54.12 | 891790.0 |
| 2025-01-24 | ADFI | ETF | 8.4 | 8.49 | 8.4 | 8.4493 | 22889.0 |
| 2025-01-24 | ADIV | ETF | 15.6633 | 15.6854 | 15.6633 | 15.6854 | 964.0 |
| 2025-01-24 | ADME | ETF | 48.565 | 48.565 | 48.2939 | 48.3764 | 10969.0 |
| 2025-01-24 | ADPV | ETF | 38.58 | 38.85 | 38.49 | 38.4963 | 16143.0 |
| 2025-01-24 | ADVE | ETF | 32.2668 | 32.2668 | 32.2668 | 32.2668 | 163.0 |
| 2025-01-24 | AESR | ETF | 18.19 | 18.1956 | 18.095 | 18.12 | 88867.0 |
| 2025-01-24 | AETH | ETF | 32.7 | 32.8 | 32.7 | 32.76 | 3827.0 |
| 2025-01-24 | AFIF | ETF | 9.19 | 9.19 | 9.1534 | 9.166 | 47617.0 |
| 2025-01-24 | AFIX | ETF | 24.5257 | 24.55 | 24.5257 | 24.5345 | 9014.0 |
| 2025-01-24 | AFK | ETF | 16.47 | 16.47 | 16.23 | 16.3 | 11498.0 |
| 2025-01-24 | AFLG | ETF | 36.04 | 36.04 | 35.8142 | 35.89 | 64351.0 |
| 2025-01-24 | AFMC | ETF | 33.1702 | 33.35 | 33.1702 | 33.26 | 18197.0 |
| 2025-01-24 | AFSM | ETF | 31.0645 | 31.13 | 30.97 | 31.07 | 2596.0 |
| 2025-01-24 | AGG | ETF | 96.87 | 97.1099 | 96.8 | 97.01 | 6487537.0 |
| 2025-01-24 | AGGH | ETF | 20.69 | 20.73 | 20.6085 | 20.73 | 64007.0 |
> showing 50 of 3,905 rows — these rows as CSV