PREVIEW / etf_daily / 2025-03-27
file: by_date/etf_daily/2025/2025-03-27.parquet size: 152 KB rows: 4,028
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-03-27 | SPY | ETF | 567.18 | 570.9 | 564.94 | 567.08 | 42156764.0 |
| 2025-03-27 | QQQ | ETF | 482.41 | 486.5799 | 480.25 | 481.62 | 33469817.0 |
| 2025-03-27 | IWM | ETF | 205.33 | 206.35 | 203.76 | 204.61 | 23077230.0 |
| 2025-03-27 | DIA | ETF | 423.68 | 425.09 | 421.455 | 422.94 | 1623273.0 |
| 2025-03-27 | GLD | ETF | 280.55 | 282.065 | 279.5868 | 281.97 | 8297341.0 |
| 2025-03-27 | TLT | ETF | 88.85 | 89.025 | 88.63 | 88.91 | 23642916.0 |
| 2025-03-27 | AAA | ETF | 24.86 | 24.9247 | 24.82 | 24.85 | 28265.0 |
| 2025-03-27 | AAAU | ETF | 30.03 | 30.225 | 29.97 | 30.215 | 1350271.0 |
| 2025-03-27 | AADR | ETF | 77.2068 | 77.45 | 76.7681 | 76.7681 | 2448.0 |
| 2025-03-27 | AAPB | ETF | 25.51 | 26.305 | 25.41 | 26.07 | 49702.0 |
| 2025-03-27 | AAPD | ETF | 17.1 | 17.17 | 16.83 | 16.92 | 1576268.0 |
| 2025-03-27 | AAPR | ETF | 26.29 | 26.34 | 26.28 | 26.29 | 16210.0 |
| 2025-03-27 | AAPU | ETF | 27.97 | 28.88 | 27.8 | 28.61 | 520623.0 |
| 2025-03-27 | AAPW | ETF | 43.4415 | 44.1462 | 43.4415 | 44.1462 | 959.0 |
| 2025-03-27 | AAPX | ETF | 24.09 | 24.9 | 24.035 | 24.69 | 24793.0 |
| 2025-03-27 | AAPY | ETF | 23.4 | 23.77 | 23.39 | 23.6667 | 1878.0 |
| 2025-03-27 | AAVM | ETF | 24.74 | 24.9 | 24.74 | 24.815 | 3830.0 |
| 2025-03-27 | AAXJ | ETF | 75.4 | 75.95 | 75.375 | 75.7 | 252191.0 |
| 2025-03-27 | ABCS | ETF | 28.04 | 28.19 | 28.0399 | 28.0408 | 2406.0 |
| 2025-03-27 | ABEQ | ETF | 33.9848 | 34.013 | 33.92 | 34.013 | 4229.0 |
| 2025-03-27 | ABFL | ETF | 65.4779 | 65.4779 | 64.82 | 64.825 | 17180.0 |
| 2025-03-27 | ABHY | ETF | 19.1096 | 19.1096 | 19.1096 | 19.1096 | 24.0 |
| 2025-03-27 | ABLD | ETF | 28.78 | 28.78 | 28.61 | 28.6664 | 4639.0 |
| 2025-03-27 | ABLG | ETF | 28.96 | 29.0265 | 28.96 | 29.0265 | 3025.0 |
| 2025-03-27 | ABNY | ETF | 65.4 | 65.55 | 64.2 | 64.986 | 1577.0 |
| 2025-03-27 | ABOT | ETF | 34.13 | 34.95 | 33.37 | 34.7601 | 2163.0 |
| 2025-03-27 | ACES | ETF | 23.47 | 23.88 | 23.47 | 23.67 | 148785.0 |
| 2025-03-27 | ACGR | ETF | 52.2656 | 52.2656 | 52.2656 | 52.2656 | 59.0 |
| 2025-03-27 | ACIO | ETF | 39.09 | 39.3076 | 39.0 | 39.07 | 95261.0 |
| 2025-03-27 | ACLC | ETF | 66.3715 | 66.79 | 66.3715 | 66.61 | 5491.0 |
| 2025-03-27 | ACSI | ETF | 60.2683 | 60.2683 | 60.2683 | 60.2683 | 27.0 |
| 2025-03-27 | ACT | ETF | 34.77 | 35.17 | 34.39 | 35.03 | 164292.0 |
| 2025-03-27 | ACTV | ETF | 30.93 | 31.13 | 30.8801 | 30.96 | 29427.0 |
| 2025-03-27 | ACVF | ETF | 43.17 | 43.41 | 43.06 | 43.16 | 4019.0 |
| 2025-03-27 | ACWI | ETF | 118.19 | 118.9 | 117.82 | 118.28 | 1783307.0 |
| 2025-03-27 | ACWV | ETF | 115.8 | 116.52 | 115.79 | 116.365 | 301607.0 |
| 2025-03-27 | ACWX | ETF | 56.33 | 56.66 | 56.09 | 56.5 | 1623543.0 |
| 2025-03-27 | ADBG | ETF | 15.71 | 15.8395 | 15.462 | 15.462 | 1878.0 |
| 2025-03-27 | ADFI | ETF | 8.44 | 8.47 | 8.43 | 8.44 | 12032.0 |
| 2025-03-27 | ADIV | ETF | 15.87 | 15.91 | 15.8699 | 15.89 | 2094.0 |
| 2025-03-27 | ADME | ETF | 45.0888 | 45.274 | 44.99 | 45.057 | 7016.0 |
| 2025-03-27 | ADPV | ETF | 34.33 | 34.35 | 34.33 | 34.34 | 10826.0 |
| 2025-03-27 | ADVE | ETF | 32.9895 | 32.9895 | 32.9895 | 32.9895 | 14.0 |
| 2025-03-27 | AESR | ETF | 17.025 | 17.025 | 16.88 | 16.8923 | 15589.0 |
| 2025-03-27 | AETH | ETF | 29.95 | 30.102 | 29.95 | 30.0341 | 522.0 |
| 2025-03-27 | AFIF | ETF | 9.23 | 9.23 | 9.17 | 9.17 | 38092.0 |
| 2025-03-27 | AFIX | ETF | 24.77 | 24.77 | 24.765 | 24.765 | 17013.0 |
| 2025-03-27 | AFK | ETF | 17.48 | 17.6873 | 17.48 | 17.63 | 8105.0 |
| 2025-03-27 | AFLG | ETF | 34.02 | 34.13 | 33.86 | 33.91 | 36920.0 |
| 2025-03-27 | AFMC | ETF | 30.7994 | 30.989 | 30.6601 | 30.75 | 14111.0 |
> showing 50 of 4,028 rows — these rows as CSV